Mirth XML CCD troubles

[jeffkirkley]

Hello everyone. I posted this on the Mirth forums site, but not sure if it is getting a lot of visibility.

***Disclaimer: I am VERY new to Mirth and HL7 and CCD. I have a general understanding, but this is my very first exposure to all of this.

Below is what I am trying to do:

I have the partial XML CCD snippet below:

 
<xml>
<document>
<ClinicalDocument xmlns="urn:hl7-org:v3" xmlns:xsd="https://www.w3.org/2001/XMLSchema" xmlns:xsi="https://www.w3.org/2001/XMLSchema-instance" moodCode="EVN">
<realmCode code="US"/>
<typeId extension="POCD_HD000040" root="2.16.840.1.113883.1.3"/>
<templateId root="2.16.840.1.113883.10.20.22.1.1"/>
<templateId root="2.16.840.1.113883.10.20.22.1.2"/>
<id extension="XXXXXXXXXXXXXXXXXXX" root="2.16.840.1.113883.3.929.4.158610.100"/>
<code code="34133-9" codeSystem="2.16.840.1.113883.6.1"/>
<title>Clinical Document</title>
<effectiveTime value="20230810134929"/>
<confidentialityCode code="N" codeSystem="2.16.840.1.113883.5.25"/>
<languageCode code="en-US"/>
<recordTarget contextControlCode="OP" typeCode="RCT">
<patientRole classCode="PAT">
<id assigningauthority="XXXXX" extension="0123456789" root="2.16.840.1.113883.4.290"/>
<addr>

I am trying to write in javascript in a Mirth destination transformer a code section to produce something similar to:

<xml>
<document>
<ClinicalDocument xmlns="urn:hl7-org:v3" xmlns:xsd="https://www.w3.org/2001/XMLSchema" xmlns:xsi="https://www.w3.org/2001/XMLSchema-instance" moodCode="EVN">
<realmCode code="US"/>
<typeId extension="POCD_HD000040" root="2.16.840.1.113883.1.3"/>
<templateId root="2.16.840.1.113883.10.20.22.1.1"/>
<templateId root="2.16.840.1.113883.10.20.22.1.2"/>
<id extension="XXXXXXXXXXXXXXXXXXX" root="2.16.840.1.113883.3.929.4.158610.100"/>
<code code="34133-9" codeSystem="2.16.840.1.113883.6.1"/>
<title>Clinical Document</title>
<effectiveTime value="20230810134929"/>
<confidentialityCode code="N" codeSystem="2.16.840.1.113883.5.25"/>
<languageCode code="en-US"/>
<recordTarget contextControlCode="OP" typeCode="RCT">
<patientRole classCode="PAT">
<id assigningauthority="XXXXX" extension="0123456789" root="2.16.840.1.113883.4.290"/> //shows original info
<id assigningauthority="YYYYY" extension="9876543210" root="2.16.840.1.113883.4.290"/> //shows modified info
<addr>

I have looked all over the boards here and on Google and have tried the various insertchildbefore, insertchildafter, and append routines, but nothing seems to want to play nice with the XML formatting/structure. For above, need both lines present in transformed output.

This is the javascript code I am running in a destination transformer:

var receiveMrn = msg['receivemrn'].toString()
channelMap.put('receiveMrn', receiveMrn);

var patientId = $('receiveMrn');
channelMap.put('patientId', patientId);

var assigningAuthority = msg['assigningauthority'].toString()
channelMap.put('assigningAuthority', assigningAuthority);

msg['document'].*::['ClinicalDocument'].*::['recordTarget'].*::['patientRole'].*::['id']['@extension'] = $('patientId');

msg['document'].*::['ClinicalDocument'].*::['recordTarget'].*::['patientRole'].*::['id']['@root'] = '2.16.840.1.113883.4.290';

msg['document'].*::['ClinicalDocument'].*::['recordTarget'].*::['patientRole'].*::['id']['@assigningauthority'] = $('assigningAuthority');

After a bunch of trial and error, I came up with the following:

<languageCode code="en-US"/>
<recordTarget contextControlCode="OP" typeCode="RCT">
<patientRole classCode="PAT">
<id assigningauthority="XXXXX" extension="0123456789" root="2.16.840.1.113883.4.290">
<id2 xmlns="" extension="2023-08-15" root="2.16.840.1.113883.10.20.22.1.1"/>
</id>
<addr>

var addTemplateId = new XML('<id2/>');

addTemplateId['@root'] = '2.16.840.1.113883.10.20.22.1.1';
addTemplateId['@extension'] = '2023-08-15';

var newValue = msg['document'].*::['ClinicalDocument'].*::['recordTarget'].*::['patientRole'].*::['id'].appendChild(addTemplateId);

​

My question now is how can I remove:

xmlns=""

[pacmano1]

Relevant forum link: https://forums.mirthproject.io/forum/mirth-connect/support/183749-how-to-copy-line-entry-in-xml-ccd-package

[jeffkirkley]

@pacmano1 Thanks for providing that. I never heard anything more on the Mirth forums site from you, so I posted here. Anything to add on how I can resolve getting rid of the xmlns entry?

[pacmano1]

I posted a working solution except for the fact your CDA is wrapped in extra tags. I would remove those tags entirely.

Since you went another direction, I deferred to others to help you as I will defer on your post here asking for a different soluton.

What is usually more helpful when you post is more detail. e.g. "I am picking up an XML file from disk that has a CDA in it wrapped in extra tags". In that case I would have suggested a preprocessor to strip those extra tags entirely, for example:

in the preprocessor:

var rawMessage = message;
rawMessage = rawMessage.replace(/<\s*xml\s*>/gi, '').replace(/<\s*\/\s*xml\s*>/gi, '');e
rawMessage = rawMessage.replace(/<\s*document\s*>/gi, '').replace(/<\s*\/\s*document\s*>/gi, '');
return rawMessage.trim();  // trim() to remove leading/trailing whitespaces if any

and again the code that already works:

var currentID = msg['recordTarget']['patientRole']['id'][0];
msg['recordTarget']['patientRole'].insertChildAfter(currentID, <id extension="AnotherExtension" root="AnotherRoot"/>);

[jeffkirkley]

@pacmano1 I appreciate your reply. Again, begging your pardon, but I literally do not know the ins and outs with all of this and am just trying to get it ti work. I understand what you said, but you are working with someone who has about 5 days of exposure to this system and yet I am trying to resolve a problem that should have been fixed yesterday.

I will take any and all coaching and assistance to try to get this to work in the proper way.

Thank you again.

[tonygermano]

In the mirth data type properties for most xml based connector types, there is an option to "strip namespaces."

https://docs.nextgen.com/bundle/Mirth_User_Guide_42/page/connect/connect/topics/c_HL7_v3_x_Data_Type_connect_ug.html

[jeffkirkley]

Scratch my last. I had to remove the hard-coded entries below and just go with what you offered. The output is now two separate lines.

WOW! THANK YOU!!!!!

I will continue to massage everything and report back here on the results.

[jeffkirkley]

So, one more tiny issue (hoping this can be easy to fix)......

For the sample output above (needed to assigningAuthority to the transformed output:

I have got the output looking correct, but the order of printed output is putting 'assigningAuthority' first in the list:

Is there a way to order this output for the new to put 'assigningAuthority' last on the line?

[tonygermano]

I'm pretty sure it always alphabetizes the properties, so likely the answer to that question is no.

[tonygermano]

Property order should not matter like element order often does.

[jeffkirkley]

I gotcha. I was thinking that was the case as well, but had to ask. Thanks.