Monday, December 17, 2018

Liquid Studio 208 v16.1.19

Liquid Studio 2018 - 16.1.19
  • Fixed issue with XML Data Binder Wizard whitespace padding rules.
  • Fixed issue in Data Mapper with JSON node mapping.
  • General Fixes.
Download a Free Trial:
https://www.liquid-technologies.com/trial-download


Wednesday, November 21, 2018

Liquid Studio 208 v16.1.18

Liquid Studio 2018 - 16.1.18
  • Fixed Data Mapper SQL Writer issue for data types using Precision and Scale values.
  • Fixed Data Mapper issue for line endings in text writer.
  • General Fixes.
Download a Free Trial:
https://www.liquid-technologies.com/trial-download


Friday, November 16, 2018

Liquid Studio 208 v16.1.17

Liquid Studio 2018 - 16.1.17
  • Fixed Data Mapper SQL Writer issue with Decimal values in Microsoft SQL Server.
  • Fixed issues with accessing SVN and Git Source Control.
  • Added If...Then...Else Data Mapper Example to Getting Started project.
  • General Fixes.
Download a Free Trial:
https://www.liquid-technologies.com/trial-download


Friday, October 05, 2018

Liquid Studio 2018 v16.1.16

Liquid Studio 2018 - 16.1.16
  • Fixed converting XSD to JSON Schema issues.
  • Fixed XML Data Binder issue with using legacy Text property option.
  • General Fixes.
Download a Free Trial:
https://www.liquid-technologies.com/trial-download


Thursday, September 27, 2018

Liquid Studio 2018 v16.1.15

Liquid Studio 2018 - 16.1.15
  • Fixed converting XSD to JSON Schema issues.
  • Fixed XML Data Binder issue with namspace attributes in primitive elements.
  • Updated Newtonsoft JSON parser to v11.0.2 and JSON Schema parser to v3.0.10.
  • General Fixes.
Download a Free Trial:
https://www.liquid-technologies.com/trial-download



Tuesday, September 18, 2018

Liquid Studio 2018 v16.1.14

Liquid Studio 2018 - 16.1.14
  • Fixed JSON Schema Editor 'The schema item is no longer associated with a parent schema or Schema Manager' issue.
  • Fixed XML Data Binder SampleApp relative path issue.
  • Fixed Data Mapper issue creating sub functions.
  • General Fixes.
Download a Free Trial:
https://www.liquid-technologies.com/trial-download



Tuesday, September 11, 2018

Liquid Studio 2018 v16.1.13.8656

Liquid Studio 2018 - 16.1.13.8656
  • Fixed issues with JSON Schema Editor drawing code.
  • General Fixes.
Download a Free Trial:
https://www.liquid-technologies.com/trial-download

Thursday, September 06, 2018

Liquid Studio 2018 v16.1.12.8633

Liquid Studio 2018 - 16.1.12.8633
  • Fixed issues connecting to MySQL 8.0 Databases with latest MySQL Connector/NET ADO.Net driver.
  • Fixed issues with Database connection dialog.
  • General Fixes.
Download a Free Trial:
https://www.liquid-technologies.com/trial-download

Friday, August 31, 2018

Liquid Studio 2018 v16.1.11.8608

Liquid Studio 2018 - 16.1.11.8608
  • Fixed issues from end user crash reports.
  • General Fixes.
Download a Free Trial:
https://www.liquid-technologies.com/trial-download

Tuesday, August 21, 2018

Free XML and JSON Community Resources

Monday, August 20, 2018

Liquid Studio 2018 v16.1.10.8592

Liquid Studio 2018 - 16.1.10.8592
  • Added option to set XPath Window Auto Execute limit.
  • Fixed high DPI monitor issues on Start Page.
  • Improved performance of XSD Intellisense for substitution groups.
  • General Fixes.
Download a Free Trial:
https://www.liquid-technologies.com/trial-download

Monday, August 13, 2018

Liquid Studio 2018 v16.1.9.8572

Liquid Studio 2018 - 16.1.9.8572

  • Fixed small toolbar icons on high DPI monitors issue.
  • Fixed XML Data Binder ToJson crash when using nested arrays.
  • Fixed Find/Replace in selection issues.
  • Added support for long paths (longer than 260 chars).
  • General Fixes.
Download a Free Trial:
https://www.liquid-technologies.com/trial-download

Thursday, August 09, 2018

Liquid Studio 2018 v16.1.8.8553

