[en] Fix slow behavior when formatting allergens for food ingredients

目前还没有官方翻译。

[en] Problem

[en] 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.

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

[en] Solution

警告

[en] This solution doesn't work if you use Store/Recall printing mode. For Store/Recall printing, use our standard solution from 食品配料过敏原的格式设置.

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

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

  1. [en] 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. [en] Double-click the allergen table in the Databases section and go to the Data Retrieving tab.

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

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

    12_allergen13.png
  5. [en] Deselect Limit number of collected records.

    08_allergens8.png
  6. [en] Double-click your allergen function.

    06_allergens6.png

    [en] The Function properties window opens.

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

    07_allergens7.png

注意

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

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

11_allergens11.png

注意

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