Text To Bold From Database Field
hi,
I am pulling list of ingredients from MS Acess database and would like data to be checked against a list of allergens.Any allergens found in the data field should be converted to Bold face on print.
something like this,
if "ingredients field" contains any of (list"Milk, Mustard, Peanuts,Fish")
print Bread,Chicken,Milk,Salad
could you help me with vb to achieve desired output
kind regards
-
Hello skbhatti,
We've created a solution for this precise issue (mainly due to the new EU allergen regulation), but in order to be able to send you this sample I'll need it to be through email. Do you mind sending us an email to Technical Support requesting this sample?
http://www.seagullscientific.com/label-software/technical-support.aspx
Regards
0 -
Hi ,
Thanks for quick response. Sent an email yesterday to eurotech@seagullscientific.com now will wait for samples .
Regards
0 -
Hello!!I have found some issues using this method :(1. If i have both "Egg" and "Eggsallad" in my "allergenslist" I haveto write Eggsallad first, otherways only the three first letters of the word "Eggsallad" will be bold.2. If I use Uppercase letters in as a capitalletter in my "allergenslist" it puts Uppercase letters inside a sentence even if it's not like that in the "Ingredientlist" .I tried to enter the allergens both with Uppercase and lowercase letters, but in this case it uses the last one that shows up in the allergenslist.BR// Andy.0
-
Hello Andreas,
Thanks for your feedback.
Indeed as the function stands the Allergens need to be ordered from the "longest" to the "shortest" to prevent the kind of issue you found when more than one allergen share common characters (such as "Egg" and "Eggsallad").
Regarding the upper or lower case of the allergens, note that the script searchs for the allergen in your ingredient list and substitute it with the corresponding allergen from the allergen list surrounded with the appropriate tags. Being that the case, you need to be careful to specify the allergens in the format you want them printed.
*Note that we hope to improve the script for future release of our software.
Many thanks and regards.
0 -
We now also have a FIC allergen labelling page on our website which covers this:
http://www.seagullscientific.com/label-software/food-and-beverage-fic.aspx
0 -
Hello Andreas,
Thanks for your feedback.
Indeed as the function stands the Allergens need to be ordered from the "longest" to the "shortest" to prevent the kind of issue you found when more than one allergen share common characters (such as "Egg" and "Eggsallad").
Regarding the upper or lower case of the allergens, note that the script searchs for the allergen in your ingredient list and substitute it with the corresponding allergen from the allergen list surrounded with the appropriate tags. Being that the case, you need to be careful to specify the allergens in the format you want them printed.
*Note that we hope to improve the script for future release of our software.
Many thanks and regards.
Hello again!!
The problem with the Upper & lower letters persists....
If the ingredient is the first word in a sentence, then i want it with a Capital letter, but if it's in the middle of thee sentence then I want it with small letters... Is this duable??
BR// Andy.
0 -
Hello Andreas,
Please note that we've improved the FIC solution you'll find in our website that cover your issue apart from adding a number of features requested by other users (an exception list, different language support,...).
You'll find our solution on the following webpage:
http://www.seagullscientific.com/label-software/food-and-beverage-fic.aspx
Regards.
0 -
Hello!
we are using BT10.0 SP4, do you also provide a template for this build? Or are we forced to do an upgrade?
Kind regards
Tobias
0 -
Hello Tobias,
The sample from our website requires features that are only available on v10.1.
Do note that it's possible for the script to work on v10.0, as the latter also uses HTML markup containers; but in this case you would need to adapt the script to make up for the lack of features of your version (something you would need to devise yourself).
*Main features that in this case affect the older version are: "external file" type data source, and independent named data sources (not contained in any label object).
Regards.
0 -
Thank you for your reply Fernando!
0 -
Hello,
How can apply allergen ingredients on bold if I connect database via excel?
0 -
When BarTender installs it should install some sample labels and one of those is called the EU FIC label. You should be able to find it here
C:\Program Files\Seagull\BarTender 2022\Templates\Food
I would suggest opening and then resaving this label as a different name and then modifying the size etc to match your requirements and add on the database link to your spreadsheet.
In the column on the left are a number of Named Data Sources and if you double click on the Ingredients you can then change the source of where this information comes from, ie change the the Type to Database and select and the correct field in the spreadsheet.
The field shown on the label image below is a complex VB script field that searches the contents of the Ingredients named data source at print time, looking for matches to the contents of the Allergens named data source ignoring any in the Exceptions and then applying the setting of the named Allergen Style field to the allergens found.
0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
12 commentaires