diff options
| -rw-r--r-- | import_all_data_bi_indoteknik.kjb | 216 | ||||
| -rw-r--r-- | run_indoteknik_job.kjb | 501 | ||||
| -rw-r--r-- | run_indoteknik_job.sh | 1 |
3 files changed, 514 insertions, 204 deletions
diff --git a/import_all_data_bi_indoteknik.kjb b/import_all_data_bi_indoteknik.kjb index a3bdf5b..ebadc64 100644 --- a/import_all_data_bi_indoteknik.kjb +++ b/import_all_data_bi_indoteknik.kjb @@ -567,162 +567,6 @@ <attributes_kjc/> </entry> <entry> - <name>import leadtime po to received</name> - <description/> - <type>TRANS</type> - <attributes/> - <specification_method>filename</specification_method> - <trans_object_id/> - <filename>/home/stephan/transformation-job-bi/import_leadtime_po_to_received.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>704</xloc> - <yloc>256</yloc> - <attributes_kjc/> - </entry> - <entry> - <name>import leadtime so to send</name> - <description/> - <type>TRANS</type> - <attributes/> - <specification_method>filename</specification_method> - <trans_object_id/> - <filename>/home/stephan/transformation-job-bi/import_leadtime_so_send.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>256</yloc> - <attributes_kjc/> - </entry> - <entry> - <name>import leadtime detail po to received</name> - <description/> - <type>TRANS</type> - <attributes/> - <specification_method>filename</specification_method> - <trans_object_id/> - <filename>/home/stephan/transformation-job-bi/import_leadtime_po_to_received_detail.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>176</xloc> - <yloc>256</yloc> - <attributes_kjc/> - </entry> - <entry> - <name>import leadtime detail so to send</name> - <description/> - <type>TRANS</type> - <attributes/> - <specification_method>filename</specification_method> - <trans_object_id/> - <filename>/home/stephan/transformation-job-bi/import_leadtime_so_send_detail.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>176</xloc> - <yloc>416</yloc> - <attributes_kjc/> - </entry> - <entry> <name>import margin</name> <description/> <type>TRANS</type> @@ -758,7 +602,7 @@ <draw>Y</draw> <nr>0</nr> <xloc>480</xloc> - <yloc>416</yloc> + <yloc>256</yloc> <attributes_kjc/> </entry> <entry> @@ -796,8 +640,8 @@ <parallel>N</parallel> <draw>Y</draw> <nr>0</nr> - <xloc>704</xloc> - <yloc>416</yloc> + <xloc>480</xloc> + <yloc>400</yloc> <attributes_kjc/> </entry> <entry> @@ -1043,51 +887,6 @@ <unconditional>N</unconditional> </hop> <hop> - <from>Delete files</from> - <to>import leadtime po to received</to> - <from_nr>0</from_nr> - <to_nr>0</to_nr> - <enabled>Y</enabled> - <evaluation>Y</evaluation> - <unconditional>N</unconditional> - </hop> - <hop> - <from>import leadtime po to received</from> - <to>import leadtime so to send</to> - <from_nr>0</from_nr> - <to_nr>0</to_nr> - <enabled>Y</enabled> - <evaluation>Y</evaluation> - <unconditional>N</unconditional> - </hop> - <hop> - <from>import leadtime so to send</from> - <to>import leadtime detail po to received</to> - <from_nr>0</from_nr> - <to_nr>0</to_nr> - <enabled>Y</enabled> - <evaluation>Y</evaluation> - <unconditional>N</unconditional> - </hop> - <hop> - <from>import leadtime detail po to received</from> - <to>import leadtime detail so to send</to> - <from_nr>0</from_nr> - <to_nr>0</to_nr> - <enabled>Y</enabled> - <evaluation>Y</evaluation> - <unconditional>N</unconditional> - </hop> - <hop> - <from>import leadtime detail so to send</from> - <to>import margin</to> - <from_nr>0</from_nr> - <to_nr>0</to_nr> - <enabled>Y</enabled> - <evaluation>Y</evaluation> - <unconditional>N</unconditional> - </hop> - <hop> <from>import margin</from> <to>import sale order</to> <from_nr>0</from_nr> @@ -1159,6 +958,15 @@ <evaluation>Y</evaluation> <unconditional>N</unconditional> </hop> + <hop> + <from>Delete files</from> + <to>import margin</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> </hops> <notepads> </notepads> diff --git a/run_indoteknik_job.kjb b/run_indoteknik_job.kjb new file mode 100644 index 0000000..90b5dd0 --- /dev/null +++ b/run_indoteknik_job.kjb @@ -0,0 +1,501 @@ +<?xml version="1.0" encoding="UTF-8"?> +<job> + <name>run_indoteknik_job</name> + <description/> + <extended_description/> + <job_version/> + <directory>/</directory> + <created_user>-</created_user> + <created_date>2023/10/20 10:55:31.951</created_date> + <modified_user>-</modified_user> + <modified_date>2023/10/20 10:55:31.951</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>160</xloc> + <yloc>96</yloc> + <attributes_kjc/> + </entry> + <entry> + <name>import omset job</name> + <description/> + <type>JOB</type> + <attributes/> + <specification_method>filename</specification_method> + <job_object_id/> + <filename>/home/stephan/transformation-job-bi/import_all_data_bi_indoteknik.kjb</filename> + <jobname/> + <directory/> + <arg_from_previous>N</arg_from_previous> + <params_from_previous>N</params_from_previous> + <exec_per_row>N</exec_per_row> + <set_logfile>N</set_logfile> + <logfile/> + <logext/> + <add_date>N</add_date> + <add_time>N</add_time> + <loglevel>Nothing</loglevel> + <slave_server_name/> + <wait_until_finished>Y</wait_until_finished> + <follow_abort_remote>N</follow_abort_remote> + <expand_remote_job>N</expand_remote_job> + <create_parent_folder>N</create_parent_folder> + <pass_export>N</pass_export> + <run_configuration>Pentaho local</run_configuration> + <parameters> + <pass_all_parameters>Y</pass_all_parameters> + </parameters> + <set_append_logfile>N</set_append_logfile> + <parallel>N</parallel> + <draw>Y</draw> + <nr>0</nr> + <xloc>272</xloc> + <yloc>96</yloc> + <attributes_kjc/> + </entry> + <entry> + <name>import pricelist job</name> + <description/> + <type>JOB</type> + <attributes/> + <specification_method>filename</specification_method> + <job_object_id/> + <filename>/home/stephan/transformation-job-bi/run_calculate_pricelist_odoo.kjb</filename> + <jobname/> + <directory/> + <arg_from_previous>N</arg_from_previous> + <params_from_previous>N</params_from_previous> + <exec_per_row>N</exec_per_row> + <set_logfile>N</set_logfile> + <logfile/> + <logext/> + <add_date>N</add_date> + <add_time>N</add_time> + <loglevel>Nothing</loglevel> + <slave_server_name/> + <wait_until_finished>Y</wait_until_finished> + <follow_abort_remote>N</follow_abort_remote> + <expand_remote_job>N</expand_remote_job> + <create_parent_folder>N</create_parent_folder> + <pass_export>N</pass_export> + <run_configuration>Pentaho local</run_configuration> + <parameters> + <pass_all_parameters>Y</pass_all_parameters> + </parameters> + <set_append_logfile>N</set_append_logfile> + <parallel>N</parallel> + <draw>Y</draw> + <nr>0</nr> + <xloc>416</xloc> + <yloc>96</yloc> + <attributes_kjc/> + </entry> + <entry> + <name>import inventory</name> + <description/> + <type>JOB</type> + <attributes/> + <specification_method>filename</specification_method> + <job_object_id/> + <filename>/home/stephan/transformation-job-bi/import_delivery_order.kjb</filename> + <jobname/> + <directory/> + <arg_from_previous>N</arg_from_previous> + <params_from_previous>N</params_from_previous> + <exec_per_row>N</exec_per_row> + <set_logfile>N</set_logfile> + <logfile/> + <logext/> + <add_date>N</add_date> + <add_time>N</add_time> + <loglevel>Nothing</loglevel> + <slave_server_name/> + <wait_until_finished>Y</wait_until_finished> + <follow_abort_remote>N</follow_abort_remote> + <expand_remote_job>N</expand_remote_job> + <create_parent_folder>N</create_parent_folder> + <pass_export>N</pass_export> + <run_configuration>Pentaho local</run_configuration> + <parameters> + <pass_all_parameters>Y</pass_all_parameters> + </parameters> + <set_append_logfile>N</set_append_logfile> + <parallel>N</parallel> + <draw>Y</draw> + <nr>0</nr> + <xloc>576</xloc> + <yloc>96</yloc> + <attributes_kjc/> + </entry> + <entry> + <name>import leadtime</name> + <description/> + <type>JOB</type> + <attributes/> + <specification_method>filename</specification_method> + <job_object_id/> + <filename>/home/stephan/transformation-job-bi/import_leadtime_job.kjb</filename> + <jobname/> + <directory/> + <arg_from_previous>N</arg_from_previous> + <params_from_previous>N</params_from_previous> + <exec_per_row>N</exec_per_row> + <set_logfile>N</set_logfile> + <logfile/> + <logext/> + <add_date>N</add_date> + <add_time>N</add_time> + <loglevel>Nothing</loglevel> + <slave_server_name/> + <wait_until_finished>Y</wait_until_finished> + <follow_abort_remote>N</follow_abort_remote> + <expand_remote_job>N</expand_remote_job> + <create_parent_folder>N</create_parent_folder> + <pass_export>N</pass_export> + <run_configuration>Pentaho local</run_configuration> + <parameters> + <pass_all_parameters>Y</pass_all_parameters> + </parameters> + <set_append_logfile>N</set_append_logfile> + <parallel>N</parallel> + <draw>Y</draw> + <nr>0</nr> + <xloc>704</xloc> + <yloc>96</yloc> + <attributes_kjc/> + </entry> + </entries> + <hops> + <hop> + <from>Start</from> + <to>import omset job</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>Y</unconditional> + </hop> + <hop> + <from>import omset job</from> + <to>import pricelist job</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> + <hop> + <from>import pricelist job</from> + <to>import inventory</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> + <hop> + <from>import inventory</from> + <to>import leadtime</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/run_indoteknik_job.sh b/run_indoteknik_job.sh new file mode 100644 index 0000000..6def61a --- /dev/null +++ b/run_indoteknik_job.sh @@ -0,0 +1 @@ +sh /home/stephan/data-integration/kitchen.sh -level="Debug" -file="/home/stephan/transformation-job-bi/run_indoteknik_job.kjb" > "/home/stephan/transformation-job-bi/log/indoteknik_job.log" |