diff options
Diffstat (limited to 'import_account_financial_report.ktr')
| -rw-r--r-- | import_account_financial_report.ktr | 352 |
1 files changed, 176 insertions, 176 deletions
diff --git a/import_account_financial_report.ktr b/import_account_financial_report.ktr index b388a68..2763931 100644 --- a/import_account_financial_report.ktr +++ b/import_account_financial_report.ktr @@ -430,20 +430,20 @@ <created_date>2024/05/10 11:31:21.038</created_date> <modified_user>-</modified_user> <modified_date>2024/05/10 11:31:21.038</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> + <name>dw bi indoteknik (localhost)</name> <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> - <port>5703</port> - <username>metabase</username> - <password>Encrypted 2be98dfba28d7bf86853c9f58cfc4f889</password> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -462,7 +462,7 @@ </attribute> <attribute> <code>PORT_NUMBER</code> - <attribute>5703</attribute> + <attribute>5432</attribute> </attribute> <attribute> <code>PRESERVE_RESERVED_WORD_CASE</code> @@ -478,7 +478,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -487,12 +487,12 @@ </attributes> </connection> <connection> - <name>erp indoteknik production</name> - <server>localhost</server> + <name>erp indoteknik production (localhost)</name> + <server>10.148.0.3</server> <type>POSTGRESQL</type> <access>Native</access> <database>erp_indoteknik</database> - <port>5901</port> + <port>5432</port> <username>odoo</username> <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> @@ -513,7 +513,7 @@ </attribute> <attribute> <code>PORT_NUMBER</code> - <attribute>5901</attribute> + <attribute>5432</attribute> </attribute> <attribute> <code>PRESERVE_RESERVED_WORD_CASE</code> @@ -529,7 +529,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -550,6 +550,168 @@ </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>account_financial_report</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>parent_id</name> + <rename>parent_id</rename> + <update>Y</update> + </value> + <value> + <name>sequence</name> + <rename>sequence</rename> + <update>Y</update> + </value> + <value> + <name>level</name> + <rename>level</rename> + <update>Y</update> + </value> + <value> + <name>type</name> + <rename>type</rename> + <update>Y</update> + </value> + <value> + <name>account_report_id</name> + <rename>account_report_id</rename> + <update>Y</update> + </value> + <value> + <name>sign</name> + <rename>sign</rename> + <update>Y</update> + </value> + <value> + <name>display_detail</name> + <rename>display_detail</rename> + <update>Y</update> + </value> + <value> + <name>style_overwrite</name> + <rename>style_overwrite</rename> + <update>Y</update> + </value> + <value> + <name>create_uid</name> + <rename>create_uid</rename> + <update>Y</update> + </value> + <value> + <name>create_date</name> + <rename>create_date</rename> + <update>Y</update> + </value> + <value> + <name>write_uid</name> + <rename>write_uid</rename> + <update>Y</update> + </value> + <value> + <name>write_date</name> + <rename>write_date</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>432</xloc> + <yloc>112</yloc> + <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>Y</update_bypassed> + <lookup> + <schema>public</schema> + <table>account_account_financial_report</table> + <key> + <name>report_line_id</name> + <field>report_line_id</field> + <condition>=</condition> + <name2/> + </key> + <key> + <name>account_id</name> + <field>account_id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>report_line_id</name> + <rename>report_line_id</rename> + <update>Y</update> + </value> + <value> + <name>account_id</name> + <rename>account_id</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>432</xloc> + <yloc>240</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -560,7 +722,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production</connection> + <connection>erp indoteknik production (localhost)</connection> <sql>select * from account_financial_report</sql> <limit>0</limit> <lookup/> @@ -907,114 +1069,6 @@ </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>account_financial_report</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>parent_id</name> - <rename>parent_id</rename> - <update>Y</update> - </value> - <value> - <name>sequence</name> - <rename>sequence</rename> - <update>Y</update> - </value> - <value> - <name>level</name> - <rename>level</rename> - <update>Y</update> - </value> - <value> - <name>type</name> - <rename>type</rename> - <update>Y</update> - </value> - <value> - <name>account_report_id</name> - <rename>account_report_id</rename> - <update>Y</update> - </value> - <value> - <name>sign</name> - <rename>sign</rename> - <update>Y</update> - </value> - <value> - <name>display_detail</name> - <rename>display_detail</rename> - <update>Y</update> - </value> - <value> - <name>style_overwrite</name> - <rename>style_overwrite</rename> - <update>Y</update> - </value> - <value> - <name>create_uid</name> - <rename>create_uid</rename> - <update>Y</update> - </value> - <value> - <name>create_date</name> - <rename>create_date</rename> - <update>Y</update> - </value> - <value> - <name>write_uid</name> - <rename>write_uid</rename> - <update>Y</update> - </value> - <value> - <name>write_date</name> - <rename>write_date</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>432</xloc> - <yloc>112</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> <name>Table input 2</name> <type>TableInput</type> <description/> @@ -1025,7 +1079,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production</connection> + <connection>erp indoteknik production (localhost)</connection> <sql>select * from account_account_financial_report</sql> <limit>0</limit> <lookup/> @@ -1095,60 +1149,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</connection> - <commit>100</commit> - <update_bypassed>Y</update_bypassed> - <lookup> - <schema>public</schema> - <table>account_account_financial_report</table> - <key> - <name>report_line_id</name> - <field>report_line_id</field> - <condition>=</condition> - <name2/> - </key> - <key> - <name>account_id</name> - <field>account_id</field> - <condition>=</condition> - <name2/> - </key> - <value> - <name>report_line_id</name> - <rename>report_line_id</rename> - <update>Y</update> - </value> - <value> - <name>account_id</name> - <rename>account_id</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>432</xloc> - <yloc>240</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |