120 likes | 388 Views
Excel ↔ XBRL mappers. Steering Committee, 2005-06-03. Why preparing own mapper tools?. The COREP taxonomies contain functionality that is new in XBRL and is being included in the specification, i. e. dimensions.
E N D
Excel ↔ XBRL mappers Steering Committee, 2005-06-03
Why preparing own mapper tools? • The COREP taxonomies contain functionality that is new in XBRL and is being included in the specification, i. e. dimensions. • Commercial tools that are able to create xbrl instance documents are being upgraded to support dimensions. Our tools are an example of how easy it is. • To test the COREP taxonomies tools are needed when creating XBRL instance documents on basis of the COREP templates.
Test case creation • coreptest.xlt file is used to fill in test data inside the COREP templates on basis of Excel tables. • Each user can prepare as many templates as he needs to build up a complete test case. • Data can be used for analyses without reference to a special bank or test unit, because the spreadsheet has an anonymous ID. • Fernando Wagener (NCB ES)
XBRL instance creation: Preparations • To enable the transformation of the Excel test file the formats and all additional sheets have to be removed by running a macro. • The file has to be saved on the hard drive. • The new created excel file can be uploaded to the mapper application.
XBRL instance creation: Architecture • Java based web: standard technology. • Uses only free available open source packages. • Application can be run on an open source web server called Apache Tomcat. • XBRL validation will be included in following phases. • The application can be freely used from all over Europe by the internet. • Katrin Schmehl (NCB DE)
XBRL instance creation: Web based Internet Coreptest.xls file XBRL instance document
XBRL instance creation: Application design Web Server (Apache Tomcat) http://<server>/corep/ Servlet JSP Taxonomies Hosted by a Supervisor
Retrieval from XBRL instance: Architecture • Web Based .NET application. Runs on Microsoft IIS • Can run in parallel on the same server with XBRL instance creator • XBRL validation is skipped • The application can be freely used from all over Europe by the internet. • Panagiotis Voulgaris (NCB GR)
XBRL instance creation: Web based Internet Excel file XBRL instance document
Retrieval from XBRL instance: Design Web Server (Microsoft IIS) http://<server>/corep-printout/ Upload XBRL file Identify Templates Use CP04 to convert to Excel Publish Excel file Hosted by a Supervisor
Next steps • Integration of a XBRL validator from a software Vendor for testing and presentation purposes • Connection to a database to store XBRL instance documents as a whole • Test to integrate a Vendor database mapping: All XBRL instance data to be stored into relational database tables
DEMO • short demo of the applications