What Is This Spreadsheet For?
Use this spreadsheet to manage the list of failure modes for your assets in TRACTIAN. Asset failures are the named types of failures that can occur — for example, "Bearing Wear" or "Shaft Misalignment." These are used to classify failure events and build your company's failure catalog. You can add new failure types 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 asset failure | No | Any valid asset failure ID from TRACTIAN | Import |
2 | Name | The name of the failure mode | Yes | Any text | Both |
Columns in Detail
ID (Fill only for update)
Leave this column blank when adding a new failure mode.
Fill this column only when you want to rename an existing failure mode. 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 failure mode (for example, "Bearing Wear" or "Seal Leakage").
Each failure name must be unique across your company — you cannot have two failure modes 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 mode — 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 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 mode, double-check that the ID matches exactly what is stored in TRACTIAN.
Example Rows
ID (Fill only for update) | Name |
Bearing Wear | |
Seal Leakage | |
64e5b0a4c2d7e70005e1a789 | Shaft Misalignment |
Rows 1 and 2 create new failure modes. Row 3 renames an existing failure mode using its ID.
Frequently Asked Questions
Can I update an existing failure mode or only create new ones? You can do both. Leave the ID column blank to create a new failure mode, 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 mode 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 mode already in the system.
Can I delete failure modes using this spreadsheet? No. This spreadsheet only supports creating and renaming failure modes. Deletions must be done directly in TRACTIAN.