diff options
Diffstat (limited to 'import_price_group.ktr')
| -rw-r--r-- | import_price_group.ktr | 202 |
1 files changed, 106 insertions, 96 deletions
diff --git a/import_price_group.ktr b/import_price_group.ktr index 459c61c..8eebead 100644 --- a/import_price_group.ktr +++ b/import_price_group.ktr @@ -442,8 +442,8 @@ <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> - <username>pdi</username> - <password>Encrypted 2be989bb20084ca95810197629d9ea18e</password> + <username>odoo</username> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -545,99 +545,6 @@ </hop> </order> <step> - <name>dw Insert / update group</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> - <value> - <name>group6</name> - <rename>group6</rename> - <update>Y</update> - </value> - <value> - <name>group7</name> - <rename>group7</rename> - <update>Y</update> - </value> - <value> - <name>group8</name> - <rename>group8</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/> @@ -649,7 +556,7 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select id, name, pricelist_id, group1, group2, group3, group4, group5, group6, group7, group8 from price_group pg</sql> + <sql>select id, name, pricelist_id, group1, group2, group3, group4, group5, group6, group7, group8, group9, group10 from price_group pg</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -856,6 +763,109 @@ <draw>Y</draw> </GUI> </step> + <step> + <name>dw Insert / update group</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> + <value> + <name>group6</name> + <rename>group6</rename> + <update>Y</update> + </value> + <value> + <name>group7</name> + <rename>group7</rename> + <update>Y</update> + </value> + <value> + <name>group8</name> + <rename>group8</rename> + <update>Y</update> + </value> + <value> + <name>group9</name> + <rename>group9</rename> + <update>Y</update> + </value> + <value> + <name>group10</name> + <rename>group10</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> |