Jump to content

Needing Advice


Xphere
 Share

Recommended Posts

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

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.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...