I've got to write an app to allow someone to enter financial
information, which will then be stored in SQL and then produce an XBRL
compliant document.

I have the taxonomy from the company it has to be submitted to - but
what now? where do I start? I've not done a huge amount of work with
XML.

App will be written in C#.NET

Help Please!?

What exactly do you want?

A conceptual description?

1.) Provide a form with text boxes to user who will enter the data
2.) Understand where to insert that data into XBRL file(respecting that
company taxonomy off course)
3.) Complete the rest (proper format of the file and submitting procedure)

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

On 09/09/10 16:09, JemmimmaP wrote:

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.

///Peter

I would recommend a look at Altova's tools called XMLSpy and MapForce.
As you have your data already in the database you could use MapForce
to create a mapping into your taxonomy. You can also generate C# code
which will do the mapping. IIRC there should also be some samples
about MapForce and XBRL mappings.

HTH,
Stefan

Questions:

1.) Which tools (programming languages) have you used so far to
manipulate(create/save) XML document?
2.) How experienced you are with XML?
3.) At this stage, which is your primary concern - the "technical" validity
of XML document or the "logical" (data inserted on right positions)?