senaite.core
senaite.core copied to clipboard
2-Dimensional CSV Data Import ignores "-"
Description
Importing data using the 2-Dimensional CSV interface seems to split string if the analysis keyword is using a "-" as part of the name
Reproduction guide
Using the following CSV import ignores the "-" while importing:
ID,HM-010_Ca,HM-010_Mg,end WM-0007,211,322, end
Observed behaviour
After import the protocol says that for the named analysis keyword "HM010_Ca" and "HM010_Mg" no data was found. This clearly shows that the "-" is deleted.
Screenshot

Last night I read up about this and I understand that this is the expected behaviour, since the Keyword needs to have the syntax of a valid identifier. The solution would be to create the service with the keyword "HM010_Mg", the translation won't change shape.
I'm making a little patch to include documentation of this sort (and specifically for each interface) in the UI.