[yunqa.de] XML headache.

  • From: "Jon Burnham" <jba@xxxxxxxxxxxxxx>
  • To: <yunqa@xxxxxxxxxxxxx>
  • Date: Tue, 21 Feb 2012 17:20:49 -0000

Hi Ralf

I wondered if you could do me a quick huge favour again as I am pulling my
hair out. Again it’s a conceptual intro like you did before. I have the xml
response below.

The double data-tables and repeating rows are defeating me. Now I can’t see
the wood for the trees (literally). I want to extract the headers and rows,
once isolated, I can align them with the DIUnicode parser as I think I have
this working with the help you gave me last time.

Please could you give me a quick illustration as to the best way to handle
it with DIXml.

I know this is above the call of duty BTW.

Kind regards

Jon


=======================================================

<?xml version="1.0" encoding="UTF-8"?>

<http://enterprise.majesticseo.com/api_command?app_api_key=2536FA35F79CBE78D
4DF3B1CAE20462F&cmd=GetTopBackLinks&URL=http://www.google.com&MaxSourceURLs=
10&ShowDomainInfo=10> <Result FullError="" ErrorMessage=""
Code="OK"><GlobalVars ServerVersion="1.0.4429.26635"
ServerName="SILVERTHORNE" ServerBuild="2012-02-16 14:47:50"
RemainingStandardReports="950" RemainingRetrievalResUnits="20000000"
RemainingDetailedReportsPerPeriod="950"
RemainingAnalysisResUnits="100000000" IndexType="0"
ChargedRetrievalResUnits="10" ChargedAnalysisResUnits="5000"
AnalysisMode="AnalyseAllBackLinks"/>
<http://enterprise.majesticseo.com/api_command?app_api_key=2536FA35F79CBE78D
4DF3B1CAE20462F&cmd=GetTopBackLinks&URL=http://www.google.com&MaxSourceURLs=
10&ShowDomainInfo=10> <DataTables Count="2"> <http://enterprise.majesticseo.
com/api_command?app_api_key=2536FA35F79CBE78D4DF3B1CAE20462F&cmd=GetTopBackL
inks&URL=http://www.google.com&MaxSourceURLs=10&ShowDomainInfo=10>
<DataTable TotalMatches="10" TotalLines="50000" TotalBackLinks="3935215490"
BackLinkType="URL" BackLinkItem="http://www.google.com";
Headers="SourceURL|ACRank|AnchorText|Date|FlagRedirect|FlagFrame|FlagNoFollo
w|FlagImages|FlagDeleted|FlagAltText|FlagMention|TargetURL|DomainID"
RowsCount="10"
Name="URL"><Row>http://jquery.com|12|google|2012-01-21|0|0|0|0|0|0|0|http://
www.google.com|0</Row><Row>http://info.com|12|google|2012-01-21|0|0|0|1|0|0|
0|http://www.google.com|1</Row><Row>http://audacity.sourceforge.net|12|googl
e|2012-01-21|0|0|0|1|0|0|0|http://www.google.com|2</Row><Row>http://www.aabe
l.net|12|google|2012-01-21|0|0|0|1|0|0|0|http://www.google.com|3</Row><Row>h
ttp://www.mydrivers.com|12|
|2012-01-21|0|0|0|1|0|0|0|http://www.google.com|4</Row><Row>http://www.kerne
l.org|12|google|2012-01-21|0|0|0|1|0|0|0|http://www.google.com|5</Row><Row>h
ttp://myspace.com|12|
|2012-01-21|1|0|0|0|0|0|0|http://www.google.com|6</Row><Row>http://www.bangi
ngblackgays.com/?acc=85530987&rev=no|11|please click here to
exit|2012-01-21|0|0|0|0|0|0|0|http://www.google.com|7</Row><Row>http://www.z
h5000.com|11|google|2012-01-21|0|0|0|1|0|0|0|http://www.google.com|8</Row><R
ow>http://www.d7623.cn|11|谷歌
|2012-01-21|0|0|0|0|0|0|0|http://www.google.com|9</Row></DataTable>
<http://enterprise.majesticseo.com/api_command?app_api_key=2536FA35F79CBE78D
4DF3B1CAE20462F&cmd=GetTopBackLinks&URL=http://www.google.com&MaxSourceURLs=
10&ShowDomainInfo=10> <DataTable
Headers="DomainID|Domain|AlexaRank|RefDomains|ExtBackLinks|IndexedURLs|Crawl
edURLs|FirstCrawled|LastSuccessfulCrawl|IP|SubNet|CountryCode|TLD"
RowsCount="10"
Name="DomainsInfo"><Row>0|jquery.com|390|120420|13269281|2550730|397767|2006
-07-27|2012-01-21|70.32.73.125|70.32.73.0|US|com</Row><Row>1|info.com|5569|1
35354|7827738|1831523|184363|2006-06-26|2012-01-21|74.205.26.220|74.205.26.0
|UK|com</Row><Row>2|sourceforge.net|133|1722127|3728811757|37476953|7186447|
2006-06-21|2012-01-21|216.34.181.60|216.34.181.0|US|net</Row><Row>3|aabel.ne
t|-1|82953|165071|4091|2816|2006-10-11|2012-01-21|92.42.70.10|92.42.70.0|NO|
net</Row><Row>4|mydrivers.com|2442|142027|18989721|5094491|1262355|2006-06-2
6|2012-01-21|125.46.58.50|125.46.58.0|CN|com</Row><Row>5|kernel.org|9545|107
207|35010601|11246012|1220405|2006-07-01|2012-01-21|199.6.1.164|199.6.1.0|US
|org</Row><Row>6|myspace.com|70|3674256|5060421666|1136177683|29952669|2006-
06-20|2012-01-21|84.53.178.43|84.53.178.0|US|com</Row><Row>7|bangingblackgay
s.com|-1|24354|8792382|3244305|632418|2008-01-07|2012-01-21|66.115.173.46|66
.115.173.0|CY|com</Row><Row>8|zh5000.com|215768|32636|387939|189847|123401|2
006-06-29|2012-01-21|61.135.214.231|61.135.214.0|CN|com</Row><Row>9|d7623.cn
|-1|28708|56083|1843|1449|2010-01-30|2012-01-21|220.249.96.170|220.249.96.0|
CN|cn</Row></DataTable></DataTables></Result>

Other related posts: