Home > SI5 Documentation > User Guide > Product Data > MMPD > Importing Products > CSV Import

CSV Import

Importing via CSV Import

 

CSV stands for "Comma Separated Values" and these files open in Microsoft Excel.  The best method for importing a CSV file into SI5 is to use our CSV template which can be accessed via the "Click here to create a new empty import file" link:

File:Si5Wiki/SI5/05Product_Data/2MMPD/4Importing_Products/01CSV_Import/import_template_link.jpg

The “Save empty CSV file” from will open:

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image003.png

Select your save location, enter a file name and click [Save].  Excel will open the file you created.  This file will have column names that correspond to and are mapped to fields in your SI5 database.  Edit the form and Import the data into your SI5 database either via the CSV Import or EZ Match Import functions:

File:Si5Wiki/SI5/05Product_Data/2MMPD/4Importing_Products/csv_import_template.jpg

What data you enter in the spreadsheet depends on what you are trying to accomplish in SI5.  There are only three required fields: Category, Manufacturer, and Model.  However, more information is needed in order to create a Proposal and drawings.  See this post for suggestions of pertinent fields and this post for a specific example of importing data from QuickBooks.

If a red "X" appears next to any of the products during the import indicating a failure, there are really only two possible reasons:

1. The product did not have one of the three required fields: Category, Manufacturer, and Model

2. The product was open for edit on the Product Explorer tab during import

File:Si5Wiki/SI5/05Product_Data/2MMPD/4Importing_Products/01CSV_Import/import_errors.jpg

 

Example

  1. Open the MMPD interface, click the Import tab, and then click the [CSV Import] button.  The following screen will display:

 

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image007.jpg

  1. Select your “Field Delimiter” from the dropdown to match the format of your spreadsheet: Comma, Semi-colon, Tab, or Pipe. If you are using our template, leave this field set to Comma.
  2. [Browse…] to your file.  The Products in the spreadsheet will display in the grid.

 

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image008.jpg

  1. Click [Options…]. The Import Options form will open:

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image009.jpg

  1. Select the Options, Fields to Import, and Field Mappings (if you are using our template, there is no need to change anything in the Field Mappings section) then click [OK].

 

lightbulb_50If this is your initial import for the products in your spreadsheet, leave all the fields checked in the “Field Mappings” section.  However, if you are importing an update to your existing data, e.g. a price change, only select the fields in the spreadsheet that you actually modified.  This will prevent you from accidentally overwriting a field.  There are so many ways to edit data in SI 5, there is no way to guarantee that other fields haven’t been modified at some point so be very aware of what you are importing.

  1. Click [Import].  You will be prompted to backup your database:

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image011.png

When the import is complete you will be notified:

File:Managing_Data/Adding_Products_to_Your_Database/Importing_Products/image012.jpg

 

 

You must to post a comment.
Last modified
13:44, 26 Nov 2013

Tags

This page has no custom tags.

Classifications

This page has no classifications.