Keep Club-Members in sync with community builder
- webminbw
- OFFLINE
-
New Member
- Posts: 2
- Thanks: 0
- Karma: 0
7 years 9 months ago - 7 years 9 months ago #283041
by webminbw
Keep Club-Members in sync with community builder was created by webminbw
Thank you for reading and giving it a thought.
We are a sports club and manage our members with JVEREIN. JVEREIN has a table called: mitglied
This is what the table looks like:
I would like to have a command to update the joomla-database and its table joomlaprefix_comprofiler continously from jverein-Database.
The joomlaprefix_comprofiler -table in the joomla-database looks like this
What are your thoughts on this? Thank you!
We are a sports club and manage our members with JVEREIN. JVEREIN has a table called: mitglied
This is what the table looks like:
"id","externemitgliedsnummer","adresstyp","personenart","anrede","titel","name","vorname","adressierungszusatz","strasse","plz","ort","staat","zahlungsweg","zahlungsrhytmus","mandatdatum","mandatversion","mandatsequence","bic","iban","ktoipersonenart","ktoianrede","ktoititel","ktoiname","ktoivorname","ktoistrasse","ktoiadressierungszusatz","ktoiplz","ktoiort","ktoistaat","ktoiemail","geburtsdatum","geschlecht","telefonprivat","telefondienstlich","handy","email","eintritt","beitragsgruppe","individuellerbeitrag","zahlerid","austritt","kuendigung","sterbetag","vermerk1","vermerk2","eingabedatum","letzteaenderung","ktoigeschlecht","zahlungstermin"
"11",NULL,"1","n","Frau",,"Doe","John",,"Any Street","41469","Neuss","DEUTSCHLAND","1","12",NULL,"1",NULL,"TESTDETTBIC","DE41553500100000123456","n",,,,,,,,,,,"1988-10-19","w",,,,,NULL,"56",NULL,NULL,NULL,NULL,NULL,,,NULL,NULL,NULL,"1204"I would like to have a command to update the joomla-database and its table joomlaprefix_comprofiler continously from jverein-Database.
The joomlaprefix_comprofiler -table in the joomla-database looks like this
"id","user_id","firstname","middlename","lastname","hits","message_last_sent","message_number_sent","avatar","avatarapproved","canvas","canvasapproved","approved","confirmed","lastupdatedate","registeripaddr","cbactivation","banned","banneddate","unbanneddate","bannedby","unbannedby","bannedreason","acceptedterms","cb_street","cb_zip","cb_city","cb_phone","cb_fax","cb_mobile","cb_position","cb_company","cb_club","cb_klasse","cb_mannschaft","cb_eintritt","cb_austritt","cb_funktion"
"313","313","John",NULL,"Doe","0","0000-00-00 00:00:00","0","picture.jpg","1","gallery/picture2.jpg","1","1","1","2016-03-12 10:10:33",,,"0",NULL,NULL,NULL,NULL,NULL,"1","Any Street 11","12345","Anytown","+49 555 123456",,"+49 555 654321","GF","Any Company",,,,"0000-00-00","0000-00-00","Sponsor"What are your thoughts on this? Thank you!
Last edit: 7 years 9 months ago by webminbw.
Please Log in to join the conversation.
nant
Team Member- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
7 years 9 months ago #283074
by nant
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Replied by nant on topic Keep Club-Members in sync with community builder
Sorry, no experience with this JVERIN system.
It would have to trigger the changes from that end.
It would have to trigger the changes from that end.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
- webminbw
- OFFLINE
-
New Member
- Posts: 2
- Thanks: 0
- Karma: 0
7 years 9 months ago #283136
by webminbw
Replied by webminbw on topic Keep Club-Members in sync with community builder
But am I on the right track here? JVerein is a club management system based on hibiscus, a banking software
github.com/willuhn/repositories
Any ideas though? Thank you already.
github.com/willuhn/repositories
Any ideas though? Thank you already.
Please Log in to join the conversation.
- nant
- Team Member
- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
7 years 9 months ago #283139
by nant
No idea.
Joomlapolis has CB Paid Subscriptions solution for membership sites:
www.joomlapolis.com/addons/cb-paid-subscriptions
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Replied by nant on topic Keep Club-Members in sync with community builder
webminbw wrote: But am I on the right track here? JVerein is a club management system based on hibiscus, a banking software
github.com/willuhn/repositories
Any ideas though? Thank you already.
No idea.
Joomlapolis has CB Paid Subscriptions solution for membership sites:
www.joomlapolis.com/addons/cb-paid-subscriptions
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.216 seconds
-
You are here:
- Home
- Forums
- Community Discussions
- Community Builder
- Keep Club-Members in sync with community builder