Network Normal 1 / db_database db_hostname db_password db_port db_username timestamp 0 xls_filename xls_folder ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDTRANSNAMEYTRANSNAMESTATUSYSTATUSLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSSTARTDATEYSTARTDATEENDDATEYENDDATELOGDATEYLOGDATEDEPDATEYDEPDATEREPLAYDATEYREPLAYDATELOG_FIELDYLOG_FIELDEXECUTING_SERVERNEXECUTING_SERVEREXECUTING_USERNEXECUTING_USERCLIENTNCLIENT
ID_BATCHYID_BATCHSEQ_NRYSEQ_NRLOGDATEYLOGDATETRANSNAMEYTRANSNAMESTEPNAMEYSTEPNAMESTEP_COPYYSTEP_COPYLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSINPUT_BUFFER_ROWSYINPUT_BUFFER_ROWSOUTPUT_BUFFER_ROWSYOUTPUT_BUFFER_ROWS
ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATELOGGING_OBJECT_TYPEYLOGGING_OBJECT_TYPEOBJECT_NAMEYOBJECT_NAMEOBJECT_COPYYOBJECT_COPYREPOSITORY_DIRECTORYYREPOSITORY_DIRECTORYFILENAMEYFILENAMEOBJECT_IDYOBJECT_IDOBJECT_REVISIONYOBJECT_REVISIONPARENT_CHANNEL_IDYPARENT_CHANNEL_IDROOT_CHANNEL_IDYROOT_CHANNEL_ID
ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATETRANSNAMEYTRANSNAMESTEPNAMEYSTEPNAMESTEP_COPYYSTEP_COPYLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSLOG_FIELDNLOG_FIELD
ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATEMETRICS_DATEYMETRICS_DATEMETRICS_CODEYMETRICS_CODEMETRICS_DESCRIPTIONYMETRICS_DESCRIPTIONMETRICS_SUBJECTYMETRICS_SUBJECTMETRICS_TYPEYMETRICS_TYPEMETRICS_VALUEYMETRICS_VALUE
0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2014/01/13 14:09:41.788 - 2015/08/26 13:32:40.148 Staging_import ${db_hostname} POSTGRESQL Native ${db_database} ${db_port} ${db_username} ${db_password} FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER${db_port} PRESERVE_RESERVED_WORD_CASEN QUOTE_ALL_FIELDSN SUPPORTS_BOOLEAN_DATA_TYPEN SUPPORTS_TIMESTAMP_DATA_TYPEN USE_POOLINGN TimestampAdd item type constantY Select valuesTimestampY Merge itemsSynchronize itemsY Sort rows 2 2Merge itemsY Sort rowsMerge itemsY Add item type constantSelect values 3Y Select values 3Sort rowsY Microsoft Excel InputSelect valuesY Existing itemsSelect values 2Y Select values 2Sort rows 2 2Y Add item type constant Constant Y 1 none rt_id Integer 5 -1 -1 N 400 150 Y Existing items TableInput Y 1 none Staging_import SELECT id, from_id, from_connector_type, from_port_number, from_module_name, is_from_patch_panel_rear, to_id, to_connector_type, to_port_number, to_module_name, is_to_patch_panel_rear, state_last_updated FROM network_connection ORDER BY id 0 N N N 700 450 Y Merge items MergeRows N 1 none id from_id from_connector_type from_port_number from_module_name is_from_patch_panel_rear to_id to_connector_type to_port_number to_module_name is_to_patch_panel_rear state_flag Sort rows 2 2 Sort rows 700 150 Y Microsoft Excel Input ExcelInput N 1 none
Y
Y N 0 Y N ${xls_folder}${xls_filename} N N id String -1 -1 none N from_name String -1 -1 none N from_id String -1 -1 none N from_port_type String -1 -1 none N from_port_number Number -1 -1 none N from_module_name String -1 -1 none N from_port_speed String -1 -1 none N from_patch_panel_rear Number -1 -1 none N to_name String -1 -1 none N to_id String -1 -1 none N to_port_type String -1 -1 none N to_port_number Number -1 -1 none N to_module_name String -1 -1 none N to_port_speed String -1 -1 none N to_patch_panel_rear Number -1 -1 none N NetworkConnections 0 0 N N N warning error line JXL 100 150 Y
Select values SelectValues Y 1 none id -2 -2 from_name -2 -2 from_id -2 -2 from_port_type -2 -2 from_port_number -2 -2 from_module_name -2 -2 from_port_speed -2 -2 from_patch_panel_rear -2 -2 to_name -2 -2 to_id -2 -2 to_port_type -2 -2 to_port_number -2 -2 to_module_name -2 -2 to_port_speed -2 -2 to_patch_panel_rear -2 -2 N from_patch_panel_rear from_patch_panel_rear Integer -2 -2 false false to_patch_panel_rear to_patch_panel_rear Integer -2 -2 false false 200 150 Y Select values 2 SelectValues Y 1 none id -2 -2 from_id -2 -2 from_connector_type -2 -2 from_port_number -2 -2 from_module_name -2 -2 is_from_patch_panel_rear -2 -2 to_id -2 -2 to_connector_type -2 -2 to_port_number -2 -2 to_module_name -2 -2 is_to_patch_panel_rear -2 -2 state_last_updated -2 -2 N from_port_number from_port_number Number -2 -2 false false to_port_number to_port_number Number -2 -2 false false state_last_updated state_last_updated BigNumber -2 -2 false false 700 350 Y Select values 3 SelectValues N 1 none id -2 -2 from_id -2 -2 from_port_type from_connector_type -2 -2 from_port_number -2 -2 from_module_name -2 -2 from_patch_panel_rear is_from_patch_panel_rear -2 -2 to_id -2 -2 to_port_type to_connector_type -2 -2 to_port_number -2 -2 to_module_name -2 -2 to_patch_panel_rear is_to_patch_panel_rear -2 -2 state_last_updated -2 -2 N state_last_updated state_last_updated BigNumber -2 -2 false false 500 150 Y Sort rows SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N id Y Y N 600 150 Y Sort rows 2 2 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N Y id Y Y N 700 250 Y Synchronize items SynchronizeAfterMerge Y 1 none Staging_import 100 N N Y state_flag new changed
network_connection
id id = id id Y from_id from_id Y from_connector_type from_connector_type Y from_port_number from_port_number Y from_module_name from_module_name Y is_from_patch_panel_rear is_from_patch_panel_rear Y to_id to_id Y to_connector_type to_connector_type Y to_port_number to_port_number Y to_module_name to_module_name Y is_to_patch_panel_rear is_to_patch_panel_rear Y state_last_updated state_last_updated Y state_flag state_flag Y 800 150 Y Timestamp GetVariable Y 1 none state_last_updated ${timestamp} String 0 0 none 300 150 Y N