XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Michael TouchardSubject: XBRL instance from XML data using XSLT
Author: Michael Touchard
Date: 10 Oct 2005 04:51 AM
Hi all,

I'm new on this forum.
I'm also new on XML/XSLT/XBRL technology, so sorry for that.

I've to create a XBRL instance document (matching an XRL Schema) from a simple XML file containing the data. It seems the only way to do that is to pass by a XSLT file.

Is somebody in the assembly could confirm that to me?
If it's correct, I'll be grateful if is somebody could send me very simple example.

Many thanks
Michael

Postnext
(Deleted User) Subject: XBRL instance from XML data using XSLT
Author: (Deleted User)
Date: 10 Oct 2005 10:46 AM
I can think of 3 ways to accomplish your task:

1) You can use XSLT
2) You can use XQuery
3) You can write program using C++/Java/C#...

You can find good XSLT tutorial with some examples at

www.w3schools.com/xsl/

or XQuery tutorial on the same site:

www.w3schools.com/xquery/

If you need specific XSLT or XQuery examples you can post your
source XML and target XBRL fragments here and I'll try to create
sample XSLT/XQuery for you.

Postnext
Michael TouchardSubject: XBRL instance from XML data using XSLT
Author: Michael Touchard
Date: 10 Oct 2005 11:06 AM
Thanks to you.

Here a simple example of XBRL.
- XML_instance.xml is the XML data file extracted from a DB
- ex.xsd is the xbrl schema
- instance.xml is the xbrl instance file supposed to be produced after the xml_instance.xml has passed in the XSLT file

I have received these file like that, I don't know if they are correct.

Thanks for your help

Michael


DocumentShortexample.rar

Postnext
(Deleted User) Subject: XBRL instance from XML data using XSLT
Author: (Deleted User)
Date: 10 Oct 2005 12:35 PM
This XSLT does not do everything, just illustrates some features.
BTW, I had to add <xml> as a root of XML_Instance.xml. Without it document is invalid.


<xbrl xmlns="http://www.xbrl.org/2003/instance" xmlns:link="http://www.xbrl.org/2003/linkbase" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ex="http://www.fsw.fujitsu.com/ex" xmlns:iso4217="http://www.xbrl.org/2003/iso4217">
<link:schemaRef xlink:type="simple" xlink:arcrole="http://www.w3.org/1999/xlink/properties/linkbase" xlink:href="ex.xsd"/>
<xsl:for-each select="xml/XBRL_SQL_output">
<ex:branch>
<ex:branchCode contextRef="ei_2005"><xsl:value-of select="Branch/branchCode"/></ex:branchCode>
<ex:location>
<ex:street contextRef="ei_2005"><xsl:value-of select="Branch/location/street"/></ex:street>
<ex:town contextRef="ei_2005"><xsl:value-of select="Branch/location/town"/></ex:town>
<ex:postalCode contextRef="ei_2005"><xsl:value-of select="Branch/location/postalCode"/></ex:postalCode>
</ex:location>
</ex:branch>
</xsl:for-each>
<ex:accountsReceivable decimals="0" contextRef="ei_2005" unitRef="euro">
<xsl:value-of select="sum(xml/XBRL_SQL_output/accountsReceivable)"/>
</ex:accountsReceivable>
</xbrl>
</xsl:template>
</xsl:stylesheet>

Postnext
(Deleted User) Subject: XBRL instance from XML data using XSLT
Author: (Deleted User)
Date: 10 Oct 2005 12:39 PM
Missed few lines, sorry :

<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ex="http://www.fsw.fujitsu.com/ex">

<xsl:template match="/">
<xbrl xmlns="http://www.xbrl.org/2003/instance" xmlns:link="http://www.xbrl.org/2003/linkbase" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ex="http://www.fsw.fujitsu.com/ex" xmlns:iso4217="http://www.xbrl.org/2003/iso4217">
<link:schemaRef xlink:type="simple" xlink:arcrole="http://www.w3.org/1999/xlink/properties/linkbase" xlink:href="ex.xsd"/>
<xsl:for-each select="xml/XBRL_SQL_output">
<ex:branch>
<ex:branchCode contextRef="ei_2005"><xsl:value-of select="Branch/branchCode"/></ex:branchCode>
<ex:location>
<ex:street contextRef="ei_2005"><xsl:value-of select="Branch/location/street"/></ex:street>
<ex:town contextRef="ei_2005"><xsl:value-of select="Branch/location/town"/></ex:town>
<ex:postalCode contextRef="ei_2005"><xsl:value-of select="Branch/location/postalCode"/></ex:postalCode>
</ex:location>
</ex:branch>
</xsl:for-each>
<ex:accountsReceivable decimals="0" contextRef="ei_2005" unitRef="euro">
<xsl:value-of select="sum(xml/XBRL_SQL_output/accountsReceivable)"/>
</ex:accountsReceivable>
</xbrl>
</xsl:template>
</xsl:stylesheet>

Posttop
void voidSubject: XBRL instance from XML data using XSLT
Author: void void
Date: 29 May 2009 12:40 AM
are you doing this using JAVA?

if so then which api you are using?


 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.