Use function SerializerFactory.getDefaultSerializationProperties('EDI/X12'); in Mirth Connect

[trinhngocthuc]

I am using connector type: database reader in channel 1. Read data and DB, input is XML data type. 1 element named DocumentText contains EDI message and I want to convert the value in that element to xml but there is a problem that the ISA.16 field has value > so I can't use this function
SerializerFactory.getDefaultSerializationProperties('EDI/X12');
I hope everyone can help me.

var serializationProperties = SerializerFactory.getDefaultSerializationProperties('EDI/X12');

serializationProperties['elementDelimiter']= "*";
serializationProperties['segmentDelimiter']=">~";
serializationProperties['subelementDelimiter']= ":";

var edi = SerializerFactory.getSerializer('EDI/X12',serializationProperties,null).toXML(msg['documenttext'].toString());

[pacmano1]

If I understand correctly, your XML is invalid in the database. That > should be properly escaped.

[trinhngocthuc]

In raw data when query from DB is an XML data type. And in ISA.16 field it has value '>'. I want to keep the value '>', how can I do it? Please help me

[pacmano1]

Post screenshots.

Your question is not clear to me.

[trinhngocthuc]

var originalMessage = connectorMessage.getRawData();
var ChangeFormat = originalMessage.replaceAll('>', '>');
logger.info('ChangeFormat: ' + ChangeFormat);

var serializationProperties = SerializerFactory.getDefaultSerializationProperties('EDI/X12');

var serializer = SerializerFactory.getSerializer('EDI/X12', serializationProperties, null);
var xmlDoc = new XML(serializer.toXML(ChangeFormat));
logger.info('xmlDoc: ' + xmlDoc);

if (ChangeFormat['documenttext']) {
var documentText = ChangeFormat['documenttext'];
logger.info('documentText: ' + documentText);
}

Transformer error
ERROR MESSAGE: Error evaluating transformer
com.mirth.connect.server.MirthJavascriptTransformerException:
CHANNEL: 1_XML_EDI_Test
CONNECTOR: sourceConnector
SCRIPT SOURCE: TRANSFORMER
SOURCE CODE:
245: var serializationProperties = SerializerFactory.getDefaultSerializationProperties('EDI/X12');
246:
247: var serializer = SerializerFactory.getSerializer('EDI/X12', serializationProperties, null);
248: var xmlDoc = new XML(serializer.toXML(ChangeFormat));
249: logger.info('xmlDoc: ' + xmlDoc);
LINE NUMBER: 248
DETAILS: TypeError: The content of elements must consist of well-formed character data or markup.
at bfa3d476-e3c3-4885-b3ca-cdf2451824ea_JavaScript_Filter_Transformer_0:248 (doTransform)
at bfa3d476-e3c3-4885-b3ca-cdf2451824ea_JavaScript_Filter_Transformer_0:278 (doScript)
at bfa3d476-e3c3-4885-b3ca-cdf2451824ea_JavaScript_Filter_Transformer_0:280
at com.mirth.connect.server.transformers.JavaScriptFilterTransformer$FilterTransformerTask.doCall(JavaScriptFilterTransformer.java:235)
at com.mirth.connect.server.transformers.JavaScriptFilterTransformer$FilterTransformerTask.doCall(JavaScriptFilterTransformer.java:187)
at com.mirth.connect.server.util.javascript.JavaScriptTask.call(JavaScriptTask.java:114)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

How to fix? Please help me

[pacmano1]

Please use code formatting and format your code, see https://docs.github.com/en/get-started/writing-on-github/working-with-advanced-formatting/creating-and-highlighting-code-blocks

And post a sample message.

[trinhngocthuc]

Thank you. i did it. <3