...
| 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.