Items filtered by date: December 2014

Default Sage Line 50 data locations

• Windows Vista and Windows 7 –  C:\Program Data\Sage\Accounts\2008
• Windows XP - C:\Documents and Settings\All Users\Application Data\Sage\Accounts\2008\

Backup Location

• c:\shared Folder\accounts
• \\server\accounts

Sage 50 Accounts 2013 Client Manager - Compliation of sage line 50 2008 - 2013 accounts packages for accountants, this is not line 50

Upgrade

Upgrade notes 1

• when autorun, system checker runs and starts an installer
• when you click install pre message below appears
  
  preparing your previous version for upgrade
   
• it will upgrade ADM
• it will now install Sage accounts 2013 (or latest version) and possibly remove a old versions, ie it will remove 2008 from ADM but not the PC so those companies still on 2008 can still be accessed directely through sage accounts 2008 but not ADM
• it will not mess with the data or its locations
• mandatory updates are forced for 2013 at this point

• check path for correct path, should be ok
  ie. c:\program files\sage\ADM\2013
• updates completed successfully click close
• enter new serial + activation key
• a completeion message will appearsaying ADM installed successfully
• accounts 2013 installed successfully

Upgrade notes 2

• basically stick the disk in every pc
• click install
• install wizard starts
• click yes to agree
• check path
• next
• select program folder
• next
• start copying files
• next

Image appears 'now -- preparing previous install for upgrade'

• version selection, select which version to install
• check path
• next
• installing starts

sage software updates part

• click install
• sage software update path check
• check path
• click yes
• program successfully updates, click ok
• wait
• the following updates were installed, sage 50 accounts 2013 - update 1
• click close

Sage ADM Activation

• enter serial and activation code
• click next
• a message now prompts to install this update on each station of a multiuser system
• also a warning:
  any companies created in versions lower than 2009 (version 15) or in non-client manager variants of accounts will not be detected
• click finish

In todays world you cannot just pick a word you use in your everyday life for your password. Read the notes below for guidlines on how to choose a password and how to look after it.

Protect your password:

• Memorize your password, do not write it down
• Do not share your password
• Do not use the same password you use on other services (gmail, Yahoo, etc)
• Avoid using one password for all your logins
• Avoid logging in from public computers
• Change your password frequently
• Be wary of allowing your password to be remembered by browser plugins or other utilities

Tips for choosing a password:

• Avoid dictionary words
• Use a combination of letters, numbers, and special characters
• Use a combination of capital and lower case letters
• If you use a word, try to combine multiple words, or use "made up" words
• Avoid familiar items (names, phone number, etc)
• Avoid common passwords and generic sequences (ie. "password", "admin", "123456", etc.)
• The more characters you use, the safer (use at least 8)

ckeditor straight from the original designers, which now have done this joomla plugin still messes with your html and code preventing geshi.

There is an easy solution to protect any code within specified tags.

• In the components menu
• goto the advanced tab
• paste the following code in to the Custom Javascript configuration
  

  CKEDITOR.config.protectedSource.push( /{code[\s\S]*?}[\s\S]*?{\/code}/g );
  CKEDITOR.config.protectedSource.push( /{geshibot[\s\S]*?}[\s\S]*?{\/geshibot}/g );

• As you can see there is 2 lines, one is to protect everything within {co de}{/co de}and {geshi bot}{/geshi bot} tags (without the spaces). you can also make you own.
• I have left Html entities enabled as they do not affect code inside protected storage

when you go to login to the joomla admin section you only get a blank or white screen

• try internet explorer
• enable javascript in firefox (this is usual culprit)
   

• interleaving = packet manipulation
• quite line test = 17070
• 'Copperline Test' can only be done form the line rental supplier and can provide a more extensive line test
• BT can guess if router/filter straight into master socket by checking impedance of the line. not 100% reliable
• when you are plugged in to the master socket and you ring BT they will do an automatic profile reset.
• according to the BT woman, BT can detect wheather you are plugged in to the test socket

** this csv export procedure might not maintain cariage returns and will need adjustment if so. CKeditor QuickFaq article is a good example **

This is a worked example of exporting data from a QuickFaq via csv, data manipulation in libre office and then importing the articles into K2. The articles contain full html and must not be modified or escaped. This custom routine will work for migrating all sorts of data to and from a MySQL database with html, or not, without loosing any data

Exporting Data out of QuickFaq

• export with phpmyadmin with the following settings:

export type CSV
fields terminated by    ,
fileds enclosed by    ¬¬¬replaceme¬¬¬
fields escaped by
lines terminated by
replace NULL by

