CCDA Parsing with TCL

[Devika Agarwal]

Hi,

I am working on a project where my end goal is to change the format of the incoming CCD to meet the end user specification requirements. I am writing a tcl proc that can read CCDA from the thread and parse out the elements/field values. Once I have the field values, I will send them to SQL database where it will be formatted according to the specs. I am using TDOM library in tcl but it isn’t working as expected. Does anyone know of a simpler way of doing this?

Thanks,

Devika

Topic

[Jim Kosloskey]

If it were me, I would use an Xlate converting the CCDA to another format then using TCL to invoke a Stored Procedure and ODBC to update the SQL Server DB.

As a matter of fact, I think I read somewhere in the Cloverleaf documentation a suggestion of using the GRM functions to work XML messages rather than try to parse.

I played around a little with using an Xlate against the CCD/CDA and it worked fine. This was some time ago so I expect this even works better in the newest releases of Cloverleaf.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Charlie Bursell]

I have never been a fan of TDOM.  Too slow and hard to use.

If you are just doing a few fields, regxp works great.  I will include an example from my level 3 classes.

However, if you are doing a lot, and especially if you must use the schema, Jim’s suggestion of using Xlate would be your best bet.

[Author]

Replies