From 64029436be905440002651b9f9c851d75ea83661 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 14 Mar 2023 17:02:48 +0700 Subject: combine with value bp name from odoo to adempiere --- import_adempiere_to_data_warehouse.ktr | 1044 +++++++++++++++++++++++++++++++- 1 file changed, 1037 insertions(+), 7 deletions(-) diff --git a/import_adempiere_to_data_warehouse.ktr b/import_adempiere_to_data_warehouse.ktr index 03852aa..70dde11 100644 --- a/import_adempiere_to_data_warehouse.ktr +++ b/import_adempiere_to_data_warehouse.ktr @@ -486,20 +486,131 @@ + + erp indoteknik production + 34.101.171.249 + POSTGRESQL + Native + erp_indoteknik + 5432 + odoo + Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3 + + + + + + FORCE_IDENTIFIERS_TO_LOWERCASE + N + + + FORCE_IDENTIFIERS_TO_UPPERCASE + N + + + IS_CLUSTERED + N + + + PORT_NUMBER + 5432 + + + PRESERVE_RESERVED_WORD_CASE + Y + + + QUOTE_ALL_FIELDS + N + + + SUPPORTS_BOOLEAN_DATA_TYPE + Y + + + SUPPORTS_TIMESTAMP_DATA_TYPE + Y + + + USE_POOLING + N + + + Microsoft Excel input + data trx adempiere + Y + + + Table input + master data bp odoo + Y + + + Table input 2 + table bp altama + Y + + + data trx adempiere + data trx adem + Y + + + table bp altama + bp altama + Y + + + data trx adem + Merge join 2 + Y + + + bp altama + Merge join 2 + Y + + + Merge join 2 Select values Y Select values - Insert / update + adem + Y + + + master data bp odoo + odoo + Y + + + adem + Merge join + Y + + + odoo + Merge join + Y + + + Merge join + Select values 2 + Y + + + Select values 2 + insert update adempiere dw indoteknik Y - Insert / update + insert update adempiere dw indoteknik InsertUpdate Y @@ -567,6 +678,16 @@ salesperson Y + + value + value + Y + + + bp_odoo_name + odoo_partner_name + Y + @@ -577,8 +698,8 @@ - 576 - 80 + 1088 + 400 Y @@ -645,7 +766,7 @@ String -1 -1 - none + both N @@ -657,7 +778,7 @@ String -1 -1 - none + both N @@ -994,7 +1115,7 @@ - Select values + data trx adempiere SelectValues Y @@ -1053,6 +1174,915 @@ Y + + Table input + TableInput + + Y + + 1 + + none + + + erp indoteknik production + select id, name, reference_number from res_partner where reference_number is not null + 0 + + N + N + N + N + + + Integer + normal + id + 9 + 0 + Table input + id + ####0;-####0 + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal + name + 2147483647 + -1 + Table input + name + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal + reference_number + 2147483647 + -1 + Table input + reference_number + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 352 + 400 + Y + + + + master data bp odoo + SelectValues + + Y + + 1 + + none + + + + + id + odoo_partner_id + + + name + odoo_partner_name + + + reference_number + odoo_ref_number + + N + + id + id + Integer + 9 + 0 + + false + + + false + + + + + + + + name + name + String + 2147483647 + -2 + + false + + + false + + + + + + + + reference_number + reference_number + String + 2147483647 + -2 + + false + + + false + + + + + + + + + + + + + + + + + 512 + 400 + Y + + + + Merge join + MergeJoin + + Y + + 1 + + none + + + LEFT OUTER + adem + odoo + + value + + + odoo_ref_number + + + + + + + + + + + 768 + 400 + Y + + + + Table input 2 + TableInput + + Y + + 1 + + none + + + dw bi indoteknik + select name, value from bp_altama + 0 + + N + N + N + N + + + String + normal + name + 2147483647 + -1 + Table input 2 + name + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + String + normal + value + 2147483647 + -1 + Table input 2 + value + + . + , + + none + N + Y + 0 + N + N + N + en_US + Asia/Bangkok + N + + + + + + + + + + + + 208 + 192 + Y + + + + table bp altama + SelectValues + + Y + + 1 + + none + + + + + name + + + + value + + + N + + name + name + String + 2147483647 + -2 + + false + + + false + + + + + + + + value + value + String + 2147483647 + -2 + + false + + + false + + + + + + + + + + + + + + + + + 416 + 192 + Y + + + + data trx adem + SortRows + + Y + + 1 + + none + + + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + customer + Y + N + N + 0 + N + + + + + + + + + + + + 544 + 80 + Y + + + + bp altama + SortRows + + Y + + 1 + + none + + + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + name + Y + N + N + 0 + N + + + + + + + + + + + + 544 + 192 + Y + + + + Merge join 2 + MergeJoin + + Y + + 1 + + none + + + INNER + data trx adem + bp altama + + customer + + + name + + + + + + + + + + + 656 + 144 + Y + + + + Select values + SelectValues + + Y + + 1 + + none + + + + + customer + + + + invoice_date + + + + price_subtotal + + + + invoice + + + + quantity + + + + product + + + + brand + + + + salesperson + + + + name + + + + value + + + N + + + + + + + + + + + 768 + 144 + Y + + + + adem + SortRows + + Y + + 1 + + none + + + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + value + Y + N + N + 0 + N + + + + + + + + + + + + 768 + 256 + Y + + + + odoo + SortRows + + Y + + 1 + + none + + + %%java.io.tmpdir%% + out + 1000000 + + N + + N + + + odoo_ref_number + Y + N + N + 0 + N + + + + + + + + + + + + 640 + 400 + Y + + + + Select values 2 + SelectValues + + Y + + 1 + + none + + + + + customer + + + + invoice_date + + + + price_subtotal + + + + invoice + + + + quantity + + + + product + + + + brand + + + + salesperson + + + + name + + + + value + + + + odoo_partner_name + + + N + + customer + customer + String + -2 + -2 + + false + + + false + + + + + + + + invoice_date + invoice_date + Date + -2 + -2 + + false + + + false + + + + + + + + price_subtotal + price_subtotal + Number + -2 + -2 + + false + + + false + + + + + + + + invoice + invoice + String + -2 + -2 + + false + + + false + + + + + + + + quantity + quantity + Number + -2 + -2 + + false + + + false + + + + + + + + product + product + String + -2 + -2 + + false + + + false + + + + + + + + brand + brand + String + -2 + -2 + + false + + + false + + + + + + + + salesperson + salesperson + String + -2 + -2 + + false + + + false + + + + + + + + name + name + String + 2147483647 + -2 + + false + + + false + + + + + + + + value + value + String + 2147483647 + -2 + + false + + + false + + + + + + + + odoo_partner_name + odoo_partner_name + String + -2 + -2 + + false + + + false + + + + + + + + + + + + + + + + + 912 + 400 + Y + + -- cgit v1.2.3