Excel data source driver - Revision history

Ihr: /* Configuration file */

2009-09-06T22:10:59Z

Configuration file

← Older revision		Revision as of 22:10, 6 September 2009
Line 47:		Line 47:
	The '''cell''' element content is a cell reference inside the Excel book. It may have two different formats:		The '''cell''' element content is a cell reference inside the Excel book. It may have two different formats:
	* explicit address to a specific cell using ''sheetname''!''Reference'' where ''Reference'' takes the form for a colum letter followed by the row number, or		* 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.		* relative address to a specific cell using ''sheetname''!''cellname'' where ''cellname'' is an existing named range in the excel file. The named range must point to just one cell.

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

Ihr: /* Configuration file */

2009-09-06T22:10:15Z

Configuration file

← Older revision		Revision as of 22:10, 6 September 2009
Line 45:		Line 45:
	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.		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.

	The '''cell''' element content is a cell reference inside the Excel book. It may have two different formats: 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.		The '''cell''' element content is a cell reference inside the Excel book. It may have two different formats:
			* 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]]		[[Main Page]] \| [[XBRLmapper]]

Ihr: /* Editors */

2009-09-06T22:00:43Z

Editors

← Older revision		Revision as of 22:00, 6 September 2009
Line 5:		Line 5:
	==Editors==		==Editors==

	The installation of Reporting Standard Mapper already ~~install~~ 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.		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.

	==Configuration file==		==Configuration file==

Ihr at 19:29, 6 September 2009

2009-09-06T19:29:30Z

← Older revision		Revision as of 19:29, 6 September 2009
Line 2:		Line 2:

	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.		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.

			==Editors==

			The installation of Reporting Standard Mapper already install 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.

	==Configuration file==		==Configuration file==

Ihr: Created page with '==Description== The Excel Data Source Driver is a configurable generic driver to obtain data from excel files and create XBRL reports inside the automatization framework provide…'

2009-09-06T17:09:10Z

Created page with '==Description== The Excel Data Source Driver is a configurable generic driver to obtain data from excel files and create XBRL reports inside the automatization framework provide…'

New page

==Description==

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.

==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:
<syntaxhighlight lang="xml">

<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 '''mapId''' element content is a string that corresponds to the mapIdentifier string of existing events [[XBRL Template File#Events]] in the instance document template.

The '''cell''' element content is a cell reference inside the Excel book. It may have two different formats: 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==
[[Main Page]] | [[XBRLmapper]]