Subject: [xsl] How do I change a XSL style sheet to group data together under one heading From: "kieters c" <kieters@xxxxxxxxxxx> Date: Wed, 16 May 2007 18:20:04 +0000 |
Good day, My knowledge of XML is next to none and I only have one XSL code to use. I also assume I may be using incorrect jargon and hope you will understand what I need.
I have an XSL style sheet to convert the XML flat file. I need to change the style sheet so it groups certain data together under one heading. I need to be able to do this as the system I upload the file to do not accept the information as presented and continuously gives me an error. What I am trying to say is that the result information under sample grouped together where the sample information is the same.
<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" /> <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="T1" result_value="08:00" result_comment="" imis_regulation_code_1="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="V2" result_value="8.233000" result_comment="" imis_regulation_code_1="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="T2" result_value="12:00" result_comment="" imis_regulation_code_1="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="V3" result_value="8.216000" result_comment="" imis_regulation_code_1="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="T3" result_value="16:00" result_comment="" imis_regulation_code_1="MC" /> <result rpttime_name="DAILY" sis_imis_code="RSP" parm_name="RESIDUE,PARTICULATE" result_structure="SI" unit_abbrev="MG/L" rptas_abbrev="NOT APPL" component_type="SM" result_value="3.38" result_comment="" imis_regulation_code_1="CA" imis_regulation_code_2="MC" /> </sample>
The one generated by the XSL style sheet is as follow.: Only a few records posted
- <sample sample_date_time="20070101" imis_cp_ext="2300" cp_name="Neutr. Sump WTPE" dischg_sample_cd="" sample_comment=""> <result 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" remark_code_1="" remark_code_2="" remark_code_3="" result_comment="" imis_regulation_code_1="MC" imis_regulation_code_2="CA" /> </sample> - <sample sample_date_time="20070101" imis_cp_ext="2300" cp_name="Neutr. Sump WTPE" dischg_sample_cd="" sample_comment=""> <result 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" remark_code_1="" remark_code_2="" remark_code_3="" result_comment="" imis_regulation_code_1="MC" imis_regulation_code_2="" /> </sample> - <sample sample_date_time="20070101" imis_cp_ext="2300" cp_name="Neutr. Sump WTPE" dischg_sample_cd="" sample_comment=""> <result 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="T1" result_value="08:00" remark_code_1="" remark_code_2="" remark_code_3="" result_comment="" imis_regulation_code_1="MC" imis_regulation_code_2="" /> </sample> - <sample sample_date_time="20070101" imis_cp_ext="2300" cp_name="Neutr. Sump WTPE" dischg_sample_cd="" sample_comment=""> <result 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="V2" result_value="8.17" remark_code_1="" remark_code_2="" remark_code_3="" result_comment="" imis_regulation_code_1="MC" imis_regulation_code_2="" /> </sample> - <sample sample_date_time="20070101" imis_cp_ext="2300" cp_name="Neutr. Sump WTPE" dischg_sample_cd="" sample_comment=""> <result 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="T2" result_value="12:00" remark_code_1="" remark_code_2="" remark_code_3="" result_comment="" imis_regulation_code_1="MC" imis_regulation_code_2="" /> </sample> The style sheet is : <?xml version="1.0" encoding="iso-8859-1" ?> - <!-- sample.xsl --> - <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output method="xml" indent="yes" /> - <xsl:variable name="UC"> <xsl:text>abcdefghijklmnopqrstuvwxyz</xsl:text> </xsl:variable> - <xsl:variable name="lc"> <xsl:text>abcdefghijklmnopqrstuvwxyz</xsl:text> </xsl:variable> - <xsl:template match="/"> - <submission imis_company_code="0001843309" ws_name=" "> <xsl:apply-templates /> </submission> </xsl:template> - <xsl:template match="sample"> - <sample sample_date_time="{sample_date_time}" imis_cp_ext="{imis_cp_ext}" cp_name="{cp_name}" dischg_sample_cd="{dischg_sample_cd}" sample_comment="{sample_comment}"> <result rpttime_name="{translate(rpttime_name,$lc,$UC)}" sis_imis_code="{translate(sis_imis_code,$lc,$UC)}" parm_name="{parm_name}" unit_abbrev="{Unit_abbrev}" rptas_abbrev="{rptas_abbrev}" result_structure="{result_structure}" component_type="{component_type}" result_value="{result_value}" remark_code_1="{remark_code_1}" remark_code_2="{remark_code_2}" remark_code_3="{remark_code_2}" result_comment="{result_comment}" imis_regulation_code_1="{imis_regulation_code_1}" imis_regulation_code_2="{imis_regulation_code_2}" /> </sample> </xsl:template> </xsl:stylesheet>
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Excluding certain nodes f, George Cristian Bina | Thread | Re: [xsl] How do I change a XSL sty, Abel Braaksma |
[xsl] Excluding certain nodes from , Andy Carr1 | Date | Re: [xsl] How do I change a XSL sty, Abel Braaksma |
Month |