Hi, we are at 7.2
We are curently processing many xml files (using Expat, thanks SK!) and we
have no problems handling all of them. But a customer asked a side order:
while processing some xml file is possible to apply a filter and generate a
new xml file based on that filter? Of course the filter is based on DB
values and not on a static statement. Here an example:
<?xml version="1.0" encoding="ISO-8859-1"?>
<Prestazione cod_servizio="TML" cod_flusso="0050">
<IdentificativiRichiesta>
<piva_utente>01948840986</piva_utente>
<piva_distr>12883450152</piva_distr>
</IdentificativiRichiesta>
<DatiPdR>
<cod_pdr>01460300599013</cod_pdr>
<matr_mis>SMGR034115193036</matr_mis>
<coeff_corr>0.937715</coeff_corr>
<freq_let>1</freq_let>
<acc_mis>1</acc_mis>
<data_racc>30/11/2017</data_racc>
<let_tot_prel>000002156</let_tot_prel>
<tipo_lettura>E</tipo_lettura>
<val_dato>SI</val_dato>
<num_tentativi>1</num_tentativi>
<esito_raccolta>P</esito_raccolta>
<mod_alt_racc>N</mod_alt_racc>
<dir_indennizzo>N</dir_indennizzo>
<pros_fin>31/05/2018 31/12/2018</pros_fin>
</DatiPdR>
<DatiPdR>
<cod_pdr>01460300600772</cod_pdr>
<matr_mis>SMGR034115179789</matr_mis>
<coeff_corr>0.937715</coeff_corr>
<freq_let>1</freq_let>
<acc_mis>1</acc_mis>
<data_racc>30/11/2017</data_racc>
<let_tot_prel>000000994</let_tot_prel>
<tipo_lettura>E</tipo_lettura>
<val_dato>SI</val_dato>
<num_tentativi>1</num_tentativi>
<esito_raccolta>P</esito_raccolta>
<mod_alt_racc>N</mod_alt_racc>
<dir_indennizzo>N</dir_indennizzo>
<pros_fin>31/05/2018 31/12/2018</pros_fin>
</DatiPdR>
</Prestazione>
The request is to apply to cod_pdr something like this:
Where cod_pdr in(select mypdr from mycustfile where active_date is not null
and ending_date is null)
and then save the result in a new xml file (assuming only pdr
01460300600772 matches):
<?xml version="1.0" encoding="ISO-8859-1"?>
<Prestazione cod_servizio="TML" cod_flusso="0050">
<IdentificativiRichiesta>
<piva_utente>01948840986</piva_utente>
<piva_distr>12883450152</piva_distr>
</IdentificativiRichiesta>
<DatiPdR>
<cod_pdr>01460300600772</cod_pdr>
<matr_mis>SMGR034115179789</matr_mis>
<coeff_corr>0.937715</coeff_corr>
<freq_let>1</freq_let>
<acc_mis>1</acc_mis>
<data_racc>30/11/2017</data_racc>
<let_tot_prel>000000994</let_tot_prel>
<tipo_lettura>E</tipo_lettura>
<val_dato>SI</val_dato>
<num_tentativi>1</num_tentativi>
<esito_raccolta>P</esito_raccolta>
<mod_alt_racc>N</mod_alt_racc>
<dir_indennizzo>N</dir_indennizzo>
<pros_fin>31/05/2018 31/12/2018</pros_fin>
</DatiPdR>
</Prestazione>
We DO NOT store xml file in our DB, we only save in a secured IFS folder.
I thought about SQL but I'm open to any solution.
TIA
--
Marco Facchinetti
Mr S.r.l.
Tel. 035 962885
Cel. 393 9620498
Skype: facchinettimarco
midrange.com
