Jonathan, I am surprised to hear that you tried the MVP dictionary and didn't speak to us at all about it. The purpose of the shared dictionary is NOT to create new concepts which are synonymous. We at CIEL have offered to help sites map their content to existing concepts or if you can't find necessary concepts to request them from us and we will add them (and then everyone benefits). I would appreciate knowing what where the 200-300 concepts you felt you needed to add.
As for disease coverage, I think we cover the vast majority of diseases and map these to ICD-10 and SNOMED CT. Again, if there is something missing, or a map is incorrect, the community would benefit if you would let us know. BTW, how did you get a copy of the MVP/CIEL dictionary? I don't see you on our registration list. I could go a long way in explaining why it is best not to create concepts on the fly. Maternalconceptlab.com is a great way to search the dictionary and in many cases the concepts already exist. Thanks for letting us know of your difficulties, Andy -------------------- Andrew S. Kanter, MD MPH - Director of Health Information Systems/Medical Informatics Millennium Villages Project, Earth Institute, Columbia University - Asst. Prof. of Clinical Biomedical Informatics and Clinical Epidemiology Columbia University Email: [email protected] Mobile: +1 (646) 469-2421 Office: +1 (212) 305-4842 Skype: akanter-ippnw Yahoo: andy_kanter >________________________________ > From: Jonathan Galingan <[email protected]> >To: [email protected] >Sent: Monday, April 16, 2012 6:48 PM >Subject: Re: [OPENMRS-IMPLEMENTERS] Import Concept dictionary CSV > > >Our government requires us to label our patients based on ICD-10 codes so that >they may be able to monitor the prevalence of certain diseases such as >cholera, dengue, measles, etc. Almost every doctor in our hospital agrees that >ICD-10 codes barely cover the diseases in their specialty but we know that >this helps our ministry of health allocate their resources to more prevalent >diseases. I heard that SNOMED covers more diseases but would require some fee. >Nevertheless, I think that the only way that these codes could be tweaked to >cover all diseases for better research is if clinicians themselves use it and >note the bugs. > > >In terms of using the MVP dictionary. I implemented it in one clinic and could >only use 10-20 concepts then I had to create around 200 to 300 more which were >highly synonymous to existing ones. This prompted to forego the MVP dictionary >in this present implementation as it would create a lot of confusion with the >employees and developers here. > > >If integration between OpenMRS implementations would occur, I think it is >easier to simply map concepts after than to restrict the creation while the >implementation is ongoing. > > >On Tue, Apr 17, 2012 at 5:22 AM, Hannan, Terry J ><[email protected]> wrote: > > >>Andy, this is a wonderful clarification of this issue. I would like to send this to members of our College (ACHI). May I have your permission? Terry >> >>Dr Terry J. Hannan MBBS;FRACP;FACHI;FACMI >>Consultant Physician >>Clinical Associate Professor School of Human Health Sciences, Universityof >>Tasmania Department of Medicine, Launceston General Hospital >>Charles Street Launceston 7250 >>Past President AustralasianCollegeof Health Informatics(2007-9) >>Visiting Professor, Universita di Modena, e reggio emelia, Italy (Sept-Nov 2010) >> >>Moderator: http://www.ghdonline.org/ >> >>Ph. 61 3 6348 7578 >>Mob. 0417 144 881 >>Fax 61 3 6348 7577 >>Email [email protected] >> >>Web/Blog: www.austemrs.com.au >> >>Skype: thehannans >> >> >>________________________________ >> >>From:[email protected] [mailto:[email protected]] On Behalf Of >>Andrew Kanter >>Sent: Monday, 16 April 2012 10:38 PM >>To: [email protected] >> >>Subject: Re: [OPENMRS-IMPLEMENTERS] Import Concept dictionary CSV >> >>Folks, I strongly advise not putting ICD-10 in your dictionaries for clinical use. ICD-10 is a classification, administrative terminology and is not designed for front-line clinical use. We (CIEL/MVP) include ICD-10 as mapped terminology but use separate concepts for actual data collection. For example, a patient does not present with "Other disease of blood and blood-forming organs". That can be a classification after the fact, but we should record what the patient actually has. You also have a problem if the text of the code or the code itself changes... that is why it is best to separate this from the actual concepts used in the record. Happy to discuss this more.... but quick and easy is not always best for long term sustainability and interoperability... >> >>Best, >>Andy >> >>-------------------- >>Andrew S. Kanter, MD MPH >> >>- Director of Health Information Systems/Medical Informatics >>Millennium Villages Project, Earth Institute, Columbia University >>- Asst. Prof. of Clinical Biomedical Informatics and Clinical Epidemiology >>ColumbiaUniversity >> >>Email: [email protected] >>Mobile: +1 (646) 469-2421 >>Office: +1 (212) 305-4842 >>Skype: akanter-ippnw >>Yahoo: andy_kanter >> >>> >>>________________________________ >>> >>>From:Tobin Greensweig <[email protected]> >>>To: [email protected] >>>Sent: Monday, April 16, 2012 2:25 AM >>>Subject: Re: [OPENMRS-IMPLEMENTERS] Import Concept dictionary CSV >>> >>> >>> >>>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 from OpenMRS Implementers' mailing list >>> >>> >>>________________________________ >>> >>>Click here to unsubscribe from OpenMRS Implementers' mailing list >>> >>> >>> >>> >>>-- >>>Jonathan D. Galingan, MD >>>Project Manager for Computerization >>>Philippine General Hospital >>> >>> >>>________________________________ >>> >>>Click here to unsubscribe from OpenMRS Implementers' mailing list >>> >>> >>> >>> >>>-- >>>Tobin >>> >>>________________________________ >>> >>>Click here to unsubscribe from OpenMRS Implementers' mailing list >>> Want to Get Healthy?The Tasmanian Government's Get Healthy Information and >>>Coaching Service(R) provides free information and coaching support to >>>Tasmanian adults who would like to learn healthier eating habits, be more >>>active or achieve and maintain a healthy weight. Call 1300 806 258 between >>>8am and 8pm, Monday to Friday or visit www.gethealthy.tas.gov.au for more >>>information."CONFIDENTIALITY NOTICE AND DISCLAIMERThe information in this >>>transmission may be confidential and/or protected by legal professional >>>privilege, and is intended only for the person or persons to whom it is >>>addressed. If you are not such a person, you are warned that any disclosure, >>>copying or dissemination of the information is unauthorised. If you have >>>received the transmission in error, please immediately contact this office >>>by telephone, fax or email, to inform us of the error and to enable >>>arrangements to be made for the destruction of the transmission, or its >>>return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.If the transmission contains advice, the advice is based on instructions in relation to, and is provided to the addressee in connection with, the matter mentioned above. Responsibility is not accepted for reliance upon it by any other person or for any other purpose. >> >>________________________________ >> Click here to unsubscribe from OpenMRS Implementers' mailing list >>________________________________ >> Click here to unsubscribe from OpenMRS Implementers' mailing list > > > >-- >Jonathan D. Galingan, MD >Project Manager for Computerization >Philippine General Hospital > >________________________________ > Click here to unsubscribe from OpenMRS Implementers' mailing list > > _________________________________________ 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]
