Table Import
The Table Import page allows you to upload a file from your computer
to Interchange in order to update one of Interchange's internal tables. This
can be done in one of several formats -- TAB-delimited text, Gnumeric simple text,
or Excel XLS workbook.
You can import slices of a table -- the only column that is required is
the key column (for example, sku is usually the key column for
products and inventory).
For instance, to update only the quantity
for a series of items in inventory, create a file with two columns, the
sku and quantity. Not all items must be updated, so you can
just upload the ones to be added or changed.
If you wish rows to be added when a new key is found, keep the default selection
Add new items if present. To only update existing rows, change
that to Ignore new items.
To upload changes to a single table in TAB-delimited format,
select a TAB-delimited file to send to Interchange by clicking Browse...,
and a table to update from the list on the right. Then select whether to
add new rows from your file to the table, or to only update rows that are in
both your file and the table.
To upload changes to multiple tables in Gnumeric simple-text format,
select it and use Browse..., then select your upload options.
The table selection is not important because the table is selected from
with the Gnumeric simple-text file.
Uploading in Excel/XLS format requires that the module Spreadsheet::ParseExcel
be installed on your server. Check with your admin if you need this and
the option is not present in the file format chooser. Otherwise, you simply
select the .xls file with Browse... and upload as with
Gnumeric simple-text format.
Interchange -
© 2000 Akopia, Inc.
(GPL)
|