Parsing Nested XML File Better Approach
Hi Expert,
I am having big XML File, Need to do followings:
1. Reading Entire XML.
2. Validate followings in XML:
# WellFormed XML
# CorrectDate Format.
# Field Values Etc.
3. Need to change the Value of few Tags.
4. Insert the Data inside DataBase
Since there various Ways to do this, What would be the best approach. Looking forward to hearing from you.
I am having big XML File, Need to do followings:
1. Reading Entire XML.
2. Validate followings in XML:
# WellFormed XML
# CorrectDate Format.
# Field Values Etc.
3. Need to change the Value of few Tags.
4. Insert the Data inside DataBase
Since there various Ways to do this, What would be the best approach. Looking forward to hearing from you.
Last Comment
Rose Babu
can you post the XML file and the tags details to be updated?
ASKER
Thanks for your reply..Here is the file....
<?xml version="1.0" encoding="UTF-8"?>
<!--Sample XML file generated by XMLSpy v2008 rel. 2 sp2 (http://www.altova.com)-->
<Envelope envelopeId="EMI" majorVersion="1" minorVersion="4" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocat
<Header>
<TransactionBlk actor="Next" mustUnderstand="1" name="StdTransBlk" majorVersion="1" minorVersion="2">
<MsgNm>MaintainGNAFraudDet
<MsgFormatCd>XML</MsgForma
<MsgMajVersionNbr>2</MsgMa
</TransactionBlk>
<SecurityBlk name="StdSecurityBlk" majorVersion="1" minorVersion="1" actor="Next" mustUnderstand="1">
<SAMLBlk>
<Assertion MajorVersion="1" MinorVersion="0" AssertionID="" Issuer="urn:aexp.com:applN
<AttributeStatement>
<Subject>
<NameIdentifier NameQualifier="urn:aexp.co
</Subject>
<Attribute AttributeName="" AttributeNamespace="">
<AttributeValue/>
</Attribute>
</AttributeStatement>
</Assertion>
</SAMLBlk>
</SecurityBlk>
</Header>
<Body>
<Request>
<RequestorId>IDN</Requesto
<OpCd>A</OpCd>
<MktCd>APA</MktCd>
<FRDCaseGrp>
<CaseNbr>A1234567890</Case
<CaseRelCnt>2</CaseRelCnt>
<LstAssgnRelNbr>1234</LstA
<DelAllRel>N</DelAllRel>
<RelGrp>
<RelNbr>1234</RelNbr>
<FRDRelGrp>
<PositiveMatchCnt>01</Posi
<CBORskInd1>X</CBORskInd1>
</FRDRelGrp>
<FRDRelGrp>
<PositiveMatchCnt>02</Posi
<CBORskInd1>X</CBORskInd1>
</FRDRelGrp>
<NoteGrp>
<NoteSeqNbr>01</NoteSeqNbr
</NoteGrp>
<NoteGrp>
<NoteSeqNbr>02</NoteSeqNbr
</NoteGrp>
<AddrGrp>
<AddrRskFlagInd>Y</AddrRsk
</AddrGrp>
<AddrGrp>
<AddrRskFlagInd>Y</AddrRsk
</AddrGrp>
<PhoneGrp>
<PhoneRskFlagInd>Y</PhoneR
</PhoneGrp>
<PhoneGrp>
<PhoneRskFlagInd>Y</PhoneR
</PhoneGrp>
<VarGrp>
<RelVarRskFlag>X</RelVarRs
</VarGrp>
</RelGrp>
<RelGrp>
<RelNbr>1234</RelNbr>
<FRDRelGrp>
<LstUpdtDt>02/04/2012</Lst
</FRDRelGrp>
<FRDRelGrp>
<PositiveMatchCnt>02</Posi
<SENbr>1234567890</SENbr>
</FRDRelGrp>
<NoteGrp>
<NoteSeqNbr>01</NoteSeqNbr
<NoteDesc>XXXXXXXXXXXXXXXX
</NoteGrp>
<NoteGrp>
<NoteSeqNbr>02</NoteSeqNbr
<NoteDesc>XXXXXXXXXXXXXXXX
</NoteGrp>
<AddrGrp>
<AddrTypeCd>S </AddrTypeCd>
<AddrLocatorCd>XXXXXXXXXXX
</AddrGrp>
<AddrGrp>
<AddrTypeCd>S </AddrTypeCd>
</AddrGrp>
<PhoneGrp>
<PhoneRskFlagInd>Y</PhoneR
</PhoneGrp>
<PhoneGrp>
<PhoneRskFlagInd>Y</PhoneR
</PhoneGrp>
<VarGrp>
<VarVal>XXXX</VarVal>
</VarGrp>
</RelGrp>
</FRDCaseGrp>
</Request>
</Body>
</Envelope>
<?xml version="1.0" encoding="UTF-8"?>
<!--Sample XML file generated by XMLSpy v2008 rel. 2 sp2 (http://www.altova.com)-->
<Envelope envelopeId="EMI" majorVersion="1" minorVersion="4" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocat
<Header>
<TransactionBlk actor="Next" mustUnderstand="1" name="StdTransBlk" majorVersion="1" minorVersion="2">
<MsgNm>MaintainGNAFraudDet
<MsgFormatCd>XML</MsgForma
<MsgMajVersionNbr>2</MsgMa
</TransactionBlk>
<SecurityBlk name="StdSecurityBlk" majorVersion="1" minorVersion="1" actor="Next" mustUnderstand="1">
<SAMLBlk>
<Assertion MajorVersion="1" MinorVersion="0" AssertionID="" Issuer="urn:aexp.com:applN
<AttributeStatement>
<Subject>
<NameIdentifier NameQualifier="urn:aexp.co
</Subject>
<Attribute AttributeName="" AttributeNamespace="">
<AttributeValue/>
</Attribute>
</AttributeStatement>
</Assertion>
</SAMLBlk>
</SecurityBlk>
</Header>
<Body>
<Request>
<RequestorId>IDN</Requesto
<OpCd>A</OpCd>
<MktCd>APA</MktCd>
<FRDCaseGrp>
<CaseNbr>A1234567890</Case
<CaseRelCnt>2</CaseRelCnt>
<LstAssgnRelNbr>1234</LstA
<DelAllRel>N</DelAllRel>
<RelGrp>
<RelNbr>1234</RelNbr>
<FRDRelGrp>
<PositiveMatchCnt>01</Posi
<CBORskInd1>X</CBORskInd1>
</FRDRelGrp>
<FRDRelGrp>
<PositiveMatchCnt>02</Posi
<CBORskInd1>X</CBORskInd1>
</FRDRelGrp>
<NoteGrp>
<NoteSeqNbr>01</NoteSeqNbr
</NoteGrp>
<NoteGrp>
<NoteSeqNbr>02</NoteSeqNbr
</NoteGrp>
<AddrGrp>
<AddrRskFlagInd>Y</AddrRsk
</AddrGrp>
<AddrGrp>
<AddrRskFlagInd>Y</AddrRsk
</AddrGrp>
<PhoneGrp>
<PhoneRskFlagInd>Y</PhoneR
</PhoneGrp>
<PhoneGrp>
<PhoneRskFlagInd>Y</PhoneR
</PhoneGrp>
<VarGrp>
<RelVarRskFlag>X</RelVarRs
</VarGrp>
</RelGrp>
<RelGrp>
<RelNbr>1234</RelNbr>
<FRDRelGrp>
<LstUpdtDt>02/04/2012</Lst
</FRDRelGrp>
<FRDRelGrp>
<PositiveMatchCnt>02</Posi
<SENbr>1234567890</SENbr>
</FRDRelGrp>
<NoteGrp>
<NoteSeqNbr>01</NoteSeqNbr
<NoteDesc>XXXXXXXXXXXXXXXX
</NoteGrp>
<NoteGrp>
<NoteSeqNbr>02</NoteSeqNbr
<NoteDesc>XXXXXXXXXXXXXXXX
</NoteGrp>
<AddrGrp>
<AddrTypeCd>S </AddrTypeCd>
<AddrLocatorCd>XXXXXXXXXXX
</AddrGrp>
<AddrGrp>
<AddrTypeCd>S </AddrTypeCd>
</AddrGrp>
<PhoneGrp>
<PhoneRskFlagInd>Y</PhoneR
</PhoneGrp>
<PhoneGrp>
<PhoneRskFlagInd>Y</PhoneR
</PhoneGrp>
<VarGrp>
<VarVal>XXXX</VarVal>
</VarGrp>
</RelGrp>
</FRDCaseGrp>
</Request>
</Body>
</Envelope>
ASKER
Want to update following Tags with new Values:
<MsgNm>MaintainGNAFraudDet
<MsgFormatCd>XML</MsgForma
<MsgMajVersionNbr>2</MsgMa
Pls Suggest.
Looking forward to hearing from you.
<MsgNm>MaintainGNAFraudDet
<MsgFormatCd>XML</MsgForma
<MsgMajVersionNbr>2</MsgMa
Pls Suggest.
Looking forward to hearing from you.
ASKER
Increasing the Points to 500.. Pls Help....
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thnanx Expert, Apologies for late response..
.NET Programming
The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.
137K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
