I want to import excel data to OpenMRS

Tags: #<Tag:0x00007f0a29cbe730>

Dear great experts, Trust we are keeping safe?

I want to import data from excel to OpenMRS, but I wouldn’t know if this is possible.

I need your candid and urgent help.

Regards, Moses.

I have come a cross this https://wiki.openmrs.org/display/docs/Spreadsheet+Import+Module though I haven’t tried out the steps.

Thank you so much @jwnasambu for your swift response. I have seen this though but I thought it will require some coding or programming, and it only works with OpenMRS 1.9

Thinking if there is any possible way to do this without coding or programming.

1 Like

Hi Moses,

https://wiki.openmrs.org/display/docs/Spreadsheet+Import+Module+Version+2 - I noticed that this works via a direct database connection… are you (or is someone on your team) comfortable with database administration? There are quite a few tools which prepare insert or update statements from CSVs/XLS files.

If the spreadsheet import module doesn’t work for your particular version, you could use an integration platform like OpenFn to periodically fetch XLS or CSV files from some web-accessible location (Dropbox, an FTP site, etc.), parse those files, build the relevant records, and then load those records into OpenMRS. That will still require some configuration though, and depending on how complex your “jobs” are they may include some custom code.

Taylor

The module version 2 only works with OpenMRS 1.9.0 and no other version because this module inserts directly into the database yet @moses is running a 2.x version.

Thank you so much for your help. I will look at it and get back to you.