Xphere Posted March 21, 2006 Share Posted March 21, 2006 First off Hi folks. I must say W3Schools has been very helpful so far.Here is my dilemma.I need to read a XML file, ReWrite the XML file into a friendlier format, and then display it in Internet Explorer. Thats what I HAVE to do.Why now? well because The program that outputs this XML file is horrible and will not allow me to change how it formats its XML. <Record><DateTime>Mar 17 2006 3:02:00:000PM</DateTime><PointName>VAV_2</PointName><PointValue>25</PointValue></Record>- <Record><DateTime>Mar 17 2006 3:03:00:000PM</DateTime><PointName>VAV_2</PointName><PointValue>25</PointValue></Record>- <Record><DateTime>Mar 17 2006 3:03:00:000PM</DateTime><PointName>VAV_3</PointName><PointValue>0</PointValue></Record>- <Record><DateTime>Mar 17 2006 3:03:00:000PM</DateTime><PointName>Furnace</PointName><PointValue>0</PointValue></Record>- <Record><DateTime>Mar 17 2006 3:03:00:000PM</DateTime><PointName>VAV_1</PointName><PointValue>100</PointValue></Record> So i have tons of records, but i want to format this into a table where all the point names are at the top all the times are on the left, and the values for that time are side by side, then the next time.ExampleDateTime | VAV1 | VAV2 | VAV3 | VAV4 |timevalue | Value | Value | Value | Value |timevalue | Value | Value | Value | Value |timevalue | Value | Value | Value | Value |So being that this needs to work in IE, do i use VBScript, or AJAX, or XSLT or a combination?I just need a pointer. Ive had this dumped on me last minute to learn how to do this by thursday so im a little stressed out and ive already read a lot of tutorials. but i need to at least know whats going to work and whats a waste of time.Someone please help me. Link to comment Share on other sites More sharing options...
Xphere Posted March 21, 2006 Author Share Posted March 21, 2006 Dont be affraid to reply Link to comment Share on other sites More sharing options...
Webworldx Posted March 21, 2006 Share Posted March 21, 2006 XSLT with Sablotron should be able to do it on any php host that's enabled it. Link to comment Share on other sites More sharing options...
Xphere Posted March 22, 2006 Author Share Posted March 22, 2006 Theres part of the problem. There is no actual server. I need to do this all with browser side scripting or some sort of macro, or vbs/vba or something. I can have a few files thats fine, but there is no server. Essentially i'll be handing IE the link to the file and ask it to open it. XSLT with Sablotron should be able to do it on any php host that's enabled it.<{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
Webworldx Posted March 22, 2006 Share Posted March 22, 2006 Eeep.. You're wanting to client side transform the XML file? So you've got file.xml, and you want IE to transform it without using an XSL file, or can you use that? If so.. why not just use the method shown in:http://www.w3schools.com/xml/xml_xsl.asp Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now