When I go to admin->other->database I get, “PHP 5.5+ is required.”
it means you should upgrade in the near future
so you’ll have to run the sql command another way, are you on windows?
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.
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");
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?
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.
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?
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
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…
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?
no, that’s good, let’s try your original approach
-
Open the XAMPP control panel.
-
Click Shell.
-
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");"
I will try that, but do I need to keep [ ] for username and dbname? Also, is dbname password?
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
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?
no, sorry, think we’re missing a double quote at the very end of the above posted command; i’ve corrected it
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!
I am using 4.2.0 on Ubuntu 12LTS and I can’t upgrade the ICD10 codes. Can you help me too?