help to better help you:
Please: add always Joomla / JEM version and details to your posts, so we can try to reproduce your issue!
Feature requests for JEM 2.0 - initial public release
[SOLVED] Getting Information of Attendee from Community Builder (comprofiler)
Re: [SOLVED] Getting Information of Attendee from Community Builder (comprofiler)
4 years 5 months ago
@jojo
Thing is that i don't use it and registering for it for just trying out is a bit of to much of a hassle at the moment.
Greetings,
Blue
Thing is that i don't use it and registering for it for just trying out is a bit of to much of a hassle at the moment.
Greetings,
Blue
The following user(s) said Thank You: jojo12
Please Log in or Create an account to join the conversation.
Re: [SOLVED] Getting Information of Attendee from Community Builder (comprofiler)
4 years 5 months ago
Ok. But you know, it only needs registering, no costs for the basic cb.
Jojo
Jojo
Please Log in or Create an account to join the conversation.
Re: [SOLVED] Getting Information of Attendee from Community Builder (comprofiler)
4 years 5 months ago
Thx. I knew it but i "hate/don't like" it that you can't simply download the basics. A lot of other components do allow it.
Ah well will see.
Ah well will see.
The following user(s) said Thank You: sepp25
Please Log in or Create an account to join the conversation.
Re: [SOLVED] Getting Information of Attendee from Community Builder (comprofiler)
4 years 5 months ago
@Bluefox: Thank you ! you gave me lots of ideas which lead me to my solution.
As I had writte before, for us it would be sufficient to have this information in the CSV-Export of the attendees.
So it is quite simple (everything is simple after the problem is solved
I had to modify 2 files:
models/attendees.php
in order to append "my" field 'cb_stimme' to the query that builds the attendees - structure:
Line:
191 $stimme = ', cb.cb_stimme as stimme'; //bo 18.07.2020
192 $join = ' LEFT JOIN #__comprofiler as cb ON cb.user_id = r.uid'; //bo 18.07.2020
and
$query = 'SELECT r.*, u.username, u.name, u.email, a.created_by, a.published,'
. ' c.catname, c.id AS catid'
197 . $stimme
...
203 . $join
and
controllers/attendees.php
to output the additional column to the CSV
line:
225 public function export()
261 $cols[] ='Stimme'; //bo 18.07.2020
279 $cols[] = $data->stimme; //bo 18.07.2020
that's it
NOW I will have a big glass of Bavarian Weissbier
As I had writte before, for us it would be sufficient to have this information in the CSV-Export of the attendees.
So it is quite simple (everything is simple after the problem is solved
I had to modify 2 files:
models/attendees.php
in order to append "my" field 'cb_stimme' to the query that builds the attendees - structure:
Line:
191 $stimme = ', cb.cb_stimme as stimme'; //bo 18.07.2020
192 $join = ' LEFT JOIN #__comprofiler as cb ON cb.user_id = r.uid'; //bo 18.07.2020
and
$query = 'SELECT r.*, u.username, u.name, u.email, a.created_by, a.published,'
. ' c.catname, c.id AS catid'
197 . $stimme
...
203 . $join
and
controllers/attendees.php
to output the additional column to the CSV
line:
225 public function export()
261 $cols[] ='Stimme'; //bo 18.07.2020
279 $cols[] = $data->stimme; //bo 18.07.2020
that's it
NOW I will have a big glass of Bavarian Weissbier
Please Log in or Create an account to join the conversation.
Re: [SOLVED] Getting Information of Attendee from Community Builder (comprofiler)
4 years 5 months ago
Nice
Good to know that it's resolved and thx for showing how it was done.
Good to know that it's resolved and thx for showing how it was done.
Please Log in or Create an account to join the conversation.
Time to create page: 0.621 seconds