CSV Import Enhancements

IT Asset Management version 2025 R1

Previously, CSV imports into IT Asset Management only supported a single column labeled LicenseKeyValue, which was used to import license keys.

Two additional optional columns can now be included in the CSV file: ExpiryDate and Comments. These are not mandatory, you can choose to omit them if not needed.

When including ExpiryDate and Comments, your CSV file should follow this structure:

LicenseKeyValue, ExpiryDate, Comments
key123, 01/11/2025, floating
key456, 04/25/2025, activation
key789, 05/27/2025, token
IT Asset Management will attempt to determine the appropriate regional date format based on all of the dates provided in the CSV file. The detection follows these rules and parsing logic:
  • German date formats—If any date matches a German format using a dot separator (for example, dd.MM.yyyy, d.MM.yyyy, and so on), IT Asset Management will immediately assume all dates in the file follow this format and stop further evaluation.
  • Japanese / ISO-8601 / RFC-3339 formats—If a date matches formats such as yyyy/MM/dd or yyyy/MM/d, IT Asset Management will assume this format for all dates in the file and stop further checks.
  • Disambiguation between US and EU formats—If a date is valid in one format (for example, US MM/dd/yyyy) but not valid in the other (for example, EU dd/MM/yyyy), IT Asset Management will adopt the format in which the date is valid and cease further analysis.

If none of the above conditions are met after examining all dates, IT Asset Management will default to using the date format specified by the server’s locale settings.

The Comments column can contain only single-line text. Multi-line comments are not supported; each entry must be contained in a single line.

IT Asset Management (Cloud)

Current