diff options
| -rw-r--r-- | import_all_data_bi_indoteknik.kjb | 48 | ||||
| -rw-r--r-- | import_match_payment_invoice.ktr | 164 | ||||
| -rw-r--r-- | run_single_ktr.sh | 2 |
3 files changed, 206 insertions, 8 deletions
diff --git a/import_all_data_bi_indoteknik.kjb b/import_all_data_bi_indoteknik.kjb index 229b379..fb951ab 100644 --- a/import_all_data_bi_indoteknik.kjb +++ b/import_all_data_bi_indoteknik.kjb @@ -1463,6 +1463,45 @@ <yloc>416</yloc> <attributes_kjc/> </entry> + <entry> + <name>match payment invoice</name> + <description/> + <type>TRANS</type> + <attributes/> + <specification_method>filename</specification_method> + <trans_object_id/> + <filename>/home/stephan/transformation-job-bi/import_match_payment_invoice.ktr</filename> + <transname/> + <arg_from_previous>N</arg_from_previous> + <params_from_previous>N</params_from_previous> + <exec_per_row>N</exec_per_row> + <clear_rows>N</clear_rows> + <clear_files>N</clear_files> + <set_logfile>N</set_logfile> + <logfile/> + <logext/> + <add_date>N</add_date> + <add_time>N</add_time> + <loglevel>Basic</loglevel> + <cluster>N</cluster> + <slave_server_name/> + <set_append_logfile>N</set_append_logfile> + <wait_until_finished>Y</wait_until_finished> + <follow_abort_remote>N</follow_abort_remote> + <create_parent_folder>N</create_parent_folder> + <logging_remote_work>N</logging_remote_work> + <run_configuration>Pentaho local</run_configuration> + <suppress_result_data>N</suppress_result_data> + <parameters> + <pass_all_parameters>Y</pass_all_parameters> + </parameters> + <parallel>N</parallel> + <draw>Y</draw> + <nr>0</nr> + <xloc>160</xloc> + <yloc>528</yloc> + <attributes_kjc/> + </entry> </entries> <hops> <hop> @@ -1735,6 +1774,15 @@ <evaluation>Y</evaluation> <unconditional>N</unconditional> </hop> + <hop> + <from>account payment</from> + <to>match payment invoice</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> </hops> <notepads> </notepads> diff --git a/import_match_payment_invoice.ktr b/import_match_payment_invoice.ktr index 92c59c7..11e4155 100644 --- a/import_match_payment_invoice.ktr +++ b/import_match_payment_invoice.ktr @@ -427,15 +427,66 @@ <clusterschemas> </clusterschemas> <created_user>-</created_user> - <created_date>2024/03/06 15:36:02.956</created_date> + <created_date>2024/06/07 11:20:43.357</created_date> <modified_user>-</modified_user> - <modified_date>2024/03/06 15:36:02.956</modified_date> + <modified_date>2024/06/07 11:20:43.357</modified_date> <key_for_session_key/> <is_key_private>N</is_key_private> </info> <notepads> </notepads> <connection> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>dw_bi_indoteknik</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> + <servername/> + <data_tablespace/> + <index_tablespace/> + <attributes> + <attribute> + <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>IS_CLUSTERED</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>PORT_NUMBER</code> + <attribute>5432</attribute> + </attribute> + <attribute> + <code>PRESERVE_RESERVED_WORD_CASE</code> + <attribute>Y</attribute> + </attribute> + <attribute> + <code>QUOTE_ALL_FIELDS</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>SUPPORTS_BOOLEAN_DATA_TYPE</code> + <attribute>Y</attribute> + </attribute> + <attribute> + <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>USE_POOLING</code> + <attribute>N</attribute> + </attribute> + </attributes> + </connection> + <connection> <name>erp indoteknik production (localhost)</name> <server>10.148.0.3</server> <type>POSTGRESQL</type> @@ -487,6 +538,11 @@ </attributes> </connection> <order> + <hop> + <from>Table input</from> + <to>Insert / update</to> + <enabled>Y</enabled> + </hop> </order> <step> <name>Table input</name> @@ -500,15 +556,109 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select * from v_match_payment_invoice -order by payment_id desc ---limit 100</sql> + <sql>select * from v_match_payment_invoice</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> <variables_active>N</variables_active> <lazy_conversion_active>N</lazy_conversion_active> <cached_row_meta_active>N</cached_row_meta_active> + <row-meta> + <value-meta> + <type>Integer</type> + <storagetype>normal</storagetype> + <name>payment_id</name> + <length>9</length> + <precision>0</precision> + <origin>Table input</origin> + <comments>payment_id</comments> + <conversion_Mask>####0;-####0</conversion_Mask> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_ID</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>Integer</type> + <storagetype>normal</storagetype> + <name>invoice_id</name> + <length>9</length> + <precision>0</precision> + <origin>Table input</origin> + <comments>invoice_id</comments> + <conversion_Mask>####0;-####0</conversion_Mask> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_ID</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + </row-meta> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>288</xloc> + <yloc>128</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Insert / update</name> + <type>InsertUpdate</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>v_match_payment_invoice</table> + <key> + <name>payment_id</name> + <field>payment_id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>payment_id</name> + <rename>payment_id</rename> + <update>N</update> + </value> + <value> + <name>invoice_id</name> + <rename>invoice_id</rename> + <update>Y</update> + </value> + </lookup> <attributes/> <cluster_schema/> <remotesteps> @@ -518,8 +668,8 @@ order by payment_id desc </output> </remotesteps> <GUI> - <xloc>240</xloc> - <yloc>80</yloc> + <xloc>448</xloc> + <yloc>128</yloc> <draw>Y</draw> </GUI> </step> diff --git a/run_single_ktr.sh b/run_single_ktr.sh index 362a6f9..9bc976c 100644 --- a/run_single_ktr.sh +++ b/run_single_ktr.sh @@ -1 +1 @@ -sh /home/stephan/data-integration/pan.sh -level="Debug" -file="/home/stephan/transformation-job-bi/import_payment_term.ktr" > "/home/stephan/transformation-job-bi/log/run_single_ktr.log" +sh /home/stephan/data-integration/pan.sh -level="Debug" -file="/home/stephan/transformation-job-bi/import_match_payment_invoice.ktr" > "/home/stephan/transformation-job-bi/log/run_single_ktr.log" |