Remove CRLF characters within fields - not ticked
Put fields names in the first row - ticked

NEW Terms in PHPMyadmin - still checking (29-05-14)

export type CSV
Columns separated with:    ,
Columns enclosed with:    ¬¬¬replaceme¬¬¬
Columns escaped with:
Lines terminated with:
Replace NULL with:

Remove CRLF characters within fields - not ticked
Put fields names in the first row - ticked

• use notepad++ and replace all " with ""
• use notepad++ and replace all ¬¬¬replaceme¬¬¬ with "
• should now be importable as a cvs into libre office

Import CSV in to libre office

The csv export should now be imported into libre office with the following settings. The purpose of this step is so that the exported data can be matched up to the data structure of the K2 articles and categories

• character set    Unicode (UTF-8), this assumes thats what your charater set is using. (the other optin is possibly Western Europe (ISO-8859-15/EURO) if you are using Latin). There should be no Bomb Characters, this shows there is a character that cannot be handled. I think unicode is probably a complete implementation of Unicode.
• Language - Default (UK) - should not make any difference
• from row 1
• separated by    ,  (comma)
• Text delimiter   "
• leave everything else

Notes

• K2 import/export module makes all " go to ""   , this seems to be the key for a successful import.
• when you then import this using open office after doubling up the ", the import process removes a " out of each pair making it the syntax appear correct once the spreadsheet opens.

Importing Data into K2

i used navicat as phpmyadmin had some issues with not setting an escaped character.

• open navicat and then select the K2 items table
• run the import wizard in navicat
• Select the appropriate csv file (ie QuickFaq Data - Ready for import into K2.csv)
• leave encoding as 65001 (UTF-8)
• next
• select comma (,) for the Field delimeter, leave Record separator as CRLF (doesnt seem to make any difference), Text Qualifier as "
• next
• change first data row to 2
• change the date settings (might be different for different csv but we will use QuickFaq to K2)

Date order    YMD
Date delimiter    -
Time delimeter    :
DateTime Order    Date Time (should be unchanged)
Decimal symbol    . (should be unchanged)

• next
• all fields should match up here
• next
• select Copy delete all records in destination, repopulate from the source
• next
• click start
• there should be no errors for a successful import 

Additional notes, these might not be required but when these instructions are used again can be pruned or merged.

on the working csv there only seems to be 1 LF at the end whereas the one that does not work has CRLF

\n = linefeed
\r = carriage return

solution is to use the pipe symbol the vertical line, seperating thing does not like multiple symbols

use CSV for export

Fields terminated by   |
Fields enclosed by     "
Fields escaped by    nothing here
Lines terminated by  nothing here
Replace NULL by NULL (possibly leave this blank)

Remove CRLF characters within fields - unticked
Put fields names in the first row   -   ticked

so unexplained is most likely due to a field seperator present in the html code such as ,";  so use one that is not present and is most likely the pipe symbol. a quick text scan will show it up.

to find the fault, find a break in the file when loaded in office/spreadsheet and then scan for that text in the csv file using notepad++ and this will reveal all.

¦ does not seem to work but give it a go

¬¬¬replaceme¬¬¬

You can test a spam scanner / filter by adding the following code to the body of your email

{code class='brush: text;'}XJS*C4JDBQADN1.NSBN3*2IDNEN*GTUBE-STANDARD-ANTI-UBE-TEST-EMAIL*C.34X{/code}

• If your anti-spam detects it and marks it as spam then it's working.
• This is a generic spam test string.
• If it does not get filtered by your email client, it might be that you email client is ignoring the spam headers in the email or it is not sufficiently high enough.

when you try and install a HP printer which is located on a windows XP PC via network share on a windows vista or windows 7 computer you will run in to configuration issue. Only the following method will allow this configuration to work.

Don't use hp setup utility

• install HP Universal Printer Driver - PCL6 is prefered
• then manually setup printer via port name and select printer appropriate driver
• delete unneeded ports as they can cause errors.

Sometimes whatever you do, windows updates fail.

The solution is to not install all updates at once. It seems if some updates are installed before others it causes a failure which in turn causes windows to revert all changes. The usual culprit is the .NET framework stuff and sometimes drivers

These are issues i have come across when upgrading prestashop either using the autoupgrader or upgrading manually.

upgrade will not work says fopen url is not activated etc...
--
add php.ini with allow_url_fopen = On in the admin/autoupgrade folder

Here is a useful link to some other issues and solutions regarding upgrading.

Upgrading to 1.4.5.1 - Frequently Asked Question