Skip to content

Instantly share code, notes, and snippets.

@alistairhenderson
Created February 10, 2016 16:02
Show Gist options
  • Save alistairhenderson/4e28cdcb3645722d1321 to your computer and use it in GitHub Desktop.
Save alistairhenderson/4e28cdcb3645722d1321 to your computer and use it in GitHub Desktop.
Pentaho Trace Debug Transformation
<?xml version="1.0" encoding="UTF-8"?>
<transformation-steps>
<steps>
<step>
<name>Mapping Input</name>
<type>MappingInput</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<fields>
<field>
<name>LogField</name>
<type>String</type>
<length>0</length>
<precision>-1</precision>
</field>
<field>
<name>LogFileName</name>
<type>String</type>
<length>0</length>
<precision>-1</precision>
</field>
<select_unspecified>N</select_unspecified>
</fields>
<cluster_schema/>
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
<xloc>128</xloc>
<yloc>48</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Is Debug Set</name>
<type>SwitchCase</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<fieldname>global_debug</fieldname>
<use_contains>N</use_contains>
<case_value_type>String</case_value_type>
<case_value_format/>
<case_value_decimal/>
<case_value_group/>
<default_target_step>No Log Required</default_target_step>
<cases><case><value>Y</value>
<target_step>Add File Constants</target_step>
</case></cases> <cluster_schema/>
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
<xloc>480</xloc>
<yloc>48</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Get Global Variables</name>
<type>GetVariable</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<fields>
<field>
<name>global_debug</name>
<variable>&#x24;&#x7b;GLOBAL_DEBUG&#x7d;</variable>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<length>-1</length>
<precision>-1</precision>
<trim_type>both</trim_type>
</field>
<field>
<name>global_debug_filepath</name>
<variable>&#x24;&#x7b;GLOBAL_DEBUG_FILEPATH&#x7d;</variable>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<length>-1</length>
<precision>-1</precision>
<trim_type>both</trim_type>
</field>
</fields>
<cluster_schema/>
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
<xloc>304</xloc>
<yloc>48</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>No Log Required</name>
<type>Dummy</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<cluster_schema/>
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
<xloc>480</xloc>
<yloc>176</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Write Log</name>
<type>TextFileOutput</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<separator/>
<enclosure/>
<enclosure_forced>N</enclosure_forced>
<enclosure_fix_disabled>N</enclosure_fix_disabled>
<header>N</header>
<footer>N</footer>
<format>DOS</format>
<compression>None</compression>
<encoding/>
<endedLine/>
<fileNameInField>Y</fileNameInField>
<fileNameField>Log File Path</fileNameField>
<create_parent_folder>Y</create_parent_folder>
<file>
<name/>
<is_command>N</is_command>
<servlet_output>N</servlet_output>
<do_not_open_new_file_init>Y</do_not_open_new_file_init>
<extention>txt</extention>
<append>N</append>
<split>N</split>
<haspartno>N</haspartno>
<add_date>N</add_date>
<add_time>N</add_time>
<SpecifyFormat>N</SpecifyFormat>
<date_time_format/>
<add_to_result_filenames>Y</add_to_result_filenames>
<pad>N</pad>
<fast_dump>N</fast_dump>
<splitevery>0</splitevery>
</file>
<fields>
<field>
<name>LogField</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<trim_type>both</trim_type>
<length>-1</length>
<precision>-1</precision>
</field>
</fields>
<cluster_schema/>
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
<xloc>1104</xloc>
<yloc>48</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Crate Log File Name</name>
<type>ConcatFields</type>
<description/>
<distribute>N</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<separator/>
<enclosure/>
<enclosure_forced>N</enclosure_forced>
<enclosure_fix_disabled>N</enclosure_fix_disabled>
<header>N</header>
<footer>N</footer>
<format>DOS</format>
<compression>None</compression>
<encoding/>
<endedLine/>
<fileNameInField>N</fileNameInField>
<fileNameField/>
<create_parent_folder>Y</create_parent_folder>
<file>
<name>file</name>
<is_command>N</is_command>
<servlet_output>N</servlet_output>
<do_not_open_new_file_init>N</do_not_open_new_file_init>
<extention>txt</extention>
<append>N</append>
<split>N</split>
<haspartno>N</haspartno>
<add_date>N</add_date>
<add_time>N</add_time>
<SpecifyFormat>N</SpecifyFormat>
<date_time_format/>
<add_to_result_filenames>Y</add_to_result_filenames>
<pad>N</pad>
<fast_dump>N</fast_dump>
<splitevery>0</splitevery>
</file>
<fields>
<field>
<name>global_debug_filepath</name>
<type>None</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<trim_type>both</trim_type>
<length>-1</length>
<precision>-1</precision>
</field>
<field>
<name>Separator</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<trim_type>both</trim_type>
<length>-1</length>
<precision>-1</precision>
</field>
<field>
<name>LogFileName</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<trim_type>both</trim_type>
<length>-1</length>
<precision>-1</precision>
</field>
<field>
<name>FileExtension</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<trim_type>both</trim_type>
<length>-1</length>
<precision>-1</precision>
</field>
</fields>
<ConcatFields>
<targetFieldName>Log File Path</targetFieldName>
<targetFieldLength>0</targetFieldLength>
<removeSelectedFields>N</removeSelectedFields>
</ConcatFields>
<cluster_schema/>
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
<xloc>784</xloc>
<yloc>48</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Add File Constants</name>
<type>Constant</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<fields>
<field>
<name>Separator</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif>&#x2f;</nullif>
<length>-1</length>
<precision>-1</precision>
<set_empty_string>N</set_empty_string>
</field>
<field>
<name>FileExtension</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif>.log</nullif>
<length>-1</length>
<precision>-1</precision>
<set_empty_string>N</set_empty_string>
</field>
</fields>
<cluster_schema/>
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
<xloc>624</xloc>
<yloc>48</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Mapping output specification</name>
<type>MappingOutput</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<cluster_schema/>
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
<xloc>1104</xloc>
<yloc>176</yloc>
<draw>Y</draw>
</GUI>
</step>
</steps>
<order>
<hop> <from>Mapping Input</from><to>Get Global Variables</to><enabled>Y</enabled> </hop>
<hop> <from>Is Debug Set</from><to>No Log Required</to><enabled>Y</enabled> </hop>
<hop> <from>Is Debug Set</from><to>Add File Constants</to><enabled>Y</enabled> </hop>
<hop> <from>Get Global Variables</from><to>Is Debug Set</to><enabled>Y</enabled> </hop>
<hop> <from>Crate Log File Name</from><to>Write Log</to><enabled>Y</enabled> </hop>
<hop> <from>Crate Log File Name</from><to>Mapping output specification</to><enabled>Y</enabled> </hop>
<hop> <from>Add File Constants</from><to>Crate Log File Name</to><enabled>Y</enabled> </hop>
</order>
<notepads>
</notepads>
<step_error_handling>
</step_error_handling>
</transformation-steps>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment