How to Compare XML and Other Files


The ability to diff and merge files is a necessity for every developer. This can be especially troublesome when trying to compare differences between files containing structured data, such as XML.

The video tutorial below provides an explanation on how to compare XML files – and more – using both XMLSpy and DiffDog. These powerful utilities perform diff and merge operations in an XML-aware manner, which reduces the number of false positives seen when comparing files.

Compare XML files with XMLSpy

Read more…

Tags: , , ,

5 Reasons to Choose a Graphical JSON Schema Editor


The advantages of JSON as a lightweight, interoperable data format have secured its place as a favored mechanism for serializing and transporting data on the web. However, most applications still benefit from or require validation of client-submitted data. Enter the JSON Schema spec, which lets you describe the structure of JSON data for a particular application, for both documentation and validation purposes.

Though JSON Schema code is by design human-readable, building a complex schema with nested and repeating sections in a text-only editor becomes time consuming and error-prone quickly. Let’s look at five ways a graphical editor is a must-have for JSON Schema development.

JSON Schema Editor in XMLSpy
Read more…
Tags: , , ,

XML Reports to Text


Creating business reports from data stored in XML and relational databases is a common requirement in most organizations. However, it’s often complicated by the need to have information available in both web formats and print-ready formats such as PDF. Altova StyleVision takes a unique approach to report creation by letting users design reports from XML, databases, and even XBRL in a visual way – and output them in multiple formats simultaneously.

Over the years, support has been added for output to HTML, RTF, Word, and PDF – and now, based on customer feedback and requests, StyleVision also supports direct output to text. Let’s take a look at how it works.

Report designer
Read more…
Tags: , , , ,

Data Mapping NoSQL Databases


NoSQL databases are non-tabular databases that store data differently than traditional databases made up of relational tables. Two of the most popular NoSQL databases, MongoDB and Apache CouchDB, store data as collections of BSON (binary JSON) and JSON documents. These databases leverage flexible JSON schemas and scale easily with large amounts of data and high user loads.

Altova MapForce has long supported data mapping all popular relational databases and now also includes native support for data mapping NoSQL databases. MapForce includes functionality for inserting, extracting, filtering, and ordering NoSQL data. Let’s look at an example.

Read more…
Tags: , , ,

Learn About OIM for XBRL


XBRL – the eXtensible Business Reporting Language – is a global framework for exchanging business information. The standard, maintained by XBRL International, is based on XML and designed to offer a standards-based approach to communicating and exchanging financial information between business systems.

The current version of the standard was finalized in 2003 and since then has received widespread uptake and eventual mandates from numerous countries and regulatory agencies, including the United States SEC. Adoption of the standard is due to advantages that include enabling automation and cost savings, better quality of reported data, improved analysis, and better quality of information used for decision making.

Despite its benefits, the complexity of XBRL presents a sharp learning curve for accountants and other stakeholders not familiar with XML, leading to errors and increased consultancy costs. In addition, coinciding with the adoption of big data technologies, XBRL has been used to represent ever growing datasets, which can be resource intensive.

XBRL International has worked over the years to modernize and simplify the standard in response to those challenges, and the Open Information Model (OIM) is an exciting and innovative solution.

Accountants learning about OIM XBRL
Read more…
Tags: , , , , , ,

New Features in XML and JSON Grid Editors


XMLSpy is known for its graphical editing views, which make working with and editing XML and JSON more straightforward – and therefore increase developer productivity.

Both XML Grid and JSON Grid have received major updates in recent releases, and we’re committed to making these graphical views as feature-rich and effective as possible through continuous improvement. As such, we rely on and appreciate feature requests and developer feedback. The latest release of XMLSpy provides some great updates in response to this input.

XML and JSON software developer
Read more…
Tags: , , , , ,

NoSQL Database Support and More in Version 2022


Altova Software Version 2022 is now available, with exciting new support for mapping and converting NoSQL databases in MapForce, pure text report output in StyleVision, and Windows 11 across the product line. The release also adds support for the exciting new OIM standard from XBRL International.

Here’s a look at the highlights.

Read more…
Tags: , , , , , ,