Export exercise

[j.batzke]

Estimated duration: 1 hour

Introduction

Along with importing records, exporting data from the Novulo application is one of the most frequently used functionalities. The Novulo Export engine allows exporting in different formats and with advanced filtering and sorting. In this exercise, we will learn basic configurations for exporting records and perform a basic export.

What you are about to learn

• What is the export engine?
• What is an export definition?
• How to create an export definition?
• How to set a data table and its columns (fields) for an export definition?
• Best practices for export

Prerequisites

• You completed the expression exercise
• A personal training environment.

Contact your Novulo consultant if you do not have access to a personal training application for exercises yet. Most exercises only work in combination with a selected set of training data and not in any application.

---

Exercise

A) Create an export definition with the type XLSX and export all fields of the Countries table.
Resource: Novulo Export: how to export data

B) Add a new export definition to export all countries with the name ending with “k”. Also sort them alphabetically by ISO code (descending).
Resource: Expressions in Novulo

C) Reset the filter for the country’s dataset in the export definition. Only export two fields: The country ISO code and primary language ISO code. Which countries don’t have the primary language set in your export file?

D) Add a new Languages dataset to your export definition and set the Countries dataset as a parent. Add a filter expression to only show the language if it equals to the primary language of the parent country. Change the export type to XML or JSON and export.

E) Generate import definitions from your export definition. Check the import definition: how many fields have been added to it? Hint: make sure the export type is XML or XLSX.

Solutions

A)

Your exported table should look like this:

B)

The result should look like this:

You should use a filter expression to filter out all countries that end with “k” in the export dataset this.name.endswith(‘k’)
You should use a sorting expression on the export dataset to achieve the correct sorting: this.iso_code.desc

C)

Add all fields of the country’s dataset.
Remove all except for iso code and primary language.
Modify the “Match field to” property of the “primary language” field from GUID to ISO code:

Luxemburg does not have an iso code set:

D)

Filter expression for the languages dataset: this.equals(parent.primary_language)

E)

Set “Embedded import definitions” to “Custom”. Then click on “Generate importdefinitions”. 2 fields are added to the import definition. They are the same fields as in the export definition.