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

How to solve GS1-128 encoding problem in EXCEL

I purchased UPC/EAN Font Advantage Package to work in Excel. It's quite OK

I am interested to work for GS1-128 in EXCEL
Another person who tried your software in Excel informed me that he is getting always errors like a return squares figures before each IA after scanning.

Can you show me a demo for the below code on how to generate GS1-128 in EXCEL?

Suppose

1st I have to input the below data in a text-formatted cell of Excel.
(01)02100004201880(00)048999607910604150(400)23983621

Then I have to click Code 128 button to change the above as below
=Code128("(01)02100004201880(00)048999607910604150(400)23983621")

The barcode string will come from above as below
ÍÊ!"*Â$42pÊÂ$yÇo*IRÊH"Gs^È1MÎ

After converting the above string by IDAutomationC128 front, the barcode is not readable and returns squares figures (as attached PHOTO)

Can you please advise with an example for the above, whether you have any 100% OK/readable GS1-128 barcode solution in EXCEL from your package?

Thanks and regards
Nasirul Huq
image

---------------------------------

Dear James

Thanks for your quick answer
By applying Tilde enabled (set to 1), Return Type = 0, reformat my data to ~2120102100004201880~21200048999607910604150~21340023983621

I found all barcode strings and bars are 100% the same as the earlier 1st method which has this problem.

So, kindly reconfirm how to solve the problem.

Best regards

Operating System: windows

Application: Excel

07-12-13     10.6 year(s) ago    

  Report Abuse

 

James

Best Answer

Within IDAutomation products, the parentheses are designed to encode the FNC. If the AIs that come after the first AI do not require an FNC, then you do not have to add parentheses around it. If you are required to identify the AIs, you could use a GS (Group Separator) created using ~029 right before your AIs. Unfortunately, I will not analyze every single value that you have. If your last string element is variable, then you will need to surround the data with parentheses to signify the FNC.

If your data does not have any variable element strings, then the data can be encoded as:
(01)021000042018800004899960791060415040023983621

or if you need to identify the AIs, it can be encoded as:

(01)02100004201880~02900048999607910604150~02940023983621

Note: The example does not take into account variable string elements which may require the parentheses to encode the FNC.

AIs Explained

ALTERNATE PRODUCT SOLUTION Update : A new product (Native Barcode Generator for Excel) has been released since this post was resolved that offers an easier method of generating barcodes in Excel.

When generating GS1 symbols, IDAutomation recommends testing the result with the Barcode Decoder App which parses out GS1 data to verify proper encoding.

Posted 10.6 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.
Other Answers (1)
If encoding in Excel, using parentheses for GS1-128 could cause Excel to interpret the data wrongly.

Instead, use the Tilde Method, with Apply Tilde enabled (set to 1), Return Type = 0, reformat your data to:

~2120102100004201880~21200048999607910604150~21340023983621

In this example, the IDAutomationC128M font at 12 points was used:

image

Produced a valid barcode:

image

Posted 10.6 year(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