Mandatory fields in the bulk import spreadsheets

  • Freigeben Version: Australia
  • Aktualisiert 12. März 2026
  • 2 Minuten Lesedauer
  • A list of the mandatory fields in the model, asset, and model and asset templates for bulk import in the Enterprise Asset Workspace.

    Mandatory fields for model template

    Field/column Mandatory for creating models Mandatory for updating models
    Index
    Hinweis:
    Representing the row number can be used to identify a specific row. However, you need to fill this in manually.
    Yes Yes
    Manufacturer Yes Yes
    Model Name Yes Yes
    Model Number Yes Yes
    Model category Yes Yes
    Model type Yes Yes
    Parent model manufacturer Yes
    Hinweis:
    Not applicable for single models.
    No
    Parent model name Yes
    Hinweis:
    Not applicable for single models.
    No
    Parent model number Yes
    Hinweis:
    Not applicable for single models.
    No
    Component number Yes
    Hinweis:
    Not applicable for single models.
    No
    Component quantity Yes
    Hinweis:
    Not applicable for single models.
    No
    Required Yes
    Hinweis:
    Not applicable for single models.
    No
    Hot swappable Yes
    Hinweis:
    Not applicable for single models.
    No
    Repairable Yes
    Hinweis:
    Not applicable for single models.
    No

    Mandatory fields for asset template

    Field/column Mandatory for creating assets Mandatory for updating assets
    Index
    Hinweis:
    Representing the row number can be used to identify a specific row. However, you need to fill this in manually.
    Yes Yes
    Manufacturer Yes Yes
    Model Name Yes Yes
    Model Number Yes Yes
    Parent model manufacturer Yes
    Hinweis:
    Not applicable for single assets.
    Yes
    Parent model name Yes
    Hinweis:
    Not applicable for single assets.
    Yes
    Parent model number Yes
    Hinweis:
    Not applicable for single assets.
    Yes
    Component number Yes
    Hinweis:
    Not applicable for single assets.
    Yes
    Asset tag Yes Yes
    Serial Number Yes No
    Parent asset Yes
    Hinweis:
    Not applicable for single assets.
    No
    Quantity Yes No
    State Yes No
    Sub state Yes No
    Stockroom Yes No
    Location Yes No

    Mandatory fields for model and asset template

    Field/column Mandatory for creating models and assets Mandatory for updating models and assets
    Index
    Hinweis:
    Representing the row number can be used to identify a specific row. However, you need to fill this in manually.
    Yes Yes
    Manufacturer Yes Yes
    Model Name Yes Yes
    Model Number Yes Yes
    Model category Yes Yes
    Model type Yes Yes
    Parent model manufacturer Yes
    Hinweis:
    Not applicable for single models and single assets.
    Yes
    Parent model name Yes
    Hinweis:
    Not applicable for single models and single assets.
    Yes
    Parent model number Yes
    Hinweis:
    Not applicable for single models and single assets.
    Yes
    Component number Yes
    Hinweis:
    Not applicable for single models and single assets.
    No
    Component quantity Yes
    Hinweis:
    Not applicable for single models and single assets.
    No
    Required Yes
    Hinweis:
    Not applicable for single models and single assets.
    No
    Hot swappable Yes
    Hinweis:
    Not applicable for single models and single assets.
    No
    Repairable Yes
    Hinweis:
    Not applicable for single models and single assets.
    No
    Asset tag Yes Yes
    Serial number Yes No
    Parent asset Yes
    Hinweis:
    Not applicable for single models and single assets.
    No
    Quantity Yes No
    State Yes No
    Sub state Yes No
    Stockroom Yes No
    Location Yes No
    Yes No