How to batch import or delete spare parts?

It is possible to import and delete spare parts.

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:
   • The fields Key, Part, Quantity, and Company must be defined.
   • 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.

1. The file must always be of the CSV type and the separator character must be ; (semicolon).
2. Each file cannot have more than 2000 records or 4 Mb.
3. Each file cannot have more than 7500 attachments or 4 Mb.

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

1. The import screen is displayed;
2. 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 wish to delete Equipment and/or Tool 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:
   • The fields Key, Part, and Company must be defined.
   • When the import is finished, the import date will be presented and it might 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 on the import, you can see the errors by clicking on the number of messages.

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