1. elisa
  2. RO CSVI
  3. Monday, 29 September 2025
  4.  Subscribe via email
Hi Roland and Tharuna,
How can I export Data from a subform properly?

personen#Männer|anzahl#10~personen#Frauen|anzahl#16~personen#Kinder|anzahl#4

the value after personen# is custom text
the value after anzahl# is a number

I need 3 Columns Männer | Frauen | Kinder and in the cells the number

It could be that the value is
personen#Frauen|anzahl#10~personen#Männer|anzahl#16~personen#Kinder|anzahl#4
or
personen#Männer|anzahl#16~personen#Kinder|anzahl#4

or different...
Accepted Answer Pending Moderation
Hello Elisa,
You can use custom template field and add three columns Männer, Frauen and Kinder in export. Using RO CSVI Field copy rule copy subform value to all three columns and using regex extract first, second and third numbers from these fields. But the problem is the order of subform value. You mentioned that subform values can be any order so it is better to write custom rule to get matching numbers based on columns.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 3 days ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi Tharuna, yes thats what I need, I hoped I can have something like subform row 1 value 1 in a column subform row 2 value 1 in a column, subform row 3 value 1 in a column or so :-)
Then I will look how to make the custom rule plugin.
thank you
Elisa
  1. 3 days ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Elisa,
I need 3 Columns Männer | Frauen | Kinder and in the cells the number

So you need export file to have customised form of subform values with three columns Männer, Frauen and Kinder and it should look like


Männer, Frauen, Kinder
10, 16, 4


Is that correct? I am trying to understand if this is what you expect in export file. If yes then this can only be done by writing custom code. This custom code can either be a override file for export or a new custom rule plugin.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 3 days 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!