Google Git
Sign in
apache / hop / 897e18786836171c3239e29f90151c786180dcb6 / . / archive-samples / transformations / Get Files - Get all transformations.ktr
blob: 8270fd8270c95e42071a153659cc922758f3f3a6 [file] [log] [blame]
<?xml version="1.0" encoding="UTF-8"?>
<pipeline>
<info>
<name>Get Files Get all transformations</name>
<description/>
<extended_description/>
<trans_version/>
<trans_type>Normal</trans_type>
<directory>&#x2f;</directory>
<parameters>
</parameters>
<log>
<pipeline-log-table>
<connection/>
<schema/>
<table/>
<size_limit_lines/>
<interval/>
<timeout_days/>
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>N</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>TRANSNAME</id>
<enabled>Y</enabled>
<name>TRANSNAME</name>
</field>
<field>
<id>STATUS</id>
<enabled>Y</enabled>
<name>STATUS</name>
</field>
<field>
<id>LINES_READ</id>
<enabled>Y</enabled>
<name>LINES_READ</name>
<subject/>
</field>
<field>
<id>LINES_WRITTEN</id>
<enabled>Y</enabled>
<name>LINES_WRITTEN</name>
<subject/>
</field>
<field>
<id>LINES_UPDATED</id>
<enabled>Y</enabled>
<name>LINES_UPDATED</name>
<subject/>
</field>
<field>
<id>LINES_INPUT</id>
<enabled>Y</enabled>
<name>LINES_INPUT</name>
<subject/>
</field>
<field>
<id>LINES_OUTPUT</id>
<enabled>Y</enabled>
<name>LINES_OUTPUT</name>
<subject/>
</field>
<field>
<id>LINES_REJECTED</id>
<enabled>N</enabled>
<name>LINES_REJECTED</name>
<subject/>
</field>
<field>
<id>ERRORS</id>
<enabled>Y</enabled>
<name>ERRORS</name>
</field>
<field>
<id>STARTDATE</id>
<enabled>Y</enabled>
<name>STARTDATE</name>
</field>
<field>
<id>ENDDATE</id>
<enabled>Y</enabled>
<name>ENDDATE</name>
</field>
<field>
<id>LOGDATE</id>
<enabled>Y</enabled>
<name>LOGDATE</name>
</field>
<field>
<id>DEPDATE</id>
<enabled>Y</enabled>
<name>DEPDATE</name>
</field>
<field>
<id>REPLAYDATE</id>
<enabled>Y</enabled>
<name>REPLAYDATE</name>
</field>
<field>
<id>LOG_FIELD</id>
<enabled>N</enabled>
<name>LOG_FIELD</name>
</field>
<field>
<id>EXECUTING_SERVER</id>
<enabled>N</enabled>
<name>EXECUTING_SERVER</name>
</field>
<field>
<id>EXECUTING_USER</id>
<enabled>N</enabled>
<name>EXECUTING_USER</name>
</field>
<field>
<id>CLIENT</id>
<enabled>N</enabled>
<name>CLIENT</name>
</field>
</pipeline-log-table>
<perf-log-table>
<connection/>
<schema/>
<table/>
<interval/>
<timeout_days/>
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>SEQ_NR</id>
<enabled>Y</enabled>
<name>SEQ_NR</name>
</field>
<field>
<id>LOGDATE</id>
<enabled>Y</enabled>
<name>LOGDATE</name>
</field>
<field>
<id>TRANSNAME</id>
<enabled>Y</enabled>
<name>TRANSNAME</name>
</field>
<field>
<id>STEPNAME</id>
<enabled>Y</enabled>
<name>STEPNAME</name>
</field>
<field>
<id>STEP_COPY</id>
<enabled>Y</enabled>
<name>STEP_COPY</name>
</field>
<field>
<id>LINES_READ</id>
<enabled>Y</enabled>
<name>LINES_READ</name>
</field>
<field>
<id>LINES_WRITTEN</id>
<enabled>Y</enabled>
<name>LINES_WRITTEN</name>
</field>
<field>
<id>LINES_UPDATED</id>
<enabled>Y</enabled>
<name>LINES_UPDATED</name>
</field>
<field>
<id>LINES_INPUT</id>
<enabled>Y</enabled>
<name>LINES_INPUT</name>
</field>
<field>
<id>LINES_OUTPUT</id>
<enabled>Y</enabled>
<name>LINES_OUTPUT</name>
</field>
<field>
<id>LINES_REJECTED</id>
<enabled>Y</enabled>
<name>LINES_REJECTED</name>
</field>
<field>
<id>ERRORS</id>
<enabled>Y</enabled>
<name>ERRORS</name>
</field>
<field>
<id>INPUT_BUFFER_ROWS</id>
<enabled>Y</enabled>
<name>INPUT_BUFFER_ROWS</name>
</field>
<field>
<id>OUTPUT_BUFFER_ROWS</id>
<enabled>Y</enabled>
<name>OUTPUT_BUFFER_ROWS</name>
</field>
</perf-log-table>
<channel-log-table>
<connection/>
<schema/>
<table/>
<timeout_days/>
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>LOG_DATE</id>
<enabled>Y</enabled>
<name>LOG_DATE</name>
</field>
<field>
<id>LOGGING_OBJECT_TYPE</id>
<enabled>Y</enabled>
<name>LOGGING_OBJECT_TYPE</name>
</field>
<field>
<id>OBJECT_NAME</id>
<enabled>Y</enabled>
<name>OBJECT_NAME</name>
</field>
<field>
<id>OBJECT_COPY</id>
<enabled>Y</enabled>
<name>OBJECT_COPY</name>
</field>
<field>
<id>REPOSITORY_DIRECTORY</id>
<enabled>Y</enabled>
<name>REPOSITORY_DIRECTORY</name>
</field>
<field>
<id>FILENAME</id>
<enabled>Y</enabled>
<name>FILENAME</name>
</field>
<field>
<id>OBJECT_ID</id>
<enabled>Y</enabled>
<name>OBJECT_ID</name>
</field>
<field>
<id>OBJECT_REVISION</id>
<enabled>Y</enabled>
<name>OBJECT_REVISION</name>
</field>
<field>
<id>PARENT_CHANNEL_ID</id>
<enabled>Y</enabled>
<name>PARENT_CHANNEL_ID</name>
</field>
<field>
<id>ROOT_CHANNEL_ID</id>
<enabled>Y</enabled>
<name>ROOT_CHANNEL_ID</name>
</field>
</channel-log-table>
<transform-log-table>
<connection/>
<schema/>
<table/>
<timeout_days/>
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>LOG_DATE</id>
<enabled>Y</enabled>
<name>LOG_DATE</name>
</field>
<field>
<id>TRANSNAME</id>
<enabled>Y</enabled>
<name>TRANSNAME</name>
</field>
<field>
<id>STEPNAME</id>
<enabled>Y</enabled>
<name>STEPNAME</name>
</field>
<field>
<id>STEP_COPY</id>
<enabled>Y</enabled>
<name>STEP_COPY</name>
</field>
<field>
<id>LINES_READ</id>
<enabled>Y</enabled>
<name>LINES_READ</name>
</field>
<field>
<id>LINES_WRITTEN</id>
<enabled>Y</enabled>
<name>LINES_WRITTEN</name>
</field>
<field>
<id>LINES_UPDATED</id>
<enabled>Y</enabled>
<name>LINES_UPDATED</name>
</field>
<field>
<id>LINES_INPUT</id>
<enabled>Y</enabled>
<name>LINES_INPUT</name>
</field>
<field>
<id>LINES_OUTPUT</id>
<enabled>Y</enabled>
<name>LINES_OUTPUT</name>
</field>
<field>
<id>LINES_REJECTED</id>
<enabled>Y</enabled>
<name>LINES_REJECTED</name>
</field>
<field>
<id>ERRORS</id>
<enabled>Y</enabled>
<name>ERRORS</name>
</field>
<field>
<id>LOG_FIELD</id>
<enabled>N</enabled>
<name>LOG_FIELD</name>
</field>
</transform-log-table>
<metrics-log-table>
<connection/>
<schema/>
<table/>
<timeout_days/>
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>LOG_DATE</id>
<enabled>Y</enabled>
<name>LOG_DATE</name>
</field>
<field>
<id>METRICS_DATE</id>
<enabled>Y</enabled>
<name>METRICS_DATE</name>
</field>
<field>
<id>METRICS_CODE</id>
<enabled>Y</enabled>
<name>METRICS_CODE</name>
</field>
<field>
<id>METRICS_DESCRIPTION</id>
<enabled>Y</enabled>
<name>METRICS_DESCRIPTION</name>
</field>
<field>
<id>METRICS_SUBJECT</id>
<enabled>Y</enabled>
<name>METRICS_SUBJECT</name>
</field>
<field>
<id>METRICS_TYPE</id>
<enabled>Y</enabled>
<name>METRICS_TYPE</name>
</field>
<field>
<id>METRICS_VALUE</id>
<enabled>Y</enabled>
<name>METRICS_VALUE</name>
</field>
</metrics-log-table>
</log>
<maxdate>
<connection/>
<table/>
<field/>
<offset>0.0</offset>
<maxdiff>0.0</maxdiff>
</maxdate>
<size_rowset>1000</size_rowset>
<sleep_time_empty>1</sleep_time_empty>
<sleep_time_full>1</sleep_time_full>
<unique_connections>N</unique_connections>
<feedback_shown>Y</feedback_shown>
<feedback_size>5000</feedback_size>
<using_thread_priorities>Y</using_thread_priorities>
<shared_objects_file/>
<capture_transform_performance>N</capture_transform_performance>
<transform_performance_capturing_delay>1000</transform_performance_capturing_delay>
<transform_performance_capturing_size_limit/>
<dependencies>
</dependencies>
<partitionschemas>
</partitionschemas>
<slaveservers>
</slaveservers>
<clusterschemas>
</clusterschemas>
<created_user/>
<created_date>2011&#x2f;05&#x2f;25 17&#x3a;15&#x3a;03.638</created_date>
<modified_user/>
<modified_date>2007&#x2f;01&#x2f;23 23&#x3a;39&#x3a;52.968</modified_date>
<key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA&#x3d;</key_for_session_key>
<is_key_private>N</is_key_private>
</info>
<notepads>
<notepad>
<note>Select all JavaScript transformations</note>
<xloc>99</xloc>
<yloc>27</yloc>
<width>249</width>
<heigth>27</heigth>
<fontname/>
<fontsize>-1</fontsize>
<fontbold>N</fontbold>
<fontitalic>N</fontitalic>
<fontcolorred>0</fontcolorred>
<fontcolorgreen>0</fontcolorgreen>
<fontcolorblue>0</fontcolorblue>
<backgroundcolorred>255</backgroundcolorred>
<backgroundcolorgreen>165</backgroundcolorgreen>
<backgroundcolorblue>0</backgroundcolorblue>
<bordercolorred>100</bordercolorred>
<bordercolorgreen>100</bordercolorgreen>
<bordercolorblue>100</bordercolorblue>
<drawshadow>N</drawshadow>
</notepad>
<notepad>
<note>Enable this branch in case of kettle repository is used</note>
<xloc>208</xloc>
<yloc>388</yloc>
<width>322</width>
<heigth>25</heigth>
<fontname>Arial</fontname>
<fontsize>10</fontsize>
<fontbold>N</fontbold>
<fontitalic>N</fontitalic>
<fontcolorred>0</fontcolorred>
<fontcolorgreen>0</fontcolorgreen>
<fontcolorblue>0</fontcolorblue>
<backgroundcolorred>255</backgroundcolorred>
<backgroundcolorgreen>205</backgroundcolorgreen>
<backgroundcolorblue>112</backgroundcolorblue>
<bordercolorred>100</bordercolorred>
<bordercolorgreen>100</bordercolorgreen>
<bordercolorblue>100</bordercolorblue>
<drawshadow>Y</drawshadow>
</notepad>
</notepads>
<order>
<hop>
<from>Get File Names</from>
<to>Filter rows 2</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Filter rows 2</from>
<to>Copy rows to result</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Get repository names</from>
<to>Filter rows 2 2</to>
<enabled>N</enabled>
</hop>
<hop>
<from>Filter rows 2 2</from>
<to>Copy rows to result</to>
<enabled>N</enabled>
</hop>
</order>
<transform>
<name>Copy rows to result</name>
<type>RowsToResult</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<cluster_schema/>
<input>
</input>
<output>
</output>
<GUI>
<xloc>472</xloc>
<yloc>122</yloc>
<draw>Y</draw>
</GUI>
</transform>
<transform>
<name>Filter rows 2</name>
<type>FilterRows</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<send_true_to/>
<send_false_to/>
<compare>
<condition>
<negated>Y</negated>
<conditions>
<condition>
<negated>N</negated>
<leftvalue>short_filename</leftvalue>
<function>ENDS WITH</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>dialog.ktr</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>short_filename</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>luciddb</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>short_filename</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>SAP</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>short_filename</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>Repository Import</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>short_filename</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>Repository Export</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>short_filename</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>TextInput and Output using variables</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>short_filename</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>Twitter</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>short_filename</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>VFS Configuration Sample</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>short_filename</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>Servlet</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>short_filename</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>Change log processing 2</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
</conditions>
</condition>
</compare>
<cluster_schema/>
<input>
</input>
<output>
</output>
<GUI>
<xloc>271</xloc>
<yloc>122</yloc>
<draw>Y</draw>
</GUI>
</transform>
<transform>
<name>Filter rows 2 2</name>
<type>FilterRows</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<send_true_to>Copy rows to result</send_true_to>
<send_false_to/>
<compare>
<condition>
<negated>Y</negated>
<conditions>
<condition>
<negated>N</negated>
<leftvalue>name</leftvalue>
<function>ENDS WITH</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>dialog</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>name</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>Database</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>name</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>Table Output</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>name</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>Change log processing</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
<condition>
<negated>N</negated>
<operator>OR</operator>
<leftvalue>name</leftvalue>
<function>CONTAINS</function>
<rightvalue/>
<value><name>constant</name><type>String</type><text>luciddb</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition>
</conditions>
</condition>
</compare>
<cluster_schema/>
<input>
</input>
<output>
</output>
<GUI>
<xloc>272</xloc>
<yloc>255</yloc>
<draw>Y</draw>
</GUI>
</transform>
<transform>
<name>Get File Names</name>
<type>GetFileNames</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<filter>
<filterfiletype>only_files</filterfiletype>
</filter>
<doNotFailIfNoFile>N</doNotFailIfNoFile>
<rownum>N</rownum>
<isaddresult>N</isaddresult>
<filefield>N</filefield>
<rownum_field/>
<filename_Field/>
<wildcard_Field/>
<exclude_wildcard_Field/>
<dynamic_include_subfolders>N</dynamic_include_subfolders>
<limit>0</limit>
<file>
<name>&#x24;&#x7b;Internal.Transformation.Filename.Directory&#x7d;&#x2f;</name>
<filemask>.&#x2a;&#x5c;.ktr&#x24;</filemask>
<exclude_filemask/>
<file_required>N</file_required>
<include_subfolders>N</include_subfolders>
</file>
<cluster_schema/>
<input>
</input>
<output>
</output>
<GUI>
<xloc>125</xloc>
<yloc>121</yloc>
<draw>Y</draw>
</GUI>
</transform>
<transform>
<name>Get repository names</name>
<type>GetRepositoryNames</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<object_type>All</object_type>
<rownum>Y</rownum>
<rownum_field>rownr</rownum_field>
<file>
<directory>&#x2f;transformations</directory>
<name_mask/>
<exclude_name_mask/>
<include_subfolders>N</include_subfolders>
</file>
<cluster_schema/>
<input>
</input>
<output>
</output>
<GUI>
<xloc>116</xloc>
<yloc>254</yloc>
<draw>Y</draw>
</GUI>
</transform>
<transform_error_handling>
</transform_error_handling>
<slave-transform-copy-partition-distribution>
</slave-transform-copy-partition-distribution>
<slave_transformation>N</slave_transformation>
</pipeline>