From 0f99a02d7a0d55da370734cb92314c2e7a99cb32 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Mon, 1 Jul 2024 15:40:28 +0700
Subject: remove b2b and b2c validation while import accurate

---
 import_accurate_to_data_warehouse.ktr | 321 +---------------------------------
 1 file changed, 2 insertions(+), 319 deletions(-)

diff --git a/import_accurate_to_data_warehouse.ktr b/import_accurate_to_data_warehouse.ktr
index 5f0fad1..57b58be 100644
--- a/import_accurate_to_data_warehouse.ktr
+++ b/import_accurate_to_data_warehouse.ktr
@@ -486,93 +486,27 @@
       </attribute>
     </attributes>
   </connection>
-  <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>
   <order>
     <hop>
       <from>Microsoft Excel input 2</from>
       <to>Select values 2</to>
       <enabled>Y</enabled>
     </hop>
-    <hop>
-      <from>Filter rows</from>
-      <to>Select values 3</to>
-      <enabled>Y</enabled>
-    </hop>
     <hop>
       <from>Select values 2</from>
       <to>Add constants</to>
       <enabled>Y</enabled>
     </hop>
     <hop>
-      <from>Select values 3</from>
-      <to>Insert / update 2</to>
+      <from>Select values</from>
+      <to>Insert / update</to>
       <enabled>Y</enabled>
     </hop>
     <hop>
       <from>Add constants</from>
-      <to>Filter rows</to>
-      <enabled>Y</enabled>
-    </hop>
-    <hop>
-      <from>Filter rows</from>
       <to>Select values</to>
       <enabled>Y</enabled>
     </hop>
-    <hop>
-      <from>Select values</from>
-      <to>Insert / update</to>
-      <enabled>Y</enabled>
-    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -613,41 +547,6 @@
       <draw>Y</draw>
     </GUI>
   </step>
-  <step>
-    <name>Filter rows</name>
-    <type>FilterRows</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <send_true_to>Select values 3</send_true_to>
-    <send_false_to>Select values</send_false_to>
-    <compare>
-      <condition>
-        <negated>N</negated>
-        <leftvalue>tipe</leftvalue>
-        <function>CONTAINS</function>
-        <rightvalue>check</rightvalue>
-      </condition>
-    </compare>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>544</xloc>
-      <yloc>224</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
   <step>
     <name>Insert / update</name>
     <type>InsertUpdate</type>
@@ -716,74 +615,6 @@
       <draw>Y</draw>
     </GUI>
   </step>
-  <step>
-    <name>Insert / update 2</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>total_omzet_by_invoice_accurate</table>
-      <key>
-        <name>invoice</name>
-        <field>invoice</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <value>
-        <name>invoice</name>
-        <rename>invoice</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>date_invoice</name>
-        <rename>date_invoice</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>customer</name>
-        <rename>customer</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>total</name>
-        <rename>total</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>subtotal</name>
-        <rename>subtotal</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>salesperson</name>
-        <rename>salesperson</rename>
-        <update>Y</update>
-      </value>
-    </lookup>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>832</xloc>
-      <yloc>224</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
   <step>
     <name>Microsoft Excel input 2</name>
     <type>ExcelInput</type>
@@ -1231,154 +1062,6 @@
       <draw>Y</draw>
     </GUI>
   </step>
-  <step>
-    <name>Select values 3</name>
-    <type>SelectValues</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <fields>
-      <field>
-        <name>invoice</name>
-      </field>
-      <field>
-        <name>date_invoice</name>
-      </field>
-      <field>
-        <name>customer</name>
-      </field>
-      <field>
-        <name>total</name>
-      </field>
-      <field>
-        <name>subtotal</name>
-      </field>
-      <field>
-        <name>salesperson</name>
-      </field>
-      <select_unspecified>N</select_unspecified>
-      <meta>
-        <name>invoice</name>
-        <rename>invoice</rename>
-        <type>String</type>
-        <length>-2</length>
-        <precision>-2</precision>
-        <conversion_mask/>
-        <date_format_lenient>false</date_format_lenient>
-        <date_format_locale/>
-        <date_format_timezone/>
-        <lenient_string_to_number>false</lenient_string_to_number>
-        <encoding/>
-        <decimal_symbol/>
-        <grouping_symbol/>
-        <currency_symbol/>
-        <storage_type/>
-      </meta>
-      <meta>
-        <name>date_invoice</name>
-        <rename>date_invoice</rename>
-        <type>Date</type>
-        <length>-2</length>
-        <precision>-2</precision>
-        <conversion_mask>yyyy-MM-dd</conversion_mask>
-        <date_format_lenient>false</date_format_lenient>
-        <date_format_locale/>
-        <date_format_timezone/>
-        <lenient_string_to_number>false</lenient_string_to_number>
-        <encoding/>
-        <decimal_symbol/>
-        <grouping_symbol/>
-        <currency_symbol/>
-        <storage_type/>
-      </meta>
-      <meta>
-        <name>customer</name>
-        <rename>customer</rename>
-        <type>String</type>
-        <length>-2</length>
-        <precision>-2</precision>
-        <conversion_mask/>
-        <date_format_lenient>false</date_format_lenient>
-        <date_format_locale/>
-        <date_format_timezone/>
-        <lenient_string_to_number>false</lenient_string_to_number>
-        <encoding/>
-        <decimal_symbol/>
-        <grouping_symbol/>
-        <currency_symbol/>
-        <storage_type/>
-      </meta>
-      <meta>
-        <name>total</name>
-        <rename>total</rename>
-        <type>Number</type>
-        <length>-2</length>
-        <precision>-2</precision>
-        <conversion_mask/>
-        <date_format_lenient>false</date_format_lenient>
-        <date_format_locale/>
-        <date_format_timezone/>
-        <lenient_string_to_number>false</lenient_string_to_number>
-        <encoding/>
-        <decimal_symbol/>
-        <grouping_symbol/>
-        <currency_symbol/>
-        <storage_type/>
-      </meta>
-      <meta>
-        <name>subtotal</name>
-        <rename>subtotal</rename>
-        <type>Number</type>
-        <length>-2</length>
-        <precision>-2</precision>
-        <conversion_mask/>
-        <date_format_lenient>false</date_format_lenient>
-        <date_format_locale/>
-        <date_format_timezone/>
-        <lenient_string_to_number>false</lenient_string_to_number>
-        <encoding/>
-        <decimal_symbol/>
-        <grouping_symbol/>
-        <currency_symbol/>
-        <storage_type/>
-      </meta>
-      <meta>
-        <name>salesperson</name>
-        <rename>salesperson</rename>
-        <type>String</type>
-        <length>-2</length>
-        <precision>-2</precision>
-        <conversion_mask/>
-        <date_format_lenient>false</date_format_lenient>
-        <date_format_locale/>
-        <date_format_timezone/>
-        <lenient_string_to_number>false</lenient_string_to_number>
-        <encoding/>
-        <decimal_symbol/>
-        <grouping_symbol/>
-        <currency_symbol/>
-        <storage_type/>
-      </meta>
-    </fields>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>688</xloc>
-      <yloc>224</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
   <step_error_handling>
   </step_error_handling>
   <slave-step-copy-partition-distribution>
-- 
cgit v1.2.3