How to import spare parts?

The spare parts can be inserted from individual records or through batch records by importing .csv files.

To batch load spare parts, select the option Settings | General | File Import or using the asset list (Assets | Locations; Assets | Equipment or Assets | Tools) by selecting the option Import Spare Parts.

1. The import screen is displayed;
   
2. Select the option Import Spare Parts;
   
3. Download the template file to be loaded, on the upper part of the screen and fill in the file;
   
4. Later, you must fill in the file according to the rules:
   
1. The fields Key, Part, Quantity, and Company must be defined.
   
2. When the import is finished, the import date will be presented and it might (or not) contain messages with import details. If an import occurs without errors/warnings, no information on the import details will be presented. If there are errors/warnings, you can see the errors by clicking on the number of messages.

When filling in the file, you must consider the following fields:

i.The file must always be of the CSV type and the separator character must be ; (semicolon).

ii.Each file cannot have more than 2000 records or 4 Mb.

iii.Each file cannot have more than 7500 attachments or 4 Mb.

 

You must not remove or add columns to the downloaded template.

• Related Articles

• How to batch delete spare parts?

  To delete spare parts select the option Settings | General | File Import: The import screen is displayed; Select the option Delete Location Spare Parts (if you wish to delete location's spare parts) or Delete Equipment or Tool Spare Parts (if you ...

• How to use spare parts?

  In an equipment, tool or location, you can associate spare parts. To associate them, follow these steps: Access the Menu in the option "Assets" - "Location" / "Equipment" / "Tools" Edit or create "Location" / "Equipment" / "Tools" On the Spare Parts ...

• How to view spare parts by asset?

  The spare parts list allows to have an overview of the pieces used, where they are used and the quantities needed. To view the list, on the menu select the option Assets | Explore | Spare Parts or search Spare Parts. The spare parts list has the ...

• How to record spare parts in an equipment or tool?

  In an equipment or tool, you can associate spare parts.   To associate them, follow these steps: Access the Menu in the option "Assets" - "Equipment" / "Tools" Edit or create "Equipment" / "Tools" On the Spare Parts tab, you can add a Part and the ...

• How to log spare parts in a location?

  In an location, you can associate spare parts. To associate them, follow these steps: Access the Menu in the option "Assets" - "Locations"; Edit or create a "Location"; On the Spare Parts tab, you can add a Part and the corresponding quantity, you ...