Show/Hide Toolbars

SpendMap User Guide (v15)

(MODULE) > Utility > Data Interfaces > (master file to be imported) > Import > Import Into …

Click to watch video tutorial on this topic
 
This utility is used to import master file data into SpendMap.

You can import over existing records if needed. If the code already exists in a Master File when you import, any fields that you import will be updated (but already populated fields that are not imported will remain as is).

 

Noteworthy Questions & Options

1.Select, modify or create an Import Configuration that matches the file you are going to import.  If no Import Configurations exist, you will be prompted to select the file to be imported, then you will be brought to the Import Configuration screen.

2.If your user ID has been set up to allow adding of master file codes on-the-fly, you will have the option to do so for any master file codes that are included in the records being imported.  For example, while importing Suppliers, you may include the Terms of Payment for each supplier, which can be added to the Terms of Payment Master File, at the same time the new suppliers are imported.

3.The Import Preview screen will be displayed so that you can verify how the data will be imported before the import takes place.

4.If your user ID has been set up to purge the applicable master file before the import, you will be prompted to do so.
 
STOP:  This feature is designed for a complete refresh. Once a table has been deleted, it cannot be restored.