Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 621
  • Last Modified:

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#)?
0
Kiran_M
Asked:
Kiran_M
  • 2
  • 2
1 Solution
 
McExpCommented:
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.
0
 
anarki_jimbelCommented:
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.

0
 
McExpCommented:
Could you post an example of the specific acord file you are looking to parse?
0
 
Kiran_MAuthor Commented:
Specifications have changed,Closing this.  

Thanks.
0
 
Kiran_MAuthor Commented:
Specifications changed.  Closing this question.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now