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:
Code:
"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
Code:
"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!
nant