Overview
Scheduled maintenance activities can be imported using CSV files only (comma-separated values). Each scheduled maintenance can be imported with single or multiple tasks, or with a task list. Multi-asset scheduled maintenance can also be imported. This procedure demonstrates the import process.
The general plan for uploading a scheduled maintenance list is as follows:
The general import process is demonstrated first. Specific .csv file examples for complicated imports are documented toward the end.
A general import of scheduled maintenances:
The following example demonstrates how to upload two scheduled maintenance actives, one for each of the two different assets. Save a .csv file using the specified format. A .csv file can be created using a spreadsheet application. Excel and OpenOffice are two common examples.
1. Create a .csv file with the following headings in consecutive columns as shown:
SM Code,Asset Code,SM Description,Task Desc,Date Created,SM Status,Priority,Maintenance Type
2. Now, fill in the details for each scheduled maintenance activity. Under each heading add one row for each scheduled maintenance plan to be uploaded.
Note: None of the columns are required fields. You can leave a column blank for any scheduled maintenance if information is not available. The data can be entered manually later.
3. Save the .csv file. In excel, and other spreadsheet programs, you will need to change the file type to .csv.
4. Upload the .csv file using the import tool. To do this, click Scheduled Maintenance, and Import
5. Select the .csv file, and click Continue
6. There are a number of items that need to be selected before completing the import including:
Once satisfied, click Continue
7. You will be met with the following pop-up where you can review your import. In this case we are creating two new records. Once satisfied, click I mport . Your import will now take place.
8. Once finished, another pop-up will appear that reviews what has taken place. In this case two records have been created. Click Done, and your Scheduled Maintenances will now be displayed with any existing Scheduled Maintenances.
9. The next step is to edit your scheduling trigger, and activate your Scheduled Maintenance. More information on how to achieve this can be found by reading the article titled Create a New Scheduled Maintenance
Import a Scheduled Maintenance with Multiple Tasks:
To import a scheduled maintenance with multiple tasks, create a csv. where all of the information is identical including the SM Code, Asset Code, SM Description, Date Created, SM Status, Priority, Maintenance Type, except for the Task Description .
Scheduled Maintenance for Single Asset with Task Group import:
Multi-Asset Scheduled Maintenance:
To import a multi-asset scheduled maintenance, create a .csv where all of the information is identical including the SM Code, SM Description, Task Group, Date Created, SM Status, Priority, Maintenance Type, except for the Asset Code .
Note:- The import has multiple error checking features: