Import your Work Orders
Level: Administrator
The Work Order Import is used to populate multiple work orders and include details such as assets, inventory, labor, and costs. Note that you can only import 1,000 rows at a time.
Contents
Import your Work Orders
Step 1. Download our sample file
- Navigate to Settings.
- From Tools and Support, click on the Import
icon. The Import Tool dialog displays. - Click Work Orders. The Work Order Import Screen displays.

- Click on Sample-WO-File.Csv to download the sample import template.
Step 2. Complete the sample file section
- Open the Sample-WO-File.csv file in Microsoft Excel.
- Remember the data in this file is a sample, you must delete this row as you do not want to import these in.

- Under each of the Column Headers, complete the row data. For details on the data, see Work Order Import Template Data.
- After all the data has been entered on the sheet, save the file to your computer.
Below displays an example of a work order import.

Step 3. Upload the completed sample file
- Click the Choose File button.
- Navigate to the file and select it. The file name displays in the screen.
- Click the Map Data button. The import file fields display.
Step 4. Map the data
The Map Data table shows which fields from the import file are being mapped to the fields in the application. Use the Map Data table to align the correct fields from the import file to the application. In this example, Status is mapped to Serial, which needs to be corrected.
- Verify that all ManagerPlus Fields are matched with the correct Import File Fields.

If you find a discrepancy, then you can correct the mapping.
- Click the Preview button. The Review Your Data screen displays.

Step 5. Import
- Now you are ready to import. Click on the Import button.

The work orders are imported and available in the work order module.

Template Fields
Below are the fields found in the template called Sample-WO-File.csv.
| Field | Required | Description |
|---|---|---|
| Work Order Number | Yes | |
| Purpose | Yes | |
| Asset | Yes | |
| Budget | Yes | |
| Type | Yes | |
| Priority | Yes | |
| Status | Yes | |
| Due date | ||
| Vendor | ||
| Assignee | ||
| Customer | ||
| Created Date | ||
| Completed Date | ||
| Work Description | ||
| Failure Code | ||
| Source ID | ||
| Maintenance Plan |
If your work orders are linked to a Maintenance Plan, then you can add the name in this column. Make sure that the name is an exact match. |
|
| PM |
Work Orders linked to PM schedules can update the PM's next due date based on the Imported Work Order's Create Date or Completed Date. If your work orders are linked to a PM, then you can add the name in this column. Make sure that the name is an exact match. |
|
| Part ID | ||
| Part Cost | ||
| Part Qty | ||
| Part Note | ||
| Part Task | ||
| Part Warehouse | ||
| Labor Contact | ||
| Labor Hours | ||
| Labor Task | ||
| Labor Rate | ||
| Labor Date | ||
| Labor Code | ||
| Other Cost Type | ||
| Other Cost Amount | ||
| Other Cost Task | ||
| Other Cost Note |
