Resolved Questions

KarlSangster

How to integrated encoded datamatrix data into InDesign?

Tagged With:-

Hi

first off, would just like to say im using the DEMO version of DataMatrix Encoder App from you guys, so not sure if this problem is related to the demo version having any restrictions on it or not

im trying to create a PDF in indesign (about 60,000 recrods/pages) that contains a unique 'customer id' that needs to be converted to a datamatrix barcode and applied to the PDF. so ive created the document in indesign, and ive used the File > Create Multiple Barcodes method in the encoder app and it generates an XML file for me (i get no other file type option other than XML)

so now i have my XML database with the encoded 'customer id' turned into data matrix font, i am having difficulty importing this data into InDesign to display properly, i feel there are extra steps i need to go through to import, as currently the XML has encoded the data matrix code into a text wrap, so it only loads the first line of data and skips the other 3 lines when converting to a barcode using the IDautomation font.

comparitively, this data works (without any tinkering) in microsft word, i guess word detects the line breaks/returns and it just creates the barcode perfectly fine (ive tested this my end) but when importing into InDesign, it doesnt like the line breaks/returns and simply ignores anything after the first break/return

i managed to find this on one of your support pages https://support.idautomation.com/Office-Macros-VBA/How-to-Create-2D-barcodes-in-InDesign-using-Fonts/_3420

and it seems to fix the problem i am having, by replacing the linebreaks/returns with _r then using idesign to change _r back to linebreaks/returns, which is all good.. however im stumbling at the very first hurdle, trying to get the formula to work, after pasting the formula next to the encoded data, i simply get #NAME? in the field instead of the converted data with _r

im kind of green/inexperienced with formulas, is there anything special i need to do with this formula? the A2 cell part of the formula is correctly targeting the encoded data, so im not quite sure why its not taking the data and putting _r on it

any thoughts?

thanks

Attachments:

» DATAMATRIX.png

09-12-22 144 day(s) ago

Report Abuse


