Categories
View Replies (3)

Resolved Export Subform Data

  1. elisa
    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...
0
Responses (3)
tharuna
tharuna
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. 4 weeks ago
  2. RO CSVI
  3. # 1
elisa
elisa
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. 4 weeks ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
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. 4 weeks 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!