XBRLizer Changelog

What's new in XBRLizer 2.8.5

Dec 16, 2014
  • New features:
  • The source code has been upgraded to work with Java 1.7
  • New tool released, XBRL Instance Express. Simplified report editor and validator. Only available through regulators.
  • New Render Hints Processor. This processor allows to get information about how the report views shall be rendered. This exclusive feature is very easy to use, just make a preset of the different views and export them as a generic link base for further use. Later on you can apply this rendering configuration to your reports by including this linkbase as part of the taxonomy. Just let the tools make the job of fitting the information in the screen following the preferences you stated.
  • Catalog can work now with zip files according with the Taxonomy Packages specification 1.0 PWD
  • Added new instructions (LINKEDLIST,PROPERTYSET,XBRLPACK,RENDHINTS,CALL,RETURN,...) to Taxonomy Builder, and some improvements have been done to previous instructions (REF,FORMULALINK,DIMLINK,..).
  • General changes:
  • Improvement in Graphic User Interface. New icons, resizeable columns, show colours in row headers in the dimensional view, cursor position in editable cells,..
  • General changes to improve usability in MAC environment.
  • Validation process doesn't trigger in automatic validation mode if no change is made in cell content.Also when validation is executing the GUI shows the progress bar.
  • Balloons messages system updated.
  • Minor bugs fixed in Catalog, Database tools and mapper..
  • Added missing sapnish translations

New in XBRLizer 2.8.4 (Dec 16, 2014)

  • New features:
  • Added initial support for the Table Linkbase 1.0 Specification (work in progress)
  • Mapping from Google sheets is now possible
  • New IXBRL processor according with iXBRL specification ans transformations registry version 2
  • Currency conversion and escalating format displaying for XBRL reports.
  • General changes:
  • Formula processor optimizations. Improved performance for taxonomies implementing complex formula with high demand of resources. Added implementation for the Custom Functions Specification 1.0, added support for new test cases in the 2011 conformance suite.
  • Improved Remote Catalog management. Users can now install or uninstall taxonomy packages from the remote catalog
  • Mapper improvement. Now is possible to map "nil" data from Excel to XBRL and generate templates with "nil" data mapping (needed for some SEC reports).
  • Javadoc documentation updated.
  • XBRL validation improvement, now XML warnings and errors are incorporated to the XBRLValidationReport
  • Updated POI version from 3.6 to 3.9 for a better Microsoft Office integration

New in XBRLizer 2.8.3 (Dec 16, 2014)

  • New features:
  • New specific 32 bits and 64 bits versions for Windows environments.
  • Improved "Exporting to Excel" procedure, now users can export just the current working view, a collection of them or the whole report. Every exported view can be previously customized, allowing the users rearrange the way that the final Excel datasheets will look.
  • Automatic generation of mapping templates. Now the tools will do the bindings between the concepts from the report and its it's matching cell in the generated Excel document.
  • Graphical user interface improvements. New features has been added: contextual help and tips via pop up messages and customizable report's colors in dimension's view mode
  • General changes:
  • Better memory usage configuration based on operating system and hardware.
  • Improved Remote Catalog management.

New in XBRLizer 2.8.2 (Oct 24, 2013)

  • The installer has been signed with a digital signature using SHA-1 instead of SHA-256. A Bug in Internet Explorer SmartScreen Filter makes the files signed with SHA-256 (which is more secure than SHA-1) not recognized as safer but quite the opposite. Hopefully Microsoft fixes this problem with Internet Explorer SmartScreen Filter.
  • We made a change in the input of numbers so that if you write 0.00 in the editor, in the XBRL report will be written the value 0.00 instead of the value 0. The reason for this change is that some taxonomies use "patterns" to validate numbers and require that the numbers have 2 decimals even when it comes to the same value.
  • In the API, you can now call DTSContainer.load(URI [ ]) more than once, formulas and resources are not compiled multiple times.
  • We have added support for some features of the PER document (Proposed Recommendation Edition) XBRL variables that made some formula linkbases created for this version did not work out in the 2009 version.

