Unable to Import from CSV or TXT File

General discussions about Abacre Retail Point of Sale
Post Reply
hmadra
Posts: 3
Joined: Fri Jul 15, 2011 4:37 am

Unable to Import from CSV or TXT File

Post by hmadra » 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

Abacre
Site Admin
Posts: 1201
Joined: Mon Jan 31, 2005 5:32 pm
Contact:

Re: Unable to Import from CSV or TXT File

Post by Abacre » Fri Jul 15, 2011 11:22 am

This is a known issue since version 4.0. We will try to correct it ASAP.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

hmadra
Posts: 3
Joined: Fri Jul 15, 2011 4:37 am

Re: Unable to Import from CSV or TXT File

Post by hmadra » Fri Jul 15, 2011 1:18 pm

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

Abacre
Site Admin
Posts: 1201
Joined: Mon Jan 31, 2005 5:32 pm
Contact:

Re: Unable to Import from CSV or TXT File

Post by Abacre » Fri Jul 15, 2011 7:47 pm

Exactly. That's what we propose to our customers right now.
We will send you detailed instructions by email.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

hmadra
Posts: 3
Joined: Fri Jul 15, 2011 4:37 am

Re: Unable to Import from CSV or TXT File

Post by hmadra » Fri Jul 15, 2011 8:42 pm

I am eagerly waiting for the instructions.
Thanks for the help

Hitesh

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest