×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Matukio Import User Data from Community Builder

Matukio Import User Data from Community Builder 12 years 1 week ago #18375

  • Marco Rella
  • Marco Rella's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Hi I am change from seminar on Matukio.

In Seminar I was eable do change the Source Code to make possible do import
extra data from Community Builder to Seminar (see attached file)

How will this made done in Matukio. I need this do finisch Matukio integration.

Any Idea is very welcome

Thanks Marco

File Attachment:

File Name: seminar-cbmodifikation-deutsch.pdf
File Size: 90 KB
Attachments:

Matukio Import User Data from Community Builder 12 years 1 week ago #18376

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 71
  • Thank you received: 556
Hi Marco,

hmm this is not going to be easy. Which booking form are you going to use - the new one or the old seminar style one?

Best regards,

Yves

P.S.: Perhaps you should add me on Skype (yves.hoppe), because this is going to be more complex

Matukio Import User Data from Community Builder 12 years 1 week ago #18385

  • Marco Rella
  • Marco Rella's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Hi Yves

I am not shure about which style will be the easyest to do this.
I hope you can tell me which way will be the most pratical one to make this.

For me it is important that I can integrate the CB the new style old or new is not
really importend.

I would appreciate it if you could help me further.

Regards Marco

My Skype ist mr.enforce

Matukio Import User Data from Community Builder 12 years 1 week ago #18446

  • Marco Rella
  • Marco Rella's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Hi Yves

Did you got my replay, sorry I do not now if I am using this Forum in the rigth way.

I am not shure about which style will be the easyest to do this.
I hope you can tell me which way will be the most pratical one to make this.

For me it is important that I can integrate the CB the new style old or new is not
really importend.

I would appreciate it if you could help me further.

Regards Marco

Matukio Import User Data from Community Builder 12 years 1 week ago #18447

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 71
  • Thank you received: 556
Hi Marco,

sorry thought you are going to contact me on Skype. You can use the old and new booking form for that.

For the new booking form you have to edit components/com_matukio/controllers/bookevent.php, instead of using $zusatz etc., you have to use the new booking field values - e.g. for example around line 233 in the for loop, add

if (field->name == "city) {
$newfields .= $row3->cb_stadt;
}

In my opinion it would be also nice to insert these values automatically in the booking form (not described in the PDF), for that you have to edit components/com_matukio/views/bookevent/tmpl/default.php.

Best regards,

Yves

Matukio Import User Data from Community Builder 11 years 11 months ago #18544

  • Marco Rella
  • Marco Rella's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Hallo Yves

Es hat geklappt soweit. Meine Frage an dich die Zusatzfelder sollten auch in den kommenden Versionen Matukio funktionieren. Weil sie die Möglichkeit geben, Felder für nur einen einzigen Event zu definieren. Was mit der neuen Version von Felder leider nicht möglich ist die neuen Felder gelden über alle Events.Oder gibts eine bessere Variante?

Danke Marco

Matukio Import User Data from Community Builder 11 years 4 months ago #21818

  • Ralf Hofer
  • Ralf Hofer's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hallo zusammen.

Ich habe versucht aus CB Daten abzufragen und beim buchen von Events direkt zu "verwerten".

In unserem Fall sollen sich die Golfer mit CB einloggen und mit Matukio ein Golfturnier buchen. In CB sind alle Daten (GolfClub, Handicap, Mitgliedsnummer) hinterlegt und sollen dann verwendet werden.

Yves, kannst du mir dabei helfen? Gibt es mittlerweile eine Art Anleitung? Ich habe diesen Thread ausprobiert, aber komme irgendwie nicht weiter.

Danke.

Matukio Import User Data from Community Builder 11 years 4 months ago #21825

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 71
  • Thank you received: 556
Hallo Ralf,

hmm eine Anleitung gibt es leider noch nicht (ausser die ganz alte für Seminar, die aber nur mit dem alten Buchungsformular funktionieren würde und wo sich bei der Implementierung auch sehr sehr viel geändert hat).

Wollt ihr das neue oder alte Buchungsformular verwenden?

Viele Grüße

Yves

P.S.: Du kannst mich auch gerne in Skype (yves.hoppe) hinzufügen

Matukio Import User Data from Community Builder 11 years 4 months ago #21844

  • Ralf Hofer
  • Ralf Hofer's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hallo Yves.

Wir würden gerne das neue Formular verwenden. Es wäre echt sehr hilfreich für die ganze Administration wenn wir das irgendwie hinbekommen. Ich werde dich in Skype hinzufügen, werde mich aber erst Mitte August um das Thema weiter kümmern können, da ich jetzt erstmal Urlaub habe :-)

Matukio Import User Data from Community Builder 11 years 1 month ago #22903

  • Ralf Hofer
  • Ralf Hofer's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hallo Yves.

Ich habe lange nichts mehr gemacht an der Homepage, aber jetzt habe ich etwas Zeit und würde gerne ein paar Daten aus CB in Matukio überführen. Ich habe gestern rumprobiert, aber bin zu keinem vernünftigem Ergebnis gekommen. Bist du heute über Skype zu erreichen und wann bis wann? Oder gibt es mittlerweile eine Art Anleitung?

