Data import

The program allows you to import data from various types of sources so that you can display this data on your labels when printing. This allows you to print labels with dynamic data that is different for each label you print. For example, with different product names, prices, etc.

Supports import from multiple sources.

Data import settings

1. Open the data import 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.

Example of setting up data import from Excel file

In this example, we will use the example file from the program delivery. The first line of the file is the column names. The contents of your file may be different, such as having no column names or having different column names.

1. Click the Data Import Settings button.

   

2. Select Add new settings. If this window does not appear, skip this step.

   

3. Go to the Connection tab and select your Excel file.

   

4. Go to the Reading tab and specify the row number of your table, which contains the column names. In our case, this is the first line.

   If your table does not contain column names, then set this line number to 0.

   

5. Go to the Data fields tab and click Read data fields from source.

   

   The column names will appear in the list.

   

   If you do not want to import some columns, you can remove them from this list.

   

6. Test the import by clicking on Test Import.

   

7. Click OK.

Import from multiple data sources

On the Rules for multiple sources tab you can select different data import scenarios:

1. Import from all sources. All data sources will be imported sequentially. The fields will be merged from all sources.
2. Import from a source that the user will choose. Before importing, 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 import settings for each source, then connect the first source to the second one using the Barcode field.

Now, when importing 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 imported.

Left join

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

Join

All data will be imported from the first source. The imported 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 imported from the second source. The imported records will then be expanded with data from the first source if the barcodes match.