Liquid Studio 2018 - 16.1.8.8553

    • Added ReadFile component in Data Mapper to read whole file contents.
    • Fixed issue with XML Data Binder writing null in ToJson for empty elements.
    • Fixed issue when opeing files using DDE.
    • General Fixes
    Download a Free Trial:
    https://www.liquid-technologies.com/trial-download

    Friday, July 20, 2018

    Data Mapper - Connecting to and Configuring a Database Data Source

    This video shows you how to connect to and configure database data sources using Liquid Data Mapper.






    A free trial of the Liquid Data Mapper is available from:
    https://www.liquid-technologies.com/trial-download

    Friday, July 13, 2018

    Liquid Studio 2018 v16.1.7.8497

    Liquid Studio 2018 - 16.1.7.8497

    • Fixed issue with JSON Schema Draft 6 IDs.
    • Fixed issue with XQuery sometimes not displaying menu and toolbar for debugging.
    • General Fixes.

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

    Liquid Studio 2018 v16.1.6.8487

    Liquid Studio 2018 - 16.1.6.8487

    • Added XSLT 3.0 file type option
    • Fixed issue with embedded XSD not getting saved into WSDL
    • Fixed slow update when changing schemaLocation in XSD
    • Fixed issue running XSLT with initial template
    • General Fixes
    Download a Free Trial:
    https://www.liquid-technologies.com/trial-download

    Wednesday, May 23, 2018

    Data Mapper - Using Joins with Multiple Data Sources

    This video shows you how to create a transform to join data from multiple data sources using Liquid Data Mapper.






    A free trial of the Liquid Data Mapper is available from:
    https://www.liquid-technologies.com/trial-download

    Monday, May 14, 2018

    JSON Data Binding with Liquid XML 2018 – Update 1

    XML to JSON and JSON to XML the smart way


    Liquid XML Data Binder has helped developers work with XML for nearly 20 years. In more recent times passing data between heterogeneous systems, specifically backend to mobile devices, has become increasingly reliant on using JSON data structures.

    In order to facilitate this, we have introduced the FromJson and ToJson set of methods to the Liquid Runtime API which will serialize and deserialize JSON data to and from the generated data objects.

    Supported languages are C++, C#, Visual Basic .Net and Java.

    C# Example

        // create an instance of the class to load the XML file into
        Bookstore elm = new Bookstore();
                        
        // load the initial XML data from a file into the object
        elm.FromXmlFile(filename);
    
        // change the price of the first book to 10.99
        elm.BookCol[0].Price = 10.99;
        
        // extract the updated data into an XML string
        string strXml = elm.ToXml();
        Console.WriteLine($"The XML created\n{strXml}");
        
        // extract the updated data into a JSON string
        string strJson = elm.ToJson();
        Console.WriteLine($"The JSON created\n{strJson}");
    

    C++ Example

        // create an instance of the class to load the XML file into
        CBookstorePtr spElm = CBookstore::CreateInstance();
        
        // load the initial XML data from a file into the object
        spElm ->FromXmlFile(lpctFilename);
        
        // change the price of the first book to 10.99
        spElm->GetBookCol()->Item(0)->SetPrice(10.99);
    
        // extract the updated data into an XML string
        std::tstring strXml = spElm ->ToXml();
        _tprintf(_T("The XML created\n%s"), strXml.c_str());
        
        // extract the updated data into a JSON string
        std::tstring strJson = spElm ->ToJson();
        _tprintf(_T("The JSON created\n%s"), strJson.c_str());
    

    The XML created

        <bs:bookstore xmlns:bs="http://www.liquid-technologies.com/sample/bookstore">
                       xmlns:xs="http://www.w3.org/2001/XMLSchema-instance">
          <bs:book price="10.99" publicationdate="2008-10-20" ISBN="978-0747596837">
          <bs:title>The Graveyard Book</bs:title>
          <bs:author>
            <bs:first-name>Neil</bs:first-name>
            <bs:last-name>Gaiman</bs:last-name>
          </bs:author>
          <bs:genre>Horror</bs:genre>
          </bs:book>
    ... etc ...
        </bs:bookstore>
    

    The JSON created

      {
        "bs:bookstore": {
          "@xmlns:bs": "http://www.liquid-technologies.com/sample/bookstore",
          "@xmlns:xs": "http://www.w3.org/2001/XMLSchema-instance",
          "bs:book": [
            {
              "@price": 10.99,
              "@publicationdate": "2008-10-20",
              "@ISBN": "978-0747596837",
              "bs:title": "The Graveyard Book",
              "bs:author": {
                "bs:first-name": "Neil",
                "bs:last-name": "Gaiman"
              },
              "bs:genre": "Horror"
            },
    ... etc ...
          ]
        }
      }
    

     

    JSON to Object Roundtripping 

     

    Looking at the JSON document, by default, attributes are prefixed with '@', namespace attributes are written out '@xmlns:bs' and names contain the namespace prefix 'bs:'. This is to enable full roundtripping of JSON back into the data objects using ToJson and FromJson methods.

    If we want a vanilla JSON document, we can control the output using the SerializationContext.

     

    C# Example

        SerializationContext.Default.JsonContext.SupportRoundtrip = JsonContext.RoundTrip.None;
    

    C++ Example

        CSerializationContext::GetDefaultContext().GetJsonContext().SetSupportRoundtrip(JsonRoundTrip_None);
    

    Now when the code is executed, the JSON output is as follows

      {
        "bookstore": {
          "book": [
            {
              "price": 10.99,
              "publicationdate": "2008-10-20",
              "ISBN": "978-0747596837",
              "title": "The Graveyard Book",
              "author": {
                "first-name": "Neil",
                "last-name": "Gaiman"
              },
              "genre": "Horror"
            },
    ... etc ...
          ]
        }
      }
    


    Download a free trial of Liquid XML Data Binder today:
    https://www.liquid-technologies.com/trial-download


    Tuesday, May 08, 2018

    Liquid Studio 2018 - Update 1

    Liquid Studio 2018 - Update 1 (v16.1.0)

    We are pleased to announce Update 1 of Liquid Studio 2018, adding new features and enhancements as requested by our end users.
    • NEW JSON support in XML Data Binder for C++, .Net and Java using ToJson() and FromJson() API methods.
    • Improved XML Data Binder Errors to include XPath or JSONPath to error location.
    • Fixed issue for BinaryData created with empty data in Liquid C++ Runtime.
    • Database Views can now be used as data sources.
    • Data Mapper Database Reader and Database Writer components can now use the app.Config to get the connection string.
    • Data Mapper Join now retains connectors when changing source.
    • Data Mapper Text Reader component can skip specified number of lines before reading data.
    • Added Data Mapper DateAdd component.
    • Fixed path resolution issues in Data Mapper.
    • Fixed copy and paste issue in Data Mapper.
    • Includes rollup of all previous fixes. 
    This update is free for user with a current Upgrade Support Protection Plan (USPP).

    Try the new features with our free trial from:
    https://www.liquid-technologies.com/trial-download

    Thursday, March 08, 2018

    Liquid Studio 2018 v16.0.5.8184

    Liquid Studio 2018 - v16.0.5.8184

    • Added new Join component to Data Mapper for fast lookup between two data sources.
    • Updated License documentation.
    • Fixed required attributes in XSD to JSON Schema conversion.
    • Fixed license issue running on Remote Desktop.
    • Fixed issue in XSD drag and drop.
    • Fixed issue in XML Data Binder for inherited ComplexType Choice.
    • General Fixes.
    Download a Free Trial:
    https://www.liquid-technologies.com/trial-download

    Thursday, March 01, 2018

    New JSON Editor Edition, SQLite, Schematron and XSLT 3.0 in Liquid Studio 2018

    Press Release: Liquid Studio 2018 - now with advanced new features for JSON, XML, and Web Service Developers.

    Liquid Studio 2018LEEDS, UK, March 2, 2018 - Liquid Technologies Limited (https://www.liquid-technologies.com) have announced the new Liquid Studio 2018 product suite, with tools for JSON, XML and Web Service Developers, plus seamless integration into Microsoft Visual Studio. Liquid Studio 2018 introduces a new JSON Editor Edition containing all of the JSON specific editors, tools and resources, along with all of the great features of the free Community edition.

    “With the growing demand in the IT industry for JSON products, it made sense for us to provide a new low-cost new entry-level edition specifically for developers who require the Graphical JSON Schema editor and associated JSON tools,” said Simon Sprott, CTO of Liquid Technologies. “We have also included some great new features in 2018 requested by our growing user base, such as support for SQLite, Schematron and XSLT 3.0."

    New feature highlights include:
    • JSON Schema Draft 6 support
    • JSON Document Outline View
    • JSON Schema Library
    • JSON Schema Documentation Tool for HTML and PDF
    • Schematron Editor and Validation
    • XSLT 3.0 support
    • Git Source Control Integration support
    • .Net Standard and .Net Core support in the XML Data Binder (https://www.liquid-technologies.com/xml-data-binder)
    • SQLite Data Mapper support
    • Parameterized SQL for Data Mapper DB Sources

    Liquid Studio 2018 also provides a Large File Editor, XML Diff tool and Microsoft Visual Studio 2017 extensions for JSON Schema Editor, XML Schema Editor, WSDL Editor, XPath and Web Service Tools. A free trial download of the full product suite is also available (https://www.liquid-technologies.com/trial-download).

    For more information about all Liquid Technologies products, services and features, please visit our website: https://www.liquid-technologies.com.