Main menu

Forum


× Help Forum English

[ROADMAP] How to extend the CSV export

  • uweb_61
  • Topic Author
  • New Member
  • New Member
More
2 weeks 1 day ago - 10 hours 38 minutes ago #19014 by uweb_61
Hi,

I'm looking for a way to expand the csv export of the registrations. I need the “next” and “place” fields from the icagenda_events table. Unfortunately, I can't find a way to select them.
My configuration:
iCagenda core 4.0.3 (2026-02-13)
Joomla 6.0.3
Thanks for any help! 
Regards
Uwe
Attachments:
Last edit: 10 hours 38 minutes ago by Lyr!C. Reason: I have found a solution that works well for me. See attached file.

Please Log in or Create an account to join the conversation.

  • Lyr!C
  • Lyr!C's Avatar
  • Administrator
  • Administrator
  • Lead Developer
More
11 hours 14 minutes ago #19021 by Lyr!C
Replied by Lyr!C on topic [SOLVED] How to extend the CSV export
Hello,

It seems you have edited your message as "SOLVED".

Does it mean you have found a wait to customized the CSV export fonction ?

Best regards,
Cyril

Latest version : iCagenda 4.0.4
We recommend every user to keep iCagenda updated.
Don't forget to have your Joomla!™ up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

File Attachment:

Please Log in or Create an account to join the conversation.

  • uweb_61
  • Topic Author
  • New Member
  • New Member
More
10 hours 54 minutes ago #19024 by uweb_61
Replied by uweb_61 on topic [SOLVED] How to extend the CSV export
Hi Cyril,

I commented on my post with "I have found a solution that works well for me. See attached file" Can't you see that? I also attached a text file named "Solution" to my post. The solution steps are described there:
Solution:

Changes in the file forms/download.xml:
Add after field event_title:
<field
name="event_title"
type="radio"
label="COM_ICAGENDA_EXPORT_EVENT_TITLE_LABEL"
default="1"
class="btn-group btn-group-yesno"
layout="joomla.form.field.radio.switcher"
>
<option value="0">JNO</option>
<option value="1">JYES</option>
</field>

<field
name="event_place"
type="radio"
label="COM_ICAGENDA_EXPORT_EVENT_PLACE_LABEL"
default="1"
class="btn-group btn-group-yesno"
layout="joomla.form.field.radio.switcher"
>
<option value="0">JNO</option>
<option value="1">JYES</option>
</field>


Changes in the file administrator/language/de-DE/de-DE.com_icagenda.ini
Add in the section „Registrations Export“ (approximately line 881):
COM_ICAGENDA_EXPORT_EVENT_PLACE_LABEL="Veranstaltungsort"
COM_ICAGENDA_EXPORT_EVENT_NEXT_LABEL="Veranstaltungsdatum"


Changes in the file src/Controller/RegistrationsController.php:
Add:
$model->setState('event_place', $form);
$model->setState('event_next', $form);

after „$model->setState('event_title', $form);“ (approximately line 104)

Changes in the file src/Model/RegistrationsModel.php:
SQL statement extended (approximately line 168):
$query->select('e.title AS event, e.place AS place, e.next AS next,

Added after if ($this->getState('event_title')) { (approximately line 808):

if($this->getState('event_place')){
$this->content .= $separator . '"' . str_replace('"', '""', Text::_('COM_ICAGENDA_EXPORT_EVENT_PLACE_LABEL')) . '"';
}


if($this->getState('event_next')){
$this->content .= $separator . '"' . str_replace('"', '""', Text::_('COM_ICAGENDA_EXPORT_EVENT_NEXT_LABEL')) . '"';
}


Added after if ($this->getState('event_title')) { (approximately line 887):

if ($this->getState('event_place')) {
$this->content .= $separator . '"' . str_replace('"', '""', $item->place) . '"';
}

if ($this->getState('event_next')) {
$this->content .= $separator . '"' . str_replace('"', '""', $item->next) . '"';
}


Best Regards,
Uwe
The following user(s) said Thank You: Lyr!C

Please Log in or Create an account to join the conversation.

  • Lyr!C
  • Lyr!C's Avatar
  • Administrator
  • Administrator
  • Lead Developer
More
10 hours 47 minutes ago #19026 by Lyr!C
Replied by Lyr!C on topic [SOLVED] How to extend the CSV export
Oh sorry, i think i need more coffee to open clearly my eyes ! :-)

So, your custom change is valid.

Just comments:
- "next" will be removed (not used anymore) in iCagenda 5 (with a full new dates sytem). So good for you to know about it.
- This is a good idea to be able to add a few event information in the export CSV, so i will add this to my todo list (for until i do this, as i don't know yet when and for which version) your custom change will work, as when i will work on this part, then you may not need anymore a custom code ;-) )

Best regards,
Cyril

Latest version : iCagenda 4.0.4
We recommend every user to keep iCagenda updated.
Don't forget to have your Joomla!™ up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

File Attachment:

Please Log in or Create an account to join the conversation.

  • uweb_61
  • Topic Author
  • New Member
  • New Member
More
10 hours 43 minutes ago #19027 by uweb_61
Replied by uweb_61 on topic [SOLVED] How to extend the CSV export
Hi,

that would be great!

Best regards,
Uwe

Please Log in or Create an account to join the conversation.

  • Lyr!C
  • Lyr!C's Avatar
  • Administrator
  • Administrator
  • Lead Developer
More
10 hours 39 minutes ago #19028 by Lyr!C
Replied by Lyr!C on topic [SOLVED] How to extend the CSV export
The idea is great, so good to add it to the todo list.

Just that the todo list is very long, but step by step, many improvements are added to iCagenda thanks to users feedback! ;-)

Have a nice weekend,
Best regards,
Cyril

Latest version : iCagenda 4.0.4
We recommend every user to keep iCagenda updated.
Don't forget to have your Joomla!™ up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

File Attachment:

Please Log in or Create an account to join the conversation.

Moderators: Lyr!C
Time to create page: 0.044 seconds

Follow Us

Create your Joomla templates with Template Creator CK

acymailing logo new