Visual Web Ripper Logo Visual Web Ripper Logo
Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
How can I eliminate this?
Options
Previous Topic Next Topic
Jacobos
#1 Posted : Monday, February 07, 2011 6:02:46 PM
Groups: Registered
Joined: 10/5/2010
Posts: 15
Location: Europa

Hello guys,

I am building an extraction project in XML, to daily feed my own Website with XML flow or feed:





I get this kind of XML:
Quote:
- <column name="ListaCiudades">
- <![CDATA[ A Coruña
]]>
</column>
- <column name="Title Tag">
- <![CDATA[ Imprime tus mejores fotos en lienzo y decora con ellas tu casa. Cupón de 44,50 euros por valor de 89 para HolaLienzo.es
]]>
</column>
- <column name="Face Value">
- <![CDATA[ 44,50 €
]]>
</column>
- <column name="Savings Percent">
- <![CDATA[ 50%
]]>
</column>
- <column name="Price">
- <![CDATA[ 44,50 €
]]>
</column>
- <column name="Imagen">
- <![CDATA[ G:\VWR - VIUAL WEB RIPPER - VWR\Resultados extracción GROUPON - 7feb2011\1291995407611.jpg
]]>
</column>
- <column name="Imagen_url">
- <![CDATA[ http://static.es.groupon...11/76/1291995407611.jpg
]]>


How can I eliminate this " <![CDATA[ ". I just need the tag or column name, and the data, of course!


Many thanks in advance and regards,


Jacobos,
Back to top
Report?
Sequentum Support
#2 Posted : Monday, February 07, 2011 6:23:09 PM

Groups: Administrators
Joined: 4/10/2010
Posts: 1,239
Location: Sydney, Australia
CDATA is part of the XML specification and you cannot get rid of it, since it would lead to invalid XML in many scenarios. If you are using an XML parser to parse the output, you'll not need to worry about the CDATA part.
Back to top
Report?
Jacobos
#3 Posted : Tuesday, February 22, 2011 5:54:16 AM
Groups: Registered
Joined: 10/5/2010
Posts: 15
Location: Europa
Hi, I understand this comment, but:

Being created VWR project, checking the output XML as data source. The resulting XML has the following format:


