How to test transformation from Virtual Document to FLR

Question

Question

Werner Beukes · Jan 15, 2021

I just need to know if I can test a Virtual Document to a flat file transformation using the Test facility in the Tools tab of the Data Transformation Builder.

There is an example in Ensemble(ENSDEMO namespace), but that is for a Virtual Document to Virtual Document. I need to know the syntax in the Input box.

Discussion (14)1

Log in or sign up to continue

Marc Mundt · Jan 19, 2021

Can the customer provide you with a sample XML file?

If not, you can try something like this online tool which accepts an XSD file and generates a sample XML document with fake data according to the XSD schema.

Demo.HL7.MsgRouter.Schema:ORM_O01 really isn't applicable to your use case. Not worth spending your time on it.

0 0

score 0 · Answer 1 · 2021-01-15T09:15:53-05:00

Marc Mundt · Jan 15, 2021

What kind of virtual document? What class is the source message -- for example EnsLib.EDI.XML.Document?

0 0

score 0 · Answer 2 · 2021-01-15T10:28:11-05:00

Werner Beukes · Jan 15, 2021

Yes. Source class is EnsLib.EDI.XML.Document and target is RecordMaps.Cxxxx.CxxxCxxxxx.Record.

0 0

score 0 · Answer 3 · 2021-01-15T10:52:32-05:00

Marc Mundt · Jan 15, 2021

That makes it easy. You can just paste raw XML into the Input Message box in the testing tool.

0 0

score 0 · Answer 4 · 2021-01-15T11:28:48-05:00

I am a bit confused. If you look at the Ensemble Demo.HL7.MsgRouter.Schema:ORM_O01, which is a Virtual document to Virtual Document transformation, the data in the Input box looks like this, MSH:;~\&:ST01C:A:HNS:A:20041209100007::ADT;A08:26070901:P:2.2:26070901::AL:::::::2.2b

Should my source data not look like this?

score 0 · Answer 5 · 2021-01-15T11:38:50-05:00

That's an HL7 vdoc (EnsLib.HL7.Message) and that sample is HL7 code (though with strange delimiters).

So yes, if your input message is HL7 (EnsLib.HL7.Message) then you can just paste a raw HL7 message into the testing tool.

If your input message is XML (EnsLib.EDI.XML.Document) then you can just paste raw XML into the testing tool.

If your input message is an EnsLib.EDI.XML.Document and the message content is HL7 there's going to be a problem :)

score 0 · Answer 6 · 2021-01-15T12:01:31-05:00

I see my mistake now. The Demo is EnsLib.HL7.Message. My source is EnsLib.EDI.XML.Document. So the demo data format is useless in this case. Is there an example somewhere of a transformation of a class of this type?

score 0 · Answer 7 · 2021-01-15T12:05:25-05:00

Sorry. I need to be more specific. An example which contains test data in the Inbox for this specific type of transformation.

score 0 · Answer 8 · 2021-01-15T13:31:11-05:00

It looks like the ENSDEMO namespace doesn't have an example for XML v-docs.

The basic steps are:
- Import an XSD (XML schema) for the document format you need to work with:
https://docs.intersystems.com/healthconnectlatest/csp/docbook/Doc.View.c...

- In your DTL, select XML as the Source Type and for Source Document Type select the schema that you just imported

- The DTL editor will use the imported schema to display a document structure that you can use to visually build your mappings

At this point you can paste into the testing tool a sample XML that follows the XSD.

If you just want to do a quick test to see how this works, you can find a simple XSD online and import that. I found this sample which includes an XSD and sample XML that follows the XSD's structure:
https://www.w3schools.com/XML/schema_example.asp

score 0 · Answer 9 · 2021-01-15T14:53:08-05:00

Sir

Once again I do have to apologize. I did not give you enough information. I might have given you the impression that I do not know how to transform this particular type of class. All the steps that you described above, have been completed. It is just that I got stuck when I wanted to use the Test tool and I did not know how to input the test data for this particular type of class. It should be in order to use the link above to create my own input then?

score 0 · Answer 10 · 2021-01-15T15:51:26-05:00

No worries, it's always hard to understand from a forum post how far along someone is with their project.

Have you been given any sample XML files that adhere to the schema? If so, you can just copy the XML into the test tool window. If you do this, does it work?

One other question: what version of Ensemble or HealthShare are you using?

score 0 · Answer 11 · 2021-01-18T06:41:15-05:00

I am missing something. My input data is not giving me the results that I am expecting. I think it is the way I am inputting the XML. Lets say the source is EnsLib.EDI.XML.Document SMP_KPMAIN1:KPMAIN1 and their are 2 group levels within this document. SMP_GRP1followed by SMP_GRP2. Within SMP_GRP1 there are 3 fields. GRP1FLD1, GRP1FLD2 and GRP1FLD3. Under SMP_GRP2 there are 5 fields. GRP2FLD1- 5. My question is, do I have to specify the whole document structure in my XML, even though I only want to test the transformation of one field? E.g. GRP2FLD4. The other question is, what would the XML look like? Is it different from a flat file transformation? I just cannot get it right.

score 0 · Answer 12 · 2021-01-18T07:09:53-05:00

Werner Beukes · Jan 18, 2021

The example test data that they give in Ensemble Demo.HL7.MsgRouter.Schema:ORM_O01 just confuses me even more.

0 0

score 0 · Answer 13 · 2021-01-18T07:13:19-05:00

Werner Beukes · Jan 18, 2021

Regarding the version that I am using, it is Iris for Ubuntu 2018.1.2

0 0