[ic] Upload Excel File

interchange-users@interchange.redhat.com interchange-users@interchange.redhat.com
Thu Sep 13 14:24:00 2001


Quoting G?tz Verdieck (goetz.verdieck@com4office.de):
> According to Racke:
> > Götz Verdieck <goetz.verdieck@com4office.de> writes:
> >> 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 ?
> > 
> 
> 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.
> 

I am guessing that some inadvertent ASCII translation happened. 

-- 
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@redhat.com>

Fast, reliable, cheap.  Pick two and we'll talk.  -- unknown