Mandatory fields in the bulk import spreadsheets

  • リリースバージョン: Australia
  • 更新日 2026年03月12日
  • 所要時間：4分

    • 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
    注:
    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
    注:
    Not applicable for single models.
    		 No
    Parent model name Yes
    注:
    Not applicable for single models.
    		 No
    Parent model number Yes
    注:
    Not applicable for single models.
    		 No
    Component number Yes
    注:
    Not applicable for single models.
    		 No
    Component quantity Yes
    注:
    Not applicable for single models.
    		 No
    Required Yes
    注:
    Not applicable for single models.
    		 No
    Hot swappable Yes
    注:
    Not applicable for single models.
    		 No
    Repairable Yes
    注:
    Not applicable for single models.
    		 No

    Mandatory fields for asset template

    Field/column Mandatory for creating assets Mandatory for updating assets
    Index
    注:
    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
    注:
    Not applicable for single assets.
    		 Yes
    Parent model name Yes
    注:
    Not applicable for single assets.
    		 Yes
    Parent model number Yes
    注:
    Not applicable for single assets.
    		 Yes
    Component number Yes
    注:
    Not applicable for single assets.
    		 Yes
    Asset tag Yes Yes
    Serial Number Yes No
    Parent asset Yes
    注:
    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
    注:
    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
    注:
    Not applicable for single models and single assets.
    		 Yes
    Parent model name Yes
    注:
    Not applicable for single models and single assets.
    		 Yes
    Parent model number Yes
    注:
    Not applicable for single models and single assets.
    		 Yes
    Component number Yes
    注:
    Not applicable for single models and single assets.
    		 No
    Component quantity Yes
    注:
    Not applicable for single models and single assets.
    		 No
    Required Yes
    注:
    Not applicable for single models and single assets.
    		 No
    Hot swappable Yes
    注:
    Not applicable for single models and single assets.
    		 No
    Repairable Yes
    注:
    Not applicable for single models and single assets.
    		 No
    Asset tag Yes Yes
    Serial number Yes No
    Parent asset Yes
    注:
    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