How to Import Supplier Contacts from an Excel (CSV) File

7 years ago
Matthew Crooks
2 minutes
  1. Go to-> Season Button -> Office Tools -> Database Maintenance

 

  1. Select the ‘Import Data’ tab -> Then click on the “Import General” tab

 

  1. Enter in your Admin or Supervisor Password in the Password field
  2. Click on “Supplier Contacts” option
  3. This will load the “Supplier Contacts Import Wizard”
  4. Click on ‘Browse  File to Import’ and choose the location to which you want to import from. (Ensure that the file name ends in .csv)  Alternatively you can type in the file directory into the yellow text box shown in the image above
  5. You can select either of the two options:-
    1.  “Merge Data”– This will merge the new data on the spreadsheet with the already existing information in the system.
    2. “Initialize File”– This will remove all existing supplier contact data from the system and only add in the new contact information from the spreadsheet.
  6. Click on the ‘Click to Import’ button
  7. Click ‘Yes’ to import Supplier Contacts
  8. Once completed, a window will appear called “Data Import Wizard” as shown below 
  9. Now click on the “Stage 1: Check Data” option.
  10. Some “Information” windows will appear on the screen, just click on “Ok” when they do
  11. Now the window should look like the following 
  12. Now repeat the same steps for “Stage 2: Import Data”
  13. Both icons should now appear with ticks on them
  14. Now any changes to the Supplier Contacts on the system should be updated.