diff options
| -rw-r--r-- | import_accurate_fixco_to_data_warehouse.ktr | 1513 | ||||
| -rw-r--r-- | import_accurate_to_data_warehouse.ktr | 1394 | ||||
| -rw-r--r-- | import_adempiere_to_data_warehouse.ktr | 1062 | ||||
| -rw-r--r-- | import_all_data_bi_indoteknik.kjb | 638 | ||||
| -rw-r--r-- | import_odoo_14_to_data_warehouse.ktr | 1195 | ||||
| -rw-r--r-- | refresh_materialized_view.ktr | 750 | ||||
| -rw-r--r-- | refresh_materialized_view_fixco.ktr | 750 |
7 files changed, 7302 insertions, 0 deletions
diff --git a/import_accurate_fixco_to_data_warehouse.ktr b/import_accurate_fixco_to_data_warehouse.ktr new file mode 100644 index 0000000..e30b7b6 --- /dev/null +++ b/import_accurate_fixco_to_data_warehouse.ktr @@ -0,0 +1,1513 @@ +<?xml version="1.0" encoding="UTF-8"?> +<transformation> + <info> + <name>import_accurate_fixco_to_data_warehouse</name> + <description/> + <extended_description/> + <trans_version/> + <trans_type>Normal</trans_type> + <directory>/</directory> + <parameters> + </parameters> + <log> + <trans-log-table> + <connection/> + <schema/> + <table/> + <size_limit_lines/> + <interval/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STATUS</id> + <enabled>Y</enabled> + <name>STATUS</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + <subject/> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + <subject/> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + <subject/> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + <subject/> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + <subject/> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + <subject/> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>STARTDATE</id> + <enabled>Y</enabled> + <name>STARTDATE</name> + </field> + <field> + <id>ENDDATE</id> + <enabled>Y</enabled> + <name>ENDDATE</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>DEPDATE</id> + <enabled>Y</enabled> + <name>DEPDATE</name> + </field> + <field> + <id>REPLAYDATE</id> + <enabled>Y</enabled> + <name>REPLAYDATE</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>Y</enabled> + <name>LOG_FIELD</name> + </field> + <field> + <id>EXECUTING_SERVER</id> + <enabled>N</enabled> + <name>EXECUTING_SERVER</name> + </field> + <field> + <id>EXECUTING_USER</id> + <enabled>N</enabled> + <name>EXECUTING_USER</name> + </field> + <field> + <id>CLIENT</id> + <enabled>N</enabled> + <name>CLIENT</name> + </field> + </trans-log-table> + <perf-log-table> + <connection/> + <schema/> + <table/> + <interval/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>SEQ_NR</id> + <enabled>Y</enabled> + <name>SEQ_NR</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STEPNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>STEP_COPY</id> + <enabled>Y</enabled> + <name>STEP_COPY</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>INPUT_BUFFER_ROWS</id> + <enabled>Y</enabled> + <name>INPUT_BUFFER_ROWS</name> + </field> + <field> + <id>OUTPUT_BUFFER_ROWS</id> + <enabled>Y</enabled> + <name>OUTPUT_BUFFER_ROWS</name> + </field> + </perf-log-table> + <channel-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>LOGGING_OBJECT_TYPE</id> + <enabled>Y</enabled> + <name>LOGGING_OBJECT_TYPE</name> + </field> + <field> + <id>OBJECT_NAME</id> + <enabled>Y</enabled> + <name>OBJECT_NAME</name> + </field> + <field> + <id>OBJECT_COPY</id> + <enabled>Y</enabled> + <name>OBJECT_COPY</name> + </field> + <field> + <id>REPOSITORY_DIRECTORY</id> + <enabled>Y</enabled> + <name>REPOSITORY_DIRECTORY</name> + </field> + <field> + <id>FILENAME</id> + <enabled>Y</enabled> + <name>FILENAME</name> + </field> + <field> + <id>OBJECT_ID</id> + <enabled>Y</enabled> + <name>OBJECT_ID</name> + </field> + <field> + <id>OBJECT_REVISION</id> + <enabled>Y</enabled> + <name>OBJECT_REVISION</name> + </field> + <field> + <id>PARENT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>PARENT_CHANNEL_ID</name> + </field> + <field> + <id>ROOT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>ROOT_CHANNEL_ID</name> + </field> + </channel-log-table> + <step-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STEPNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>STEP_COPY</id> + <enabled>Y</enabled> + <name>STEP_COPY</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>N</enabled> + <name>LOG_FIELD</name> + </field> + </step-log-table> + <metrics-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>METRICS_DATE</id> + <enabled>Y</enabled> + <name>METRICS_DATE</name> + </field> + <field> + <id>METRICS_CODE</id> + <enabled>Y</enabled> + <name>METRICS_CODE</name> + </field> + <field> + <id>METRICS_DESCRIPTION</id> + <enabled>Y</enabled> + <name>METRICS_DESCRIPTION</name> + </field> + <field> + <id>METRICS_SUBJECT</id> + <enabled>Y</enabled> + <name>METRICS_SUBJECT</name> + </field> + <field> + <id>METRICS_TYPE</id> + <enabled>Y</enabled> + <name>METRICS_TYPE</name> + </field> + <field> + <id>METRICS_VALUE</id> + <enabled>Y</enabled> + <name>METRICS_VALUE</name> + </field> + </metrics-log-table> + </log> + <maxdate> + <connection/> + <table/> + <field/> + <offset>0.0</offset> + <maxdiff>0.0</maxdiff> + </maxdate> + <size_rowset>10000</size_rowset> + <sleep_time_empty>50</sleep_time_empty> + <sleep_time_full>50</sleep_time_full> + <unique_connections>N</unique_connections> + <feedback_shown>Y</feedback_shown> + <feedback_size>50000</feedback_size> + <using_thread_priorities>Y</using_thread_priorities> + <shared_objects_file/> + <capture_step_performance>N</capture_step_performance> + <step_performance_capturing_delay>1000</step_performance_capturing_delay> + <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit> + <dependencies> + </dependencies> + <partitionschemas> + </partitionschemas> + <slaveservers> + </slaveservers> + <clusterschemas> + </clusterschemas> + <created_user>-</created_user> + <created_date>2023/03/09 15:57:16.496</created_date> + <modified_user>-</modified_user> + <modified_date>2023/03/09 15:57:16.496</modified_date> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> + <is_key_private>N</is_key_private> + </info> + <notepads> + </notepads> + <connection> + <name>dw bi fixco</name> + <server>192.168.23.5</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>dw_bi_fixco</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</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> + <hop> + <from>Microsoft Excel input</from> + <to>Select values</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Select values</from> + <to>Add constants</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Add constants</from> + <to>Filter rows</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Filter rows</from> + <to>Select values 2</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Select values 2</from> + <to>Insert / update</to> + <enabled>Y</enabled> + </hop> + </order> + <step> + <name>Add constants</name> + <type>Constant</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>check</name> + <type>String</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>B2C</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>608</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Filter rows</name> + <type>FilterRows</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <send_true_to>Select values 2</send_true_to> + <send_false_to/> + <compare> + <condition> + <negated>N</negated> + <leftvalue>tipe</leftvalue> + <function>=</function> + <rightvalue>check</rightvalue> + </condition> + </compare> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>720</xloc> + <yloc>144</yloc> + <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 fixco</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>total_omzet_by_product</table> + <key> + <name>item_code</name> + <field>item_code</field> + <condition>=</condition> + <name2/> + </key> + <key> + <name>invoice</name> + <field>invoice</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>tanggal</name> + <rename>tanggal</rename> + <update>Y</update> + </value> + <value> + <name>nomor_po</name> + <rename>nomor_po</rename> + <update>Y</update> + </value> + <value> + <name>customer</name> + <rename>customer</rename> + <update>Y</update> + </value> + <value> + <name>tipe</name> + <rename>tipe</rename> + <update>Y</update> + </value> + <value> + <name>diskon</name> + <rename>diskon</rename> + <update>Y</update> + </value> + <value> + <name>brand</name> + <rename>brand</rename> + <update>Y</update> + </value> + <value> + <name>item_code</name> + <rename>item_code</rename> + <update>N</update> + </value> + <value> + <name>product</name> + <rename>product</rename> + <update>Y</update> + </value> + <value> + <name>qty</name> + <rename>qty</rename> + <update>Y</update> + </value> + <value> + <name>harga</name> + <rename>harga</rename> + <update>Y</update> + </value> + <value> + <name>total_harga</name> + <rename>total_harga</rename> + <update>Y</update> + </value> + <value> + <name>ppn</name> + <rename>ppn</rename> + <update>Y</update> + </value> + <value> + <name>invoice</name> + <rename>invoice</rename> + <update>N</update> + </value> + <value> + <name>dpp</name> + <rename>dpp</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>1008</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Microsoft Excel input</name> + <type>ExcelInput</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <header>Y</header> + <noempty>Y</noempty> + <stoponempty>N</stoponempty> + <filefield/> + <sheetfield/> + <sheetrownumfield/> + <rownumfield/> + <sheetfield/> + <filefield/> + <limit>0</limit> + <encoding/> + <add_to_result_filenames>Y</add_to_result_filenames> + <accept_filenames>N</accept_filenames> + <accept_field/> + <accept_stepname/> + <file> + <name>/home/superman/runapps/rincian_faktur_penjualan_ptfixcokaryanus.xlsx</name> + <filemask/> + <exclude_filemask/> + <file_required>N</file_required> + <include_subfolders>N</include_subfolders> + </file> + <fields> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Tanggal</name> + <type>Date</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>No. PO Pesanan Penjualan</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>both</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Pelanggan</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>both</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Tipe Pelanggan Pelanggan Pesanan Penjualan</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>both</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Diskon Faktur Penjualan</name> + <type>Number</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Nama Kategori Barang Barang & Jasa</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>both</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Kode #</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>both</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Nama Barang</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>both</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Kuantitas</name> + <type>Number</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name> null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>@Harga</name> + <type>Number</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Total Harga</name> + <type>Number</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>PPN Barang</name> + <type>Number</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Nomor #</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>both</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>DPP</name> + <type>Number</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + </fields> + <sheets> + <sheet> + <name>Rincian Faktur Penjualan</name> + <startrow>0</startrow> + <startcol>0</startcol> + </sheet> + </sheets> + <strict_types>N</strict_types> + <error_ignored>N</error_ignored> + <error_line_skipped>N</error_line_skipped> + <bad_line_files_destination_directory/> + <bad_line_files_extension>warning</bad_line_files_extension> + <error_line_files_destination_directory/> + <error_line_files_extension>error</error_line_files_extension> + <line_number_files_destination_directory/> + <line_number_files_extension>line</line_number_files_extension> + <shortFileFieldName/> + <pathFieldName/> + <hiddenFieldName/> + <lastModificationTimeFieldName/> + <uriNameFieldName/> + <rootUriNameFieldName/> + <extensionFieldName/> + <sizeFieldName/> + <spreadsheet_type>POI</spreadsheet_type> + <password>Encrypted </password> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>320</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>Tanggal</name> + <rename>tanggal</rename> + </field> + <field> + <name>No. PO Pesanan Penjualan</name> + <rename>nomor_po</rename> + </field> + <field> + <name>Pelanggan</name> + <rename>customer</rename> + </field> + <field> + <name>Tipe Pelanggan Pelanggan Pesanan Penjualan</name> + <rename>tipe</rename> + </field> + <field> + <name>Diskon Faktur Penjualan</name> + <rename>diskon</rename> + </field> + <field> + <name>Nama Kategori Barang Barang & Jasa</name> + <rename>brand</rename> + </field> + <field> + <name>Kode #</name> + <rename>item_code</rename> + </field> + <field> + <name>Nama Barang</name> + <rename>product</rename> + </field> + <field> + <name>Kuantitas</name> + <rename>qty</rename> + </field> + <field> + <name>@Harga</name> + <rename>harga</rename> + </field> + <field> + <name>Total Harga</name> + <rename>total_harga</rename> + </field> + <field> + <name>PPN Barang</name> + <rename>ppn</rename> + </field> + <field> + <name>Nomor #</name> + <rename>invoice</rename> + </field> + <field> + <name>DPP</name> + <rename>dpp</rename> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>464</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values 2</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>tanggal</name> + </field> + <field> + <name>nomor_po</name> + </field> + <field> + <name>customer</name> + </field> + <field> + <name>tipe</name> + </field> + <field> + <name>diskon</name> + </field> + <field> + <name>brand</name> + </field> + <field> + <name>item_code</name> + </field> + <field> + <name>product</name> + </field> + <field> + <name>qty</name> + </field> + <field> + <name>harga</name> + </field> + <field> + <name>total_harga</name> + </field> + <field> + <name>ppn</name> + </field> + <field> + <name>invoice</name> + </field> + <field> + <name>dpp</name> + </field> + <select_unspecified>N</select_unspecified> + <meta> + <name>tanggal</name> + <rename>tanggal</rename> + <type>Date</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask>yyyy-MM-dd</conversion_mask> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>nomor_po</name> + <rename>nomor_po</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>customer</name> + <rename>customer</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>tipe</name> + <rename>tipe</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>diskon</name> + <rename>diskon</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>brand</name> + <rename>brand</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>item_code</name> + <rename>item_code</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>product</name> + <rename>product</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>qty</name> + <rename>qty</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>harga</name> + <rename>harga</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>total_harga</name> + <rename>total_harga</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>ppn</name> + <rename>ppn</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>invoice</name> + <rename>invoice</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>dpp</name> + <rename>dpp</rename> + <type>None</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>864</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step_error_handling> + </step_error_handling> + <slave-step-copy-partition-distribution> + </slave-step-copy-partition-distribution> + <slave_transformation>N</slave_transformation> + <attributes/> +</transformation> diff --git a/import_accurate_to_data_warehouse.ktr b/import_accurate_to_data_warehouse.ktr new file mode 100644 index 0000000..778b90c --- /dev/null +++ b/import_accurate_to_data_warehouse.ktr @@ -0,0 +1,1394 @@ +<?xml version="1.0" encoding="UTF-8"?> +<transformation> + <info> + <name>import accurate to data warehouse</name> + <description/> + <extended_description/> + <trans_version/> + <trans_type>Normal</trans_type> + <directory>/</directory> + <parameters> + </parameters> + <log> + <trans-log-table> + <connection/> + <schema/> + <table/> + <size_limit_lines/> + <interval/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STATUS</id> + <enabled>Y</enabled> + <name>STATUS</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + <subject/> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + <subject/> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + <subject/> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + <subject/> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + <subject/> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + <subject/> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>STARTDATE</id> + <enabled>Y</enabled> + <name>STARTDATE</name> + </field> + <field> + <id>ENDDATE</id> + <enabled>Y</enabled> + <name>ENDDATE</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>DEPDATE</id> + <enabled>Y</enabled> + <name>DEPDATE</name> + </field> + <field> + <id>REPLAYDATE</id> + <enabled>Y</enabled> + <name>REPLAYDATE</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>Y</enabled> + <name>LOG_FIELD</name> + </field> + <field> + <id>EXECUTING_SERVER</id> + <enabled>N</enabled> + <name>EXECUTING_SERVER</name> + </field> + <field> + <id>EXECUTING_USER</id> + <enabled>N</enabled> + <name>EXECUTING_USER</name> + </field> + <field> + <id>CLIENT</id> + <enabled>N</enabled> + <name>CLIENT</name> + </field> + </trans-log-table> + <perf-log-table> + <connection/> + <schema/> + <table/> + <interval/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>SEQ_NR</id> + <enabled>Y</enabled> + <name>SEQ_NR</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STEPNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>STEP_COPY</id> + <enabled>Y</enabled> + <name>STEP_COPY</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>INPUT_BUFFER_ROWS</id> + <enabled>Y</enabled> + <name>INPUT_BUFFER_ROWS</name> + </field> + <field> + <id>OUTPUT_BUFFER_ROWS</id> + <enabled>Y</enabled> + <name>OUTPUT_BUFFER_ROWS</name> + </field> + </perf-log-table> + <channel-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>LOGGING_OBJECT_TYPE</id> + <enabled>Y</enabled> + <name>LOGGING_OBJECT_TYPE</name> + </field> + <field> + <id>OBJECT_NAME</id> + <enabled>Y</enabled> + <name>OBJECT_NAME</name> + </field> + <field> + <id>OBJECT_COPY</id> + <enabled>Y</enabled> + <name>OBJECT_COPY</name> + </field> + <field> + <id>REPOSITORY_DIRECTORY</id> + <enabled>Y</enabled> + <name>REPOSITORY_DIRECTORY</name> + </field> + <field> + <id>FILENAME</id> + <enabled>Y</enabled> + <name>FILENAME</name> + </field> + <field> + <id>OBJECT_ID</id> + <enabled>Y</enabled> + <name>OBJECT_ID</name> + </field> + <field> + <id>OBJECT_REVISION</id> + <enabled>Y</enabled> + <name>OBJECT_REVISION</name> + </field> + <field> + <id>PARENT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>PARENT_CHANNEL_ID</name> + </field> + <field> + <id>ROOT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>ROOT_CHANNEL_ID</name> + </field> + </channel-log-table> + <step-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STEPNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>STEP_COPY</id> + <enabled>Y</enabled> + <name>STEP_COPY</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>N</enabled> + <name>LOG_FIELD</name> + </field> + </step-log-table> + <metrics-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>METRICS_DATE</id> + <enabled>Y</enabled> + <name>METRICS_DATE</name> + </field> + <field> + <id>METRICS_CODE</id> + <enabled>Y</enabled> + <name>METRICS_CODE</name> + </field> + <field> + <id>METRICS_DESCRIPTION</id> + <enabled>Y</enabled> + <name>METRICS_DESCRIPTION</name> + </field> + <field> + <id>METRICS_SUBJECT</id> + <enabled>Y</enabled> + <name>METRICS_SUBJECT</name> + </field> + <field> + <id>METRICS_TYPE</id> + <enabled>Y</enabled> + <name>METRICS_TYPE</name> + </field> + <field> + <id>METRICS_VALUE</id> + <enabled>Y</enabled> + <name>METRICS_VALUE</name> + </field> + </metrics-log-table> + </log> + <maxdate> + <connection/> + <table/> + <field/> + <offset>0.0</offset> + <maxdiff>0.0</maxdiff> + </maxdate> + <size_rowset>10000</size_rowset> + <sleep_time_empty>50</sleep_time_empty> + <sleep_time_full>50</sleep_time_full> + <unique_connections>N</unique_connections> + <feedback_shown>Y</feedback_shown> + <feedback_size>50000</feedback_size> + <using_thread_priorities>Y</using_thread_priorities> + <shared_objects_file/> + <capture_step_performance>N</capture_step_performance> + <step_performance_capturing_delay>1000</step_performance_capturing_delay> + <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit> + <dependencies> + </dependencies> + <partitionschemas> + </partitionschemas> + <slaveservers> + </slaveservers> + <clusterschemas> + </clusterschemas> + <created_user>-</created_user> + <created_date>2023/03/03 16:19:32.865</created_date> + <modified_user>-</modified_user> + <modified_date>2023/03/03 16:19:32.865</modified_date> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> + <is_key_private>N</is_key_private> + </info> + <notepads> + </notepads> + <connection> + <name>dw bi fixco</name> + <server>192.168.23.5</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>dw_bi_fixco</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</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> + <connection> + <name>dw bi indoteknik</name> + <server>192.168.23.5</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>dw_bi_indoteknik</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</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> + <hop> + <from>Microsoft Excel input 2</from> + <to>Select values 2</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Filter rows</from> + <to>Select values 3</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Select values 2</from> + <to>Add constants</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Select values 3</from> + <to>Insert / update 2</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Add constants</from> + <to>Filter rows</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Filter rows</from> + <to>Select values</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Select values</from> + <to>Insert / update</to> + <enabled>Y</enabled> + </hop> + </order> + <step> + <name>Add constants</name> + <type>Constant</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>check</name> + <type>String</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>B2B</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>400</xloc> + <yloc>224</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Filter rows</name> + <type>FilterRows</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <send_true_to>Select values 3</send_true_to> + <send_false_to>Select values</send_false_to> + <compare> + <condition> + <negated>N</negated> + <leftvalue>tipe</leftvalue> + <function>CONTAINS</function> + <rightvalue>check</rightvalue> + </condition> + </compare> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>544</xloc> + <yloc>224</yloc> + <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 fixco</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>total_omzet_by_invoice</table> + <key> + <name>invoice</name> + <field>invoice</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>invoice</name> + <rename>invoice</rename> + <update>N</update> + </value> + <value> + <name>date_invoice</name> + <rename>date_invoice</rename> + <update>Y</update> + </value> + <value> + <name>customer</name> + <rename>customer</rename> + <update>Y</update> + </value> + <value> + <name>total</name> + <rename>total</rename> + <update>Y</update> + </value> + <value> + <name>subtotal</name> + <rename>subtotal</rename> + <update>Y</update> + </value> + <value> + <name>salesperson</name> + <rename>salesperson</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>832</xloc> + <yloc>352</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</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>total_omzet_by_invoice_accurate</table> + <key> + <name>invoice</name> + <field>invoice</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>invoice</name> + <rename>invoice</rename> + <update>N</update> + </value> + <value> + <name>date_invoice</name> + <rename>date_invoice</rename> + <update>Y</update> + </value> + <value> + <name>customer</name> + <rename>customer</rename> + <update>Y</update> + </value> + <value> + <name>total</name> + <rename>total</rename> + <update>Y</update> + </value> + <value> + <name>subtotal</name> + <rename>subtotal</rename> + <update>Y</update> + </value> + <value> + <name>salesperson</name> + <rename>salesperson</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>832</xloc> + <yloc>224</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Microsoft Excel input 2</name> + <type>ExcelInput</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <header>Y</header> + <noempty>Y</noempty> + <stoponempty>N</stoponempty> + <filefield/> + <sheetfield/> + <sheetrownumfield/> + <rownumfield/> + <sheetfield/> + <filefield/> + <limit>0</limit> + <encoding/> + <add_to_result_filenames>Y</add_to_result_filenames> + <accept_filenames>N</accept_filenames> + <accept_field/> + <accept_stepname/> + <file> + <name>/home/superman/data/daftar_faktur_penjualan_ptfixcokaryanus.xlsx</name> + <filemask/> + <exclude_filemask/> + <file_required>N</file_required> + <include_subfolders>N</include_subfolders> + </file> + <fields> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Nomor #</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>both</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Tanggal</name> + <type>Date</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>both</trim_type> + <repeat>N</repeat> + <format>yyyy-MM-dd</format> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Pelanggan</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>both</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Total</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Total-PPN</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Nama Penjual Utama</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>both</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>null</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Tipe Pelanggan</name> + <type>None</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>both</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + </fields> + <sheets> + <sheet> + <name>Daftar Faktur Penjualan</name> + <startrow>0</startrow> + <startcol>0</startcol> + </sheet> + </sheets> + <strict_types>N</strict_types> + <error_ignored>N</error_ignored> + <error_line_skipped>N</error_line_skipped> + <bad_line_files_destination_directory/> + <bad_line_files_extension>warning</bad_line_files_extension> + <error_line_files_destination_directory/> + <error_line_files_extension>error</error_line_files_extension> + <line_number_files_destination_directory/> + <line_number_files_extension>line</line_number_files_extension> + <shortFileFieldName/> + <pathFieldName/> + <hiddenFieldName/> + <lastModificationTimeFieldName/> + <uriNameFieldName/> + <rootUriNameFieldName/> + <extensionFieldName/> + <sizeFieldName/> + <spreadsheet_type>POI</spreadsheet_type> + <password>Encrypted </password> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>128</xloc> + <yloc>224</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>invoice</name> + <rename/> + </field> + <field> + <name>date_invoice</name> + <rename/> + </field> + <field> + <name>customer</name> + <rename/> + </field> + <field> + <name>total</name> + <rename/> + </field> + <field> + <name>subtotal</name> + <rename/> + </field> + <field> + <name>salesperson</name> + <rename/> + </field> + <select_unspecified>N</select_unspecified> + <meta> + <name>invoice</name> + <rename>invoice</rename> + <type>String</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>date_invoice</name> + <rename>date_invoice</rename> + <type>Date</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask>yyyy-MM-dd</conversion_mask> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>customer</name> + <rename>customer</rename> + <type>String</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>total</name> + <rename>total</rename> + <type>Number</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>subtotal</name> + <rename>subtotal</rename> + <type>Number</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>salesperson</name> + <rename>salesperson</rename> + <type>String</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>688</xloc> + <yloc>352</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values 2</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>Nomor #</name> + <rename>invoice</rename> + </field> + <field> + <name>Tanggal</name> + <rename>date_invoice</rename> + </field> + <field> + <name>Pelanggan</name> + <rename>customer</rename> + </field> + <field> + <name>Total</name> + <rename>total</rename> + </field> + <field> + <name>Total-PPN</name> + <rename>subtotal</rename> + </field> + <field> + <name>Nama Penjual Utama</name> + <rename>salesperson</rename> + </field> + <field> + <name>Tipe Pelanggan</name> + <rename>tipe</rename> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>288</xloc> + <yloc>224</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values 3</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>invoice</name> + </field> + <field> + <name>date_invoice</name> + </field> + <field> + <name>customer</name> + </field> + <field> + <name>total</name> + </field> + <field> + <name>subtotal</name> + </field> + <field> + <name>salesperson</name> + </field> + <select_unspecified>N</select_unspecified> + <meta> + <name>invoice</name> + <rename>invoice</rename> + <type>String</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>date_invoice</name> + <rename>date_invoice</rename> + <type>Date</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask>yyyy-MM-dd</conversion_mask> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>customer</name> + <rename>customer</rename> + <type>String</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>total</name> + <rename>total</rename> + <type>Number</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>subtotal</name> + <rename>subtotal</rename> + <type>Number</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + <meta> + <name>salesperson</name> + <rename>salesperson</rename> + <type>String</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>688</xloc> + <yloc>224</yloc> + <draw>Y</draw> + </GUI> + </step> + <step_error_handling> + </step_error_handling> + <slave-step-copy-partition-distribution> + </slave-step-copy-partition-distribution> + <slave_transformation>N</slave_transformation> + <attributes/> +</transformation> diff --git a/import_adempiere_to_data_warehouse.ktr b/import_adempiere_to_data_warehouse.ktr new file mode 100644 index 0000000..03852aa --- /dev/null +++ b/import_adempiere_to_data_warehouse.ktr @@ -0,0 +1,1062 @@ +<?xml version="1.0" encoding="UTF-8"?> +<transformation> + <info> + <name>import adempiere to data warehouse</name> + <description/> + <extended_description/> + <trans_version/> + <trans_type>Normal</trans_type> + <directory>/</directory> + <parameters> + </parameters> + <log> + <trans-log-table> + <connection/> + <schema/> + <table/> + <size_limit_lines/> + <interval/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STATUS</id> + <enabled>Y</enabled> + <name>STATUS</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + <subject/> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + <subject/> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + <subject/> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + <subject/> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + <subject/> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + <subject/> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>STARTDATE</id> + <enabled>Y</enabled> + <name>STARTDATE</name> + </field> + <field> + <id>ENDDATE</id> + <enabled>Y</enabled> + <name>ENDDATE</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>DEPDATE</id> + <enabled>Y</enabled> + <name>DEPDATE</name> + </field> + <field> + <id>REPLAYDATE</id> + <enabled>Y</enabled> + <name>REPLAYDATE</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>Y</enabled> + <name>LOG_FIELD</name> + </field> + <field> + <id>EXECUTING_SERVER</id> + <enabled>N</enabled> + <name>EXECUTING_SERVER</name> + </field> + <field> + <id>EXECUTING_USER</id> + <enabled>N</enabled> + <name>EXECUTING_USER</name> + </field> + <field> + <id>CLIENT</id> + <enabled>N</enabled> + <name>CLIENT</name> + </field> + </trans-log-table> + <perf-log-table> + <connection/> + <schema/> + <table/> + <interval/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>SEQ_NR</id> + <enabled>Y</enabled> + <name>SEQ_NR</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STEPNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>STEP_COPY</id> + <enabled>Y</enabled> + <name>STEP_COPY</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>INPUT_BUFFER_ROWS</id> + <enabled>Y</enabled> + <name>INPUT_BUFFER_ROWS</name> + </field> + <field> + <id>OUTPUT_BUFFER_ROWS</id> + <enabled>Y</enabled> + <name>OUTPUT_BUFFER_ROWS</name> + </field> + </perf-log-table> + <channel-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>LOGGING_OBJECT_TYPE</id> + <enabled>Y</enabled> + <name>LOGGING_OBJECT_TYPE</name> + </field> + <field> + <id>OBJECT_NAME</id> + <enabled>Y</enabled> + <name>OBJECT_NAME</name> + </field> + <field> + <id>OBJECT_COPY</id> + <enabled>Y</enabled> + <name>OBJECT_COPY</name> + </field> + <field> + <id>REPOSITORY_DIRECTORY</id> + <enabled>Y</enabled> + <name>REPOSITORY_DIRECTORY</name> + </field> + <field> + <id>FILENAME</id> + <enabled>Y</enabled> + <name>FILENAME</name> + </field> + <field> + <id>OBJECT_ID</id> + <enabled>Y</enabled> + <name>OBJECT_ID</name> + </field> + <field> + <id>OBJECT_REVISION</id> + <enabled>Y</enabled> + <name>OBJECT_REVISION</name> + </field> + <field> + <id>PARENT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>PARENT_CHANNEL_ID</name> + </field> + <field> + <id>ROOT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>ROOT_CHANNEL_ID</name> + </field> + </channel-log-table> + <step-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STEPNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>STEP_COPY</id> + <enabled>Y</enabled> + <name>STEP_COPY</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>N</enabled> + <name>LOG_FIELD</name> + </field> + </step-log-table> + <metrics-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>METRICS_DATE</id> + <enabled>Y</enabled> + <name>METRICS_DATE</name> + </field> + <field> + <id>METRICS_CODE</id> + <enabled>Y</enabled> + <name>METRICS_CODE</name> + </field> + <field> + <id>METRICS_DESCRIPTION</id> + <enabled>Y</enabled> + <name>METRICS_DESCRIPTION</name> + </field> + <field> + <id>METRICS_SUBJECT</id> + <enabled>Y</enabled> + <name>METRICS_SUBJECT</name> + </field> + <field> + <id>METRICS_TYPE</id> + <enabled>Y</enabled> + <name>METRICS_TYPE</name> + </field> + <field> + <id>METRICS_VALUE</id> + <enabled>Y</enabled> + <name>METRICS_VALUE</name> + </field> + </metrics-log-table> + </log> + <maxdate> + <connection/> + <table/> + <field/> + <offset>0.0</offset> + <maxdiff>0.0</maxdiff> + </maxdate> + <size_rowset>10000</size_rowset> + <sleep_time_empty>50</sleep_time_empty> + <sleep_time_full>50</sleep_time_full> + <unique_connections>N</unique_connections> + <feedback_shown>Y</feedback_shown> + <feedback_size>50000</feedback_size> + <using_thread_priorities>Y</using_thread_priorities> + <shared_objects_file/> + <capture_step_performance>N</capture_step_performance> + <step_performance_capturing_delay>1000</step_performance_capturing_delay> + <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit> + <dependencies> + </dependencies> + <partitionschemas> + </partitionschemas> + <slaveservers> + </slaveservers> + <clusterschemas> + </clusterschemas> + <created_user>-</created_user> + <created_date>2023/03/04 09:58:38.760</created_date> + <modified_user>-</modified_user> + <modified_date>2023/03/04 09:58:38.760</modified_date> + <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> + <type>POSTGRESQL</type> + <access>Native</access> + <database>dw_bi_indoteknik</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</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> + <hop> + <from>Microsoft Excel input</from> + <to>Select values</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Select values</from> + <to>Insert / update</to> + <enabled>Y</enabled> + </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</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>total_omzet_by_invoice_adempiere</table> + <key> + <name>invoice</name> + <field>invoice</field> + <condition>=</condition> + <name2/> + </key> + <key> + <name>product</name> + <field>product</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>customer</name> + <rename>customer</rename> + <update>Y</update> + </value> + <value> + <name>invoice_date</name> + <rename>invoice_date</rename> + <update>Y</update> + </value> + <value> + <name>price_subtotal</name> + <rename>price_subtotal</rename> + <update>Y</update> + </value> + <value> + <name>invoice</name> + <rename>invoice</rename> + <update>N</update> + </value> + <value> + <name>quantity</name> + <rename>quantity</rename> + <update>Y</update> + </value> + <value> + <name>product</name> + <rename>product</rename> + <update>N</update> + </value> + <value> + <name>brand</name> + <rename>brand</rename> + <update>Y</update> + </value> + <value> + <name>salesperson</name> + <rename>salesperson</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>576</xloc> + <yloc>80</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Microsoft Excel input</name> + <type>ExcelInput</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <header>Y</header> + <noempty>Y</noempty> + <stoponempty>N</stoponempty> + <filefield/> + <sheetfield/> + <sheetrownumfield/> + <rownumfield/> + <sheetfield/> + <filefield/> + <limit>0</limit> + <encoding/> + <add_to_result_filenames>Y</add_to_result_filenames> + <accept_filenames>N</accept_filenames> + <accept_field/> + <accept_stepname/> + <file> + <name>/home/superman/data/Report Total Omzet By Customer.xlsx</name> + <filemask/> + <exclude_filemask/> + <file_required>N</file_required> + <include_subfolders>N</include_subfolders> + </file> + <fields> + <field> + <name>BPLocation</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Brand</name> + <type>Number</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Business Partner</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Customer Name</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Date Ordered</name> + <type>Date</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Doc Type</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Free Item</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>handtool</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>IsCashBack</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Line Amt</name> + <type>Number</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Market Segment</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Order</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Ordered Qty</name> + <type>Number</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Partner Location</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Product</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Product Brand</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>product_category</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Product Category</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Product Group</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Product Name</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>product_subcategory</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Sales Name</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Sales Region</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Sales Region_1</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Sales Rep</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Sales Transaction</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>SO No</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + <field> + <name>Product Brand_1</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> + </fields> + <sheets> + <sheet> + <name>Sheet0</name> + <startrow>0</startrow> + <startcol>0</startcol> + </sheet> + </sheets> + <strict_types>N</strict_types> + <error_ignored>N</error_ignored> + <error_line_skipped>N</error_line_skipped> + <bad_line_files_destination_directory/> + <bad_line_files_extension>warning</bad_line_files_extension> + <error_line_files_destination_directory/> + <error_line_files_extension>error</error_line_files_extension> + <line_number_files_destination_directory/> + <line_number_files_extension>line</line_number_files_extension> + <shortFileFieldName/> + <pathFieldName/> + <hiddenFieldName/> + <lastModificationTimeFieldName/> + <uriNameFieldName/> + <rootUriNameFieldName/> + <extensionFieldName/> + <sizeFieldName/> + <spreadsheet_type>POI</spreadsheet_type> + <password>Encrypted </password> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>208</xloc> + <yloc>80</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>Business Partner</name> + <rename>customer</rename> + </field> + <field> + <name>Date Ordered</name> + <rename>invoice_date</rename> + </field> + <field> + <name>Line Amt</name> + <rename>price_subtotal</rename> + </field> + <field> + <name>Order</name> + <rename>invoice</rename> + </field> + <field> + <name>Ordered Qty</name> + <rename>quantity</rename> + </field> + <field> + <name>Product</name> + <rename>product</rename> + </field> + <field> + <name>Product Brand</name> + <rename>brand</rename> + </field> + <field> + <name>Sales Name</name> + <rename>salesperson</rename> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>416</xloc> + <yloc>80</yloc> + <draw>Y</draw> + </GUI> + </step> + <step_error_handling> + </step_error_handling> + <slave-step-copy-partition-distribution> + </slave-step-copy-partition-distribution> + <slave_transformation>N</slave_transformation> + <attributes/> +</transformation> diff --git a/import_all_data_bi_indoteknik.kjb b/import_all_data_bi_indoteknik.kjb new file mode 100644 index 0000000..52e10c8 --- /dev/null +++ b/import_all_data_bi_indoteknik.kjb @@ -0,0 +1,638 @@ +<?xml version="1.0" encoding="UTF-8"?> +<job> + <name>run_all_import_data_bi_indoteknik</name> + <description/> + <extended_description/> + <job_version/> + <directory>/</directory> + <created_user>-</created_user> + <created_date>2023/03/08 11:02:31.082</created_date> + <modified_user>-</modified_user> + <modified_date>2023/03/08 11:02:31.082</modified_date> + <parameters> + </parameters> + <slaveservers> + </slaveservers> + <job-log-table> + <connection/> + <schema/> + <table/> + <size_limit_lines/> + <interval/> + <timeout_days/> + <field> + <id>ID_JOB</id> + <enabled>Y</enabled> + <name>ID_JOB</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>JOBNAME</id> + <enabled>Y</enabled> + <name>JOBNAME</name> + </field> + <field> + <id>STATUS</id> + <enabled>Y</enabled> + <name>STATUS</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>STARTDATE</id> + <enabled>Y</enabled> + <name>STARTDATE</name> + </field> + <field> + <id>ENDDATE</id> + <enabled>Y</enabled> + <name>ENDDATE</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>DEPDATE</id> + <enabled>Y</enabled> + <name>DEPDATE</name> + </field> + <field> + <id>REPLAYDATE</id> + <enabled>Y</enabled> + <name>REPLAYDATE</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>Y</enabled> + <name>LOG_FIELD</name> + </field> + <field> + <id>EXECUTING_SERVER</id> + <enabled>N</enabled> + <name>EXECUTING_SERVER</name> + </field> + <field> + <id>EXECUTING_USER</id> + <enabled>N</enabled> + <name>EXECUTING_USER</name> + </field> + <field> + <id>START_JOB_ENTRY</id> + <enabled>N</enabled> + <name>START_JOB_ENTRY</name> + </field> + <field> + <id>CLIENT</id> + <enabled>N</enabled> + <name>CLIENT</name> + </field> + </job-log-table> + <jobentry-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>JOBNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>JOBENTRYNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>RESULT</id> + <enabled>Y</enabled> + <name>RESULT</name> + </field> + <field> + <id>NR_RESULT_ROWS</id> + <enabled>Y</enabled> + <name>NR_RESULT_ROWS</name> + </field> + <field> + <id>NR_RESULT_FILES</id> + <enabled>Y</enabled> + <name>NR_RESULT_FILES</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>N</enabled> + <name>LOG_FIELD</name> + </field> + <field> + <id>COPY_NR</id> + <enabled>N</enabled> + <name>COPY_NR</name> + </field> + </jobentry-log-table> + <channel-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>LOGGING_OBJECT_TYPE</id> + <enabled>Y</enabled> + <name>LOGGING_OBJECT_TYPE</name> + </field> + <field> + <id>OBJECT_NAME</id> + <enabled>Y</enabled> + <name>OBJECT_NAME</name> + </field> + <field> + <id>OBJECT_COPY</id> + <enabled>Y</enabled> + <name>OBJECT_COPY</name> + </field> + <field> + <id>REPOSITORY_DIRECTORY</id> + <enabled>Y</enabled> + <name>REPOSITORY_DIRECTORY</name> + </field> + <field> + <id>FILENAME</id> + <enabled>Y</enabled> + <name>FILENAME</name> + </field> + <field> + <id>OBJECT_ID</id> + <enabled>Y</enabled> + <name>OBJECT_ID</name> + </field> + <field> + <id>OBJECT_REVISION</id> + <enabled>Y</enabled> + <name>OBJECT_REVISION</name> + </field> + <field> + <id>PARENT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>PARENT_CHANNEL_ID</name> + </field> + <field> + <id>ROOT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>ROOT_CHANNEL_ID</name> + </field> + </channel-log-table> + <pass_batchid>N</pass_batchid> + <shared_objects_file/> + <entries> + <entry> + <name>Start</name> + <description/> + <type>SPECIAL</type> + <attributes/> + <start>Y</start> + <dummy>N</dummy> + <repeat>N</repeat> + <schedulerType>0</schedulerType> + <intervalSeconds>0</intervalSeconds> + <intervalMinutes>60</intervalMinutes> + <hour>12</hour> + <minutes>0</minutes> + <weekDay>1</weekDay> + <DayOfMonth>1</DayOfMonth> + <parallel>N</parallel> + <draw>Y</draw> + <nr>0</nr> + <xloc>176</xloc> + <yloc>128</yloc> + <attributes_kjc/> + </entry> + <entry> + <name>accurate</name> + <description/> + <type>TRANS</type> + <attributes/> + <specification_method>filename</specification_method> + <trans_object_id/> + <filename>/home/superman/runapps/import_accurate_to_data_warehouse.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>128</yloc> + <attributes_kjc/> + </entry> + <entry> + <name>adempiere</name> + <description/> + <type>TRANS</type> + <attributes/> + <specification_method>filename</specification_method> + <trans_object_id/> + <filename>/home/superman/runapps/import_adempiere_to_data_warehouse.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>128</yloc> + <attributes_kjc/> + </entry> + <entry> + <name>odoo</name> + <description/> + <type>TRANS</type> + <attributes/> + <specification_method>filename</specification_method> + <trans_object_id/> + <filename>/home/superman/runapps/import_odoo_14_to_data_warehouse.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>624</xloc> + <yloc>128</yloc> + <attributes_kjc/> + </entry> + <entry> + <name>refresh_materialized_view</name> + <description/> + <type>TRANS</type> + <attributes/> + <specification_method>filename</specification_method> + <trans_object_id/> + <filename>/home/superman/runapps/refresh_materialized_view.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>752</xloc> + <yloc>128</yloc> + <attributes_kjc/> + </entry> + <entry> + <name>Delete files</name> + <description/> + <type>DELETE_FILES</type> + <attributes/> + <arg_from_previous>N</arg_from_previous> + <include_subfolders>N</include_subfolders> + <fields> + <field> + <name>/home/superman/data</name> + <filemask>.+\.xls</filemask> + </field> + <field> + <name>/home/superman/data</name> + <filemask>.+\.xlsx</filemask> + </field> + </fields> + <parallel>N</parallel> + <draw>Y</draw> + <nr>0</nr> + <xloc>752</xloc> + <yloc>256</yloc> + <attributes_kjc/> + </entry> + <entry> + <name>import fixco</name> + <description/> + <type>TRANS</type> + <attributes/> + <specification_method>filename</specification_method> + <trans_object_id/> + <filename>/home/superman/runapps/import_accurate_fixco_to_data_warehouse.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>896</xloc> + <yloc>128</yloc> + <attributes_kjc/> + </entry> + <entry> + <name>refresh mv fixco</name> + <description/> + <type>TRANS</type> + <attributes/> + <specification_method>filename</specification_method> + <trans_object_id/> + <filename>/home/superman/runapps/refresh_materialized_view_fixco.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>896</xloc> + <yloc>256</yloc> + <attributes_kjc/> + </entry> + </entries> + <hops> + <hop> + <from>Start</from> + <to>accurate</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>Y</unconditional> + </hop> + <hop> + <from>accurate</from> + <to>adempiere</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> + <hop> + <from>adempiere</from> + <to>odoo</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> + <hop> + <from>odoo</from> + <to>refresh_materialized_view</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> + <hop> + <from>refresh_materialized_view</from> + <to>import fixco</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> + <hop> + <from>import fixco</from> + <to>refresh mv fixco</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> + <hop> + <from>refresh mv fixco</from> + <to>Delete files</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> + </hops> + <notepads> + </notepads> + <attributes/> +</job> diff --git a/import_odoo_14_to_data_warehouse.ktr b/import_odoo_14_to_data_warehouse.ktr new file mode 100644 index 0000000..c12bd7b --- /dev/null +++ b/import_odoo_14_to_data_warehouse.ktr @@ -0,0 +1,1195 @@ +<?xml version="1.0" encoding="UTF-8"?> +<transformation> + <info> + <name>import odoo 14 to data warehouse</name> + <description/> + <extended_description/> + <trans_version/> + <trans_type>Normal</trans_type> + <directory>/</directory> + <parameters> + </parameters> + <log> + <trans-log-table> + <connection/> + <schema/> + <table/> + <size_limit_lines/> + <interval/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STATUS</id> + <enabled>Y</enabled> + <name>STATUS</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + <subject/> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + <subject/> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + <subject/> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + <subject/> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + <subject/> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + <subject/> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>STARTDATE</id> + <enabled>Y</enabled> + <name>STARTDATE</name> + </field> + <field> + <id>ENDDATE</id> + <enabled>Y</enabled> + <name>ENDDATE</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>DEPDATE</id> + <enabled>Y</enabled> + <name>DEPDATE</name> + </field> + <field> + <id>REPLAYDATE</id> + <enabled>Y</enabled> + <name>REPLAYDATE</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>Y</enabled> + <name>LOG_FIELD</name> + </field> + <field> + <id>EXECUTING_SERVER</id> + <enabled>N</enabled> + <name>EXECUTING_SERVER</name> + </field> + <field> + <id>EXECUTING_USER</id> + <enabled>N</enabled> + <name>EXECUTING_USER</name> + </field> + <field> + <id>CLIENT</id> + <enabled>N</enabled> + <name>CLIENT</name> + </field> + </trans-log-table> + <perf-log-table> + <connection/> + <schema/> + <table/> + <interval/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>SEQ_NR</id> + <enabled>Y</enabled> + <name>SEQ_NR</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STEPNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>STEP_COPY</id> + <enabled>Y</enabled> + <name>STEP_COPY</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>INPUT_BUFFER_ROWS</id> + <enabled>Y</enabled> + <name>INPUT_BUFFER_ROWS</name> + </field> + <field> + <id>OUTPUT_BUFFER_ROWS</id> + <enabled>Y</enabled> + <name>OUTPUT_BUFFER_ROWS</name> + </field> + </perf-log-table> + <channel-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>LOGGING_OBJECT_TYPE</id> + <enabled>Y</enabled> + <name>LOGGING_OBJECT_TYPE</name> + </field> + <field> + <id>OBJECT_NAME</id> + <enabled>Y</enabled> + <name>OBJECT_NAME</name> + </field> + <field> + <id>OBJECT_COPY</id> + <enabled>Y</enabled> + <name>OBJECT_COPY</name> + </field> + <field> + <id>REPOSITORY_DIRECTORY</id> + <enabled>Y</enabled> + <name>REPOSITORY_DIRECTORY</name> + </field> + <field> + <id>FILENAME</id> + <enabled>Y</enabled> + <name>FILENAME</name> + </field> + <field> + <id>OBJECT_ID</id> + <enabled>Y</enabled> + <name>OBJECT_ID</name> + </field> + <field> + <id>OBJECT_REVISION</id> + <enabled>Y</enabled> + <name>OBJECT_REVISION</name> + </field> + <field> + <id>PARENT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>PARENT_CHANNEL_ID</name> + </field> + <field> + <id>ROOT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>ROOT_CHANNEL_ID</name> + </field> + </channel-log-table> + <step-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STEPNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>STEP_COPY</id> + <enabled>Y</enabled> + <name>STEP_COPY</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>N</enabled> + <name>LOG_FIELD</name> + </field> + </step-log-table> + <metrics-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>METRICS_DATE</id> + <enabled>Y</enabled> + <name>METRICS_DATE</name> + </field> + <field> + <id>METRICS_CODE</id> + <enabled>Y</enabled> + <name>METRICS_CODE</name> + </field> + <field> + <id>METRICS_DESCRIPTION</id> + <enabled>Y</enabled> + <name>METRICS_DESCRIPTION</name> + </field> + <field> + <id>METRICS_SUBJECT</id> + <enabled>Y</enabled> + <name>METRICS_SUBJECT</name> + </field> + <field> + <id>METRICS_TYPE</id> + <enabled>Y</enabled> + <name>METRICS_TYPE</name> + </field> + <field> + <id>METRICS_VALUE</id> + <enabled>Y</enabled> + <name>METRICS_VALUE</name> + </field> + </metrics-log-table> + </log> + <maxdate> + <connection/> + <table/> + <field/> + <offset>0.0</offset> + <maxdiff>0.0</maxdiff> + </maxdate> + <size_rowset>10000</size_rowset> + <sleep_time_empty>50</sleep_time_empty> + <sleep_time_full>50</sleep_time_full> + <unique_connections>N</unique_connections> + <feedback_shown>Y</feedback_shown> + <feedback_size>50000</feedback_size> + <using_thread_priorities>Y</using_thread_priorities> + <shared_objects_file/> + <capture_step_performance>N</capture_step_performance> + <step_performance_capturing_delay>1000</step_performance_capturing_delay> + <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit> + <dependencies> + </dependencies> + <partitionschemas> + </partitionschemas> + <slaveservers> + </slaveservers> + <clusterschemas> + </clusterschemas> + <created_user>-</created_user> + <created_date>2023/03/04 09:35:53.789</created_date> + <modified_user>-</modified_user> + <modified_date>2023/03/04 09:35:53.789</modified_date> + <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> + <type>POSTGRESQL</type> + <access>Native</access> + <database>dw_bi_indoteknik</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</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> + <connection> + <name>erp indoteknik production</name> + <server>34.101.171.249</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>erp_indoteknik</database> + <port>5432</port> + <username>odoo</username> + <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> + <hop> + <from>Table input</from> + <to>Select values</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Select values</from> + <to>Insert / update</to> + <enabled>Y</enabled> + </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</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>total_omzet_by_invoice_odoo14</table> + <key> + <name>account_move_line_id</name> + <field>account_move_line_id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>invoice</name> + <rename>invoice</rename> + <update>Y</update> + </value> + <value> + <name>industry</name> + <rename>industry</rename> + <update>Y</update> + </value> + <value> + <name>salesperson</name> + <rename>salesperson</rename> + <update>Y</update> + </value> + <value> + <name>invoice_date</name> + <rename>invoice_date</rename> + <update>Y</update> + </value> + <value> + <name>year_month</name> + <rename>year_month</rename> + <update>Y</update> + </value> + <value> + <name>year</name> + <rename>year</rename> + <update>Y</update> + </value> + <value> + <name>month</name> + <rename>month</rename> + <update>Y</update> + </value> + <value> + <name>brand</name> + <rename>brand</rename> + <update>Y</update> + </value> + <value> + <name>product</name> + <rename>product</rename> + <update>Y</update> + </value> + <value> + <name>default_code</name> + <rename>default_code</rename> + <update>Y</update> + </value> + <value> + <name>quantity</name> + <rename>quantity</rename> + <update>Y</update> + </value> + <value> + <name>price_unit</name> + <rename>price_unit</rename> + <update>Y</update> + </value> + <value> + <name>price_subtotal</name> + <rename>price_subtotal</rename> + <update>Y</update> + </value> + <value> + <name>price_total</name> + <rename>price_total</rename> + <update>Y</update> + </value> + <value> + <name>customer</name> + <rename>customer</rename> + <update>Y</update> + </value> + <value> + <name>partner_id</name> + <rename>partner_id</rename> + <update>Y</update> + </value> + <value> + <name>quarter</name> + <rename>quarter</rename> + <update>Y</update> + </value> + <value> + <name>account_move_line_id</name> + <rename>account_move_line_id</rename> + <update>N</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>496</xloc> + <yloc>96</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>invoice</name> + </field> + <field> + <name>industry</name> + </field> + <field> + <name>salesperson</name> + </field> + <field> + <name>invoice_date</name> + </field> + <field> + <name>year_month_invoice_date</name> + <rename>year_month</rename> + </field> + <field> + <name>year</name> + </field> + <field> + <name>month</name> + </field> + <field> + <name>brand</name> + </field> + <field> + <name>product</name> + </field> + <field> + <name>default_code</name> + </field> + <field> + <name>quantity</name> + </field> + <field> + <name>price_unit</name> + </field> + <field> + <name>price_subtotal</name> + </field> + <field> + <name>price_total</name> + </field> + <field> + <name>customer</name> + </field> + <field> + <name>partner_id</name> + </field> + <field> + <name>quarter</name> + </field> + <field> + <name>account_move_line_id</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>352</xloc> + <yloc>96</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Table input</name> + <type>TableInput</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik production</connection> + <sql>select * from v_total_omzet_by_invoice</sql> + <limit>0</limit> + <lookup/> + <execute_each_row>N</execute_each_row> + <variables_active>N</variables_active> + <lazy_conversion_active>N</lazy_conversion_active> + <cached_row_meta_active>N</cached_row_meta_active> + <row-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>invoice</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>invoice</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>industry</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>industry</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>salesperson</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>salesperson</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>Date</type> + <storagetype>normal</storagetype> + <name>invoice_date</name> + <length>-1</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>invoice_date</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>year_month_invoice_date</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>year_month_invoice_date</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>year</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>year</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>month</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>month</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>brand</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>brand</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>product</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>product</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>default_code</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>default_code</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>quantity</name> + <length>-1</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>quantity</comments> + <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol/> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_unit</name> + <length>-1</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>price_unit</comments> + <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol/> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_subtotal</name> + <length>-1</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>price_subtotal</comments> + <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol/> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>BigNumber</type> + <storagetype>normal</storagetype> + <name>price_total</name> + <length>-1</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>price_total</comments> + <conversion_Mask>######0.0###################;-######0.0###################</conversion_Mask> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol/> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>customer</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>customer</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>Integer</type> + <storagetype>normal</storagetype> + <name>partner_id</name> + <length>9</length> + <precision>0</precision> + <origin>Table input</origin> + <comments>partner_id</comments> + <conversion_Mask>####0;-####0</conversion_Mask> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + <value-meta> + <type>String</type> + <storagetype>normal</storagetype> + <name>quarter</name> + <length>2147483647</length> + <precision>-1</precision> + <origin>Table input</origin> + <comments>quarter</comments> + <conversion_Mask/> + <decimal_symbol>.</decimal_symbol> + <grouping_symbol>,</grouping_symbol> + <currency_symbol/> + <trim_type>none</trim_type> + <case_insensitive>N</case_insensitive> + <collator_disabled>Y</collator_disabled> + <collator_strength>0</collator_strength> + <sort_descending>N</sort_descending> + <output_padding>N</output_padding> + <date_format_lenient>N</date_format_lenient> + <date_format_locale>en_US</date_format_locale> + <date_format_timezone>Asia/Bangkok</date_format_timezone> + <lenient_string_to_number>N</lenient_string_to_number> + </value-meta> + </row-meta> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>224</xloc> + <yloc>96</yloc> + <draw>Y</draw> + </GUI> + </step> + <step_error_handling> + </step_error_handling> + <slave-step-copy-partition-distribution> + </slave-step-copy-partition-distribution> + <slave_transformation>N</slave_transformation> + <attributes/> +</transformation> diff --git a/refresh_materialized_view.ktr b/refresh_materialized_view.ktr new file mode 100644 index 0000000..8b21a1a --- /dev/null +++ b/refresh_materialized_view.ktr @@ -0,0 +1,750 @@ +<?xml version="1.0" encoding="UTF-8"?> +<transformation> + <info> + <name>refresh_materialized_view</name> + <description/> + <extended_description/> + <trans_version/> + <trans_type>Normal</trans_type> + <directory>/</directory> + <parameters> + </parameters> + <log> + <trans-log-table> + <connection/> + <schema/> + <table/> + <size_limit_lines/> + <interval/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STATUS</id> + <enabled>Y</enabled> + <name>STATUS</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + <subject/> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + <subject/> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + <subject/> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + <subject/> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + <subject/> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + <subject/> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>STARTDATE</id> + <enabled>Y</enabled> + <name>STARTDATE</name> + </field> + <field> + <id>ENDDATE</id> + <enabled>Y</enabled> + <name>ENDDATE</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>DEPDATE</id> + <enabled>Y</enabled> + <name>DEPDATE</name> + </field> + <field> + <id>REPLAYDATE</id> + <enabled>Y</enabled> + <name>REPLAYDATE</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>Y</enabled> + <name>LOG_FIELD</name> + </field> + <field> + <id>EXECUTING_SERVER</id> + <enabled>N</enabled> + <name>EXECUTING_SERVER</name> + </field> + <field> + <id>EXECUTING_USER</id> + <enabled>N</enabled> + <name>EXECUTING_USER</name> + </field> + <field> + <id>CLIENT</id> + <enabled>N</enabled> + <name>CLIENT</name> + </field> + </trans-log-table> + <perf-log-table> + <connection/> + <schema/> + <table/> + <interval/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>SEQ_NR</id> + <enabled>Y</enabled> + <name>SEQ_NR</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STEPNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>STEP_COPY</id> + <enabled>Y</enabled> + <name>STEP_COPY</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>INPUT_BUFFER_ROWS</id> + <enabled>Y</enabled> + <name>INPUT_BUFFER_ROWS</name> + </field> + <field> + <id>OUTPUT_BUFFER_ROWS</id> + <enabled>Y</enabled> + <name>OUTPUT_BUFFER_ROWS</name> + </field> + </perf-log-table> + <channel-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>LOGGING_OBJECT_TYPE</id> + <enabled>Y</enabled> + <name>LOGGING_OBJECT_TYPE</name> + </field> + <field> + <id>OBJECT_NAME</id> + <enabled>Y</enabled> + <name>OBJECT_NAME</name> + </field> + <field> + <id>OBJECT_COPY</id> + <enabled>Y</enabled> + <name>OBJECT_COPY</name> + </field> + <field> + <id>REPOSITORY_DIRECTORY</id> + <enabled>Y</enabled> + <name>REPOSITORY_DIRECTORY</name> + </field> + <field> + <id>FILENAME</id> + <enabled>Y</enabled> + <name>FILENAME</name> + </field> + <field> + <id>OBJECT_ID</id> + <enabled>Y</enabled> + <name>OBJECT_ID</name> + </field> + <field> + <id>OBJECT_REVISION</id> + <enabled>Y</enabled> + <name>OBJECT_REVISION</name> + </field> + <field> + <id>PARENT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>PARENT_CHANNEL_ID</name> + </field> + <field> + <id>ROOT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>ROOT_CHANNEL_ID</name> + </field> + </channel-log-table> + <step-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STEPNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>STEP_COPY</id> + <enabled>Y</enabled> + <name>STEP_COPY</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>N</enabled> + <name>LOG_FIELD</name> + </field> + </step-log-table> + <metrics-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>METRICS_DATE</id> + <enabled>Y</enabled> + <name>METRICS_DATE</name> + </field> + <field> + <id>METRICS_CODE</id> + <enabled>Y</enabled> + <name>METRICS_CODE</name> + </field> + <field> + <id>METRICS_DESCRIPTION</id> + <enabled>Y</enabled> + <name>METRICS_DESCRIPTION</name> + </field> + <field> + <id>METRICS_SUBJECT</id> + <enabled>Y</enabled> + <name>METRICS_SUBJECT</name> + </field> + <field> + <id>METRICS_TYPE</id> + <enabled>Y</enabled> + <name>METRICS_TYPE</name> + </field> + <field> + <id>METRICS_VALUE</id> + <enabled>Y</enabled> + <name>METRICS_VALUE</name> + </field> + </metrics-log-table> + </log> + <maxdate> + <connection/> + <table/> + <field/> + <offset>0.0</offset> + <maxdiff>0.0</maxdiff> + </maxdate> + <size_rowset>10000</size_rowset> + <sleep_time_empty>50</sleep_time_empty> + <sleep_time_full>50</sleep_time_full> + <unique_connections>N</unique_connections> + <feedback_shown>Y</feedback_shown> + <feedback_size>50000</feedback_size> + <using_thread_priorities>Y</using_thread_priorities> + <shared_objects_file/> + <capture_step_performance>N</capture_step_performance> + <step_performance_capturing_delay>1000</step_performance_capturing_delay> + <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit> + <dependencies> + </dependencies> + <partitionschemas> + </partitionschemas> + <slaveservers> + </slaveservers> + <clusterschemas> + </clusterschemas> + <created_user>-</created_user> + <created_date>2023/03/07 18:01:17.675</created_date> + <modified_user>-</modified_user> + <modified_date>2023/03/07 18:01:17.675</modified_date> + <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> + <type>POSTGRESQL</type> + <access>Native</access> + <database>dw_bi_indoteknik</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</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> + <hop> + <from>accurate</from> + <to>adempiere</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>adempiere</from> + <to>combine</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>combine</from> + <to>salesperson</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>salesperson</from> + <to>customer_current_year</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>customer_current_year</from> + <to>Execute SQL script</to> + <enabled>Y</enabled> + </hop> + </order> + <step> + <name>accurate</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_omzet_by_invoice_accurate</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>240</xloc> + <yloc>160</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>adempiere</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_omzet_by_invoice_adempiere</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>400</xloc> + <yloc>160</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>combine</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_omzet_by_invoice_combine</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>560</xloc> + <yloc>160</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>customer_current_year</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 dw_customer_current_year</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>880</xloc> + <yloc>160</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>salesperson</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 dw_salesperson</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>720</xloc> + <yloc>160</yloc> + <draw>Y</draw> + </GUI> + </step> + <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>select update_running_quarter()</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>1024</xloc> + <yloc>160</yloc> + <draw>Y</draw> + </GUI> + </step> + <step_error_handling> + </step_error_handling> + <slave-step-copy-partition-distribution> + </slave-step-copy-partition-distribution> + <slave_transformation>N</slave_transformation> + <attributes/> +</transformation> diff --git a/refresh_materialized_view_fixco.ktr b/refresh_materialized_view_fixco.ktr new file mode 100644 index 0000000..af911f3 --- /dev/null +++ b/refresh_materialized_view_fixco.ktr @@ -0,0 +1,750 @@ +<?xml version="1.0" encoding="UTF-8"?> +<transformation> + <info> + <name>refresh_materialized_view_fixco</name> + <description/> + <extended_description/> + <trans_version/> + <trans_type>Normal</trans_type> + <directory>/</directory> + <parameters> + </parameters> + <log> + <trans-log-table> + <connection/> + <schema/> + <table/> + <size_limit_lines/> + <interval/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STATUS</id> + <enabled>Y</enabled> + <name>STATUS</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + <subject/> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + <subject/> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + <subject/> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + <subject/> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + <subject/> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + <subject/> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>STARTDATE</id> + <enabled>Y</enabled> + <name>STARTDATE</name> + </field> + <field> + <id>ENDDATE</id> + <enabled>Y</enabled> + <name>ENDDATE</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>DEPDATE</id> + <enabled>Y</enabled> + <name>DEPDATE</name> + </field> + <field> + <id>REPLAYDATE</id> + <enabled>Y</enabled> + <name>REPLAYDATE</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>Y</enabled> + <name>LOG_FIELD</name> + </field> + <field> + <id>EXECUTING_SERVER</id> + <enabled>N</enabled> + <name>EXECUTING_SERVER</name> + </field> + <field> + <id>EXECUTING_USER</id> + <enabled>N</enabled> + <name>EXECUTING_USER</name> + </field> + <field> + <id>CLIENT</id> + <enabled>N</enabled> + <name>CLIENT</name> + </field> + </trans-log-table> + <perf-log-table> + <connection/> + <schema/> + <table/> + <interval/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>SEQ_NR</id> + <enabled>Y</enabled> + <name>SEQ_NR</name> + </field> + <field> + <id>LOGDATE</id> + <enabled>Y</enabled> + <name>LOGDATE</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STEPNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>STEP_COPY</id> + <enabled>Y</enabled> + <name>STEP_COPY</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>INPUT_BUFFER_ROWS</id> + <enabled>Y</enabled> + <name>INPUT_BUFFER_ROWS</name> + </field> + <field> + <id>OUTPUT_BUFFER_ROWS</id> + <enabled>Y</enabled> + <name>OUTPUT_BUFFER_ROWS</name> + </field> + </perf-log-table> + <channel-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>LOGGING_OBJECT_TYPE</id> + <enabled>Y</enabled> + <name>LOGGING_OBJECT_TYPE</name> + </field> + <field> + <id>OBJECT_NAME</id> + <enabled>Y</enabled> + <name>OBJECT_NAME</name> + </field> + <field> + <id>OBJECT_COPY</id> + <enabled>Y</enabled> + <name>OBJECT_COPY</name> + </field> + <field> + <id>REPOSITORY_DIRECTORY</id> + <enabled>Y</enabled> + <name>REPOSITORY_DIRECTORY</name> + </field> + <field> + <id>FILENAME</id> + <enabled>Y</enabled> + <name>FILENAME</name> + </field> + <field> + <id>OBJECT_ID</id> + <enabled>Y</enabled> + <name>OBJECT_ID</name> + </field> + <field> + <id>OBJECT_REVISION</id> + <enabled>Y</enabled> + <name>OBJECT_REVISION</name> + </field> + <field> + <id>PARENT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>PARENT_CHANNEL_ID</name> + </field> + <field> + <id>ROOT_CHANNEL_ID</id> + <enabled>Y</enabled> + <name>ROOT_CHANNEL_ID</name> + </field> + </channel-log-table> + <step-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>TRANSNAME</id> + <enabled>Y</enabled> + <name>TRANSNAME</name> + </field> + <field> + <id>STEPNAME</id> + <enabled>Y</enabled> + <name>STEPNAME</name> + </field> + <field> + <id>STEP_COPY</id> + <enabled>Y</enabled> + <name>STEP_COPY</name> + </field> + <field> + <id>LINES_READ</id> + <enabled>Y</enabled> + <name>LINES_READ</name> + </field> + <field> + <id>LINES_WRITTEN</id> + <enabled>Y</enabled> + <name>LINES_WRITTEN</name> + </field> + <field> + <id>LINES_UPDATED</id> + <enabled>Y</enabled> + <name>LINES_UPDATED</name> + </field> + <field> + <id>LINES_INPUT</id> + <enabled>Y</enabled> + <name>LINES_INPUT</name> + </field> + <field> + <id>LINES_OUTPUT</id> + <enabled>Y</enabled> + <name>LINES_OUTPUT</name> + </field> + <field> + <id>LINES_REJECTED</id> + <enabled>Y</enabled> + <name>LINES_REJECTED</name> + </field> + <field> + <id>ERRORS</id> + <enabled>Y</enabled> + <name>ERRORS</name> + </field> + <field> + <id>LOG_FIELD</id> + <enabled>N</enabled> + <name>LOG_FIELD</name> + </field> + </step-log-table> + <metrics-log-table> + <connection/> + <schema/> + <table/> + <timeout_days/> + <field> + <id>ID_BATCH</id> + <enabled>Y</enabled> + <name>ID_BATCH</name> + </field> + <field> + <id>CHANNEL_ID</id> + <enabled>Y</enabled> + <name>CHANNEL_ID</name> + </field> + <field> + <id>LOG_DATE</id> + <enabled>Y</enabled> + <name>LOG_DATE</name> + </field> + <field> + <id>METRICS_DATE</id> + <enabled>Y</enabled> + <name>METRICS_DATE</name> + </field> + <field> + <id>METRICS_CODE</id> + <enabled>Y</enabled> + <name>METRICS_CODE</name> + </field> + <field> + <id>METRICS_DESCRIPTION</id> + <enabled>Y</enabled> + <name>METRICS_DESCRIPTION</name> + </field> + <field> + <id>METRICS_SUBJECT</id> + <enabled>Y</enabled> + <name>METRICS_SUBJECT</name> + </field> + <field> + <id>METRICS_TYPE</id> + <enabled>Y</enabled> + <name>METRICS_TYPE</name> + </field> + <field> + <id>METRICS_VALUE</id> + <enabled>Y</enabled> + <name>METRICS_VALUE</name> + </field> + </metrics-log-table> + </log> + <maxdate> + <connection/> + <table/> + <field/> + <offset>0.0</offset> + <maxdiff>0.0</maxdiff> + </maxdate> + <size_rowset>10000</size_rowset> + <sleep_time_empty>50</sleep_time_empty> + <sleep_time_full>50</sleep_time_full> + <unique_connections>N</unique_connections> + <feedback_shown>Y</feedback_shown> + <feedback_size>50000</feedback_size> + <using_thread_priorities>Y</using_thread_priorities> + <shared_objects_file/> + <capture_step_performance>N</capture_step_performance> + <step_performance_capturing_delay>1000</step_performance_capturing_delay> + <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit> + <dependencies> + </dependencies> + <partitionschemas> + </partitionschemas> + <slaveservers> + </slaveservers> + <clusterschemas> + </clusterschemas> + <created_user>-</created_user> + <created_date>2023/03/09 16:28:40.400</created_date> + <modified_user>-</modified_user> + <modified_date>2023/03/09 16:28:40.400</modified_date> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> + <is_key_private>N</is_key_private> + </info> + <notepads> + </notepads> + <connection> + <name>dw bi fixco</name> + <server>192.168.23.5</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>dw_bi_fixco</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</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> + <hop> + <from>Execute SQL script</from> + <to>Execute SQL script 2</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Execute SQL script 2</from> + <to>Execute SQL script 3</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Execute SQL script 3</from> + <to>Execute SQL script 4</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Execute SQL script 4</from> + <to>Execute SQL script 5</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>Execute SQL script 5</from> + <to>Execute SQL script 6</to> + <enabled>Y</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 fixco</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_total_omzet_by_invoice</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>320</xloc> + <yloc>112</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Execute SQL script 2</name> + <type>ExecSQL</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi fixco</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_total_omzet_by_product</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>464</xloc> + <yloc>112</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Execute SQL script 3</name> + <type>ExecSQL</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi fixco</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 dw_brand</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>592</xloc> + <yloc>112</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Execute SQL script 4</name> + <type>ExecSQL</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi fixco</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 growth_brand_by_qty</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>720</xloc> + <yloc>112</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Execute SQL script 5</name> + <type>ExecSQL</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi fixco</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 growth_brand_by_value</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>864</xloc> + <yloc>112</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Execute SQL script 6</name> + <type>ExecSQL</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi fixco</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 growth_marketplace</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>1008</xloc> + <yloc>112</yloc> + <draw>Y</draw> + </GUI> + </step> + <step_error_handling> + </step_error_handling> + <slave-step-copy-partition-distribution> + </slave-step-copy-partition-distribution> + <slave_transformation>N</slave_transformation> + <attributes/> +</transformation> |