This article will outline some handy tips, tricks & Rules to make the importing process easier than ever.

General Importing Rules

1. File format is CSV which is easiest to prepare in MS Excel
2. “ and ‘ are not seen as feet and inches in computer code, but rather quotation marks.
3. Import file type is CSV which means COMMA Separated Variable - If you have commas in your sheet, then you’ll push the data out to subsequent columns
4. Try with a sample file first - maybe 5 lines off your CSV import file. If you have an error, you can correct it.
5. Split the data into smaller subsets if needed. If you make a mistake, easier to delete
6. If you make a mistake, it may be possible to overwrite or update the data
7. Auto create new records - Can import certain columns and they will create new records. For example, you can import asset categories on the asset list and the categories will be created if they do not exist
8. Watch out for spelling mistakes. For example, you have Drills asset category already in the system and you import your sheet with asset category “drill”, the system will create a new record as in Auto create new records.
9. You can comment out the entire cell in later versions of MS Excel. For example, "Torgue Gauge, 30' Handle, 15k ft-lb SN: 816404" would import ok.

 Order of operations:

1. Create your custom fields
2. Import users & business if needed
3. Import asset list
4. Import parts
5. Import Task Groups
6. Import PMs
7. Import old work orders

Asset Import

1. Must have an asset name when importing
2. Custom Fields on the asset record - they must exist in the system before importing

Parts Import

1. Must have an asset name when importing

Meters

1. You cannot trigger items from the importer. This is to prevent errors. So, cannot import meter readings to trigger PMs.

PM’s

1. Not possible to import triggers
2. Watch out for nested PM’s - for example, monthly, quarterly and annual on same system. This reduces the number of PMs to manage. These need to be created manually
3. You can add the task group when importing. It is easier to add the task group needed for those PM's during the import, rather than configure it manually after.