Data Mapping NoSQL Databases


NoSQL databases are non-tabular databases that store data differently than traditional databases made up of relational tables. Two of the most popular NoSQL databases, MongoDB and Apache CouchDB, store data as collections of BSON (binary JSON) and JSON documents. These databases leverage flexible JSON schemas and scale easily with large amounts of data and high user loads.

Altova MapForce has long supported data mapping all popular relational databases and now also includes native support for data mapping NoSQL databases. MapForce includes functionality for inserting, extracting, filtering, and ordering NoSQL data. Let’s look at an example.

Read more…
Tags: , , ,

Learn About OIM for XBRL


XBRL – the eXtensible Business Reporting Language – is a global framework for exchanging business information. The standard, maintained by XBRL International, is based on XML and designed to offer a standards-based approach to communicating and exchanging financial information between business systems.

The current version of the standard was finalized in 2003 and since then has received widespread uptake and eventual mandates from numerous countries and regulatory agencies, including the United States SEC. Adoption of the standard is due to advantages that include enabling automation and cost savings, better quality of reported data, improved analysis, and better quality of information used for decision making.

Despite its benefits, the complexity of XBRL presents a sharp learning curve for accountants and other stakeholders not familiar with XML, leading to errors and increased consultancy costs. In addition, coinciding with the adoption of big data technologies, XBRL has been used to represent ever growing datasets, which can be resource intensive.

XBRL International has worked over the years to modernize and simplify the standard in response to those challenges, and the Open Information Model (OIM) is an exciting and innovative solution.

Accountants learning about OIM XBRL
Read more…
Tags: , , , , , ,

New Features in XML and JSON Grid Editors


XMLSpy is known for its graphical editing views, which make working with and editing XML and JSON more straightforward – and therefore increase developer productivity.

Both XML Grid and JSON Grid have received major updates in recent releases, and we’re committed to making these graphical views as feature-rich and effective as possible through continuous improvement. As such, we rely on and appreciate feature requests and developer feedback. The latest release of XMLSpy provides some great updates in response to this input.

XML and JSON software developer
Read more…
Tags: , , , , ,

NoSQL Database Support and More in Version 2022


Altova Software Version 2022 is now available, with exciting new support for mapping and converting NoSQL databases in MapForce, pure text report output in StyleVision, and Windows 11 across the product line. The release also adds support for the exciting new OIM standard from XBRL International.

Here’s a look at the highlights.

Read more…
Tags: , , , , , ,

Maintaining Low Code Apps


Low code software tools can speed mobile application development by freeing developers from routine coding tasks and encouraging focus on high level app requirements. However, some developers, project managers, and even entire enterprises remain wary of low code tools. These stakeholders are afraid testing and maintaining low-code apps will be more difficult and costly over time.

But not all low code or RMAD (Rapid Mobile App Development) tools are alike. A low code tool that is simply a user interface to a code generator and builds apps from a set of templates could be attractive to an inexperienced developer. When an issue arises, a highly skilled programmer might need to diagnose and modify the generated code for each mobile OS to create a solution.

MobileTogether is a cross-platform RMAD tool that works differently. MobileTogether uses a combination of drag-and-drop UI design, a powerful Action Tree visual language for event handling, and standardized functional programming for data selection and processing. MobileTogether includes a built-in Simulator window to instantly execute the app to test logic, view the UI as it will appear on a variety of iOS, Android, Windows, and other devices, and examine changes in workflow data during execution. MobileTogether also includes sophisticated automated testing features and a built-in debugger to test and debug apps with precision and examine app behavior directly in the design environment.

Let’s look at how some real-world app maintenance requirements are simplified in MobileTogether.

Read more…
Tags: , ,

Tools for JSON Comments and JSON Lines


Altova XMLSpy and MapForce JSON tools have long supported JSON and JSON5 for editing as well as data mapping and conversion. 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 Comments and JSON Lines – and show how to use them in XMLSpy and MapForce.

Tools for JSON Comments and JSON Lines
Read more…
Tags: , , , , , ,

