Validating Data Transformation

Software developers and other data professionals often need to transform data from one format to another. These transformations can be simple one-to-one conversions or may require more complex manipulation. For instance, relationships must be generated when importing flat CSV files into a database, or source data may need to be split for the target, as in full name vs. first, middle, last, and optional suffix. Validating data transformation is critical to prevent data loss or corruption.

In our recent post on Web service data integration combined a string value for GMT time with a numeric offset in seconds to generate the local time for weather forecasts. We created a user function that performed all the steps required to complete this operation. MapForce includes a powerful interactive data mapping debugger that can easily trace and validate this transformation. Let’s take a look at how it works.

Read more…
Tags: , , , ,

Get to Know Your Favorite XML Editor Again [Video]

For more than a decade XMLSpy has been a leading choice for all things XML. But over the years we’ve broadened the scope by adding hundreds of new features, supported standards, and innovative tools to make development faster and easier.

This new overview video offers a quick, high-level look at the various tools and options available, including functionality for JSON, XPath/XQuery, HTTP testing, debugging, back-mapping, and more.

Check out the XMLSpy demos page for more videos and in-depth tutorials on the JSON Grid Editor, XPath and XSLT for JSON, comparing XML files, and more.

Get access to all these features by upgrading to the latest version of XMLSpy or downloading a free, 30-day trial.

Tags: , , ,

Web Service Data Integration

In a previous post we wrote that every data integration and reporting task needs to start with a clear understanding of the source data. Using grid view in XMLSpy, the industry-leading XML and JSON editor, we analyzed JSON data for 5-day weather forecasts retrieved from a Web service.

Continuing with our earlier scenario, we’ll use MapForce, the award-winning, graphical data mapping tool for any-to-any conversion and integration, to map the forecasts for a series of major cargo shipping ports into nicely formatted Excel documents. We’ll want to highlight any predicted high winds or heavy rainfall that could cause delays by interfering with cranes loading and unloading containers, or slowing ships entering and exiting the harbors.

Read more…
Tags: , , , , ,

Analyze JSON Data with Filters, Formulas, and Charts in XMLSpy Grid View

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

Build Advanced XML Reports with New XPath Debugger

Altova StyleVision is a unique, easy-to-use tool for creating business reports using a drag-and-drop visual design interface. StyleVision lets you build reports for XML as well as database and XBRL sources. Each design you create can be automated for recurring reporting to HTML, PDF and Word, either using the auto-generated XSLT stylesheet or via StyleVision Server.

Integral to XSLT stylesheet design is XPath for selecting and calculating data, as well as defining styling rules, in your report. New features added to StyleVision include an XPath debugger that makes testing and perfecting your report easier than ever. Let’s see how it works.

Developer working from home
Read more…
Tags: , , , , , , ,

Excel Data Mapping to Update Existing Documents

Excel began life as a simple spreadsheet tool. Over time, support for rich text styling options, built-in charts, and copy and paste formatting features has led many enterprises to create reports in Excel documents. This can cause difficulty when data changes and existing documents need to be manually updated for distribution to a wide audience in the familiar report style.

Altova MapForce, the award-winning, graphical data mapping tool for any-to-any conversion and integration, supports Excel data mapping to convert data to existing Excel documents while preserving styles and formulas in the original.

This feature lets you write directly to nicely formatted Excel files to update data at runtime: any designated worksheets, rows, and cells from the specified file will be replaced with data from the mapping and all formatting in the existing file will be preserved as-is. To protect functionality in the existing spreadsheet, cells with formulas are not overwritten.

Let’s look at an example:

Financial pros using XBRL
Read more…
Tags: , , ,