Matukio Import User Data from Community Builder

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

Marco Rella
Topic Author
Offline
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 11 years 5 months ago #18376

Yves Hoppe Offline 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 Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

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

Marco Rella
Topic Author
Offline
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 11 years 5 months ago #18446

Marco Rella
Topic Author
Offline
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 11 years 5 months ago #18447

Yves Hoppe
Offline
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 4 months ago #18544

Marco Rella
Topic Author
Offline
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 10 years 9 months ago #21818

Ralf Hofer
Offline
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 10 years 9 months ago #21825

Yves Hoppe
Offline
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 10 years 9 months ago #21844

Ralf Hofer Offline 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 Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Matukio Import User Data from Community Builder 10 years 6 months ago #22903

Ralf Hofer
Offline
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 10 years 6 months ago #22910

Yves Hoppe Offline 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 Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

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

Rob Swart
Offline
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 2 months ago #24622

Ralf Hofer
Offline
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 2 months ago #24623

Rob Swart
Offline
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 2 months ago #24635

Ralf Hofer
Offline
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 2 months ago #24754

Rob Swart
Offline
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 2 months ago #25053

Ralf Hofer
Offline
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

Tiles

CMC

CMandrill

FFGate

CUpdater

CNotes

Mydigipass

CSlideshow

Pricing

Joomla! Development

Joomla! Security

App Development

Angular 2

Official releases

Developer releases

Languages

Help Desk

Support policy

Hotspots

Matukio Events

CComment

Ctransifex

CMC

CNotes

CMigrator

CMandrill

MyDigipass

CForms

CForms for WordPress

Video Tutorials

Changelogs

Matukio API Docs

Team

Joomla Commitment

Privacy Policy / Imprint

Notice

TOPIC: Matukio Import User Data from Community Builder