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:

  1. 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.
  2. 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 Corporate license section.

Several users work in turn

This option is possible with a Pro license.

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:

  1. Install AzureLabel on all user computers.
    You can see how to do this in the Installation section.
  2. Close any running AzureLabels on all users' computers.
  3. Run the program on one of the computers and go to Menu > Tools > Backup database .
  4. Select your shared drive as the location to save the database backup.
  5. Close the program.
  6. Navigate to your shared drive using Windows Explorer or another file manager.
  7. Change the name of the previously saved file "db.fdb_backup_XXXXXXXX_XXXXXX_XXX.aldb" to "db.fdb".
  8. 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:

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

Option 2: Users share the program database with each other

Deployment and configuration:

  1. Install AzureLabel on all user computers.
    You can see how to do this in the Installation section.
  2. Close any running AzureLabels on all users' computers.
  3. 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:

  1. 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.
  2. The next user performs step 1, and so on.

Printing labels with Transparency codes

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

  1. Amazon Transparency 1.125" x 1.125"
  2. Amazon Transparency 1.75" x 0.75"
  3. Amazon Transparency UPC 1.375" x 1.375"

Example of printed labels (test data):

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

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

Let's say the link is in the Link data field of your data source.

At the time of inserting the QR code into the template

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

In an existing QR code

  1. Double click on the QR code
  2. Select data field Link.
  3. Click OK.

How to generate barcode?

In the template formula

Use function Barcode.

For example formula

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

will generate an EAN-13 barcode with a "23" prefix based on the data in the Code data field.

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 sort the list? How can I sort the list 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.

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 [Image] and the image width should be 1000px:

[Image] 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?

Add the desired layer in the template properties and before adding the element, change the current layer to another one.

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

  1. Select Actions > Save to file menu.
  2. Choose a location to save the template.
  3. Transfer the saved template to another computer.
  4. On another computer, go to Label Designer.
  5. Select Actions > Load from file menu.
  6. Select a saved template.

To transfer multiple templates

  1. Go to Menu > Catalogs > Templates.
  2. Check the boxes for the templates or template folders you want.
  3. Select Actions > Templates export menu.
  4. Select the templates export method Keep folder structure.
  5. Select a folder to save templates.
  6. Transfer the folder with the saved templates to another computer.
  7. On another computer, go to Menu > Catalogs > Templates.
  8. Go to the root of the catalog.
  9. Select Actions > Templates import menu.
  10. Select the import method Import all templates from a folder.
  11. Select a folder with saved templates.

How to work with GS1 data in a label template?

To work with GS1, you can use:

  1. 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.
  2. 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.
  3. 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:

  1. The GS1 string is taken from the Barcode data field.
  2. 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:

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

How to get a GTIN (or other element) from a GS1 string and put it in a separate data field when loading data?

Let's say you have a file with GS1 strings in a GS1 data field.

Let's say you want to load a GTIN element into a GTIN data field.

Do the following:

  1. Open the settings for loading data from the source.
  2. Add a GTIN data field.
  3. Click the button and set the formula to get the GTIN value (AI=01):

    [GS1] GetGS1ParsedData("01")

How do I mark up the price when loading?

Let's say you have a product file and each product has a price in the Price data field, but you want to load that price with a markup.

Do the following:

  1. Open the settings for loading data from the source.
  2. Select the Price data field.
  3. Click the button and set the formula to get the markup price (15% in this example):

    [Price] AddPercent(15;"+")

How to set up a scheduled task launch?

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

Task creation

  1. Open the Tasks catalog through Menu > Catalogs > Tasks.
  2. Create a task using the Add button.
  3. Set up and test the task.

Configure Windows Scheduler to run this task

  1. Go to the Windows menu Start > Windows Administrative Tools > Task Scheduler.

  2. Click Create Task.

  3. Go to the Actions tab and click New.

  4. Click Browse and select the program file C:\Program Files (x86)\AzureLabel 14\AzureLabel.exe.

  5. Temporarily go to the program and in the task window click Copy as arguments to run from the command line.

  6. Paste the copied into the Add arguments box.

  7. Click OK.
  8. Go to the Triggers tab and click New.

  9. Set the task launch schedule.

This completes the configuration and the Windows task scheduler will start the task according to the schedule you set.

See when the task was launched, whether it was successful and the result of its execution you can in the Tasks catalog.