it’s that time of year again
this icd10 update is for dos >= 10-1-2017
you can go get the files from https://www.cms.gov/Medicare/Coding/ICD10/2018-ICD-10-CM-and-GEMs.html and place the files in the contrib/icd10 folder
then remove the 2017 files from that folder
then go to your favorite mysql prompt and run the following queries or copy and paste into the phpmyadmin sql query tool
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");
finally run the external data load script and …
you are good to go
1 Like
ptalerico
October 3, 2017, 3:53pm
3
Is the above process described by Stephen a shortcut for developers and code-saavy people, or can it also be done the way I did last year’s ICD10 update: “Administration: External Data Loads: ICD10”?
My plan was to do the latter, but I want to make sure I’m not going to destroy my database by doing so.
Also, the link in “Administration: External Data Loads: ICD10: Instructions” to the raw data feed release is apparently no longer active.
hi @ptalerico , you should follow my steps above; please make a backup before just in case
if you right click on [url](this location) and open in a new tab does it work?
ptalerico
October 4, 2017, 10:13am
5
Opening the link in a new tab did work, thank you. I’ll add that little tip to my arsenal of troubleshooting tips.
ptalerico
October 5, 2017, 2:28am
6
In the event that others are as clueless as me as to which of the many files on the CMS website are to be downloaded, I linked the files referenced in Stephen’s instructions (above) to what I believe are the correct files on the CMS website. Please correct me if I’m wrong.
Can we upgrade ICD-10 from web GUI, instead of method mentioned on top?
you first have to move the files into that directory, then you use the web gui
There is option available which says “Upgrade” Just refer attachment. I am just curious to find easiest method to upgrade ICD-10.
those are last year’s codes that were bundled with OpenEMR v5.0; these are the 2018 updated codes
Good work @stephenwaite ! Thank You & well done!
Wizard353
October 8, 2017, 10:13pm
14
I tried following the instructions described above, but got the following warnings (in red) when I prepared to load the October, 2017 version of the IDC-10 info through the Administration interface
UNSUPPORTED database load file:
Should I go ahead any way, or is there something I can fix?
1 Like
hi @Wizard353 , don’t forget to run the sql, Upgrade icd10 code set
nursejeff
October 10, 2017, 2:20am
16
Man I wish I knew what my “favorite mysql prompt” and “the phpmyadmin sql query tool” was.
NurseJeff
it’s under admin->other->database on v5.0
nursejeff
October 10, 2017, 2:23am
18
Will the External Database Import Utility unzip these files.
So all I have to do is get these files in the right folder delete the 2017’s and click “upgrade”
NurseJeff
yes, but you have to run that pesky sql command too before you click upgrade
nursejeff
October 10, 2017, 2:26am
20
Hi Stephen,
When I go to admin->other->database I get "admin->other->database, I get “PHP 5.5+ is required.”
Is that bad?
NurseJeff
