Kiran_M
asked on
How to parse an ACORD XML which can have muliple Transactions in it
I need to parse an ACORD xml which can contain mutiple transactions in it and update SQL Transaction tables with the each transaction.
I have not handled ACORD XML with mutiple transactions till now. Could you please suggest different approaches to do this (in C#)?
I have not handled ACORD XML with mutiple transactions till now. Could you please suggest different approaches to do this (in C#)?
I would load the XML file into an XML document. Write an appropriate XPath statement which extracts each transaction node and then "foreach" node make a UPDATE query against the database.
I am not sure if many people know how to do this. ACORD is quite a new standard.
Some companies products have support for ACORD XML, however this is not free, e.g
see INGENIUM .NET:
http://www.solcorp.com/products/net.htm
I don't really know the format and tasks to be solved. However xml is xml, and you may try to write your own library to handle specific ACORD formats. Eventually .Net has excellent support for xml.
Some companies products have support for ACORD XML, however this is not free, e.g
see INGENIUM .NET:
http://www.solcorp.com/products/net.htm
I don't really know the format and tasks to be solved. However xml is xml, and you may try to write your own library to handle specific ACORD formats. Eventually .Net has excellent support for xml.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Specifications have changed,Closing this.
Thanks.
Thanks.
ASKER
Specifications changed. Closing this question.