diff options
| -rw-r--r-- | import_all_data_bi_indoteknik.kjb | 96 | ||||
| -rw-r--r-- | import_payment_term.ktr | 2 | ||||
| -rw-r--r-- | import_property.ktr | 2 |
3 files changed, 98 insertions, 2 deletions
diff --git a/import_all_data_bi_indoteknik.kjb b/import_all_data_bi_indoteknik.kjb index f2d92cd..e47394f 100644 --- a/import_all_data_bi_indoteknik.kjb +++ b/import_all_data_bi_indoteknik.kjb @@ -1073,6 +1073,84 @@ <yloc>656</yloc> <attributes_kjc/> </entry> + <entry> + <name>import property</name> + <description/> + <type>TRANS</type> + <attributes/> + <specification_method>filename</specification_method> + <trans_object_id/> + <filename>/home/stephan/transformation-job-bi/import_property.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>432</xloc> + <yloc>656</yloc> + <attributes_kjc/> + </entry> + <entry> + <name>import payment term</name> + <description/> + <type>TRANS</type> + <attributes/> + <specification_method>filename</specification_method> + <trans_object_id/> + <filename>/home/stephan/transformation-job-bi/import_payment_term.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>288</xloc> + <yloc>656</yloc> + <attributes_kjc/> + </entry> </entries> <hops> <hop> @@ -1255,6 +1333,24 @@ <evaluation>Y</evaluation> <unconditional>N</unconditional> </hop> + <hop> + <from>import invoice margin</from> + <to>import property</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> + <hop> + <from>import property</from> + <to>import payment term</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/import_payment_term.ktr b/import_payment_term.ktr index 32d48ab..4da70b8 100644 --- a/import_payment_term.ktr +++ b/import_payment_term.ktr @@ -557,7 +557,7 @@ </partitioning> <connection>erp indoteknik production (localhost)</connection> <sql>select * from account_payment_term ---where write_date >= (now() - '5 days'::interval)</sql> +where write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> diff --git a/import_property.ktr b/import_property.ktr index a7af364..518f63e 100644 --- a/import_property.ktr +++ b/import_property.ktr @@ -558,7 +558,7 @@ <connection>erp indoteknik production (localhost)</connection> <sql>select * from ir_property ip where (ip.name = 'property_supplier_payment_term_id' or ip.name = 'property_payment_term_id') ---and ip.write_date >= (now() - '5 days'::interval)</sql> +and ip.write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> |