Version: 3D or Pro, 4.0.4.8 or higher
Inventory data stored as an excel spreadsheet can be imported into ShowSim by simply renaming the column headerstomach the names displayed in the Inventory Browser screen (these names are shown in the table below). The column order does not matter, but the order of the header titles must match the order of the data. So you could have stock # be in any column that you want, but the data must also be in that same column. For example, you can not have the "stock #" keyword appear in column three of the header and then the actuall stock numbers be stored in column one of the data-- they must match or the import will not work right. It is not necessary to include every column that ShowSim supports, so you can leave out columns that you are not using. Missing columns will receive default values during the import as will missing data within any row. Blank rows will be ignored.
Note than when you use the Export button on the Inventory Browser with the format set to Excel (right click on the Export button to select the format), the resulting Excel file will already have the proper header names. Thus you could modify this file and export it back into ShowSim without changing anything.
Because ShowSim can not read in Excel files directly, you will need to convert your Excel file to .CSV format using the Save As option in Excel. When importing the resulting .CSV file back into ShowSim, use the “Generic CSV” option on the import format listing. Note that the semicolon ; must be used for the separation character rather than the usual comma when creating this .CSV file.
When showsim imports each invnetory item, it checks the stock number to see if an item having that same stock number already exists in the database within the inventory you are importing into. If an item is found to already exist with that same stock number within the same inventory group, the existing item is updated rather than creating a new item with a duplicate stock number. So if you have duplilcate stock numbers in the inventory that you are importing, the duplicates will overwrite each other and items will be missing that were in the original file.
Column Name Data Type Default Value
Stock # text blank
Size float 0.0
Description text blank
Prefire Time float 0.0
Dur. float 0.0
Mfg text blank
Class text blank
Type text blank
Magazine text blank
Lot Date date 1/1/2000
Lot Shift integer 1
Price float 0.0
Cost float 0.0
Reorder Limit integer 0
Active Wt. float 0.0
Total Wt. float 0.0
Setback float 0.0
Qty. integer 0
Custom 1 text blank
Custom 2 text blank
Custom 3 text blank
Custom 4 text blank
Custom 5 text blank
Custom 6 text blank
Custom 7 text blank
Custom 8 text blank
Custom 9 text blank
Custom 10 text blank
Sim ID text guid of effect assigned to this item (blank entries default to N.A. effect on import, or keep existing guid if refreshing an existing inventory)