Upgrade icd10 code set

Management and Administration
#57

What do you think the permission problem? I have Ubuntu. Last check, everything is root “chown”. What is everyone’s file ownership?

#58

most everyone uses www-data:
also dbl check the file names match the sql statements

#59

I think that has been the problem with this whole ordeal. I’ll try it in the morning and will let the members here know. I am still puzzled in that during the installation process, when do people set their privileges to www-data. After install, I get root. Now, I need to refresh my memory on how to chown the directory and subdirectories… Crazy

#60

it’s usually the last step in securing the code base, chown -R www-data: /var/www/html/openemr works on current ubuntu

dbl check on 12.04, openemr might be under /var/www

#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