Datacenter User Guide

Version 2.2 | Published May 16, 2024 ©

File

This section provides the steps to configure a File dataset.

  1. Create a new dataset of type File, specifying a name and (optionally) a prefix to use to identify the dataset and its values, respectively:

    images/download/thumbnails/149915730/image-2024-1-24_16-0-45.png
  2. Click Add. The dataset is added to the list, and it has an initial WARNING status as it contains no source file yet.

    images/download/thumbnails/149915730/image-2023-8-15_16-7-54.png
  3. You can now select a source file from the table in the Dataset configuration panel, by double clicking one of its rows. The table lists all recently used files.

    images/download/attachments/149915730/image-2024-1-24_16-2-53.png


    Alternatively, you can type a file location in the input box at the top of the table and press the plus sign. The file is added to the dataset source, and included in the Files table for future reference.

    images/download/attachments/149915730/image-2024-1-24_16-4-4.png


    The input box supports autocomplete, listing the files in the folder alias that were setup while configuring the File provider in the Admin page.
    Datacenter supports the following file types:

    1. Text (These are key-value pairs, using the '=' or ':' char as separators. The separators can be mixed.)

    2. Ini-file

    3. JSON

    4. CSV (comma-separated)

TXT files accept two separators: '=' or ':', which can be mixed. White space added after the separator, is preserved in the value. White space added before the separator is stripped from the key.

Editing Recently Added Files

The table in the Dataset configuration panel lists all the recently added files. When adding a file, its values are set to default.

Follow these steps to edit those properties:

  1. Click on the file you want to edit, the corresponding row is highlighted in blue:

    images/download/attachments/149915730/image-2024-1-24_16-4-53.png
  2. Edit the properties listed, such as Name and Description.

    images/download/thumbnails/149915730/image-2024-1-24_16-5-20.png

Working with CSV Files

When adding a CSV file, Datacenter attempts to read the keys from the first column in the file, and the values from the second. T o change this behavior, click on the filename in the Dataset Configuration panel:

images/download/attachments/149915730/image-2024-1-22_17-42-35.png

Change the Keys Column or Values Column options in the Setup Panel.

images/download/attachments/149915730/image-2024-1-22_17-43-3.png

Filtering a Dataset

Values read from a file into a dataset, can be filtered via the Filtering tool. To do so, select the dataset card, click on the hamburger menu and then press the Filter button.

images/download/attachments/149915730/image-2023-8-15_16-17-46.png

A dialog visualizing the file's payload schema opens, where a user can filter the source data.
images/download/attachments/149915730/image-2023-8-15_16-20-24.png
Please refer to the Filtering and Manipulating the Dataset Entries page to learn how to enable, disable and edit the entries added.