...
Field (Exact Name) | Required | Format / Limits | Description |
---|
ProjectNumber | Yes | Text (127 max) | MetaField's Project Number for the project the work is for - must match MetaField |
StartDate | Yes | yyyy-mm-dd | Date the work is scheduled to be performed / due |
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) |
StartTime | Conditionally | hh:mm | Starting time for the work Tip |
---|
Only required / supply if AsAvailable = FALSE |
|
DurationHours | Conditionally | Integer (2 characters max) | Duration of work in hours Tip |
---|
Only required / supply if AsAvailable = FALSE |
|
DurationMinutes | Conditionally | Integer (2 characters max) | Duration of work in minutes Tip |
---|
Only required / supply if AsAvailable = FALSE |
|
WorkItem | No | String (Concatenation of Names if multiples) | MetaField's Work Item Name Tip |
---|
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 |
Tip |
---|
String contained in " " if commas exist in text string. |
|
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.) Tip |
---|
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 Text String 2 Text String 3 |
|
Address | No | Text (Long String) | Address of the work Tip |
---|
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. 123 Anywhere Street|NW Lot Corner results in... 123 Anywhere Street NW Lot Corner |
|
City | No | String | City of the work |
Technician | No | String | MetaField User's (Field Technician) Email Address Tip |
---|
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 |
|
NotesForTechnician | No | Text (Long String) | Notes / supporting information for the technician to be aware of - could be a concatenation of multiple data points Tip |
---|
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 Text String 2 Text String 3 |
|
NotesForScheduler | No | Text (Long String) | Notes / supporting information for the scheduler to be aware of - could be a concatenation of multiple data points Tip |
---|
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 Text String 2 Text String 3 |
|
RequestedBy | No | Text (100 characters max) | Name of the person requesting the work Tip |
---|
"Bulk Import" or similar could be passed to denote the work orders created using the bulk import script. |
|
PhoneNumber | No | Text (63 Max) | Phone number of the person requesting the work
|
RequestedDateTime | No | yyyy-mm-dd hh:mm | Date and time the work was requested
|
Import Work Order Data
The attachment below, is an example of a properly formatted file, ready for Importing.