XML to XSD: Generating a Schema from Multiple XML Instances


I was recently talking with one of our Support Engineers about common questions he receives from customers. One that comes up a lot is schema generation, specifically, “How can I generate an XSD from XML?” The answer, of course, is to use your favorite XML editor. XMLSpy will generate a valid XSD from a DTD, a relational database structure, a JSON Schema, and of course, an XML instance.

But what many customers are surprised to learn is that the XML editor will also create an XML Schema based on a group of related XML files – and this is a common requirement. Let’s take a look at how it works.

Read more…

Tags: , , ,

Mobile App Development: Follow Up on a User Story


My friend Casey used the Solar Tool mobile app created with Altova MobileTogether to track rooftop solar production for a full year now and reports some surprising results. We first wrote about Casey’s user story in the spring, when she anticipated higher solar power production as hours of sunlight increased. Casey expected the billing cycle that included June 21, the summer solstice, to be her best generation month. Her actual results were very different and worth investigating.

Read more…
Tags: , , ,

XPath & XQuery Tutorial for SQL Pros (Video)


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 that would serve as an XPath tutorial and XQuery 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.

Read more…

Tags: , , , , ,

A Great App for Cataloging Collections


If you’re a collector – and let’s face it, we all are – of anything from books to stamps to video games, you’ve got to check out the Altova MyCollections app.

This is a free app available for Android, iOS, and Windows, and you can actually install it on all three concurrently. I love using this to, for example, enter collection info on my Windows laptop and access it on the go on my phone. It’s easy to share your collections with friends or make them public, and you can even list your items for sale or rent.

Check out this quick demo video to see how it works.

The best way to see how MyCollections works is to try it out yourself. Download it from your favorite app store using the links below.

Download on the App Store
Download on Google Play
Download from the Microsoft Store

Tags: , , ,

How to Learn a New Programming Language this Summer


What better goal to set for your summer than learning a new programming language? Forget the “beach books” this summer and set your sights on diving into a new coding language – but which one should you pick?

As reported by EDC there are approximately 24 million professional software developers on Earth, and almost 700 notable programming languages (according to Wikipedia). I would wager a bet there is a staggeringly equal number of places online where you can learn one programming language or another. Whether you are already one of those 11 million coding experts or a newbie to programming, there is a plethora of information out there to sort though.

