Import | TSM Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

===== Import =====

[{{   :8000tsm7:8760import:import.png?200|The Import Utility Screen}}]

The Import utility allows [[:8000tsm7:8200products:8200products|Product]] and [[:8000tsm7:8150customers:8150customers|Customer]] data to be quickly entered into TSM from an existing database. The fields format required for import are defined in the following spreadsheets: 

{{:8000tsm7:8760import:product.csv|Product Import Template}} 

{{:8000tsm7:8760import:customer.csv|Customer Import Template}}

Note that only the fields you wish to import have to be included in the import file.

After selecting whether to import products or customers, and choosing file to import from, you can select how the import handles records which already exist in TSM (ignore duplicated, update the existing record and import new, or only update existing records). Existing records are matched on Product Number in the products database, and Customer Code in the customer database.