On 09/09/10 16:09, JemmimmaP wrote:
> haha, I guess I was vague ;)
> I can create the input app fine and saving the data to SQL no probs -
> I'm looking for a rough idea of getting info back out and placed into
> an XML file that will be validated against the taxonomy - are there
> any example out there or what's the best tools to use? I'm using
> VS2008, SQL2005
Your best bet is to use XQuery to select the data and output it in some
temporary XML format, and then pass that through an XSLT script to
generate the XBRL document.
Ideally the data would be gathered using XForms and stored in a native
XML system to start with, rather than using a relational database; then
the process would be XML from end to end, which is always much easier to
deal with. But a lot of organisations are still stuck with SQL systems,
so you have to take a hybrid approach.
If you need to generate XML, the best approach is to use XML-compliant
tools rather than trying to coerce non-XML tools into doing it.