ICD10 spanish version?

Management and Administration
#5

Hi!
Yep, I did it but no luck
just english version
:frowning:

FER

#6

best resource http://www2.paho.org/hq/ contact info is at bottom of page

http://ais.paho.org/classifications/Chapters/

#7

Thanks so much
I’ll try to find a downloadable version, hope get same zip package to import it to my EMR5
Thks
FER

#8

Hi Fernando

did you get the ICD10 in Spanish?
because I need it too

I need to add icd-10 manually
#9

it looks like there may be a simple way to bring in the spanish translations from the above link, http://ais.paho.org/classifications/Chapters/

if you save each chapter as a text file and then write a little php script to try to read the icd10_dx table by the code and if successful update the short and/or long description

#10

Did anyone get the ICD10 in Spanish working on OpenEMR, Fernando? eliseoiie?

Thanks in advance!

#11

Not for now. follow this thread: I need to add icd-10 manually

#12

I have the Colombia CIE-10 version in XLS. But I’m a new user and cannot upload files.

#13

flagging @robert.down on this to see if he can get you access to be able to upload files on your posts

#14

Hi @josefflo,

I made you a regular user, try uploading now. Let me know if you are still having trouble.

Thanks,
Robert

#15

I’m trying to attach the file and kept receiving an error message “Sorry, you must provide a file to upload.”

It can be found in this URL https://drive.google.com/drive/u/0/folders/0B7_uSv9d5oj_MHB2UGNlMWxFUms

#16

Jose, thanks for sharing, the link asks for your permission.
Spanish: “Jose, gracias por compartir, el enlace me solicita tu permiso”.

#17

Hello,
It was possible to solve the translation of the CIE10, because I also have this problem, my name is Josue Caycho, I am from Peru and I am beginning to familiarize myself with this software.
Thanks a lot.

#18

Hola Jose !
Tambien busco esa version de CIE10 en español, tuviste suerte ?
vivo en Lima
FER

#19

Hola @Fernando_Guerra . Instale la versión en inglés que viene con Openemr desde Admin->código->Carga Datos Externo. Luego reemplace en la Base de Datos estos dos archivos que adjunto. Debe reemplazar las tablas icd10_pcs_order_code y icd10_dx_order_code. A los códigos los baje del Ministerio de Salud de España Ultima version 2022: eCIE-Maps - Documentación
Adjuntos:
icd10_dx_order_code.zip - pCloud
icd10_pcs_order_code.zip - pCloud
Saludos.
Luis de Argentina.

Cie10 Spanish External Data load
#20

Hola Luis !
En principio gracias por contestar y tan rapido sobretodo.
Una consulta, cuando hablas de REEMPLAZAR implica que debo usar DROP ?? o quizas pueda renombrarlas solamente?
Gracias
FER

#21

@Fernando_Guerra , mejor cambia el nombre a las tablas originales para resguardo y luego ejecuta los script sql que te envié. Crearán tablas nuevas.
Saludos.
Luis
(Sorry to the forum for writing in Spanish)

#22

Thanks so much Luis, I’ve just installed OpenEMR v7 in a hosting space, I’m so happy ! First I’ll try it in my local VirtualBox Ubuntu 20 then I’ll let you know

Muchas gracias Luis un fuerte abrazo

2 Likes
#23

It works ok !
Thanks !!!

1 Like
#24

Thank you Luis,

This scripts will replace “english version” of ICD10. In my case, I am running MariaDB in my server, I can connect to it using DBeaver.

I had to drop table and create it again. I noticed that some codes exceeds 7 characters, so I modified the column size to 10.

I recommend to drop the table as first step

DROP TABLE IF EXISTS icd10_dx_order_code;

DROP TABLE IF EXISTS icd10_pcs_order_code;

Then create it again

CREATE TABLE icd10_dx_order_code (
  dx_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  dx_code varchar(10) DEFAULT NULL,
  formatted_dx_code varchar(10) DEFAULT NULL,
  valid_for_coding char(1) DEFAULT NULL,
  short_desc varchar(60) DEFAULT NULL,
  long_desc text DEFAULT NULL,
  active tinyint(4) DEFAULT 0,
  revision int(11) DEFAULT 0,
 UNIQUE KEY dx_id (dx_id),
 KEY formatted_dx_code (formatted_dx_code),
 KEY active (active)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE icd10_pcs_order_code (
  pcs_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  pcs_code varchar(10) DEFAULT NULL,
  valid_for_coding char(1) DEFAULT NULL,
  short_desc varchar(60) DEFAULT NULL,
  long_desc text DEFAULT NULL,
  active tinyint(4) DEFAULT 0,
  revision int(11) DEFAULT 0,
  UNIQUE KEY pcs_id (pcs_id),
  KEY pcs_code (pcs_code),
  KEY active (active)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

and then run the batch insert script.

2 Likes