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

Cannot Save Excel Generator Image to CSV for InDesign


I can create a 2d code in Excel, but it has to be in a .csv file format. When I try to save the file as a .csv, the 2d code field ends up blank. Is there any way to save it as a .csv & keep the 2d code intact?

Operating System: Windows 10

Application: Excel

10-10-22     117 day(s) ago    

  Report Abuse

 

Ben

Best Answer

When using the Barcode Generator for Excel, it is not possible to store the image created with the default parameter or parameter 1, such as
=IDAutomation_NXLS_DataMatrix(CELL REF) OR =IDAutomation_NXLS_DataMatrix(CELL REF, 1) , into a CSV.

In this case, IDAutomation has another parameter to generate text data and use a barcode font with the product. The formula uses parameter 3:
=IDAutomation_NXLS_DataMatrix(CELL REF, 3)

About Font Text parameter 3:
Returns a text string that when combined with the included font creates a barcode. If this option is used, the fonts within the package must be installed on each computer using the product. This option should only be used when the font produces a better result than other options. The fonts to install are IDAutomation2D XLS for all 2D barcodes. No other fonts or sizes are provided since these are the only sizes that display correctly within Excel. If other font sizes are needed, the appropriate font package must be purchased. Any cell using IDAutomation2D XLS must be set to "wrap text" to stack the 2D symbol. If it is necessary to embed the font for distribution, it may be possible to embed the Excel worksheet in a Word document in which the desired font is also embedded.

The text produced in this formula uses carriage returns and line feeds to stack the character. To ensure the data is maintained in a CSV, the carriage returns and lines feeds must be replaced using this formula directly in Excel:

=SUBSTITUTE(SUBSTITUTE(IDAutomation_NXLS_DataMatrix(CELL REF, 3),CHAR(13),"_r"),CHAR(10),"_r")

image

image


In InDesign:

1. Open an InDesign project. Select Window - Utilities - Data Merge.
image
image

2. Choose Select Data Source.
image

The encoded data appears as:
image

3. On the left panel of InDesign, drag a text field onto the document.
image

4. Drag the merged source field to the text field.
image

5. Check the Preview check box within the InDesign Data Merge box.

6. Select Edit - Find/Change.
image

7. Select the GREP tab. In the Find what box, enter _r_r or the replacement character used from Excel. In the Change to, enter ~b~k for return and line feed.
Select Change All and choose Done.
image

8. Highlight the encoded data and select the IDAutomation2D font.
image

9. If the barcode has white horizontal lines, modify the spacing.
image
Adjust the spacing until it reaches the desired size square without spacing.

10. The 2D barcode is created.
image

Posted 116 day(s) ago

(0)
(0)
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (3)
I had the image setting guy (he uses InDesign) try to make it work by changing the font that came with the barcode generator, but it still didn't look right. Does this mean I need the Encoder part? All we purchased was the Native barcode generator for Excel (IDA125).

We are only using it for a sequential number. The new inserter we have uses a high speed camera & it picks up the 2d code faster & better than plain numbers.

Posted 117 day(s) ago

(0)
(0)
   Report Abuse
To save a 2D code in a CSV file you need to save the text formatted to the 2D font only. You will not be able to save images in a CSV file. The 2D text formatted to the font contains multiple lines and this can also be a problem for CSV files. If this information doesn’t help, let us know exactly what you’re trying to do and what application you were trying to create the barcode within and we’ll see if we can find a better solution.

Posted 117 day(s) ago

(0)
(0)
   Report Abuse
While you can save 2D encoded data using the first few steps available in this post, it is not practical to display a barcode in the CSV. If it is blank, review the steps in the tutorial to ensure the data is encoded.

Posted 117 day(s) ago

(0)
(0)
   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 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