Skip to main content
Eptura Knowledge Center

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.

Import your Work Orders


Step 1. Download our sample file 

  1. Navigate to Settings.
  2. From Tools and Support, click on the Import clipboard_e2f7734169606f74f6b9db1dc625fc659.png icon. The Import Tool dialog displays.
  3. Click Work Orders. The Work Order Import Screen displays.

clipboard_e7f2a67e79c25b5a3f79809059998ca72.png

  1. Click on Sample-WO-File.Csv to download the sample import template.

Step 2. Complete the sample file section

  1. Open the Sample-WO-File.csv file in Microsoft Excel.
  2. Remember the data in this file is a sample, you must delete this row as you do not want to import these in.

clipboard_e9989f0f227198b3ffd265255163faeb5.png

  1. Under each of the Column Headers, complete the row data. For details on the data, see Work Order Import Template Data.
  2. 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.

clipboard_e9993388f101a212283e0ac9ae51aa026.png

Step 3. Upload the completed sample file 

  1. Click the Choose File button.
  2. Navigate to the file and select it. The file name displays in the screen.
  3. Click the Map Data buttonThe 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.

  1. Verify that all ManagerPlus Fields are matched with the correct Import File Fields.

clipboard_ef71b644368e021cf7dc16a8653198917.png

If you find a discrepancy, then you can correct the mapping.

  1. Click the Preview button. The Review Your Data screen displays.

clipboard_ec30895163bef73fd561c2b7d24d2c377.png

Step 5. Import

  1. Now you are ready to import. Click on the Import button.

clipboard_e44275ccc033efbf0b22b7b3d4db16f44.png

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

clipboard_e8f26e1cab4345e4d65ed9f7b9e0bd877.png

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