Asset/Report Value Import Excel Template
To begin working with the template, select the Download Standard Field Template, Download Repeating Field Group Template, or Download National Bridge Element Template link to download the desired spreadsheet.
Standard Field Template
All fields are not necessarily mandatory, but it is recommended that all fields be completed if possible. It is important that all information be entered accurately.
Fields of Note: Controls that use numbers (such as Deck Condition) Some of these fields have a limited number of choices available to them. If a control's dropdown allows numbers "1" through "9" to be selected, entering any value outside of that range (such as "10") will cause an error when importing the template.
-OR-
Repeating Field Group Template
All fields are not necessarily mandatory, but it is recommended that all fields be completed if possible. It is important that all information be entered accurately.
Fields of Note: Controls that use numbers (such as Deck Condition) Some of these fields have a limited number of choices available to them. If a control's dropdown allows numbers "1" through "9" to be selected, entering any value outside of that range (such as "10") will cause an error when importing the template.
For example:
Instance ID = 1 Underrecord A Instance ID = 2 Underrecord B Instance ID = 3 Underrecord C Instance ID = 26 Underrecord Z Instance ID = 28 Underrecord BB
-OR-
National Bridge Element Template
All fields are not necessarily mandatory, but it is recommended that all fields be completed if possible. It is important that all information be entered accurately.
Fields of Note: Parent Element This field determines to which element the new element belongs, if applicable. In order for the import to work, the parent element listed in the field must already exist in the system and must be entered correctly.
Example: An agency has an asset with both element 12 and element 212 using protective system 510. However, each of those protective systems now has a defect that must be added:
12 > 510 > 1110
212 > 510 > 1111
When importing new grandchild elements, entering "510" into the Parent Element column of the template will cause problems because both element 12 and element 212 contain that protective system. To solve this issue, the admin can enter "12 > 510" into the Parent Element column to specify exactly where to place the new grandchild element within that asset.
- Controls that use numbers (such as Deck Condition) Some of these fields have a limited number of choices available to them. If a control's dropdown allows numbers "1" through "9" to be selected, entering any value outside of that range (such as "10") will cause an error when importing the template.
- Importing grandchild elements To import grandchild elements, the Parent Asset column of the template must
follow a specific "Parent Element > Protective System" format to ensure that the defect is imported to the correct location. For example, the Parent Asset column could read "12 > 510" with the Element column reading "1110."