- Resulting CSV file must contain a header row with the fields / field (column) names outlined in the following table.
- Columns should be in the exact order below.
- File should be transmitted as a CSV file (not as an Excel file).
| Order | Field | Required | Format / Limits | Description |
|---|---|---|---|---|
| 1 | ProjectNumber | Yes | Text (127 max) | MetaField's Project Number for the project the work is for - must match MetaField |
| 2 | StartDate | Yes | yyyy-mm-dd | Date the work is scheduled to be performed / due |
| 3 | AsAvailable | Yes | 0/1, TRUE/FALSE, True/False | Indication if the work order is assigned to a time (AsAvailable = FALSE) or if the work order is performed as technicians are available that day / no set time (AsAvailable = TRUE) |
| 4 | StartTime | Conditionally | hh:mm | Starting time for the work Only required / supply if AsAvailable = FALSE |
| 5 | DurationHours | Conditionally | Integer (2 characters max) | Duration of work in hours Only required / supply if AsAvailable = FALSE |
| 6 | DurationMinutes | Conditionally | Integer (2 characters max) | Duration of work in minutes Only required / supply if AsAvailable = FALSE |
| 7 | WorkItem | Yes | String (Concatenation of Names if multiples) | MetaField's Work Item Name If multiple work items are associated with a work order, separate the work item ID list by | (pipes) with no spaces surrounding the pipes. For example: Work Item A|Work Item B|Work Item C String contained in " " if commas exist in text string. |
| 8 | Location | No | Text (Long String) | Location of the work - could be a concatenation of multiple data points related to the work being performed (asset information, physical location, etc.) String contained in " " if commas exist in text string. Line breaks inserted by including a | at the end of a line. Do not put spaces on either side of the | to prevent extra spaces from being inserted. Text String 1|Text String 2|Text String 3 results in... Text String 1 |
| 9 | NotesForTechnician | No | Text (Long String) | Notes / supporting information for the technician to be aware of - could be a concatenation of multiple data points String contained in " " if commas exist in text string. Line breaks inserted by including a | at the end of a line. Do not put spaces on either side of the | to prevent extra spaces from being inserted. Text String 1|Text String 2|Text String 3 results in... Text String 1 |
| 10 | NotesForScheduler | No | Text (Long String) | Notes / supporting information for the scheduler to be aware of - could be a concatenation of multiple data points String contained in " " if commas exist in text string. Line breaks inserted by including a | at the end of a line. Do not put spaces on either side of the | to prevent extra spaces from being inserted. Text String 1|Text String 2|Text String 3 results in... Text String 1 |
| 11 | RequestedBy | No | Text (100 characters max) | Name of the person requesting the work "Bulk Import" or similar could be passed to denote the work orders created using the bulk import script. |
| 12 | PhoneNumber | No | Text (63 Max) | Phone number of the person requesting the work 999-999-9999 format |
| 13 | RequestedDateTime | No | yyyy-mm-dd hh:mm | Date and time the work was requested |
| 14 | Technician | No | String | MetaField User's (Field Technician) Email Address If multiple technicians are associated with a work order, separate the email address list by | (pipes). Do not put spaces on either side of the | to prevent extra spaces from being inserted. For example: user1@company.com|user2@company.com |