How to insert custom random bar code-39 in more than thousand Visio drawing file copies
Hello,
Here a long post follows. Discussed issue might be very small but to clarify my requirement I had to write in detail.
I have designed a Visio 2016 drawing which has eight A3 landscape pages. With centerfold stapled and double sided printing it will become a 32 paged A4 book.
I have to get more than thousand copies of my original visio file, with bar codes inserted as per the scheme I will explain below
I am trying to match concept similar to MS office mail merge. But mail merge directly would not work in Visio I think. Another idea is to generate barcodes and their text in Access and then somehow insert repeatedly in visio file and get it printed like mail merge.
There are numerous ready made (PAID) bar code Add-ins or other stuff. But I want to solve it in-house.
I have attached a sample Visio file. When printed and center stapled, it turns into an A4 portrait book having 32 pages printed front and back. In Visio file, each page is A3 landscape having center fold in the center which visually divides A3 Page into two A4 portrait pages. On each A3 page there are four specific locations where bar codes 39 has to be inserted. The bar codes placed in sample are generated outside of Visio just to create the sample.
I had to remove following pages from sample to overcome file upload size limit
P20 and P13 Deleted
P22 and P11 Deleted
P12 and P21 Deleted
Batch run
On a batch run, I need to open Visio file, insert bar codes as per given scheme, save (with a different name so original in intact) or print or both. Then open the main Visio file again insert new bar codes on set locations as per given scheme then again save/print. Similarly more than thousand copies of this 32 paged book are required.
Bar code 39 scheme explanation
Bar codes at the top of A4 pages and bottom of the page are same. Except that at bottom of page under barcode there is readable text at a given distance from bar code.
Each A4 page will have a new unique bar code according to the following scheme:
Bar Code Scheme:
SAMPLE BAR CODE TEXT( Code 39): * 01-MS0123456789-A1*
Start and end character asterisk '*' is required to be included in bar code but optional to display in readable text.
bar code examples Page wise:
----------- START of Book -----------
Page:1 01-MS0123456789-A1
Page:2 02-MS0123456789-A2
Page:3 03-MS0123456789-01
Page:4 04-MS0123456789-02
Page:5 05-MS0123456789-03
.
.
.
Page:30 30-MS0123456789-28
Page:31 31-MS0123456789-29
Page:32 32-MS0123456789-A3
----------- END of Book -----------
Format for one 32 paged book is as follows:
Bar Code text digits:
First two digits : numbers from 01 to 32
Third digit: hyphen sign '-'
Fourth and fifth digits: characters (in sample 'MS')
Sixth to fifteenth digits: numbers (select randomly from a given start number and end number set)
sixteenth digit: hyphen sign '-'
seventeen and eighteenth digits:
On first page: A1
On second page A2
On third page: 01
On fourth page: 02
.
.
.
On page 31: 29
On page: 32: A3
More than thousand books print out will follow above scheme
In all cases bar code remains unique everywhere.
User may ask to changes in bar codes static and random series parts in future.
Please guide my direction for an in-house solution.
Waiting for response
|