New in XBRLizer 2.8.1 (Oct 24, 2013)

  • Most of the applications contains deep changes in the user interface code.
  • Use the remote catalog and synchronize over Internet the local copies of existing taxonomies.
  • New features on the XBRL database model.
  • New, intuitive, view of XBRL reports content including dimensions and regular XBRL views.
  • New possibility to mix instant and duraction facts on the same view when this is needed.

New in XBRLizer 2.7.9 (Oct 24, 2013)

  • The Chilean SVS just published an updated version of the recently published taxonomy for the insurance sector. We have included that new taxonomy version in the taxonomy Catalog and removed the previous version.

New in XBRLizer 2.7.8 (Oct 24, 2013)

  • The Chilean SVS just published the final version of the taxonomy for the insurance sector. Now it is included in the Taxonomy Catalog to boost taxonomy loading process.
  • Added to the taxonomy catalog a fixed version of one schema from XBRL International with errors (for more information refer to the Formula Working Group at XBRL International).

New in XBRLizer 2.7.7 (Oct 24, 2013)

  • New features:
  • Ability to generate Illustrated Taxonomy in Excel (from any opened Taxonomy).
  • Taxonomy Builder now generates XBRL formulas directly from Excel sheet columns (simple assertions definition).
  • The EDGAR Filer Manual validation component for reporting to the US SEC in compliant with the EFM conformance suite.
  • Improved validation of tuples and generation of instances using tuples.
  • If the taxonomy has fixed enumeration fields, XBRLizer shows combo boxes to ease value selection.
  • New taxonomies in catalog Seguros Chile July 2012, IFRS 2012 IFRS Spanish labels of 2011 and 2011, Peru Taxonomy SMV.
  • for SEC reporting, Added the generation of XBRL taxonomies and reports encoded in US-ASCII.
  • General changes:
  • Accelerated the view of forms and dimensional view tables.

New in XBRLizer 2.7.6 (Oct 24, 2013)

  • New features:
  • Update in the Excel to XBRL Mapper tool.
  • Update in the EFM (EDGAR Filer Manual) validation engine and the UTR (Units type registry) processor.
  • The EDGAR Filer Manual validation component for reporting to the US SEC in compliant with the EFM conformance suite.
  • New JNDI Data Source driver to allow automatic generation of XBRL reports from application servers compatible with JNDI to describe database connections (Tested with WAS and Tomcat).
  • General changes:
  • Accelerated the view of forms and dimensional view tables.

New in XBRLizer 2.7.5 (Oct 24, 2013)

  • New features:
  • Updates in the taxonomy catalog and catalog features.
  • Updates in the mapping tools.
  • New Edgar Filer Manual validation component for reporting to the US SEC. 100% compliant with the EFM conformance suite.
  • General changes:
  • This new relase in the dimensional view of an instance dimensions not directly related with the selected primary item are not represented. In previous versions too many dimensions may cause an number of non reportable combinations to appear on the tables and more difficult representation of a table if the user does not know exactly how the table shall be represented. Now it is more intuitive.

New in XBRLizer 2.7.4 (Oct 24, 2013)

  • New features:
  • The XBRL report generation based on templates has been empowered with the following features: Creation of report sections; a report section is a variable part of a report that exist on the template and may or may not exist on the instance depending on a value evaluated dynamically. This allows for the mapping of notes to financial reports in the IFRS taxonomy that may or may not exist in the source excel file and the generation of the instance document will or will not contain that section, including the section files in the DTS. Creation of duplicate concept mappings; now, the same concept, for the same context can be mapped to multiple cells and documented as a duplicate dynamic set. The duplicate dynamic set is evaluated at mapping time and only the non duplicate elements are converted into facts in the XBRL report. Mapping of context sections like the scheme and identifier is not possible.
  • New taxonomies added to the taxonomy catalog. The new versions of the most commonly used taxonomies has been added to the taxonomy catalog. The taxonomy catalog now allows for more metadata specified in the ZIP file such as the official starting URL of the taxonomy files that previously was indicated in the XML configuration file.
  • Translation of the tool dialogs to Spanish. Now English and Spanish languages are available. The language selection is automatic depending on the selection in the windows control panel.
  • General changes:
  • The FORM view has been updated to include the capability to add columns dynamically based on typed dimensions and select values from explicit dimensions.

