Quick tip: How to use new Resco Inspections data storage options

storage_main

The Spring Update 2019 brought new data storage options for Resco Inspections, convenient especially when handling extensive questionnaires.

Why?

The data-driven architecture of questionnaires allows great flexibility, without the need to create metadata on the backend system. However, representing each question and answer as a record could be inefficient when handling questionnaires with hundreds or even thousands of questions.

That’s why – when creating or modifying a questionnaire – users can now choose to store answers in a single JavaScript Object Notation file (JSON). Or even in a compressed JSON file, further optimizing the use of available storage. Storing questionnaires as JSON files, enables users to save the entire questionnaire as a single file, which streamlines and speeds up the synchronization process.

JSON is a lightweight data-interchange format. It is easy to read for people and easy to parse and generate for machines. It is a text format that is language independent but uses conventions that are familiar to users of the C-family of programming languages – including C, C++, C#, Java, JavaScript, Python, and others.

How to change your questionnaire data storage preference

1. To select a data storage option for a particular questionnaire template, create a new or open an existing questionnaire in the Designer.

storage_options

2. In the Questionnaire panel on the right, you can then immediately choose from available storage options for the Answer Storage field – Records, JSON, Compressed JSON (the default setting is Records).

designer_optimizedstorage

And that’s it! Just don’t forget to Save and Activate your questionnaire when finished.

However, saving an entire questionnaire in a single file can make integrating with business intelligence and reporting tools more challenging. That’s why we’re already planning to introduce a so-called “hybrid” storage option in the upcoming Resco Inspections update. It will enable users to pick a storage option for each question individually. That way, you can have the parts of a questionnaire which are essential for BI stored as records, while others can be saved in a JSON file.

Curious what else is new in Resco Inspections? Then check out the detailed overview of the Spring Update 2019. And if you haven’t tried it yet, you can start your free 30-day trial straightaway, or contact us for a live demo.