CbC Reporting Made Easy


A recent mandate from the OECD called on large, multinational companies to report financials annually for each country in which they do business to their local tax authority. The OECD specified that this detailed Country by Country (CbC) Report be filed in an XML document according to their reporting schema. But for tax departments that work largely in Excel or other accounting software, this presented a significant stumbling block – and companies found themselves scrambling to meet the requirements by the deadline.

What was needed is a way to automatically generate valid, properly formatted CbC XML reports based on existing data. Altova created the Country by Country Reporting Solution to do just that, either based on manually entered data or figures imported directly from Excel. Let’s take a look at how it works.

 

Read more…

Tags: , , , ,

Transitioning Data Mapping Projects from Development through Testing and Production


Data mapping projects often mirror software development efforts with distinct phases for design, testing, and deployment. This is especially true for ETL (Extract Transform Load) projects when repeated data mapping execution is required as new data becomes available, and the stakes increase higher with large data sets. The Altova MissionKit and Server Software products provide Global Resources to define configurations for each project phase and smoothly transition between them.

Let’s take a look at an example based on a MapForce data mapping from a source file to a database.

Read more…
Tags: , , , , ,

Accelerate Low Code App Development with MobileTogether 6.0


With the right tools, a low code approach to development doesn’t mean a sacrifice of functionality or sophistication of the end result. On the contrary, low code app development frameworks like MobileTogether make advanced programming functionality more accessible and faster to implement.

Whether you’re building apps for iOS, Android, Windows, the web – or all of the above – the latest release of MobileTogether adds a mix of features that elevate programming on the platform to the next level and give developers easy access to the latest mobile device trends.

Announcing MobileTogether 6.0
Read more…
Tags: , , , ,

How to Compare CSV Files or Compare a CSV File to a Database Table


CSV files are a quick and convenient way to record structured data in a generic format. Because CSV files are so easy to create, multiple similar versions of very large CSV files can quickly proliferate. Often it becomes necessary to compare CSV files to find the desired version. In an ETL (Extract Transform Load) scenario, a data analyst may want to compare a CSV file to a database table for validation or to update data.

DiffDog, the unique XML-aware diff / merge tool from Altova, supports CSV as a native file format for comparison and can compare and selectively merge data CSV to CSV, or between a CSV file and database table. Let’s look at an example.

Read more…
Tags: , , , ,

Tools for JSON Comments and JSON Lines


Altova XMLSpy and MapForce JSON tools have long supported JSON and JSON5 for editing and data mapping. As new JSON formats arise in response to real-world usage, the support in these tools is expanding.

This article will help explain the advantages of two newer formats –  JSON with Comments and JSON Lines – and show how to use them in XMLSpy and MapForce.

Tools for JSON Comments and JSON Lines
Read more…
Tags: , , , , , ,

Learn about XULE for XBRL


XBRL (eXtensible Business Reporting Language) is an open, XML-based standard for the electronic submission of business and financial data. Though XBRL specifies what data must be reported and provides a standardized way of doing so, companies and regulatory agencies need a way of ensuring data quality through business rule validation. XULE is one method that is growing in popularity.

Let’s take a look at what XULE is and how it works.

Read more…
Tags: , , , ,

Version 2020 Revolutionizes JSON Editing


We’re introducing several exciting new tools for JSON development in Altova Software Version 2020, but there’s much more too. Support for the XULE XBRL standard, comparing CSV against database content, and updated database support are just a few of the new features introduced across the product line.

Let’s take a look at the highlights.

Altova Software v2020 announcement
Read more…
Tags: , , , ,