You can export, edit, then import a CSV file from within a Project.Exporting Project Items to a CSV file can be useful for importing into third-party software. You may also feel more comfortable editing Items from a Project in a CSV file, then importing the CSV file back into the Project to update the Items.
Within the Project Editor, click the Tools tab and you will see the Export/Import options in the ribbon:
When exporting you will choose to export just whatever Items you have selected, or you can export all Items:
This will open the Export Items to CSV File interface:
Here you can choose what field you wish to export. If you choose to include calculated fields in your export, just know that these fields cannot be re-imported, e.g. Installation Price.
Once you have edited the items in the CSV file, you can re-import the file and update Items within the Project. This is pretty straightforward since all fields from the CSV are already mapped to the fields within the Project since the file was originally exported from the Project.
In addition to exporting and re-importing CSV files, you could also choose to import a CSV file to a Project to add new Products to a Project, e.g. you want to import a list of Products into an SI Project from some other source. An example of this is shown below.
To import a CSV file to a Project, open the Project Editor and click the [Import and Update] button in the CSV section of the ribbon:
You will be prompted to browse for your CSV file. Once a CSV file has been selected, the Map CSV File interface will open. Depending on your spreadsheet, you may not see all of the steps shown below.
You will need to map the columns in your CSV file to Database Fields in the SI Catalog. Some fields will be pre-mapped if they are an exact match or if they are a close match. There are two required columns that must be mapped: Manufacturer and Model.
If your CSV file has dimensions or weight columns, you can choose the measurement.
Click the "Map" link next to any field you wish to map or re-map and the following form will open. Select you field (or the [None] button at the bottom if you wish to unmap a field) and then click [OK].
Once your fields are mapped, click [Next>].
On this step, if there are Manufacturer names in your spreadsheet that are not already a part of your SI Catalog, you can choose to allow the Manufacturer to be created or you can map to an existing manufacturer, e.g. different spelling in your Catalog.
Click the "Map" link next to each name that you wish to map to an existing Manufacturer and the following form will open. Make your selection and then click [OK].
On this step, if there are Category names in your spreadsheet that are not already a part of your SI Catalog, you can choose to allow the Category to be created or you can map to an existing Category, e.g. different spelling in your Catalog.
Click the "Map" link next to each name that you wish to map to an existing Category and the following form will open. Make your selection and then click [OK].
This step is primarily a summary of what you have done on the previous steps. Here you can also choose whether to use the Part Number or Accounting Item Name fields, if they exist in your CSV file, to match to SI Catalog Items. These options are useful if you do not have a Model field mapped in your CSV file.