Gruß, Christian

Matukio Import User Data from Community Builder 11 years 1 month ago #22910

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 71
  • Thank you received: 556
Hallo Christian,

im Forum gab es dazu einen interessanten Beitrag von einem Benutzer: compojoom.com/forum/107-wishlist/17941-r...anstatt-joomla#22834

Eventuell noch meine Anmerkungen dazu beachten.

Viele Grüße

Yves

P.S.: Einfach anschreiben in Skype, bin immer unsichtbar ;)

Matukio Import User Data from Community Builder 10 years 11 months ago #23849

  • Rob Swart
  • Rob Swart's Avatar
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 57
  • Thank you received: 5
Hi Yves,

I'm happy to tell you that I've found an, not to complicated, way to use Community Builder data in the default bookingform.
Note that I'm putting the contents of the CB fields in the zusatz fields. This way they wil be added to the Matukio database table.
Offcourse one can take any CB field this way. The shown fieldnames in this example code are just my local CB custom fields.

I've added a few lines of code in components/com_matukio//views/event/tmpl/default.php

Around line 694 find "// Zusatzfelder ausgeben"
Under it, add this code:
// Added code for retrieving extra data from Community Builder
	    $sqlcb = $my->id;                         
	    $namr  = $my->name;
	    $sqlcb      = $my->id;
	    if ($sqlcb > 0) {
	 	    $databasecb = &JFactory::getDBO();								   // Extra database variable to facilitate query on Community Builder databasetable
		    $querycb      = "SELECT * FROM #__comprofiler WHERE id='$sqlcb'" ; // Query on Community Builder database for custom fields
		    $databasecb->setQuery($querycb);
		    $rowcb			  = $databasecb->loadObject();
		    $naam             = $namr;
		    $adres			  = $rowcb->cb_adres;
		    $plaats			  = $rowcb->cb_plaats;
		    $bank			  = $rowcb->cb_banknummer;
		    $uitlootindicatie = $rowcb->cb_uitgeloot;
		    $personeelsnr	  = $rowcb->cb_personeelsnummer;
	    }
		// End added code

On or around line 771 find this code:
default:
							$htxt = "<input type=\"text\" class=\"sem_inputbox\" id=\"zusatz" . ($i + 1) . "\" name=\"zusatz" . ($i + 1) . "\" value=\""
								. $zustemp[$i] . "\" size=\"50\"" . $tempdis . ">" . $temp;
							break;
					}
				} else

And replace it by this code:
default:
								$htxt = "";                            // Changed: here the custom fields from Community Builder that must be shown in every booking are set (not editable)
								switch($zusart[0]) {
									case "Naam":
										$htxt  .= "<input type=\"text\" class=\"sem_inputbox\" id=\"zusatz".($i+1)."\" name=\"zusatz".($i+1)."\" value=\"".$naam."\" size=\"50\" READONLY />".$temp;
									break;
									case "Adres":
										$htxt  .= "<input type=\"text\" class=\"sem_inputbox\" id=\"zusatz".($i+1)."\" name=\"zusatz".($i+1)."\" value=\"".$adres."\" size=\"50\" READONLY />".$temp;
									break;
									case "Woonplaats":
										$htxt  .= "<input type=\"text\" class=\"sem_inputbox\" id=\"zusatz".($i+1)."\" name=\"zusatz".($i+1)."\" value=\"".$plaats."\" size=\"50\" READONLY />".$temp;
									break;
									case "Banknummer":
										$htxt  .= "<input type=\"text\" class=\"sem_inputbox\" id=\"zusatz".($i+1)."\" name=\"zusatz".($i+1)."\" value=\"".$bank."\" size=\"50\" READONLY />".$temp;
									break;
									case "Uitlootindicatie":
										if ($uitlootindicatie == 0) {
											$uitloot = "Uitlootbaar";
										} else {
											$uitloot = "Niet uitlootbaar";
										}
										$htxt  .= "<input type=\"text\" class=\"sem_inputbox\" id=\"zusatz".($i+1)."\" name=\"zusatz".($i+1)."\" value=\"".$uitloot."\" size=\"50\" READONLY />".$temp;
									break;
									case "Persnr":
										$htxt  .= "<input type=\"text\" class=\"sem_inputbox\" id=\"zusatz".($i+1)."\" name=\"zusatz".($i+1)."\" value=\"".$personeelsnr."\" size=\"50\" READONLY />".$temp;
									break;
									default:
									$htxt .= "<input type=\"text\" class=\"sem_inputbox\" id=\"zusatz".($i+1)."\" name=\"zusatz".($i+1)."\" value=\"".$zustemp[$i]."\" size=\"50\"".$tempdis." />".$temp;
									break;
								 }
						   }
 
				} else

Note that the shown fields are not editable. This is because only registered members can book events on my site. Just delete the "READONLY" parameter to make the fields editable for each event.

Greetings,
Rob

Matukio Import User Data from Community Builder 10 years 9 months ago #24622

  • Ralf Hofer
  • Ralf Hofer's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hoi Rob.
