DSXchange

A short text to describe your forum
http://dsxchange.com./

xml file Name

http://dsxchange.com./viewtopic.php?f=24&t=154607

Page 1 of 1

xml file Name

Posted: Thu May 07, 2015 4:33 am
by Gius
Hello, I have a job that use the XML here down ( with a XML input )
I would like to fetch the value for => Field Name="entRecno"
But when I inport the XML or XSD I can not see this field,
do you now what can I do for this ?
thank You -

Code: Select all

  <?xml version="1.0" ?> 
- <MDSBroadcast>
- <BroadcastHeader>
  <locale>English (United States)</locale> 
  <timeZone>CDT</timeZone> 
  </BroadcastHeader>
- <MDSEvent>
- <EventHeader>
  <entType>per</entType> 
  <evtType>MEMBER UPDATED</evtType> 
  <triggerEvtType>MEMBER UPDATED</triggerEvtType> 
  <triggerEvtId>U</triggerEvtId> 
  <evtCreateDateTime>2014/09/24 16:38:23</evtCreateDateTime> 
  <triggerId>2:PO426397</triggerId> 
  <triggerMemRecno>26522616</triggerMemRecno> 
  <triggerAudRecno>26580123</triggerAudRecno> 
  <triggerUserName>mdmadmin</triggerUserName> 
  <msgCheckSum>3045376419886454121</msgCheckSum> 
  </EventHeader>
- <MDSObject Type="Member">
- <ObjHeader>
  <Field Name="memType">Policy</Field> 
  <Field Name="memberId">2:PO426397</Field> 
  <Field Name="memRecno">26522616</Field> 
  <Field Name="entRecno">13321076</Field> 
  <Field Name="memStat">A</Field> 
  <Field Name="mdsCTime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="mdsMTime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  <Field Name="srcCTime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="srcMTime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  </ObjHeader>
  <ObjData /> 
  </MDSObject>
- <MDSObject Type="View">
+ <ObjHeader>
  <Field Name="viewName">PEMCA</Field> 
  <Field Name="viewKind">E</Field> 
  <Field Name="memType">Policy</Field> 
  </ObjHeader>
- <ObjData>
- <MDSObject Type="Attribute">
- <ObjHeader>
  <Field Name="attrCode">PERADDR</Field> 
  <Field Name="memberId">2:PO426397</Field> 
  <Field Name="memRecno">26522616</Field> 
  <Field Name="memSeqno">3</Field> 
  <Field Name="asaIdxno">0</Field> 
  <Field Name="recStat">A</Field> 
  <Field Name="mdsCTime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="mdsMTime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  <Field Name="srcCtime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="srcMtime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  </ObjHeader>
- <ObjData>
  <Field Name="stLine1">121A TOPSHAM ROAD</Field> 
  <Field Name="stLine2">EXETER</Field> 
  <Field Name="stLine3" /> 
  <Field Name="stLine4" /> 
  <Field Name="city">EXETER</Field> 
  <Field Name="state" /> 
  <Field Name="zipCode">EA1 2PO</Field> 
  <Field Name="country">UK</Field> 
  <Field Name="geoText1" /> 
  <Field Name="geoCode1" /> 
  <Field Name="geoCode2" /> 
  </ObjData>
  </MDSObject>
- <MDSObject Type="Attribute">
- <ObjHeader>
  <Field Name="attrCode">PERNAME</Field> 
  <Field Name="memberId">2:PO426397</Field> 
  <Field Name="memRecno">26522616</Field> 
  <Field Name="memSeqno">8</Field> 
  <Field Name="asaIdxno">0</Field> 
  <Field Name="recStat">A</Field> 
  <Field Name="mdsCTime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="mdsMTime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  <Field Name="srcCtime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="srcMtime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  </ObjHeader>
- <ObjData>
  <Field Name="onmLast">POPE</Field> 
  <Field Name="onmFirst">JOHN</Field> 
  <Field Name="onmMiddle" /> 
  <Field Name="onmPrefix" /> 
  <Field Name="onmSuffix" /> 
  <Field Name="onmDegree" /> 
  <Field Name="onmTitle" /> 
  </ObjData>
  </MDSObject>
  </ObjData>
  </MDSObject>
  </MDSEvent>