Code:
<?xml version="1.0" encoding="UTF-8"?>
    <data_project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
        <table name="Groupon">
            <rows>
                <row>
                    <columns>
                        <column name="titulo_C"><![CDATA[Descuento de hoy: Imprime tus mejores fotos en lienzo y decora con ellas tu casa. Cupón de 44,50 euros por valor de 89 para HolaLienzo.es]]></column>
                        <column name="precio_C"><![CDATA[Precio: 44,50 €]]></column>
                        <column name="descuento_C"><![CDATA[50%]]></column>
                        <column name="ahorro_C"><![CDATA[44,50 €]]></column>
                        <column name="imagen_C"><![CDATA[C:\Users\edu\Documents\Visual Web Ripper\G\1291995407611.jpg]]></column>
                        <column name="imagen_C_url"><![CDATA[http://static.es.groupon-content.net/11/76/1291995407611.jpg]]></column>
                    </columns>
                    <tables>
                    </tables>
                </row>
                <row>
                    <columns>
                        <column name="titulo_C"><![CDATA[Descuento de hoy: 39 euros en lugar de 213 por una sesión flash de ácido hialurónico con fotorrejuvenecimiento facial y mesoterapia virtual (45 mins. aprox.), solo en Zenkai]]></column>
                        <column name="precio_C"><![CDATA[Precio: 39,00 €]]></column>
                        <column name="descuento_C"><![CDATA[82%]]></column>
                        <column name="ahorro_C"><![CDATA[174,00 €]]></column>
                        <column name="imagen_C"><![CDATA[C:\Users\edu\Documents\Visual Web Ripper\G\1298054880308.jpg]]></column>
                        <column name="imagen_C_url"><![CDATA[http://static.es.groupon-content.net/08/03/1298054880308.jpg]]></column>
                    </columns>
                    <tables>
                    </tables>
                </row>
                <row>
                    <columns>
                        <column name="titulo_C"><![CDATA[Descuento de hoy: Imprime tus mejores fotos y crea tu propio álbum personal con Fotoalbum. Paga 5 EUR en lugar de 25 EUR ¡Ahorra un 80%!]]></column>
                        <column name="precio_C"><![CDATA[Precio: 5,00 €]]></column>
                        <column name="descuento_C"><![CDATA[80%]]></column>
                        <column name="ahorro_C"><![CDATA[20,00 €]]></column>
                        <column name="imagen_C"><![CDATA[C:\Users\edu\Documents\Visual Web Ripper\G\1273170933983.jpg]]></column>
                        <column name="imagen_C_url"><![CDATA[http://static.es.groupon-content.net/83/39/1273170933983.jpg]]></column>
                    </columns>
                    <tables>
                    </tables>
                </row>
.
.
.


But the needs of our project, the resulting xml should be like this:

Code:
<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
<channel>
<title>Groupon ES - Madrid</title>
<language>en</language>
<item>
<title>Kitchen Stories : Ahorra 81% en Madrid</title>
<pubDate>2011-02-22 00:00:00</pubDate>
<link>http://www.groupon.es/deals/madrid/que-tendra-tu-pareja-para-que-en-kitchen-stories-le-inviten/258772?CID=ES_RSS_217_389_189_22&amp;utm_source=rss_217&amp;utm_medium=rss_389&amp;utm_campaign=rss_189&amp;utm_content=rss_22</link>
<description>&lt;img style="float:left" src="http://static.groupon.es/67/17/1298233021767.jpg"/&gt;&lt;br /&gt;Llévate a tu pareja a comer a Kitchen Stories: paga una comida (primero, segundo y postre) y la otra solo te costará 6 euros con tu cupón</description>
</item>
<item>
<title>Pizzón Pizza : Ahorra 69% en Madrid</title>
<pubDate>2011-02-22 00:00:00</pubDate>
<link>http://www.groupon.es/deals/madrid/2-pizzas-familiares-de-4-ingredientes-en-pizzon-pizza/259644?CID=ES_RSS_217_389_189_22&amp;utm_source=rss_217&amp;utm_medium=rss_389&amp;utm_campaign=rss_189&amp;utm_content=rss_22</link>
<description>&lt;img style="float:left" src="http://static.groupon.es/97/12/1298309591297.jpg"/&gt;&lt;br /&gt;¡Mmmmmmmmm pizza! 11,95 euros en lugar de 39,10 por 2 pizzas familiares de 4 ingredientes en Pizzón Pizza</description>
</item>
<item>
<title>Zenkai : Ahorra 82% en Madrid</title>
<pubDate>2011-02-22 00:00:00</pubDate>
<link>http://www.groupon.es/deals/madrid/sesion-flash--facial-zenkai/259868?CID=ES_RSS_217_389_189_22&amp;utm_source=rss_217&amp;utm_medium=rss_389&amp;utm_campaign=rss_189&amp;utm_content=rss_22</link>
<description>&lt;img style="float:left" src="http://static.groupon.es/25/03/1298054880325.jpg"/&gt;&lt;br /&gt;39 euros en lugar de 213 por una sesión flash de ácido hialurónico con fotorrejuvenecimiento facial y mesoterapia virtual (45 mins. aprox.), solo en Zenkai</description>
</item>
<item>
<title>Imagen Integral : Ahorra 84% en Madrid</title>
<pubDate>2011-02-22 00:00:00</pubDate>
<link>http://www.groupon.es/deals/madrid/cavitacion-ultrasonica-presoterapia-imagen-integral/258852?CID=ES_RSS_217_389_189_22&amp;utm_source=rss_217&amp;utm_medium=rss_389&amp;utm_campaign=rss_189&amp;utm_content=rss_22</link>
<description>&lt;img style="float:left" src="http://static.groupon.es/19/46/1298287074619.jpg"/&gt;&lt;br /&gt;84% de descuento en tener un cuerpo 10 en Imagen Integral: 5 sesiones de cavitación ultrasónica + 5 sesiones de presoterapia por solo 79 euros en lugar de 500</description>
.
.
.
.
</item>


My question is:
"I can configure the resulting XML by VWR interface? or else should I use methods postprocesing?

If I have to use postprocesing functions, where I can find information to meet the formatting options for the resulting XML?

Thank you very much
Back to top
Report?
Sequentum Support
#4 Posted : Tuesday, February 22, 2011 11:25:34 PM

Groups: Administrators
Joined: 4/10/2010
Posts: 1,239
Location: Sydney, Australia
You need to use a post-processor if you want the XML output to follow an XML specification, such as RSS. You'll need .NET programming skills in order to create a post-processing script.

Please see these two topics:

http://manual.visualwebr...ault.aspx?manual_id=998

http://manual.visualwebr...ault.aspx?manual_id=945

Back to top
Report?
Users browsing this topic
Guest
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.4 RC1 | YAF © 2003-2009, Yet Another Forum.NET
This page was generated in 0.096 seconds.