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
#27374
@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
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
#27375
Ok. But you know, it only needs registering, no costs for the basic cb.
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
#27376
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.
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
#27388
@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 :-)
The following user(s) said Thank You: jojo12, Bluefox

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
#27391
Nice :)

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