Upgrade icd10 code set

Management and Administration
#61

after chown this AM, it is still not a go. However, it did solve my other problem with running sql_upgrade.php

#62

hi @CalvinTy, sorry, forgot you’re on 4.2.0, there’s some code level changes, you probably should upgrade to 5.0.0 and then do the icd10 upgrade

here’s the code change from 2016 2016 and 2017 ICD10 Updates

#63

Funny you brought that up. Here is my 5.0.1 version on my test environment.

Name: ICD10
Revision: CMS
Release Date: 2014-10-01
Staged Releases
2017-GEM-DC.zip
2017-GEM-PCS.zip
2017-ICD10-Code-Descriptions.zip
2017-PCS-Long-Abbrev-Titles.zip
2018-ICD-10-CM-General-Equivalence-Mappings.zip
2018-ICD-10-Code-Descriptions.zip
2018-ICD-10-PCS-General-Equivalence-Mappings.zip
2018-ICD-10-PCS-Order-File.zip

And here is my ICD codes on my 4.2.0 version

Installed Release
Name: ICD10
Revision: CMS
Release Date: 2014-10-01
Staged Releases
2018-ICD-10-CM-General-Equivalence-Mappings.zip
2018-ICD-10-Code-Descriptions.zip
2018-ICD-10-PCS-General-Equivalence-Mappings.zip
2018-ICD-10-PCS-Order-File.zip

There is no difference. I am so confused.

#64

never fear :tiger2: , let’s restore your confidence, on the test system please remove these files and see if you can upgrade

#65

thank you for troubleshooting this problem with me. I have removed all the 2017 files and ran the sql statement. No go either… I’ve been scratching my head so much, I got no hair left.

#66

:haircut_man: upload a screen shot of your test system and will keep debugging, thanks

#67

will do in the AM. Which screen shot would be most helpful to you?

#68

external data upload screen on the test system

#69

ExtLoad1.pdf (42.3 KB)

I hope this helps. I can’t do prtsc so I had to do it in PDF

#70

did you run the sql statement on the test system?

#71

isn’t this the same command you posted for me a few days back?

#72

I typed in your suggestion to be sure that we haven’t missed anything. It still doesn’t work.

#73

yup, you can check to see if the 4 files md5s are in that table with
mysql -u root -p openemr -e "SELECT * FROM supported_external_dataloads"

should see something like this

|      38 | ICD10     | CMS         | 2017-10-01        | 2018-ICD-10-PCS-Order-File.zip                   | 264b342310236f2b3927062d2c72cfe3 |
|      39 | ICD10     | CMS         | 2017-10-01        | 2018-ICD-10-CM-General-Equivalence-Mappings.zip  | 787a025fdcf6e1da1a85be779004f670 |
|      40 | ICD10     | CMS         | 2017-10-01        | 2018-ICD-10-Code-Descriptions.zip                | 6f9c77440132e30f565222ca9bb6599c |
|      41 | ICD10     | CMS         | 2017-10-01        | 2018-ICD-10-PCS-General-Equivalence-Mappings.zip | bb73c80e272da28712887d7979b1cebf |

±--------±----------±------------±------------------±-------------------------------------------------±---------------------------------+

#74

Holy cow, I have 6 sets of the 4 files…

#75

do you know how I can remove those extraneous duplicates?

#76

hi @CalvinTy, it may not be pretty but it’s ok to have duplicates, please post the output of
ls -lrt /var/www/html/openemr/contrib/icd10

#77

med@testbed:~$ ls -lrt /var/www/openemr/contrib/icd10
total 6708
-rw-r–r-- 1 www-data www-data 1640538 Mar 8 10:00 2018-ICD-10-PCS-Order-File.zip
-rw-r–r-- 1 www-data www-data 1114989 Mar 8 10:00 2018-ICD-10-CM-General-Equivalence-Mappings .zip
-rw-r–r-- 1 www-data www-data 2775671 Mar 8 10:00 2018-ICD-10-Code-Descriptions.zip
-rw-r–r-- 1 www-data www-data 1327378 Mar 8 10:00 2018-ICD-10-PCS-General-Equivalence-Mapping s.zip
med@testbed:~$

#78

thanks, are those typos in the *Mappings.zip files?

#79

Those are the names as it downloaded. I haven’t changed anything. What should it be?

#80

Those are the same name as in the sql command posted too