[SOLVED] site data in XML

Gallex · 2021-01-13 10:56:06

my client website has products page. now he wants all the data in that product page (each product has title, description and images) as XML file. how i get this?

etc · 2021-01-13 12:02:11

Are you trying to import or to export data to/from txp?

Gallex · 2021-01-13 12:05:18

etc wrote #328144:

Are you trying to import or to export data to/from txp?

export

etc · 2021-01-13 12:18:06

First create a XML form type in Advanced options/Custom form template types:

[xml]
mediatype="text/xml"
title="XML"

Then create a XML form (say products) like

<?xml version = "1.0"?>
<products>
<txp:article_custom>
<product>
   <title><txp:title /></title>
   <description><txp:meta_description format="" /></description>
   ...
</product>
</txp:article_custom>
</products>

You should be able to access it via ?f=products now.

Gallex · 2021-01-13 13:13:05

<?xml version = “1.0”?>
<products>
<txp:article_custom>
<product> <title><txp:title /></title> <description><txp:meta_description format=”“ /></description> …

by the product description I meant – text inside the body. is it correct then:

<title><txp:title /></title>
   <description><txp:body /></description>

but images?

Pat64 · 2021-01-13 13:13:05

… I’m so curious Oleg. And now: if the question was how to import?

Last edited by Pat64 (2021-01-13 13:15:00)

etc · 2021-01-13 13:18:35

Gallex wrote #328147:

but images?

I don’t think you can (without encoding them). Include just their URL?

Pat64 wrote #328148:

… And now: if the question was how to import?

smd_xml or etc_query?

Gallex · 2021-01-13 13:48:42

etc wrote #328146:

Then create a XML form (say products) like

<?xml version = "1.0"?>...

You should be able to access it via ?f=products now.

oleg, this is not at all what i would like. i would like to export this page as XML.
your solution produces this
some page titles and one multiplied page description

etc · 2021-01-13 14:06:30

Gallex wrote #328150:

some page titles and one multiplied page description

What do you want — I had no idea of how meta_description tag works :-) Try with <txp:body /> or

<txp:custom_field name="description" />

And probably replace article_custom with article to filter by section.

Pat64 · 2021-01-13 14:13:36

@etc: Ok. With the help of a plugin (I thought you do it with some native TXP magic inside) :D

colak · 2021-01-13 15:15:31

Is the https://kenovoeesti.ee/tooted/aeda-ja-garaazi/ page an article or a category? The reason I am asking is because it finishes with / which implies that it is not an article. It is good to know if aeda-ja-garaazi is a category and if tooted is a section.

Also…

Are the images loaded via article_image ?
In case it is a category, Do you expect the data of the tables to be included in the xml?

Last edited by colak (2021-01-13 15:58:12)

Gallex · 2021-01-14 09:15:42

colak wrote #328155:

It is good to know if aeda-ja-garaazi is a category and if tooted is a section.

you are absolutely correct – aeda-ja-garaazi is a category and tooted is a section.

Are the images loaded via article_image ?

yes

In case it is a category, Do you expect the data of the tables to be included in the xml?

yes

Textpattern CMS

Textpattern CMS support forum

#1 2021-01-13 10:56:06