Categories
View Replies (2)

Resolved Custim fields from Mosets tree

  1. itrust
    itrust
  2. RO CSVI
  3. Tuesday, 18 February 2020
  4.  Subscribe via email
Hello!
What is the best way to export custom fields from Mosets tree?
I think there is no special plugin, so i've tried to get it with custom tables.

Here is the screenshot of database structure.
After export i got something like this:

article id cf_value
1 10
1 auto
1 black
2 11
2 plane
2 white

Instead of
1^10^auto^black
2^11^plane^white

Is there any chance to get it?
Thank you!
Attachments (1)
supp1.jpg supp1.jpg
0
Responses (2)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I think there is no special plugin, so i've tried to get it with custom tables.
There is no support for Mosets tree in RO CSVI. Using the Custom Tables export is the only way to get data out of it. Unless you write your own export routine :)

Instead of
1^10^auto^black
2^11^plane^white
That process is called transposing. This is not something you can easily do with a regular database query. One way is to write code (custom export routine) to do so, the other is to use some Excel formulas perhaps if you are creative with Excel.
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. # 1
itrust
itrust
Accepted Answer Pending Moderation
Ok, thank you
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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