I need help in changing the XSL code

Discussion in 'XML' started by Hennie Coertze, May 15, 2007.

  1. 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.

    Your assistance is much appreciated.

    Thank you.

    Hennie

    The format it requires is as follow:

    <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:eek:utput 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>




    *** Sent via Developersdex http://www.developersdex.com ***
     
    Hennie Coertze, May 15, 2007
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Kevin Flood
    Replies:
    0
    Views:
    1,078
    Kevin Flood
    Sep 8, 2004
  2. Kevin Flood
    Replies:
    1
    Views:
    2,852
    Kevin Flood
    Sep 13, 2004
  3. Thomas S.

    XSL: textarea with xsl code???

    Thomas S., Feb 5, 2004, in forum: XML
    Replies:
    1
    Views:
    1,342
    Markus Spath
    Feb 5, 2004
  4. Replies:
    1
    Views:
    3,721
    A. Bolmarcich
    May 27, 2005
  5. =?iso-8859-1?q?Jean-Fran=E7ois_Michaud?=

    Help with XSL/XSL:FO for producing revision indicator bar in document.

    =?iso-8859-1?q?Jean-Fran=E7ois_Michaud?=, Apr 28, 2006, in forum: XML
    Replies:
    6
    Views:
    602
    =?iso-8859-1?q?Jean-Fran=E7ois_Michaud?=
    May 3, 2006
Loading...

Share This Page