Ben	Best Answer To produce a solution that moves each encoded line to a different column requires customizing the Data Matrix Font Encoder to with Excel formulas. Each column is considered a separate merged field. If you are expert level in Excel, it may be good option. However, IDAutomation could not support a customized VBA formula. The best option is to find out why navigating through pages, reverts the encoded data or does not encode all the values from the merged field. Posted 141 day(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet. Be the first to comment.

Other Answers (6)

KarlSangster

Posted 142 day(s) ago

(0)

Report Abuse

KarlSangster

hmm, ill send an email over to adobe and see what they say, in the mean time, dont suppose there is a different process all together we could tackle?

currently, the 'Datamatrix Encoder App' from you guys, exports multiple barcodes out into a single data string.

i work in a mailing house and we get data supplied to us from UK mail provides like Onepost, Citipost, Whistl etc and they provide their data into 4 seperate columns, instead of 1 string with line breaks.

considering the problem at the moment is getting indesign to change _r into linebreaks, if there is formula going around that completely bypasses line breaks being used at all, and instead says something like at character 13 or 10 (or whatever the formula is that defines the line break, instead of replacing it "_r" how about it puts the rest of the code onto the next column over, so if the string is in A2, the formula would break that string out into 4 columns A3,A4,A5,A6 which is how the other mailing companies provide there data, that way there is no line breaks and returns (which is proving troublesome with CSV format and indesign, and you simply need to select the 4 fields like this

Barcode1
Barcode2
Barcode3
Barcode4

and then change the font to datamatrix font, and that in theory would work, as that is how we currently get the Type 29 mailmark barcodes to work from Onepost, Citipost, Whistl etc

is there a formula or a tweak in the export process for the Datamatrix Encoder App that can export the string onto 4 seperate lines instead of 1 line with returns/breaks?

Posted 142 day(s) ago

(0)

Report Abuse

Ben	I have reviewed Adobe's page regarding Find and Replace and I cannot determine why it would revert when advancing and reversing through pages. Maybe Adobe can provide insight . Posted 142 day(s) ago (0) (0) Report Abuse

Ben

We no longer have an account for Adobe and will not be able to support it directly. I was not able to view the screen shots. I recommend sending the screen shots to our Technical Support email. While we might not be able to resolve the issue directly, we might be able to provide some advice. It might also be helpful to contact Adobe InDesign support to find out if they have an recommendations after importing a CSV file with characters to replace.

Posted 142 day(s) ago

(0)

Report Abuse

KarlSangster

Hi

thanks for the fast reply, ive gone back through the guide and noticed i missed out a small line from the walkthrough, stating a different formula is to be used if using the demo version, see below:

9. In cell B2, enter the formula:
Licensed Version use: =IDAutomation_DMatrix_FontEncoder()
Demo Version, use: =EncDM()

so with that change, using EncDM instead of the licensed version, it made the necessary change to the data, so all good there

However, now that i have got further along in the process, im stuck at another step, specifically when i am importing the CSV into InDesign and using the Find/Replace feature, its only working on the preview record, and not making the change to every record in the data, for example jobs i will need to get this working on, are documents of say 10,000 records, the change we do in Find/Replace needs to apply to every single record, not the first record

on this guide here > https://support.idautomation.com/Office-Macros-VBA/How-to-Create-2D-barcodes-in-InDesign-using-Fonts/_3420

pretty much from step 6 or 7 onwards, i follow the steps, but its not making the changes all the way through the document, only to the 1 record that you are currently previewing, it WILL change the _r_r in the data string to ~b~k to create break lines, but it doesnt carry that out throughout the whole document, for record 2,3,4 onwards.

also when you export to PDF, it ignores the changes and just shows the data with _r_r on it and doesnt replace them ~b~k

any ideas why this is not applying to all records and only the 1? (and then ignore the changes when exporting to PDF) its almost like there needs to be a buttong or option somewhere that says "apply to all records" or something but i cant see it

if i can upload the InDesign file for you to have a look at, would that help? ive also uploaded 4 screenshots showing:
1) the find/replace settings page
2) the effect working on the single preview record
3) the changes getting discard when you cycle through to record 2
4) the changes still being discard even when you go back to record 1, its as if its not actually holding onto the changes ive told it to make

any help would be appreciated (getting there, just stumbling at this final hurdle)

Posted 143 day(s) ago

(0)

Report Abuse

Ben

If you are working through the guide to produce barcodes in InDesign using Excel VBA, the #NAME usually means either more than one VBA with the same name is imported or no VBA is imported.

Check to make sure there is only one Data Matrix encoder file imported into the VB Editor.

Also, refer to this Excel #Name Error Incident.

Posted 144 day(s) ago

(1)

(0)

Report Abuse

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption	:
Link URL	:	(Must starts with "http://")
Add \| Cancel

Allow to insert an image. Must be among the following file types - .jpg, .gif, .png & .bmp.
Image Url	:	Upload New (Image url must always starts with " http:// ")
Width	:	pixels (Must not be greater than 450px. Enter 0px for no resize)
Add \| Cancel

Allow to insert YouTube video. Insert the video embed code.
Embed Code	:
Add \| Cancel

Up to 5000 Characters are allowed. Current Count: 0

Your comment on this answer

Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption	:
Link URL	:	(Must start with "http://" or "https://")
Add \| Cancel

Allow to insert an image. Must be among the following file types - .jpg, .gif, .png & .bmp.
Image Url	:	Upload New (Image url must always start with "http://" or "https://")
Width	:	pixels (Must not be greater than 450px. Enter 0px for no resize)
Add \| Cancel

Allow to insert YouTube video. Insert the video embed code.
Embed Code	:
Add \| Cancel

Up to 5000 characters are allowed. Current Count: 0

My Profile

You may answer and comment on any thread according to the Terms and Conditions.