New in XBRLizer 2.7.3 (Oct 24, 2013)

  • All Microsoft Office add-ins (XBRL Mapper, Taxonomy editor for Excel, Functions to access to the XBRL Database) has been refactored for Office 2007 and Office 2010. if you want to make sure they are installed, check you met the Software Requirements before starting the installation process.
  • Formula processor: There is a new tool called FormulaTT for helping understanding how the formula processor works according with the Formula Specifications. Use this tool for debugging purposes of a single formula or assertion. •Generador de taxonomías. Ahora es una sola herramienta independiente y también se integra con el complemento de Excel.
  • Taxonomy Builder. Now it is a single, stand alone tool and it is also integrated with the Excel add-in.
  • Taxonomy Catalog. Added some new taxonomies around the world (China and India taxonomies are now included in the package automatically)
  • XBRLIzer: the form view now can be exported to Excel.
  • Mapper Processor: updated the methods to extract data from Excel. Now it is possible to specify a file name in an Excel cell and the content of that file will be extracted during the instance document generation process. This allows for reporting embedded files in XBRL reports directly from Excel and reporting of notes in HTML format.

New in XBRLizer 2.7.2 (Oct 24, 2013)

  • Bug fix: on single processor computers requesting a license may not work. Now that bug is fixed.
  • Formula processor: Updated according to the Polish taxonomy and the new interpretation of General Variables.
  • Taxonomy Builder, added instructions for generating formula linkbases. The documentation is still not available. Ask for information directly via email.
  • Taxonomy Catalog. Added some files to the catalog according to the latest changes on taxonomies.
  • XBRLIzer: added forms view (according with the Eurofiling solution for Forms and some improvements found by us).
  • Personal Validation: fixed a bug that allows the user to select independent validation modules. Now dependencies automatically selects required validation modules.
  • XBRLizer: now validates all it has licenses to validate according to installed validation modules.
  • Taxonomy Builder: is now extensible for new instructions in external .jar files.
  • XBRLizer: now allows for multidimensional views and drag and drop operations of dimensions over all axes.
  • XBRLizer: now remember the user defined configuration for each extended link role and the position of every dimension.
  • More than other 54 new small features added as responses to requests from our users.

