FHIR Chat · convert PQA VS cqf tooling · cql

Stream: cql

Topic: convert PQA VS cqf tooling


view this post on Zulip Vasyl Herman (Apr 09 2021 at 09:43):

Hi,
Is it possible to convert PQA VS xlsx file into FHIR VS?
PQA VS

I am trying to run gradlew pqaXlsxToValueSet:

plugins {
  id 'java'
}

repositories {
  maven {url 'https://oss.sonatype.org/content/repositories/snapshots'}
}

dependencies {
  runtimeOnly 'org.opencds.cqf:tooling:1.3.1-SNAPSHOT'
}

task pqaXlsxToValueSet(type: JavaExec) {
  classpath = sourceSets.main.runtimeClasspath
  main = 'org.opencds.cqf.tooling.Main'
  args '-XlsxToValueSet', '-pts=./m_pqa_meas_yr_2020_stars_value_sets_20210225.xlsx', '-op=./vsd'
}
> Task :pqaXlsxToValueSet FAILED
Exception in thread "main" java.lang.IllegalArgumentException: -code flag must be specified
        at org.opencds.cqf.tooling.terminology.GenericValueSetGenerator.execute(GenericValueSetGenerator.java:253)
        at org.opencds.cqf.tooling.Main.main(Main.java:171)

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':pqaXlsxToValueSet'.
> Process 'command 'C:\Program Files\Java\jre1.8.0_271\bin\java.exe'' finished with non-zero exit value 1

I was wondering if anybody could help or point to a how to

view this post on Zulip Bryn Rhodes (Apr 09 2021 at 13:42):

The parameters to that operation are documented here: https://github.com/cqframework/cqf-tooling/blob/master/src/main/java/org/opencds/cqf/tooling/terminology/CMSFlatMultiValueSetGenerator.java#L12

view this post on Zulip Bryn Rhodes (Apr 09 2021 at 13:42):

Assuming the format has all that data, you should be able to just set those parameters.

view this post on Zulip Vasyl Herman (Apr 11 2021 at 07:30):

Hi, @Bryn Rhodes
Thank you for quick responding!

I inspected the xlsx file there are some Code System that don't exist in CodeSystemLookupDictionary: Medi-Span's Generic Product Identifiers (GPI), National Drug Code (NDC).

I wonder if there is a way to contribute. If yes then what is the first step on this way.

view this post on Zulip Bryn Rhodes (Apr 12 2021 at 13:09):

Hi @Vasil Herman , absolutely, if you're comfortable using github, feel free to submit a PR.


Last updated: Apr 12 2022 at 19:14 UTC