Running a programme · For a printer's production manager
What is in the print file
An export is built in the background and downloaded as a ZIP. One table, two renderings: the CSV is for variable-data printing, the Excel bundle is for people to look at.
The files #
| File | What it is | Print from it? |
|---|---|---|
qr/ (SVG files) | One vector file per label. Scales to any size with no loss. | Yes. |
codes.csv | One row per label, one column per thing. For variable-data printing. | Yes — through your own VDP software. |
| The Excel bundle | The same labels with the QR embedded as an image, for human handover and sign-off. | No. The image is 338 dpi at 15 mm. It is for looking at. |
manifest.csv | One row describing the batch: batch id, brand, product, line, mode, the second factor, the label range, the verification limit, lot number, the printed dates, and the scan URL the codes were built against. | For the job bag and for QC. |
SHA256SUMS.txt | A checksum per file, taken as each file was written. | To prove the file you hold is the file AVRA built. |
The columns, by line #
| Batch | Columns, in print order |
|---|---|
informational, authenticity single, warranty, certificate | label, qr |
authenticity dual | label, qr, then qr2 or scratch |
rewards with a scratch code | label, qr, scratch |
rewards with two QRs | label, qr, qr2 |
qr2 is a URL for a second QR; scratch is a short code printed as plain text. The second column is qr2 when the second factor is scanned and scratch when it is typed. A certificate batch's export also carries the issuer's own columns, so the document can actually be printed.
The one rule about row order #
Keep the row order. An imposition job that re-sorts rows pairs a QR with a different label's second factor, and every mis-paired label is either a reward paid on a pack nobody bought or a genuine pack that reads as fake. The label column is your check, and QC's way of finding label 4,312 on a roll. The full artwork rules are in the artwork spec.
Why a cell can never run a formula #
Every CSV cell we emit passes one guard that neutralises a leading =, +, -, @, tab, CR or LF. The Excel bundle writes every cell as text, never as something Excel may read as a formula.
Last reviewed 18 Sep 2026 · Something wrong? connect@avrascan.com