What Is This Spreadsheet For?
Use this spreadsheet to manage the list of failure causes for your assets in TRACTIAN. Failure causes describe why a failure happened — for example, "Lack of lubrication" or "Overheating." You can use this spreadsheet to add new failure causes in bulk or update the names of existing ones.
Can I Import, Export, or Both?
Import (upload data into TRACTIAN): Yes
Export (download data from TRACTIAN): Yes
Column Reference
# | Column Name | What to Fill In | Required? | Accepted Values | Used In |
1 | ID (Fill only for update) | The unique ID of an existing failure cause | No | Any valid failure cause ID from TRACTIAN | Import |
2 | Name | The name of the failure cause | Yes | Any text | Both |
Columns in Detail
ID (Fill only for update)
Leave this column blank when adding a new failure cause.
Fill this column only when you want to rename an existing failure cause. The ID tells TRACTIAN which record to update.
If you enter an ID that does not exist in TRACTIAN, the row will be rejected.
Name
The name of the cause of the failure (for example, "Lack of Lubrication" or "Excessive Vibration").
Each failure cause name must be unique across your company — you cannot have two failure causes with the same name.
This column is required for every row.
Custom Fields
This spreadsheet does not include custom fields.
Tips for a Successful Import
Leave the ID (Fill only for update) column blank for every new failure cause — only fill it when renaming an existing one.
Make sure every row has a value in the Name column — rows with a blank name will be skipped.
Each failure cause name must be unique. If two rows in the same file have the same name, both may be rejected.
If you are updating an existing failure cause, double-check that the ID matches exactly what is stored in TRACTIAN.
Example Rows
ID (Fill only for update) | Name |
Lack of Lubrication | |
Overheating | |
64c3f8e2a0b5e50003c9e567 | Excessive Vibration |
Rows 1 and 2 create new failure causes. Row 3 renames an existing failure cause using its ID.
Frequently Asked Questions
Can I update an existing failure cause or only create new ones? You can do both. Leave the ID column blank to create a new failure cause, or fill it with the existing ID to update its name.
What happens if I enter a name that already exists? The row will be rejected with an error. Each failure cause name must be unique within your company.
What happens if I enter an ID that does not exist in TRACTIAN? The row will be rejected. Make sure the ID you enter matches a failure cause already in the system.
Can I delete failure causes using this spreadsheet? No. This spreadsheet only supports creating and renaming failure causes. Deletions must be done directly in TRACTIAN.