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 Bookmark and Share
pfm

Insert variable QR codes

I am having difficulty inserting variable QR Codes into a job being printed on an HP Indigo digital press. We are using the Excel VBA tool on a Windows 7 machine and Excel 2007. The insertion is being done on a Mac in Indesign CS4 using the IDAutomationDMatrix font. The urls for the QR codes were sent to us in a CSV file.
The conversion appears to work correctly, but when the font is applied to the codes, there are wide line breaks splitting the QR codes. As best I can tell, there are no line breaks in the file.


06-20-12     2561 day(s) ago    

  Report Abuse

 

pfm

Best Answer

Neither Indesign nor the choice of fonts was causing the problem. The datafile was not correct.
The macro converts the URLs to:
=EncQR_click(http://whatever.com)
In order to work properly, the fx field needs to contain:
=SUBSTITUTE(EncQR_click(http://whatever.com),CHAR(13)," ")

Posted 2559 day(s) ago

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

pfm
Indesign is not adding any additional lines.
What puzzles me is the fact that the previous datafile does not cause this issue, but the new one does - in the exact same file.
If I manually change the line spacing, I can make the spaces go away, but this is a trial-and-error process and I have no way of knowing whether or not the codes will scan.
These codes are going on labels that will have variable data, individual QR codes and RFID tags - all of which will be unique to each label.

Posted 2560 day(s) ago

()
()
   Report Abuse

Ben
You may want to take a look at: https://www.idautomation.com/fonts/datamatrix/faq.html#Line Spacing Issues

It mentions the Data Matrix symbology but QR Code also applies. Also if it is not this issue, then check your application's line spacing. It is most likely one of the two issues mentioned.

Posted 2560 day(s) ago

()
()
   Report Abuse

pfm
image
image image image
The top and bottom image use the previous data file; the middle two use the current file. No other changes made to the Indesign file. Originally printed using the DMatrix or IDAutomation2D font.

Posted 2560 day(s) ago

()
()
   Report Abuse

Ben
Can you attach a screen shot of the issue? I just need to see a bit more detail before I can determine exactly how to resolve the issue.


Posted 2560 day(s) ago

()
()
   Report Abuse

pfm
We are making QR Codes. This job had been done in the past by someone else who worked here. The previous job was set up to use IDAutomationDMatrix as the font and was set to 7.3 pt size with 7.3 pt leading. When I change to the 2D barcode font (otf) in either the old job or the one I am working on, the appearance does not change - the old job looks correct in both fonts and the new job is incorrect in both fonts. When I use the old database in the new job, the codes appear to be correct and when I use the new database in the old job they are incorrect. This leads me to believe that the datafile is not correct.

Here is what I did in Excel:
Duplicate the column with the URLs (I also tried this on the original column)
Select the new column and use the Symbology Addin to convert to QR code
Save the file as comma delimited (I also tried every tab delimited option)

The converted fields now read as follows in the formula bar:
=EncQR_click("http://...")
The fields themselves are a long string of capital letters with no spacing or other characters.
I did not apply any format to the fields nor did I resize the columns.

Posted 2561 day(s) ago

()
()
   Report Abuse

Ben
What barcode are you attempting to create Data Matrix or QR Code or both? If you are creating QR Code, then you will want to apply the IDAutomation 2D barcode font to the encoded data. If you are creating Data Matrix, then you will want to use the IDAutomationDMatrix or IDAutomation2D font.

If you are receiving spaces, then make sure there are no additional lines being placed within InDesign as this will create a barcode that has horizontal lines through it.

Posted 2561 day(s) ago

()
()
   Report Abuse
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 2019 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