March 2020

New Tools to Work with XBRL in Excel

March 30, 2020/in Applications, Tools, XBRL /by Erin Cavanaugh

With the importance of accurate, standardized financial reporting enforced through XBRL filing mandates, having XBRL tools you can rely on is a must. What’s more, financial professionals need to be able to generate XBRL reports easily without getting bogged down by the complexities of XBRL syntax.

Altova offers several add-ins for Excel that make it easy for organizations to comply with regulations from the EBA, EIOPA, and other regulatory bodies that mandate reporting in XBRL. These easy-to-use software products integrate directly into Excel so that users can create valid XBRL reports in an environment where they’re already comfortable working. And, the add-ins support importing existing XBRL reports to Excel for easy readability and analysis.

The latest release of the Altova XBRL Add-ins for Excel provides some important new features – let’s take a look.

New tools to work with XBRL data in Excel

New Data Integration Tools

March 25, 2020/in Data Integration, Database, EDI /by Erin Cavanaugh

Altova MissionKit tools offer numerous ways to connect to, query, and integrate data from disparate sources. With multiple product releases each year, we’re constantly working to deliver increased power and efficiency for data integration, while adding features requested by customers. This includes ongoing updates to built-in support for all major SQL databases across the product line.

Let’s take a look at some of the recently added tools and enhancements.

New data integration tools in Altova's release

New Tools for XML and JSON Editing

March 13, 2020/in Development, JSON, XML /by Erin Cavanaugh

The latest release of XMLSpy adds several user-requested features for working with JSON and XML, as well as new functionality for debugging XPath, updated standards and database support, and more.

How to Convert Legacy Text Files [Video]

March 11, 2020/in Data Integration, Tools /by Erin Cavanaugh

It’s a common requirement to convert non-standard or legacy text files to or from structured data formats like XML, JSON, and relational databases. However, many times legacy text files are not in a format that can be readily processed by data mapping tools, especially when they have a complex and unique structure that does not consistently fit into CSV or fixed-length field patterns. Moreover, sometimes you need to extract only portions of useful data from a legacy text file.

MapForce, Altova’s any-to-any data conversion tool, includes a unique utility called FlexText that makes it easy to visually define templates for parsing text files and making them accessible to the data mapping tool.

See how FlexText works in our video tutorial.

The example files referenced in the video are available here and you can try FlexText with a free, 30-day trial of MapForce.

Tags: data mapping, FlexText, MapForce