When we open .xml file in Notepad++ ,see below data (putting sample of it)
Line1 -
Code: Select all
<Proponix>
<Header>
<DestinationID>ABC</DestinationID>
<SenderID>PRO</SenderID>
<OperationOrganizationID>LANZ3073</OperationOrganizationID>
<MessageType>PRFADAT</MessageType>
<DateSent>20150618</DateSent>
<TimeSent>0000</TimeSent>
<MessageID>159649037</MessageID>
</Header>
<SubHeader>
<InstrumentID></InstrumentID>
<ActivityType></ActivityType>
<ActivitySequenceNumber></ActivitySequenceNumber>
<DocumentType></DocumentType>
<WorkItemNumber></WorkItemNumber>
<DocumentName>CURRENT, DCF_ABC_AB18062015</DocumentName>
<FaxPrintorData>D</FaxPrintorData>
<ReceiverFax></ReceiverFax>
<FaxSubject></FaxSubject>
<FaxComments></FaxComments>
<OnlineorTemporal>B</OnlineorTemporal>
<DistributeIndicator></DistributeIndicator>
<FinalorDraftorCopy>BOR</FinalorDraftorCopy>
<FileType>CSV</FileType>
<UserID>DCF-TOD-S-LANZ3073-HD</UserID>
<Product></Product>
<ProductType></ProductType>
<NumberofPages></NumberofPages>
<NumberofPrints></NumberofPrints>
</SubHeader>
<UserHeader>
<UserHeader1></UserHeader1>
<UserHeader2></UserHeader2>
<UserHeader3></UserHeader3>
<UserHeader4></UserHeader4>
<UserHeader5></UserHeader5>
</UserHeader>
<Body>
<CoreInformation>
Line3 - column names (separated by comma)
Line4 - Blank ie no data
Line5 - Data separated by comma
Line 6 - Blank ie no data
Line 7 - Data separated by comma
-
-
-
so on & so forth
How can we get DataState Read this file....
thanks