ICD-10 2019 "Unsupported database load file"

hamd · February 18, 2019, 1:30am

Hi,

Trying to update the ICD-10 codes. The CMS site says there are no GEMS files. What am I doing wrong.

This is what the Export Database Import Utility screen says;

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

UNSUPPORTED database load file:
2019-ICD-10-CM-Code-Descriptions.zip!

UNSUPPORTED database load file:
2019-ICD-10-PCS-Order-File.zip!

Thank you,

Henry

stephenwaite · February 18, 2019, 2:27pm

the supported_external_dataloads table needs the md5 hashes of the 2 new zip files, see this sql insert statement

hamd · February 18, 2019, 6:17pm

Hi Stephen,
I’m running 5.0.1-6. Do you mean that I need to copy the green areas ( including insert to) into each of their respective files?

Thank you,
Henry

hamd · February 18, 2019, 6:23pm

And change line 28 in the php.version file from 262 to 263

stephenwaite · February 18, 2019, 7:29pm

think all you’ll need is to run the 2 mysql insert commands, can you get to a mysql prompt?

hamd · February 18, 2019, 11:02pm

I use webmin or ubuntu cmd line to access the system. Is there a separate cmd prompt for the database? No problem inserting those lines of codes in those files thru webmin.

stephenwaite · February 19, 2019, 2:34am

try this from the cmd line

mysql -u [username] -p[password] [dbname] -e “INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2018-10-01’, ‘2019-ICD-10-CM-Code-Descriptions.zip’, ‘b23e0128eb2dce0cb007c31638a8dc00’); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2018-10-01’, ‘2019-ICD-10-PCS-Order-File.zip’, ‘eb545fe61ada9efad0ad97a669f8671f’);”

hamd · February 19, 2019, 4:09pm

Hi Stephen,
Do you first;
~$ mysql -u [username] -p [dbname]
mysql >
Then input;
-e INPUT INTO …

Sorry mysql cmds are new to me.
Am I mistaken that the commit that you pointed to meant that these were code lines to add to those 2 files?
Trying to understand what is being done.

Thank you,

Henry

stephenwaite · February 19, 2019, 4:55pm

hi @hamd, it’s all one command, you can put your password right up against the -p like
-ppassword, just edited the post above

hamd · March 7, 2019, 4:54am

Hi Stephen,
Tried the cmd above and got the following;
-bash: syntax error near unexpected token ‘)’

Is it possible instead to insert those lines into the file sql/database.sql at lines 7150 and 7151 without using cmd line as you showed above?
That would be very easy for me to do.

Thank you,

Henry

stephenwaite · March 7, 2019, 2:39pm

hi @hamd, whoops, try this file, you will probably have to change username password

sup_ext_dat_load.txt (488 Bytes)

hamd · March 9, 2019, 4:14am

Hi Stephen,
Still no go.
Tried the cmd you suggested and get the following;
mysql : [Warning] Using a password on the command line interface can be insecure.

Does this mean that the cmd should be done from root (#) ?
Thank you
Henry

stephenwaite · March 9, 2019, 10:51am

pretty sure that means it worked

hamd · March 10, 2019, 2:45am

Hi Stephen,
Yes it changed Unsupported next to each the 2 files to the below.

There is no visible “UPDATE” button visible.
What is happening ?
Thank you,
Henry

hamd · March 10, 2019, 3:09am

Stephen,
I looked into the sql/database.sql file and do not see any change that has occurred. Looks like the below;

Not sure what is going on. Did I not update the previous external dataloads updates
correctly ?
(PS, Finally learned how to take a screenshot and put it into the forum.)
Thank you,
Henry

hamd · March 10, 2019, 6:01am

Double checked and the contrib/icd10 directory has all the files as shown below;

I have made all these changes on a appliance copy to be sure it all works out all right before working on the production appliance, just in case.
This method has served me well.

Thank you,
Henry

stephenwaite · March 11, 2019, 12:19pm

hi @hamd, it won’t update the script just the database. If you remove the 2018 files from contrib/icd10 you should be able to proceed

hamd · March 11, 2019, 5:01pm

Hi Stephen, how do I confirm that the 2018 update has been done? It’s saying that the latest install is the 2017. If that’s so, shouldn’t I remove the 2019 files, update the 2018, then put the 2019 files back in and update to 2019? Is there a file that shows what the latest update is?

Thank you,

Henry

stephenwaite · March 11, 2019, 5:42pm

if it says it’s 2017 then that is active in the system. It depends if you have old dates of service prior to 10-1-18 that might need the older version but most likely you can go straight to 2019.

hamd · March 13, 2019, 2:18am

Hi Stephen,
It worked!!!
Learned 5 things.

When External Database Import Utility “Installed Release” reads that the release date is 2017-10-01; It really means it’s the 2018-ICD-10 codes are loaded.
Likewise when it reads that the release date is 2018-10-01; It really means that the 2019-ICD-10 codes are loaded.

2)You can’t have 2 different code dates loaded in the contrib/icd10 file. It won’t let you update.

3)The mysql cmd file does require
“-p[password]” as you indicated.

“Staged Releases” means; These are the files sitting in the contrib/icd10 file. It doesn’t mean that they have or have not been loaded into your system.
When the Staged Release box says “the installed version and the staged files are the same”; It means exactly that, i.e. the files in the Staged Release (contrib/icd10 file) are already loaded into your system.

Thank you so much for your help!!
You and the OpenEMR team are truly incredible!!!

Henry