New in XBRLizer 2.7.1 (May 8, 2011)

  • General changes:
  • Bug Fix: ExcelDataSource (Mapper Excel Driver) when a numeric value in Excel cannot be obtained the IllegalStateException is now captured and sent back to the application as a MapException.
  • Translations of some error messages of the Dimensions Validation for taxonomies.
  • Taxonomy Builder, added new instructions TYPEDDOMAIN and DPTABLE.
  • Taxonomy Catalog. Fixed a bug while adding taxonomies to the catalog from a ZIP file that does not contains a root folder.
  • DTSBuilder: added logic to detect if a domain member is already a hypercube or domain definition which is not valid and raise a warning if that happens.
  • Chilean Taxonomy CL-CI 2011 added to the catalog
  • IFRS 2011 Taxonomy added to the catalog
  • US-GAAP 2011 Taxonomy added to the catalog
  • XBRL API enhancement. The XBRL API now has a central class that stores all available configuration parameters for the XBRL Processor. That class may also store information for the external "custom" processors designed for special validation rules applicable to certain projects. The GUI of the Personal Validator tool and for XBRLizer now has access to all properties defined on all processors available. This allows users to select validation processors parameters for a big number of characteristics (not all of them are available form the GUI. Only those whose values can be represented as text).
  • DTSBuilder during the recognition of the lookup table when it is used during the DIMLINK instruction, the table of dimensions is now reported and warnings about non existing dimensions has been removed.
  • DTSBuilder new VALIDATE instruction in order to allow for XBRL validation (XBRL 2.1, Dimensions and Formula) of the produced files.
  • New updates to XBRLizer:
  • XBRLIzer and XBRLViewer GUI in the Dimensions view of the XBRL Report in order to allow dimension panes to scroll horizontally when space used by dimensions is bigger than the space available.
  • XBRLizer: added support of typed dimensions as domain members.
  • Fixed a bug while saving files to disk opened from an external URL or the database.
  • Enhancement. Show all resources in the DTS as long as the concepts are shown.
  • Enhancement. Show elements in the substitution group of other elements in the pop-up menu. Open a taxonomy, search for the xbrldt:dimensionItem and the xbrldt:hypercubeItem on the concepts list and right click on them.
  • Enhancement. new "Expand All" pop-up menu in presentation and calculation tree elements.
  • Enhancement. The taxonomy catalog is now stored in ZIP files rather than expanded files in a subdirectory. This makes Installation and un-installation faster.
  • Enhancement. Now is possible to see all facts in an XBRL Report even if the taxonomy contains no presentation or definition structures. Goto the Report pane and select "All facts in the instance document" on the View combo box.
  • Enhancement. Now is possible to see all concept and resources relationships graphically in a new panel called Board Click on the Board pane, then drag a concept or resource from the list on the left to the pane. Then right click on the element or resource and select "Show incoming relationships" or "Show outgoing relationships". If the concept has relationships defined. If only "Remove" menu option appears, then the concept has no relationships according to the filters on the bottom part of the Board pane.
  • Enhancement. Now, when opening a DTS; the progress bar keeps active until the GUI is completely updated.
  • Enhancement. Now the user can change the width of the data cells on the Report pane.
  • Bug fix. The taxonomy catalog did not work properly when adding taxonomies from ZIP files under some scenarios
  • Increased stability and solved minor bugs causing NullPointerExcecptions
  • Enhancement. Added a window to show the XML of concepts and resources.
  • New during the installation process:
  • There is now a new tool for completely remove the software from your computer in case the windows uninstaller fails.

