amusarra
12/1/2011 - 3:02 PM
Job e Trasformazione per il calcolo del codice fiscale
Job e Trasformazione per il calcolo del codice fiscale
<?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>antonio.musarra@gmail.com</destination>
<destinationCc/>
<destinationBCc/>
<replyto>antonio.musarra@gmail.com</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>antonio.musarra@gmail.com</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>antonio.musarra@gmail.com</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>antonio.musarra@gmail.com</destination>
<destinationCc/>
<destinationBCc/>
<replyto>antonio.musarra@gmail.com</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>antonio.musarra@gmail.com</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>antonio.musarra@gmail.com</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>
<?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>