#! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! GUI IGNORE SourceDataset_IDRISI_1,IDRISI_IN_SEARCH_ENVELOPE_MINX_IDRISI_1,IDRISI_IN_SEARCH_ENVELOPE_MINY_IDRISI_1,IDRISI_IN_SEARCH_ENVELOPE_MAXX_IDRISI_1,IDRISI_IN_SEARCH_ENVELOPE_MAXY_IDRISI_1,IDRISI_IN_CLIP_TO_ENVELOPE_IDRISI_1,SEARCH_ENVELOPE_COORDINATE_SYSTEM_IDRISI_1,DestDataset_ORACLE8I_1,ORACLE8I_OUT_USER_NAME_ORACLE8I_1,ORACLE8I_OUT_PASSWORD_ORACLE8I_1,_START_TRANSACTION_ORACLE8I_1,_CHUNK_SIZE_ORACLE8I_1,_TRANSACTION_INTERVAL_ORACLE8I_1,_BEGIN_SQL_ORACLE8I_1,_END_SQL_ORACLE8I_1,_STRICT_ATTR_CONVERSION_ORACLE8I_1,_WRITER_MODE_ORACLE8I_1,_ORACLE8I_Workspace_ORACLE8I_1,_ORACLE8I_OUT_HANDLE_MULTIPLE_SPATIAL_COLUMNS_ORACLE8I_1 DEFAULT_MACRO SourceDataset_IDRISI C:\FMEData\Data\Emergency\e911_facilities.vct GUI MULTIFILE SourceDataset_IDRISI IDRISI_Vector_Files(*.vct)|*.vct|IDRISI_Link_Files(*.vlx)|*.vlx|All_Files|*.* Source IDRISI Vector Format File(s): DEFAULT_MACRO DestDataset_ORACLE8I bpmal GUI TEXT DestDataset_ORACLE8I Destination Oracle Spatial Object Service: INCLUDE TCL proc __FME_ExpandMacros {text {maxlevels 100}} { if { $maxlevels <= 0 } { return $text; } set pattern [join {{\$} {\([^()$]*\)}} {}] set indices [regexp -inline -all -indices $pattern $text] if [llength $indices] { foreach pair [lreverse $indices] { lassign $pair start end set replacement {} set replacement $::FME_MacroValues([string range $text [expr $start + 2] [expr $end - 1]]) set text [string replace $text $start $end $replacement] } return [__FME_ExpandMacros $text [expr $maxlevels - 1]] } return $text } proc __FME_ExpandEnvVars {text {maxlevels 100}} { if { $maxlevels <= 0 } { return $text; } set pattern [join {{\$} {\{[^\{\}$]*\}}} {}] set indices [regexp -inline -all -indices $pattern $text] if [llength $indices] { foreach pair [lreverse $indices] { lassign $pair start end set replacement {} set replacement $::env([string range $text [expr $start + 2] [expr $end - 1]]) set text [string replace $text $start $end $replacement] } return [__FME_ExpandEnvVars $text [expr $maxlevels - 1]] } return $text } proc __FME_EvalAndEncodeMacro {macroName} { set macroVal {} catch { set macroVal [__FME_ExpandMacros $::FME_MacroValues($macroName)] } catch { set macroVal [__FME_ExpandEnvVars $macroVal] } return [FME_EncodeText $macroVal] } END_INCLUDE INCLUDE [ puts "MACRO SourceDataset_IDRISI__FMEENCODED__ [__FME_EvalAndEncodeMacro SourceDataset_IDRISI]" ; ] INCLUDE [ puts "MACRO DestDataset_ORACLE8I__FMEENCODED__ [__FME_EvalAndEncodeMacro DestDataset_ORACLE8I]" ; ] INCLUDE [ if {{$(SourceDataset_IDRISI)} == {}} { puts_real {Parameter 'SourceDataset_IDRISI' must be given a value.}; exit 1; }; ] INCLUDE [ if {{$(DestDataset_ORACLE8I)} == {}} { puts_real {Parameter 'DestDataset_ORACLE8I' must be given a value.}; exit 1; }; ] #! START_HEADER #! START_WB_HEADER READER_TYPE IDRISI READER_KEYWORD IDRISI_1 READER_GEN_DIRECTIVES IDRISI_EXPOSE_FORMAT_ATTRS,,SEARCH_ENVELOPE_MAXX,0,CLIP_TO_ENVELOPE,NO,USE_SEARCH_ENVELOPE,NO,SEARCH_ENVELOPE_MINX,0,SEARCH_ENVELOPE_MINY,0,_MERGE_SCHEMAS,YES,SEARCH_ENVELOPE_MAXY,0 WRITER_TYPE ORACLE8I WRITER_KEYWORD ORACLE8I_1 #! END_WB_HEADER #! START_WB_HEADER MACRO WB_KEYWORD "IDRISI_1" #! END_WB_HEADER #! START_SOURCE_HEADER IDRISI IDRISI_1 # ============================================================================ # The following GUI line prompts for a directory to be used as the # source of the IDRISI files. # The user input is stored in a macro, which is then used to define # the dataset to be read. # The dataset this mapping file was generated from was: #! END_SOURCE_HEADER #! START_WB_HEADER DEFAULT_MACRO SourceDataset INCLUDE [ if {{$(SourceDataset)} != ""} { \ puts {DEFAULT_MACRO SourceDataset_IDRISI_1 $(SourceDataset)} \ } ] #! END_WB_HEADER #! START_SOURCE_HEADER IDRISI IDRISI_1 DEFAULT_MACRO SourceDataset_IDRISI_1 $(SourceDataset_IDRISI) GUI MULTIFILE SourceDataset_IDRISI_1 IDRISI_Vector_Files(*.vct)|*.vct|IDRISI_Link_Files(*.vlx)|*.vlx|All_Files|*.* Source IDRISI Vector Format File(s): # Include this file in source setting section to add external search envelope processing # Zero as a default means we don't do any search -- this makes workbench happier # =========================================================================== DEFAULT_MACRO IDRISI_IN_SEARCH_ENVELOPE_MINX_IDRISI_1 0 IDRISI_1_SEARCH_ENVELOPE "$(IDRISI_IN_SEARCH_ENVELOPE_MINX_IDRISI_1)" GUI OPTIONAL FLOAT IDRISI_IN_SEARCH_ENVELOPE_MINX_IDRISI_1 Minimum X: # =========================================================================== DEFAULT_MACRO IDRISI_IN_SEARCH_ENVELOPE_MINY_IDRISI_1 0 IDRISI_1_SEARCH_ENVELOPE "$(IDRISI_IN_SEARCH_ENVELOPE_MINY_IDRISI_1)" GUI OPTIONAL FLOAT IDRISI_IN_SEARCH_ENVELOPE_MINY_IDRISI_1 Minimum Y: # =========================================================================== DEFAULT_MACRO IDRISI_IN_SEARCH_ENVELOPE_MAXX_IDRISI_1 0 IDRISI_1_SEARCH_ENVELOPE "$(IDRISI_IN_SEARCH_ENVELOPE_MAXX_IDRISI_1)" GUI OPTIONAL FLOAT IDRISI_IN_SEARCH_ENVELOPE_MAXX_IDRISI_1 Maximum X: # =========================================================================== DEFAULT_MACRO IDRISI_IN_SEARCH_ENVELOPE_MAXY_IDRISI_1 0 IDRISI_1_SEARCH_ENVELOPE "$(IDRISI_IN_SEARCH_ENVELOPE_MAXY_IDRISI_1)" GUI OPTIONAL FLOAT IDRISI_IN_SEARCH_ENVELOPE_MAXY_IDRISI_1 Maximum Y: # =========================================================================== # BUG18999: We now have a soft clip to fall back on like native spatial index # thus we are reintroducing the clip to envelop as an option for users. # Defualt to soft clip as per the existing database readers we are emulating DEFAULT_MACRO IDRISI_IN_CLIP_TO_ENVELOPE_IDRISI_1 NO IDRISI_1_CLIP_TO_ENVELOPE "$(IDRISI_IN_CLIP_TO_ENVELOPE_IDRISI_1)" GUI OPTIONAL CHECKBOX IDRISI_IN_CLIP_TO_ENVELOPE_IDRISI_1 YES%NO Clip to Search Envelope # PR:31021 # Include this file in workbench source preamble section to enable the ability # to specify a coordinate system for search envelope processing # =========================================================================== DEFAULT_MACRO SEARCH_ENVELOPE_COORDINATE_SYSTEM_IDRISI_1 GUI OPTIONAL COORDSYS SEARCH_ENVELOPE_COORDINATE_SYSTEM_IDRISI_1 Search Envelope Coordinate System: IDRISI_1_SEARCH_ENVELOPE_COORDINATE_SYSTEM "$(SEARCH_ENVELOPE_COORDINATE_SYSTEM_IDRISI_1)" # =========================================================================== IDRISI_1_DATASET "$(SourceDataset_IDRISI_1)" #! END_SOURCE_HEADER #! START_WB_HEADER MACRO WB_KEYWORD "ORACLE8I_1" #! END_WB_HEADER #! START_DEST_HEADER ORACLE8I ORACLE8I_1 # ============================================================================ # The following GUI line prompts for the name of the Oracle Service # to which data will be written. #! END_DEST_HEADER #! START_WB_HEADER DEFAULT_MACRO DestDataset INCLUDE [ if {"$(DestDataset)" != ""} { \ puts {DEFAULT_MACRO DestDataset_ORACLE8I_1 $(DestDataset)} \ } ] #! END_WB_HEADER #! START_DEST_HEADER ORACLE8I ORACLE8I_1 DEFAULT_MACRO DestDataset_ORACLE8I_1 $(DestDataset_ORACLE8I) GUI TEXT DestDataset_ORACLE8I_1 Destination Oracle Spatial Object Service: DEFAULT_MACRO _ORACLE8I_Tolx_ORACLE8I_1 0.05 DEFAULT_MACRO _ORACLE8I_Toly_ORACLE8I_1 0.05 DEFAULT_MACRO _ORACLE8I_Tolz_ORACLE8I_1 0.05 DEFAULT_MACRO _ORACLE8I_Tolm_ORACLE8I_1 0.05 DEFAULT_MACRO _ORACLE8I_CreationParams_ORACLE8I_1 DEFAULT_MACRO _ORACLE8I_SRID_ORACLE8I_1 DEFAULT_MACRO _ORACLE8I_SpatialIndexName_ORACLE8I_1 DEFAULT_MACRO _ORACLE8I_ForceIndexCreation_ORACLE8I_1 No DEFAULT_MACRO _ORACLE8I_TargetGeometryColumn_ORACLE8I_1 DEFAULT_MACRO _ORACLE8I_UpdateGeometry_ORACLE8I_1 Yes DEFAULT_MACRO _ORACLE8I_DropTable_ORACLE8I_1 No DEFAULT_MACRO _ORACLE8I_TruncateTable_ORACLE8I_1 No DEFAULT_MACRO _ORACLE8I_Measures_ORACLE8I_1 No DEFAULT_MACRO _ORACLE8I_CustomSQL_ORACLE8I_1 DEFAULT_MACRO _ORACLE8I_SequencedColumns_ORACLE8I_1 ORACLE8I_1_SERVER_TYPE ORACLE8i # ============================================================================ # ============================================================================ # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_USER_NAME_ORACLE8I_1 robyn ORACLE8I_1_USER_NAME "$(ORACLE8I_OUT_USER_NAME_ORACLE8I_1)" GUI OPTIONAL TEXT ORACLE8I_OUT_USER_NAME_ORACLE8I_1 Username: # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_PASSWORD_ORACLE8I_1 robyn ORACLE8I_1_PASSWORD "$(ORACLE8I_OUT_PASSWORD_ORACLE8I_1)" GUI OPTIONAL PASSWORD ORACLE8I_OUT_PASSWORD_ORACLE8I_1 Password: # ============================================================================ # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_DIMENSION_ORACLE8I_1 2 ORACLE8I_1_DIMENSION "$(ORACLE8I_OUT_DIMENSION_ORACLE8I_1)" # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_CONTAINS_MEASURES_ORACLE8I_1 NO ORACLE8I_1_CONTAINS_MEASURES "$(ORACLE8I_OUT_CONTAINS_MEASURES_ORACLE8I_1)" # cannot use LOOKUP_GLOBAL here because it assumes any parameter set to 0 in the destination # parameters are parameters that was not set and prevent user from performing translations # in UT # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MINX_ORACLE8I_1 -180 ORACLE8I_1_SPATIAL_INDEX_MINX "$(ORACLE8I_OUT_SPATIAL_INDEX_MINX_ORACLE8I_1)" # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MINY_ORACLE8I_1 -90 ORACLE8I_1_SPATIAL_INDEX_MINY "$(ORACLE8I_OUT_SPATIAL_INDEX_MINY_ORACLE8I_1)" # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MINZ_ORACLE8I_1 0 ORACLE8I_1_SPATIAL_INDEX_MINZ "$(ORACLE8I_OUT_SPATIAL_INDEX_MINZ_ORACLE8I_1)" # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MINM_ORACLE8I_1 0 ORACLE8I_1_SPATIAL_INDEX_MINM "$(ORACLE8I_OUT_SPATIAL_INDEX_MINM_ORACLE8I_1)" # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MAXX_ORACLE8I_1 180 ORACLE8I_1_SPATIAL_INDEX_MAXX "$(ORACLE8I_OUT_SPATIAL_INDEX_MAXX_ORACLE8I_1)" # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MAXY_ORACLE8I_1 90 ORACLE8I_1_SPATIAL_INDEX_MAXY "$(ORACLE8I_OUT_SPATIAL_INDEX_MAXY_ORACLE8I_1)" # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MAXZ_ORACLE8I_1 0 ORACLE8I_1_SPATIAL_INDEX_MAXZ "$(ORACLE8I_OUT_SPATIAL_INDEX_MAXZ_ORACLE8I_1)" # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MAXM_ORACLE8I_1 0 ORACLE8I_1_SPATIAL_INDEX_MAXM "$(ORACLE8I_OUT_SPATIAL_INDEX_MAXM_ORACLE8I_1)" # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_GEOMETRY_COLUMN_ORACLE8I_1 GEOM ORACLE8I_1_GEOMETRY_COLUMN "$(ORACLE8I_OUT_GEOMETRY_COLUMN_ORACLE8I_1)" # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_CREATE_SPATIAL_INDEX_ORACLE8I_1 no ORACLE8I_1_CREATE_SPATIAL_INDEX "$(ORACLE8I_OUT_CREATE_SPATIAL_INDEX_ORACLE8I_1)" # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_INDEX_LEVELS_ORACLE8I_1 0 ORACLE8I_1_INDEX_LEVELS "$(ORACLE8I_OUT_INDEX_LEVELS_ORACLE8I_1)" # ============================================================================ DEFAULT_MACRO ORACLE8I_OUT_NUMBER_OF_TILES_ORACLE8I_1 8 ORACLE8I_1_NUMBER_OF_TILES "$(ORACLE8I_OUT_NUMBER_OF_TILES_ORACLE8I_1)" # ============================================================================ # The following option specifies which feature number the writer should actually # start writing features to the database on. This should normally be zero, but # can be changed if a previous translation is interrupted. DEFAULT_MACRO _START_TRANSACTION_ORACLE8I_1 0 GUI INTEGER _START_TRANSACTION_ORACLE8I_1 Transaction To Start Writing At: ORACLE8I_1_START_TRANSACTION $(_START_TRANSACTION_ORACLE8I_1) # ============================================================================ # The following specifies how many features will be written to the database in # on each bulk write. DEFAULT_MACRO _CHUNK_SIZE_ORACLE8I_1 200 GUI INTEGER _CHUNK_SIZE_ORACLE8I_1 Features Per Bulk Write: ORACLE8I_1_CHUNK_SIZE $(_CHUNK_SIZE_ORACLE8I_1) # ============================================================================ # The following specifies how many features will be written to the database in # each transaction. DEFAULT_MACRO _TRANSACTION_INTERVAL_ORACLE8I_1 1000 GUI INTEGER _TRANSACTION_INTERVAL_ORACLE8I_1 Features To Write Per Transaction: ORACLE8I_1_TRANSACTION_INTERVAL $(_TRANSACTION_INTERVAL_ORACLE8I_1) # ============================================================================ # The following specifies an SQL command to execute before opening the first # ORACLE table. DEFAULT_MACRO _BEGIN_SQL_ORACLE8I_1 GUI OPTIONAL TEXT_EDIT_SQL _BEGIN_SQL_ORACLE8I_1 SQL Statement To Execute Before Translation: ORACLE8I_1_BEGIN_SQL{0} "$(_BEGIN_SQL_ORACLE8I_1)" # ============================================================================ # The following specifies an SQL command to execute after closing all the # ORACLE tables. DEFAULT_MACRO _END_SQL_ORACLE8I_1 GUI OPTIONAL TEXT_EDIT_SQL _END_SQL_ORACLE8I_1 SQL Statement To Execute After Translation: ORACLE8I_1_END_SQL{0} "$(_END_SQL_ORACLE8I_1)" # ============================================================================== # The following specifies whether rows written to the writer's tables have # to adhere strictly to the destination feature type. When 'No' or 'Warn', # character columns are truncated to fit and other conversion problems end up # inserting NULL values; if STRICT_ATTR_CONVERSION is 'Yes', rows containing # such problems will be logged and not written to the tables. DEFAULT_MACRO _STRICT_ATTR_CONVERSION_ORACLE8I_1 No GUI OPTIONAL CHOICE _STRICT_ATTR_CONVERSION_ORACLE8I_1 Yes%No%Warn Enforce strict attribute conversion: ORACLE8I_1_STRICT_ATTR_CONVERSION "$(_STRICT_ATTR_CONVERSION_ORACLE8I_1)" # ============================================================================ # The following specifies the mode of the writer DEFAULT_MACRO _WRITER_MODE_ORACLE8I_1 INSERT GUI OPTIONAL CHOICE _WRITER_MODE_ORACLE8I_1 INSERT%UPDATE%DELETE Writer Mode: ORACLE8I_1_WRITER_MODE "$(_WRITER_MODE_ORACLE8I_1)" # ============================================================================ # The following specifies the name of the Oracle Workspace that we should go # to when writing tables. DEFAULT_MACRO _ORACLE8I_Workspace_ORACLE8I_1 GUI OPTIONAL TEXT _ORACLE8I_Workspace_ORACLE8I_1 Oracle Workspace: ORACLE8I_1_WORKSPACE "$(_ORACLE8I_Workspace_ORACLE8I_1)" # ============================================================================ # The following specifies whether to maintain multiple geometries or not. # If set to YES, the Multiple Geometries will be read into an aggregate # If NO, the default behavior of selecting one geometry will occur DEFAULT_MACRO _ORACLE8I_OUT_HANDLE_MULTIPLE_SPATIAL_COLUMNS_ORACLE8I_1 NO GUI CHOICE _ORACLE8I_OUT_HANDLE_MULTIPLE_SPATIAL_COLUMNS_ORACLE8I_1 YES%NO Handle Multiple Spatial Columns: ORACLE8I_1_HANDLE_MULTIPLE_SPATIAL_COLUMNS $(_ORACLE8I_OUT_HANDLE_MULTIPLE_SPATIAL_COLUMNS_ORACLE8I_1) ORACLE8I_1_DATASET "$(DestDataset_ORACLE8I_1)" #! END_DEST_HEADER #! END_HEADER LOG_FILENAME "$(FME_MF_DIR)AttributeFileReader.log" LOG_APPEND NO LOG_MAX_FEATURES 200 LOG_MAX_RECORDED_FEATURES 200 FME_REPROJECTION_ENGINE FME FME_GEOMETRY_HANDLING Enhanced FME_STROKE_MAX_DEVIATION 0 LOG_FILTER_MASK -1 DEFAULT_MACRO DATASET_KEYWORD_IDRISI_1 IDRISI_1 DEFAULT_MACRO DATASET_KEYWORD_ORACLE8I_1 ORACLE8I_1 # ------------------------------------------------------------------------- IDRISI_1_READER_META_ATTRIBUTES fme_feature_type # ------------------------------------------------------------------------- MULTI_READER_CONTINUE_ON_READER_FAILURE No # ------------------------------------------------------------------------- MACRO WORKSPACE_NAME AttributeFileReader MACRO FME_VIEWER_APP fmeview # ------------------------------------------------------------------------- INCLUDE [ if {[info exists env(TEMP)]} {set gVisualizerTemp $env(TEMP)} elseif { $tcl_platform(platform) == "unix" } {set gVisualizerTemp "/tmp"} else {set gVisualizerTemp c:}; regsub -all {[ ,&]} {$(WORKSPACE_NAME)} {_} wsname; set gVisualizerTemp $gVisualizerTemp/${wsname}_[clock format [clock seconds] -format %H%M%S]; puts "MACRO WORKSPACE_TEMP_DIR $gVisualizerTemp"; MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/inspector.ffs MACRO VISUALIZER_CREATE_SPATIAL_INDEX YES # ------------------------------------------------------------------------- IDRISI_1_DEF e911_facilities IDRISI_TYPE idrisi_point IDR_ID0 integer IDR_ID integer ADDRESS char(40) NAME char(40) FACILITY char(50) TYPE_ double STATUS char(16) STA_NUM char(3) COMMAND char(16) ENTITY char(26) PROP_DATE char(8) FACILITY2 char(16) COLOCATE char(5) NAME2 char(25) UNIT char(35) GAATN char(16) LADDER char(16) X_COORD double Y_COORD double SECTORS_ char(16) JURIS_ char(16) NAME_FULL char(30) # ------------------------------------------------------------------------- Lookup ___KnownFeatureTypes___ e911_facilities yes "" no # ------------------------------------------------------------------------- FACTORY_DEF * TestFactory FACTORY_NAME "Unexpected Input Remover" INPUT FEATURE_TYPE * TEST @Lookup(___KnownFeatureTypes___,@FeatureType()) == yes OUTPUT PASSED FEATURE_TYPE * # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "Source -> Generic" INPUT FEATURE_TYPE * OUTPUT FEATURE_TYPE * @Transform(IDRISI,FME_GENERIC,PRESERVE_GEOMETRY) DEFAULT_MACRO WB_CURRENT_CONTEXT # ------------------------------------------------------------------------- Tcl2 proc a56a978a_c11c_4d8e_aeef_116c706214254_doSetAttr {attrText} { FME_SetAttribute [FME_DecodeText {PHOTO_FILE_NAME}] [FME_DecodeText $attrText] } FACTORY_DEF * TeeFactory FACTORY_NAME StringConcatenator INPUT FEATURE_TYPE e911_facilities OUTPUT FEATURE_TYPE StringConcatenator_OUTPUT @Tcl2("a56a978a_c11c_4d8e_aeef_116c706214254_doSetAttr {@EvaluateExpression(STRING_ENCODED,c:FMEDataDataEmergencyPDFValueNAME_FULL.pdf,StringConcatenator)} ") # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME AttributeFileReader INPUT FEATURE_TYPE StringConcatenator_OUTPUT OUTPUT FEATURE_TYPE AttributeFileReader_OUTPUT @File(DestReadSrcWrite,PHOTO,"@Value(PHOTO_FILE_NAME)",fme-binary) # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFileReader_OUTPUT -> E911_FACILITIES Correlator" INPUT FEATURE_TYPE AttributeFileReader_OUTPUT OUTPUT FEATURE_TYPE __GO_TO_FINAL_OUTPUT_ROUTER__ @Transform(FME_GENERIC,ORACLE8I) @SupplyAttributes(__wb_out_feat_type__,E911_FACILITIES) # ------------------------------------------------------------------------- FACTORY_DEF * TestFactory FACTORY_NAME "Final Output Feature Type Router" INPUT FEATURE_TYPE * TEST @Value(__wb_out_feat_type__) != "" OUTPUT PASSED FEATURE_TYPE * @FeatureType(@Value(__wb_out_feat_type__)) OUTPUT FAILED FEATURE_TYPE __nuke_me__ @Tcl2("FME_StatMessage 818059 {@Value(fme_template_feature_type)} 818060 818061 fme_warn") # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "Final Output Nuker" INPUT FEATURE_TYPE __nuke_me__ # ------------------------------------------------------------------------- ORACLE8I_1_DEF E911_FACILITIES oracle_model object oracle_create_indices No oracle_levels 0 oracle_numtiles 8 oracle_min_x -180 oracle_min_y -90 oracle_min_z 0 oracle_min_m 0 oracle_max_x 180 oracle_max_y 90 oracle_max_z 0 oracle_max_m 0 oracle_x_tol 0.05 oracle_y_tol 0.05 oracle_z_tol 0.05 oracle_m_tol 0.05 oracle_dim 2 oracle_default_contains_measures No oracle_default_geom_column GEOM oracle_drop_table Yes IDR_ID integer ADDRESS char(40) NAME char(40) FACILITY char(50) TYPE_ float STATUS char(16) STA_NUM char(3) COMMAND char(16) ENTITY char(26) PROP_DATE char(8) FACILITY2 char(16) COLOCATE char(5) NAME2 char(25) UNIT char(35) GAATN char(16) LADDER char(16) X_COORD float Y_COORD float SECTORS_ char(16) JURIS_ char(16) NAME_FULL char(30) PHOTO blob PHOTO_FILE_NAME char(75)