After selecting the data file, you need to wait until the file is uploaded.

Icon

Please note, that default maximum file size to import is 20MB. BellaDati Unlimited or BellaDati On-Premise may have different file size limits. You can compress the file size when importing it in a ZIP archive (see below).

Importing from CSV

When you are importing from CSV, please continue directly to Import settings page.

Importing from Microsoft Excel

After uploading XLS/XLSX file you will be prompted to select the desired spreadsheet list.

Icon

List selection will not appear when your Excel spreadsheet contains only single list.

Importing from XML

In the XML importing guide, you will be prompted to select the row tag, which represents repeatable data sentence. The following example illustrates it on XML file containing employees:

New data set will not be created until the import process will have been successfully completed.

Importing From JSON

Icon

Importing from JSON is available since BellaDati 2.9

BellaDati also allows users to import data from JSON file. By using special transformation functions, it is possible to parse JSON arrays and objects.

In some cases, it might be necessary to change Array element to correctly parse the data into rows. This can be done in the import settings.

After choosing the Array element correctly, it is possible to use the function parseJSON() to load the JSON value into a variable and then access the values by using functions getString(), getInteger(), getDouble(), etc. to load the values. To access a nested object, users have to use function getJSONObject(). To access an array, function getJSONArray() is available.

Icon

If the Array element is nested into another object, use "," character to separate the Array path.

Examples

Let's have a JSON file with following structure:

To be able to get the values, users need to specify sales as Array element.

To get the category, add a new column as an attribute and use following code:

To get the total items, add a new column as an indicator and use following code:

To calculate the total price from all the item prices, use this formula:

Let's have this JSON:

To access value from the JSONArray, use this formula:

Let's have this JSON:

In this case, we need to set "data,data" as the Array element.

In order to get the value from the element name, we can use the following transformation script: