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
wafiyy

How to solve GS1-128 encoding problem in EXCEL

I purchased UPC/EAN Font Advantage Package to work in Excel. Its quite OK

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

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

Suppose

1st I have to input 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 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 above string by IDAutomationC128 front, the barcode is not readable and return squares figures (as attached PHOTO)

Can you please advise with example for the above, whether you have any 100% OK / readable GS1-128 barcode solution in EXCEL from your any 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 string and bar are 100% same as earlier 1st method which have this problem.

So, kindly reconfirm how to solve the problem.

Best regards

Operating System: windows

Application: Excel

07-12-13     2107 day(s) ago    

  Report Abuse

 

James

Best Answer

2016 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.

Within IDAutomation products the parentheses is 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 within 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 do not take into account variable string elements which may require the parentheses to encode the FNC.

AIs Explained

Posted 2104 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 (1)

James
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 were used:

image

Produced a valid barcode:

image

Posted 2107 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