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, University of Tasmania Department of Medicine, Launceston General Hospital Charles Street Launceston 7250 Past President Australasian College of Health Informatics(2007-9) Visiting Professor, Universita di Modena, e reggio emelia, Italy (Sept-Nov 2010) Moderator: http://www.ghdonline.org/ <http://www.ghdonline.org/> Ph. 61 3 6348 7578 Mob. 0417 144 881 Fax 61 3 6348 7577 Email [email protected] <outbind://21-00000000CE6891EA9693784F8369C3F9F842586007004536092D6B1A81 40A17AEDB955662848000001418F68000077AB6B1EC4168B4D82A274505EB2163A0001B4 192C160000/[email protected]> Web/Blog: www.austemrs.com.au <http://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 Columbia University 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] <mailto:djazayeri%[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 <mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l> from OpenMRS Implementers' mailing list ________________________________ Click here to unsubscribe <mailto:[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 <mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l> from OpenMRS Implementers' mailing list -- Tobin ________________________________ Click here to unsubscribe <mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l> from OpenMRS Implementers' mailing list ________________________________ Click here to unsubscribe <mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l> from OpenMRS Implementers' mailing list Want to Get Healthy? The Tasmania 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 DISCLAIMER The 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. _________________________________________ 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]
