If you have workbench installed, you can right click on the patient table to open a table import wizard. There you can select the table columns corresponding to the columns in csv to be imported.
I’ve used used this feature in some other project.
I did some improvements on the Spreadsheet Import module a while back. Here it is, let me know if you are interested because I will have to give you more instructions.
I’m doing data import from CSV for PIH Mexico. I’m using Initializer, for which I have some outstanding pull requests which allow it to import patients, encounters, and observations. I will also be implementing support for program enrollment soon.
I’m doing some old-fashioned data wrangling in R to transform the old CSVs to fit the format expected by Initializer.
The formats expected by Initializer (or “Iniz” as we affectionately call it) are likely to change between now and when they get merged, but if this is just a one-time import task, you could tie your work to a particular commit, as these data importers are already working.
To use Iniz, you’ll need to check it out and watch it, including it in your POM as a snapshot version. It’s not yet in the OpenMRS Maven repository. And anyway you’ll want this working version, assuming you’re wanting to implement this within the next month or so.
I came to realize these changes were very specific to the use case I was catering to at the time. Given the use case can be a recurring issue but what I did deviated from the main module promise. I have yet to summarize all the changes I did but before I can even submit the PR, I think I should at least articulate those changes and see if they make sense to everyone interested in this module.