Page 1 of 1

Unable to Import from CSV or TXT File

Posted: Fri Jul 15, 2011 4:41 am
by hmadra
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

Re: Unable to Import from CSV or TXT File

Posted: Fri Jul 15, 2011 11:22 am
by Abacre
This is a known issue since version 4.0. We will try to correct it ASAP.

Re: Unable to Import from CSV or TXT File

Posted: Fri Jul 15, 2011 1:18 pm
by hmadra
Roman

Is is possible to get the previous version of Art POS like 3.6.
Can I import into 3.6 and then upgrade to 4.1 .

thanks

Hitesh Sharma

Re: Unable to Import from CSV or TXT File

Posted: Fri Jul 15, 2011 7:47 pm
by Abacre
Exactly. That's what we propose to our customers right now.
We will send you detailed instructions by email.

Re: Unable to Import from CSV or TXT File

Posted: Fri Jul 15, 2011 8:42 pm
by hmadra
I am eagerly waiting for the instructions.
Thanks for the help

Hitesh