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.