[ic] 'Add' Items Via Upload

[Ian C. Melville]

Chaim:

That's one of the more straightforward uploads in IC 4.8.6 as I found
out recently :-) From the admin area go to the table manager and
download the products.txt file. This is usually a TAB-delimited file and
can be opened/edited in excel or access. The file may be empty or it may
have data already but what you're really after is the structure of the
file (column headings). Add your data (following the data already there
(or the column headings) and save the completed file as a TAB-delimited
file--removing any records that you don't need. Upload it using the
table manager. If you wish to keep existing records just append your new
records to the file starting at the first available row.

TIP: If you use excel to edit the file make sure you open the file in a
plain text editor (like notepad) before uploading it and remove any
extraneous quotation marks--excel has a way of putting these in the
saved file and you don't need them.

That should do it!

Cheers!

 

Ian C. Melville

FRONTLINE MARKETING AGENCIES
Trinidad & Tobago, West Indies


 


-----Original Message-----
From: interchange-users-admin@icdevgroup.org
[mailto:interchange-users-admin@icdevgroup.org] On Behalf Of Chaim Klar
Sent: Wednesday, October 30, 2002 9:02 PM
To: interchange-users@icdevgroup.org
Subject: [ic] 'Add' Items Via Upload



HI:

I would like to upload a whole file with products that should be 'ADDED'
to my existing database instead of entering each item individually.
Does any body know how to set that the products.txt should be added
instead of overwriting the whole existing database?

Thank You
Chaim Klar