Upgrade icd10 code set

billing

(Jeff Guillory) #21

When I go to admin->other->database I get, “PHP 5.5+ is required.”


(Stephen Waite) #22

it means you should upgrade in the near future :slight_smile:
so you’ll have to run the sql command another way, are you on windows?


(Jeff Guillory) #23

No, my server is on Linux - Fedora.

My new server came in today. It has the newest Ubuntu Server Software on it.

I haven’t even got it out of the box. It will be my new OpenEmr Server.


(Stephen Waite) #24

very nice, ok, so you can run the mysql query from the command line

mysql -u [username] -p [dbname] -e "INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-PCS-Order-File.zip", "264b342310236f2b3927062d2c72cfe3"); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-CM-General-Equivalence-Mappings.zip", "787a025fdcf6e1da1a85be779004f670"); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-Code-Descriptions.zip", "6f9c77440132e30f565222ca9bb6599c"); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-PCS-General-Equivalence-Mappings.zip", "bb73c80e272da28712887d7979b1cebf");

(Max) #25

Timed out the first time. And the second time it succeeded? Does anyone have an idea why it may have timed out the first time?


(Stephen Waite) #26

might be php settings


(VL) #27

Hi Stephenwaite.
I am also trying to install ICD 10 on after fresh install of openEMR on Windows.
(after installing, I did follow the Securing OpenEMR page and erased some files. Is that a problem?)

I download 4 files you listed in the comments, and copied them in contrib/icd10.
When I go to administration -> Other -> External Data Loads and click on ICD10 tab it says,

UNSUPPORTED database load file:
2018-ICD-10-CM-General-Equivalence-Mappings.zip!
UNSUPPORTED database load file:
2018-ICD-10-Code-Descriptions.zip!
UNSUPPORTED database load file:
2018-ICD-10-PCS-General-Equivalence-Mappings.zip!
UNSUPPORTED database load file:
2018-ICD-10-PCS-Order-File.zip

So, I opened XAMPP (as administrator) and clicked on SHELL button on left, and typed the commands you specified as below:

mysql -u root -p openemr -e "INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (“ICD10”, “CMS”, “2017-10-01”, “2018-ICD-10-PCS-Order-File.zip”, “264b342310236f2b3927062d2c72cfe3”); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (“ICD10”, “CMS”, “2017-10-01”, “2018-ICD-10-CM-General-Equivalence-Mappings.zip”, “787a025fdcf6e1da1a85be779004f670”); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (“ICD10”, “CMS”, “2017-10-01”, “2018-ICD-10-Code-Descriptions.zip”, “6f9c77440132e30f565222ca9bb6599c”); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (“ICD10”, “CMS”, “2017-10-01”, “2018-ICD-10-PCS-General-Equivalence-Mappings.zip”, “bb73c80e272da28712887d7979b1cebf”);

It asks me for my password, so I typed in the password I set for mysql (which I set while I was following the steps specified in Securing OpenEMR page), and I get the error message below:

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax, check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘Order-File.zip, 264b342310236f2b3927062d2c72cfe3)’ at line 1

Could you help me with installing ICD10 on OpenEMR please?

I have almost no experience with programing…

Thank you.


(Stephen Waite) #28

can you try to cut and paste the sql at Upgrade icd10 code set in a mysql prompt?


(VL) #29

I tried the set of codes you originally listed at the top of this thread.
It gives me the following error message:

‘INSERT’ is not recognized as an internal or external command,
operable program or batch file.

Is this bad?


(Stephen Waite) #30

no, just not in the right environment, it might be easier to go to phpmyadmin
navigate to Admin->Other->Database select the openemr database, usually named openemr, by clicking on it near the top and pull up a sql query box (the tab to the right of Databases)

might want to make a backup just in case

Screenshot-2017-11-21 OpenEMR


(VL) #31

Well, when I go to Admin > Other > Database (and there is no arrow for more options at Database), I get the following message

I am so lost…


(Stephen Waite) #32

hi @AAACnA, did you install the OpenEMR XAMPP package ?


(VL) #33

Yes, sir.
And by that I mean, I went to the link below and followed Option number 1.

http://www.open-emr.org/wiki/index.php/OpenEMR_5.0.0_XAMPP_Package_Installation

Should I have followed the Option number 2?


(Stephen Waite) #34

no, that’s good, let’s try your original approach

  1. Open the XAMPP control panel.

  2. Click Shell.

  3. Type the following command

    mysql -u [username] -p [dbname] -e "INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-PCS-Order-File.zip", "264b342310236f2b3927062d2c72cfe3"); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-CM-General-Equivalence-Mappings.zip", "787a025fdcf6e1da1a85be779004f670"); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-Code-Descriptions.zip", "6f9c77440132e30f565222ca9bb6599c"); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-PCS-General-Equivalence-Mappings.zip", "bb73c80e272da28712887d7979b1cebf");"

(VL) #35

I will try that, but do I need to keep [ ] for username and dbname? Also, is dbname password?


(Stephen Waite) #36

no need to keep the brackets, your db name is openemr and the username and password is the mysql credentials

you could test connecting to the mysql engine first with

mysql -u root -p openemr

and then you should be prompted for the mysql password which might be empty so just hit enter


(VL) #37

I tried the commands you listed on XAMPP shell and it is giving me the following error message…

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘Order-File.zip, 264b342310236f2b3927062d2c72cfe3)’ at line 1

Did I do something wrong?


(Stephen Waite) #38

no, sorry, think we’re missing a double quote at the very end of the above posted command; i’ve corrected it


(VL) #39

It worked!
Right now I am trying to actually install the new codes…
AND IT WORKED!
It just finished installing the new ICD 10 codes!

Thank you very much for being so patient and resolve this problem with me!

Thank you!


(Calvin Ty) #40

I am using 4.2.0 on Ubuntu 12LTS and I can’t upgrade the ICD10 codes. Can you help me too?