Maintenance import (PAT test results)

Maintenance > Maintenance Imports page allows you to quickly import PAT inspection (also called Test and Tag) reports directly into Trail from a provided file.

Trail links the inspection results to the correct item and records them in the system, saving time and reducing manual entry errors.

Note: This page can be added on request. Contact support@trail.fi if you are interested.

Topics:

  1. Basic information
  2. Create maintenance plan for PAT tests
  3. Import test results
  4. Examples of the files

Basic information

  • The file must be in TXT or CSV format.
  • The file should include an identifier exported by your testing device (e.g., serial number, custom ID, or Trail barcode).
  • During import, Trail scans each row (or block) of the tests in the provided file and searches for the item informed.
  • Once the item is found, Trail adds a new inspection using the added date from the file.
  • If a maintenance report with the same name and date already exists, Trail reports this with an error to avoid creating a duplicate.

Create maintenance plan for PAT tests

  1. Open Maintenance - Maintenance planning
  2. Click New maintenance plan
  3. Create maintenance plan for the PAT inspection.
    1. Additional guidance here: Maintenance plan (create or edit plans)
  4. Select the model the inspection requires
  5. Save the change

Import test results

  1. Open Maintenance > Maintenance imports
  2. Click Import
  3. Select maintenance plan
  4. Drag and drop the file (Choose a .text, .csv file)
  5. Click Import

  1. Trail imports the results.
  2. Status will show Imported once complete
  3. Click the file name to view detailed results
    1. New Maintenances – Import was successful
    2. Errors – Something went wrong. Common examples:
      • Maintenance (20.01.2026) already exists for the item → duplicate import
      • Item not found → identifier in the file does not match any existing item

  1. Imported information can be found by opening the maintenance's details

Examples of the files

Example of a PAT inspection (TXT)

TEST NUMBER   00XX
DATE   07-SEP-2021 <== INSPECTION DATE
TIME      08:12:54
TESTER    AAA-BBBB
APP NO    IDENTITY <== TRAIL IDENTITY
TEST MODE     TEST
...
USER       example
SITE              
TEXT

Example of a PAT inspection (CSV)

Asset ID,Description,Last Full Test Date,Next Full Test Date,,
<TRAIL IDENTITY>,MANUFACTURER MODEL,18/11/2021,17/11/2022,,

⭐ Tips

  • Make sure your file includes a correct identifier for each item to ensure the inspection links properly.
  • Check that the inspection dates are in a recognized format.
  • If any rows fail to import, review the Errors to see the issue and correct it.

Related Articles