Problem Setting up Drug data using CSV import

Ask OpenMRS
, ,
1

Application Name: Reference Application Version Number: 2.6.0

Question: My team and I are trying to use the /drug endpoint to get data and manipulate it for use in a DrugOrderComponent that we are working on. Problem is the endpoint returns empty responses meaning these is no drug data in our current dataset. I have tried to manually add drug data via the concept dictionary and that works, but it will take time and is not scalable. I have Drug data in .csv format. How can I upload this/ add this data to the standalone application?

2

Are you aware of this? https://wiki.openmrs.org/display/docs/Metadata+Sharing+Module

3

Yes @dkayiwa I checked it out and tried importing but the version 2.6.0 is currently not supported, so the import fails

4

What error did you get?

5

Screen Shot 2017-08-14 at 16.54.10.png2682×1742 681 KB
Screen Shot 2017-08-14 at 16.54.55.png2560×1864 900 KB

6

You could try leveraging the ‘drugs’ domain that is processed by our Initializer module.

  • This is an example for the drugs CSV file.
  • And here the ad-hoc concept drugs CSV that goes with it.
7

Screen Shot 2017-08-14 at 18.14.10.png1568×184 16.9 KB
This set of instructions do not work as the named repository does not exit. So I cloned the dev branch and this is the error I get when trying to install with maven:
Screen Shot 2017-08-14 at 18.15.59.png1638×952 1.14 MB

8

Until this is done, you may have to skip tests:

mvn clean install -Dmaven.test.skip=true

Disclaimer: All this is still under development.

1 Like
9

Thanks @mksd the error still persists. I think it can work once all dependancies and included.

10

Weird, you should clone and build Ext I18N beforehand in that case. Just for the sake of being able to build Initializer.

11

@upendo, one option is to install the CIEL concept dictionary. (Instructions are here.) This has both a lot of concepts, and also some drugs (I think it’s the WHO Essential medication list, or something).

12

I will try this and give inform you how it goes.

13

Thank you. The install was successful and the omod folder was generated. I will embark on an install tomorrow and tell you how this goes. Thanks again.

1 Like
14

@mksd, How do you install the built omod to the Openmrs instance?

15

@upendo, in the meantime Ext I18N was moved into an OpenMRS-owned repo, meaning that you can just rely on its snapshots safely from now on as they will be available on Nexus:

16

You can use the legacy admin UI interface at this URI: /openmrs/admin/modules/module.list Or you can just copy the OMOD file in the modules directory of your OpenMRS instance and then restart OpenMRS.

17

Screen Shot 2017-08-15 at 18.48.10.png3252×1486 634 KB
I have increased max_allowed_packet to 128M as defined here But this is the error I get.

18

Did you get a chance to look at this? https://wiki.openmrs.org/display/docs/Troubleshooting+Memory+Errors

19

Screen Shot 2017-08-16 at 10.43.14.png1150×52 12.5 KB
I found out that adding this to my openmrs-standalone-runtime.properties file increased the packet size. But I now get a new error message:
Screen Shot 2017-08-16 at 10.47.32.png2586×1530 647 KB
I am importing the from dropbox, is this the right way to do it?

20

Screen Shot 2017-08-16 at 11.57.40.png1134×150 71.2 KB
I am trying to update concept data but that is the error I am getting.