dcsimg
www.webdeveloper.com
Results 1 to 4 of 4

Thread: Format xml grouping by date??????

  1. #1
    Join Date
    Apr 2003
    Posts
    3

    Format xml grouping by date??????

    Hello all,

    Here is my xml doc and desired output. I'm pretty new to using xslt and this has really stumped me. So any help is appreciated.

    XML:
    <VitalSignsComponent>
    <patient_info>
    <vitals>
    <type>bp</type>
    <date>04/14/2003</date>
    <time>13:15:00</time>
    <sys_value>157</sys_value>
    <dia_value>99</dia_value>
    <mean_value>118</mean_value>
    </vitals>
    <vitals>
    <type>bp</type>
    <date>04/14/2003</date>
    <time>13:30:00</time>
    <sys_value>145</sys_value>
    <dia_value>94</dia_value>
    <mean_value>111</mean_value>
    </vitals>
    <vitals>
    <type>bp</type>
    <date>04/14/2003</date>
    <time>13:45:00</time>
    <sys_value>150</sys_value>
    <dia_value>89</dia_value>
    <mean_value>109</mean_value>
    </vitals>
    <vitals>
    <type>hr</type>
    <date>04/14/2003</date>
    <time>13:15:00</time>
    <value>63</value>
    </vitals>
    <vitals>
    <type>hr</type>
    <date>04/14/2003</date>
    <time>13:30:00</time>
    <value>77</value>
    </vitals>
    <vitals>
    <type>hr</type>
    <date>04/14/2003</date>
    <time>13:45:00</time>
    <value>78</value>
    </vitals>
    <vitals>
    <type>temp</type>
    <date>04/14/2003</date>
    <time>13:15:00</time>
    <c_value> 36.6</c_value>
    <f_value> 97.9</f_value>
    </vitals>

    <vitals>
    <type>o2</type>
    <date>04/14/2003</date>
    <time>13:15:00</time>
    <value>98</value>
    </vitals>
    <vitals>
    <type>resp</type>
    <date>04/14/2003</date>
    <time>13:15:00</time>
    <value>20</value>
    </vitals>
    </patient_info>
    <utility>
    <hours>12</hours>
    </utility>
    </VitalSignsComponent>

    Output:
    <table cellspacing="2" cellpadding="2" border="1">
    <tr>
    <td>&nbsp;</td>
    <td>04/14/2003 - 13:15:00</td>
    <td>04/14/2003 - 13:30:00</td>
    <td>04/14/2003 - 13:45:00</td>
    </tr>
    <tr>
    <td>BP</td>
    <td>157/99 118</td>
    <td>145/94 111</td>
    <td>150/89 109</td>
    </tr>
    <tr>
    <td>HR</td>
    <td>63</td>
    <td>77</td>
    <td>78</td>
    </tr>
    <tr>
    <td>RESP</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>20</td>
    </tr>
    <tr>
    <td>o2</td>
    <td>98</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    </tr>
    <tr>
    <td>Temp</td>
    <td>97.9f 36.6c</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    </tr>
    </table>

  2. #2
    Join Date
    Dec 2002
    Location
    Calgary, Canada
    Posts
    2,653
    solution to your question is time consuming,I think if you have partial question that will probably be answered sooner.People answer questions here volunteerily,creating complete solutions if its time consuming, might not be something people want to do.

    Cheers

    Khalid

  3. #3
    Join Date
    Apr 2003
    Posts
    3

    Unhappy

    Fair enough.

    If someone could point me in the right direction.....

    I need to create the above output based on the xml. Is the xml formatted in such a way that this is even possible? If it is how would you go about grouping by date/time? Create a choose or if loop and do what???? I'm not asking for anyone to do this work for me just some direction, any help is appreciated. Hopefully as I get more proficient at XSLT I'll be able to offer some help to others as well.

    THANKS

  4. #4
    Join Date
    Dec 2002
    Location
    Calgary, Canada
    Posts
    2,653
    ok here is the logic as I'd follow,forgive me my xsl/xslt skills are 3 yrs old..:-)

    First create the table headers with date+time values

    look into for-each loops in xsl for vitals element
    once that is done

    next is to create first item in vitals group which is bp
    then the other and so on
    table
    tr
    <xsl:for-each select = "//vitals">
    <td>
    <xsl:value-of select="date"/> - <xsl:value-of select="time"/>

    </td>
    /tr
    here you go again for each vitals and get the rest of the values

    hope this helps

    Cheers

    Khalid

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles