Boffo as of version 1.6.0 filters the user's spreadsheet selection in the command for looking up barcodes. It filters out anything that doesn't have at least one digit. The only purpose of this particular filter is that I wanted to guard against the user selecting a whole column with a title. If they have a spreadsheet like
Our Barcodes
────────
0930950
0930951
0930952
...
etc., and they select the whole column instead of selecting just the cells containing barcodes, I wanted to filter out the text "Our Barcodes" (or whatever they might have written in the header row) because in the output, Boffo creates a new sheet where the first column has a title (and the title is "Barcodes").
In a conversation with Kyle Banerjee on the code4lib Slack on 2023-09-01, I learned that some other sites do have barcodes that have no digits in them. This would be a problem for Boffo, which would ignore those barcodes completely.
I'm not sure what the solution is going to be. Maybe there needs to be a user preference setting that allows them to say "allow anything" or something like that.
Boffo as of version 1.6.0 filters the user's spreadsheet selection in the command for looking up barcodes. It filters out anything that doesn't have at least one digit. The only purpose of this particular filter is that I wanted to guard against the user selecting a whole column with a title. If they have a spreadsheet like
Our Barcodes
────────
0930950
0930951
0930952
...
etc., and they select the whole column instead of selecting just the cells containing barcodes, I wanted to filter out the text "Our Barcodes" (or whatever they might have written in the header row) because in the output, Boffo creates a new sheet where the first column has a title (and the title is "Barcodes").
In a conversation with Kyle Banerjee on the code4lib Slack on 2023-09-01, I learned that some other sites do have barcodes that have no digits in them. This would be a problem for Boffo, which would ignore those barcodes completely.
I'm not sure what the solution is going to be. Maybe there needs to be a user preference setting that allows them to say "allow anything" or something like that.