Hi Jonathan, This scrip is GREAT, thank you for sharing. I've been needing to make just this for the same purpose and avoiding it!
To get it to work for me I had to set the dilimeter of the csv.reader from 'rb' to 'U'. This may be because my csv file was produced with Excel on mac. Also, in the last part of your code you have source being specified as "1" which is SNOMED CT in the standard OpenMRS install. You mentioned ICD 10 so you might double check. I ended up using 8. I think that having sharing a metadata sharing export of all the code-able ICD-10 concepts would be very useful for implementers, does anybody know if this is allowed in terms of WHO licensing etc? Tobin On Mon, Apr 16, 2012 at 3:07 AM, Jonathan Galingan <[email protected]>wrote: > Hi, I made a short python script to insert the icd-10 codes from a csv > through mysql. If you're using ubuntu, just download the necessary MySQLdb > module for python and run the script while the csv file is in the same > directory. Change the parameters as necessary in the script. (The current > parameters are set to get the name of the code from the first column of the > csv while the code is placed on the second column) > > Then update the concept word table by clicking 'Update Concept Index' in > the Administration page. > > Its quite messy compared to using the webservices. I'll try to fix it once > I've gained more knowledge on how to use the webservices. > > On Fri, Apr 13, 2012 at 10:44 PM, Darius Jazayeri <[email protected] > > wrote: > >> Hi Titi, >> >> As far as I know there is no tool that does this. >> >> I think you would have to either write java code to parse the csv and >> create concepts via the API, or else do scripting to parse the csv and >> create concepts via web services. >> >> -Darius >> >> >> On Fri, Apr 13, 2012 at 6:43 AM, Titi Tsholofelo <[email protected]>wrote: >> >>> How can import concept dictionary CSV file into my system. >>> >>> -- >>> 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 >> >> >> ------------------------------ >> 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 > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list > -- Tobin _________________________________________ 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]
