Categories
View Replies (3)

Resolved Create rules

  1. psycofox
    psycofox
  2. RO CSVI
  3. Friday, 07 October 2016
  4.  Subscribe via email
Hi there,

I've got a SQL table with this two fields: ID_car and equipments.
The ID_car field regroup all the ID of cars, the equipments field regroup all the equipments of a car.
The viewing of the table is :

ID_car | Equipments
1 | Abs ,Radio ,Bluetooth

I need to create an XML that get the data from database and place them with this structure:

<id> ID_car </id>
<equipments>
<equipment>
<text> First Equipment </text>
</equipment>
<equipment>
<text> Second Equipment </text>
</equipment>
<equipment>
<text> Third Equipment </text>
</equipment>
<equipments>

I've already created the template, the field mapper and the template fields. They work perfectly on exporting data, i've got trouble to divide the equipments into the structure i've posted above.

Database schema version 6.6.0
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You are trying to split a field value from database and make it as each XML node on export, that wont be possible as CSVI reads the field value as a whole and writes to XML node. You may need to write your own custom code to hack the code to get this with some developer's help.
Kind regards,

Tharuna

=========================
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. # 1
psycofox
psycofox
Accepted Answer Pending Moderation
Could u suggest me how to do this hacking ? I mean the file which i've to modify. I will try to do the code by myself.
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Instead of modifying an existing file, you could create your own XML export handler. In the folder administrator/components/com_csvi/helper/file/export/xml you can add your own XML file. This will show up when you choose XML as export type in your template.

If you make a copy of an existing XML handler, you can modify it to your own needs.
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. # 3
  • Page :
  • 1


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