test

1 files changed, 7 insertions, 2 deletions

diff --git a/import_partner_one_time.ktr b/import_partner_one_time.ktr
index e99f884..92901fd 100644
--- a/import_partner_one_time.ktr
+++ b/import_partner_one_time.ktr
@@ -648,6 +648,11 @@
         <rename>group_partner_id</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>user_id</name>
+        <rename>user_id</rename>
+        <update>N</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
@@ -676,10 +681,10 @@
     </partitioning>
     <connection>erp indoteknik production (localhost)</connection>
     <sql>select id, name, display_name, active, email, industry_id, state_id, kota_id, 
-kecamatan_id, kelurahan_id, is_potential, parent_id, email, phone, mobile, pareto_status, group_partner_id
+kecamatan_id, kelurahan_id, is_potential, parent_id, email, phone, mobile, pareto_status, group_partner_id, user_id
 from res_partner 
 --where write_date >= (now() - '5 days'::interval)
-where pareto_status is not null</sql>
+where user_id is not null</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>