Welcome, Guest
Username: Password: Remember me
Feature requests for JEM 2.0 - initial public release

TOPIC:

[SOLVED] Getting Information of Attendee from Community Builder (comprofiler) 2 years 8 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
(won't respond to PM)
==================================================================
running: pre-alpha JEM 4.x (custom version) + Joomla 4.0.0-beta7 + PHP 7.3
The following user(s) said Thank You: jojo12

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

[SOLVED] Getting Information of Attendee from Community Builder (comprofiler) 2 years 8 months ago #27375

  • jojo12
  • jojo12's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 3534
  • Thank you received: 400
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.

[SOLVED] Getting Information of Attendee from Community Builder (comprofiler) 2 years 8 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.
(won't respond to PM)
==================================================================
running: pre-alpha JEM 4.x (custom version) + Joomla 4.0.0-beta7 + PHP 7.3
The following user(s) said Thank You: sepp25

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

[SOLVED] Getting Information of Attendee from Community Builder (comprofiler) 2 years 8 months ago #27388

  • sepp25
  • sepp25's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 16
  • Thank you received: 2
@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.

[SOLVED] Getting Information of Attendee from Community Builder (comprofiler) 2 years 8 months ago #27391

Nice :)

Good to know that it's resolved and thx for showing how it was done.
(won't respond to PM)
==================================================================
running: pre-alpha JEM 4.x (custom version) + Joomla 4.0.0-beta7 + PHP 7.3

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

Time to create page: 0.478 seconds

Donate

If you find JEM useful and if you use it on your site, please consider a donation to the project.

Private Messages

You are not logged in.

Follow us......