Loading data from a source

The program allows you to load data from various types of sources.

Data load settings

1. Open the data load settings.

   

2. Add a data source.

   

3. Select the source type and, if necessary, specify the source name.

   

4. Set up a connection to the source and set up data reading.

   

5. On the Data Fields tab, read the data fields from source 1 and make additional settings for data fields 2 if necessary.

   

   If necessary, remove unnecessary data fields and/or add additional data fields, which, for example, will be calculated.

   If the data field contains the number of labels to be printed, mark this with the corresponding checkbox.

   If the data field contains barcodes, mark this with the corresponding checkbox.

6. Optionally, customize the data processing that occurs after the data is read from the source.

   

7. Click OK.

If you have multiple data sources

On the Rules for multiple sources tab you can choose various data loading scenarios:

1. Load from all sources. All data sources will be loaded sequentially. The fields will be merged from all sources.
2. Load from a source that the user will choose. Before loading, a dialog box will appear with the source selection.
3. The first source is related to the rest. You will be able to choose how the first source will be linked and affect the rest of the sources.

   

   • Filter
   • Left join
   • Join
   • Right join
   More details below.

The first source is related to the rest

We will describe various scenarios with examples. Suppose you have two data sources:

1. The first data source contains barcodes and website links.

   

2. The second data source contains barcodes and item details.

   

Set up data load settings for each source, then connect the first source to the second one using the Barcode field.

Now, when loading data, the relationship between sources will be taken into account.

Filter

From the second source, only those records that have a barcode present in the first source (filter) will be loaded.

Left join

All data will be loaded from the first source. The loaded records will then be expanded with data from the second source if the barcodes match.

Join

All data will be loaded from the first source. The loaded records will then be expanded with data from the second source if the barcodes match. All records where the barcodes do not match will be deleted.

Right join

All data will be loaded from the second source. The loaded records will then be expanded with data from the first source if the barcodes match.