Values not in the Codelist

Values not in the Codelist

As a last resource (but really last resource), you can always edit the define.xml file manually using an XML editor or NotePad++, and add the values yourself.
Avoids you to have to go through multiple cycles of trial-and-error.
There are also GUI based Define-XML builders and editors on the market that work with WYSIWYG (what-you-see-is-what-you-get).

last resource

Hi Jozef,
I agree with you, updating the define.xml is the last option I wanted to do. It implies that each time we generate the define.xml, we have to manually update it. Moreover, it is not really traceable...
I would like to work with GUI, unfortunately, it is not the company's policy at the moment...
Any idea what could cause the issues?

Many thanks!

last resource versus GUI

I do have some ideas why the issue occurs, but will need a bit more details from you.
You can always contact me by e-mail.

Sergiy

on February 21, 2022

P21

Hi Tathoum,  Could you…

Hi Tathoum, 

Could you share your excel specs for diagnostics of this issue?

Thank you,
Sergiy
sergiy at pinnacle21 dot com

Sergiy

on February 22, 2022

P21

Hi Tathoum, I tried to…

Hi Tathoum, 

I tried to replicate your case and found a bug in P21 Define.xml Generator.

It looks like "Codelist" table should be sorted before generation of define.xml file. For example, if specifications for some codelist are split into 2 blocks separated by specs of other codelists, then only terms from the latter block of specs will be included into define.xml file.

See attached example. For CMCAT codelist, terms TEST1 and TEST2 will be present in define.xml, while terms like PSYCHOTROPHIC DRUG TREATMENT HISTORY will be skipped.

So, if your issue related to this bug, then a simple temporal solution is to sort "Codelists" table by ID prior generation of define.xml file.

Sorry for inconvenience and thank you for helping with identification of this bug! You are the first person who hits this issue since 2010. ;)

Kind Regards,
Sergiy