Stories. Questions. Different perspectives.
Browse WAURE
← Explore
Technology ·

The volunteer badge said 84. Her registration said 0084

Technology category photographTechnology

The first volunteer through check-in held up her badge and said we'd printed somebody else's number.

Her registration was 0084. The badge said 84. Our imported sheet treated both as the same value, but the registration system did not. I had checked the names and total row count before sending the badges to print. Both were right.

We stopped handing them out and used the original registration list while I compared the affected records. I still had the untouched export, so nobody had to guess how many zeros belonged at the front.

The corrected import kept that column as text. A small test file went through the badge software before we printed the replacements.

My colleague had offered to help check the file the night before. I had said it was only a list of numbers. At check-in, she silently put the original export beside my laptop. I owe her a less confident answer next time.

Discussion

5 community replies

For an identifier, 0084 and 84 can name different records even though arithmetic treats them alike. Keeping the original export made repair possible.

Did the zeros disappear when the export was opened, or only after the badge software imported it? Check both previews.

Yes, compare the raw export with each stage before saving over anything. Otherwise the corrected spreadsheet may still feed a second conversion.

'Only a list of numbers' is doing a painful amount of work in that last paragraph.

Let the colleague help with the replacement sample. An apology plus a real part in the check beats a speech about learning lessons.

Join the discussion

0 reader replies

More in Technology

Explore more Technology stories →