Tags with leading 0 not loaded from excel correctly

[jezza323]

Tags with a leading 0 in the linked excel sheet don't load into CrossMgr with the leading zero

Have tried

0xxxxxxx
'0xxxxxxx
Formatted as text in excel

Same result for all

Submitting tags via webreader does accept/process as a leading zero as expected.

Tags in the unmatched excel match exactly those in the linked spreadsheet

Any tips to resolve?

[esitarski]

CrossMgr strips leading zeros to be compatible with Excel behavior, which also strips leading zeros from numeric input. As many people flow numeric tags in and out of Excel, and humans often skip leading zeros when repeating numbers, this led to many bugs as a result of integration issues. Best practice is not to use tags with leading zeros.

…

On Sun, Apr 30, 2023 at 7:30 AM jezza323 ***@***.***> wrote: I am using a custom reader and submitting raw epcs in hex format as my tags. Tags with a leading 0 in the linked excel sheet don't load into CrossMgr with the leading zero Have tried 0xxxxxxx '0xxxxxxx Formatted as text in excel Same result for all Submitting tags via webreader does accept/process as a leading zero as expected Any tips to resolve? — Reply to this email directly, view it on GitHub <#120>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABGXKM2FNEKBSPXRCFZDNLXDZEMHANCNFSM6AAAAAAXQ3RDUA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

-- Edward Sitarski

[jezza323]

Thanks for the confirmation. Not my tags unfortunately! I will modify my custom reader to strip leading zeros also instead 👍

[esitarski]

Recognized that this is a pain, but sooo many times all-digit hex tags when in-and-out of Excel and had the leading zeros deleted. Check that you don't have insanity where the number of leading zeros is significant (eg. 000ABC, 00ABC).

…

On Sun, Apr 30, 2023 at 8:02 AM jezza323 ***@***.***> wrote: Closed #120 <#120> as completed. — Reply to this email directly, view it on GitHub <#120 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABGXKPA7HF7UM3YGLGRYOTXDZIF5ANCNFSM6AAAAAAXQ3RDUA> . You are receiving this because you commented.Message ID: ***@***.***>

-- Edward Sitarski