Issue with Viewing Values in Care Plan Form After Importing External Codeset in OpenEMR 7.0.2

Hi,

Situation
I recently installed OpenEMR 7.0.2 on my local machine via Docker. In OpenEMR 7.0.2, I imported an external codeset from NLM, which was downloaded in XML format and sorted by the CMS ID column.
I then placed the downloaded VALUESET database ZIP file into the contrib/cqm_valueset directory and proceeded to install the dataset.
However, after completing these steps, I am unable to view the values when searching for the Care Plan Form.

OpenEMR Version
I’m using OpenEMR version 7.0.2

Browser:
I’m using: Google Chrome

Operating System
I’m using: Ubuntu 20.04.6 LTS

Thank you for your help and support in advance.

Hi @Jay1 , can’t reproduce on master codebase with ep_ec_only_cms_20200507.xml.zip.

1 Like

Note to verify code type in setup

Hi,

I imported the file ep_ec_only_cms_20200507.xml.zip and verified the Code Type, but no CQM ValueSets are appearing in the Care Plan form.

hi @Jay1 , do you have data in the valueset database table?

Hi @stephenwaite ,

The valueset table is currently empty.

does the apache error log in the openemr docker have any clues to why the import failed?

Error log from Docker :

install script does not exist. skipping InstModuleTable->installSQL for module, referer: http://localhost:8301/interface/modules/zend_modules/public/Installer

PHP Warning: simplexml_load_file(): /tmp/CQM_VALUESET/ep_ec_only_cms_20200507.xml.zip:1: parser error : Start tag expected, ‘<’ not found in /var/www/localhost/htdocs/openemr/library/standard_table
PHP Warning: simplexml_load_file(): PK\x03\x04\x14 in /var/www/localhost/htdocs/openemr/library/standard_tables_capture.inc.php on line 617, referer: http://localhost:8301/interface/code_systems/dataloads_ajax.php
PHP Warning: simplexml_load_file(): ^ in /var/www/localhost/htdocs/openemr/library/standard_tables_capture.inc.php on line 617, referer: http://localhost:8301/interface/code_systems/dataloads_ajax.php
PHP Warning: Attempt to read property “DescribedValueSet” on bool in /var/www/localhost/htdocs/openemr/library/standard_tables_capture.inc.php on line 618, referer: http://localhost:8301/interface/code_systems/dataloads_ajax.php
PHP Warning: foreach() argument must be of type array|object, null given in /var/www/localhost/htdocs/openemr/library/standard_tables_capture.inc.php on line 618, referer: http://localhost:8301/interface/code_systems/dataloads_ajax.php

PHP Warning: simplexml_load_file(): /tmp/CQM_VALUESET/ep_ec_only_cms_20200507.xml:1: parser error : Document is empty in /var/www/localhost/htdocs/openemr/library/standard_tables_capture.inc.php on line 617, referer: http://localhost:8301/interface/code_systems/dataloads_ajax.php
PHP Warning: simplexml_load_file(): in /var/www/localhost/htdocs/openemr/library/standard_tables_capture.inc.php on line 617, referer: http://localhost:8301/interface/code_systems/dataloads_ajax.php
PHP Warning: simplexml_load_file(): ^ in /var/www/localhost/htdocs/openemr/library/standard_tables_capture.inc.php on line 617, referer: http://localhost:8301/interface/code_systems/dataloads_ajax.php
PHP Warning: Attempt to read property “DescribedValueSet” on bool in /var/www/localhost/htdocs/openemr/library/standard_tables_capture.inc.php on line 618, referer: http://localhost:8301/interface/code_systems/dataloads_ajax.php
PHP Warning: foreach() argument must be of type array|object, null given in /var/www/localhost/htdocs/openemr/library/standard_tables_capture.inc.php on line 618, referer: http://localhost:8301/interface/code_systems/dataloads_ajax.php

hi @Jay1 , looks like there’s a problem with the file that you copied into the docker contrib/cqm_valueset folder

hi,

I got the file from NLM, but it seems to be problematic. Could you please share the file that is functioning correctly on your end?

Thank you.

Sorry @Jay1, the license prohibits sharing the files.

Hi,

In the valueset table, what do the nqf_code and valueset columns represent? What type of data do they refer to ?