Data Export to Excel for Evaluation

Hey Guys,

I want to export analysis results of a batch from Senaite into an Excel table. In the output, I would like to have the following columns:
| Batch | Sample ID | Date | Analysis | Result | Unit |

I have Senaite running on an Ubuntu Server in a Docker container. I installed the DataBoxes tool via the web interface. Unfortunately, I couldn’t figure out how to export samples and results in a comprehensive overview.

During my research, I couldn’t find any guide on this. Can someone help me with this?

Thanks for the support!

Hello Jan,

for some cases the export function of the batchbook can help.

Inside Databox you have to query the analyses and fetch some items from the parent sample.

But I didn’t find a proper filter function there myself yet, e.g. to limit the list to one particular batch or sample…

Hi Jan,

Did you follow the instructions in GitHub repo:

If yes can you elaborate more about the issues you face.

Regards,

1 Like

I’ve found it now. Looks like I couldn’t see the forest for the trees before lunch.

thx

Didn’t had a look on Git at that time. I will have a look on it! but actually i make a completly new setup. it was running in a docker container and i didn’t managed the backup at the end.

Seems i have to learn a bit more about Linux and run it without docker.