diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-09-18 13:32:00 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-09-18 13:32:00 +0700 |
| commit | 76a5f56f324986a18ced12d01214670fdc18663e (patch) | |
| tree | 77d73102aa001cdc78c2424db76509c9c58290e7 /import_purchase_order.ktr | |
| parent | 9828160c003af8915fd837f2ae4d3271387ea8e3 (diff) | |
refactor again
Diffstat (limited to 'import_purchase_order.ktr')
| -rw-r--r-- | import_purchase_order.ktr | 50 |
1 files changed, 9 insertions, 41 deletions
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, |