refactor again

15 files changed, 226 insertions, 1053 deletions

diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr
index 7b13e71..77feab1 100644
--- a/calculate_price_after_disc.ktr
+++ b/calculate_price_after_disc.ktr
@@ -436,14 +436,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -474,11 +474,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -622,7 +622,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -1110,7 +1110,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -1598,7 +1598,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <sql>select p.product_id, p.item_code, p.name, b.pricing_group,
 coalesce((select
 	case
diff --git a/import_all_data_bi_indoteknik.kjb b/import_all_data_bi_indoteknik.kjb
index 0e4bbd0..25c7ce6 100644
--- a/import_all_data_bi_indoteknik.kjb
+++ b/import_all_data_bi_indoteknik.kjb
@@ -800,357 +800,6 @@
       <yloc>416</yloc>
       <attributes_kjc/>
     </entry>
-    <entry>
-      <name>import brand</name>
-      <description/>
-      <type>TRANS</type>
-      <attributes/>
-      <specification_method>filename</specification_method>
-      <trans_object_id/>
-      <filename>/home/stephan/transformation-job-bi/import_brand.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>928</xloc>
-      <yloc>416</yloc>
-      <attributes_kjc/>
-    </entry>
-    <entry>
-      <name>import pricelist</name>
-      <description/>
-      <type>TRANS</type>
-      <attributes/>
-      <specification_method>filename</specification_method>
-      <trans_object_id/>
-      <filename>/home/stephan/transformation-job-bi/import_pricelist.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>1152</xloc>
-      <yloc>416</yloc>
-      <attributes_kjc/>
-    </entry>
-    <entry>
-      <name>import product</name>
-      <description/>
-      <type>TRANS</type>
-      <attributes/>
-      <specification_method>filename</specification_method>
-      <trans_object_id/>
-      <filename>/home/stephan/transformation-job-bi/import_product_product.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>1152</xloc>
-      <yloc>560</yloc>
-      <attributes_kjc/>
-    </entry>
-    <entry>
-      <name>import purchase order</name>
-      <description/>
-      <type>TRANS</type>
-      <attributes/>
-      <specification_method>filename</specification_method>
-      <trans_object_id/>
-      <filename>/home/stephan/transformation-job-bi/import_purchase_order.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>928</xloc>
-      <yloc>560</yloc>
-      <attributes_kjc/>
-    </entry>
-    <entry>
-      <name>import purchase pricelist</name>
-      <description/>
-      <type>TRANS</type>
-      <attributes/>
-      <specification_method>filename</specification_method>
-      <trans_object_id/>
-      <filename>/home/stephan/transformation-job-bi/import_purchase_pricelist.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>704</xloc>
-      <yloc>560</yloc>
-      <attributes_kjc/>
-    </entry>
-    <entry>
-      <name>import price group</name>
-      <description/>
-      <type>TRANS</type>
-      <attributes/>
-      <specification_method>filename</specification_method>
-      <trans_object_id/>
-      <filename>/home/stephan/transformation-job-bi/import_price_group.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>480</xloc>
-      <yloc>560</yloc>
-      <attributes_kjc/>
-    </entry>
-    <entry>
-      <name>count product</name>
-      <description/>
-      <type>TRANS</type>
-      <attributes/>
-      <specification_method>filename</specification_method>
-      <trans_object_id/>
-      <filename>/home/stephan/transformation-job-bi/update_count_trx_po_product.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>320</xloc>
-      <yloc>560</yloc>
-      <attributes_kjc/>
-    </entry>
-    <entry>
-      <name>count vendor</name>
-      <description/>
-      <type>TRANS</type>
-      <attributes/>
-      <specification_method>filename</specification_method>
-      <trans_object_id/>
-      <filename>/home/stephan/transformation-job-bi/update_count_trx_po_vendor.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>560</yloc>
-      <attributes_kjc/>
-    </entry>
-    <entry>
-      <name>calculate pricelist</name>
-      <description/>
-      <type>TRANS</type>
-      <attributes/>
-      <specification_method>filename</specification_method>
-      <trans_object_id/>
-      <filename>/home/stephan/transformation-job-bi/calculate_price_after_disc.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>688</yloc>
-      <attributes_kjc/>
-    </entry>
   </entries>
   <hops>
     <hop>
@@ -1270,87 +919,6 @@
       <evaluation>Y</evaluation>
       <unconditional>N</unconditional>
     </hop>
-    <hop>
-      <from>import sale order</from>
-      <to>import brand</to>
-      <from_nr>0</from_nr>
-      <to_nr>0</to_nr>
-      <enabled>Y</enabled>
-      <evaluation>Y</evaluation>
-      <unconditional>N</unconditional>
-    </hop>
-    <hop>
-      <from>import brand</from>
-      <to>import pricelist</to>
-      <from_nr>0</from_nr>
-      <to_nr>0</to_nr>
-      <enabled>Y</enabled>
-      <evaluation>Y</evaluation>
-      <unconditional>N</unconditional>
-    </hop>
-    <hop>
-      <from>import pricelist</from>
-      <to>import product</to>
-      <from_nr>0</from_nr>
-      <to_nr>0</to_nr>
-      <enabled>Y</enabled>
-      <evaluation>Y</evaluation>
-      <unconditional>N</unconditional>
-    </hop>
-    <hop>
-      <from>import product</from>
-      <to>import purchase order</to>
-      <from_nr>0</from_nr>
-      <to_nr>0</to_nr>
-      <enabled>Y</enabled>
-      <evaluation>Y</evaluation>
-      <unconditional>N</unconditional>
-    </hop>
-    <hop>
-      <from>import purchase order</from>
-      <to>import purchase pricelist</to>
-      <from_nr>0</from_nr>
-      <to_nr>0</to_nr>
-      <enabled>Y</enabled>
-      <evaluation>Y</evaluation>
-      <unconditional>N</unconditional>
-    </hop>
-    <hop>
-      <from>import purchase pricelist</from>
-      <to>import price group</to>
-      <from_nr>0</from_nr>
-      <to_nr>0</to_nr>
-      <enabled>Y</enabled>
-      <evaluation>Y</evaluation>
-      <unconditional>N</unconditional>
-    </hop>
-    <hop>
-      <from>import price group</from>
-      <to>count product</to>
-      <from_nr>0</from_nr>
-      <to_nr>0</to_nr>
-      <enabled>Y</enabled>
-      <evaluation>Y</evaluation>
-      <unconditional>N</unconditional>
-    </hop>
-    <hop>
-      <from>count product</from>
-      <to>count vendor</to>
-      <from_nr>0</from_nr>
-      <to_nr>0</to_nr>
-      <enabled>Y</enabled>
-      <evaluation>Y</evaluation>
-      <unconditional>N</unconditional>
-    </hop>
-    <hop>
-      <from>count vendor</from>
-      <to>calculate pricelist</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_brand.ktr b/import_brand.ktr
index cc956af..4bbf1a2 100644
--- a/import_brand.ktr
+++ b/import_brand.ktr
@@ -436,14 +436,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -474,11 +474,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -487,8 +487,8 @@
     </attributes>
   </connection>
   <connection>
-    <name>erp indoteknik production</name>
-    <server>34.101.171.249</server>
+    <name>erp indoteknik production (localhost)</name>
+    <server>localhost</server>
     <type>POSTGRESQL</type>
     <access>Native</access>
     <database>erp_indoteknik</database>
@@ -500,41 +500,9 @@
     <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>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>USE_POOLING</code>
-        <attribute>N</attribute>
-      </attribute>
     </attributes>
   </connection>
   <order>
@@ -555,7 +523,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -618,7 +586,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik production</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <sql>select id, x_name, x_manufacture_level, 
 (select x_name from x_manufactures xm2 where xm2.id = xm.parent_id) as parent, pricing_group
 from x_manufactures xm
diff --git a/import_price_group.ktr b/import_price_group.ktr
index 05f5414..8a2460d 100644
--- a/import_price_group.ktr
+++ b/import_price_group.ktr
@@ -430,20 +430,20 @@
     <created_date>2023/08/22 09:00:32.267</created_date>
     <modified_user>-</modified_user>
     <modified_date>2023/08/22 09:00:32.267</modified_date>
-    <key_for_session_key/>
+    <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>
     <is_key_private>N</is_key_private>
   </info>
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -474,11 +474,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -487,8 +487,8 @@
     </attributes>
   </connection>
   <connection>
-    <name>erp indoteknik production</name>
-    <server>34.101.171.249</server>
+    <name>erp indoteknik production (localhost)</name>
+    <server>localhost</server>
     <type>POSTGRESQL</type>
     <access>Native</access>
     <database>erp_indoteknik</database>
@@ -500,41 +500,9 @@
     <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>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>USE_POOLING</code>
-        <attribute>N</attribute>
-      </attribute>
     </attributes>
   </connection>
   <order>
@@ -545,6 +513,84 @@
     </hop>
   </order>
   <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>price_group_dw</table>
+      <key>
+        <name>id</name>
+        <field>id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <value>
+        <name>id</name>
+        <rename>id</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>name</name>
+        <rename>name</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>pricelist_id</name>
+        <rename>pricelist_id</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>group1</name>
+        <rename>group1</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>group2</name>
+        <rename>group2</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>group3</name>
+        <rename>group3</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>group4</name>
+        <rename>group4</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>group5</name>
+        <rename>group5</rename>
+        <update>Y</update>
+      </value>
+    </lookup>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>480</xloc>
+      <yloc>112</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
     <name>Table input</name>
     <type>TableInput</type>
     <description/>
@@ -555,7 +601,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik production</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <sql>select id, name, pricelist_id, group1, group2, group3, group4, group5 from price_group pg</sql>
     <limit>0</limit>
     <lookup/>
@@ -763,84 +809,6 @@
       <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</connection>
-    <commit>100</commit>
-    <update_bypassed>N</update_bypassed>
-    <lookup>
-      <schema>public</schema>
-      <table>price_group_dw</table>
-      <key>
-        <name>id</name>
-        <field>id</field>
-        <condition>=</condition>
-        <name2/>
-      </key>
-      <value>
-        <name>id</name>
-        <rename>id</rename>
-        <update>N</update>
-      </value>
-      <value>
-        <name>name</name>
-        <rename>name</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>pricelist_id</name>
-        <rename>pricelist_id</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>group1</name>
-        <rename>group1</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>group2</name>
-        <rename>group2</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>group3</name>
-        <rename>group3</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>group4</name>
-        <rename>group4</rename>
-        <update>Y</update>
-      </value>
-      <value>
-        <name>group5</name>
-        <rename>group5</rename>
-        <update>Y</update>
-      </value>
-    </lookup>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>480</xloc>
-      <yloc>112</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
   <step_error_handling>
   </step_error_handling>
   <slave-step-copy-partition-distribution>
diff --git a/import_product_product.ktr b/import_product_product.ktr
index 640a1a5..17c48ef 100644
--- a/import_product_product.ktr
+++ b/import_product_product.ktr
@@ -436,14 +436,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -474,11 +474,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -487,8 +487,8 @@
     </attributes>
   </connection>
   <connection>
-    <name>erp indoteknik production</name>
-    <server>34.101.171.249</server>
+    <name>erp indoteknik production (localhost)</name>
+    <server>localhost</server>
     <type>POSTGRESQL</type>
     <access>Native</access>
     <database>erp_indoteknik</database>
@@ -500,41 +500,9 @@
     <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>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>USE_POOLING</code>
-        <attribute>N</attribute>
-      </attribute>
     </attributes>
   </connection>
   <order>
@@ -543,51 +511,8 @@
       <to>Insert / update</to>
       <enabled>Y</enabled>
     </hop>
-    <hop>
-      <from>Insert / update</from>
-      <to>Execute SQL script</to>
-      <enabled>N</enabled>
-    </hop>
   </order>
   <step>
-    <name>Execute SQL script</name>
-    <type>ExecSQL</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <connection>dw bi indoteknik</connection>
-    <execute_each_row>N</execute_each_row>
-    <single_statement>N</single_statement>
-    <replace_variables>N</replace_variables>
-    <quoteString>N</quoteString>
-    <sql>refresh materialized view mv_growth_existing_customer;</sql>
-    <set_params>N</set_params>
-    <insert_field/>
-    <update_field/>
-    <delete_field/>
-    <read_field/>
-    <arguments>
-    </arguments>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>576</xloc>
-      <yloc>128</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
-  <step>
     <name>Insert / update</name>
     <type>InsertUpdate</type>
     <description/>
@@ -598,7 +523,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -686,7 +611,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik production</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <sql>select pp.id as product_id, pt.id as template_id, pt.name, pp.active, pt.x_manufacture as brand_id,
 case when pp.default_code is null then pt.default_code else pp.default_code end as item_code,
 (select name from product_public_category ppc where id in((select replace(left(parent_path, 2), '/', '')::int from product_public_category 
diff --git a/import_purchase_order.ktr b/import_purchase_order.ktr
index ee85cad..3d798b4 100644
--- a/import_purchase_order.ktr
+++ b/import_purchase_order.ktr
@@ -436,14 +436,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -474,11 +474,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -487,8 +487,8 @@
     </attributes>
   </connection>
   <connection>
-    <name>erp indoteknik production</name>
-    <server>34.101.171.249</server>
+    <name>erp indoteknik production (localhost)</name>
+    <server>localhost</server>
     <type>POSTGRESQL</type>
     <access>Native</access>
     <database>erp_indoteknik</database>
@@ -500,41 +500,9 @@
     <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>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>USE_POOLING</code>
-        <attribute>N</attribute>
-      </attribute>
     </attributes>
   </connection>
   <order>
@@ -555,7 +523,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -668,7 +636,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik production</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <sql>select po.write_date as po_date, pol.write_date as line_date, po.name as documentno, 
 po.state, po.partner_id, rp.name as vendor, pol.product_id, pol.product_uom_qty as qty, 
 pol.price_unit, pol.price_subtotal, pol.id as line_id,
diff --git a/import_purchase_pricelist.ktr b/import_purchase_pricelist.ktr
index e64fd60..1de88f4 100644
--- a/import_purchase_pricelist.ktr
+++ b/import_purchase_pricelist.ktr
@@ -436,14 +436,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -474,11 +474,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -487,8 +487,8 @@
     </attributes>
   </connection>
   <connection>
-    <name>erp indoteknik production</name>
-    <server>34.101.171.249</server>
+    <name>erp indoteknik production (localhost)</name>
+    <server>localhost</server>
     <type>POSTGRESQL</type>
     <access>Native</access>
     <database>erp_indoteknik</database>
@@ -500,41 +500,9 @@
     <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>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>USE_POOLING</code>
-        <attribute>N</attribute>
-      </attribute>
     </attributes>
   </connection>
   <order>
@@ -555,7 +523,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -638,7 +606,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik production</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <sql>select pp.id, pp.product_id, pp.vendor_id, rp.name as vendor, pp.product_price, pp.write_date,
 pp.system_price, pp.system_last_update, pp.human_last_update
 from purchase_pricelist pp
diff --git a/insert_update_pricelist.ktr b/insert_update_pricelist.ktr
index f14e7f6..335cd76 100644
--- a/insert_update_pricelist.ktr
+++ b/insert_update_pricelist.ktr
@@ -437,14 +437,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -475,11 +475,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -488,54 +488,22 @@
     </attributes>
   </connection>
   <connection>
-    <name>erp indoteknik local</name>
+    <name>erp indoteknik production (localhost)</name>
     <server>localhost</server>
     <type>POSTGRESQL</type>
     <access>Native</access>
-    <database>indoteknik_20230914</database>
+    <database>erp_indoteknik</database>
     <port>5432</port>
     <username>odoo</username>
-    <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <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>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>USE_POOLING</code>
-        <attribute>N</attribute>
-      </attribute>
     </attributes>
   </connection>
   <order>
@@ -785,7 +753,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -884,7 +852,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -927,7 +895,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -1036,7 +1004,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, 
 disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5,
 round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, 
@@ -1377,7 +1345,7 @@ order by product_id</sql>
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <sql>select * from product_pricelist_item where pricelist_id = 17022 order by product_id</sql>
     <limit>0</limit>
     <lookup/>
@@ -2017,7 +1985,7 @@ order by product_id</sql>
       </output>
     </remotesteps>
     <GUI>
-      <xloc>416</xloc>
+      <xloc>400</xloc>
       <yloc>128</yloc>
       <draw>Y</draw>
     </GUI>
diff --git a/insert_update_pricelist1.ktr b/insert_update_pricelist1.ktr
index 77dc10f..f84c8fe 100644
--- a/insert_update_pricelist1.ktr
+++ b/insert_update_pricelist1.ktr
@@ -437,14 +437,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -475,11 +475,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -488,54 +488,22 @@
     </attributes>
   </connection>
   <connection>
-    <name>erp indoteknik local</name>
+    <name>erp indoteknik production (localhost)</name>
     <server>localhost</server>
     <type>POSTGRESQL</type>
     <access>Native</access>
-    <database>indoteknik_20230914</database>
+    <database>erp_indoteknik</database>
     <port>5432</port>
     <username>odoo</username>
-    <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <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>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>USE_POOLING</code>
-        <attribute>N</attribute>
-      </attribute>
     </attributes>
   </connection>
   <order>
@@ -785,7 +753,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -884,7 +852,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -927,7 +895,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -1036,7 +1004,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, 
 disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5,
 round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, 
@@ -1377,7 +1345,7 @@ order by product_id</sql>
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <sql>select * from product_pricelist_item where pricelist_id = 17023 order by product_id</sql>
     <limit>0</limit>
     <lookup/>
diff --git a/insert_update_pricelist2.ktr b/insert_update_pricelist2.ktr
index dd0f6ea..87064c4 100644
--- a/insert_update_pricelist2.ktr
+++ b/insert_update_pricelist2.ktr
@@ -437,14 +437,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -475,11 +475,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -488,54 +488,22 @@
     </attributes>
   </connection>
   <connection>
-    <name>erp indoteknik local</name>
+    <name>erp indoteknik production (localhost)</name>
     <server>localhost</server>
     <type>POSTGRESQL</type>
     <access>Native</access>
-    <database>indoteknik_20230914</database>
+    <database>erp_indoteknik</database>
     <port>5432</port>
     <username>odoo</username>
-    <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <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>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>USE_POOLING</code>
-        <attribute>N</attribute>
-      </attribute>
     </attributes>
   </connection>
   <order>
@@ -785,7 +753,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -884,7 +852,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -927,7 +895,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -1036,7 +1004,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, 
 disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5,
 round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, 
@@ -1377,7 +1345,7 @@ order by product_id</sql>
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <sql>select * from product_pricelist_item where pricelist_id = 17024 order by product_id</sql>
     <limit>0</limit>
     <lookup/>
diff --git a/insert_update_pricelist3.ktr b/insert_update_pricelist3.ktr
index 357db0b..c2981fb 100644
--- a/insert_update_pricelist3.ktr
+++ b/insert_update_pricelist3.ktr
@@ -437,14 +437,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -475,11 +475,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -488,54 +488,22 @@
     </attributes>
   </connection>
   <connection>
-    <name>erp indoteknik local</name>
+    <name>erp indoteknik production (localhost)</name>
     <server>localhost</server>
     <type>POSTGRESQL</type>
     <access>Native</access>
-    <database>indoteknik_20230914</database>
+    <database>erp_indoteknik</database>
     <port>5432</port>
     <username>odoo</username>
-    <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <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>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>USE_POOLING</code>
-        <attribute>N</attribute>
-      </attribute>
     </attributes>
   </connection>
   <order>
@@ -785,7 +753,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -884,7 +852,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -927,7 +895,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -1036,7 +1004,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, 
 disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5,
 round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, 
@@ -1377,7 +1345,7 @@ order by product_id</sql>
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <sql>select * from product_pricelist_item where pricelist_id = 17025 order by product_id</sql>
     <limit>0</limit>
     <lookup/>
diff --git a/insert_update_pricelist4.ktr b/insert_update_pricelist4.ktr
index c8feb72..b5fc7c1 100644
--- a/insert_update_pricelist4.ktr
+++ b/insert_update_pricelist4.ktr
@@ -437,14 +437,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -475,11 +475,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -488,54 +488,22 @@
     </attributes>
   </connection>
   <connection>
-    <name>erp indoteknik local</name>
+    <name>erp indoteknik production (localhost)</name>
     <server>localhost</server>
     <type>POSTGRESQL</type>
     <access>Native</access>
-    <database>indoteknik_20230914</database>
+    <database>erp_indoteknik</database>
     <port>5432</port>
     <username>odoo</username>
-    <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <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>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>USE_POOLING</code>
-        <attribute>N</attribute>
-      </attribute>
     </attributes>
   </connection>
   <order>
@@ -785,7 +753,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -884,7 +852,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -927,7 +895,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -1036,7 +1004,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, 
 disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5,
 round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, 
@@ -1377,7 +1345,7 @@ order by product_id</sql>
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <sql>select * from product_pricelist_item where pricelist_id = 17026 order by product_id</sql>
     <limit>0</limit>
     <lookup/>
diff --git a/insert_update_pricelist5.ktr b/insert_update_pricelist5.ktr
index e747546..be0b9c1 100644
--- a/insert_update_pricelist5.ktr
+++ b/insert_update_pricelist5.ktr
@@ -437,14 +437,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -475,11 +475,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -488,54 +488,22 @@
     </attributes>
   </connection>
   <connection>
-    <name>erp indoteknik local</name>
+    <name>erp indoteknik production (localhost)</name>
     <server>localhost</server>
     <type>POSTGRESQL</type>
     <access>Native</access>
-    <database>indoteknik_20230914</database>
+    <database>erp_indoteknik</database>
     <port>5432</port>
     <username>odoo</username>
-    <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <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>Y</attribute>
-      </attribute>
-      <attribute>
-        <code>USE_POOLING</code>
-        <attribute>N</attribute>
-      </attribute>
     </attributes>
   </connection>
   <order>
@@ -785,7 +753,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -884,7 +852,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -927,7 +895,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <commit>100</commit>
     <update_bypassed>N</update_bypassed>
     <lookup>
@@ -1036,7 +1004,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, 
 disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5,
 round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, 
@@ -1377,7 +1345,7 @@ order by product_id</sql>
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>erp indoteknik local</connection>
+    <connection>erp indoteknik production (localhost)</connection>
     <sql>select * from product_pricelist_item where pricelist_id = 17027 order by product_id</sql>
     <limit>0</limit>
     <lookup/>
diff --git a/update_count_trx_po_product.ktr b/update_count_trx_po_product.ktr
index c9839aa..515f468 100644
--- a/update_count_trx_po_product.ktr
+++ b/update_count_trx_po_product.ktr
@@ -436,14 +436,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -474,11 +474,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -509,7 +509,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <execute_each_row>N</execute_each_row>
     <single_statement>N</single_statement>
     <replace_variables>N</replace_variables>
@@ -547,7 +547,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <sql>select pod.product_id, pod.partner_id, count(pod.documentno) as counter from purchase_order_dw pod
 where pod.state = 'done'
 group by pod.product_id, pod.partner_id</sql>
@@ -653,7 +653,7 @@ group by pod.product_id, pod.partner_id</sql>
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <skip_lookup>N</skip_lookup>
     <commit>100</commit>
     <use_batch>N</use_batch>
diff --git a/update_count_trx_po_vendor.ktr b/update_count_trx_po_vendor.ktr
index ab116d9..2dc4f32 100644
--- a/update_count_trx_po_vendor.ktr
+++ b/update_count_trx_po_vendor.ktr
@@ -436,14 +436,14 @@
   <notepads>
   </notepads>
   <connection>
-    <name>dw bi indoteknik</name>
-    <server>192.168.23.5</server>
+    <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 2be98afc86aa7f2e4cb79ce10d196a0d5</password>
+    <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password>
     <servername/>
     <data_tablespace/>
     <index_tablespace/>
@@ -474,11 +474,11 @@
       </attribute>
       <attribute>
         <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
-        <attribute>Y</attribute>
+        <attribute>N</attribute>
       </attribute>
       <attribute>
         <code>USE_POOLING</code>
@@ -509,7 +509,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <execute_each_row>N</execute_each_row>
     <single_statement>N</single_statement>
     <replace_variables>N</replace_variables>
@@ -547,7 +547,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <sql>select pod.partner_id, count(pod.documentno) as counter from purchase_order_dw pod
 where pod.state = 'done'
 group by pod.partner_id</sql>
@@ -630,7 +630,7 @@ group by pod.partner_id</sql>
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <connection>dw bi indoteknik</connection>
+    <connection>dw bi indoteknik (localhost)</connection>
     <skip_lookup>N</skip_lookup>
     <commit>100</commit>
     <use_batch>N</use_batch>