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. 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 that segregates devices belonging to the same sub-network for the asset's IPv4 connectivity. In format X.X.X.X where X is 0-255 (inclusive).
Gateway Router (AKA 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).

Note

  • Ensure that the Excel file follows the provided template structure.
  • 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.
  • Ensure that each column name in the Excel file for import is unique.
  • File with size more than 5 MB will not be accepted.

Custom Properties

Custom properties allow users to store additional asset-specific information (such as location, department, etc.) that is not covered by the standard columns.

Note

  • Custom property columns are added after the standard columns in the Excel template.
  • Each custom property column should have a unique name.
  • Max. 10 custom properties for each asset. This limit is inclusive of any user-defined identifier columns, because a user-defined identifier is a custom property column. For example, 2 user-defined identifiers plus 8 regular custom properties reach the limit of 10; adding an 11th custom property column causes the import to fail.

Examples

  • An example column, Custom property 1, highlighted in blue in the Excel template, illustrates how to add custom property fields.

Asset Identifier

MAC address is the default asset identifier. If not available, a user-defined identifier can be provided as an asset identifier.

Note

  • User-defined asset identifier can be provided by adding a custom property column with user-defined identifier name and suffix '*'.
  • Max. allowed user-defined identifiers are 2. Because user-defined identifiers are custom property columns, they count toward the limit of 10 custom properties per asset (they are not additional to it).
  • Column names mentioned in the Excel Template Columns table can't be used as user-defined identifiers. If such a column name is marked as a user-defined identifier by adding the suffix '*', the '*' suffix is ignored and the column is treated as its standard column (not as a user-defined identifier).
  • If no asset identifier is provided i.e. neither a MAC address nor a user-defined identifier, that asset entry will be skipped and not imported.
  • If more than one user-defined identifier is specified, priority is assigned from left to right based on the column order in the Excel template.

Examples

  • An example column, user-defined identifier 1*, highlighted in yellow in the Excel template, illustrates how to add user-defined identifier fields.

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:

  • Asset entry doesn't have any asset identifier (neither a MAC address nor a user-defined identifier).
  • A MAC address, IP address, Subnet mask, or Gateway value is present but not in the right format.

Note

An empty MAC address cell is not treated as a format error. If the MAC address is left empty, the entry is only skipped when no user-defined identifier is provided. When a valid user-defined identifier is present, the asset is imported using that identifier and the empty MAC address is ignored. Format validation applies only to cells that contain a value.

This exemption applies to an empty MAC address only. A MAC address that is present but malformed always causes the entry to be skipped, even when a valid user-defined identifier is also provided. Correct or clear the malformed MAC address value to import the entry.

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".
  • A malformed MAC address such as "123456" is skipped even when a valid user-defined identifier is present; clear the cell or fix the value.

Rejected Assets

Assets will be rejected if:

  • Asset entry has invalid values, i.e., doesn't comply with asset schema. For more details on asset schema, refer Base write schema.
  • The imported asset entry uses the same identifier (or combination of identifiers) as an existing asset in the system. In this case, only the conflicting asset entry is rejected; the rest of the import continues and the existing asset is not modified.
  • 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