[Home] [By Thread] [By Date] [Recent Entries]
Good day,
Thank you for your reply. I am aware of the one entry and have tried to run it with it as presented to you and without it with only sample_date_time. The result is the same. I receive the message for the following line: <xsl:for-each select="sample[generate-id() = generate-id(key('sample',concat(sample_date_time, cp_name)[1])]"> line 15, Character 23 Stylesheet error: Invalid XPath expression select You will also notice from the produced result extract, the following appears in the same line as sample_date_time xmlns:od="urn:schemas-microsoft-com:officedata". This is due to the dataroot entry from the flatfile and is created while the creating the flatfile from Access 2000. Thank you for your valueable time. Hennie Required output <?xml version="1.0" encoding="utf-8" ?> <submission imis_company_code="0001843309" ws_name="LENNOX TGS"> <sample sample_date_time="20070101" imis_cp_ext="2300" cp_name="NEUTRA. SUMP WTPE" dischg_sample_cd="20070101" sample_comment=""> <result rpttime_name="DAILY" sis_imis_code="FTFLOW" parm_name="FLOW" result_structure="SI" unit_abbrev="M3/D" rptas_abbrev="NOT APPL" component_type="SM" result_value="170.000000" result_comment="" imis_regulation_code_1="CA" imis_regulation_code_2="MC"/> <result rpttime_name="DAILY" sis_imis_code="PH" parm_name="PH (-LOG H+ CONCN)" result_structure="P3" unit_abbrev="NO DIM" rptas_abbrev="NOT APPL" component_type="V1" result_value="8.246000" result_comment="" imis_regulation_code_1="MC"/> </sample> Produced result <?xml version="1.0" encoding="utf-8" ?> <submission imis_company_code="0001843309" ws_name="LENNOX"> <sample sample_date_time="20070101" xmlns:od="urn:schemas-microsoft-com:officedata"> ==> due to dataroot. Very first entry in flat file. Repeated with every sample_date_time. <result cp_name="Neutr. Sump WTPE" imis_cp_ext="2300" dischg_sample_cd="" sample_comment="" rpttime_name="Daily" sis_imis_code="FTFLOW" parm_name="Flow" Unit_abbrev="M3/D" rptas_abbrev="NOT APPL" result_structure="SI" component_type="SM" result_value="168.2" result_comment="" imis_regulation_code_1="MC /> <result cp_name="Neutr. Sump WTPE" imis_cp_ext="2300" dischg_sample_cd="" sample_comment="" rpttime_name="Daily" sis_imis_code="pH" parm_name="pH (-log H+ Concn)" Unit_abbrev="NO DIM" rptas_abbrev="NOT APPL" result_structure="P3" component_type="V1" result_value="8.2" result_comment="" imis_regulation_code_1="MC" /> </sample> <sample sample_date_time="20070102" xmlns:od="urn:schemas-microsoft-com:officedata"> <result cp_name="Neutr. Sump WTPE" imis_cp_ext="2300" dischg_sample_cd="" sample_comment="" rpttime_name="Daily" sis_imis_code="FTFLOW" parm_name="Flow" Unit_abbrev="M3/D" rptas_abbrev="NOT APPL" result_structure="SI" component_type="SM" result_value="203.5" result_comment="" imis_regulation_code_1="MC" /> <result cp_name="Neutr. Sump WTPE" imis_cp_ext="2300" dischg_sample_cd="" sample_comment="" rpttime_name="Daily" sis_imis_code="pH" parm_name="pH (-log H+ Concn)" Unit_abbrev="NO DIM" rptas_abbrev="NOT APPL" result_structure="P3" component_type="V1" result_value="7.82" result_comment="" imis_regulation_code_1="MC" /> </sample> Flat file <dataroot>
<sample>
<sample_date_time>20070101</sample_date_time>
<cp_name>Neutr. Sump WTPE</cp_name>
<imis_cp_ext>2300</imis_cp_ext>
<dischg_sample_cd/>
<sample_comment/>
<rpttime_name>Daily</rpttime_name>
<sis_imis_code>FTFLOW</sis_imis_code>
<parm_name>Flow</parm_name>
<Unit_abbrev>M3/D</Unit_abbrev>
<rptas_abbrev>NOT APPL</rptas_abbrev>
<result_structure>SI</result_structure>
<component_type>SM</component_type>
<result_value>168.2</result_value>
<result_comment/>
<imis_regulation_code_1>MC</imis_regulation_code_1>
<imis_regulation_code_2>CA</imis_regulation_code_2>
</sample>
<sample>
<sample_date_time>20070101</sample_date_time>
<cp_name>Neutr. Sump WTPE</cp_name>
<imis_cp_ext>2300</imis_cp_ext>
<dischg_sample_cd/>
<sample_comment/>
<rpttime_name>Daily</rpttime_name>
<sis_imis_code>pH</sis_imis_code>
<parm_name>pH (-log H+ Concn)</parm_name>
<Unit_abbrev>NO DIM</Unit_abbrev>
<rptas_abbrev>NOT APPL</rptas_abbrev>
<result_structure>P3</result_structure>
<component_type>V1</component_type>
<result_value>8.2</result_value>
<result_comment/>
<imis_regulation_code_1>MC</imis_regulation_code_1>
<imis_regulation_code_2/>
</sample>
</dataroot>From: Abel Braaksma <abel.online@xxxxxxxxx> _________________________________________________________________ Share folders without harming wildlife! http://www.communicationevolved.com/en-za/
|

Cart



