03333 445950
Home
Up
CSV Restrictions
Validation
Excel

                                

 

Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Import Problems

There are lots of potential problems when importing, you need to approach the de-bugging of your import in a systematic way.

As you find an error, check all the rest of the records for the same error.  If you are using a spreadsheet to prepare your data simply go to the row with the same line number as reported in the import procedure, and then go across the the appropriate column for the field error and see what is different.

Work methodically, one error at a time until you find them all and the import works.

Please make use of our online support desk and forums if you have problems.

Common problems:

Blank lines at the end of the file

References to supplier/customer or nominal accounts that do not exist or have not been imported first

Illegal characters in account references

Dates invalid because excel has converted them, if you open a csv file excel automatically converts dates and zero filled numbers. To avoid this rename the file to have a different file extension, when you open it the excel import will allow you to set the columns as being text rather than general and so stop it from converting.

System hangs - normally caused because the file you are importing is still open, make sure you close the file in excel.

If you have something else let us know!

Excel issues

 


Home Main site Contact Terms

Accounting, Pay as you go Sage 50 Support, Sage 50 Links to applications, 3rd Party integration and more!

This Sage 50 import website is copyright © Making I.T. Happen 2017