Hi again.
I’d like to be able to import lab results. The equipment can export data through CSV files and HIS.
I haven’t found much info about this but browsing Bahmni EMR there’s an option to import CSV data, however, I obviously need to map CSV headers to the corresponding fields in the bahmni database. Where should I do this?
Lab results can be added to Bahmni EMR (not the lab system). The csv headers are described in code here. I will try creating a sample csv file for you.
I tried a sample csv file but when uploading throws the following error:
Server Error : 32:28.csv� LabResultsRowIN_PROGRESS���superman2016-03-28 19:32:290000-00-00 00:00:00�' can not be represented as java.sql.Timestamp
Some fields I don’t know how they are interpreted (like Patient.name,Patient.Surname), but although there is an error (COMPLETED_WITH_ERRORS), there’s a new test showing in the patient’s profile (probably mapped correctly to the patient’s profile due to the Registration Number field?). although no test-result pairs are imported.
@decote
The matching of the patient record goes by Registration Number, You are right.
I took your sample file and made changes to the concept names and registration number as per my local db, its works fine. I have removed the extra EMPTY cells for Test and Result and it worked.
@shanmugam I’ve tested an import for an order of type OPD and the results are imported into bahmni. However, I need the results to be imported into openElis for validation and generate the report (in PDF).
This does not seem to be out of the box. Is there any possibility to import to openElis through the process you recommend?
Hi,
I think the correct approach would be to import in elis. The results would of course flow back to Bahmni EMR as well.
Just doing an internet search i noticed this…
https://haitilis.wordpress.com/page/2/
It seems someone has tried it and written some code as well to achieve it.
In context of elis, he mentions
We have taken a much more modest approach, most analyzers are able to export their results to a file and we have written the software which will import those files into OpenELIS
@decote
do you want to take a lead to connect with him to see if the software they have written is opensource and can be used for your purpose? It would be much easier to try it out with equipment available.