For the purposes for this blog post, we will certainly look at the world’s most-widely-used programming languages in 2021, but also at important languages for data manipulation and querying, so we’ll discuss: C and its derivatives (C++, C#, and Objective-C), Java, Python, R, JavaScript, Ruby, SQL, and XQuery.

Deciding where to start depends entirely on the kind of development scenarios you have in mind, so we’ve broken things down for you to make it easier. It doesn’t matter if you are a seasoned programmer looking to add a new language to your repertoire or a novice who doesn’t know the difference between C, C++, Objective-C, or C# yet. We have assembled a list of explanations to help you choose which language you may want to conquer next.

shutterstock_416174497_700py
Read more…
Tags: , , , ,

MobileTogether Adds In-App Purchasing


The latest release of MobileTogether introduces new tools for monetizing your apps and integrating them in new ways – making the platform even more flexible and useful for developers in firms of all types and sizes.

If you haven’t tried the MobileTogether framework for rapidly building enterprise apps and native apps for iOS, Android, Windows, and more, now is the time. Learn about all the new features below and try MobileTogether Designer for free.

Announcing new features in MobileTogether
Read more…
Tags: , , ,

Mobile App Development: A User Story


Ahh spring! Birds singing, flowers blooming, and the sun rises earlier and sets later. All that extra daylight gives solar power generation systems more hours to make electricity. As the summer solstice approaches, solar generation systems enter their most productive time of year.

Owners of rooftop solar systems can be passionate about tracking their productivity. The actor and comedian John Hodgman even moderated a disagreement over obsessive monitoring of solar production. My friend Kasey is also enthusiastic about solar power. Whenever I see Kasey, she reports her latest kilowatt-hours stats. Kasey’s home is in a warm, sunny climate where air conditioning is her biggest electricity demand. She installed solar panels on the roof of her house at the end of last June and her system raced to generate enough power during long summer days to offset her air conditioning.

After receiving the electric bill for August, Kasey called her solar installer to report success – her home’s electricity consumption for the month was zero. “I have to confess, I read my meters every single day to see how the system is doing,” Kasey told the installer.

“Everybody does it,” the installer replied. “Some users even tell me they check the meters three times a day!”

Kasey asked me if a mobile phone application built with MobileTogether might make a good reporting tool for her solar power system. “I could enter the meter readings into my phone,” she said. “I can do it every day when I take the dog out before breakfast.”

That’s how our mobile app development collaboration began. The result is the MobileTogether app we call Solar Power Tool.

Read more…
Tags: , , ,

API Data Mapping


Web service data integration with MapForce is a popular and proven strategy to capture timely information for analysis or generation of user-friendly reports. In an earlier post we demonstrated API data mapping in 5-day weather forecasts for busy cargo shipping ports by reading Web service data in JSON format and mapping to richly formatted Excel spreadsheets. The weather API we used  is hosted by OpenWeather, a provider of historical, current, and weather forecast data.

But integrating data from any API is not a set-it-and-forget-it task. When you build a solution based on external data, you have to react quickly when the data structure changes. Since our original integration project OpenWeather revised the data delivered by their API. The API now includes wind gust predictions in a JSON property separate from wind speed. Since wind gusts are suspected as a cause of the recent Suez Canal blockage the new data is very relevant to our application! Fortunately, both the MapForce data mapping and the Excel spreadsheet are easily revised to add new data.

Read more…
Tags: , , , ,

How to View Workflow Automation Reports on FlowForce Server


Altova FlowForce Server is a high-performance workflow engine for automating enterprise-level data processing, data integration, and ETL jobs.

FlowForce Server includes a helpful web interface for managing and monitoring all aspects of data processing jobs, including in-depth logging functionality and a complete visual dashboard. Let’s take a look at how you can take advantage of FlowForce charts and statistics to monitor the progress of FlowForce Server jobs, as well as performance of the server itself, in great detail.

Article about FlowForce Server
Read more…
Tags: , , , ,

Data Mapping with XSLT3 Math Functions


XSLT3 adds trigonometry and other advanced math functions, new formatting functions, functions to collect environment variables, and more, extending XSLT and XSLT2 XML transformation standards. Data analysts and other data professionals can apply XSLT3 functions to solve XML data mapping and integration challenges that require complex mathematical computations. Let’s look at some MapForce examples of data mapping with XSLT3 math functions using trigonometry and other complex math expressions.

Read more…
Tags: , , ,

The fastest way to replace expiring licenses on Altova LicenseServer


Have you ever struggled with replacing an expiring software license because production in your organization runs 24/7? Maybe your biggest fear is that the application will stop running?  Fear not – I will walk you through the replacement process so you can avoid any interruptions in service. 

Though using the Altova LicenseServer is straightforward, there are a couple of tricks and tips that will make your life easier. For this post, my goal is to walk you through the process of replacing an expiring license.  Be it a standalone or centralized license server, replacement is fast and easy.  And we will complete the replacement of the license without any downtime to the application(s) being served.

Read more…
Tags: ,

XML Grid Gets a Makeover


If you’ve worked with XML in XMLSpy you’ve likely utilized XML Grid View to get a graphical representation of your XML document’s structure. This visual representation of the document’s hierarchical structure makes it immediately easier to understand and edit the content.

In the latest version of the XML editor, XML Grid looks a little different – in fact, it’s been completely rebuilt from scratch to offer even more unique functionality for editing, querying, calculating, and sharing XML data.

Learn about XML Grid in XMLSpy
Read more…
Tags: , , , ,

Developing and Debugging User Functions in Mobile Apps


Recently I came across this note in a senior developer’s code review of a colleague’s work: “Slightly revised the user function to work correctly when languages other than English are used.” This was a surprising comment–the code is the code and it shouldn’t make a difference what language the developer or the end user speaks! A user function is simply an expression that may accept input parameters and returns a result.

Altova MobileTogether supports user functions in a cross-platform mobile development framework that combines drag-and-drop UI design and standardized functional programming for data selection and processing. Several MobileTogether demo applications are highly dependent on user functions and the MobileTogether Designer includes features that greatly assist creating and validating user functions.

Let’s take a look at user functions in mobile apps by examining one of these demo apps.

Read more…
Tags: , , ,

New XML Grid and More in v2021r2


In the latest release of Altova desktop developer tools and server software products, we’re introducing a completely rebuilt XML Grid View, support for XSLT3 for XML data mapping, statistics and charts for monitoring FlowForce Server, and much more. Let’s take a look at the highlights of Altova Software Version 2021 Release 2. 

New features in Altova v2021r2
Read more…
Tags: , , , , , ,

A General Counsel’s Take on Contract Management Tools


Contract management is an important issue for most businesses, large and small. Given the breadth of approaches and tools in use, deciding on a solution can be a daunting task.

My take is simple: we use the Altova ContractManager for all of our contracts. We modified some fields to accommodate tracking of deadlines for trademarks and patents and storing copyright registrations. If you have a deadline or need to store odd documents, ContractManager can be modified to meet your need. It is a great platform that is flexible and easy to use. Perhaps I am a little biased since, well, I am the General Counsel of Altova and helped during the product design – which is an interesting story in and of itself.

Contract management case study
Read more…
Tags: , , ,

Create Reports for CbC XML Schema 2.0


Companies filing Country by Country reports as mandated by OECD will need to ensure compliance with Version 2.0 of the CbC XML Schema by February 1, 2021.

To help companies prepare, the Altova Country By Country Reporting Solution now supports Version 2.0 of the schema, adding to prior support for Version 1.0.1. The latest version of the cloud-based app also provides support for additional country-specific validation rules.

New features in Altova Country by Country Reporting software
Read more…
Tags: , , ,

An Easy Way to Test HTTP Requests During Development


Web and web services developers often need to send HTTP requests – whether for testing APIs, testing REST and SOAP web services, or managing web sites.

XMLSpy makes it easy to send and receive HTTP requests directly in the XML and JSON editor during development with its HTTP Window and WADL/WSDL Import Wizard, a great time-saving tool for debugging web services.

Web servers - testing http requests
Read more…
Tags: , , , , , ,

Create Mobile Apps that Automatically Support Dark Theme


Android and Apple mobile devices support a display option called Dark Theme, which you can think of as  almost a negative image of the normal screen display. In Dark Theme white is black, black is white, and color intensity in general is adjusted. Dark Theme reduces power requirements, which can extend runtime for a battery charge, and can be easier to view in low light.

Altova MobileTogether includes features to let developers create mobile apps that automatically support Dark Theme by detecting the user setting when the app is launched.

Let’s look at an example:

Read more…
Tags: , , ,

New Features for Refining Your App UI


The latest release of Altova’s rapid application development (RAD) framework introduces several new features that make it easier to customize and refine the UI of your app, with new features for styling controls, flexible options for users, and new logging tools.

Let’s take a look at what’s new in MobileTogether 7.2.

New in MobileTogether
Read more…
Tags: , , , , ,

New JSON Editing Features


In Version 2020, Altova introduced an entirely new approach to JSON editing in XMLSpy called JSON Grid View. This visual JSON editor offers a graphical representation of the JSON document structure that is immediately easier to understand and work with than the corresponding JSON code in a text editor, especially for long, complex documents with multiple nested levels of arrays and objects.

With each release we improve upon the list of unique editing tools in JSON Grid. Let’s take a look at  some important updates announced in Version 2021, which was released in October of 2020.

New JSON editing tools
Read more…
Tags: , , ,

Data Mapping Binary Objects – Part 2


Binary objects – BLOBs — can be cumbersome to manage in databases. In an earlier post we described a MapForce data mapping to insert binary objects into a database with generated metadata to identify the BLOBs later. The companion challenge in data mapping binary objects is to extract binary data and save it in a comprehensible form faithful to the original.

Let’s look at how that’s done.

Read more…
Tags: , ,

Data Mapping Binary Objects


Binary objects are difficult to manage in databases. They are large, their content is not human readable, and they can contain bytes of data easily misinterpreted as control characters. Even the data type name for binary large objects – BLOB – reflects most database managers’ dislike of them. Before relational databases, the definition of a blob was “something undefined or amorphous.”

Altova MapForce, the award-winning, graphical data mapping tool for any-to-any conversion and integration, includes features for effortlessly data mapping binary objects to or from all popular relational databases. Data such as images, PDF files, video files, or any other binary data can be mapped. Let’s look at an example.

Read more…
Tags: ,

Finally – An Easy Way to Manage XBRL Taxonomies


XBRL – the eXtensible Business Language – makes use of taxonomies as a standards-based way to define the specific tags that are used for individual items of data (such as “net profit”) in a financial report, as well as their attributes and how they relate to other data points. As such, different taxonomies are created for different business reporting scenarios.

Over time a staggering number of different XBRL Taxonomies have been developed to reflect the local accounting practices in various countries. In addition, many specific industries, such as construction and insurance, have created their own specialized taxonomies.

Developers and financial pros working with XBRL software tools need a way to download and manage the XBRL Taxonomies they need for their specific projects. Altova has long provided free installers for these taxonomies and their various versions on our web site, but we’ve now made the process even more streamlined with the XBRL Taxonomy Manager.

Let’s take a look at how it works.

XBRL accountant
Read more…
Tags: ,

New tools for JSON, EDI, SWIFT, and XBRL in Version 2021


As standards-based technologies and their applications evolve, so does the functionality that users require from developer tools. In our latest release, we’ve added new ways to work with XBRL, JSON, EDI, and more that help Altova customers work faster and more efficiently.

Let’s take a look at some highlights from the Altova Software Version 2021 release.

Read more…
Tags: , , , , , , ,

Manage Your Contracts in the Cloud


Organizations of all types and sizes are faced with the challenge of storing and managing contracts in a paperless world. Locked file cabinets have been replaced by network storage folders that quickly become unorganized and don’t always provide the appropriate level of access control and security.

Customers have turned to digital contract management solutions and indeed there are many on the market. After our own search for a product that was easy to use, secure, and readily adapted to our business, we found that the field came up short. So we built our own.

Introducing Altova ContractManager – a secure, cloud-based contract management app that’s feature rich, highly-customizable, and affordable for firms of any size.  Let’s take a look at how Altova ContractManager checks all the boxes.

Altova ContractManager: a cloud-based contract management solution
Read more…
Tags: , ,

Altova Enters SaaS Market with New Cloud Apps


We are excited to announce a new SaaS subscription model for Altova legal, financial, and regulatory apps. The Altova Cloud offers a seamless experience for users to simply log in and start using one or more Altova apps, without the need to download or install any software.

Let’s take a look at some advantages of choosing Altova cloud apps and what makes the Altova Cloud different from other SaaS subscription models.

Introducing the Altova Cloud for SaaS
Read more…
Tags: , , , ,

XBRL Updates for COVID-19 Requirements


In response to measures related to the COVID-19 crisis, the European Banking Authority (EBA) has issued updated reporting and disclosure requirements. These are designed to accommodate, for instance, emergency legislation on pausing loan repayment schedules and the resulting impact on financial institutions.

As such, the corresponding local XBRL taxonomies for reporting to the EBA have been updated with these temporary changes.  Altova has published updated taxonomy installers that provide the most recent versions.

Updated taxonomies are included with any installation of the Altova EBA XBRL Add-in for Excel, and additional local taxonomies including BBK, BDP, NBB, and SRB are available on the product download page.

Additionally, the XBRL Taxonomies Installer for all other Altova products that provide XBRL functionality, including XMLSpy, MapForce, and StyleVision, has been likewise updated. 

Tags: , , , ,

Examine, Edit, and Validate .x3d Files


The .x3d file format is an ISO/IEC xml-based standard for representing 3d images. Also known as X3D, .x3d files originated as a way to represent 3D images for computer graphics. Over time applications grew from virtual reality (VRML), to CAD design, architectural rendering, 3D printing, medical and anatomical imaging, representation of molecular chemical structures, human animation, and more.

The Web3D Consortium maintains the X3D standard, with XML Schemas documented here. Current versions include definitions of more than 250 XML elements, over 100 simple types, 70 complex types, and more than 40 defined node groups.

It takes that much complexity to accurately describe anything from a precisely manufactured machine part to a richly textured virtual environment, especially considering lighting, texture, and point of view! XMLSpy, the world’s most popular tool for modeling, editing, transforming, and debugging XML and JSON related technologies, supports .x3d files. XMLSpy offers standards-based tools for anyone who may need to examine, exchange, consume, or validate .x3d files. Let’s look at some examples.

Read more…
Tags: , , , ,

Mobile App Debugging


MobileTogether is a tool for building highly complex, elegant, cross-platform solutions. Developers need mobile app debugging tools to troubleshoot during development and understand app behavior. The MobileTogether Designer offers full-featured debugging of app execution flow inside action trees and debugging of XPath/XQuery functions. These features are provided in two mobile app debugging views integrated into a single tool.

The Actions Debugger view allows developers to debug the Actions of a Control event or a Page event. This view is available when an Action that has been selected for debugging is encountered during processing. The XPath Debugger view opens the XPath/XQuery evaluator window for in-depth tracing and debugging of expressions.

Developers can set breakpoints at various locations and the app, then execute one step at a time, pausing in either view to allow examination of the complete execution environment.

Let’s see mobile app debugging in action:

Read more…
Tags: , , ,

Design Templates for Mobile Apps


In an earlier post we wrote about using software design templates for mobile apps to facilitate design reuse and make it easy to build efficient, flexible options for various app requirements. We described an example of a Control Template designed to present multiple levels of hierarchical data based on user selection at runtime.

Our example was built using MobileTogether, Altova’s RMAD (Rapid Mobile App Development) tool to help developers build cross-platform apps that deliver dynamic, sophisticated app performance that delights end users.

You can also build Control Templates for cross-platform mobile apps by combining multiple controls into a larger unit, like a complex sub-assembly built from individual parts. This creates design templates for mobile apps that can easily be dropped in anywhere, speeding development and ensuring consistency.

Read more…
Tags: , , ,

MobileTogether Adds a Full-Featured Debugger


MobileTogether is an easy to use, low-code app development framework that allows you to create sophisticated apps for all platforms from a single app design. Because MobileTogether is capable of building highly complex, elegant solutions, developers need the ability to troubleshoot during development to understand and debug app behavior.

In its latest release MobileTogether introduces a brand new, enterprise-grade debugger alongside other new features for defining controls, actions, and UI refinements.

New for low code app development
Read more…
Tags: , , ,

Programming Techniques for Mobile Development


MobileTogether is an easy to use, low-code app development framework that lets you create sophisticated apps for all platforms from a single design.

Low-code doesn’t mean no code. A database specialist might start with a few SQL queries and use the MobileTogether drag and drop interface to create an app with elegant tables and graphs to report up-to-the-minute enterprise data, while experienced developers often use familiar programming techniques in mobile development to build highly complex, elegant MobileTogether solutions.

Developers define user functions, parameters, variables, loops, or a complex data structure when that’s the right tool for the job. MobileTogether makes it fast and easy to control all the features in the device – camera, microphone, GPS, SMS, handwriting capture, and more. MobileTogether helps you achieve your vision fast and build really cool mobile apps with charisma enough to go viral.

MobileTogether is about getting the work done efficiently, not limiting how you do it. Let’s check out a couple examples of programming techniques in MobileTogether apps.

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

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

New Tools to Work with XBRL in Excel


With the importance of accurate, standardized financial reporting enforced through XBRL filing mandates, having XBRL tools you can rely on is a must. What’s more, financial professionals need to be able to generate XBRL reports easily without getting bogged down by the complexities of XBRL syntax.

Altova offers several add-ins for Excel that make it easy for organizations to comply with regulations from the EBA, EIOPA, and other regulatory bodies that mandate reporting in XBRL. These easy-to-use software products integrate directly into Excel so that users can create valid XBRL reports in an environment where they’re already comfortable working. And, the add-ins support importing existing XBRL reports to Excel for easy readability and analysis.

The latest release of the Altova XBRL Add-ins for Excel provides some important new features – let’s take a look.

New tools to work with XBRL data in Excel
Read more…
Tags: , , , ,

New Data Integration Tools


Altova MissionKit tools offer numerous ways to connect to, query, and integrate data from disparate sources. With multiple product releases each year, we’re constantly working to deliver increased power and efficiency for data integration, while adding features requested by customers. This includes ongoing updates to built-in support for all major SQL databases across the product line.

Let’s take a look at some of the recently added tools and enhancements.

New data integration tools in Altova's release
Read more…
Tags: , , , , , , ,

How to Convert Legacy Text Files [Video]


It’s a common requirement to convert non-standard or legacy text files to or from structured data formats like XML, JSON, and relational databases. However, many times legacy text files are not in a format that can be readily processed by data mapping tools, especially when they have a complex and unique structure that does not consistently fit into CSV or fixed-length field patterns. Moreover, sometimes you need to extract only portions of useful data from a legacy text file.

MapForce, Altova’s any-to-any data conversion tool, includes a unique utility called FlexText that makes it easy to visually define templates for parsing text files and making them accessible to the data mapping tool.

See how FlexText works in our video tutorial.

The example files referenced in the video are available here and you can try FlexText with a free, 30-day trial of MapForce.

Tags: , ,

Data Mapping JSON Lines


The JSON data format continues to evolve as an open standard as it is creatively applied to new data interchange requirements. JSON Lines, defined at http://jsonlines.org/, is a convenient text format for storing structured data where each record is a single line and a valid JSON object. JSON Lines handles tabular data and clearly identifies data types without ambiguity. This allows records to be processed one at a time, which makes the format very useful for exporting and sending data.

Altova MapForce supports data mapping JSON Lines as either a data source or target. Let’s look at a mapping project to extract records from a database table and map to a JSON Lines file for output.

Read more…
Tags: , , , ,

How to Create Fillable PDF Forms


Compared to traditional paper forms, fillable PDF forms offer numerous benefits – aside from saving trees – including removing issues with legibility, allowing data validation, reducing re-keying errors, and streamlining information storage and re-use.

I, for one, really wish my kids’ school would switch to PDF forms for the myriad back-to-school information pages that we fill out in triplicate every fall. Perhaps I can give the administrators a demo of StyleVision, which just added support for fillable PDF form creation.

Unlike other PDF form design tools, however, StyleVision also provides form workflow functionality via integration with StyleVision Server for extracting and processing the data that end users enter. Let’s take a look at how it works.

PDF Forms

Read more…

Tags: , , ,

Software Design Templates in Mobile Development Projects


Software design templates streamline mobile app development by eliminating implementation of repetitive components. Creating a design template also simplifies revisions and upgrades when a change to the template can roll through an entire project.

MobileTogether supports software design templates for user controls in cross-platform mobile apps to facilitate design reuse and make it easy to build efficient, flexible options for various app requirements.

A Control Template in MobileTogether is a design component that allows developers to specify and group user controls in a way that makes them easily reusable. Control Templates support parameters, and each template can be customized based on parameter values at runtime.

Let’s look at an example.

Read more…
Tags: , , ,