2016 and 2017 ICD10 Updates

Management and Administration
#6

cmswest wrote on Tuesday, December 13, 2016:

hi David, please pardon the expression; the code change is compatible.

You’ll just take the sql statements

INSERT INTOsupported_external_dataloads(load_type,load_source,load_release_date,load_filename,load_checksum`) VALUES (‘ICD10’, ‘CMS’, ‘2016-10-01’, ‘2017-PCS-Long-Abbrev-Titles.zip’, ‘4669c47f6a9ca34bf4c14d7f93b37993’);

INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2016-10-01’, ‘2017-GEM-DC.zip’, ‘5a0affdc77a152e6971781233ee969c1’);

INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2016-10-01’, ‘2017-ICD10-Code-Descriptions.zip’, ‘ed9c159cb4ac4ae4f145062e15f83291’);

INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2016-10-01’, ‘2017-GEM-PCS.zip’, ‘a4e08b08fb9a53c81385867c82aa8a9e’);
`

and run them in phpmyadmin after you select the database, like in the attached

#7

hitechelp wrote on Tuesday, December 13, 2016:

Stephen, you are awesome. We’re golden here. Much appreciated.

Thanks again,
David

#8

cmswest wrote on Tuesday, December 13, 2016:

way to go! you’re welcome, glad to help, original author of external dataloads, * @author (Mac) Kevin McAloon mcaloon@patienthealthcareanalytics.com, contributed much to the ease of bringing these in every year

#9

hitechelp wrote on Tuesday, December 13, 2016:

We’ve lost ICD10 diagnosis code search capability in our fee sheets!
Yikes, now we can’t bill all! Help

Regards,
David

On Dec 13, 2016 1:05 PM, “Stephen Waite” cmswest@users.sf.net wrote:

way to go! you’re welcome, glad to help, original author of external
dataloads, * @author (Mac) Kevin McAloon mcaloon@
patienthealthcareanalytics.com, contributed much to the ease of bringing
these in every year

2016 and 2017 ICD10 Updates
https://sourceforge.net/p/openemr/discussion/202505/thread/3ad74165/?limit=25#51e8/b873

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/openemr/discussion/202505/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

#10

hitechelp wrote on Tuesday, December 13, 2016:

Spoke too soon!
Searching for ICD10 codes in the fee sheet returns nothing.

Regards,
David

On Dec 13, 2016 1:05 PM, “Stephen Waite” cmswest@users.sf.net wrote:

way to go! you’re welcome, glad to help, original author of external
dataloads, * @author (Mac) Kevin McAloon mcaloon@
patienthealthcareanalytics.com, contributed much to the ease of bringing
these in every year

2016 and 2017 ICD10 Updates
https://sourceforge.net/p/openemr/discussion/202505/thread/3ad74165/?limit=25#51e8/b873

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/openemr/discussion/202505/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

#11

cmswest wrote on Tuesday, December 13, 2016:

ok, no worries, did you make the code change?

from this

 -	    if (!stripos($filename, ".txt") || stripos($filename,"diff")) {

to this

 +	    if (!stripos($filename, ".txt") || stripos($filename,"diff") || stripos($filename, "addenda")) {
Upgrade icd10 code set
#12

hitechelp wrote on Tuesday, December 13, 2016:

No, I only ran the sql queries you sent.
Then went to the External Data Load page and updated.

#13

cmswest wrote on Tuesday, December 13, 2016:

oh, make the code change, empty the icd10_dx_order_code table under Operations in phpmyadmin and rerun the external data load,

#14

hitechelp wrote on Tuesday, December 13, 2016:

Just the code change in library/standard_tables_capture.inc or also the database.sql code change?

#15

cmswest wrote on Tuesday, December 13, 2016:

library/standard_tables_capture.inc

#16

hitechelp wrote on Tuesday, December 13, 2016:

Ok made the code change to library/standard_tables_capture.inc then emptied (truncated) the icd10_dx_order_code table using Operations in phpmyadmin but The External Data Load page still shows The installed version and the staged files are the same so it won’t allow me to rerun.

#17

cmswest wrote on Wednesday, December 14, 2016:

ok, remove the relevant icd10 entries in table: standardized_tables_track

#18

hitechelp wrote on Wednesday, December 14, 2016:

Thanks Stephen, I shall resume this endeavor tomorrow morning.

Regards,
David

On Dec 13, 2016 7:41 PM, “Stephen Waite” cmswest@users.sf.net wrote:

ok, remove the relevant icd10 entries in table:
supported_external_dataloads

2016 and 2017 ICD10 Updates
https://sourceforge.net/p/openemr/discussion/202505/thread/3ad74165/?limit=25#372c/5307

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/openemr/discussion/202505/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

#19

hitechelp wrote on Wednesday, December 14, 2016:

Clearing the icd10 entries in the standardized_tables_track table gave me an error on the External Data Load page that the staged files were invalid but, the answer was in the hover prompt (rerun the SQL Statements to re-populate the supported_external_dataloads table.) After that, the Update ran succesfully and it tested ok (fee sheet search for icd10 diagnostic codes is working now!)

Thanks a ton Stephen, and hats off to Kevin McAloon mcaloon@patienthealthcareanalytics.com, for making this critcally important function exceptionally user friendly. I suspect I would have had no problems if my system was at 4.2.2

It’s a good thing to have confidence in your ability to restore a backup, but a better thing to not have to.

Regards,
David

#20

cmswest wrote on Wednesday, December 14, 2016:

you’re welcome David

yes, the upgrade scripts would have handled this more gracefully, keep your eyes peeled for OpenEMR v5.0 coming soon!

#21

hitechelp wrote on Wednesday, December 14, 2016:

Will do!

Regards,
David

On Dec 14, 2016 9:54 AM, “Stephen Waite” cmswest@users.sf.net wrote:

you’re welcome David

yes, the upgrade scripts would have handled this more gracefully, keep
your eyes peeled for OpenEMR v5.0 coming soon!

2016 and 2017 ICD10 Updates
https://sourceforge.net/p/openemr/discussion/202505/thread/3ad74165/?limit=25#258b/123b

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/openemr/discussion/202505/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

#22

klassy wrote on Sunday, January 15, 2017:

Hello

I had problems installing ICD 10 codes using the bundled in 2016 codes on Openemr Ver 4.2.2 Decided to just load the new 2017 codes. Followed the string above but what i get is this :

Staged Releases
2017-GEM-DC.zip
UNSUPPORTED database load file:
2017-GEM-PCS.zip!
2017-ICD10-Code-Descriptions.zip
2017-PCS-Long-Abbrev-Titles.zip
The number of staged files is incorrect. Only place the files that you wish to install/upgrade to.
Follow these instructions for installing or upgrading the following database: ICD10?

I have run

INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2016-10-01’, ‘2017-GEM-PCS.zip’, ‘a4e08b08fb9a53c81385867c82aa8a9e’);

And re downloaded the 2017-GEM-PCS.zip file

How many staged files are there supposed to be?

#23

klassy wrote on Sunday, January 15, 2017:

ps. i have checked the checksum of the updated file

its now

bffcc0527415f506ddddeeab20faf11cd8c93c1e

#24

klassy wrote on Sunday, January 15, 2017:

p.s
New error!

Warning: mkdir(): Permission denied in /Applications/XAMPP/xamppfiles/htdocs/openemr/library/standard_tables_capture.inc on line 36
ERROR: Unable to copy the file

#25

cmswest wrote on Monday, January 16, 2017:

Hi Keletso, what value do you have for the temporary file directory?