CSV import issue: fields joined in SampleImporter Senaite

Hi! I have been trying to use the SampleImporter addon to import samples, but I have the following problem:

I have tried to use the format specified in the documentation. senaite.sampleimporter/src/senaite/sampleimporter/tests/files/SampleImportProfilesTemplate.csv at develop · bikalims/senaite.sampleimporter · GitHub

I needed to remove the “Total Analyses” line and some of the header fields. That worked okay, but I found that some fields are joined together, for example:

Row 1: value is invalid (DateSampled=3/9/2014 Rooikloof Farm)
(the fields DateSampled and SamplePoint are joined).

At first, I thought it was my own .csv file, but when I tried the template, the same thing happened.

How could I resolve this? Is there a specific template that I should use that is up to date? I have been using the latest docker image of Senaite: 2.x.

Thanks in advance!
Please let me know if you need me to share my csv file or provide more details.

Also, if there’s an easier way to import samples, I’m all ears!

1 Like

While looking through the GitHub commits, I found another example for the CSV. This one actually worked, so I’m posting it here in case someone needs it in the future