New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions

Help with Data Matrix 2D Barcode on MAC for InDesign


I'm looking for help with a 2D Barcode (Data Matrix) on a MAC. We have the 2D font installed. We are looking for help with creating and setting up a MAC in Excel, the proper steps so when we save the CSV we can then merge it into InDesign. I feel we are missing multiple steps here. I think we are missing a step or 2 in the Excel portion. Thank you.

Operating System: MAC OSX

Application: Excel, InDesign

04-03-23     1.5 year(s) ago    

  Report Abuse

 

debrac

Best Answer

The generation of a Data Matrix barcode and subsequent merging of the data to InDesign is a complicated process. First, your data will need to be encoded which can be done in Excel and is fairly straightforward. The merge to InDesign is where things will become more difficult because there are invisible line breaks in the encoded data which makes the square symbol that needs to be changed over to visible characters for the merge and then changed back to their invisible characters to complete the barcode. There are two tutorials that should help you with this:

1.
For the encoding piece in Excel which is a good tutorial for both Windows and Mac: How to encode Data Matrix Barcodes using VBA in Excel.

2.
After you have your data encoded, here is a tutorial for the 2D barcode merge to InDesign: How to Create 2D barcodes in InDesign using Fonts and this tutorial picks up after Step 9 of the first tutorial.

The merge is a complicated process and unfortunately, IDAutomation cannot support the merging of the data to InDesign directly but the second tutorial listed above has worked for previous customers. If the import to InDesign and changing the visible back to invisible characters isn’t working correctly, you would need to reach out to InDesign for assistance with that portion.

Posted 1.5 year(s) ago

(0)
(0)
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.

Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  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
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  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

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

 © Copyright 2021 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook