Asset Imports
Platform: | WebMobile |
---|---|
Plan Type: | BasicEssentialPremiumEnterprise |
User Type: | RequesterFull UserAdministrator |
This article explains how to import asset data into MaintainX from a CSV or Microsoft Excel (XLS, XLSX) file using the built-in asset importer.
Asset Import Workflow Overview​
The asset import process follows these steps:
- Create a file to import: You can use a custom file, or the MaintainX asset import template (recommended).
- Upload the file: MaintainX processes the data and gives you a summary of what it can import.
- Troubleshoot (if needed): If MaintainX can't import your data, or the import summary isn't what you expect, you can modify and re-upload the file.
- Import your assets: If the import summary looks good, import the data to bring the assets into your organization.
Create a File to Import​
This section explains how to create an asset file to import, and details the file requirements.
An asset file can't have more than 500 rows. If your file has more than 500 rows, split it into smaller files before importing.
Supported File Formats​
You can upload files in any of the following formats:
.csv
.xls
or.xlsx
(Microsoft Excel)
Use the MaintainX Asset Import Template​
The import process works best if you use the MaintainX asset import template. The template includes all the supported fields (see Fields You Can Import) and is designed to work with the importer.
To download the asset import template:
-
From the sidebar, open the Settings menu and select General.
-
On the General tab, navigate to the Import Data section and select Assets.
The Asset Import Session screen opens.
-
Select Download Template.
The asset import template downloads directly to your computer.
Create a Custom File to Import​
If you don't use the MaintainX template to import your asset data, you can import from a custom file. For example, an export from an enterprise resource planning (ERP) or enterprise asset management (EAM) system. In that case the importer will try to match the data in your file to the data MaintainX needs to create the assets.
Before importing, carefully review the fields you can import, and make sure the column names for the data in your custom file match the column names that MaintainX expects.
Fields You Can Import​
Column in File | Field in MaintainX | Description |
---|---|---|
Asset | Asset Name | The name of the asset. It can be up to 255 characters long. MaintainX can't import an asset if this cell is blank. |
Parent Asset | Parent Asset | If you're importing a multi-level asset hierarchy, this is the immediate parent asset of the asset defined in the row. When MaintainX imports the assets, it builds the full hierarchy based on these relationships. For details, see Importing Asset Hierarchies. If you enter the exact name of an existing asset in this cell, MaintainX makes the imported asset a sub-asset of that asset. |
Description | Description | A short description of the asset. It can be up to 4096 characters long (roughly 500 to 700 words). Make sure to include all the relevant details for the asset. |
Asset Type | Asset Types | A text field to label the assets into types. This field can be used for filtering and reporting. Although an asset in MaintainX can have more than one asset type, your import file can only have one per asset. If you enter the exact name of an existing asset type in this cell, MaintainX adds that asset type to the new asset's Asset Types field. If you enter the name of an asset type that doesn't exist in your MaintainX organization, MaintainX creates the asset type when it imports the assets, and adds it to the new asset's Asset Types field. |
Model | Model | The model name or model number of the asset. |
Serial Number / VIN Number | Serial Number | The vehicle identification number (VIN) or serial number of the asset. |
Bar code | QR Code Barcode | Barcode or QR Code used to identify the asset. To import it, enter the alphanumeric code in this cell. This appears as a QR code in the MaintainX application. |
Location | Location | The location associated with the asset in your MaintainX organization. If you enter the exact name of an existing location in this cell, MaintainX associates the imported asset with that location. If you enter the name of a location that doesn't exist in your MaintainX organization, MaintainX creates the location when it imports the assets, and associates the asset with the new location. |
Responsible Teams | Teams in charge | The teams responsible for maintaining the asset. Although an asset in MaintainX can be associated with more than one team, your import file can only have one team per asset. If you enter the exact name of an existing team in this cell, MaintainX associates the imported asset with that team. If you enter the name of a team that doesn't exist in your MaintainX organization, MaintainX creates the team when it imports the assets, and associates the asset with the new team. |