Hi All,
Can anyone tell me if the following scenario is possible -- and if so, how I might start to implement it? I am not sure of what terms to use even to describe what I want to do -- so Google is not really helping me much. I'll describe as best I can...
I have some data that fits well as a XML document. Being XML, I can develop tools to read this data, and ultimately to insert the data into a database. So far, so good.
However, I also need to interact with end users. I have already played with XSLT, and can transform my data either into a HTML web page, or into a .xslx spreadsheet, and probably a few other formats as well. However, what I really want to do is somehow give the end user the choice of what transform will actually be applied, and how the data will be presented.
I am working inside a corporate environment with moderately high security settings, which affect the ability to run MS macros etc. But it would be very good to be able to have the transform process take into account any settings saved into the local users home directory, and to process the data accordingly to either produce a nicely formatted web-page, or a spreadsheet, or to automatically import into a database.
Is this possible / feasible (even if we limit our options to a specific platform)? If so, what solution am I searching for?
Thanks
Phil