Did you know you can add multiple options to an option set in DHIS2 at once using a CSV file? ![]()
This can be helpful when you need to add many options that exceed 50 or more.
In this short video, I show how you can do it step by step:
Did you know you can add multiple options to an option set in DHIS2 at once using a CSV file? ![]()
This can be helpful when you need to add many options that exceed 50 or more.
In this short video, I show how you can do it step by step:
Nice work, @Mayamiko !
Thank you @ellen ![]()
Really helpful to see this contribution to the community @Mayamiko ! Thank you! ![]()
It is always a pleasure to do what has been done for me for others @Gassim. Thank you for being instrumental in this process
Good reminder! I also think that (as in things like the User Extended App from @eyeseetea and BIF from @BAO_Systems) if there was an easy csv download as a blank format in the metadata import/export, this is something that would be done a lot more. I can speak for myself at least that the (perhaps silly) point of having to find the exact name (perhaps also order? I know CSV import has been very specific in the past) has led me to doing this either more manually through the interface or by building out a json package.
That’s a really good point, and honestly, I can relate to your experience and I have run into this a couple of times.
The need to remember the exact column names (and sometimes the order) can make CSV imports feel harder than they should be, especially for someone who isn’t working with metadata every day. I think that’s why many people fall back to the UI or go the JSON route instead.
One of the reasons I leaned into the CSV approach is exactly what you mentioned, the learning curve. For many users, especially those without a programming background, working in Excel feels much more natural than editing JSON files.
To help with that, I’ve created a small repo with ready-to-use blank templates that already have the correct structure and naming. The idea is to remove that “guesswork” barrier so people can focus on just filling in their data rather than figuring out the format.
It would be great to hear your thoughts on whether something like this could help bridge that gap a bit!