Serialisation with Database
Hi,
I looked through the forms and couldn't find any answer so I thought I would try, at the moment, we print off data to a label, which is scanned into a database to print small CR80 tags with a QR code, the QR Code on the tag contains all of the relevant fields which have been put into a CONCAT but we have no way to add the tag serial number itself to the CONCAT field.
I know i can serialise within BarTender but due to 3rd party issues, i need to add the tag serial to the 3rd or 4th field of the CONCAT, while serialising just seems to tack it onto the end.
The question is can I do any of the following and which (if any) is easier?
Update a new, blank "TagSerial " field with the sequential numbers?
Add the sequential numbers to the middle of the QR code by assigning multiple Data Sources instead of the one CONCAT data field?
If anyone has a better idea or knows an easier way please let me know
-
Hi,
Maybe not the best and certainly not the most elegant solution, but I managed to work around it, so if times are dire use this, if someone else can provide an actual solution using the database please post below as this was driving me crazy.
I opted to drop the CONCAT and added the fields individually to manipulate the layout, using the BarTender designer, I changed the data sources to be in the order I needed individually, and embedded a comma (this can be any sort of separator like | or / etc)between each field by using the character template and setting it to ",".
Then to add incrementing serials, I once again used the embedded data inside the QR code and set it to "1" as a text object (So if printing 1000+ it wouldn't contain a ",") and would increment by one each print using Transforms > Serialisation
Pic below for layout, again if someone can say how to do this with a field writing the serial number back to the database and then add that to the QR code, that would be fantastic, any other issues i will try to assist where possible.
0 -
Do you mean something like this with a single concatenated field which you need to break up to add a sequential number in to the middle of?
If so and if the data always appears in the same location you could just add multiple strings and then truncate them accordingly. Strings 1 and 3 below are linked to the concatenated text field but string 1 removes the last 8 digits and string 3 just keeps the last 8 and string 2 is the sequential number between:
1 -
To write back data to the database you would need to create an Action from the BarTender Document Option from the File Menu.
1 -
How would a statement like that be worded?
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
4 Kommentare