#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
CSV2_1_FIELD_QUALIFIER_CHARACTER "$(CSV2_IN_FIELD_QUALIFIER_CHARACTER_CSV2_1)"
GUI OPTIONAL STRING_ENCODED CSV2_IN_FIELD_QUALIFIER_CHARACTER_CSV2_1 Field Qualifier Character:
DEFAULT_MACRO CSV2_IN_FIELD_QUALIFIER_ESCAPE_CHARACTER_CSV2_1
CSV2_1_FIELD_QUALIFIER_ESCAPE_CHARACTER "$(CSV2_IN_FIELD_QUALIFIER_ESCAPE_CHARACTER_CSV2_1)"
GUI OPTIONAL STRING_ENCODED CSV2_IN_FIELD_QUALIFIER_ESCAPE_CHARACTER_CSV2_1 Field Qualifier Escape Character:
DEFAULT_MACRO CSV2_IN_FIELD_NAMES_GROUP_CSV2_1
GUI OPTIONAL DISCLOSUREGROUP CSV2_IN_FIELD_NAMES_GROUP_CSV2_1 FME_DISCLOSURE_CLOSED%CSV2_IN_CASE_SENSITIVE_FIELD_NAMES_CSV2_1%CSV2_IN_ENFORCE_STRICT_SCHEMA_CSV2_1%CSV2_IN_TRIM_FIELD_NAME_WHITESPACE_CSV2_1 Field Names
DEFAULT_MACRO CSV2_IN_TRIM_FIELD_NAME_QUALIFIERS_CSV2_1 Yes
CSV2_1_TRIM_FIELD_NAME_QUALIFIERS "$(CSV2_IN_TRIM_FIELD_NAME_QUALIFIERS_CSV2_1)"
DEFAULT_MACRO CSV2_IN_CASE_SENSITIVE_FIELD_NAMES_CSV2_1 Yes
CSV2_1_CASE_SENSITIVE_FIELD_NAMES "$(CSV2_IN_CASE_SENSITIVE_FIELD_NAMES_CSV2_1)"
GUI CHOICE CSV2_IN_CASE_SENSITIVE_FIELD_NAMES_CSV2_1 Yes%No Case Sensitive Field Names:
DEFAULT_MACRO CSV2_IN_ENFORCE_STRICT_SCHEMA_CSV2_1 No
CSV2_1_ENFORCE_STRICT_SCHEMA "$(CSV2_IN_ENFORCE_STRICT_SCHEMA_CSV2_1)"
GUI CHOICE CSV2_IN_ENFORCE_STRICT_SCHEMA_CSV2_1 Yes%No Enforce Strict Schema:
DEFAULT_MACRO CSV2_IN_TRIM_FIELD_NAME_WHITESPACE_CSV2_1 Yes
CSV2_1_TRIM_FIELD_NAME_WHITESPACE "$(CSV2_IN_TRIM_FIELD_NAME_WHITESPACE_CSV2_1)"
GUI CHOICE CSV2_IN_TRIM_FIELD_NAME_WHITESPACE_CSV2_1 Yes%No Trim Whitespaces From Field Names:
DEFAULT_MACRO CSV2_IN_FIELD_VALUES_GROUP_CSV2_1
GUI OPTIONAL DISCLOSUREGROUP CSV2_IN_FIELD_VALUES_GROUP_CSV2_1 FME_DISCLOSURE_CLOSED%CSV2_IN_TRIM_FIELD_VALUE_QUALIFIERS_CSV2_1%CSV2_IN_READ_EMPTY_VALUES_AS_CSV2_1 Field Values
DEFAULT_MACRO CSV2_IN_READ_EMPTY_VALUES_AS_CSV2_1 Null
CSV2_1_READ_EMPTY_VALUES_AS "$(CSV2_IN_READ_EMPTY_VALUES_AS_CSV2_1)"
GUI CHOICE CSV2_IN_READ_EMPTY_VALUES_AS_CSV2_1 Missing%Null Read Empty Values As:
DEFAULT_MACRO CSV2_IN_TRIM_FIELD_VALUE_QUALIFIERS_CSV2_1 Yes
CSV2_1_TRIM_FIELD_VALUE_QUALIFIERS "$(CSV2_IN_TRIM_FIELD_VALUE_QUALIFIERS_CSV2_1)"
GUI CHOICE CSV2_IN_TRIM_FIELD_VALUE_QUALIFIERS_CSV2_1 Yes%No Trim Field Qualifier Characters:
DEFAULT_MACRO CSV2_IN_ENCODING_GROUP_CSV2_1
GUI OPTIONAL DISCLOSUREGROUP CSV2_IN_ENCODING_GROUP_CSV2_1 FME_DISCLOSURE_CLOSED%CSV2_IN_ENCODING_CSV2_1%CSV2_IN_PRESERVE_SOURCE_ENCODING_CSV2_1 Encoding
DEFAULT_MACRO CSV2_IN_ENCODING_CSV2_1 UTF-8
CSV2_1_ENCODING "$(CSV2_IN_ENCODING_CSV2_1)"
GUI STRING_OR_ENCODING CSV2_IN_ENCODING_CSV2_1 fme-system%* Character Encoding:
DEFAULT_MACRO CSV2_IN_PRESERVE_SOURCE_ENCODING_CSV2_1 No
CSV2_1_PRESERVE_SOURCE_ENCODING "$(CSV2_IN_PRESERVE_SOURCE_ENCODING_CSV2_1)"
GUI CHOICE CSV2_IN_PRESERVE_SOURCE_ENCODING_CSV2_1 Yes%No Preserve Source Encoding:
DEFAULT_MACRO CSV2_IN_SKIPPED_LINES_GROUP_CSV2_1
GUI OPTIONAL DISCLOSUREGROUP CSV2_IN_SKIPPED_LINES_GROUP_CSV2_1 FME_DISCLOSURE_CLOSED%CSV2_IN_READ_SKIPPED_LINES_CSV2_1 Skipped Lines
DEFAULT_MACRO CSV2_IN_READ_SKIPPED_LINES_CSV2_1 No
CSV2_1_READ_SKIPPED_LINES "$(CSV2_IN_READ_SKIPPED_LINES_CSV2_1)"
GUI CHOICE CSV2_IN_READ_SKIPPED_LINES_CSV2_1 Yes%No Read Skipped Lines:
DEFAULT_MACRO CSV2_IN_SCAN_MAX_ROWS_CSV2_1 10000
CSV2_1_SCAN_MAX_ROWS "$(CSV2_IN_SCAN_MAX_ROWS_CSV2_1)"
DEFAULT_MACRO CSV2_IN_SCAN_TYPES_CSV2_1 Yes
CSV2_1_SCAN_TYPES "$(CSV2_IN_SCAN_TYPES_CSV2_1)"
# ============================================================================
# Determines whether numeric attributes should be interpreted as bounded or unbounded
DEFAULT_MACRO CSV2_IN_TYPE_ATTRIBUTE_HANDLING_CSV2_1 STANDARD_TYPES
CSV2_1_TYPE_ATTRIBUTE_HANDLING "$(CSV2_IN_TYPE_ATTRIBUTE_HANDLING_CSV2_1)"
# ============================================================================
# Determines whether string attributes should be interpreted as bounded or unbounded
DEFAULT_MACRO CSV2_IN_STRING_TYPE_ATTRIBUTE_HANDLING_CSV2_1 EXPLICIT_WIDTH
CSV2_1_STRING_TYPE_ATTRIBUTE_HANDLING "$(CSV2_IN_STRING_TYPE_ATTRIBUTE_HANDLING_CSV2_1)"
DEFAULT_MACRO CSV2_IN_DATE_INPUT_FORMAT_CSV2_1 FME
CSV2_1_DATE_INPUT_FORMAT "$(CSV2_IN_DATE_INPUT_FORMAT_CSV2_1)"
DEFAULT_MACRO CSV2_IN_SCAN_ADDITIONAL_FIELDS_CSV2_1 No
CSV2_1_SCAN_ADDITIONAL_FIELDS "$(CSV2_IN_SCAN_ADDITIONAL_FIELDS_CSV2_1)"
DEFAULT_MACRO CSV2_IN_EXPOSE_ATTRS_GROUP_CSV2_1
CSV2_1_EXPOSE_ATTRS_GROUP "$(CSV2_IN_EXPOSE_ATTRS_GROUP_CSV2_1)"
DEFAULT_MACRO CSV2_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_CSV2_1 Yes
CSV2_1_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS "$(CSV2_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_CSV2_1)"
DEFAULT_MACRO CSV2_IN_CHUNK_SIZE_CSV2_1 100000
CSV2_1_CHUNK_SIZE "$(CSV2_IN_CHUNK_SIZE_CSV2_1)"
# ===========================================================================
DEFAULT_MACRO CSV2_IN_NETWORK_AUTHENTICATION_CSV2_1
CSV2_1_NETWORK_AUTHENTICATION "$(CSV2_IN_NETWORK_AUTHENTICATION_CSV2_1)"
GUI OPTIONAL AUTHENTICATOR CSV2_IN_NETWORK_AUTHENTICATION_CSV2_1 CONTAINER%GROUP%CONTAINER_TITLE%"Network Authentication"%PROMPT_TYPE%NETWORK Network Authentication
# ============================================================================
DEFAULT_MACRO CSV2_IN_ATTRIBUTE_READING_CSV2_1 DEFLINE
CSV2_1_ATTRIBUTE_READING "$(CSV2_IN_ATTRIBUTE_READING_CSV2_1)"
# ============================================================================
CSV2_1_GENERATE_FME_BUILD_NUM 21784
CSV2_1_DATASET "$(SourceDataset_CSV2_1)"
#! END_SOURCE_HEADER
#! START_WB_HEADER
MACRO WB_KEYWORD "AUTOMATIONS_1"
#! END_WB_HEADER
#! START_DEST_HEADER AUTOMATIONS AUTOMATIONS_1
#! END_DEST_HEADER
#! START_WB_HEADER
DEFAULT_MACRO DestDataset
INCLUDE [ if {"$(DestDataset)" != ""} { \
puts {DEFAULT_MACRO DestDataset_AUTOMATIONS_1 $(DestDataset)} \
} ]
#! END_WB_HEADER
#! START_DEST_HEADER AUTOMATIONS AUTOMATIONS_1
DEFAULT_MACRO DestDataset_AUTOMATIONS_1 NULL
DEFAULT_MACRO AUTOMATIONS_OUT_FME_GROUP_NAMED1_AUTOMATIONS_1
GUI OPTIONAL DISCLOSUREGROUP AUTOMATIONS_OUT_FME_GROUP_NAMED1_AUTOMATIONS_1 AUTOMATIONS_OUT_DEBUG_OUTPUT_DIRECTORY_AUTOMATIONS_1%AUTOMATIONS_OUT_DEBUG_AUTOMATION_ID_AUTOMATIONS_1%AUTOMATIONS_OUT_DEBUG_AUTOMATION_NODE_ID_AUTOMATIONS_1%AUTOMATIONS_OUT_DEBUG_JOB_ID_AUTOMATIONS_1%AUTOMATIONS_OUT_DEBUG_PORT_MAPPING_AUTOMATIONS_1 Debug Parameters
DEFAULT_MACRO AUTOMATIONS_OUT_DEBUG_OUTPUT_DIRECTORY_AUTOMATIONS_1
AUTOMATIONS_1_DEBUG_OUTPUT_DIRECTORY "$(AUTOMATIONS_OUT_DEBUG_OUTPUT_DIRECTORY_AUTOMATIONS_1)"
GUI OPTIONAL DIRNAME AUTOMATIONS_OUT_DEBUG_OUTPUT_DIRECTORY_AUTOMATIONS_1 Debug Output Folder:
DEFAULT_MACRO AUTOMATIONS_OUT_DEBUG_AUTOMATION_ID_AUTOMATIONS_1
AUTOMATIONS_1_DEBUG_AUTOMATION_ID "$(AUTOMATIONS_OUT_DEBUG_AUTOMATION_ID_AUTOMATIONS_1)"
GUI OPTIONAL TEXT_ENCODED AUTOMATIONS_OUT_DEBUG_AUTOMATION_ID_AUTOMATIONS_1 Automation ID:
DEFAULT_MACRO AUTOMATIONS_OUT_DEBUG_AUTOMATION_NODE_ID_AUTOMATIONS_1
AUTOMATIONS_1_DEBUG_AUTOMATION_NODE_ID "$(AUTOMATIONS_OUT_DEBUG_AUTOMATION_NODE_ID_AUTOMATIONS_1)"
GUI OPTIONAL TEXT_ENCODED AUTOMATIONS_OUT_DEBUG_AUTOMATION_NODE_ID_AUTOMATIONS_1 Automation Node ID:
DEFAULT_MACRO AUTOMATIONS_OUT_DEBUG_JOB_ID_AUTOMATIONS_1
AUTOMATIONS_1_DEBUG_JOB_ID "$(AUTOMATIONS_OUT_DEBUG_JOB_ID_AUTOMATIONS_1)"
GUI OPTIONAL TEXT_ENCODED AUTOMATIONS_OUT_DEBUG_JOB_ID_AUTOMATIONS_1 Job ID:
DEFAULT_MACRO AUTOMATIONS_OUT_DEBUG_PORT_MAPPING_AUTOMATIONS_1
AUTOMATIONS_1_DEBUG_PORT_MAPPING "$(AUTOMATIONS_OUT_DEBUG_PORT_MAPPING_AUTOMATIONS_1)"
GUI OPTIONAL TEXT_EDIT AUTOMATIONS_OUT_DEBUG_PORT_MAPPING_AUTOMATIONS_1 FME_SYNTAX%JAVASCRIPT%FME_NO_WHITESPACE&YES Port Mapping:
DEFAULT_MACRO AUTOMATIONS_OUT_FME_GROUP_NAMED2_AUTOMATIONS_1
GUI OPTIONAL DISCLOSUREGROUP AUTOMATIONS_OUT_FME_GROUP_NAMED2_AUTOMATIONS_1 AUTOMATIONS_OUT_COUNTER_CLOCKWISE_AREAS_AUTOMATIONS_1%AUTOMATIONS_OUT_WGS84_REPROJECTION_AUTOMATIONS_1%AUTOMATIONS_OUT_CUSTOM_CRS_NAME_AUTOMATIONS_1 Geometry
DEFAULT_MACRO AUTOMATIONS_OUT_COUNTER_CLOCKWISE_AREAS_AUTOMATIONS_1 Yes
AUTOMATIONS_1_COUNTER_CLOCKWISE_AREAS "$(AUTOMATIONS_OUT_COUNTER_CLOCKWISE_AREAS_AUTOMATIONS_1)"
GUI CHOICE AUTOMATIONS_OUT_COUNTER_CLOCKWISE_AREAS_AUTOMATIONS_1 Yes%No Convert Areas to Counterclockwise:
DEFAULT_MACRO AUTOMATIONS_OUT_WGS84_REPROJECTION_AUTOMATIONS_1 No
AUTOMATIONS_1_WGS84_REPROJECTION "$(AUTOMATIONS_OUT_WGS84_REPROJECTION_AUTOMATIONS_1)"
GUI CHOICE AUTOMATIONS_OUT_WGS84_REPROJECTION_AUTOMATIONS_1 Yes%No Reproject to WGS84:
DEFAULT_MACRO AUTOMATIONS_OUT_CUSTOM_CRS_NAME_AUTOMATIONS_1
AUTOMATIONS_1_CUSTOM_CRS_NAME "$(AUTOMATIONS_OUT_CUSTOM_CRS_NAME_AUTOMATIONS_1)"
GUI OPTIONAL TEXT_ENCODED AUTOMATIONS_OUT_CUSTOM_CRS_NAME_AUTOMATIONS_1 Custom CRS Name:
# ============================================================================
# Opt in for destination dataset type vs format type validation
DEFAULT_MACRO AUTOMATIONS_OUT_DESTINATION_DATASETTYPE_VALIDATION_AUTOMATIONS_1 Yes
AUTOMATIONS_1_DESTINATION_DATASETTYPE_VALIDATION "$(AUTOMATIONS_OUT_DESTINATION_DATASETTYPE_VALIDATION_AUTOMATIONS_1)"
# ============================================================================
AUTOMATIONS_1_GENERATE_FME_BUILD_NUM 22765
AUTOMATIONS_1_DATASET "$(DestDataset_AUTOMATIONS_1)"
#! END_DEST_HEADER
#! START_WB_HEADER
#! END_WB_HEADER
#! END_HEADER
LOG_FILENAME "$(FME_MF_DIR)TrafficWorkOrdersToProcess.log"
LOG_APPEND NO
LOG_FILTER_MASK -1
LOG_MAX_FEATURES 200
LOG_MAX_RECORDED_FEATURES 200
FME_REPROJECTION_ENGINE FME
FME_IMPLICIT_CSMAP_REPROJECTION_MODE Auto
FME_GEOMETRY_HANDLING Enhanced
FME_STROKE_MAX_DEVIATION 0
FME_NAMES_ENCODING UTF-8
FME_BULK_MODE_THRESHOLD
LAST_SAVE_BUILD "FME 2022.2.0.0 (20221103 - Build 22765 - WIN64)"
DEFAULT_MACRO DATASET_KEYWORD_CSV2_1 CSV2_1
DEFAULT_MACRO DATASET_KEYWORD_AUTOMATIONS_1 AUTOMATIONS_1
# -------------------------------------------------------------------------
CSV2_1_READER_META_ATTRIBUTES fme_feature_type
# -------------------------------------------------------------------------
CSV2_1_COORDINATE_SYSTEM LL84
MULTI_READER_CONTINUE_ON_READER_FAILURE No
# -------------------------------------------------------------------------
MACRO WORKSPACE_NAME TrafficWorkOrdersToProcess
MACRO FME_VIEWER_APP fmedatainspector
# -------------------------------------------------------------------------
FACTORY_DEF * RoutingFactory FACTORY_NAME "Router and Unexpected Input Remover" COMMAND_PARM_EVALUATION SINGLE_PASS MULTI_READER_KEYWORD $(DATASET_KEYWORD_CSV2_1) INPUT FEATURE_TYPE * ROUTE CSV2 CSV2_1::CSV multi_reader_keyword,$(DATASET_KEYWORD_CSV2_1) TO FME_GENERIC ::CSV ALIAS_GEOMETRY MERGE_INPUT Yes OUTPUT ROUTED FEATURE_TYPE *
CSV2_1_MERGE_DEF CSV2_1::CSV EXACT CSV DEFLINE fme_attribute_reading,defined,WorkOrderID,varchar13,Status,varchar12,AssetType,varchar36,AssetID,uint32,LocationID,varchar13,CreatedDate,varchar29,ModifiedDate,varchar29,SubmittedDate,varchar29,ClosedDate,varchar29,FiscalYear,uint32,WorkType,varchar15,WorkNeeded,varchar223,WorkTypeOther,varchar464,WorkRequestedBy,varchar35,JobDescription,varchar1032,ProblemFound,varchar598,ActionTaken,varchar2526,Follow-UpNeeded,varchar6,ChildWorkOrder,varchar13,ParentWorkOrder,varchar13,IsFollow-Up,varchar6,TMCIssueID,varchar13,ServiceRequest#,varchar13,DamageReport,varchar85,LocationName,varchar80,Latitude,varchar1,Longitude,varchar1,Location,varchar46
# -------------------------------------------------------------------------
FACTORY_DEF * TeeFactory FACTORY_NAME "CSV_CSV2_1 Splitter" INPUT FEATURE_TYPE CSV OUTPUT FEATURE_TYPE CSV_CSV2_1
DEFAULT_MACRO WB_CURRENT_CONTEXT
# -------------------------------------------------------------------------
# First determine which function we are going to be using -- we can do
# this statically at parse time for efficiency sake
MACRO GeometryReplacer_SetTempAttr
MACRO GeometryReplacer_Function
MACRO GeometryReplacer_RemoveTempAttr
MACRO GeometryReplacer_RemoveSourceAttr
INCLUDE [ set sourceText {@EvaluateExpression(FDIV,STRING_ENCODED,ValueLocation,GeometryReplacer)}; set decodedText [FME_DecodeText "$sourceText"]; if ![regexp {@EvaluateExpression\([^)]*STRING_ENCODED,@Value\(([^()]*)\),[^()]*\)} "$decodedText" dummy geomSrcAttr] { puts "MACRO GeometryReplacer_SetTempAttr @SupplyAttributes(ENCODED,__GeometryReplacerTemp__,\"$sourceText\")"; puts "MACRO GeometryReplacer_RemoveTempAttr @RemoveAttributes(__GeometryReplacerTemp__)"; set geomSrcAttr __GeometryReplacerTemp__; } elseif {{Yes} == {Yes} } { puts "MACRO GeometryReplacer_RemoveSourceAttr @RemoveAttributes(\"$geomSrcAttr\")"; }; if {{wkt} == {fmebinary} } { puts "MACRO GeometryReplacer_Function @Geometry(FROM_ATTRIBUTE_BINARY,\"$geomSrcAttr\")"; } elseif {{wkt} == {fmehex} } { puts "MACRO GeometryReplacer_Function @Geometry(FROM_ATTRIBUTE_BINARY_HEX,\"$geomSrcAttr\")"; } elseif {{wkt} == {fmexml} } { puts "MACRO GeometryReplacer_Function @Geometry(FROM_ATTRIBUTE,\"$geomSrcAttr\")"; } elseif {{wkt} == {fmexmlencoded} } { puts "MACRO GeometryReplacer_Function @Geometry(FROM_ENCODED_STRING,&\"$geomSrcAttr\")"; } elseif {{wkt} == {polyline} } { puts "MACRO GeometryReplacer_Function @Geometry(FROM_ATTRIBUTE_POLYLINE,\"$geomSrcAttr\")"; } elseif {{wkt} == {wkt} } { puts "MACRO GeometryReplacer_Function @OGCGeometry(from_attribute,wkt,\"$geomSrcAttr\",FLOAT_64)"; } elseif {{wkt} == {wkb} || {wkt} == {wkbhex} } { puts "MACRO GeometryReplacer_Function @OGCGeometry(from_attribute,wkt,\"$geomSrcAttr\")"; } elseif {{wkt} == {GEOJSON} || {wkt} == {ESRIJSON} } { puts "MACRO GeometryReplacer_Function @JSONGeometry(FROM_ATTRIBUTE,wkt,\"$geomSrcAttr\")"; } elseif {{wkt} == {GEORSS} } { puts "MACRO GeometryReplacer_Function @GeoRSSGeometry(FROM_ATTRIBUTE,\"$geomSrcAttr\")"; } elseif {{wkt} == {KML} } { puts "MACRO GeometryReplacer_Function @KMLGeometry(FROM_ATTRIBUTE,\"$geomSrcAttr\")"; } elseif {{wkt} == {GML} } { puts "MACRO GeometryReplacer_Function @GMLGeometry(FROM_ATTRIBUTE,\"$geomSrcAttr\",)"; } elseif {{wkt} == {geohash} } { puts "MACRO GeometryReplacer_Function @GeoHash(FROM_ATTRIBUTE,\"$geomSrcAttr\",)"; } elseif {{wkt} == {ogeosms} || {wkt} == {geosms} || {wkt} == {geo} } { puts "MACRO GeometryReplacer_Function @OGCGeometry(from_attribute,wkt,\"$geomSrcAttr\")"; } elseif {{wkt} == {mgrs}} { puts "MACRO GeometryReplacer_Function @MGRS(FROM_MGRS, , ,\"@EvaluateExpression(FDIV,STRING_ENCODED,ValueLocation,GeometryReplacer)\")" } elseif {{wkt} == {mssql} } { puts "MACRO GeometryReplacer_Function @SerializeGeometry(from_attribute,wkt,\"$geomSrcAttr\",)"; } elseif {{wkt} == {iso6709} } { puts "MACRO GeometryReplacer_Function @GeographicPoint(FROM_ATTRIBUTE,\"$geomSrcAttr\")"; } elseif {{wkt} == {qlikmaps} } { puts "MACRO GeometryReplacer_Function @Geometry(FROM_ATTRIBUTE_QLIKMAPS_POLYLINE,\"$geomSrcAttr\")"; }; ]
FACTORY_DEF {*} TeeFactory FACTORY_NAME { GeometryReplacer } INPUT FEATURE_TYPE CSV_CSV2_1 OUTPUT { FEATURE_TYPE ___TOREJECTOR___ @RenameAttributes(FME_STRICT,___fme_rejection_code___,fme_rejection_code) $(GeometryReplacer_SetTempAttr) $(GeometryReplacer_Function) $(GeometryReplacer_RemoveTempAttr) }
FACTORY_DEF {*} TestFactory FACTORY_NAME { GeometryReplacer_Rejector } INPUT FEATURE_TYPE ___TOREJECTOR___ TEST @Value(fme_rejection_code) != "" OUTPUT { PASSED FEATURE_TYPE GeometryReplacer_ @RemoveAttributes(___fme_rejection_code___) } OUTPUT { FAILED FEATURE_TYPE GeometryReplacer_OUTPUT @RenameAttributes(FME_STRICT,fme_rejection_code,___fme_rejection_code___) $(GeometryReplacer_RemoveSourceAttr) }
DEFAULT_MACRO _WB_BYPASS_TERMINATION No
FACTORY_DEF * TeeFactory FACTORY_NAME GeometryReplacer_ INPUT FEATURE_TYPE GeometryReplacer_ NO_LOGGING OUTPUT FAILED FEATURE_TYPE * @Abort(ENCODED, GeometryReplaceroutputaRejectedfeature.TocontinuetranslationwhenfeaturesarerejectedchangeWorkspaceParametersTranslationRejectedFeatureHandlingtoContinueTranslation)
# -------------------------------------------------------------------------
FACTORY_DEF {*} TestFactory FACTORY_NAME { Tester } INPUT FEATURE_TYPE GeometryReplacer_OUTPUT TEST { "@EvaluateExpression(FDIV,STRING_ENCODED,ValueStatus,Tester)" = Submitted ENCODED } TEST { "@EvaluateExpression(FDIV,STRING_ENCODED,ValueAssetType,Tester)" = SchoolBeaconZone ENCODED } TEST { "@EvaluateExpression(FDIV,STRING_ENCODED,ValueAssetType,Tester)" = SchoolBeacon ENCODED } BOOLEAN_OPERATOR { COMPOSITE } COMPOSITE_TEST_EXPR { "1 AND ( 2 OR 3 )" } FEATURE_TABLE_SHIM_SUPPORT Yes PRESERVE_FEATURE_ORDER { PER_OUTPUT_PORT } OUTPUT { PASSED FEATURE_TYPE Tester_PASSED }
# -------------------------------------------------------------------------
FACTORY_DEF {*} AttributeKeeperFactory FACTORY_NAME { AttributeKeeper } INPUT FEATURE_TYPE Tester_PASSED KEEP_ATTRS { AssetID,AssetType,ServiceRequest#,WorkNeeded,WorkOrderID,WorkType,Location,JobDescription,ProblemFound } KEEP_LISTS { } KEEP_FME_ATTRIBUTES Yes BUILD_FEATURE_TABLES { NO } OUTPUT_ON_ATTRIBUTE_CHANGE { } OUTPUT { OUTPUT FEATURE_TYPE AttributeKeeper_OUTPUT }
# -------------------------------------------------------------------------
INCLUDE [ puts {DEFAULT_MACRO FeatureWriterDataset_FeatureWriter @EvaluateExpression(FDIV,STRING_ENCODED,$(FME_SHAREDRESOURCE_DATA$encode)workorders.sqlite,FeatureWriter)}; ]
FACTORY_DEF {*} WriterFactory COMMAND_PARM_EVALUATION SINGLE_PASS FEATURE_TABLE_SHIM_SUPPORT INPUT_SPEC_ONLY FLUSH_WHEN_GROUPS_CHANGE { } FACTORY_NAME { FeatureWriter } WRITER_TYPE { SPATIALITE_NATIVE } WRITER_DATASET { "$(FeatureWriterDataset_FeatureWriter)" } WRITER_SETTINGS { "RUNTIME_MACROS,OVERWRITE_FILENoDATASET_TEMPLATEDESTINATION_DATASETTYPE_VALIDATIONYesSPATIAL_TABLE_CREATIONSPATIAL_COLUMN_NAMESRIDDIMENSIONAUTOCOMPRESS_GEOMETRYNOCREATE_SPATIAL_INDEXYESADVANCEDWRITER_MODEINSERTTRANSACTION_INTERVAL500BEGIN_SQL0END_SQL0COORDINATE_SYSTEM_GRANULARITYFEATURE_TYPESUPPORT_INTERNATIONALIZATIONYESENCODINGutf-8,METAFILE,SPATIALITE_NATIVE" } WRITER_METAFILE { "ATTRIBUTE_CASE,ANY,ATTRIBUTE_INVALID_CHARS,,ATTRIBUTE_LENGTH,255,ATTR_TYPE_MAP,integerfme_int64integerfme_int32integerfme_uint32integerfme_int16integerfme_uint16integerfme_booleanintegerfme_int8integerfme_uint8textfme_buffertextfme_xmltextfme_jsonblobfme_binarybufferblobfme_varbinarywidthblobfme_binarywidthtextfme_datetimetextfme_datetextfme_timedoublefme_real64floatfme_real64floatfme_real32varcharwidthfme_varchar