How To

How to work with label templates and data common to all users from different computers?

You can use one of the options that will be described below:

Simultaneous work of many users from many computers.
Several users work in turn.

Simultaneous work of many users from many computers

This option is possible with a Corporate license.

Solution features:

Only one license is required and must be activated on the host computer (server).
All user computers must be on the local network along with the host computer or connect via Remote Desktop (RDP) to the host computer.

Deployment and configuration:

Install AzureLabel on the host computer (server) - it will have a shared database, including templates. This computer can also be a workplace at the same time.
Activate the Corporate license on it.
You can see how to do this in the Installing the program: Server section.
Install AzureLabel on the required number of working computers (licenses do not need to be activated on these computers) and configure the connection settings with the server computer.
You can see how to do this in the Installing the program: Client section.

For more information about the Corporate license, see the Multi-user (floating) license section.

Several users work in turn

This option is possible with licenses Free, Lite, Pro.

Solution features:

You need as many licenses as there are user computers.
Licenses must be activated on all users' computers: one license per computer.
Simultaneous operation of several users is not possible.

Option 1: The program database is located on a shared drive, such as Google Drive

Deployment and configuration:

Install AzureLabel on all user computers.
You can see how to do this in the Easy Install section.
Close any running AzureLabels on all users' computers.
Run the program on one of the computers and go to Menu > Tools > Backup database .
Select your shared drive as the location to save the database backup.
Close the program.
Navigate to your shared drive using Windows Explorer or another file manager.
Change the name of the previously saved file "db.fdb_backup_XXXXXXXX_XXXXXX_XXX.aldb" to "db.fdb".
Run the program one by one on each of the users' computers and do the following:
1. Go to Menu > Settings.
2. Go to the Database section.
3. Change the database path in the "Database" field to the path to the "db.fdb" file on your shared drive.
4. Activate the license allocated for this computer.
5. Close the program.

Working with the program:

One of the users starts the program, works with the program and closes the program.
The next user starts the program, works with the program, and closes the program.
And so on.

Deployment and configuration:

Install AzureLabel on all user computers.
You can see how to do this in the Easy Install section.
Close any running AzureLabels on all users' computers.
Run the program one by one on each of the users' computers and do the following:
1. Activate the license allocated for this computer.
2. Close the program.

Working with the program:

One of the users:
1. Starts the program.
2. Restores the database from a backup received from the previous user (if any):
  Go to Menu > Tools > Restore database from a backup and select the database backup file received from the previous user.
3. Works with the program.
4. Saves the program database as a backup:
  Go to Menu > Tools > Backup database .
5. Passes the saved database backup to the next user.
6. Closes the program.
The next user performs step 1, and so on.

How to print Amazon Transparency codes

You can print Transparency codes in two ways, namely through:

Import Transparency codes into the program and then print labels with imported codes.
How to do this will be described below.
Printing labels with Transparency codes, transferring data to the program directly from another system / program.
You can see how to do this in the Integration Guide.

The program remembers each printed Transparency code in the Printed Transparency codes catalog. A label already printed with a Transparency Code will not be printed or displayed in a preview, thus avoiding duplicate printing of Transparency codes.

Importing Transparency codes into the program

You must first request your Transparency codes from Amazon. These codes are delivered in a CSV file and are listed in the "Public_Code" column. You can get more information directly from Amazon.

Click Label Printing.
Clear the product list with the clear button.
Click Import.
Select Amazon Transparency codes data source.

If your Transparency codes are in a file of a different format, then you can use another data source, for example Spreadsheet (Excel, ODF etc) and, accordingly, import Transparency codes from Excel files.
Click the Read Data from Source button.
Go to the Import Data tab.
Make sure that the column with Transparency codes is bound to the data field Transparency code.

If not, click on the column header with the Transparency codes and select the Transparency code data field.
Click the Import Data button and close the import window.

After importing the Transparency codes into the program, you can print labels with the imported codes.

You can see more details about importing into the program in the Importing Data section.

Printing labels with Transparency codes

For printing ¹ Transparency codes, templates are supplied with the program:

Amazon Transparency 1.125" x 1.125"
Amazon Transparency 1.75" x 0.75"
Amazon Transparency UPC 1.375" x 1.375"

To print labels, do the following:

Select one of the above label template.
Click the Print or Preview button to print labels with Transparency codes.

Example of printed labels (test data):

You can change these templates for yourself in the Label Designer.

¹ For more details on how to print labels, see the Printing Labels section.

How to delete products from catalog?

Select products and folders that you want to delete and click Mark For Deletion.
The icons of these products and folders will change to those marked for deletion.
In the program menu, click Delete Marked Items.

How to display a link from the database in a QR code?

Suppose that you are importing links into the Parameter 1 column. Then you need to display the data from this column in a QR code.

