10 pts.
 Turning Report Output into XML
We have a report subroutine that most all programs PERFORM to write data to our electronic report distribution system. Looking for suggestions on how to define these reports so we can store them in some form of XML that would then maybe be applied against a style sheet perhaps? I'm still a novice when it comes to XML, XSLt, etc.

Software/Hardware used:
ASKED: May 21, 2007  7:42 PM
UPDATED: May 21, 2007  8:16 PM

Answer Wiki:
Here's a method that should work for XML and HTML. The concept is that you want to wrap your values in tags, wrap lines of those in tags, and wrap tables of those in tags. In the example below, underlines are really spaces, but used to keep this page's formatter in line. So, if the current output looks like this: Numbers__Fruits__Vegetables ______1__Orange__Tomato ______2__Apple___Brussel_sprouts ______3__Banana__Potato Then we can use HTML or XML to wrap things, using TD for table data, TR for table row, and TABLE for table: (One further item: The formatter won't allow me to show you real HTML. So, in the example below, [ means the Less-Than symbol, and ] means the Greater-Than symbol) [TABLE] [TR][TD>Numbers[/TD>][TD]Fruits]/TD][TD]Vegetables[/TD][/TR] [TR][TD]1[/TD][TD]Orange[/TD][TD]Tomato[/TD][/TR] [TR][TD]2[/TD][TD]Apple[/TD][TD]Brussel_sprouts[/TD][/TR] [TR][TD]3[/TD][TD]Banana[/TD][TD]Potato[/TD][/TR] [/TABLE] --- Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
Last Wiki Answer Submitted:  May 21, 2007  8:16 pm  by  SheldonLinker   15 pts.
All Answer Wiki Contributors:  SheldonLinker   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _