Cie10 Spanish External Data load

Hi everyone,
I would like to replace the ICD10 external data load with the cie10 (Spanish ) version of the same code. I am not a PHP developer. I have tried the following unsuccessfully:

  1. Adding my cie10_emr501.sql code into the contrib directory
  2. I have tried editing the files inside the 2022-code desciption.zip
    etc.

How should I tackle this issue? what PHP scripts should I focus on (e.g. icd10_howto.php, etc )
I don’t want to have to install PHPmy admin. I would like to incorporate the cie10 in my image.

Here is a snippet of my cie10_emr501.sql code

INSERT INTO codes (code,code_text, code_type)
VALUES
(‘A00’,‘Cólera’,113),
(‘A000’,‘Colera debido a vibrio cholerae o1, biotipo cholerae’,113),
(‘A001’,‘Colera debido a vibrio cholerae o1, biotipo el tor’,113),
(‘A009’,‘Colera no especificado’,113),
(‘A01’,‘Fiebres tifoidea y paratifoidea’,113),
(‘A010’,‘Fiebre tifoidea’,113),
(‘A011’,‘Fiebre paratifoidea a’,113),

Any help would be greatly appreciated.?

You can read this post, if you have doubts write me

Saludos
Luis

1 Like

Hi Luis,
Thank you for pointing me in the right direction, very much appreciated. How did manage to enter the accompanying files into the database without PHP my admin?
Thanks,

I have updated the code_types.inc.php as follow:
define_external_table($code_external_tables, 20, ‘cie10_diag’, ‘code’, ‘desc’, ‘desc_short’, array(“active=‘1’”,“valid_for_coding = ‘1’”), ‘revision DESC’);
define_external_table($code_external_tables, 21, ‘cie10_proced’, ‘code’, ‘desc’, ‘desc_short’, array(“active=‘1’”,“valid_for_coding = ‘1’”), ‘revision DESC’);

global $ct_external_options;
$ct_external_options = array(
‘0’ => xl(‘No’),
‘4’ => xl(‘ICD9 Diagnosis’),
‘5’ => xl(‘ICD9 Procedure/Service’),
‘1’ => xl(‘ICD10 Diagnosis’),
‘6’ => xl(‘ICD10 Procedure/Service’),
‘2’ => xl(‘SNOMED (RF1) Diagnosis’),
‘7’ => xl(‘SNOMED (RF1) Clinical Term’),
‘9’ => xl(‘SNOMED (RF1) Procedure’),
‘10’ => xl(‘SNOMED (RF2) Diagnosis’),
‘11’ => xl(‘SNOMED (RF2) Clinical Term’),
‘12’ => xl(‘SNOMED (RF2) Procedure’),
‘13’ => xl(‘CQM (Mixed Types) Value Set’),
‘14’ => xl(‘CQM OID Value Set’),
‘20’ => xl(‘CIE-10 Diagnósticos’),
‘21’ => xl(‘CIE-10 Procedimientos’),

);

lastly, I added to new Code types under Form -List:
CIe-10 115 CIE-10 Diagnostic
CIE10-PCS 116 CIE10 Procedimientos

Do you speak Spanish?

Saludos! Si Luis, hablo Espanol?
Intente agregue el cie10_diag,sql y el cie10_preced.sql al directorio:openerm\slq. Aditionalmente, contemple editar el database.sql y agregar estas parte:

Volcando estructura para tabla clinica.cie10_proced
CREATE TABLE IF NOT EXISTS cie10_proced (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
code varchar(10) DEFAULT NULL,
formatted_code varchar(7) DEFAULT NULL,
valid_for_coding char(1) DEFAULT NULL,
desc varchar(300) DEFAULT NULL,
desc_short varchar(60) DEFAULT NULL,
active tinyint(4) DEFAULT ‘0’,
revision int(11) DEFAULT ‘0’,
KEY PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=71975 DEFAULT CHARSET=utf8 COMMENT=‘CIE-10 Procedimientos’;

– Volcando estructura para tabla clinica.cie10_diag
CREATE TABLE IF NOT EXISTS cie10_diag (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
code varchar(10) DEFAULT NULL,
formatted_code varchar(7) DEFAULT NULL,
valid_for_coding char(1) DEFAULT NULL,
desc varchar(300) DEFAULT NULL,
desc_short varchar(60) DEFAULT NULL,
active tinyint(4) DEFAULT ‘0’,
revision int(11) DEFAULT ‘0’,
KEY PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=69824 DEFAULT CHARSET=utf8 COMMENT=‘CIE-10 Diagnósticos’;

– Volcando datos para la tabla clinica.cie10_diag: ~69.869 rows (aproximadamente)
DELETE FROM cie10_diag;
/*!40000 ALTER TABLE cie10_diag DISABLE KEYS */;
INSERT INTO cie10_diag (id, code, formatted_code, valid_for_coding, desc, desc_short, active, revision) VALUES

Hello. Yes, please excuse me. Those files had an error. Use the attached ones that are fine. If there is any table left, delete it and upload the two files again with phpmyadmin
Also change the code in code_types.inc.php as follows:

Spanish:
Hola. Si, por favor discúlpame. Esos archivos tenían un error. Usa los que adjuntos que están bien. Si quedo alguna tabla, borrala y sube de nuevo los dos archivos con phpmyadmin
Ademas cambia en código en code_types.inc.php como sigue:

// Definiciones CIE 10 en Español
// Modificado agregando Procedimientos y diagnósticos 2017-06-05
define_external_table($code_external_tables, 20, ‘cie10_diag’, ‘formatted_dx_code’, ‘long_desc’, ‘short_desc’, array(“active=‘1’”,“valid_for_coding = ‘1’”), ‘revision DESC’);
define_external_table($code_external_tables, 21, ‘cie10_proced’, ‘pcs_code’, ‘long_desc’, ‘short_desc’, array(“active=‘1’”,“valid_for_coding = ‘1’”), ‘revision DESC’);
//**** Fin Definiciones CIE 10

y

1 Like

Thank you for the information.