Excel Import
The asset data from an Excel spreadsheet can be imported to IAH. This allows users to create assets in bulk and to add custom properties to the assets.
Prerequisite:
The user needs to have the admin role with global permission glb_file_import to perform the Excel import.
Important Notice
Please be aware:
- User Responsibility: By using this, you accept responsibility of uploading asset data to IAH.
Proceeding indicates your acceptance of these terms.
Import Data
To import asset data, the template file for the Excel import can be downloaded here Excel template file.
Excel Template Columns
| Column Name | Description |
|---|---|
| Asset name | Name of the asset (e.g. hostname). |
| Asset Family | Product family of the asset (e.g., SCALANCE 1500). |
| Description | Description of the asset. |
| MAC address* | MAC address of the asset (required). In format XX:XX:XX:XX:XX:XX or XX-XX-XX-XX-XX-XX where X is 0-9 or A-F (inclusive). |
| Serial number | Serial number of the asset. |
| Vendor | Manufacturer of the asset. |
| Hardware version | Product Version of the asset. |
| Firmware version | Firmware version of the asset. |
| Subnet mask | Network mask for the asset's IPv4 connectivity. In format X.X.X.X where X is 0-255 (inclusive). |
| Gateway | Gateway address for the asset's IPv4 connectivity. In format X.X.X.X where X is 0-255 (inclusive). |
| IP address | IPv4 address of the asset. In format X.X.X.X where X is 0-255 (inclusive). |
- Ensure that the Excel file follows the provided template structure.
- MAC Address, marked with '' and highlighted in black* in the Excel template is required for importing an asset. If not provided that asset entry will be skipped and not imported.
- Incorrect or missing data may result in import errors or incomplete asset creation.
- Do not change the name or order of the columns mentioned above in the template Excel.
- Any column added after the IP address columns will be treated as a custom property column defined by the user.
- Custom property columns are highlighted in blue in the Excel template.
- An example column, Custom property 1, is included in the template to illustrate how to add user-defined fields.
- Ensure that each column name in the Excel file for import is unique to prevent data mapping issues.
- File with size more than 5 MB will not be accepted.
Recommendations
- Import maximum of 3000 assets in a single import operation.