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 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: , , , ,

Analyze JSON Data with Filters, Formulas, and Charts


Software developers and other data professionals often need to examine new data instances before designing processes for efficient production. As JSON becomes a more popular format for data exchange, the tradeoff for smaller data payloads can be loss of clarity of the underlying data structure.

XMLSpy has supported viewing, modeling, and editing JSON files since 2010 and includes rich tools to analyze JSON data, including applying filters, formulas, and charts.

Let’s take a look.

Read more…
Tags: , , , ,

InfoPath Alternatives from Altova


InfoPath, the popular business forms software from Microsoft, was sunset by the company starting in 2016. Without a direct replacement, customers have turned to InfoPath alternatives to facilitate forms creation and automated data collection.

Altova offers two alternatives that meet different customer implementation requirements. This article will walk you through some background information and help you decide which product to choose.

XML forms
Read more…
Tags: , , , , , ,

How to Debug XSLT and XQuery


Nothing’s more frustrating than getting unintended results from an XSLT or XQuery transformation and having to spend hours tracking down the issue – especially if you’ve inherited the project from another developer or haven’t looked at the code in a few months.  Of course, XMLSpy has long included an XSLT debugger and XQuery debugger for setting break points and stepping through transformations to identify problems.

For a more interactive debugging process, XMLSpy also includes XSLT/XQuery back-mapping.

With back-mapping enabled, you can simply click on or hover over the portion of your output document you want to zero in on, and XMLSpy will immediately highlight the source XML and XSLT or XQuery instruction that is responsible. Let’s see how it works.

Debug XSLT with back-mapping

Read more…

Tags: , , , ,

MapForce Data Mapping Tutorial (Video)


Altova MapForce is an any-to-any data transformation, conversion, and ETL tool for integrating data.

A graphical data mapping tool, MapForce has an intuitive drag-and-drop interface that lets you easily convert data between any two formats, such as XML, JSON, relational databases, NoSQL databases, EDI, and more. It also features an extensive library of conversion functions that can be chained together to form custom functions that can be reused throughout your projects.

Data translated by MapForce can be pulled to or pushed from a relational or NoSQL database and all data management products, and it can be adapted to customize in-house data management solutions.

The MapForce tutorial video below covers all major features offered by the data integration tool and shows example mappings between several different types of files.

You can try MapForce yourself with a free, 30-day trial.

Tags: , , , , , ,

Mobile App Themes Improve User Satisfaction


Mobile app themes improve user satisfaction by letting each user customize the app appearance with personal preferences. One way to implement multiple themes in apps that report and visualize data is to offer users a choice of color palettes for charts and graphs. MobileTogether uses a combination of drag-and-drop UI design, the powerful Action Tree visual programming language for event handling, and standardized functional programming for data selection and processing. Developers use MobileTogether every day to create elegant cross-platform apps with rich charts and graphs in all popular formats.

The main chart configuration settings let mobile app developers choose any of four built-in color palettes or even define a custom color palette for charts and graphs as they design an app. Combined with dark mode and light mode display settings, that creates ten colorful possibilities for display customization. Rather than impose a design-time color choice, developers can leverage MobileTogether features to let users choose for themselves. Let’s look at an example.

Read more…
Tags: , , ,