Mapping XML files received from FileAdapter

20 views
Skip to first unread message

Gary

unread,
May 23, 2012, 6:52:54 AM5/23/12
to InterSystems: Ensemble in Healthcare
Hi All,

I am guessing that this may be a simple question to answer but it has
got me stumped at the moment, I am planing on receiving XML files via
the File Adapter but I am struggling to figure out how I could then
use these in a transformation.

If for example my XML file was as follows:

<?xml version="1.0" encoding="UTF-8"?>
<People>
<Person>
<Name>
<Forename>John</Forename>
<Surname>Smith</Surname>
</Name>
</Person>
<Person>
<Name>
<Forename>Jane</Forename>
<Surname>Smith</Surname>
</Name>
</Person>
</People>

How would I create a message in Studio that would match this to enable
transformations to occur within for example a BPL or a Routing Rule
etc?

Can anybody point me in the direction of the documentation which
explains this please, I am having no luck trying to figure it out?

Thanks,
Gary

David Loveluck

unread,
May 23, 2012, 7:35:48 AM5/23/12
to ensemble-in...@googlegroups.com
You have three choices.

1) You can import the XML as a Cache Object. Look at the documentation guide 'Using Caché XML Tools'
2) you can import the XML as An XML virtual document. This is new in 2012.1 and is more complete in 2012.2. See documentation guide 'Ensemble and XML Virtual documents'.
3) You can use XSLT.

Dave
--
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare Community" group.
To post to this group, send email to Ensemble-in...@googlegroups.com
To unsubscribe from this group, send email to Ensemble-in-Healt...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en

Marc Lang

unread,
May 23, 2012, 2:42:02 PM5/23/12
to ensemble-in...@googlegroups.com
I tend to get a schema for the XML, generate classes, and use correlate

Gary

unread,
May 24, 2012, 8:32:38 AM5/24/12
to InterSystems: Ensemble in Healthcare
Thanks Dave and Marc,

I will look into these, we are still currently on version 2009 so we
dont have the option yet to import the XML as a virtual document. We
are looking to upgrade to 2012 shortly so I guess it depends on which
comes first, the upgrade or the need to implement this solution as to
whether we go down the virtual document route.

Thanks again for your input.

Gary

On May 23, 7:42 pm, Marc Lang <marc.c.l...@gmail.com> wrote:
> I tend to get a schema for the XML, generate classes, and use correlate
>
> >http://groups.google.com/group/Ensemble-in-Healthcare?hl=en- Hide quoted text -
>
> - Show quoted text -
Reply all
Reply to author
Forward
0 new messages