To import data from OpenMRS, we just installed a jasper server. We plugged in the SQL query that we wanted into a jasper report. The report could then be downloaded to a csv, xls or pdf format.
The biggest problem we faced doing this is the EAV. We had to make multiple joins and our queries would be more than 3 pages long. On Wed, Apr 25, 2012 at 3:50 AM, Joaquín Blaya < [email protected]> wrote: > As Tobin mentioned, we're making the spreadsheet import module more easily > usable, but this probably won't happen for another month or so. > > Joaquín > ___________________________________________________________________ > Gerente de Desarrollo, eHealth Systems <http://www.ehs.cl/> > Research Fellow, Escuela de Medicina de Harvard <http://hms.harvard.edu/> > Moderador, GHDOnline.org <http://www.ghdonline.org/> > > > > On Tue, Apr 24, 2012 at 4:17 PM, Darius Jazayeri > <[email protected]>wrote: > >> You can also see what was discussed on the "Importing Data Into OpenMRS" >> University call. >> >> Notes: http://notes.openmrs.org/OpenMRS-University-2012-01-25 >> Recording: http://connect.iu.edu/p3mg19sn3jv/ >> >> -Darius >> >> >> On Tue, Apr 24, 2012 at 11:52 AM, Tobin Greensweig >> <[email protected]>wrote: >> >>> Hi Titi, >>> >>> This is a modified version of a python script that recently went out on >>> this list. I have made many permutations of it to import patients, >>> concepts, drugs, observations, and more. It takes some knowledge of the >>> OpenMRS information model ( >>> https://wiki.openmrs.org/display/docs/Data+Model) and is a bit hacky >>> but I've had good luck with it. >>> >>> I think Joaquín Blaya is working on updating the import module (which >>> will be fantastic). >>> >>> Tobin >>> >>> >>> >>> >>> On Tue, Apr 24, 2012 at 8:52 PM, Titi Tsholofelo >>> <[email protected]>wrote: >>> >>>> I need a help i want to import/upload some data from my old database >>>> into OpenMRS, i am getting errors as i having trying Spreadsheet import >>>> module. Any i dea on how i can do this. Just a guidance on how i can do >>>> that will help me a lot. I have atatched the spreadsheet which shows the >>>> variables in the sheet i want to upload. >>>> >>>> -- >>>> Titi T. Tsholofelo >>>> Office Tel:00267- 3632273 >>>> Mobile Phone:00267- 72623601 >>>> >>>> >>>> "*Psalm **121*" >>>> >>>> ------------------------------ >>>> Click here to >>>> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from >>>> OpenMRS Implementers' mailing list >>> >>> >>> >>> >>> -- >>> Tobin >>> ------------------------------ >>> Click here to >>> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from >>> OpenMRS Implementers' mailing list >>> >> >> ------------------------------ >> Click here to >> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from >> OpenMRS Implementers' mailing list >> > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list > -- Jonathan D. Galingan, MD Project Manager for Computerization Philippine General Hospital _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
