[ic] uploading .xls file using cpanel not working

[TGroup]

> > Wondering if anyone has experienced the same trouble using this cpanel
> > option. After completing the Wizard, the final step is to upload your
> > template, in this case named template.xls- I receive no errors until
> trying to preview the cart, and then a fatal error page shows and states
that
the .xls file could not be uploaded.
> >
> > Is this a cpanel issue?
This is what I discovered regarding uploading .xls files to Interchange
under Cpanel.
1)  the template.xls==>"save as" products.xls"  (this will be your new
"template" for your products - I would recommend you make a backup of this
file, name it something like "productsBAK.xls".  If you somehow corrupt your
original, you can fall back on the Backup.
2)  You will notice that the template has several sheets.  Products,
Inventory, etc.
3)  You will need to covert the .xls file to a tab delimited .txt file
before uploading it to Interchange.
4)  File => Save As = > products.txt [note:  Excel will warn you that the
.xls worksheet you are using has several sheets, and it can't save all the
sheets, and will only save the "products" sheet.  That's okay.  Ignore all
the warnings about saving in that format might make the file incompatible
for certain uses, etc.  Whatever Excel "says",  just keep saving until you
are left with the file "products.txt"
5)  I don't know what you are doing with your catalog, but you will need to
reopen the "products.xls" table, and click on the "Inventory" sheet, and do
the same thing with that sheet:  "Save as" Inventory.txt.  You will need to
upload that text file as well.
6)  Two ways to upload your products.txt file to Interchange:
    A)  Sign in to your  Interchange Admin Control.  At the first page after
signing in, you will see the "tables" link near the bottom of the page.
Click on it to open the Table Manager.  Look for the "products" row.  The
icons to the left of the word products are your controls.  Put your mouse
over them to see what they do.  You will want to click on the "import
products" icon (second from the left).  When you click that icon, the Table
Import form will be presented at the next page.  Locate your "products.txt"
file on your hard drive, and click the import button. (I just leave
everything else there set to its default).  The file should then be
imported, and you will hopefully get a "success" message afterwards. Click
on the "apply changes" link.

    B)  The second way to get the products.txt file into Interchange:  FTP
to your site.  Before you enter the public_html area, you will see a folder
called "Catalog".  Open that folder. You will see a folder with the name of
your catalog (same as site username).  Open that folder.  You will see a
folder called "Products".  Open that folder.  Look at the files in there.
You will see "products.txt" among them.  You will also see "Inventory.txt".
Transfer (in ASCII Mode) your products.txt file to that location.  You can
also transfer the "Inventory.txt" file there as well.
7)  You can close your FTP program.  Click on the "apply changes" link in
your Admin Control Panel (I'm not sure if this is necessary.  I just do it
to be safe).

That's it.  You should be set.  Good luck.
Harry Governick
Artistic Director
TheatrGROUP, Inc.
http://www.theatrgroup.com