[ic] RE: Parse error on Excel upload "File not found"

[interchange-users@interchange.redhat.com]

-----Original Message-----
From: Gavin Harper [mailto:gavin@steelblue.co.uk]
Sent: Thursday, October 11, 2001 6:51 AM
To: interchange-users@interchange.redhat.com
>>Subject: [ic] RE: Parse error on Excel upload "File not found"

>>I am also experiencing this problem.
>>Using IC 4.8.2 and only get the problem when using the upload XLS file
from
>>the wizard section. This only occurs if you choose Yes from the "Insert
>>Products Data" drop down on the next screen.
>>Please can anyone help with this asap as I need to put this live in a few
>>days time!!

>>Thanks

>>Gavin

>Message: 29
>From: patrick.bennett@ccgenesis.com
>To: interchange-users@interchange.redhat.com
>Date: Fri, 5 Oct 2001 16:23:28 -0600
>Subject: [ic] Parse error on Excel upload "File not found"
>Reply-To: interchange-users@interchange.redhat.com

>When I try to upload my excel spreadsheet of
>products using the Wizard, I get this error:

>FATAL error

>Failed to parse XLS file
>upload/Q:\AWT\products.xls: No such file or directory


For a temporary workaround for this problem, you can edit the file:

<INTERCHANGE_HOME>/lib/UI/pages/admin/wizard/do_save.html

Just above the call to [import-fields] (inside the enclosing if
statement) put this code in:

[seti good][perl]
  $Values->{products} =~ s:.*/::;
  $Values->{products} =~ s:.*\\::;
[/perl][/seti]

This will strip the file name down to just the file with extension,
which will allow the import to get the right file name.  What
happens during the wizard is that the file is uploaded to
<CATALOG_ROOT>/uploads.  The "uploads/" is supposed to be appended
to the file name, but the code to strip out the source machine's
path doesn't seem to be working.  The code above will deal with
that problem.

Patrick


--__--__--


_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users