The following steps will show how to configure the Data Links tool. This example will show you how to load information from your external data source (Excel spreadsheet) to your user-defined Properties tab.
Go to the General Configuration tab in iConstruct menu and run the Data Links Configuration tool.
Select DataSource Type from the drop-down menu and search for a file in File Name.
Excel spreadsheet example.
Define if you want to apply the information to Items or Groups or both (Apply to Object Types) and select a sheet where information is located in Excel (Select Table).
Select an element in the background model and click Get NW Props.
Choose Target Attribute – user defined tab where you will write the data or type in the name to create it.
Select Exists Action and Linking Attribute. Linking Attribute can be any tab that will define a connection between a database and a model.
Define linking property between the database and the model.
NW Link Property and Database Link Field.
Check Fields to import.
Define Template Name and click Save.
Go to Data Links Configuration ➤ Select DataSource Type ➤ Define Object Types ➤ Select Table ➤ Pick an item in the background ➤ Click Get NW Props ➤ Choose Target Attribute, Exists Action and Linking Attribute ➤ Define linking property ➤ Select Fields ➤ Save Template ➤ Close