In this chapter you will learn,
- how to create a serial number without uploading a CSV file,
- how to parameterize the serial number and
- which possible specific issues can be illustrated
1. General
In practice, for creation and printing, sequential numbering must be generated either sorted or randomly arranged on previously prepared designs - this is in order to achieve clear labelling. Therefore, the data source for the serial number can either be created beforehand in an external application and provided as a CSV file, or it can be created in the VDP Editor without uploading a CSV file. Serial numbers are needed for the following cases:
- Lot numbers - Unique number for raffles, tombolas, etc.
- Batch numbers - Creation of combined number ranges with consecutive numbering.
- Vouchers - Creation of unique number for promotional vouchers.
- Machine numbers - Creation of unique numbers for stickers which are used to identify machines or spare parts.
- Identification/badges - Creation of consecutive numbering for badges or authorization badges.
2. Creating a serial number
You would like to create consecutive numbering on a sticker, based on the following parameters:
- seven-digit numbering
- the smallest number should start with 100, the largest number is 9999999
- centered horizontally within the space provided on the sticker
- in Calibri Bold with 8pt font size
- in a color matching the design
In order to carry out this intention, proceed as follows:
- Open the desired Article or the intended Print Item in the VDP editor.
- Select the VDP Text Tool [1].
- Create a line from the left edge to the right edge of the free space on the Print Item. The line indicates, on the one hand, from which start position to which end position the serial number will stand and on the other hand, from which baseline the serial number will be created. The X and Y position of the serial number can be changed later and at any time. The red color for the line immediately indicates the user that the serial number is placed on layer VDP on highest level [2].
Figure 1: The Print Item when creating the text position using the VDP Text Tool
Warning is displayed
Since serial numbers are usually applied in small font sizes, after releasing the mouse button the dummy text may run into the text overflow. This will cause a warning to be displayed in the area provided. You can simply ignore this warning when creating the serial number, as this warning will disappear when conducting the next step.
- After releasing the mouse button, the Sample Content dummy text is created in a predefined size and font and displayed to the user.
- Then open the Content tab [3] and select the Serial Number [4] entry in the Data source option.
Figure 2: The Print Item after dragging the text position with the VDP Text Tool and selecting the Data Source Serial Number
- By selecting Serial Number in the Data Source option, five input fields are offered, which present the following functions:
- Start [5] – Define the start value of the serial number.
-
Repeat after [6] – By entering a value - a number greater than the start value - the serial number will start numbering again, beginning with the start value.
Example:- Start=100 | Repeat after = 105 | Width = 7
- Outcome: 0000100, 0000101, 0000102, 0000103, 0000104, 0000105, 0000100, 0000101, 0000102, 0000103, 0000104, 0000105, 0000100, 0000101, …
-
Increment [7] – Defines at which interval the next number should be generated
Example:- Start = 100 | Increment = 105 | Width = 7
- Outcome: 0000100, 0000105, 0000110, 0000115, 0000120, …
-
Repeats [8] – Defines how many times the current Serial Number will consecutively remain the same before switching to the next Serial Number.
Example:- Start = 100 | Increment = 105 | Repeats = 3 | Width = 7
- Outcome: 0000100, 0000100, 0000100, 0000105, 0000105, 0000105, 0000105, 0000110, 0000110, 0000110, 0000110, …
- Width [9] – Defines the number of digits which are to be generated and therefore filled with leading zeros. (See as well the warning message after the figure)
- For the execution of the task, enter the value 100 in the Start [5] input field and the number 7 in the Width [9] input field and leave all other input fields unchanged as set by default. For checking your inputs, inspect the values in the Preview [10]. There, the Serial Number which would be generated for the next and the after next data set is displayed.
Figure 3: The Print Item with the defined parameters for the Serial Number
Generate leading zeros
When generating leading zeros for Serial Numbers, the Width to the desired number of digits has to be entered. In the VDP browser, leading zeros cannot be entered in the Start input field. However, in the Adobe Illustrator plug-in this is possible. Note that leading zeros in the Start input field are thus eliminated in the output.
- After defining the serial number sequence and according review, it is possible to define the graphical implementation. To do this, switch to the Format tab [11] and open the Text Settings [12] settings area.
- In order to place the serial number horizontally centered in the free field, select the Align centered entry in the Horizontal alignment [13] option. The function of the other parameters in this settings area is described below in Create Serial Number on Arc/Path serial number on arc/path. For our example, the other two options are not relevant.
- In order to format the font for the here described example, open the Font Settings [14]. Select Calibri [15] and Bold [16] in Font Family and set the Font Size [17] to 8 pt. For other purposes the following more options are available in this settings area:
- Font Collection [18] - Allows users to upload their own fonts which can be subsequently selected in Font Family. The procedure for this is described in Creating and editing variable objects.
- Horizontal / vertical scaling [19] - Distort the font for the entire serial number either horizontally or vertically. Typographers will scold us for providing this option!
- Glyph Spacing [20] - Increase or decrease the letter spacing between all letters. Selective spacing of parts of a Serial Number or defined text is not possible.
- Line Width [21] - If, for various reasons, the Serial Number or text needs an outline, this can be done by entering the line width. For a more detailed description on how to create a outline for a text, see the section Create a Serial Number with Outline.
- Dash/Gap [22] - Use this to create a dashed font outline, among other things. A more detailed description can be found below in the section Create a Serial Number with Outline.
Figure 4: The Print Item with formated Serial Number
- As the last step of the procedure, we want to determine the color of the Serial Number. To do this, open the Color Settings area [23] and select the color picker [24] option. This allows you to select the desired color value simply by clicking on the color circle [29] and to transfer the color value as CMYK value [28]. The color can also be defined in other ways. The following options are available for defining a color (for a more detailed description, see the article Creating and editing variable objects):
-
Color Picker [24]- When this option is enabled, different colors can be assigned as follows:
- CMYK colors [26] – Allows a color to be defined by entering a CMYK value [28].
- Spot Colors [27] – Allows the desired Spot Color to be selected and used from the list of system-wide defined Spot Colors.
- Color wheel [29] – The color circle represents the used color value. However, users can also double-click on the color wheel to select a color value and transfer the resulting CMYK color value to the CMYK input fields.
- No color – By pressing the X symbol the object is displayed without color (transparent). This only makes sense for texts or serial numbers, when at least an outline is created for the text or serial number.
- Data Source [25] – When this option is activated, the color value can be taken from a CSV file or generated by creating dynamic color values using serial numbers.
-
Color Picker [24]- When this option is enabled, different colors can be assigned as follows:
Figure 5: The Print Item with colored Serial Number
- When the serial number is provided with a Stroke, the color value and the fill color can be determined in the Stroke Color Settings [30].
- Close the finished dialog by selecting the Save menu item.
3. Specific features
In connection with Serial Numbers a few special features are available. The following description deals with these special features. All options that can be used for serial numbers are described here.
3.1. Generate a random Serial Number
Especially for lot numbers or vouchers, the Serial Number should not be serialized in the output, but printed well mixed. This function is available in the VDP editor by activating the Randomly Distributed option [32] in the Contents tab [31].
Figure 6: The Print Item with a randomly distributed Serial Number
3.2. Create Serial Number on Arc/Path
In order to create a white serial number on a path or circular resp. elliptical arc on the blue surface, proceed as follows.
- Create a path along the desired elliptical arc using the VDP Text Bezier Curve Tool [34]. To do this, simply use the tool to create a start point, a vertex and the end point and finish the process with
ESC
. - The placeholder text Sample Content is created on the inside of the arc in the default size and font.
- Adjust the path accordingly using the Direct Selection Tool [33] resp. by selecting Smoothing Type [35] for the selected curve point so that the text runs alongside the desired curve.
Figure 7: The Print Item with its placeholder text which is located along the inside of the path
- Switch to the Content tab and select the Serial Number entry in the Data Source option and enter the same values that were set in the previous example - Start 100, Increment 1, Width 7.
- Switch to the Format tab and format the serial number with regard to Font Family, Font Size and Glyph Spacing in the Font Settings [39]. Note that Glyph Spacing is mostly mandatory for texts within an arc. Adjust the Glyph Spacing to match the design.
- Switch to the Color Settings area, set the text as white text with the CMYK values 0/0/0/0.
- Finally determine in the Text Settings area, where the text should be positioned on the path. In the illustration below, the text has been left-aligned [36] and indented with a 2 mm offset [37] from the left starting point. Since the text is already created inside the arc, you do not need to activate the Place Text Inside [38] option. As well in some other cases, this option might bring about the desired text positioning.
Figure 8: The Print Item with the from left aligned white Serial Number on the created text path
3.3. Create a Serial Number with an Outline
In order to create a serial number consisting of an outlined, dashed text, proceed as follows.
- Create a Serial Number at the desired position, in the desired size and font using the desired VDP Text Tool. You are already acquainted with this functionality.
- In order to create the stroke for the serial number, you need to experiment with the following options:
- Line Width [40] - Depending on the font size, you need to adjust the line width. Note that half of the line width grows outwards and the other half grows inwards, so if the line width is too strong, this can cause very unfavorable visual effects.
- Stroke/Gap [42] - Determine the length of the white drawing outline and the length of the non-drawing outline. By entering the same value for stroke and for the gap, a regular dashed line will be created. If you want to make the pattern more variable, you must add another definition for stroke and gap by clicking on the + symbol [41].
- Stroke Color Settings [43] - In order to draw a white outline, the stroke color must be defined in this settings area by entering a color definition - in this example the CMYK values are set to 0/0/0/0.
Figure 9: The Print Item of a white dashed outlined Serial Number on a Text Path
3.4. Automatically adjust text size for serial numbers
Numbers are monospaced in almost all fonts. This means that each number has the same tracking - width of each letter. Thus, no matter what combination of numbers is produced when the serial numbers are generated, the sum of all numbers should always have the same text length.
However, there are also fonts that have tracking, depending on the number. For such fonts, it is advisable to adjust the text length automatically. In the figure below, a serial number has been created with a proportional font. Due to a change in the tracking length for the number 4, the serial number of this font will overflow into the text.
Figure 10: Left: The serial number for the digits 399; Right: The serial number for the digits 40
To prevent the overflow from happening in the output, two entries are available in the Fit Size [45] option in the Font Settings [44] area.
- Reduce to fit - If a text overflows, the font size is automatically adjusted by reducing the font size. This ensures that no letters of a variable text are removed in the output.
- Fit Text to content size - The font size for the text is always automatically adjusted to the available path length. Note that this means that changing the font size does not visually change the text or serial number.
Figure 11: The settings area Font Settings with activated Fit Size Reduce to fit
Article update: Workflow version 1.13.2 – 08/2022