How to create a pipeline for converting CCDA (XML) document into Flatfile or CSV File using IRIS

Question

Question

isabella Barnes · Nov 16, 2023

Can someone share some details for creating a pipeline for converting CCDA (XML) document into Flatfile or CSV File using IRIS.

@Marc Mundt
@David Marcus
@Paul Lomayesva

Could you please help me out identifying the inbound and outbound adapters along with the DTL process for converting CCDA into CSV Files.

Thanks in advance!!
Isabella

Product version: IRIS 2022.1

Discussion (3)2

Log in or sign up to continue

score 0 · Answer 1 · 2023-11-17T02:17:40-05:00

We have a lot of documentation about XML transformations, you can start with this

My suggestion, try to get the schema of the CCDA (a XSD file) and import it into IRIS (Interoperate -> XML -> XML SCHEMA STRUCTURES) in order to work better with a Virtual Document based on your CCDA files. Then you can use regular DTL to transform it into another objects or directly access to each field of the document with methods as GetValueAt (documentation)

About the Inbound Adapters here is the documentation related and for the Outbound Adapter...if you want to export it into a flat file or a CSV any FileOperation would be enough.

score 0 · Answer 2 · 2023-11-17T16:58:16-05:00

@Luis Angel Pérez Ramos
When you say "My suggestion, try to get the schema of the CCDA (a XSD file)" do you mean by CCDA.XML file? if no then how i can get the aXSD file. I have only CCDA.xml file. Or can i generate this XSD file using the CCDA.xml file?

score 0 · Answer 3 · 2023-11-18T02:32:03-05:00

You can get the xsd from the xml (there are many web pages that can help you to do it). With your xsd you can follow the instructions from this documentation.