Resolved Questions

AConforti

DataMatrix is not decoded as GS1 DataMatrix

When using the Data Matrix Fonts, I have two different types of bar code on this document plus full encoded numbers and the Human Readables. The bar code in column B is a GS1-128 and works fine. The second bar code should be a GS1 DataMatrix. When scanned the first one comes up correctly. All the rest scan as just DataMatrix even though they are using the same the same formula.

Operating System: Mac 10.15.7

Application: Excel

03-19-25 9 day(s) ago

Report Abuse


debrac	Best Answer Hello April, When I review your Excel spreadsheet you are creating a formula to encode for the Data Matrix barcode that is not correct with the ~202 and the ~1. You need to take your data from column A for example in A2: ~202420554323568~202921879028574520121001~m21 and change that data so that the ~202 is no longer a ~202. You need to replace that with ~1 for the Data Matrix barcode type. The previous forum post you opened,~213 was just an example. You are using ~202 and you have to replace that with ~1. Please create a new column of data for your Data Matrix barcodes so that you aren't creating a formula to replace the FNC1 characters. Your new column of data should be using ~1 so your cell A2 in a new column for the Data Matrix would look like ~1420554323568~1921879028574520121001~m21 After you create a new column of data, then reference that only with your formula: =IDAutomation_DMatrix_FontEncoder(CELL) and remove the substitute that you have setup because it is not changing the FNC1 for you correctly to generate GS1 Data Matrix In order to simplify this for you, please set up columns in your spreadsheet specific to Data Matrix so they look like this: Posted 9 day(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet. Be the first to comment.

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

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

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

My Profile

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