Variable Data FAQ
What font, size and color will be used for the Variable Numbering portion?
The default font for the Variable Numbering portion is 14pt Calibri, black ink only. Black ink for the numbering should be taken into consideration when designing your artwork file. If your background images are dark, you may need to KO (knock out) the background image in the numbering areas, so that the numbers are visible.
What types of files can I upload for Event Tickets with Variable Numbering?
Artwork file formats: We recommend pdf. You may also send the following types: jpg, jpeg, tif, tiff, eps, and png.
Data file format: We accept CSV (comma delimited) format only.
To download a CSV Data File sample click here.
Note: The CSV data file may contain up to 5 digits or characters for each record.
How do I indicate what areas of the ticket I want numbered and how do I set up my CSV Data File?
Choose from the 9 numbered areas shown in the example below. You may choose as few or as many areas as you like. Indicate which areas you would like to utilize by naming the Column Headers on your CSV Data File with the corresponding Area Name.
Will you modify my CSV Data File to correct any errors or typos?
No, We don’t proofread, flag or correct errors. It is your responsibility to double check and ensure the accuracy of your data.
What if my CSV Data File has less records than the run size I ordered?
We will print the full run size ordered. Variable Numbering will be printed for each record in your CSV data file. The entire order with numbered and non-numbered tickets will be carton packed and delivered via the chosen delivery method (UPS Shipping, or Pick-up).
What if my CSV Data File has more records than the run size I ordered?
We will print the full run size ordered. If your CSV Data File contains more records than the run size ordered, We will not print those additional records.
How do I prepare a CSV data file with leading zeros, for example I want my starting number to 00001?
In order to preserve leading zeroes on your Variable Number CSV file (e.g. 001, 0001) please Format the Cells as Text before creating your numbered list.
To include leading zeros: Right-click (or control click) on the first few cells, then Choose Format Cells > Text or Plain Text. Once your cells are formatted, proceed with creating your numbered list. You should be able to see your numbering correctly before saving your document.
Note: If you close and reopen your document or look at a preview of the document, it will appear that the CSV has reverted and your leading zeroes were deleted. However, be assured that is not the case. As long as you were able to see the leading zeros at the time you saved the document, your CSV has the leading zeros. It is safe to upload your CSV and your leading zeroes will be preserved.