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_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
${db_port}
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
N
SUPPORTS_TIMESTAMP_DATA_TYPE
N
USE_POOLING
N
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
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
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