It is possible to create linear barcodes in VisionDP using Excel and a font encoder. Before the CSV data is imported into, the data must be "encoded" using a font encoder. Fortunately, it is possible to encode data in Excel using an IDAutomation font encoder, the VBA module.
The process involves importing the VBA into the Visual Basic Editor of Excel, returning to the spreadsheet to enter the formula, encoding the data, and exporting the file as a CSV. It is very similar to the mail merge/data merge process.
Encode data for Code 39
Code 39 does not require the VBA module.
Encode data for Code 128, UPC, Interleaved 2 of 5, and other linear barcodes
Example explains how to encode data for Code 128B. The tutorial should only be used as a guide on how to import the VBA, and enter a formula.
To create UPCa, use =UPCa()
To create UPCe, use =UPCe()
To create Intelligent Mail (Tracing), use =IntelligentMail()
To create MSI, use =MSI()
Though the example uses the standard Code 128 font, certain encoded characters of Code 128 and Interleaved 2 of 5 may cause the barcode created in VisionDP to appear with small empty boxes.
To generate Code 128 or Interleaved 2 of 5 barcodes for VisionDP, use the Universal Font Package. The Universal Font Package encodes data using the Roman character set, which will prevent the empty boxes.
After the data is encoded, import the CSV file into Vision, set up the fields, and apply the barcode font.
Posted 2623 day(s) ago