Start admin_users_importcsv_2_step2 process on 27/10/2024-07:33 Open input file: /var/www/html/mioteamdata/communities/7X1EdiHL2k/config/data (7)241027071023.csv First line with columns header read Line contains 25 fiels Query to create the temporary table is: CREATE TABLE `mioteam`.`AA_TEMP_IMPORT_241027071023` ( `id` INT NOT NULL AUTO_INCREMENT , `col0` VARCHAR(150) , `col1` VARCHAR(150) , `col2` VARCHAR(150) , `col3` VARCHAR(150) , `col4` VARCHAR(150) , `col5` VARCHAR(150) , `col6` VARCHAR(150) , `col7` VARCHAR(150) , `col8` VARCHAR(150) , `col9` VARCHAR(150) , `col10` VARCHAR(150) , `col11` VARCHAR(150) , `col12` VARCHAR(150) , `col13` VARCHAR(150) , `col14` VARCHAR(150) , `col15` VARCHAR(150) , `col16` VARCHAR(150) , `col17` VARCHAR(150) , `col18` VARCHAR(150) , `col19` VARCHAR(150) , `col20` VARCHAR(150) , `col21` VARCHAR(150) , `col22` VARCHAR(150) , `col23` VARCHAR(150) , `col24` VARCHAR(150) , PRIMARY KEY (`id`)) ENGINE = InnoDB; Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241027071023 (`col0` , `col1` , `col2` , `col3` , `col4` , `col5` , `col6` , `col7` , `col8` , `col9` , `col10` , `col11` , `col12` , `col13` , `col14` , `col15` , `col16` , `col17` , `col18` , `col19` , `col20` , `col21` , `col22` , `col23` , `col24` ) VALUES ("Gruppo", "Cognome", "Nome", "Email", "Telefono", "Data di Nascita", "Luogo di Nascita", "Contatto 1", "Email 1", "Telefono 1", "Contatto 2", "Email 2", "Telefono 2", "Codice Fiscale", "Data Scadenza Codice Fiscale", "Data Scadenza Visita", "Data Scadenza Antitetanica", "Tipo Documento Identita", "Numero Documento Identita", "Data Scadenza Documento Identita", "Numero Tessera", "Data Scadenza Tessera", "Iscrizione Annuale", "Data Scadenza Iscrizione Annuale", "Indirizzo"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241027071023 (`col0` , `col1` , `col2` , `col3` , `col4` , `col5` , `col6` , `col7` , `col8` , `col9` , `col10` , `col11` , `col12` , `col13` , `col14` , `col15` , `col16` , `col17` , `col18` , `col19` , `col20` , `col21` , `col22` , `col23` , `col24` ) VALUES ("Agonisti", "Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "31/03/2010", "Sassari", "", "", "3492947510", "", "", "", "RRSGRL10C31I452T", "", "10/12/2025", "", "", "", "", "149377", "31/12/2024", "S", "31/12/2024", "Piazzale Segni 410"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241027071023 (`col0` , `col1` , `col2` , `col3` , `col4` , `col5` , `col6` , `col7` , `col8` , `col9` , `col10` , `col11` , `col12` , `col13` , `col14` , `col15` , `col16` , `col17` , `col18` , `col19` , `col20` , `col21` , `col22` , `col23` , `col24` ) VALUES ("Agonisti", "Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "26/07/1981", "BURCEI", "", "", "", "", "", "", "TZNGLI81L66B274O", "", "11/12/2024", "", "", "", "", "144279", "31/12/2024", "S", "31/12/2024", "Viale Sicilia 18"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241027071023 (`col0` , `col1` , `col2` , `col3` , `col4` , `col5` , `col6` , `col7` , `col8` , `col9` , `col10` , `col11` , `col12` , `col13` , `col14` , `col15` , `col16` , `col17` , `col18` , `col19` , `col20` , `col21` , `col22` , `col23` , `col24` ) VALUES ("Agonisti", "Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "30/07/1988", "Bagno a Ripoli", "", "", "", "", "", "", "BZZLNE88L70A564U", "", "11/04/2026", "", "", "", "", "139439", "31/12/2024", "S", "31/12/2024", "VIA BIASI 14"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241027071023 (`col0` , `col1` , `col2` , `col3` , `col4` , `col5` , `col6` , `col7` , `col8` , `col9` , `col10` , `col11` , `col12` , `col13` , `col14` , `col15` , `col16` , `col17` , `col18` , `col19` , `col20` , `col21` , `col22` , `col23` , `col24` ) VALUES ("Agonisti", "Budroni", "Greta", "budroni38@gmail.com", "3713363193", "01/02/2007", "Sassari", "", "", "3937227533", "", "", "", "BDRGRT07B41I452F", "", "10/12/2025", "", "", "", "", "139440", "31/12/2024", "S", "31/12/2024", "Via Rockfeller 2A"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241027071023 (`col0` , `col1` , `col2` , `col3` , `col4` , `col5` , `col6` , `col7` , `col8` , `col9` , `col10` , `col11` , `col12` , `col13` , `col14` , `col15` , `col16` , `col17` , `col18` , `col19` , `col20` , `col21` , `col22` , `col23` , `col24` ) VALUES ("Agonisti", "Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "29/06/1995", "Sassari", "", "", "", "", "", "", "CRPPRP95H29I452A", "", "22/04/2015", "", "", "", "", "96010", "31/12/2024", "S", "31/12/2024", "S.v tignoni monti minuddu 541"); Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_241027071023` ; *************** All done!!! Import successfully Completed Start admin_users_importcsv_2_step2 process on 27/10/2024-07:33 Query to get line with titles: SELECT * FROM `AA_TEMP_IMPORT_241027071023` WHERE `id` = 1; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "data di nascita"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "7T0grTL8S0"; Code for this custom field code : 7T0grTL8S0 Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 1 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("7T0grTL8S0","7X1EdiHL2k","7T0grTL8S0","1", "0", "1", "0","1","Data di Nascita"); Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "luogo di nascita"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "f4p8GiLb1F"; Code for this custom field code : f4p8GiLb1F Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 2 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("f4p8GiLb1F","7X1EdiHL2k","f4p8GiLb1F","1", "0", "1", "0","2","Luogo di Nascita"); Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "contatto 1"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "gYXmCGCMgY"; Code for this custom field code : gYXmCGCMgY Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 3 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("gYXmCGCMgY","7X1EdiHL2k","gYXmCGCMgY","1", "0", "1", "0","3","Contatto 1"); Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "email 1"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "N9ar9nzSFF"; Code for this custom field code : N9ar9nzSFF Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 4 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("N9ar9nzSFF","7X1EdiHL2k","N9ar9nzSFF","1", "0", "1", "0","4","Email 1"); Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "telefono 1"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "AbTtdkFI8o"; Code for this custom field code : AbTtdkFI8o Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 5 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("AbTtdkFI8o","7X1EdiHL2k","AbTtdkFI8o","1", "0", "1", "0","5","Telefono 1"); Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "contatto 2"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "OpAj1fPtpD"; Code for this custom field code : OpAj1fPtpD Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 6 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("OpAj1fPtpD","7X1EdiHL2k","OpAj1fPtpD","1", "0", "1", "0","6","Contatto 2"); Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "email 2"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "V3CyJZ139e"; Code for this custom field code : V3CyJZ139e Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 7 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("V3CyJZ139e","7X1EdiHL2k","V3CyJZ139e","1", "0", "1", "0","7","Email 2"); Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "telefono 2"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "ni1x9klY2C"; Code for this custom field code : ni1x9klY2C Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 8 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("ni1x9klY2C","7X1EdiHL2k","ni1x9klY2C","1", "0", "1", "0","8","Telefono 2"); Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "data scadenza codice fiscale"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "myC7oWrjAI"; Code for this custom field code : myC7oWrjAI Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 9 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("myC7oWrjAI","7X1EdiHL2k","myC7oWrjAI","1", "0", "1", "0","9","Data Scadenza Codice Fiscale"); Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "data scadenza antitetanica"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "mCMvyAezOc"; Code for this custom field code : mCMvyAezOc Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 10 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("mCMvyAezOc","7X1EdiHL2k","mCMvyAezOc","1", "0", "1", "0","10","Data Scadenza Antitetanica"); Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "numero documento identita"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "9TbpWo8I37"; Code for this custom field code : 9TbpWo8I37 Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 11 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("9TbpWo8I37","7X1EdiHL2k","9TbpWo8I37","1", "0", "1", "0","11","Numero Documento Identita"); Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "numero tessera"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "v8insK5BHF"; Code for this custom field code : v8insK5BHF Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 12 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("v8insK5BHF","7X1EdiHL2k","v8insK5BHF","1", "0", "1", "0","12","Numero Tessera"); Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "iscrizione annuale"; Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "qpFFXOU17J"; Code for this custom field code : qpFFXOU17J Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" ORDER BY `fieldscom`.`ycord` DESC; ycord for this custom field: 13 Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("qpFFXOU17J","7X1EdiHL2k","qpFFXOU17J","1", "0", "1", "0","13","Iscrizione Annuale"); 1 - Gruppo => |gruppo 2 - Cognome => Cognome 3 - Nome => Nome 4 - Email => Email 5 - Telefono => NumeroTelefono 6 - Data di Nascita => _7T0grTL8S0 7 - Luogo di Nascita => _f4p8GiLb1F 8 - Contatto 1 => _gYXmCGCMgY 9 - Email 1 => _N9ar9nzSFF 10 - Telefono 1 => _AbTtdkFI8o 11 - Contatto 2 => _OpAj1fPtpD 12 - Email 2 => _V3CyJZ139e 13 - Telefono 2 => _ni1x9klY2C 14 - Codice Fiscale => CodiceFiscale 15 - Data Scadenza Codice Fiscale => _myC7oWrjAI 16 - Data Scadenza Visita => DataScadenzaVisita 17 - Data Scadenza Antitetanica => _mCMvyAezOc 18 - Tipo Documento Identita => TipoDocumentoIdentita 19 - Numero Documento Identita => _9TbpWo8I37 20 - Data Scadenza Documento Identita => DataScadenzaDocumentoIdentita 21 - Numero Tessera => _v8insK5BHF 22 - Data Scadenza Tessera => DataScadenzaTessera 23 - Iscrizione Annuale => _qpFFXOU17J 24 - Data Scadenza Iscrizione Annuale => DataScadenzaIscrizioneAnnuale 25 - Indirizzo => Indirizzo Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_241027071023` WHERE `id` > 1; Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/7X1EdiHL2k/usersfolders/Gabriele.Arras2 Directory succesfully created Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "7T0grTL8S0", "31/03/2010"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "f4p8GiLb1F", "Sassari"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "gYXmCGCMgY", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "N9ar9nzSFF", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "AbTtdkFI8o", "3492947510"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "OpAj1fPtpD", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "V3CyJZ139e", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "ni1x9klY2C", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "myC7oWrjAI", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "mCMvyAezOc", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "9TbpWo8I37", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "v8insK5BHF", "149377"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras2", "qpFFXOU17J", "S"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras2", "7X1EdiHL2k", "XwRrzYSUsH", "0", "XwRrzYSUsH", "10", "20241027073341", "20241027073341","importCsv"); Query to check if group exists: SELECT * FROM `groups` WHERE `CodiceCommunity` = "7X1EdiHL2k" AND `Nome` = "Agonisti"; Query to create new group/user: INSERT INTO `groups_users` (`CodiceCommunity`,`GruppoID`,`UserID`) VALUES ("7X1EdiHL2k","3387","Gabriele.Arras2"); *************** User Gabriele.Arras2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/7X1EdiHL2k/usersfolders/Giulia.Atzeni3 Directory succesfully created Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "7T0grTL8S0", "26/07/1981"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "f4p8GiLb1F", "BURCEI"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "gYXmCGCMgY", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "N9ar9nzSFF", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "AbTtdkFI8o", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "OpAj1fPtpD", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "V3CyJZ139e", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "ni1x9klY2C", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "myC7oWrjAI", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "mCMvyAezOc", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "9TbpWo8I37", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "v8insK5BHF", "144279"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni3", "qpFFXOU17J", "S"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11/12/2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni3", "7X1EdiHL2k", "UDMhRfM2DR", "0", "UDMhRfM2DR", "10", "20241027073342", "20241027073342","importCsv"); Query to check if group exists: SELECT * FROM `groups` WHERE `CodiceCommunity` = "7X1EdiHL2k" AND `Nome` = "Agonisti"; Query to create new group/user: INSERT INTO `groups_users` (`CodiceCommunity`,`GruppoID`,`UserID`) VALUES ("7X1EdiHL2k","3387","Giulia.Atzeni3"); *************** User Giulia.Atzeni3 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/7X1EdiHL2k/usersfolders/Elena.Bozzi3 Directory succesfully created Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "7T0grTL8S0", "30/07/1988"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "f4p8GiLb1F", "Bagno a Ripoli"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "gYXmCGCMgY", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "N9ar9nzSFF", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "AbTtdkFI8o", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "OpAj1fPtpD", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "V3CyJZ139e", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "ni1x9klY2C", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "myC7oWrjAI", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "mCMvyAezOc", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "9TbpWo8I37", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "v8insK5BHF", "139439"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi3", "qpFFXOU17J", "S"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "11/04/2026", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi3", "7X1EdiHL2k", "HZzg41oOYk", "0", "HZzg41oOYk", "10", "20241027073343", "20241027073343","importCsv"); Query to check if group exists: SELECT * FROM `groups` WHERE `CodiceCommunity` = "7X1EdiHL2k" AND `Nome` = "Agonisti"; Query to create new group/user: INSERT INTO `groups_users` (`CodiceCommunity`,`GruppoID`,`UserID`) VALUES ("7X1EdiHL2k","3387","Elena.Bozzi3"); *************** User Elena.Bozzi3 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/7X1EdiHL2k/usersfolders/Greta.Budroni2 Directory succesfully created Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "7T0grTL8S0", "01/02/2007"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "f4p8GiLb1F", "Sassari"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "gYXmCGCMgY", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "N9ar9nzSFF", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "AbTtdkFI8o", "3937227533"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "OpAj1fPtpD", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "V3CyJZ139e", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "ni1x9klY2C", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "myC7oWrjAI", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "mCMvyAezOc", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "9TbpWo8I37", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "v8insK5BHF", "139440"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni2", "qpFFXOU17J", "S"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/2025", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni2", "7X1EdiHL2k", "rQjQutvVlD", "0", "rQjQutvVlD", "10", "20241027073343", "20241027073343","importCsv"); Query to check if group exists: SELECT * FROM `groups` WHERE `CodiceCommunity` = "7X1EdiHL2k" AND `Nome` = "Agonisti"; Query to create new group/user: INSERT INTO `groups_users` (`CodiceCommunity`,`GruppoID`,`UserID`) VALUES ("7X1EdiHL2k","3387","Greta.Budroni2"); *************** User Greta.Budroni2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/7X1EdiHL2k/usersfolders/PietroPaolo.Carpentras2 Directory succesfully created Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "7T0grTL8S0", "29/06/1995"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "f4p8GiLb1F", "Sassari"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "gYXmCGCMgY", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "N9ar9nzSFF", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "AbTtdkFI8o", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "OpAj1fPtpD", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "V3CyJZ139e", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "ni1x9klY2C", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "myC7oWrjAI", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "mCMvyAezOc", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "9TbpWo8I37", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "v8insK5BHF", "96010"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras2", "qpFFXOU17J", "S"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras2", "7X1EdiHL2k", "16aiYMOPgz", "0", "16aiYMOPgz", "10", "20241027073344", "20241027073344","importCsv"); Query to check if group exists: SELECT * FROM `groups` WHERE `CodiceCommunity` = "7X1EdiHL2k" AND `Nome` = "Agonisti"; Query to create new group/user: INSERT INTO `groups_users` (`CodiceCommunity`,`GruppoID`,`UserID`) VALUES ("7X1EdiHL2k","3387","PietroPaolo.Carpentras2"); *************** User PietroPaolo.Carpentras2 succesfully added to MioTeam *************** All done!!! Import successfully Completed Start admin_users_importcsv_2_step2 process on 27/10/2024-07:38 Open input file: /var/www/html/mioteamdata/communities/7X1EdiHL2k/config/data (7)241027071007.csv First line with columns header read Line contains 25 fiels Query to create the temporary table is: CREATE TABLE `mioteam`.`AA_TEMP_IMPORT_241027071007` ( `id` INT NOT NULL AUTO_INCREMENT , `col0` VARCHAR(150) , `col1` VARCHAR(150) , `col2` VARCHAR(150) , `col3` VARCHAR(150) , `col4` VARCHAR(150) , `col5` VARCHAR(150) , `col6` VARCHAR(150) , `col7` VARCHAR(150) , `col8` VARCHAR(150) , `col9` VARCHAR(150) , `col10` VARCHAR(150) , `col11` VARCHAR(150) , `col12` VARCHAR(150) , `col13` VARCHAR(150) , `col14` VARCHAR(150) , `col15` VARCHAR(150) , `col16` VARCHAR(150) , `col17` VARCHAR(150) , `col18` VARCHAR(150) , `col19` VARCHAR(150) , `col20` VARCHAR(150) , `col21` VARCHAR(150) , `col22` VARCHAR(150) , `col23` VARCHAR(150) , `col24` VARCHAR(150) , PRIMARY KEY (`id`)) ENGINE = InnoDB; Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241027071007 (`col0` , `col1` , `col2` , `col3` , `col4` , `col5` , `col6` , `col7` , `col8` , `col9` , `col10` , `col11` , `col12` , `col13` , `col14` , `col15` , `col16` , `col17` , `col18` , `col19` , `col20` , `col21` , `col22` , `col23` , `col24` ) VALUES ("Gruppo", "Cognome", "Nome", "Email", "Telefono", "Data di Nascita", "Luogo di Nascita", "Contatto 1", "Email 1", "Telefono 1", "Contatto 2", "Email 2", "Telefono 2", "Codice Fiscale", "Data Scadenza Codice Fiscale", "Data Scadenza Visita", "Data Scadenza Antitetanica", "Tipo Documento Identita", "Numero Documento Identita", "Data Scadenza Documento Identita", "Numero Tessera", "Data Scadenza Tessera", "Iscrizione Annuale", "Data Scadenza Iscrizione Annuale", "Indirizzo"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241027071007 (`col0` , `col1` , `col2` , `col3` , `col4` , `col5` , `col6` , `col7` , `col8` , `col9` , `col10` , `col11` , `col12` , `col13` , `col14` , `col15` , `col16` , `col17` , `col18` , `col19` , `col20` , `col21` , `col22` , `col23` , `col24` ) VALUES ("Agonisti", "Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "31/03/2010", "Sassari", "", "", "3492947510", "", "", "", "RRSGRL10C31I452T", "", "10122025", "", "", "", "", "149377", "31/12/2024", "S", "31/12/2024", "Piazzale Segni 410"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241027071007 (`col0` , `col1` , `col2` , `col3` , `col4` , `col5` , `col6` , `col7` , `col8` , `col9` , `col10` , `col11` , `col12` , `col13` , `col14` , `col15` , `col16` , `col17` , `col18` , `col19` , `col20` , `col21` , `col22` , `col23` , `col24` ) VALUES ("Agonisti", "Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "26/07/1981", "BURCEI", "", "", "", "", "", "", "TZNGLI81L66B274O", "", "11-12-2024", "", "", "", "", "144279", "31/12/2024", "S", "31/12/2024", "Viale Sicilia 18"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241027071007 (`col0` , `col1` , `col2` , `col3` , `col4` , `col5` , `col6` , `col7` , `col8` , `col9` , `col10` , `col11` , `col12` , `col13` , `col14` , `col15` , `col16` , `col17` , `col18` , `col19` , `col20` , `col21` , `col22` , `col23` , `col24` ) VALUES ("Agonisti", "Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "30/07/1988", "Bagno a Ripoli", "", "", "", "", "", "", "BZZLNE88L70A564U", "", "2026-04-11", "", "", "", "", "139439", "31/12/2024", "S", "31/12/2024", "VIA BIASI 14"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241027071007 (`col0` , `col1` , `col2` , `col3` , `col4` , `col5` , `col6` , `col7` , `col8` , `col9` , `col10` , `col11` , `col12` , `col13` , `col14` , `col15` , `col16` , `col17` , `col18` , `col19` , `col20` , `col21` , `col22` , `col23` , `col24` ) VALUES ("Agonisti", "Budroni", "Greta", "budroni38@gmail.com", "3713363193", "01/02/2007", "Sassari", "", "", "3937227533", "", "", "", "BDRGRT07B41I452F", "", "10/12/25", "", "", "", "", "139440", "31/12/2024", "S", "31/12/2024", "Via Rockfeller 2A"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241027071007 (`col0` , `col1` , `col2` , `col3` , `col4` , `col5` , `col6` , `col7` , `col8` , `col9` , `col10` , `col11` , `col12` , `col13` , `col14` , `col15` , `col16` , `col17` , `col18` , `col19` , `col20` , `col21` , `col22` , `col23` , `col24` ) VALUES ("Agonisti", "Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "29/06/1995", "Sassari", "", "", "", "", "", "", "CRPPRP95H29I452A", "", "22/04/2015", "", "", "", "", "96010", "31/12/2024", "S", "31/12/2024", "S.v tignoni monti minuddu 541"); Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_241027071007` ; *************** All done!!! Import successfully Completed Start admin_users_importcsv_2_step2 process on 27/10/2024-07:38 Query to get line with titles: SELECT * FROM `AA_TEMP_IMPORT_241027071007` WHERE `id` = 1; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "data di nascita"; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "luogo di nascita"; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "contatto 1"; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "email 1"; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "telefono 1"; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "contatto 2"; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "email 2"; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "telefono 2"; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "data scadenza codice fiscale"; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "data scadenza antitetanica"; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "numero documento identita"; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "numero tessera"; Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "7X1EdiHL2k" AND `labelText` = "iscrizione annuale"; 1 - Gruppo => |gruppo 2 - Cognome => Cognome 3 - Nome => Nome 4 - Email => Email 5 - Telefono => NumeroTelefono 6 - Data di Nascita => _7T0grTL8S0 7 - Luogo di Nascita => _f4p8GiLb1F 8 - Contatto 1 => _gYXmCGCMgY 9 - Email 1 => _N9ar9nzSFF 10 - Telefono 1 => _AbTtdkFI8o 11 - Contatto 2 => _OpAj1fPtpD 12 - Email 2 => _V3CyJZ139e 13 - Telefono 2 => _ni1x9klY2C 14 - Codice Fiscale => CodiceFiscale 15 - Data Scadenza Codice Fiscale => _myC7oWrjAI 16 - Data Scadenza Visita => DataScadenzaVisita 17 - Data Scadenza Antitetanica => _mCMvyAezOc 18 - Tipo Documento Identita => TipoDocumentoIdentita 19 - Numero Documento Identita => _9TbpWo8I37 20 - Data Scadenza Documento Identita => DataScadenzaDocumentoIdentita 21 - Numero Tessera => _v8insK5BHF 22 - Data Scadenza Tessera => DataScadenzaTessera 23 - Iscrizione Annuale => _qpFFXOU17J 24 - Data Scadenza Iscrizione Annuale => DataScadenzaIscrizioneAnnuale 25 - Indirizzo => Indirizzo Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_241027071007` WHERE `id` > 1; Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/7X1EdiHL2k/usersfolders/Gabriele.Arras3 Directory succesfully created Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "7T0grTL8S0", "31/03/2010"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "f4p8GiLb1F", "Sassari"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "gYXmCGCMgY", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "N9ar9nzSFF", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "AbTtdkFI8o", "3492947510"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "OpAj1fPtpD", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "V3CyJZ139e", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "ni1x9klY2C", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "myC7oWrjAI", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "mCMvyAezOc", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "9TbpWo8I37", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "v8insK5BHF", "149377"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Gabriele.Arras3", "qpFFXOU17J", "S"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Arras", "Gabriele", "giusy_78@libero.it", "3517388472", "RRSGRL10C31I452T", "10122025", "", "", "31/12/2024", "31/12/2024", "Gabriele.Arras3", "7X1EdiHL2k", "ozfhH0t69b", "0", "ozfhH0t69b", "10", "20241027073830", "20241027073830","importCsv"); Query to check if group exists: SELECT * FROM `groups` WHERE `CodiceCommunity` = "7X1EdiHL2k" AND `Nome` = "Agonisti"; Query to create new group/user: INSERT INTO `groups_users` (`CodiceCommunity`,`GruppoID`,`UserID`) VALUES ("7X1EdiHL2k","3387","Gabriele.Arras3"); *************** User Gabriele.Arras3 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/7X1EdiHL2k/usersfolders/Giulia.Atzeni4 Directory succesfully created Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "7T0grTL8S0", "26/07/1981"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "f4p8GiLb1F", "BURCEI"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "gYXmCGCMgY", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "N9ar9nzSFF", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "AbTtdkFI8o", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "OpAj1fPtpD", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "V3CyJZ139e", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "ni1x9klY2C", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "myC7oWrjAI", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "mCMvyAezOc", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "9TbpWo8I37", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "v8insK5BHF", "144279"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Giulia.Atzeni4", "qpFFXOU17J", "S"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Atzeni", "Giulia", "giulia.atzeni@gmail.com", "3664763217", "TZNGLI81L66B274O", "11-12-2024", "", "", "31/12/2024", "31/12/2024", "Giulia.Atzeni4", "7X1EdiHL2k", "yljFUDg8dh", "0", "yljFUDg8dh", "10", "20241027073831", "20241027073831","importCsv"); Query to check if group exists: SELECT * FROM `groups` WHERE `CodiceCommunity` = "7X1EdiHL2k" AND `Nome` = "Agonisti"; Query to create new group/user: INSERT INTO `groups_users` (`CodiceCommunity`,`GruppoID`,`UserID`) VALUES ("7X1EdiHL2k","3387","Giulia.Atzeni4"); *************** User Giulia.Atzeni4 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/7X1EdiHL2k/usersfolders/Elena.Bozzi4 Directory succesfully created Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "7T0grTL8S0", "30/07/1988"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "f4p8GiLb1F", "Bagno a Ripoli"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "gYXmCGCMgY", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "N9ar9nzSFF", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "AbTtdkFI8o", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "OpAj1fPtpD", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "V3CyJZ139e", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "ni1x9klY2C", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "myC7oWrjAI", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "mCMvyAezOc", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "9TbpWo8I37", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "v8insK5BHF", "139439"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Elena.Bozzi4", "qpFFXOU17J", "S"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Bozzi", "Elena", "bozzielena5@gmail.com", "3489312126", "BZZLNE88L70A564U", "2026-04-11", "", "", "31/12/2024", "31/12/2024", "Elena.Bozzi4", "7X1EdiHL2k", "oWCSALG85O", "0", "oWCSALG85O", "10", "20241027073832", "20241027073832","importCsv"); Query to check if group exists: SELECT * FROM `groups` WHERE `CodiceCommunity` = "7X1EdiHL2k" AND `Nome` = "Agonisti"; Query to create new group/user: INSERT INTO `groups_users` (`CodiceCommunity`,`GruppoID`,`UserID`) VALUES ("7X1EdiHL2k","3387","Elena.Bozzi4"); *************** User Elena.Bozzi4 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/7X1EdiHL2k/usersfolders/Greta.Budroni3 Directory succesfully created Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "7T0grTL8S0", "01/02/2007"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "f4p8GiLb1F", "Sassari"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "gYXmCGCMgY", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "N9ar9nzSFF", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "AbTtdkFI8o", "3937227533"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "OpAj1fPtpD", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "V3CyJZ139e", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "ni1x9klY2C", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "myC7oWrjAI", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "mCMvyAezOc", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "9TbpWo8I37", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "v8insK5BHF", "139440"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "Greta.Budroni3", "qpFFXOU17J", "S"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Budroni", "Greta", "budroni38@gmail.com", "3713363193", "BDRGRT07B41I452F", "10/12/25", "", "", "31/12/2024", "31/12/2024", "Greta.Budroni3", "7X1EdiHL2k", "P6IV0U0k5F", "0", "P6IV0U0k5F", "10", "20241027073833", "20241027073833","importCsv"); Query to check if group exists: SELECT * FROM `groups` WHERE `CodiceCommunity` = "7X1EdiHL2k" AND `Nome` = "Agonisti"; Query to create new group/user: INSERT INTO `groups_users` (`CodiceCommunity`,`GruppoID`,`UserID`) VALUES ("7X1EdiHL2k","3387","Greta.Budroni3"); *************** User Greta.Budroni3 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/7X1EdiHL2k/usersfolders/PietroPaolo.Carpentras3 Directory succesfully created Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "7T0grTL8S0", "29/06/1995"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "f4p8GiLb1F", "Sassari"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "gYXmCGCMgY", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "N9ar9nzSFF", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "AbTtdkFI8o", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "OpAj1fPtpD", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "V3CyJZ139e", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "ni1x9klY2C", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "myC7oWrjAI", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "mCMvyAezOc", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "9TbpWo8I37", ""); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "v8insK5BHF", "96010"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to add user to add custom field value: INSERT INTO `cfields_values` (`codiceCommunity`, `username`, `idField`, `value`) VALUES ("7X1EdiHL2k", "PietroPaolo.Carpentras3", "qpFFXOU17J", "S"); INSERT INTO `anagrafica` (`Cognome` , `Nome` , `Email` , `NumeroTelefono` , `CodiceFiscale` , `DataScadenzaVisita` , `TipoDocumentoIdentita` , `DataScadenzaDocumentoIdentita` , `DataScadenzaTessera` , `DataScadenzaIscrizioneAnnuale` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Carpentras", "Pietro Paolo", "pietropaolo.carpentras@outlook.it", "3404211512", "CRPPRP95H29I452A", "22/04/2015", "", "", "31/12/2024", "31/12/2024", "PietroPaolo.Carpentras3", "7X1EdiHL2k", "EJtr61npK9", "0", "EJtr61npK9", "10", "20241027073834", "20241027073834","importCsv"); Query to check if group exists: SELECT * FROM `groups` WHERE `CodiceCommunity` = "7X1EdiHL2k" AND `Nome` = "Agonisti"; Query to create new group/user: INSERT INTO `groups_users` (`CodiceCommunity`,`GruppoID`,`UserID`) VALUES ("7X1EdiHL2k","3387","PietroPaolo.Carpentras3"); *************** User PietroPaolo.Carpentras3 succesfully added to MioTeam *************** All done!!! Import successfully Completed