At the time of inserting the QR code into the template

Go to the Data source for barcode tab and select data field Parameter 1.

In an existing QR code

Double click on the QR code
Select data field Parameter 1.
Click OK.
Save the template.

How to generate barcode?

You can do this in two ways.

In the product catalog

Select desired products or folders.
Click Actions with Selected Rows at the bottom of the window.
Go to the Add Barcodes tab.
Set the parameters for forming barcodes (type of barcode, prefix, on the basis of which the barcode will be formed).
Click Add barcode in selected products button.

In the template formula

Use function Barcode.

For example formula

[ProductCode] Barcode("EAN-13"; "23")

will generate an EAN-13 barcode with the prefix "23" based on the product code.

In this case, the barcode will be formed "on the fly" when printing labels or in print preview.

How to change the currency symbol in the label?

Open Label Designer, delete the old currency symbol and add the desired currency symbol with the Currency Symbol tool.

How to bind templates to products?

To bind a template to a product, select the product and set the desired template in the Template column.

If you need to bind a template to several products at once

Select desired products or folders.
Click Actions with Selected Rows at the bottom of the window.
Go to the Replace Values in column tab 1.
In the 2 field, select the Template column.
Select the required template in the 3 field
Click 4 button.

How to make sure that when adding a new product in the Country column the manufacturer I need is put?

Go to the Menu > Settings.
Go to the Catalogs section
Select Countries catalog.
Select desired country in the Default value field.

This country will be used by default for new products.

Similarly, you can specify default values for other catalogs.

How to sort products? How to sort products by several columns, for example, by article and color?

You can sort the list by any column, for example, by name, article number, etc.

To sort, click on the column heading.

To change the sort direction, click on the column heading again.

To sort by several columns, press the [Ctrl] key while clicking on the column heading.

How to make a discount or markup?

To make a markup or discount:

Open product catalog.
Click Actions with Selected Rows at the bottom of the window.
Go to the Edit Prices tab.
Select desired products.
Select the price to set in Target Price.
The price will be set in this way: the base price will be taken, a discount or markup will be applied to it, then rounding will be performed, of the price received.
Select the base price in Source Price, which serves as the basis for the discount or mark-up.
This can be a same price that Target Price, if you need to change a certain price by a number or percentage.
Select the source of the discount or markup: a number or value from the column of the product catalog.
If this is a number, then specify the desired one.
Positive number - markup, negative number - discount.
Choose the type of markup or discount: percentage or unit of currency.
Choose rounding.
Click Replace.

How to use image links in Google Drive to display images in labels?

Google Drive public links of this kind

https://drive.google.com/file/d/{Image ID}/view?usp=sharing

not suitable for direct image acquisition.

Such links must be converted to links of this kind

https://drive.google.com/thumbnail?id={Image ID}&sz=w{Image width in pixels}

You can do the conversion directly in the template. For this, it is necessary to add the function of replacing part of the string in the formula for obtaining a link to an image.

An example of a formula if the link to the image is obtained from the data field [ProductParam1] (column "Parameter 1") and the image width should be 1000px:

[ProductParam1] Replace("/file/d/"; "/thumbnail?id=" ; "T") Replace("/view?usp=sharing"; "&sz=w1000" ; "T")

How to add an element, such as a barcode, to a separate layer in a template?

There are 9 layers in the template. By default, all elements are added to layer 1. Before adding an element, you can change the current layer to another.

You can also change the layer of an existing element.

How to create your own label template?

Creating a label template is described in the Creating a label template section.

How do I transfer a label template or multiple templates to another computer?

To transfer one template

Go to Label Designer.
Select Actions > Save to file menu.
Choose a location to save the template.
Transfer the saved template to another computer.
On another computer, go to Label Designer.
Select Actions > Load from file menu.
Select a saved template.

To transfer multiple templates

Go to Label Designer.
Click on the button All templates.
Check the boxes for the templates or template folders you want.
Select Actions > Templates export menu.
Select the templates export method Keep folder structure.
Select a folder to save templates.
Transfer the folder with the saved templates to another computer.
On another computer, go to Label Designer.
Click on the button All templates.
Go to the root of the catalog.
Select Actions > Templates import menu.
Select the import method Import all templates from a folder.
Select a folder with saved templates.

How to work with GS1 data in a label template?

To work with GS1, you can use:

The function in the formula GetGS1ParsedData(<AI>), where <AI> is the AI by which the function returns the data of the element if an element with such AI was present in the GS1 string, otherwise the function returns an empty string.
The functions in a JavaScript getGS1ParsedData(<GS1 string>, <AI>), where <GS1 string> is the GS1 string that the function parses into separate elements, <AI> is the AI by which the function returns the data of the element if an element with such AI was present in the GS1 string, otherwise the function returns an empty string.
The functions in a Pascal script GetGS1ParsedData(<GS1 string>, <AI>), where <GS1 string> is the GS1 string that the function parses into separate elements, <AI> is the AI by which the function returns the data of the element if an element with such AI was present in the GS1 string, otherwise the function returns an empty string.

