Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 09-10-2002 20:21:59

carole
Member
Registered: 08-15-2002
Posts: 6

product upload

How do I upload more then one product at a time?.....
please explain in detail..

Offline

 

#2 09-11-2002 08:11:20

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: product upload

Download the file:

./data/site/catalog.db

To your computer via FTP and open in Microsoft Excel as a pipe delimited text file.  Make the updates you need to based on existing rows in the database, then save as a pipe delimited file.  Re-upload to your server.


Nick Hendler

Offline

 

#3 09-11-2002 18:03:39

Guest
Guest

Re: product upload

How do I open it excel as a pipe delimited file?

 

#4 09-12-2002 06:37:39

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: product upload

When you select the file to open it, Excel will run you through a conversion routine.  Choose to use a delimiter - the pipe | - for your data.


Nick Hendler

Offline

 

#5 09-12-2002 14:00:26

Guest
Guest

Re: product upload

Is there an abbreviation for  pipe delimiter in excel .....When I put the file in excel it opens up as a spread I'm not sure how to convert it.....

 

#6 09-13-2002 06:39:22

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: product upload

Not sure what you mean.  If you've got an old version of Excel you may need to export as tab delimited then open in Word and replace the tabs (^t) with pipes (|).


Nick Hendler

Offline

 

#7 09-16-2002 00:00:18

Guest
Guest

Re: product upload

This is how excel opened it:  1|1::2|Infant

Tee|43201|3.50|0.00|0.00|0.00|0.05|N|N|0|N|0|:1neutral|43201.jpg|43201t.jpg|

Y||100% cotton (Dark Heather is 90/10) jersey. Shoulder-to-shoulder

taping, rib crew neck, and double-needle hem sleeve and bottom.

 

#8 09-16-2002 10:22:03

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: product upload

No, you need to use excel's import utility and select | as your delimiter.  It defaults to tab.


Nick Hendler

Offline

 

Board footer