How to batch import or delete spare parts?

Prev Next
  • PT

  • ES


Spare parts can be entered through individual records or in batch, by importing CSV files. They can also be deleted in batch.


Import spare parts

To import spare parts in batch, follow these steps:

  1. Open the import screen, in one of the following ways:

    • In Settings | General | File Imports, click on the desired template:

      • LocationParts, in the Import Spare Parts of Locations row;

      • EquipmentItemParts, in the Import Spare Parts of Equipments or Tools row;

    • In the asset list (Assets | Locations, Assets | Equipment or Assets | Tools), select the option Import Spare Parts;

  2. On the import screen, click on Download file to get the template file;

  3. Fill in the downloaded file, according to the rules below;

  4. In File to Import, click on Select and choose the filled-in file;

  5. Click on Import;

  6. View the result in the Summary of imports, displayed on the same screen. If there are no errors or warnings, the summary shows No messages. Otherwise, click on the number of messages to view them.


Fill in the import file

When filling in the file, the following rules apply:

  • The Key, Part, Quantity and Company fields are required;

  • The file must be of type CSV, with the semicolon (;) as the separator;

  • The file must not have more than 2,000 records or 4 MB;

Columns must not be removed or added to the downloaded template file.


Delete spare parts

To delete spare parts in batch, follow these steps:

  1. Go to Settings | General | File Imports;

  2. Click on the template corresponding to what you want to delete:

    • DeleteLocationParts, in the Delete Spare Parts of Locations row;

    • DeleteEquipmentItemParts, in the Delete Spare Parts of Equipments or Tools row;

  3. On the import screen, click on Download file to get the template file;

  4. Fill in the downloaded file, according to the rules below;

  5. In File to Import, click on Select and choose the filled-in file;

  6. Click on Import;

  7. View the result in the Summary of imports, displayed on the same screen. If there are no errors or warnings, the summary shows No messages. Otherwise, click on the number of messages to view them.


Fill in the deletion file

When filling in the file, the following rules apply:

  • The Key, Part and Company fields are required;

  • The file must be of type CSV, with the semicolon (;) as the separator.