You can see all application identifiers (AI) that the GS1 string can store.

An example of a formula for working with GS1 data:

[Barcode] GetGS1ParsedData ("01")

The following happens in the formula:

The GS1 string is taken from the Barcode data field.
Using the GetGS1ParsedData function, a GTIN (AI=01) is obtained from the GS1 string and displayed on the label.

An example of a Pascal script for working with GS1 data:

var
    GS1Str, GTIN, Serial: string;
begin
    //getting GS1 string from Barcode data field
    GS1Str := GetFieldValue('Barcode');

    //getting GTIN (AI = 01)
    GTIN := GetGS1ParsedData(GS1Str, '01');

    //getting Serial (AI = 21)
    Serial := GetGS1ParsedData(GS1Str, '21');
    WriteLn('GTIN: ');

    //displaying GTIN
    WriteLn(GTIN);
    WriteLn('Serial: ');
    
    //displaying Serial
    WriteLn(Serial);
end.

In the Pascal script, the following happens:

The GS1 string is taken from the Barcode data field.
Using the GetGS1ParsedData function, GTIN, Serial strings are obtained from GS1 and displayed in the label.

How to import GTIN and other elements from the input GS1 string?

Suppose you have a file with products and each product has a corresponding GS1 string.

Consider two options for importing this file:

You want to import instead of the GS1 string a GTIN * element that should be selected from this string.
You want to import both the GS1 string and the GTIN * element that should be selected from this string.

* Or any other element or several elements

Implementing Option 1 (import GTIN only)

Suppose you want to import a GTIN element into the Parameter 2 data field.

Initial setting:

Open data source settings.
Go to the Data fields tab.
Select data field Parameter 2.
Go to the Settings of Import / Print from Source tab.
Click the button and set the formula to get the GTIN value (AI=01):

[ProductParam2] GetGS1ParsedData("01")

Before importing, bind the column containing the GS1 to the Parameter 2 data field:

After importing, the Parameter 2 data field will show the GTIN selected from the GS1 line. In this example, this is "04999123456789":

How it works? When importing from GS1 the string passed to the Parameter 2 data field, the GTIN is extracted using the formula and its value replaces the current value of the Parameter 2 data field.

Implementing Option 2 (import GS1 strings and GTIN)

Suppose you want to import a GS1 string into the Parameter 1 data field, and a GTIN element into the Parameter 2 data field.

Initial setting:

Open data source settings.
Go to the Data fields tab.
Select data field Parameter 2.
Go to the Settings of Import / Print from Source tab.
Click the button and set the formula to get the GTIN value (AI=01):

[ProductParam1] GetGS1ParsedData("01")

Before importing, bind the column containing the GS1 to the Parameter 1 data field:

After importing, the GS1 string will appear in the Parameter 1 data field, the GTIN selected from the GS1 row will appear in the Parameter 2 data field. In this example, this is "04999123456789":

How it works? When importing from GS1 the string passed in the Parameter 1 data field, GTIN is selected using the formula and its value falls into the Parameter 2 data field.

How to mark up the price when importing?

Suppose you have a file with products and each product has a price, but you want to import this price with a mark-up.

Initial setting:

Open data source settings.
Go to the Data fields tab.
Select data field Price.
Go to the Settings of Import / Print from Source tab.
Click the button and set the formula to get the price with a mark-up (in this example, 15%):

[ProductPrice] AddPercent(15;"+")

Before importing, bind the column containing the price to the Price data field:

After import, in the Price data field there will be a price with a margin of 15%. In this example, it is "115":

How it works? When importing, the price passed in the Price data field is charged by 15% using the formula and replaces the current value in the Price data field.

How to configure import to the product catalog on schedule?

Create and configure a task for import in the Tasks catalog.
Configure Windows Scheduler to run this task.

Task creation

Open the Tasks catalog through Menu > Catalogs > Tasks.
Create a task using the Add button.
Set the task type to Import and the data source (in this example, the Spreadsheet).
Configure the data source in the same way as described in the One-Click Import section.

You can open the data source settings directly from the task.

Configure Windows Scheduler to run this task

Go to the Windows menu Start > Windows Administrative Tools > Task Scheduler.
Click Create Task.
Go to the Actions tab and click New.
Click Browse and select the program file C:\Program Files (x86)\AzureLabel 11\AzureLabel.exe.
Temporarily go to the program and in the task window click Copy as arguments to run from the command line.
Paste the copied into the Add arguments box.
Click ОК.
Go to the Triggers tab and click New.
Set the task launch schedule.