Categories
View Replies (8)

Resolved XML export, all values empty - question

  1. gnsbud
    gnsbud
  2. RO CSVI
  3. Saturday, 08 August 2015
  4.  Subscribe via email
Hi,

I have few fields for export, no matter if Virtuemart, Joomla content or Hikashop export - if I'm using export to csv file and if all my product/content fields values are empty, then this whole empty row isn't placed in csv file - that's perfect. However if I'm exporting the same fields to xml file, the "body" is inserted to xml file even if all currently processing item fields "in row" are empty. Is there a way to not insert xml "body" part if all item fields values are empty? Hope you understand what I mean, I can't describe it better :silly:

Best regards,
Chris
0
Responses (8)
gnsbud
gnsbud
Accepted Answer Pending Moderation
Hi,

everything is working fine now! :woohoo:

Best regards,
Chris
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Chris,

I see now, I as understanding something else. The attached file should fix that issue as well.
Attachments (1)
patch_nodes_20150811.zip
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
gnsbud
gnsbud
Accepted Answer Pending Moderation
Hi,

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

Best regards,
Chris
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Chris,

Which website have you chosen for the XML export?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
gnsbud
gnsbud
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
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.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
gnsbud
gnsbud
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
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?
Attachments (1)
patch_nodes_20150810.zip
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!