Resolved XML export, all values empty - question

Hey Chris,

I think I know what you mean, you get an empty node. Only the start and end of the node, correct?

Attached is a patch file that is an attempt to fix this for the Joomla content export. Can you give it a spin and let me know if it works for you?

Hi,

almost perfect, now if all item fields are empty, then 'body' for this item is not inserted to xml (exactly as wanted), however if fields are not empty, then I got in my xml file for example "[alias]" - I mean it doesn't change tokens to actual values - it supposed to be "some-alias-to-my-article" but instead it's always "[alias]" and the same thing is with any other field.

BTW (quite off topic I know) there seems to be small typo, I got this error while narrowing export to only published articles:

Unknown column 'c.published' in 'where clause' SQL=SELECT `c`.`metakey`, `c`.`metadesc` FROM `gd_content` AS `c` LEFT JOIN `gd_categories` AS `cat` ON `cat`.`id` = `c`.`catid` WHERE `c`.`published` = 1

There isn't "published" column in content table, I guess it should be "state" column.

Best regards,
Chris

Hello Chris,

The tokens are not supposed to be used, you only need to add the fields and during the export the field name or if set the column header will be used as XML node. For ezample the alias field would be exported as

<alias>myownfieldaliasvalue</alias>

As for the error, you are correct, this should be the state column. Thanks.

Hi,

yes, exactly, I mean that, I should have:

<alias>myownfieldaliasvalue</alias>

but I have

<alias>[alias]</alias>

and with any other field the same thing happens.

Best regards,
Chris

Hey Chris,

Which website have you chosen for the XML export?

Hi,

I choose "Custom" and filled XML Layout. Before applying patch it was working fine.

Best regards,
Chris

Hey Chris,

I see now, I as understanding something else. The attached file should fix that issue as well.

Hi,

everything is working fine now! :woohoo:

Best regards,
Chris