Tuesday, September 21, 2021

Liquid Studio 2021 - v19.0.11

 

Announcing Liquid Studio 2021 v19.0.11:

  • Added option to re-create Columns for Excel Reader and Excel Writer components in Data Mapper
  • Fixed issue with Join component in Data Mapper
  • Fixed issue with showing Excel Properties in Data Mapper
  • Fixed issue with ‘Write Column Names’ option in Excel Data Mapper
  • Fixed High DPI issues
  • Fixed issues in Find/Replace dialog
  • Fixed issues in JSON Intellisense
  • Fixed issues from user crash reports
  • General Fixes

Download a Free Trial:
https://www.liquid-technologies.com/trial-download

 

Friday, August 13, 2021

Creating Multiple Sample XML Documents from an Excel Spreadsheet with Liquid Data Mapper

We recently received a support ticket where the user wanted to generate a sample XML document for each row within an Excel spreadsheet.

This is easy to achieve using Liquid Data Mapper.

Here is our Spreadsheet data:

And here is a simple Data Mapping to create an XML document from the Excel data:

However, this will create a single XML document containing all rows from the Excel spreadsheet. In order to output multiple XML documents, i.e. one per row, we need to make a few simple changes:

  1. Right click on the Xml Writer and select 'Toggle Simple View' to show the Filename node.
  2. Connect the Excel Reader 'Row' node to the Xml Writer 'bookstore' node.
  3. Add a 'Concat' component and a 'Const' component.
  4. Set the type of the 'Const' to be a string and the value to be .xml.
  5. Connect the 'Title' node to the String 1 of the Concat.
  6. Connect the 'Const' to the String 2 of the Concat.
  7. Connect the Concat to the Filename node.

 

When we run the updated transform, we now see three XML documents are generated 'The Graveyard Book.xml', 'The Portable Door.xml' and 'XML Schemas.xml'. Each XML document contains the Row data specific to the book.

Further Reading

Please see the data mapper documentation for additional information about transforming Excel to XML in Liquid Data Mapper.

Download a Free Trial of Liquid Data Mapper:
https://www.liquid-technologies.com/trial-download