Question & Answer
Question
CSV file format for work order data
Answer
CSV file format for work order data
Data related to work orders needs to be imported into IBM? Work Optimization for Water Utilities for use inwork order scheduling. The data needs to be formatted as a comma-separatedvalue file and imported into IBM Work Optimization for Water Utilities with the wo command.
OPWONUMASSETTYPEFAILUREPROBLEMCAUSEREMEDYWORKTYPEEQNUMSTATUSSTATUSDATEFAILDATEREPORTDATELOCATIONLATITUDELONGITUDEDESCRIPTIONWORKPRIORITYDURATION
OperationWO_IDAsset_typeFailureProblemCauseRemedyWorktypeAsset_numberStatusStatus_dateFailure_dateReported_dateLocationLatitudeLongitudeDescriptionWO_PriorityDuration
- Operation specifies if the work order is tobe added updated or deleted. Operation is oneof the following one character uppercase values:
- A specifies that the work order is to be added.
- U specifies that the existing work order isto be updated. If the work order does not exist it is added.
- D specifies that the existing work order isto be deleted.
- WO_ID is an up to 10 character value identifyingthe work order.
- Asset_type is an up to 20 character value classifyingthe asset. Asset_type must match an asset typedefined in the customer production data.
- Failure is an up to 20 character value specifyingthe type of failure. Failure must match a failuretype defined in the customer production data.
- Problem is an up to 20 character value specifyingthe problem code for the failure. Problem mustmatch a problem code defined in the customer production data.
- Cause is an up to 20 character value specifyingthe cause for the failure. Cause must match a problemcause defined in the customer production data.
- Remedy is an up to 20 character value specifyinghow the failure was or needs to be fixed. Remedy mustmatch a problem remedy defined in the customer production data.
- Worktype is an up to 20 character value specifyingthe type of work to be performed. Worktype mustmatch a work type defined in the customer production data.
- Asset_number is a reserved field. Anythingspecified in the CSV file will be ignored.
- Status is an up to 20 character value specifyingthe status of the work order. Status must matcha status type defined in the customer production data.
- Status_date is the date of the last work orderupdate in the format:
Year-Month-Day Hour:Minute:Second:Millisecond
Where:- Year is a four-digit year value.
- Month is a two-digit month value.
- Day is a two-digit day value.
- Hour is a two-digit hour value in 24-hour format.
- Minute is a two-digit minute value.
- Second is a two-digit second value.
- Millisecond is a four-digit millisecond value
The Year Monthand Day must always be specified. If time is alsospecified Hour Minute Secondand Millisecond must be specified.
- Failure_date is the date when the failureoccurred in the format:
Year-Month-Day Hour:Minute:Second:Millisecond
Where:- Year is a four-digit year value.
- Month is a two-digit month value.
- Day is a two-digit day value.
- Hour is a two-digit hour value in 24-hour format.
- Minute is a two-digit minute value.
- Second is a two-digit second value.
- Millisecond is a four-digit millisecond value
The Year Monthand Day must always be specified. If time is alsospecified Hour Minute Secondand Millisecond must be specified.
- Reported_date is the date when the failurewas reported in the format:
Year-Month-Day Hour:Minute:Second:Millisecond
Where:- Year is a four-digit year value.
- Month is a two-digit month value.
- Day is a two-digit day value.
- Hour is a two-digit hour value in 24-hour format.
- Minute is a two-digit minute value.
- Second is a two-digit second value.
- Millisecond is a four-digit millisecond value
The Year Monthand Day must always be specified. If time is alsospecified Hour Minute Secondand Millisecond must be specified.
- Location is an up to 254 character descriptionof the location where the failure occurred. For example the streetaddress.
- Longitude is the longitude where the failureis located. Longitude is a DECIMAL(138) valuebetween -180 and +180.
- Latitude is the latitude where the failureis located. Latitude is a DECIMAL(138) value between-90 and +90.
- Description is an up to 254 character descriptionof the work to be performed.
- WO_Priority is a number describing the priorityof the work order where 5 is the highest priority and 1 is the lowest.
- Duration is a number describing the plannedor actual work time in minutes.
If a value contains non-alphanumeric charactersfor example spaces or symbols the value must be enclosed in quotationmarks. Otherwise surrounding values with quotation marks is optional.Values cannot include double or single quotation marks. All valuesmust be separated by commas. Ifa value is not specified the place for that value must still be heldwith commas with no data between them.
When Operation isadd (A) or update (U) the informationspecified in the CSV file will replace any existing information in IBM Work Optimization for Water Utilities. If a valueis not specified in the CSV file any existing value in IBM Work Optimization for Water Utilities is retained.Only Operation and WO_ID arerequired for the delete (D) operation.
OPWONUMASSETTYPEFAILUREPROBLEMCAUSEREMEDYWORKTYPEEQNUMSTATUSSTATUSDATEFAILDATEREPORTDATELOCATIONLATITUDELONGITUDEDESCRIPTIONWORKPRIORITY
Was this topic helpful?
Document Information
Modified date:
08 December 2018
UID
ibm10758629