Loading Relationships
Copy
Loading relationships into the database using the Batch Loader is identical to loading the Item instances. The Configurations Pane parameters, such as the data file name and the Server fully specified path, must be completed. Alternatively, you can use an .ibl configuration file that may have these parameters previously set. The difference is of course in the data mappings. Let’s look at the following data file:
To set the data mappings:
- Start the
BatchLoader.ex - Select New from the main Tool Bar.
- Fill out the information in the Configuration Pane as follows:
- FileName – C:\BOM.txt
- Server – http://localhost/InnovatorServer
- Database – InnovatorSolutions
- User - admin
- LogFilePath – C:\BOM.log
- FirstRowIsColumnNames – True
- From the template pane, select Wizard. A new dialog is brought up for data mapping:
- Select Part BOM from the Item Type dropdown.
- The Source Part maps to the keyed_name of the source_id Item
- The Related Part maps to the keyed_name of the related_id Item
- Click OK once all mappings are finished. You should see the mappings displayed in the Batch Loader template.
- Click Save in the main tool bar and save this configuration file. The configuration file (with an .ibl extension) saves all the Configuration Pane settings, such as the server path, and the data file name, as well as all the data mappings.
- Click Verify in the main tool bar to make sure that there are no errors in the AML template.
- Click Load.
- Log into Aras Innovator, using the same database that you specified for the data load.
- Go to Part X-00012, and look at the added BOM relationships: