[ic] Upload Excel File

Götz Verdieck interchange-users@interchange.redhat.com
Wed Sep 12 02:07:01 2001


> Götz Verdieck <goetz.verdieck@com4office.de> writes:
> 
>> Hi,
>> 
>> I tried to upload the construct.xls template
>> and get the following error message
>> 
>> DBD::mysql::db do failed: You have an error in your SQL syntax
>> near 'where sku = 'os28070'' at line 1 at
>> /Users/gv/interchange/lib/Vend/Table/DBI.pm line 1129,  line 21.
>> 
>> Progress to date:
>> 
>> table inventory: Using fields from file: 'sku quantity stock_message account
>> cogs_account'
>> 
>> 
>> 
>> Any idea or help would be appreciated.
> 
> Which Interchange version do you using ?
> 
> Ciao
>       Racke

I use 4.8.1 on a Powerbook G3 OS X 10.0.4

this error appears when I select:

Insert Product Data   YES
in the Admin Wizard menu.

But also when I tried to upload the products table in the Admin table
overview.
The *.xls was not opened or edited on the mac.
I used the original file from your site.


Best regards

Goetz

==============================
Goetz.Verdieck@com4office.de