Unable to Import from CSV or TXT File
Posted: Fri Jul 15, 2011 4:41 am
I have been trying to import data to Abacre Retail POS. However , any configuration give error for validation on SQL.
The CSV only has the line below
50,hello,10.00,hello
The Columns checked are
Code, Name, Price , Note.
However , I get the error
I get the error
"Line 1 : SQL Error: validation error for column APPLYTAX,value "***null***" , Error code -625. The insert failed because a column definition includes validation constraints. The SQL: INSERT INTO Item (code,name,price,note) VALUES (?,?,?,?);;"
This is over and over , doesnt matter what columns I check and how the CSV File is .
I have Trial for 4.1 and am waiting on this to work to buy the final version.
This is Urgent. If any one has any clue , as My client goes online with this POS on Saturday and I have all their SKUs in the CSV, but cannot import them.
thanks
Hitesh Sharma
TechPrima
The CSV only has the line below
50,hello,10.00,hello
The Columns checked are
Code, Name, Price , Note.
However , I get the error
I get the error
"Line 1 : SQL Error: validation error for column APPLYTAX,value "***null***" , Error code -625. The insert failed because a column definition includes validation constraints. The SQL: INSERT INTO Item (code,name,price,note) VALUES (?,?,?,?);;"
This is over and over , doesnt matter what columns I check and how the CSV File is .
I have Trial for 4.1 and am waiting on this to work to buy the final version.
This is Urgent. If any one has any clue , as My client goes online with this POS on Saturday and I have all their SKUs in the CSV, but cannot import them.
thanks
Hitesh Sharma
TechPrima