The standalone application Excel Importer (SystemWeaver.ExcelImport.exe) performs rudimentary imports of one structure level in depth so it offers a "broad" support. It can be used to create new items. It does not support updating existing items in the database. The Excel Importer is not a core product, and we provide it to customers when it fits customers' needs. The below example's use case is for importing an Excel file that contains requirements.
- Access to a SystemWeaver database.
- A container item has been created for the Excel file
- Installation of SystemWeaver.ExcelImport.exe
Note: This tool cannot be used for importing attribute nodes, e.g., test results.
Start by opening the SystemWeaver.ExcelImport.exe, and entering your login information.
Configuring the Import
- In Container item id, enter the item ID for the container item that has been created in advance for the Excel file "parent". This can be obtained by selecting the newly created container item and viewing the Properties view or by copying the item (Ctrl+C) and pasting (Ctrl+V) in the Container item id field. Example: url:swap://sys7:1345/x04000000000982AA or x04000000000982AA.
- In the File field, browse out and select the Excel file containing the requirements.
- Select the Sheet from the drop-down.
- Select or manually enter the Item type (SID) for the imported items (e.g., requirements).
- Select or manually enter the Part type (SID) for the imported items (e.g., requirements).
In the above example, requirements will be loaded to the 'Fun: Climate control' container. The Item Type will be CRES and the Part type will be IBRA.
- Select the first row number that is containing data in First row of data.
- In Item name column, select the column that will map to the item Name.
- In Item description column, select the column that will map to the Description.
|Tip: A context menu is also available for making the above selections when right-clicking in the Preview:|
If you want to map further information from the spreadsheet, you can map it to existing attributes for the new items.
- In the Preview, right-click on a data cell in the column you want to map and select Map this column to attribute:
- The SelectAttributeTypeDialog will display. Select the existing attribute to map to and click Done. The Attribute mappings table in the tool will display your selected mappings.
In the above example, the data in column C will be imported to the attribute with SID 'ABAN'.
Note: The ExcelImport tool will only allow for the import of enum attributes with Single Dimension, i.e., single value occurrence.
|Tip: If importing to an enum attribute, be sure that your data matches the attributes validated list of values otherwise you will see data errors in the imported items. For example, the value "Approved" is not the same as the value "Approved " (note space after the letter d).|
Saving the Import Config and Importing
You have the option of saving the configuration for later use. It is not required that you do this.
- When you are satisfied with an Excel Import configuration, you have two options for saving your settings.
-Click Save config to save it as your default config. The default config will load each time you open the application.
-Click Save config as to save the configuration as a .config file which you can load for future use by clicking Load config and selecting it.
- When you are ready to import, click Start Import. A message to the right of Start Import will inform when the import is completed.
- Once your import is complete, you can then find the newly created items in the database and make edits as needed.
Example Import Configuration
Results In Explorer