Excel data source driver and XBRL Database: Difference between pages

From XBRLWiki
(Difference between pages)
Jump to navigationJump to search
 
(Created page with '==Product page== http://www.reportingstandard.com/XBRL_Database.xhtml XBRL Database [[File:XBRLDBIcon.png|none|left|XhBtRmL template language to produce HTML representation…')
 
Line 1: Line 1:
==Description==
==Product page==


The Excel Data Source Driver is a configurable generic driver to obtain data from excel files and create XBRL reports inside the automatization framework provided by the XBRL Mapper engine designed by Reporting Standard.
[[http://www.reportingstandard.com/XBRL_Database.xhtml XBRL Database]]


==Editors==
[[File:XBRLDBIcon.png|none|left|XhBtRmL template language to produce HTML representation of XBRL reports]]


The installation of Reporting Standard Mapper already installs an Excel plug-in that is able to edit the configuration file described in the next section. Advanced users can take advantage of editing the XML configuration files manually or creating their own editing applications.
==Description==
 
==Configuration file==
 
The configuration file is provided during the driver declaration inside the instance document template file. See [[XBRL Template File#Definition_of_data_sources]] for more information. The driver class is '''com.ihr.xbrl.mapper.source.ExcelDataSource'''
 
Sample Excel driver data source declaration:
<syntaxhighlight lang="xml">
  <datasources>
    <source
      id="source0"
      class="com.ihr.xbrl.mapper.source.ExcelDataSource"
      config="Excel-driver-config.xml"/>
  </datasources>
</syntaxhighlight>
 
The configuration file must be valid according to a very simple XML Schema that has no namespace and that is published in the following official location <nowiki>http://www.reportingstandard.com/schemas/mapper/XBRLDataSourceExcelMapSchema.xsd</nowiki>


Sample configuration file:
The XBRL Database is a permament repository system implemented using relational databases and the most advanced technologies in order to allow the storage of document level information like XBRL reports, XBRL Taxonomies and XBRL Linkbases along with granular level information as XBRL Fact items, XBRL concept definitions, XBRL Labels, XBRL Resources, XBRL Relationships.
<syntaxhighlight lang="xml">
<!-- Sample configuration file for ExcelDataSource content -->
<XBRLDataSourceExcelMap
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:noNamespaceSchemaLocation
    ="http://www.reportingstandard.com/schemas/mapper/XBRLDataSourceExcelMapSchema.xsd">
  <map>
    <mapId>ifrs-gp_CostOfSales</mapId>
    <cell>CostsSheet!costofsales</cell>
  </map>
  <map>
    <mapId>ifrs-gp_Revenues</mapId>
    <cell>RevenuesSheet!D1</cell>
  </map>
</XBRLDataSourceExcelMap>
</syntaxhighlight>


The example above shows the content of the mapping configuration file. The root element is the '''XBRLDataSourceExcelMap''' element whose content is a set of '''map''' elements. In turn, a '''map''' element is a sequence of two other elements called '''mapId''' and '''cell'''.
* The storage system allows the storage of everything that is valid XBRL 2.1
* The storage repository accepts information for any existing or new XBRL 2.1 taxonomy
* The storage system allows users to develop complex cross instance document and cross taxonomy information systems


The '''mapId''' element content is a string that corresponds to the mapIdentifier string of existing events [[XBRL Template File#Events]] in the instance document template.
There is a live demo of the XBRL Database that store all the information published by the SEC here [[http://www.xbrl4.org/regulators/ExploreXBRL.html ExploreXBRL direct link]].


The '''cell''' element content is a cell reference inside the Excel book. It may have two different formats:
For more information about the XBRL Database please contact reporting standard directly by sending an email to info at reportingstandard.com
* explicit address to a specific cell using ''sheetname''!''Reference'' where ''Reference'' takes the form for a colum letter followed by the row number, or
* relative address to a specific cell using ''sheetname''!''cellname'' where ''cellname'' is an existing named range in the excel file.


==Navigation==
==Navigation==
[[Main Page]] | [[XBRLmapper]]

Revision as of 12:21, 8 October 2009

Product page

[XBRL Database]

XhBtRmL template language to produce HTML representation of XBRL reports

Description

The XBRL Database is a permament repository system implemented using relational databases and the most advanced technologies in order to allow the storage of document level information like XBRL reports, XBRL Taxonomies and XBRL Linkbases along with granular level information as XBRL Fact items, XBRL concept definitions, XBRL Labels, XBRL Resources, XBRL Relationships.

  • The storage system allows the storage of everything that is valid XBRL 2.1
  • The storage repository accepts information for any existing or new XBRL 2.1 taxonomy
  • The storage system allows users to develop complex cross instance document and cross taxonomy information systems

There is a live demo of the XBRL Database that store all the information published by the SEC here [ExploreXBRL direct link].

For more information about the XBRL Database please contact reporting standard directly by sending an email to info at reportingstandard.com

Navigation

Retrieved from "https://reportingstandard.com/wiki/index.php?title=Excel_data_source_driver&oldid=347"