- <MDSEvent>
- <EventHeader>
  <entType>per</entType> 
  <evtType>ENTITY UPDATED</evtType> 
  <triggerEvtType>MEMBER UPDATED</triggerEvtType> 
  <triggerEvtId>U</triggerEvtId> 
  <evtCreateDateTime>2014/09/24 16:38:23</evtCreateDateTime> 
  <triggerId>2:PO426397</triggerId> 
  <triggerMemRecno>26522616</triggerMemRecno> 
  <triggerAudRecno>26580123</triggerAudRecno> 
  <triggerUserName>mdmadmin</triggerUserName> 
  <msgCheckSum>1166946334105160712</msgCheckSum> 
  </EventHeader>
- <MDSObject Type="Entity">
- <ObjHeader>
  <Field Name="entRecno">13321076</Field> 
  <Field Name="entType">per</Field> 
  <Field Name="memCount">1</Field> 
  </ObjHeader>
- <ObjData>
  <Field Name="member">2:PO426397</Field> 
  </ObjData>
  </MDSObject>
- <MDSObject Type="View">
- <ObjHeader>
  <Field Name="viewName">PEMCA</Field> 
  <Field Name="viewKind">E</Field> 
  <Field Name="memType">Policy</Field> 
  </ObjHeader>
- <ObjData>
- <MDSObject Type="Attribute">
- <ObjHeader>
  <Field Name="attrCode">PERADDR</Field> 
  <Field Name="memberId">2:PO426397</Field> 
  <Field Name="memRecno">26522616</Field> 
  <Field Name="memSeqno">3</Field> 
  <Field Name="asaIdxno">0</Field> 
  <Field Name="recStat">A</Field> 
  <Field Name="mdsCTime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="mdsMTime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  <Field Name="srcCtime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="srcMtime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  </ObjHeader>
- <ObjData>
  <Field Name="stLine1">121A TOPSHAM ROAD</Field> 
  <Field Name="stLine2">EXETER</Field> 
  <Field Name="stLine3" /> 
  <Field Name="stLine4" /> 
  <Field Name="city">EXETER</Field> 
  <Field Name="state" /> 
  <Field Name="zipCode">EA1 2PO</Field> 
  <Field Name="country">UK</Field> 
  <Field Name="geoText1" /> 
  <Field Name="geoCode1" /> 
  <Field Name="geoCode2" /> 
  </ObjData>
  </MDSObject>
- <MDSObject Type="Attribute">
- <ObjHeader>
  <Field Name="attrCode">PERNAME</Field> 
  <Field Name="memberId">2:PO426397</Field> 
  <Field Name="memRecno">26522616</Field> 
  <Field Name="memSeqno">8</Field> 
  <Field Name="asaIdxno">0</Field> 
  <Field Name="recStat">A</Field> 
  <Field Name="mdsCTime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="mdsMTime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  <Field Name="srcCtime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="srcMtime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  </ObjHeader>
- <ObjData>
  <Field Name="onmLast">POPE</Field> 
  <Field Name="onmFirst">JOHN</Field> 
  <Field Name="onmMiddle" /> 
  <Field Name="onmPrefix" /> 
  <Field Name="onmSuffix" /> 
  <Field Name="onmDegree" /> 
  <Field Name="onmTitle" /> 
  </ObjData>
  </MDSObject>
  </ObjData>
  </MDSObject>
  </MDSEvent>
  </MDSBroadcast>

Posted: Thu May 07, 2015 5:39 am
by eostic
This is because entRecno isn't metadata...it is a "value". Unfortunately, this xml document isn't really using the tags in a way that would be most useful. We see this often when xml is required, but the time needed to fully model the data items wasn't available.

The metadata is an attribute called "Name"....within a repeating Element called "Field".

Described correctly in xmlInput, you will get "n" rows (one for each "Field") element, and they can/will have (at least) two columns:

Name
Field

Scan the rows later in a constraint to find all of your entRecno "rows", or else perform a pivot and turn those repeating "Field" rows into columns.

Ernie

Posted: Thu May 07, 2015 12:32 pm
by AshishDevassy
yea , The XML is not using the tags the way its supposed to.
If you are in UNIX or windows i would suggest just write a shell script to extract the records with entRecno. (from the look of things it looks like they are going to be on the same line)..
And use the output from that as an input.
Just a thought
All times are UTC-06:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited