Altova Blog - Page 2 of 65 - News from Altova, including XMLSpy XML Editor, SQL, UML, Data Integration, and Mobile Tools

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.

Tools for JSON Comments and JSON Lines

October 23, 2019/in JSON, Tools comments, comments and json, comments and json lines, data, data integration, data mapping, json and json5, json lines, json tools, json with comments, line comments, lines, new json, single line, single line comments, source file, support for json, supported by mapforce, xmlspy, xmlspy and mapforce /by Erin Cavanaugh

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.

Learn about XULE for XBRL

October 16, 2019/in Servers, Software, XBRL data, data quality, output keyword, processor and validator, query, single query, single query mode, xbrl data, xbrl formula, xbrl report, xbrl reports, xmlspy, xule documents, xule editor, xule expressions, xule language, xule processor, xule processor and validator, xule syntax, xule window /by Erin Cavanaugh

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.

Tags: Raptor, XBRL, XBRL Formula, XMLSpy, XULE

Version 2020 Revolutionizes JSON Editing

October 9, 2019/in JSON, XBRL, XML data, data quality, database, database content, diffdog and diffdog, diffdog and diffdog server, json, json data, json document, json documents, json grid, json lines, json with comments, now supported by xmlspy, product line, support, supported by xmlspy, version 2020, visual studio 2019, xule /by Erin Cavanaugh

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.

Tags: compare data, JSON, JSON editor, v2020, XULE

Build Custom Maps in Mobile Apps

September 18, 2019/in Mobile, mobile development, MobileTogether, XQuery airport status app, android phone, build custom, build custom maps, build custom maps in mobile, cross-platform mobile, custom maps, custom maps in mobile, custom maps in mobile apps, entire list of markers, expression, list of locations, list of markers, map, maps in mobile, maps in mobile apps, mobile apps, mobiletogether, xquery expression, xquery expression window /by David McGahey

In an earlier post we described how to integrate maps into cross-platform mobile apps with each end-user device’s native map application. Our example app generated a map with pins locating major airports in the United States. Illustrations showed maps generated by the same app on an Android phone, an iPhone, and Windows desktop.

What if a list of locations to be mapped is not known in advance, but generated based on user activity at run-time? MobileTogether, the low-code cross-platform mobile development tool from Altova, also empowers developers to build custom maps in mobile apps on the fly based on a list of geolocations generated at run time.

XPath & XQuery Tutorial for SQL Pros (Video)

September 11, 2019/in SQL, XPath, XQuery app, data, found, languages, produce, queries, query, query languages, sample, sql, training, training library, video, xml, xml files, xmlspy, xpath, xpath and xquery, xpath xquery, xquery /by Ty Shuff

Prior to starting at Altova I had zero experience with both XPath and XQuery. The first task I was presented with was to train myself on both query languages as quickly as possible and produce a concise video tutorial. It was important to develop a thorough understanding of their features and capabilities because both languages are integral to app development in MobileTogether and querying data in XMLSpy. I started with a strong background in SQL, learning XPath and XQuery by building queries first in SQL, and then determining how to replicate them in both query languages.

UML Modeling for C++ with UModel

August 21, 2019/in Software, Tools business process, c code, c project, code, code generation, existing uml, model, modeling, new class, project, source code, uml, uml diagrams, uml for c, uml model, uml modeling, uml models, umodel, umodel includes, visual studio /by David McGahey

C++ is one of the most powerful and efficient programming languages available, the de facto choice for high-performance computing, server applications, and complex architectures that demand the most powerful language constructs. The Unified Modeling Language™ (UML®) is the standard to design, visualize, and document models of software systems implemented in C++ and other source code languages.

Altova UModel competes with even the most advanced UML modeling tools with complete code engineering support in UML modeling for C++. UModel includes: C++ code generation from UML diagrams, reverse engineering C++ code to generate UML models, and round-trip engineering to update revisions to either C++ code and UML models.

Model transformation even lets developers convert an existing UML model designed for Java, C#, or Visual Basic to support C++.

Tags: C#, software modeling, UML, UML tool, UModel