I tried "your" way, but it doesn't work or I'm too stupid.
I'm using the latest version of Matukio (3.07) and I did every change in the default.php as you proposed. I also added in CB your original fields like "plaats", "adres", ... In Matukio I'm using the old booking template. Do I have to add anything special in the booking itself under "Additional booking fields"?? As I understood with editing from the default.php I do not have to add something there.
Can you please help me?
Dank je wel!, Christian

Matukio Import User Data from Community Builder 10 years 9 months ago #24623

  • Rob Swart
  • Rob Swart's Avatar
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 57
  • Thank you received: 5
I'm also using the old booking template.

Ok, there are two more steps that I didn't mention before.
In order to display the fields correctly on the booking form, they must be there. So here is some more code to make that happen:

First open file components/com_matukio/views/createevent/view.html.php
Find on or around line 83:
			$row->begin = date("Y-m-d") . " " . $def_begin;
			$row->end = date("Y-m-d") . " " . $def_end;
			$row->booked = date("Y-m-d") . " " . $def_booked;
add after:
			// Default booking fields
			$row->zusatz1 = "Naam|0||text";                     // Added some fixed fields that will be shown in every event
			$row->zusatz2 = "Adres|0||text";                    
			$row->zusatz3 = "Woonplaats|0||text";              
			$row->zusatz4 = "Banknummer|1||text";  // values will be taken from Community Builder
			$row->zusatz5 = "Uitlootindicatie|0||text";         
			$row->zusatz6 = "Persnr|0||text";
			$row->zusatz1hint = "";
			$row->zusatz2hint = "Here your hint";
			$row->zusatz3hint = "Here your hint";
			$row->zusatz4hint = "Here your hint";
			$row->zusatz5hint = "Here your hint";
			$row->zusatz6hint =  "Here your hint";
			$row->zusatz1show = 1;
			$row->zusatz2show = 1;
			$row->zusatz3show = 1;
			$row->zusatz4show = 1;
			$row->zusatz5show = 1;
			$row->zusatz6show = 1;

Second open file administrator/com_matukio/models/event.php

Find on or around line 64:
			// Current user
			$event->publisher = JFactory::getUser()->id;
			$event->semnum = MatukioHelperUtilsEvents::createNewEventNumber(date('Y'));
 
			$event->published = 1;
Add after:
			// Default booking fields
			$row->zusatz1 = "Naam|0||text";                     // Added some fixed fields that will be shown in every event
			$row->zusatz2 = "Adres|0||text";                    
			$row->zusatz3 = "Woonplaats|0||text";              
			$row->zusatz4 = "Banknummer|1||text";  // values will be taken from Community Builder
			$row->zusatz5 = "Uitlootindicatie|0||text";         
			$row->zusatz6 = "Persnr|0||text";
			$row->zusatz1hint = "";
			$row->zusatz2hint = "Here your hint";
			$row->zusatz3hint = "Here your hint";
			$row->zusatz4hint = "Here your hint";
			$row->zusatz5hint = "Here your hint";
			$row->zusatz6hint =  "Here your hint";
			$row->zusatz1show = 1;
			$row->zusatz2show = 1;
			$row->zusatz3show = 1;
			$row->zusatz4show = 1;
			$row->zusatz5show = 1;
			$row->zusatz6show = 1;			

This way the fields zusatz1 through 6 are reserved for you default bookingfields.
Notice that when you want more or less fields, you'll have to change the code in all three files.
Notice also that the name of the variables must be the same in all files or the will not be filled correctly.

And offcourse, the name of the CB fields are in MY database. You should change them to the variable names in your own CB database you want to use.

BTW i'm on version 3.06 of Matukio.
Upgrading is more work for me because of these custom changes i've made ;)

Good Luck!

Matukio Import User Data from Community Builder 10 years 9 months ago #24635

  • Ralf Hofer
  • Ralf Hofer's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Now I'm also using Matukio 3.06 :-)
I'm using the old form and layout "standard". I did all the changes you wrote. I generated all CB fields like you and it didn't work for me. During the booking I didn't see anything from these additional fields. Anything more I have to change? What do you need from me that you can help me?
Thanks in advance.

Matukio Import User Data from Community Builder 10 years 9 months ago #24754

  • Rob Swart
  • Rob Swart's Avatar
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 57
  • Thank you received: 5
Hi Christian,

I've been on vacation, that's why this reply is a bit late.
A couple of things could be causing the fact you don't see the extra fields:

- It only works for new events you've created AFTER altering the code
- It only works for registered members that are logged in
- The content of the fields only shows when they are filled by the user that is making the booking. Otherwise they stay empty.

Matukio Import User Data from Community Builder 10 years 9 months ago #25053

  • Ralf Hofer
  • Ralf Hofer's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hi Rob.
Also your last advices don't work for me.
I prepared an event after editing the codes.
When I login as an user I see the event, but when I book the event I see only the normal old booking form. It's hard for me to explain because I'm not so familiar with understanding the codes. Is it possible that we can connect each other via skype? Any help is really appreciated. Maybe it's only a small issue.

Thanks, Christian
  • Page:
  • 1
Time to create page: 0.189 seconds