Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Creating an XBRL compliant document

21 views
Skip to first unread message

JemmimmaP

unread,
Sep 9, 2010, 6:40:41 AM9/9/10
to
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!?

Kutle Boy

unread,
Sep 9, 2010, 7:31:33 AM9/9/10
to


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)


JemmimmaP

unread,
Sep 9, 2010, 11:09:21 AM9/9/10
to
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

Peter Flynn

unread,
Sep 10, 2010, 1:06:39 PM9/10/10
to

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

StefanM

unread,
Sep 13, 2010, 2:53:42 AM9/13/10
to
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

Kutle Boy

unread,
Sep 13, 2010, 4:06:20 AM9/13/10
to


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)?


0 new messages