I have the unenviable task of taking a huge XML document and converting it into a client statement that is in HTML format.
In order to get off on the right footing, there are some questions I need to ask before taking the plunge. (I use VB6 as my development tool)
If I leave the XML file intact, am I :-
* Able to extract this information and "save" it into individual client files ?(It's no good to have other clients information in the same file).
* Is it a wasted step to extract and save this information into SQL SVR per client ?
* If I need to extract a particular clients information from the original XML file, how do I pass it a parameter like a client name or number ?
* Should I use XSL somewhere along the line ?
* If so, can I use XSL to create what would look like a printed client statement ?
Thanks for any light that can be shone on this ...
In order to get off on the right footing, there are some questions I need to ask before taking the plunge. (I use VB6 as my development tool)
If I leave the XML file intact, am I :-
* Able to extract this information and "save" it into individual client files ?(It's no good to have other clients information in the same file).
* Is it a wasted step to extract and save this information into SQL SVR per client ?
* If I need to extract a particular clients information from the original XML file, how do I pass it a parameter like a client name or number ?
* Should I use XSL somewhere along the line ?
* If so, can I use XSL to create what would look like a printed client statement ?
Thanks for any light that can be shone on this ...