XML/RSS problem.

Post Reply
gerry.odea
Posts: 98
Joined: Fri Sep 19, 2008 9:33 am

XML/RSS problem.

Post by gerry.odea »

I have the old version of texis. Ver 2.6 so I need to bring in the xml old school.

I usually use:

'recdelim >><item
multiple
field Title varchar />><title>\P=!</title>+ ""
field Link varchar />><link>\P=!</link>+ ""
'

but I have tried for hours to figure out how to pull this in with no luck. I only need the first
<title xml:lang="ru">need this</title> and
<link rel="alternate" type="text/html" title="story" href="need this">

Thanks, Gerry


<entry>
<id>tag:www.bbcrussian.com,2009-09-25:1727093</id>
<dc:identifier>1727093</dc:identifier>
<updated>2009-09-25T13:22:40+04:00</updated>
<published>2009-09-25T12:59:41+04:00</published>
<category xml:lang="ru" term="russian" label="russian" />
<category xml:lang="ru" term="international" label="&#1042; &#1084;&#1080;&#1088;&#1077;" />
<rights>not restricted</rights>
<title xml:lang="ru">"&#1041;&#1086;&#1083;&#1100;&#1096;&#1072;&#1103; &#1076;&#1074;&#1072;&#1076;&#1094;&#1072;&#1090;&#1082;&#1072;" &#1073;&#1091;&#1076;&#1077;&#1090; &#1082;&#1086;&#1086;&#1088;&#1076;&#1080;&#1085;&#1080;&#1088;&#1086;&#1074;&#1072;&#1090;&#1100; &#1084;&#1080;&#1088;&#1086;&#1074;&#1091;&#1102; &#1101;&#1082;&#1086;&#1085;&#1086;&#1084;&#1080;&#1082;&#1091;</title>
<summary xml:lang="ru">&#1041;&#1086;&#1083;&#1077;&#1077; &#1079;&#1072;&#1084;&#1077;&#1090;&#1085;&#1091;&#1102; &#1088;&#1086;&#1083;&#1100; &#1089;&#1090;&#1072;&#1085;&#1091;&#1090; &#1080;&#1075;&#1088;&#1072;&#1090;&#1100; &#1085;&#1072;&#1088;&#1086;&#1078;&#1076;&#1072;&#1102;&#1097;&#1080;&#1077;&#1089;&#1103; &#1101;&#1082;&#1086;&#1085;&#1086;&#1084;&#1080;&#1082;&#1080;, &#1082;&#1086;&#1090;&#1086;&#1088;&#1099;&#1077; &#1076;&#1086; &#1089;&#1080;&#1093; &#1087;&#1086;&#1088; &#1085;&#1072;&#1093;&#1086;&#1076;&#1080;&#1083;&#1080;&#1089;&#1100; &#1074; &#1090;&#1077;&#1085;&#1080; &#1088;&#1072;&#1079;&#1074;&#1080;&#1090;&#1099;&#1093; &#1075;&#1086;&#1089;&#1091;&#1076;&#1072;&#1088;&#1089;&#1090;&#1074;, &#1074;&#1093;&#1086;&#1076;&#1103;&#1097;&#1080;&#1093; &#1074; "&#1041;&#1086;&#1083;&#1100;&#1096;&#1091;&#1102; &#1074;&#1086;&#1089;&#1100;&#1084;&#1077;&#1088;&#1082;&#1091;".</summary>
<dc:subject>"&#1041;&#1086;&#1083;&#1100;&#1096;&#1072;&#1103; &#1076;&#1074;&#1072;&#1076;&#1094;&#1072;&#1090;&#1082;&#1072;", &#1084;&#1080;&#1088;&#1086;&#1074;&#1072;&#1103; &#1101;&#1082;&#1086;&#1085;&#1086;&#1084;&#1080;&#1082;&#1072;,</dc:subject>
- <link rel="alternate" type="text/html" title="story" href="http://www.bbc.co.uk/russian/internatio ... nomy.shtml">
<xhtml:link xmlns:xhtml="http://www.w3.org/1999/xhtml" rel="alternate" media="handheld" title="mobile-story" type="text/html" href="http://www.bbc.co.uk/russian/mobile/int ... nomy.shtml" />
- <media:content>
- <media:thumbnail url="http://www.bbc.co.uk/worldservice/asset ... 0_106i.jpg" width="106" height="60">
<img alt="&#1057;&#1080;&#1084;&#1074;&#1086;&#1083;&#1080;&#1082;&#1072; "&#1041;&#1086;&#1083;&#1100;&#1096;&#1086;&#1081; &#1076;&#1074;&#1072;&#1076;&#1094;&#1072;&#1090;&#1082;&#1080;"" width="106" height="60" src="http://www.bbc.co.uk/worldservice/asset ... 0_106i.jpg" />
</media:thumbnail>
</media:content>
</link>
- <link rel="related" type="text/html" title="story" href="http://www.bbc.co.uk/russian/internatio ... sity.shtml">
<xhtml:link xmlns:xhtml="http://www.w3.org/1999/xhtml" rel="related" media="handheld" title="mobile-story" type="text/html" href="http://www.bbc.co.uk/russian/mobile/int ... sity.shtml" />
- <media:content>
- <media:thumbnail url="http://www.bbc.co.uk/worldservice/asset ... med106.jpg" width="106" height="60">
<img alt="&#1052;&#1077;&#1076;&#1074;&#1077;&#1076;&#1077;&#1074;" width="106" height="60" src="http://www.bbc.co.uk/worldservice/asset ... med106.jpg" />
</media:thumbnail>
</media:content>
</link>
</entry>
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

XML/RSS problem.

Post by mark »

How about this:

field Title varchar />><title=[^>]*>\P=!</title>+ ""
field Link varchar />><link=[^>]*>\P=!</link>+ ""
gerry.odea
Posts: 98
Joined: Fri Sep 19, 2008 9:33 am

XML/RSS problem.

Post by gerry.odea »

No that didn't work either. For some reason images are showing up too. The link I am pulling it from is:
http://www.bbc.co.uk/russian/international/index.xml

I also tried:
'recdelim >><entry
multiple
field Title varchar />></rights>=\space*<title=[^>]*>\P=!</title>+ ""
field Link varchar />></dc:subject>=\space*<link=[^>]*>\P=!</link>+ ""
'

but that didn't work either. Appreciate any suggestions.

Thanks Gerry
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

XML/RSS problem.

Post by mark »

field Link varchar />><link=!href\=\x22+href\=\x22\P=[^\x22]+\F\x22 ""
Post Reply