Skip to content

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. More role and permission information can be found on the Role and Access Management page.

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.

Conditions

  • Import up to 3000 assets at once, with a maximum of 10 custom properties per asset.

Examples

  • An Excel file contains 3500 assets (rows), split it into at least two files, each with no more than 3000 rows, to import all assets.
  • After the standard columns (up to "IP address"), add up to 10 additional columns for custom properties (such as "Location", "Department", "Asset Owner", etc.). Each asset (row) can have values for these custom properties. Adding more than 10 custom property columns will cause the file import job to fail.

Constraints

  • For each tenant, only 2 import jobs can be in the STARTED state (running) at the same time. Any number of import jobs can be created, but only 2 will run in parallel. Additional jobs will wait and start automatically when one of the running jobs completes.

Examples

  • When starting 5 import jobs, the first 2 begin immediately. The remaining 3 are queued and start one by one as earlier jobs finish. This ensures system stability and fair resource usage for all users.

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).
Article Number Article number of the asset.
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.

Import Errors and Troubleshooting

During the import process, some assets may be skipped or rejected if they do not meet the required criteria. Below are common reasons and examples to help you avoid these issues:

Skipped Assets

Assets will be skipped if:

  • MAC Address is not provided.
  • MAC Address, IP Address, Subnet Mask, or Gateway are not in the right format.

Examples

  • A MAC address like "ZZ:ZZ:ZZ:ZZ:ZZ:ZZ" or "123456" will cause the asset to be skipped. Use formats like "00:1A:2B:3C:4D:5E".
  • An IP address like "999.999.999.999" or "abc.def.ghi.jkl" is invalid. Use formats like "192.168.1.10".

Rejected Assets

Assets will be rejected if:

  • Import Asset size is more than 64 KB (including all property values).
  • Vendor length is longer than 128 characters.
  • Other fields (such as description, asset name, custom property values) are longer than 512 characters.

Examples

  • If you attach a very large description or many custom properties, the total data for that asset may exceed 64 KB and will be rejected.
  • Vendor like "Super Long Vendor That Exceeds The Maximum Allowed Length.........." (over 128 characters) will cause rejection. Keep it concise.
  • If the asset description is a full page of text, it may exceed 512 characters and be rejected. Use brief, clear descriptions.

Tip

  • Ensure the Excel file uses correct formats and reasonable field lengths before importing to avoid errors.

Any questions left?

Ask the community