Created
December 1, 2011 15:02
-
-
Save amusarra/1417396 to your computer and use it in GitHub Desktop.
Job e Trasformazione per il calcolo del codice fiscale
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="UTF-8"?> | |
| <job> | |
| <name>ExecuteCalculateCodiceFiscale</name> | |
| <description>Job che esegue la trasformazione per l'integrazione del Codice Fiscale</description> | |
| <extended_description/> | |
| <job_version>1.0</job_version> | |
| <job_status>1</job_status> | |
| <directory>/</directory> | |
| <created_user>-</created_user> | |
| <created_date>2011/01/25 17:21:26.000</created_date> | |
| <modified_user>admin</modified_user> | |
| <modified_date>2011/02/17 10:35:19.000</modified_date> | |
| <parameters> | |
| </parameters> | |
| <slaveservers> | |
| <slaveserver><name>shirus-pentaho-suite-00.lab.roma.matrix.it</name><hostname>shirus-pentaho-suite-00.lab.roma.matrix.it</hostname><port>8080</port><webAppName/><username>cluster</username><password>Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8</password><proxy_hostname/><proxy_port/><non_proxy_hosts/><master>Y</master></slaveserver> | |
| </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></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></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>Mail Fail</name> | |
| <description/> | |
| <type>MAIL</type> | |
| <server>smtp.gmail.com</server> | |
| <port>587</port> | |
| <destination>[email protected]</destination> | |
| <destinationCc/> | |
| <destinationBCc/> | |
| <replyto>[email protected]</replyto> | |
| <replytoname>Antonio Musarra</replytoname> | |
| <subject>Job ExcuteCalculateCodiceFiscale failed</subject> | |
| <include_date>Y</include_date> | |
| <contact_person>Antonio Musarra</contact_person> | |
| <contact_phone>+39 3351028122</contact_phone> | |
| <comment>Il job in oggetto è stato eseguito e terminato con errori.</comment> | |
| <include_files>Y</include_files> | |
| <zip_files>N</zip_files> | |
| <zip_name/> | |
| <use_auth>Y</use_auth> | |
| <use_secure_auth>Y</use_secure_auth> | |
| <auth_user>[email protected]</auth_user> | |
| <auth_password>Encrypted 2dbf0cbf91aca9d97a91aaa22ca86a38b</auth_password> | |
| <only_comment>Y</only_comment> | |
| <use_HTML>Y</use_HTML> | |
| <use_Priority>Y</use_Priority> | |
| <encoding>UTF-8</encoding> | |
| <priority>high</priority> | |
| <importance>normal</importance> | |
| <secureconnectiontype>TLS</secureconnectiontype> | |
| <replyToAddresses>[email protected]</replyToAddresses> | |
| <filetypes> <filetype>LOG</filetype> | |
| </filetypes> <embeddedimages> | |
| <embeddedimage> | |
| <image_name>${ERROR_PATH}/ImportPerson_CalculateCodiceFiscale.log</image_name> | |
| <content_id/> | |
| </embeddedimage> | |
| </embeddedimages> | |
| <parallel>N</parallel> | |
| <draw>Y</draw> | |
| <nr>0</nr> | |
| <xloc>427</xloc> | |
| <yloc>143</yloc> | |
| </entry> | |
| <entry> | |
| <name>Mail Success</name> | |
| <description/> | |
| <type>MAIL</type> | |
| <server>smtp.gmail.com</server> | |
| <port>587</port> | |
| <destination>[email protected]</destination> | |
| <destinationCc/> | |
| <destinationBCc/> | |
| <replyto>[email protected]</replyto> | |
| <replytoname>Antonio Musarra</replytoname> | |
| <subject>Job ExcuteCalculateCodiceFiscale success</subject> | |
| <include_date>Y</include_date> | |
| <contact_person>Antonio Musarra</contact_person> | |
| <contact_phone>+39 3351028122</contact_phone> | |
| <comment>Il job in oggetto è stato eseguito e terminato con successo</comment> | |
| <include_files>Y</include_files> | |
| <zip_files>N</zip_files> | |
| <zip_name>person_codice_fiscale.zip</zip_name> | |
| <use_auth>Y</use_auth> | |
| <use_secure_auth>Y</use_secure_auth> | |
| <auth_user>[email protected]</auth_user> | |
| <auth_password>Encrypted 2dbf0cbf91aca9d97a91aaa22ca86a38b</auth_password> | |
| <only_comment>Y</only_comment> | |
| <use_HTML>Y</use_HTML> | |
| <use_Priority>Y</use_Priority> | |
| <encoding>UTF-8</encoding> | |
| <priority>high</priority> | |
| <importance>normal</importance> | |
| <secureconnectiontype>TLS</secureconnectiontype> | |
| <replyToAddresses>[email protected]</replyToAddresses> | |
| <filetypes> <filetype>GENERAL</filetype> | |
| </filetypes> <embeddedimages> | |
| <embeddedimage> | |
| <image_name>${OUTPUT_PATH}/person_codice_fiscale.xml</image_name> | |
| <content_id>5bplu561ecejo</content_id> | |
| </embeddedimage> | |
| </embeddedimages> | |
| <parallel>N</parallel> | |
| <draw>Y</draw> | |
| <nr>0</nr> | |
| <xloc>681</xloc> | |
| <yloc>266</yloc> | |
| </entry> | |
| <entry> | |
| <name>ImportPerson_CalculateCodiceFiscale</name> | |
| <description/> | |
| <type>TRANS</type> | |
| <specification_method>rep_name</specification_method> | |
| <trans_object_id/> | |
| <filename/> | |
| <transname>ImportPerson_CalculateCodiceFiscale</transname> | |
| <directory>/PortaleAgenti</directory> | |
| <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>Y</set_logfile> | |
| <logfile>${ERROR_PATH}/ImportPerson_CalculateCodiceFiscale</logfile> | |
| <logext>log</logext> | |
| <add_date>N</add_date> | |
| <add_time>N</add_time> | |
| <loglevel>Debug</loglevel> | |
| <cluster>N</cluster> | |
| <slave_server_name>shirus-pentaho-suite-00.lab.roma.matrix.it</slave_server_name> | |
| <set_append_logfile>Y</set_append_logfile> | |
| <wait_until_finished>Y</wait_until_finished> | |
| <follow_abort_remote>N</follow_abort_remote> | |
| <create_parent_folder>N</create_parent_folder> | |
| <parameters> <pass_all_parameters>Y</pass_all_parameters> | |
| </parameters> <parallel>N</parallel> | |
| <draw>Y</draw> | |
| <nr>0</nr> | |
| <xloc>427</xloc> | |
| <yloc>267</yloc> | |
| </entry> | |
| <entry> | |
| <name>START</name> | |
| <description/> | |
| <type>SPECIAL</type> | |
| <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>212</xloc> | |
| <yloc>267</yloc> | |
| </entry> | |
| </entries> | |
| <hops> | |
| <hop> | |
| <from>ImportPerson_CalculateCodiceFiscale</from> | |
| <to>Mail Fail</to> | |
| <from_nr>0</from_nr> | |
| <to_nr>0</to_nr> | |
| <enabled>Y</enabled> | |
| <evaluation>N</evaluation> | |
| <unconditional>N</unconditional> | |
| </hop> | |
| <hop> | |
| <from>ImportPerson_CalculateCodiceFiscale</from> | |
| <to>Mail Success</to> | |
| <from_nr>0</from_nr> | |
| <to_nr>0</to_nr> | |
| <enabled>Y</enabled> | |
| <evaluation>Y</evaluation> | |
| <unconditional>N</unconditional> | |
| </hop> | |
| <hop> | |
| <from>START</from> | |
| <to>ImportPerson_CalculateCodiceFiscale</to> | |
| <from_nr>0</from_nr> | |
| <to_nr>0</to_nr> | |
| <enabled>Y</enabled> | |
| <evaluation>Y</evaluation> | |
| <unconditional>Y</unconditional> | |
| </hop> | |
| </hops> | |
| <notepads> | |
| <notepad> | |
| <note>Job Execute Calculate Codice Fiscale</note> | |
| <xloc>286</xloc> | |
| <yloc>69</yloc> | |
| <width>346</width> | |
| <heigth>32</heigth> | |
| <fontname>Ariel</fontname> | |
| <fontsize>18</fontsize> | |
| <fontbold>Y</fontbold> | |
| <fontitalic>Y</fontitalic> | |
| <fontcolorred>0</fontcolorred> | |
| <fontcolorgreen>0</fontcolorgreen> | |
| <fontcolorblue>0</fontcolorblue> | |
| <backgroundcolorred>255</backgroundcolorred> | |
| <backgroundcolorgreen>165</backgroundcolorgreen> | |
| <backgroundcolorblue>0</backgroundcolorblue> | |
| <bordercolorred>100</bordercolorred> | |
| <bordercolorgreen>100</bordercolorgreen> | |
| <bordercolorblue>100</bordercolorblue> | |
| <drawshadow>Y</drawshadow> | |
| </notepad> | |
| </notepads> | |
| </job> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="UTF-8"?> | |
| <transformation> | |
| <info> | |
| <name>ImportPerson_CalculateCodiceFiscale</name> | |
| <description>Processo d'importazione di un set di dati di tipo Person e calcolo del Codice Fiscale</description> | |
| <extended_description/> | |
| <trans_version>1.0</trans_version> | |
| <trans_type>Normal</trans_type> | |
| <trans_status>1</trans_status> | |
| <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></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> | |
| </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>Y</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> | |
| <slaveserver><name>shirus-pentaho-suite-00.lab.roma.matrix.it</name><hostname>shirus-pentaho-suite-00.lab.roma.matrix.it</hostname><port>8080</port><webAppName/><username>cluster</username><password>Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8</password><proxy_hostname/><proxy_port/><non_proxy_hosts/><master>Y</master></slaveserver> | |
| </slaveservers> | |
| <clusterschemas> | |
| </clusterschemas> | |
| <created_user>-</created_user> | |
| <created_date>2011/01/25 14:18:03.000</created_date> | |
| <modified_user>admin</modified_user> | |
| <modified_date>2011/01/31 15:53:11.000</modified_date> | |
| </info> | |
| <notepads> | |
| <notepad> | |
| <note>Trasformazione per l'integrazione del Codice Fiscale sulla sorgente dati</note> | |
| <xloc>139</xloc> | |
| <yloc>70</yloc> | |
| <width>635</width> | |
| <heigth>32</heigth> | |
| <fontname>Ariel</fontname> | |
| <fontsize>18</fontsize> | |
| <fontbold>N</fontbold> | |
| <fontitalic>Y</fontitalic> | |
| <fontcolorred>0</fontcolorred> | |
| <fontcolorgreen>0</fontcolorgreen> | |
| <fontcolorblue>0</fontcolorblue> | |
| <backgroundcolorred>255</backgroundcolorred> | |
| <backgroundcolorgreen>165</backgroundcolorgreen> | |
| <backgroundcolorblue>0</backgroundcolorblue> | |
| <bordercolorred>100</bordercolorred> | |
| <bordercolorgreen>100</bordercolorgreen> | |
| <bordercolorblue>100</bordercolorblue> | |
| <drawshadow>Y</drawshadow> | |
| </notepad> | |
| </notepads> | |
| <order> | |
| <hop> <from>WS_CalcoloCodiceFiscale</from><to>XML Output</to><enabled>Y</enabled> </hop> <hop> <from>ReadPersonData</from><to>Unique rows</to><enabled>Y</enabled> </hop> <hop> <from>Unique rows</from><to>Write to log</to><enabled>Y</enabled> </hop> <hop> <from>Replace for data_nascita e sesso</from><to>Replace SESSO Femminile</to><enabled>Y</enabled> </hop> <hop> <from>Unique rows</from><to>Replace for data_nascita e sesso</to><enabled>Y</enabled> </hop> <hop> <from>Replace SESSO Femminile</from><to>Replace SESSO Maschile</to><enabled>Y</enabled> </hop> <hop> <from>Replace SESSO Maschile</from><to>WS_CalcoloCodiceFiscale</to><enabled>Y</enabled> </hop> </order> | |
| <step> | |
| <name>ReadPersonData</name> | |
| <type>CsvInput</type> | |
| <description>Lettura dei dati anagrafici di Persone Fisiche.</description> | |
| <distribute>N</distribute> | |
| <copies>1</copies> | |
| <partitioning> | |
| <method>none</method> | |
| <schema_name/> | |
| </partitioning> | |
| <filename>${INPUT_PATH}/input_csv_codice_fiscale.csv</filename> | |
| <filename_field/> | |
| <rownum_field/> | |
| <include_filename>N</include_filename> | |
| <separator>,</separator> | |
| <enclosure>"</enclosure> | |
| <header>Y</header> | |
| <buffer_size>50000</buffer_size> | |
| <lazy_conversion>Y</lazy_conversion> | |
| <add_filename_result>Y</add_filename_result> | |
| <parallel>Y</parallel> | |
| <encoding>UTF-8</encoding> | |
| <fields> | |
| <field> | |
| <name>NOME</name> | |
| <type>String</type> | |
| <format/> | |
| <currency/> | |
| <decimal>,</decimal> | |
| <group>.</group> | |
| <length>9</length> | |
| <precision>-1</precision> | |
| <trim_type>none</trim_type> | |
| </field> | |
| <field> | |
| <name>COGNOME</name> | |
| <type>String</type> | |
| <format/> | |
| <currency/> | |
| <decimal>,</decimal> | |
| <group>.</group> | |
| <length>9</length> | |
| <precision>-1</precision> | |
| <trim_type>none</trim_type> | |
| </field> | |
| <field> | |
| <name>CITTA</name> | |
| <type>String</type> | |
| <format/> | |
| <currency/> | |
| <decimal>,</decimal> | |
| <group>.</group> | |
| <length>11</length> | |
| <precision>-1</precision> | |
| <trim_type>none</trim_type> | |
| </field> | |
| <field> | |
| <name>DATA_NASCITA</name> | |
| <type>String</type> | |
| <format/> | |
| <currency/> | |
| <decimal>,</decimal> | |
| <group>.</group> | |
| <length>10</length> | |
| <precision>-1</precision> | |
| <trim_type>none</trim_type> | |
| </field> | |
| <field> | |
| <name>SESSO</name> | |
| <type>String</type> | |
| <format/> | |
| <currency/> | |
| <decimal>,</decimal> | |
| <group>.</group> | |
| <length>9</length> | |
| <precision>-1</precision> | |
| <trim_type>none</trim_type> | |
| </field> | |
| </fields> | |
| <cluster_schema/> | |
| <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> | |
| <xloc>135</xloc> | |
| <yloc>217</yloc> | |
| <draw>Y</draw> | |
| </GUI> | |
| </step> | |
| <step> | |
| <name>Replace SESSO Femminile</name> | |
| <type>ReplaceString</type> | |
| <description/> | |
| <distribute>N</distribute> | |
| <copies>1</copies> | |
| <partitioning> | |
| <method>none</method> | |
| <schema_name/> | |
| </partitioning> | |
| <fields> | |
| <field> | |
| <in_stream_name>SESSO</in_stream_name> | |
| <out_stream_name/> | |
| <use_regex>no</use_regex> | |
| <replace_string>FEMMINILE</replace_string> | |
| <replace_by_string>F</replace_by_string> | |
| <whole_word>no</whole_word> | |
| <case_sensitive>no</case_sensitive> | |
| </field> | |
| </fields> | |
| <cluster_schema/> | |
| <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> | |
| <xloc>603</xloc> | |
| <yloc>335</yloc> | |
| <draw>Y</draw> | |
| </GUI> | |
| </step> | |
| <step> | |
| <name>Replace SESSO Maschile</name> | |
| <type>ReplaceString</type> | |
| <description/> | |
| <distribute>N</distribute> | |
| <copies>1</copies> | |
| <partitioning> | |
| <method>none</method> | |
| <schema_name/> | |
| </partitioning> | |
| <fields> | |
| <field> | |
| <in_stream_name>SESSO</in_stream_name> | |
| <out_stream_name/> | |
| <use_regex>no</use_regex> | |
| <replace_string>MASCHILE</replace_string> | |
| <replace_by_string>M</replace_by_string> | |
| <whole_word>no</whole_word> | |
| <case_sensitive>no</case_sensitive> | |
| </field> | |
| </fields> | |
| <cluster_schema/> | |
| <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> | |
| <xloc>773</xloc> | |
| <yloc>335</yloc> | |
| <draw>Y</draw> | |
| </GUI> | |
| </step> | |
| <step> | |
| <name>Replace for data_nascita e sesso</name> | |
| <type>ReplaceString</type> | |
| <description/> | |
| <distribute>N</distribute> | |
| <copies>1</copies> | |
| <partitioning> | |
| <method>none</method> | |
| <schema_name/> | |
| </partitioning> | |
| <fields> | |
| <field> | |
| <in_stream_name>DATA_NASCITA</in_stream_name> | |
| <out_stream_name/> | |
| <use_regex>no</use_regex> | |
| <replace_string>-</replace_string> | |
| <replace_by_string>/</replace_by_string> | |
| <whole_word>no</whole_word> | |
| <case_sensitive>no</case_sensitive> | |
| </field> | |
| </fields> | |
| <cluster_schema/> | |
| <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> | |
| <xloc>604</xloc> | |
| <yloc>217</yloc> | |
| <draw>Y</draw> | |
| </GUI> | |
| </step> | |
| <step> | |
| <name>Unique rows</name> | |
| <type>Unique</type> | |
| <description/> | |
| <distribute>N</distribute> | |
| <copies>1</copies> | |
| <partitioning> | |
| <method>none</method> | |
| <schema_name/> | |
| </partitioning> | |
| <count_rows>N</count_rows> | |
| <count_field/> | |
| <reject_duplicate_row>Y</reject_duplicate_row> | |
| <error_description>Riga duplicata</error_description> | |
| <fields> <field> <name>NOME</name> | |
| <case_insensitive>Y</case_insensitive> | |
| </field> <field> <name>COGNOME</name> | |
| <case_insensitive>Y</case_insensitive> | |
| </field> <field> <name>CITTA</name> | |
| <case_insensitive>Y</case_insensitive> | |
| </field> <field> <name>DATA_NASCITA</name> | |
| <case_insensitive>Y</case_insensitive> | |
| </field> <field> <name>SESSO</name> | |
| <case_insensitive>Y</case_insensitive> | |
| </field> </fields> <cluster_schema/> | |
| <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> | |
| <xloc>349</xloc> | |
| <yloc>217</yloc> | |
| <draw>Y</draw> | |
| </GUI> | |
| </step> | |
| <step> | |
| <name>WS_CalcoloCodiceFiscale</name> | |
| <type>WebServiceLookup</type> | |
| <description/> | |
| <distribute>N</distribute> | |
| <copies>1</copies> | |
| <partitioning> | |
| <method>none</method> | |
| <schema_name/> | |
| </partitioning> | |
| <wsURL>http://webservices.dotnethell.it/codicefiscale.asmx?WSDL</wsURL> | |
| <wsOperation>CalcolaCodiceFiscale</wsOperation> | |
| <wsOperationRequest/> | |
| <wsOperationNamespace>http://webservices.dotnethell.it/CodiceFiscale</wsOperationNamespace> | |
| <wsInFieldContainer/> | |
| <wsInFieldArgument/> | |
| <wsOutFieldContainer>CalcolaCodiceFiscaleResult</wsOutFieldContainer> | |
| <wsOutFieldArgument>CalcolaCodiceFiscaleResult</wsOutFieldArgument> | |
| <proxyHost/> | |
| <proxyPort/> | |
| <httpLogin/> | |
| <httpPassword/> | |
| <callStep>1</callStep> | |
| <passingInputData>Y</passingInputData> | |
| <compatible>N</compatible> | |
| <repeating_element/> | |
| <reply_as_string>N</reply_as_string> | |
| <fieldsIn> | |
| <field> | |
| <name>NOME</name> | |
| <wsName>Nome</wsName> | |
| <xsdType>string</xsdType> | |
| </field> | |
| <field> | |
| <name>COGNOME</name> | |
| <wsName>Cognome</wsName> | |
| <xsdType>string</xsdType> | |
| </field> | |
| <field> | |
| <name>CITTA</name> | |
| <wsName>ComuneNascita</wsName> | |
| <xsdType>string</xsdType> | |
| </field> | |
| <field> | |
| <name>DATA_NASCITA</name> | |
| <wsName>DataNascita</wsName> | |
| <xsdType>string</xsdType> | |
| </field> | |
| <field> | |
| <name>SESSO</name> | |
| <wsName>Sesso</wsName> | |
| <xsdType>string</xsdType> | |
| </field> | |
| </fieldsIn> | |
| <fieldsOut> | |
| <field> | |
| <name>CalcolaCodiceFiscaleResult</name> | |
| <wsName>CalcolaCodiceFiscaleResult</wsName> | |
| <xsdType>string</xsdType> | |
| </field> | |
| </fieldsOut> | |
| <cluster_schema/> | |
| <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> | |
| <xloc>773</xloc> | |
| <yloc>489</yloc> | |
| <draw>Y</draw> | |
| </GUI> | |
| </step> | |
| <step> | |
| <name>Write to log</name> | |
| <type>WriteToLog</type> | |
| <description/> | |
| <distribute>Y</distribute> | |
| <copies>1</copies> | |
| <partitioning> | |
| <method>none</method> | |
| <schema_name/> | |
| </partitioning> | |
| <loglevel>log_level_rowlevel</loglevel> | |
| <displayHeader>Y</displayHeader> | |
| <fields> | |
| <field> | |
| <name>NOME</name> | |
| </field> | |
| <field> | |
| <name>COGNOME</name> | |
| </field> | |
| <field> | |
| <name>CITTA</name> | |
| </field> | |
| <field> | |
| <name>DATA_NASCITA</name> | |
| </field> | |
| <field> | |
| <name>SESSO</name> | |
| </field> | |
| </fields> | |
| <cluster_schema/> | |
| <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> | |
| <xloc>348</xloc> | |
| <yloc>406</yloc> | |
| <draw>Y</draw> | |
| </GUI> | |
| </step> | |
| <step> | |
| <name>XML Output</name> | |
| <type>XMLOutput</type> | |
| <description/> | |
| <distribute>Y</distribute> | |
| <copies>1</copies> | |
| <partitioning> | |
| <method>none</method> | |
| <schema_name/> | |
| </partitioning> | |
| <encoding>UTF-8</encoding> | |
| <name_space/> | |
| <xml_main_element>Rows</xml_main_element> | |
| <xml_repeat_element>Row</xml_repeat_element> | |
| <file> | |
| <name>${OUTPUT_PATH}/person_codice_fiscale</name> | |
| <extention>xml</extention> | |
| <do_not_open_newfile_init>N</do_not_open_newfile_init> | |
| <split>N</split> | |
| <add_date>N</add_date> | |
| <add_time>N</add_time> | |
| <SpecifyFormat>N</SpecifyFormat> | |
| <omit_null_values>Y</omit_null_values> | |
| <date_time_format/> | |
| <add_to_result_filenames>N</add_to_result_filenames> | |
| <zipped>N</zipped> | |
| <splitevery>0</splitevery> | |
| </file> | |
| <fields> | |
| <field> | |
| <name>NOME</name> | |
| <element/> | |
| <type>String</type> | |
| <format/> | |
| <currency/> | |
| <decimal/> | |
| <group/> | |
| <nullif/> | |
| <length>9</length> | |
| <precision>-1</precision> | |
| </field> | |
| <field> | |
| <name>COGNOME</name> | |
| <element/> | |
| <type>String</type> | |
| <format/> | |
| <currency/> | |
| <decimal/> | |
| <group/> | |
| <nullif/> | |
| <length>9</length> | |
| <precision>-1</precision> | |
| </field> | |
| <field> | |
| <name>CITTA</name> | |
| <element/> | |
| <type>String</type> | |
| <format/> | |
| <currency/> | |
| <decimal/> | |
| <group/> | |
| <nullif/> | |
| <length>11</length> | |
| <precision>-1</precision> | |
| </field> | |
| <field> | |
| <name>DATA_NASCITA</name> | |
| <element/> | |
| <type>Date</type> | |
| <format>dd-MM-yyyy</format> | |
| <currency/> | |
| <decimal/> | |
| <group/> | |
| <nullif/> | |
| <length>10</length> | |
| <precision>-1</precision> | |
| </field> | |
| <field> | |
| <name>SESSO</name> | |
| <element/> | |
| <type>String</type> | |
| <format/> | |
| <currency/> | |
| <decimal/> | |
| <group/> | |
| <nullif/> | |
| <length>9</length> | |
| <precision>-1</precision> | |
| </field> | |
| <field> | |
| <name>CalcolaCodiceFiscaleResult</name> | |
| <element/> | |
| <type>String</type> | |
| <format/> | |
| <currency/> | |
| <decimal/> | |
| <group/> | |
| <nullif/> | |
| <length>-1</length> | |
| <precision>-1</precision> | |
| </field> | |
| </fields> | |
| <cluster_schema/> | |
| <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> | |
| <xloc>568</xloc> | |
| <yloc>489</yloc> | |
| <draw>Y</draw> | |
| </GUI> | |
| </step> | |
| <step_error_handling> | |
| <error> | |
| <source_step>ReadPersonData</source_step> | |
| <target_step/> | |
| <is_enabled>Y</is_enabled> | |
| <nr_valuename/> | |
| <descriptions_valuename/> | |
| <fields_valuename/> | |
| <codes_valuename/> | |
| <max_errors/> | |
| <max_pct_errors/> | |
| <min_pct_rows/> | |
| </error> | |
| <error> | |
| <source_step>Unique rows</source_step> | |
| <target_step>Write to log</target_step> | |
| <is_enabled>Y</is_enabled> | |
| <nr_valuename/> | |
| <descriptions_valuename/> | |
| <fields_valuename/> | |
| <codes_valuename/> | |
| <max_errors/> | |
| <max_pct_errors/> | |
| <min_pct_rows/> | |
| </error> | |
| </step_error_handling> | |
| <slave-step-copy-partition-distribution> | |
| </slave-step-copy-partition-distribution> | |
| <slave_transformation>N</slave_transformation> | |
| </transformation> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment