Home > SI 2018 Documentation > User Guide > People > Vendors > Adding Vendors > Import Vendor(s) from CSV

Import Vendor(s) from CSV

Table of contents

SI 2018 Page.png

Details

 

You can import a .csv file of your Vendors if you wish. The file you use should contain header rows and you will map your columns in the spreadsheet to fields with SI 2018. If you would like a template .csv file in which to paste your data, you can enter one Vendor manually in SI 2018 and then click the [CSV] button in the Export section of the ribbon in the Vendor Explorer:

 

export.png

 

You can then delete the record from the spreadsheet and use this template for your import since all columns will automatically mapped.

Steps

 

  1. In the Vendor Explorer, click the [CSV] button in the Import section of the ribbon.

 

csv.png

 

  1. You will be prompted to browse to your .csv file:

 

browse.png

 

  1. Once you've selected your file the Map CSV File form will open:

 

map csv.png

 

You will need to map the columns in your CSV file to Vendor Fields in the SI 2018. Some fields will be pre-mapped if they are an exact match or if they are a close match. When you click the Map button next to an item you will then be able to select the appropriate field or you can unmap any field by clicking the [None] button on the form:

 

map columns.png

 

  1. The Import Vendors from CSV form will open:

 

import form.png

 

Select the Clients you wish to import then click the [Import and Close] or [Import] button:

 

select.png

 

import buttons.png

 

Last modified

Tags

This page has no custom tags.

Classifications

This page has no classifications.