New in XBRLizer 2.7.0 (Mar 2, 2011)

  • General changes:
  • Reporting Standard has incorporated an XBRL Formula processor to the set of available XBRL Processors.
  • There is a new button called "Community WIKI" on the user interface of all tools that drives the user to a specific web page where the user manual is and where people can discuss and share comments.
  • While creating XBRL reports from XBRL Report templates (mapping) the loading process of the XBRL Template has been extremely accelerated.
  • New updates to XBRLizer:
  • New taxonomies available in the XBRL Catalog. (The latest versions of FINREP (Solvency I and II of Banco de España), ACRA Taxonomy, EDINET Taxonomy US-GAAP 2011 taxonomy and much more...
  • Easy integration between the graphical tools and tools using the XBRL Database. Supported databases are (Oracle, SQLServer o PostgreSQL) All XBRL Reports can be stored and retrieved from XBRLizer and XBRLviewer, All data can be exported to Excel as functions.
  • New during the installation process:
  • There is now one specific installer for users of Office 2007. That installer installs all dependencies at once.

New in XBRLizer 2.6.11 (Oct 3, 2010)

  • General changes:
  • New way for requesting licenses directly from the tool
  • Updated saxonica library to release 9.2.1.2
  • Updated saxon9-jdom library from source code in order to implement new saxon9 interfaces
  • Added taxonomy cl-hb-2010-05-15 to the XBRL Catalog
  • Updated IKVM library to release 0.44.0.4
  • POI library updated to release 3.6 in order to support protected excel workbooks
  • Added digital signatures to the executables, DLLs and MSI installer
  • Taxonomy Catalog. Added Individual entry points to the wizard for Chilean cl-ci taxonomy
  • Added LicenseManager tool in order to facilitate users to request and install licenses
  • Added windows manifest to all executable files. No more questions on Vista and Windows 7 asking if the tool works well
  • XBRLIzer new features:
  • New DTS tab that allows access to all information about the XBRL Discoverable Taxonomy Set. (Shows all files and which file loads which other files)
  • New dialog to set/change the default unit for new facts
  • New dialog to change the Company Name (previously, the same dialog asking for company and date information was used)
  • Now links on errors and inconsistencies can find facts in the Dimensional view and in the Non Dimensional view (classical view) of the report
  • Now facts of date data type are represented as text, and edited as dates. The editor of dates is the same (when the element has the focus) But the representation of a date as a value (cell without the focus) is according to the date value.
  • The text "Click to set a value..." in an empty cell of the XBRL Report now don't wrap if there is no space in the cell for it.
  • The text string in some error messages is now more human readable and user friendly. It includes contextual information.
  • Added support for negated labels, the label in red color is shown in the presentation view and in the calculation view (previously was only in the instance view)
  • Fixed bug regarding performance and the number of rows represented in the non dimensional view (classical view) when the instance contains multiple (hundreds of) companies.
  • Added File > Open > Add DB in order to load files stored into the XBRL Database
  • Updated the Excel Functions to access to data stored in the XBRL Database
  • Bug fix: Tooltips for precision or decimals sometimes was not property updated.
  • Bug fix: When an instance document contains facts for multiple columns with same dimensions, fact items are ordered within every column in the same order.
  • Bug fix: The Columns window was showing duplicate columns when the combo-box for periods was used on top of that window. Now fixed.
  • Added a GUI option to let the user decide if the dates will have the time zone included or not. Default value is time zone will not be included.
  • While preparing the representation of the dimensions view. There is a new algorithm to decide if the row headers comes from a presentation linkbase or from a definition linkbase.
  • Changed the algorithm that decides about the order of dimension columns. The new algorithm put parent headers at the end.
  • Added a menu and Graphical user interface for using proxies.
  • Added an icon to show the filter regarding how instant data is matched within the column.
  • Added a "Duplicates" virtual dimension that appears when there are duplicate elements for a particular combination of dimensions
  • Exchanged icons for beginning of period and end of period to make them consistent with the new ordering of columns
  • Taxonomy Builder new features and changes:
  • Included more examples in the TaxonomyBuilder tool and renamed the directory to TaxonomyBuilder-samples
  • Added parameter 7 to the DIMLINK instruction of the Taxonomy Builder. This is an optional parameter pointing to a lookup table where there are pre-defined hypercube elements for dimension combinations. Read the documentation for more information.
  • Added a new instruction called CLEAR for clearing defined things in the DTS. This allows the user to define multiple DTSs in the same Excel sheet and avoid one DTS to load the other.
  • Taxonomy Builder now raises a warning if a prefix can be resolved to more than one taxonomy
  • Added new instructions INCLUDE, NAME2QNAME. Read the documentation for more information.
  • Changed the default value for "Nillable" and "Abstract" attributes to "null". now, if they are undefined, no attribute is created on the element definition in the taxonomy.
  • Implemented new instructions DPDIM, DPCONCEPTS, DPDOM for the definition of dimensional taxonomies according to the Data Points Structure. See the FINREP web site for more information about the Data Points Structure.
  • Changes and new Features in the XBRL API:
  • There is a new property defined in the DTSContainer class in order to set it to work as indicated in the new (still not approved) version of the XBRL 2.1 specification in regard to how the "precision" and "decimals" attributes on calculation networks must be used. This is not activated by default and it is EXPERIMENTAL because it is not approved by the XBRL consortium.
  • Added a flag to the XBRL Processor called DTSContainer.DTS_DISCOVERY_ON_DIFFERENT_FILE_NAMES to set if an error, warning or nothing will be sent to the user when a referenced file in the DTS has a name that is different from the real file name in the file system. Note this happens on Windows platforms that does not distinguish between file names in uppercase and lowercase while unix file systems does.
  • Updated the XBRL Library for not raising an error when a relationship in a generic linkbase points to an XML fragment inside a taxonomy that is not an Element definition and not a Resource inside an embedded linkbase.
  • Added properties to the DTSContainer in order to use internet proxies.
  • Added properties to the DTSContainer class in order to allow the XBRL Database to be used as source of XBRL Documents.
  • Formula Processor. Fixed a bug that raises a null pointer exception while reading formula linkbases created by the Bank of Spain not according to any test case defined in the Formula Conformance suite.

New in XBRLizer 2.6.10 (Jul 17, 2010)

  • Contains new version of the Excel Add In for mapping between Excel and XBRL