Forum Message

Importing CSV files

I have succesfully imported all my customers and suppliers.

I am now trying to import invoices. I get the following error message for each row of infomation.

[ERROR] Row 2: Missing field 'VAT Treatment ID'

I have got a column headed VAT Treatment ID> I have inserted the number 1 into each row. I have formatted the cells as a number and integer but with no success.

Any thoughts.

[


Posted by Robert Garbutt on Nov 7, 2009 8:06 PM GMT

Hi Robert,

Can you please email us your CSV file? We can then investigate the problem further...

Cheers,


Posted by Mark McLaren (Solar Accounts) on Nov 8, 2009 11:04 AM GMT

Did you find out what was wrong as I have exactly the same problem


Posted by Michael Bull on Nov 25, 2009 3:20 PM GMT

Yes - the import process is case-sensitive, so you will need to ensure ensure the field is spelt "VAT Treatment ID" (not "Vat Treatment ID")


Posted by Mark McLaren (Solar Accounts) on Nov 25, 2009 3:24 PM GMT

Thanks, that's fixed it!


Posted by Michael Bull on Nov 25, 2009 3:28 PM GMT

Hi Michael,

Glad to hear that. We'll fix this problem in the next release by making the field header case-insensitive.

Cheers,


Posted by Mark McLaren (Solar Accounts) on Nov 25, 2009 3:38 PM GMT

I get the error messages invalid name, is the name field case sensitive?


Posted by Danny Addy on Sep 10, 2012 4:58 PM BST

Hi Danny,

No, the name field is not case-sensitive when importing invoice data.

When you import invoices the customer must already exist in the system. In your case it sounds like you are trying to import invoices whether there is not already a customer with the same name as on the invoice.

Regards,


Posted by Mark McLaren (Solar Accounts) on Sep 10, 2012 5:34 PM BST