Been a while. Things have been smooth sailing for my other data, until this set here.
I am not sure why I get this error when ingesting it.
[2023-12-27T16:46:33,099][WARN ][logstash.outputs.elasticsearch][main][5612df4cdf64ce486ed4f17f543f5217abceb715b437f43413948e5c2f14e44d] Could not index event to Elasticsearch. {:status=>400, :action=>["index", {:_id=>nil, :_index=>"xxx-workorder-logs-2023", :routing=>nil, :pipeline=>"xxx-workorder-pipeline"}, {"message"=>"1032691,NULL,0.0,0.0,0.0,2022-12-24 14:16:31.57,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:57:16.064,0,NULL,NULL,NULL,NULL,PWY_TMA,NULL,2023 PWY TMA 6-Monthly xxxxx Critical Turnout Geometry Measurement,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008695,NULL,NULL,EN,2022-12-30 16:57:16.564,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,DTLMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,182.0,DAYS,0,1.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-03-20,NULL,2023-09-18,PM000000098127,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-24 14:16:32.211,126692,0,NULL,NULL,2021 PWY-ML-P2703,NULL,NULL,2023-03-20 00:00:00.0,2023-03-20 00:00:00.0,NULL,0,DTL,NULL,NULL,APPR,2022-12-30 16:56:13.326,NULL,125071.0,0,NULL,2023-05-04 00:00:00.0,NULL,2023-02-03 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428029,0,WO00428029,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221", "event"=>{"original"=>"1032691,NULL,0.0,0.0,0.0,2022-12-24 14:16:31.57,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:57:16.064,0,NULL,NULL,NULL,NULL,PWY_TMA,NULL,2023 PWY TMA 6-Monthly xxxxx Critical Turnout Geometry Measurement,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008695,NULL,NULL,EN,2022-12-30 16:57:16.564,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,DTLMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,182.0,DAYS,0,1.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-03-20,NULL,2023-09-18,PM000000098127,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-24 14:16:32.211,126692,0,NULL,NULL,2021 PWY-ML-P2703,NULL,NULL,2023-03-20 00:00:00.0,2023-03-20 00:00:00.0,NULL,0,DTL,NULL,NULL,APPR,2022-12-30 16:56:13.326,NULL,125071.0,0,NULL,2023-05-04 00:00:00.0,NULL,2023-02-03 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428029,0,WO00428029,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221"}, "host"=>{"name"=>"2003effb4cc0"}, "log"=>{"file"=>{"path"=>"/usr/share/logstash/workorder/xxx_workorder2023_20230727.csv"}}, "@version"=>"1", "@timestamp"=>2023-12-27T16:46:29.350220247Z}], :response=>{"index"=>{"status"=>400, "error"=>{"type"=>"illegal_argument_exception", "reason"=>"unable to convert [0.0] to long", "caused_by"=>{"type"=>"number_format_exception", "reason"=>"For input string: \"0.0\""}}}}}
[2023-12-27T16:46:33,101][WARN ][logstash.outputs.elasticsearch][main][5612df4cdf64ce486ed4f17f543f5217abceb715b437f43413948e5c2f14e44d] Could not index event to Elasticsearch. {:status=>400, :action=>["index", {:_id=>nil, :_index=>"xxx-workorder-logs-2023", :routing=>nil, :pipeline=>"xxxx-workorder-pipeline"}, {"message"=>"1032692,NULL,0.0,0.0,0.0,2022-12-24 14:16:33.259,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:57:16.643,0,NULL,NULL,NULL,NULL,PWY_TMA,NULL,2023 PWY TMA 6-Monthly xxxx Critical Turnout Geometry Measurement,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008695,NULL,NULL,EN,2022-12-30 16:57:17.174,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,DTLMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,182.0,DAYS,0,1.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-09-18,NULL,2024-03-18,PM000000098127,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-24 14:16:33.868,126692,0,NULL,NULL,2021 PWY-ML-P2703,NULL,NULL,2023-09-18 00:00:00.0,2023-09-18 00:00:00.0,NULL,0,DTL,NULL,NULL,APPR,2022-12-30 16:56:13.326,NULL,125071.0,0,NULL,2023-11-02 00:00:00.0,NULL,2023-08-04 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428030,0,WO00428030,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221", "event"=>{"original"=>"1032692,NULL,0.0,0.0,0.0,2022-12-24 14:16:33.259,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:57:16.643,0,NULL,NULL,NULL,NULL,PWY_TMA,NULL,2023 PWY TMA 6-Monthly xxxx Critical Turnout Geometry Measurement,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008695,NULL,NULL,EN,2022-12-30 16:57:17.174,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,DTLMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,182.0,DAYS,0,1.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-09-18,NULL,2024-03-18,PM000000098127,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-24 14:16:33.868,126692,0,NULL,NULL,2021 PWY-ML-P2703,NULL,NULL,2023-09-18 00:00:00.0,2023-09-18 00:00:00.0,NULL,0,DTL,NULL,NULL,APPR,2022-12-30 16:56:13.326,NULL,125071.0,0,NULL,2023-11-02 00:00:00.0,NULL,2023-08-04 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428030,0,WO00428030,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221"}, "host"=>{"name"=>"2003effb4cc0"}, "log"=>{"file"=>{"path"=>"/usr/share/logstash/workorder/reams_workorder2023_20230727.csv"}}, "@version"=>"1", "@timestamp"=>2023-12-27T16:46:29.350995137Z}], :response=>{"index"=>{"status"=>400, "error"=>{"type"=>"illegal_argument_exception", "reason"=>"unable to convert [0.0] to long", "caused_by"=>{"type"=>"number_format_exception", "reason"=>"For input string: \"0.0\""}}}}}
This data set has alot of columns so I'm not sure how exactly I can share my Index Template and Pipeline Template.
Data
1033407,NULL,0.0,0.0,0.0,2022-12-27 03:55:37.739,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:21:57.284,0,NULL,NULL,NULL,NULL,PWY_PQA,NULL,2023 PWY PQA 11-Daily BKP to HVW General Inspection,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008836,NULL,NULL,EN,2022-12-30 16:21:57.769,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,DTLMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,11.0,DAYS,0,0.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-09-13,NULL,2023-09-24,PM000000098428,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-27 03:55:38.364,126692,0,NULL,NULL,2023 PWY-ML-IS/02,NULL,NULL,2023-09-13 00:00:00.0,2023-09-13 00:00:00.0,NULL,0,DTL,NULL,NULL,APPR,2022-12-30 16:21:37.749,NULL,131758.0,0,NULL,2023-09-15 00:00:00.0,NULL,2023-09-11 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428623,0,WO00428623,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221
1033408,NULL,0.0,0.0,0.0,2022-12-27 03:55:39.197,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:21:57.831,0,NULL,NULL,NULL,NULL,PWY_PQA,NULL,2023 PWY PQA 11-Daily BKP to HVW General Inspection,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008836,NULL,NULL,EN,2022-12-30 16:21:58.315,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,DTLMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,11.0,DAYS,0,0.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-09-24,NULL,2023-10-05,PM000000098428,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-27 03:55:39.838,126692,0,NULL,NULL,2023 PWY-ML-IS/02,NULL,NULL,2023-09-24 00:00:00.0,2023-09-24 00:00:00.0,NULL,0,DTL,NULL,NULL,APPR,2022-12-30 16:21:37.749,NULL,131758.0,0,NULL,2023-09-26 00:00:00.0,NULL,2023-09-22 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428624,0,WO00428624,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221
1033409,NULL,0.0,0.0,0.0,2022-12-27 03:55:40.559,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:21:58.394,0,NULL,NULL,NULL,NULL,PWY_PQA,NULL,2023 PWY PQA 11-Daily BKP to HVW General Inspection,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008836,NULL,NULL,EN,2022-12-30 16:21:58.878,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,DTLMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,11.0,DAYS,0,0.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-10-05,NULL,2023-10-16,PM000000098428,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-27 03:55:41.184,126692,0,NULL,NULL,2023 PWY-ML-IS/02,NULL,NULL,2023-10-05 00:00:00.0,2023-10-05 00:00:00.0,NULL,0,DTL,NULL,NULL,APPR,2022-12-30 16:21:37.749,NULL,131758.0,0,NULL,2023-10-07 00:00:00.0,NULL,2023-10-03 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428625,0,WO00428625,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221
1033410,NULL,0.0,0.0,0.0,2022-12-27 03:55:41.903,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:21:58.94,0,NULL,NULL,NULL,NULL,PWY_PQA,NULL,2023 PWY PQA 11-Daily BKP to HVW General Inspection,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008836,NULL,NULL,EN,2022-12-30 16:21:59.425,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,DTLMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,11.0,DAYS,0,0.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-10-16,NULL,2023-10-27,PM000000098428,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-27 03:55:42.53,126692,0,NULL,NULL,2023 PWY-ML-IS/02,NULL,NULL,2023-10-16 00:00:00.0,2023-10-16 00:00:00.0,NULL,0,DTL,NULL,NULL,APPR,2022-12-30 16:21:37.749,NULL,131758.0,0,NULL,2023-10-18 00:00:00.0,NULL,2023-10-14 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428626,0,WO00428626,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221
Index
{
"index_patterns": [
"xxx-workorder-logs-*"
],
"template": {
"mappings": {
"_meta": {
"created_by": "file-data-visualizer"
},
"properties": {
"@timestamp": {
"type": "date",
"format": "strict_date_optional_time||yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd HH:mm:ss.SS||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.S"
},
"r_xxx_mms_ar_workorder_xt_actfinish": {
"type": "date",
"format": "strict_date_optional_time||yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd HH:mm:ss.SS||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.S"
},
"r_xxx_mms_ar_workorder_xt_actintlabhrs": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_actlabhrs": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_actoutlabhrs": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_actstart": {
"type": "date",
"format": "strict_date_optional_time||yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd HH:mm:ss.SS||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.S"
},
"r_xxx_mms_ar_workorder_xt_acttoolcost": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_ala_asset_id": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_amcrew": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_ams": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_aos": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_apptrequired": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_assetlocpriority": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_assetnum": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_assignedownergroup": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_availstatusdate": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_backoutplan": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_business_date": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_calccalendar": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_calcorgid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_calcpriority": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_calcshift": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_calendar": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_changeby": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_changedate": {
"type": "date",
"format": "strict_date_optional_time||yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd HH:mm:ss.SS||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.S"
},
"r_xxx_mms_ar_workorder_xt_chargestore": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_cinum": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_classstructureid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_commodity": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_commoditygroup": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_crewid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_crewworkgroup": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_dat_qlty": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_description": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_dirissuemtlstatus": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_disabled": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_downtime": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_environment": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks_ops": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_eqpt_failure": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_eqpt_failure_ops": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_estatapprintlabhrs": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_estatapprlabhrs": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_estatapproutlabhrs": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_estatapprtoolcost": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_estdur": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_estintlabhrs": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_estlabhrs": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_estoutlabhrs": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_esttoolcost": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_externalrefid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_faildate": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_failurecode": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_fdnum": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_fincntrlid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_firstapprstatus": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_flowaction": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_flowactionassist": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_flowcontrolled": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_flowid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_fnlconstraint": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_fromchainage": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_generatedforpo": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_genforpolineid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_genforporevision": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_haschildren": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_hasfollowupwork": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_hasld": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_historyflag": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_ifce_req": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_ifce_sender": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_ignorediavail": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_ignoresrmavail": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_inaccessible_remarks": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_inaccessible_time": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_inctasksinsched": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_ingestion_date": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_ingestion_time": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_inspector": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_interruptible": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_istask": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_jobtaskid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_jpnum": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_justifypriority": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_kpi_rpt_inputs": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_langcode": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_lastcopylinkdate": {
"type": "date",
"format": "strict_date_optional_time||yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd HH:mm:ss.SS||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.S"
},
"r_xxx_mms_ar_workorder_xt_launchentryname": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_lead": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_lms": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_location": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_los": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_maint_act_ty": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_measuredate": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_measurementvalue": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_nestedjpinprocess": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_newchildclass": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_newserialnum": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_observation": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_oldserialnum": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_onbehalfof": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_ops_rpt_inputs": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_ops_wkly_rpt_inputs": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_orgid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_origrecordclass": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_origrecordid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_outtoolcost": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_owner": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_ownergroup": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_ownersysid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_parent": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_parentchgsstatus": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_partchangeout": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_persongroup": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_pluscfrequency": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_pluscfrequnit": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_pluscismobile": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_pluscjprevnum": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_pluscloop": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_pluscnextdate": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_pluscoverduedate": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_pluscphyloc": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_pmcombpelactname": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_pmcombpelenabled": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_pmcombpelinprog": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_pmcomstate": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_pmcomtype": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_pmduedate": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_pmextdate": {
"type": "date",
"format": "strict_date_optional_time||yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd HH:mm:ss.SS||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.S"
},
"r_xxx_mms_ar_workorder_xt_pmnextduedate": {
"type": "date",
"format": "strict_date_optional_time||yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd HH:mm:ss.SS||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.S"
},
"r_xxx_mms_ar_workorder_xt_pmnum": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_pointnum": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_problemcode": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_reasonforchange": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_remdur": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_repairfacility": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_repfacsiteid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_reportdate": {
"type": "date",
"format": "strict_date_optional_time||yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd HH:mm:ss.SS||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.S"
},
"r_xxx_mms_ar_workorder_xt_reportedby": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_reqasstdwntime": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_respondby": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_risk": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_route": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_routestopid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_rptstatus": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_schedfinish": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_schedstart": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_sendersysid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_serviceaffect": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_siteid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_sneconstraint": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_sourcesysid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_status": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_statusdate": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_storeroommtlstatus": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_supervisor": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_suspendflow": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_sys_downtime": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_targcompdate": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_targetdesc": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_targstartdate": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_taskid": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_tochainage": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_user_schedfinish": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_user_schedstart": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_vendor": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_verification": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_whomischangefor": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_wo_downtime": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_wo_ptw_type": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_wo_tar_accesstype": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_woacceptscharges": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_woclass": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_wogroup": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_woisswap": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_wonum": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_wopriority": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_worklocation": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_workorderid": {
"type": "long"
},
"r_xxx_mms_ar_workorder_xt_workpackmtlstatus": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_worktype": {
"type": "keyword"
},
"r_xxx_mms_ar_workorder_xt_wosequence": {
"type": "keyword"
}
}
}
}
}
Pipeline
{
"description": "Ingest pipeline created by text structure finder",
"processors": [
{
"csv": {
"field": "message",
"target_fields": [
"r_xxx_mms_ar_workorder_xt_workorderid",
"r_xxx_mms_ar_workorder_xt_actfinish",
"r_xxx_mms_ar_workorder_xt_actintlabhrs",
"r_xxx_mms_ar_workorder_xt_actlabhrs",
"r_xxx_mms_ar_workorder_xt_actoutlabhrs",
"r_xxx_mms_ar_workorder_xt_actstart",
"r_xxx_mms_ar_workorder_xt_acttoolcost",
"r_xxx_mms_ar_workorder_xt_ala_asset_id",
"r_xxx_mms_ar_workorder_xt_amcrew",
"r_xxx_mms_ar_workorder_xt_ams",
"r_xxx_mms_ar_workorder_xt_aos",
"r_xxx_mms_ar_workorder_xt_apptrequired",
"r_xxx_mms_ar_workorder_xt_assetlocpriority",
"r_xxx_mms_ar_workorder_xt_assetnum",
"r_xxx_mms_ar_workorder_xt_assignedownergroup",
"r_xxx_mms_ar_workorder_xt_availstatusdate",
"r_xxx_mms_ar_workorder_xt_backoutplan",
"r_xxx_mms_ar_workorder_xt_calccalendar",
"r_xxx_mms_ar_workorder_xt_calcorgid",
"r_xxx_mms_ar_workorder_xt_calcpriority",
"r_xxx_mms_ar_workorder_xt_calcshift",
"r_xxx_mms_ar_workorder_xt_calendar",
"r_xxx_mms_ar_workorder_xt_changeby",
"r_xxx_mms_ar_workorder_xt_changedate",
"r_xxx_mms_ar_workorder_xt_chargestore",
"r_xxx_mms_ar_workorder_xt_cinum",
"r_xxx_mms_ar_workorder_xt_classstructureid",
"r_xxx_mms_ar_workorder_xt_commodity",
"r_xxx_mms_ar_workorder_xt_commoditygroup",
"r_xxx_mms_ar_workorder_xt_crewid",
"r_xxx_mms_ar_workorder_xt_crewworkgroup",
"r_xxx_mms_ar_workorder_xt_description",
"r_xxx_mms_ar_workorder_xt_dirissuemtlstatus",
"r_xxx_mms_ar_workorder_xt_disabled",
"r_xxx_mms_ar_workorder_xt_downtime",
"r_xxx_mms_ar_workorder_xt_environment",
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks",
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks_ops",
"r_xxx_mms_ar_workorder_xt_eqpt_failure",
"r_xxx_mms_ar_workorder_xt_eqpt_failure_ops",
"r_xxx_mms_ar_workorder_xt_estatapprintlabhrs",
"r_xxx_mms_ar_workorder_xt_estatapprlabhrs",
"r_xxx_mms_ar_workorder_xt_estatapproutlabhrs",
"r_xxx_mms_ar_workorder_xt_estatapprtoolcost",
"r_xxx_mms_ar_workorder_xt_estdur",
"r_xxx_mms_ar_workorder_xt_estintlabhrs",
"r_xxx_mms_ar_workorder_xt_estlabhrs",
"r_xxx_mms_ar_workorder_xt_estoutlabhrs",
"r_xxx_mms_ar_workorder_xt_esttoolcost",
"r_xxx_mms_ar_workorder_xt_externalrefid",
"r_xxx_mms_ar_workorder_xt_faildate",
"r_xxx_mms_ar_workorder_xt_failurecode",
"r_xxx_mms_ar_workorder_xt_fdnum",
"r_xxx_mms_ar_workorder_xt_fincntrlid",
"r_xxx_mms_ar_workorder_xt_firstapprstatus",
"r_xxx_mms_ar_workorder_xt_flowaction",
"r_xxx_mms_ar_workorder_xt_flowactionassist",
"r_xxx_mms_ar_workorder_xt_flowcontrolled",
"r_xxx_mms_ar_workorder_xt_fnlconstraint",
"r_xxx_mms_ar_workorder_xt_fromchainage",
"r_xxx_mms_ar_workorder_xt_generatedforpo",
"r_xxx_mms_ar_workorder_xt_genforpolineid",
"r_xxx_mms_ar_workorder_xt_genforporevision",
"r_xxx_mms_ar_workorder_xt_haschildren",
"r_xxx_mms_ar_workorder_xt_hasfollowupwork",
"r_xxx_mms_ar_workorder_xt_hasld",
"r_xxx_mms_ar_workorder_xt_historyflag",
"r_xxx_mms_ar_workorder_xt_ifce_req",
"r_xxx_mms_ar_workorder_xt_ifce_sender",
"r_xxx_mms_ar_workorder_xt_ignorediavail",
"r_xxx_mms_ar_workorder_xt_ignoresrmavail",
"r_xxx_mms_ar_workorder_xt_inaccessible_remarks",
"r_xxx_mms_ar_workorder_xt_inaccessible_time",
"r_xxx_mms_ar_workorder_xt_inctasksinsched",
"r_xxx_mms_ar_workorder_xt_inspector",
"r_xxx_mms_ar_workorder_xt_interruptible",
"r_xxx_mms_ar_workorder_xt_istask",
"r_xxx_mms_ar_workorder_xt_jobtaskid",
"r_xxx_mms_ar_workorder_xt_jpnum",
"r_xxx_mms_ar_workorder_xt_justifypriority",
"r_xxx_mms_ar_workorder_xt_kpi_rpt_inputs",
"r_xxx_mms_ar_workorder_xt_langcode",
"r_xxx_mms_ar_workorder_xt_lastcopylinkdate",
"r_xxx_mms_ar_workorder_xt_launchentryname",
"r_xxx_mms_ar_workorder_xt_lead",
"r_xxx_mms_ar_workorder_xt_lms",
"r_xxx_mms_ar_workorder_xt_location",
"r_xxx_mms_ar_workorder_xt_los",
"r_xxx_mms_ar_workorder_xt_maint_act_ty",
"r_xxx_mms_ar_workorder_xt_measuredate",
"r_xxx_mms_ar_workorder_xt_measurementvalue",
"r_xxx_mms_ar_workorder_xt_nestedjpinprocess",
"r_xxx_mms_ar_workorder_xt_newchildclass",
"r_xxx_mms_ar_workorder_xt_newserialnum",
"r_xxx_mms_ar_workorder_xt_observation",
"r_xxx_mms_ar_workorder_xt_oldserialnum",
"r_xxx_mms_ar_workorder_xt_onbehalfof",
"r_xxx_mms_ar_workorder_xt_ops_rpt_inputs",
"r_xxx_mms_ar_workorder_xt_ops_wkly_rpt_inputs",
"r_xxx_mms_ar_workorder_xt_orgid",
"r_xxx_mms_ar_workorder_xt_origrecordclass",
"r_xxx_mms_ar_workorder_xt_origrecordid",
"r_xxx_mms_ar_workorder_xt_outtoolcost",
"r_xxx_mms_ar_workorder_xt_owner",
"r_xxx_mms_ar_workorder_xt_ownergroup",
"r_xxx_mms_ar_workorder_xt_ownersysid",
"r_xxx_mms_ar_workorder_xt_parent",
"r_xxx_mms_ar_workorder_xt_parentchgsstatus",
"r_xxx_mms_ar_workorder_xt_partchangeout",
"r_xxx_mms_ar_workorder_xt_persongroup",
"r_xxx_mms_ar_workorder_xt_pluscfrequency",
"r_xxx_mms_ar_workorder_xt_pluscfrequnit",
"r_xxx_mms_ar_workorder_xt_pluscismobile",
"r_xxx_mms_ar_workorder_xt_pluscjprevnum",
"r_xxx_mms_ar_workorder_xt_pluscloop",
"r_xxx_mms_ar_workorder_xt_pluscnextdate",
"r_xxx_mms_ar_workorder_xt_pluscoverduedate",
"r_xxx_mms_ar_workorder_xt_pluscphyloc",
"r_xxx_mms_ar_workorder_xt_pmcombpelactname",
"r_xxx_mms_ar_workorder_xt_pmcombpelenabled",
"r_xxx_mms_ar_workorder_xt_pmcombpelinprog",
"r_xxx_mms_ar_workorder_xt_pmcomstate",
"r_xxx_mms_ar_workorder_xt_pmcomtype",
"r_xxx_mms_ar_workorder_xt_pmduedate",
"r_xxx_mms_ar_workorder_xt_pmextdate",
"r_xxx_mms_ar_workorder_xt_pmnextduedate",
"r_xxx_mms_ar_workorder_xt_pmnum",
"r_xxx_mms_ar_workorder_xt_pointnum",
"r_xxx_mms_ar_workorder_xt_problemcode",
"r_xxx_mms_ar_workorder_xt_reasonforchange",
"r_xxx_mms_ar_workorder_xt_remdur",
"r_xxx_mms_ar_workorder_xt_repairfacility",
"r_xxx_mms_ar_workorder_xt_repfacsiteid",
"r_xxx_mms_ar_workorder_xt_reportdate",
"r_xxx_mms_ar_workorder_xt_reportedby",
"r_xxx_mms_ar_workorder_xt_reqasstdwntime",
"r_xxx_mms_ar_workorder_xt_respondby",
"r_xxx_mms_ar_workorder_xt_risk",
"r_xxx_mms_ar_workorder_xt_route",
"r_xxx_mms_ar_workorder_xt_routestopid",
"r_xxx_mms_ar_workorder_xt_rptstatus",
"r_xxx_mms_ar_workorder_xt_schedfinish",
"r_xxx_mms_ar_workorder_xt_schedstart",
"r_xxx_mms_ar_workorder_xt_sendersysid",
"r_xxx_mms_ar_workorder_xt_serviceaffect",
"r_xxx_mms_ar_workorder_xt_siteid",
"r_xxx_mms_ar_workorder_xt_sneconstraint",
"r_xxx_mms_ar_workorder_xt_sourcesysid",
"r_xxx_mms_ar_workorder_xt_status",
"r_xxx_mms_ar_workorder_xt_statusdate",
"r_xxx_mms_ar_workorder_xt_storeroommtlstatus",
"r_xxx_mms_ar_workorder_xt_supervisor",
"r_xxx_mms_ar_workorder_xt_suspendflow",
"r_xxx_mms_ar_workorder_xt_sys_downtime",
"r_xxx_mms_ar_workorder_xt_targcompdate",
"r_xxx_mms_ar_workorder_xt_targetdesc",
"r_xxx_mms_ar_workorder_xt_targstartdate",
"r_xxx_mms_ar_workorder_xt_taskid",
"r_xxx_mms_ar_workorder_xt_tochainage",
"r_xxx_mms_ar_workorder_xt_user_schedfinish",
"r_xxx_mms_ar_workorder_xt_user_schedstart",
"r_xxx_mms_ar_workorder_xt_vendor",
"r_xxx_mms_ar_workorder_xt_verification",
"r_xxx_mms_ar_workorder_xt_whomischangefor",
"r_xxx_mms_ar_workorder_xt_wo_downtime",
"r_xxx_mms_ar_workorder_xt_wo_ptw_type",
"r_xxx_mms_ar_workorder_xt_wo_tar_accesstype",
"r_xxx_mms_ar_workorder_xt_woacceptscharges",
"r_xxx_mms_ar_workorder_xt_woclass",
"r_xxx_mms_ar_workorder_xt_wogroup",
"r_xxx_mms_ar_workorder_xt_woisswap",
"r_xxx_mms_ar_workorder_xt_wonum",
"r_xxx_mms_ar_workorder_xt_wopriority",
"r_xxx_mms_ar_workorder_xt_worklocation",
"r_xxx_mms_ar_workorder_xt_workpackmtlstatus",
"r_xxx_mms_ar_workorder_xt_worktype",
"r_xxx_mms_ar_workorder_xt_wosequence",
"r_xxx_mms_ar_workorder_xt_ingestion_time",
"r_xxx_mms_ar_workorder_xt_flowid",
"r_xxx_mms_ar_workorder_xt_dat_qlty",
"r_xxx_mms_ar_workorder_xt_ingestion_date",
"r_xxx_mms_ar_workorder_xt_business_date"
],
"ignore_missing": false
}
},
{
"date": {
"field": "r_xxx_mms_ar_workorder_xt_reportdate",
"timezone": "Asia/Singapore",
"formats": [
"strict_date_optional_time",
"yyyy-MM-dd HH:mm:ss.SSS",
"yyyy-MM-dd HH:mm:ss.SS",
"yyyy-MM-dd HH:mm:ss",
"yyyy-MM-dd HH:mm:ss.S"
]
}
},
{
"date": {
"field": "r_xxx_mms_ar_workorder_xt_reportdate",
"timezone": "Asia/Singapore",
"target_field": "r_xxx_mms_ar_workorder_xt_reportdate",
"formats": [
"strict_date_optional_time",
"yyyy-MM-dd HH:mm:ss.SSS",
"yyyy-MM-dd HH:mm:ss.SS",
"yyyy-MM-dd HH:mm:ss",
"yyyy-MM-dd HH:mm:ss.S"
]
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_actintlabhrs",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_actlabhrs",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_actoutlabhrs",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_acttoolcost",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_ams",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_aos",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_apptrequired",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_business_date",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_changeby",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_chargestore",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_disabled",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_downtime",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_eqpt_failure",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_eqpt_failure_ops",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_estatapprintlabhrs",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_estatapprlabhrs",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_estatapproutlabhrs",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_estatapprtoolcost",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_estdur",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_estintlabhrs",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_estlabhrs",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_estoutlabhrs",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_esttoolcost",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_flowactionassist",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_flowcontrolled",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_haschildren",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_hasfollowupwork",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_hasld",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_historyflag",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_ignorediavail",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_ignoresrmavail",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_inctasksinsched",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_ingestion_date",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_interruptible",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_istask",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_lms",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_los",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_nestedjpinprocess",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_outtoolcost",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_parentchgsstatus",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_partchangeout",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_pluscfrequency",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_pluscismobile",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_pluscjprevnum",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_pluscloop",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_reportedby",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_reqasstdwntime",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_serviceaffect",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_supervisor",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_suspendflow",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_woacceptscharges",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_woisswap",
"type": "long",
"ignore_missing": true
}
},
{
"convert": {
"field": "r_xxx_mms_ar_workorder_xt_workorderid",
"type": "long",
"ignore_missing": true
}
},
{
"remove": {
"field": "message"
}
}
]
}