Formatting Allergens for Food Ingredients works slow

Official translation unavailable. Translate this page with Google:

Problem

When you browse through the records in your solution for allergens, NiceLabel responds slowly. It takes a lot of time to switch between records. The delay increases with the number of records in your food database.

The problem occurs because NiceLabel loads the whole database every time you switch the record in your allergen solution.

Solution

Warning

This solution doesn't work if you use Store/Recall printing mode. For Store/Recall use our standard solution described in NiceLabel Designer User Guide.

You can modify your existing allergen solution in NiceLabel Designer. The method is valid for all supported databases in allergen solutions.

The described procedure is based on our sample with an Excel database. You can find sample allergen solution if you open NiceLabel Designer and go to Help > Sample Files > Labels > Food > Food Allergens

  1. Connect your allergen table to the existing database connection. Go to Dynamic Data Manager, then double-click your database. Add your table, then click OK.

    10_allergens10.png
  2. Double-click allergen table in Databases section and go to Data Retrieving tab.

    02_allergens2.png
  3. Deselect Show record selection at print time.

    12_allergens12.png
  4. Select Collect records option and set comma character (,) as a Delimiter.

    12_allergen13.png
  5. Deselect Limit number of collected records.

    08_allergens8.png
  6. Double-click your allergen function.

    06_allergens6.png

    Function properties window opens.

  7. Edit your VBscript. Use FormatAllergens function name instead of your existing name like FormatAllergensFormatAllergensFromExcel. Change also the other syntax where you define your allergens:

    07_allergens7.png

Note

If you use an allergen solution with exclusions, connect your solution also with the exclusions table.

Repeat steps 1-6 for your exclusions table. Change the syntax where you define your allergens and exclusions:

11_allergens11.png

Note

You won't see highlighted allergens in the Designer's preview. To see correct previews, go to File > Print.