Start admin_users_importcsv_2_step2 process on 29/04/2024-17:22

Open input file: /var/www/html/mioteamdata/communities/JKkP3wv5R3/config/cartel1240429170407.csv
First line with columns header read
Line contains 26 fiels

Query to create the temporary table is: CREATE TABLE `mioteam`.`AA_TEMP_IMPORT_240429170407` ( `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) , `col25` VARCHAR(150) , PRIMARY KEY (`id`)) ENGINE = InnoDB; 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10", "Column11", "Column12", "Column13", "Column14", "Column15", "Column16", "Column17", "Column18", "Column19", "Column20", "Column21", "Column22", "Column23", "Column24", "Column25", "Column26"); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) 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_240429170407 (`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` , `col25` ) VALUES ("", "Pasotti", "Andrea", "andreapaso@tiscali.it", "", "00/00/0000", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "N", "", "", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Bazzani", "Lorenzo", "", "389 2673325", "02/04/1999", "Brescia", "", "", "", "", "", "", "BZZLNZ99D02B157N", "", "12/02/2024", "", "", "", "", "AT-02505717", "", "", "12/09/23", "Via Valbella 24 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Cavagna", "Manuel", "", "366 2744856", "09/11/1997", "Brescia", "", "", "", "", "", "", "CVGMNL97S09B157M", "", "", "", "", "", "", "AT-02505229", "", "", "11/09/23", "Via San Filippo Neri 45 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Cocca", "Andrea", "", "335 5248087", "12/08/1979", "Brescia", "", "", "", "", "", "", "CCCNRP79M12B157R", "", "", "", "", "", "", "AT-02505230", "", "", "11/09/23", "Via Cesare Scaluggia 44 25069 Villa Carcina (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Cornacchiari", "Filippo", "", "334 7561409", "28/12/1997", "Gavardo", "", "", "", "", "", "", "CRNFPP97T28D940B", "", "", "", "", "", "", "AT-02505231", "", "", "11/09/23", "Via Strada Piana 24 25071 Agnosine (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Donati", "Alessio", "", "338 6591854", "11/04/1993", "Gardone Val Trompia", "", "", "", "", "", "", "DNTLSS93D11D918V", "", "06/10/2024", "", "", "", "", "AT-02505378", "", "", "11/09/23", "Via XXV Aprile 21 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Ghidini", "Giacomo", "ghidini.giacomo33@gmail.com", "338 7046184", "05/04/1994", "Brescia", "", "", "", "", "", "", "GHDGCM94D05B157Q", "", "21/02/2024", "", "", "", "", "AT-02505237", "", "", "11/09/23", "Via Repubblica 12 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Ghidini", "Riccardo", "", "334 1615087", "17/08/1997", "Brescia", "", "", "", "", "", "", "GHDRCR97M17B157Z", "", "", "", "", "", "", "AT-02505238", "", "", "11/09/23", "Via Sant'Andrea 98 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Graziotti", "Giulio", "g.grazio@libero.it", "333 1561532", "27/10/1993", "Brescia", "", "", "", "", "", "", "GRZGLI93R27B157R", "", "", "", "", "", "", "AT-02528398", "", "", "16/12/23", "Via Caselli 42 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Guagnetti", "Daniel", "", "331 4464492", "30/01/2004", "Gardone Val Trompia", "", "", "", "", "", "", "GGNDNL04A30D918Z", "", "", "", "", "", "", "AT-02505721", "", "", "12/09/23", "Via Renzo 10 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Lena", "Nicola", "", "389 1449783", "12/06/1992", "Brescia", "", "", "", "", "", "", "LNENCL92H12B157U", "", "16/02/2024", "", "", "", "", "AT-02505239", "", "", "11/09/23", "Via Padre Bolognini 52 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Mori", "Paolo", "mori92lume@hotmail.com", "333 9227260", "06/02/1992", "Gardone Val Trompia", "", "", "", "", "", "", "MROPLA92B06D918R", "", "", "", "", "", "", "AT-02505241", "", "", "11/09/23", "Via D. Alighieri 28 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Pasotti", "Andrea", "", "392 7905885", "24/12/1979", "Brescia", "", "", "", "", "", "", "PSTNDR79T24B157Q", "", "", "", "", "", "", "NA-02500434", "", "", "20/07/23", "Via XXV Aprile 18/A 25068 Sarezzo (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Potenza", "Luigi", "luigi.potenza@icloud.com", "320 5529590", "23/02/1992", "Gardone Val Trompia", "", "", "", "", "", "", "PTNLGU92B23D918I", "", "", "", "", "", "", "AT-02505243", "", "", "11/09/23", "Via V. Montini 178 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Primerano", "Simone", "", "380 4940271", "09/06/1998", "Brescia", "", "", "", "", "", "", "PRMSMN98H09B157V", "", "", "", "", "", "", "AT-02504162", "", "", "07/09/23", "Via M. Zanagnolo 25/S 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Raza", "Marco", "razamarco6@gmail.com", "328 6844822", "10/08/1993", "Gardone Val Trompia", "", "", "", "", "", "", "RZAMCF93M10D918O", "", "", "", "", "", "", "AT-02505244", "", "", "11/09/23", "Vicolo Fratte 5 25064 Gussago (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Sabiu", "Stefano", "", "331 3154966", "31/03/1999", "Gardone Val Trompia", "", "", "", "", "", "", "SBASFN99C31D918K", "", "", "", "", "", "", "AT-02505722", "", "", "12/09/23", "Via Maestro Zanagnolo 23 Z 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Sanzogni", "Carlo", "sanzo.94@hotmail.com", "388 3214271", "08/04/1994", "Brescia", "", "", "", "", "", "", "SNZCRL94D08B157N", "", "", "", "", "", "", "AT-02505247", "", "", "11/09/23", "Via S. G. Battista 75 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Tampalini", "Pierangelo", "", "334 1118733", "17/06/1992", "Brescia", "", "", "", "", "", "", "TMPPNG92H17B157V", "", "", "", "", "", "", "AT-02505248", "", "", "11/09/23", "Via Caselli 75 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Vivenzi", "Alberto", "albo.vivenzi@hotmail.com", "333 6993319", "03/08/1992", "Brescia", "", "", "", "", "", "", "VVNLRT92M03B157E", "", "", "", "", "", "", "AT-02505251", "", "", "11/09/23", "Via G. Matteotti 67 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170407 (`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` , `col25` ) VALUES ("", "Zanetti", "Riccardo", "riccardozanetti22@gmail.com", "333 4076239", "24/06/1992", "Gardone Val Trompia", "", "", "", "", "", "", "ZNTRCR92H24D918C", "", "", "", "", "", "", "AT-02505255", "", "", "11/09/23", "Via Zanagnolo 2 25065 Lumezzane (BS)", ""); 

Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_240429170407` ; 

*************** All done!!! Import successfully Completed
Start admin_users_importcsv_2_step2 process on 29/04/2024-17:22


Query to get line with titles: SELECT * FROM `AA_TEMP_IMPORT_240429170407` WHERE `id` = 1; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column1"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "gi7oSbZKgK"; 

Code for this custom field code : gi7oSbZKgK 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" 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 ("gi7oSbZKgK","JKkP3wv5R3","gi7oSbZKgK","1", "0", "1", "0","2","Column1");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column2"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "oFHmXBWa6i"; 

Code for this custom field code : oFHmXBWa6i 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" 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 ("oFHmXBWa6i","JKkP3wv5R3","oFHmXBWa6i","1", "0", "1", "0","3","Column2");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column3"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "r0uugLaVSB"; 

Code for this custom field code : r0uugLaVSB 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" 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 ("r0uugLaVSB","JKkP3wv5R3","r0uugLaVSB","1", "0", "1", "0","4","Column3");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column4"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "JvtuGFSUkG"; 

Code for this custom field code : JvtuGFSUkG 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" 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 ("JvtuGFSUkG","JKkP3wv5R3","JvtuGFSUkG","1", "0", "1", "0","5","Column4");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column5"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "3QbeXPXKkc"; 

Code for this custom field code : 3QbeXPXKkc 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" 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 ("3QbeXPXKkc","JKkP3wv5R3","3QbeXPXKkc","1", "0", "1", "0","6","Column5");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column6"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "EW5w3YMU7H"; 

Code for this custom field code : EW5w3YMU7H 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" 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 ("EW5w3YMU7H","JKkP3wv5R3","EW5w3YMU7H","1", "0", "1", "0","7","Column6");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column7"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "lhDBB5ZL91"; 

Code for this custom field code : lhDBB5ZL91 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" 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 ("lhDBB5ZL91","JKkP3wv5R3","lhDBB5ZL91","1", "0", "1", "0","8","Column7");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column8"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "3oYSQ7oBk9"; 

Code for this custom field code : 3oYSQ7oBk9 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" 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 ("3oYSQ7oBk9","JKkP3wv5R3","3oYSQ7oBk9","1", "0", "1", "0","9","Column8");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column9"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "iq6lODtLXf"; 

Code for this custom field code : iq6lODtLXf 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" 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 ("iq6lODtLXf","JKkP3wv5R3","iq6lODtLXf","1", "0", "1", "0","10","Column9");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column10"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "90LO6wkxo4"; 

Code for this custom field code : 90LO6wkxo4 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" 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 ("90LO6wkxo4","JKkP3wv5R3","90LO6wkxo4","1", "0", "1", "0","11","Column10");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column11"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "WHVhPFWFLH"; 

Code for this custom field code : WHVhPFWFLH 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" 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 ("WHVhPFWFLH","JKkP3wv5R3","WHVhPFWFLH","1", "0", "1", "0","12","Column11");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column12"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "fX26KCKXcQ"; 

Code for this custom field code : fX26KCKXcQ 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" 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 ("fX26KCKXcQ","JKkP3wv5R3","fX26KCKXcQ","1", "0", "1", "0","13","Column12");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column13"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "TTaRHfyAly"; 

Code for this custom field code : TTaRHfyAly 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 14 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("TTaRHfyAly","JKkP3wv5R3","TTaRHfyAly","1", "0", "1", "0","14","Column13");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column14"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "38UITn4LdR"; 

Code for this custom field code : 38UITn4LdR 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 15 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("38UITn4LdR","JKkP3wv5R3","38UITn4LdR","1", "0", "1", "0","15","Column14");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column15"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "5HfQqNsKrY"; 

Code for this custom field code : 5HfQqNsKrY 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 16 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("5HfQqNsKrY","JKkP3wv5R3","5HfQqNsKrY","1", "0", "1", "0","16","Column15");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column16"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "mEloVOaURi"; 

Code for this custom field code : mEloVOaURi 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 17 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("mEloVOaURi","JKkP3wv5R3","mEloVOaURi","1", "0", "1", "0","17","Column16");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column17"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "zlCnqMYarM"; 

Code for this custom field code : zlCnqMYarM 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 18 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("zlCnqMYarM","JKkP3wv5R3","zlCnqMYarM","1", "0", "1", "0","18","Column17");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column18"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "6hky9bXvrn"; 

Code for this custom field code : 6hky9bXvrn 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 19 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("6hky9bXvrn","JKkP3wv5R3","6hky9bXvrn","1", "0", "1", "0","19","Column18");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column19"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "hgIMonQObG"; 

Code for this custom field code : hgIMonQObG 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 20 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("hgIMonQObG","JKkP3wv5R3","hgIMonQObG","1", "0", "1", "0","20","Column19");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column20"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "mrsKXYCv1f"; 

Code for this custom field code : mrsKXYCv1f 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 21 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("mrsKXYCv1f","JKkP3wv5R3","mrsKXYCv1f","1", "0", "1", "0","21","Column20");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column21"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "N6Ezn1I0O1"; 

Code for this custom field code : N6Ezn1I0O1 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 22 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("N6Ezn1I0O1","JKkP3wv5R3","N6Ezn1I0O1","1", "0", "1", "0","22","Column21");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column22"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "61dNnF9oR4"; 

Code for this custom field code : 61dNnF9oR4 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 23 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("61dNnF9oR4","JKkP3wv5R3","61dNnF9oR4","1", "0", "1", "0","23","Column22");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column23"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "TTj8EeSEYT"; 

Code for this custom field code : TTj8EeSEYT 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 24 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("TTj8EeSEYT","JKkP3wv5R3","TTj8EeSEYT","1", "0", "1", "0","24","Column23");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column24"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "YtlUnDWWcJ"; 

Code for this custom field code : YtlUnDWWcJ 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 25 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("YtlUnDWWcJ","JKkP3wv5R3","YtlUnDWWcJ","1", "0", "1", "0","25","Column24");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column25"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "7yYm1DGU4O"; 

Code for this custom field code : 7yYm1DGU4O 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 26 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("7yYm1DGU4O","JKkP3wv5R3","7yYm1DGU4O","1", "0", "1", "0","26","Column25");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column26"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "9BdneyLv8O"; 

Code for this custom field code : 9BdneyLv8O 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 27 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("9BdneyLv8O","JKkP3wv5R3","9BdneyLv8O","1", "0", "1", "0","27","Column26");  

*************** All done!!! Import successfully Completed
Start admin_users_importcsv_2_step2 process on 29/04/2024-17:23

Open input file: /var/www/html/mioteamdata/communities/JKkP3wv5R3/config/cartel1240429170414.csv
First line with columns header read
Line contains 26 fiels

Query to create the temporary table is: CREATE TABLE `mioteam`.`AA_TEMP_IMPORT_240429170414` ( `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) , `col25` VARCHAR(150) , PRIMARY KEY (`id`)) ENGINE = InnoDB; 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10", "Column11", "Column12", "Column13", "Column14", "Column15", "Column16", "Column17", "Column18", "Column19", "Column20", "Column21", "Column22", "Column23", "Column24", "Column25", "Column26"); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) 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_240429170414 (`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` , `col25` ) VALUES ("", "Bazzani", "Lorenzo", "", "389 2673325", "02/04/1999", "Brescia", "", "", "", "", "", "", "BZZLNZ99D02B157N", "", "12/02/2024", "", "", "", "", "AT-02505717", "", "", "12/09/23", "Via Valbella 24 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Cavagna", "Manuel", "", "366 2744856", "09/11/1997", "Brescia", "", "", "", "", "", "", "CVGMNL97S09B157M", "", "", "", "", "", "", "AT-02505229", "", "", "11/09/23", "Via San Filippo Neri 45 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Cocca", "Andrea", "", "335 5248087", "12/08/1979", "Brescia", "", "", "", "", "", "", "CCCNRP79M12B157R", "", "", "", "", "", "", "AT-02505230", "", "", "11/09/23", "Via Cesare Scaluggia 44 25069 Villa Carcina (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Cornacchiari", "Filippo", "", "334 7561409", "28/12/1997", "Gavardo", "", "", "", "", "", "", "CRNFPP97T28D940B", "", "", "", "", "", "", "AT-02505231", "", "", "11/09/23", "Via Strada Piana 24 25071 Agnosine (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Donati", "Alessio", "", "338 6591854", "11/04/1993", "Gardone Val Trompia", "", "", "", "", "", "", "DNTLSS93D11D918V", "", "06/10/2024", "", "", "", "", "AT-02505378", "", "", "11/09/23", "Via XXV Aprile 21 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Ghidini", "Giacomo", "ghidini.giacomo33@gmail.com", "338 7046184", "05/04/1994", "Brescia", "", "", "", "", "", "", "GHDGCM94D05B157Q", "", "21/02/2024", "", "", "", "", "AT-02505237", "", "", "11/09/23", "Via Repubblica 12 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Ghidini", "Riccardo", "", "334 1615087", "17/08/1997", "Brescia", "", "", "", "", "", "", "GHDRCR97M17B157Z", "", "", "", "", "", "", "AT-02505238", "", "", "11/09/23", "Via Sant'Andrea 98 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Graziotti", "Giulio", "g.grazio@libero.it", "333 1561532", "27/10/1993", "Brescia", "", "", "", "", "", "", "GRZGLI93R27B157R", "", "", "", "", "", "", "AT-02528398", "", "", "16/12/23", "Via Caselli 42 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Guagnetti", "Daniel", "", "331 4464492", "30/01/2004", "Gardone Val Trompia", "", "", "", "", "", "", "GGNDNL04A30D918Z", "", "", "", "", "", "", "AT-02505721", "", "", "12/09/23", "Via Renzo 10 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Lena", "Nicola", "", "389 1449783", "12/06/1992", "Brescia", "", "", "", "", "", "", "LNENCL92H12B157U", "", "16/02/2024", "", "", "", "", "AT-02505239", "", "", "11/09/23", "Via Padre Bolognini 52 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Mori", "Paolo", "mori92lume@hotmail.com", "333 9227260", "06/02/1992", "Gardone Val Trompia", "", "", "", "", "", "", "MROPLA92B06D918R", "", "", "", "", "", "", "AT-02505241", "", "", "11/09/23", "Via D. Alighieri 28 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Pasotti", "Andrea", "", "392 7905885", "24/12/1979", "Brescia", "", "", "", "", "", "", "PSTNDR79T24B157Q", "", "", "", "", "", "", "NA-02500434", "", "", "20/07/23", "Via XXV Aprile 18/A 25068 Sarezzo (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Potenza", "Luigi", "luigi.potenza@icloud.com", "320 5529590", "23/02/1992", "Gardone Val Trompia", "", "", "", "", "", "", "PTNLGU92B23D918I", "", "", "", "", "", "", "AT-02505243", "", "", "11/09/23", "Via V. Montini 178 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Primerano", "Simone", "", "380 4940271", "09/06/1998", "Brescia", "", "", "", "", "", "", "PRMSMN98H09B157V", "", "", "", "", "", "", "AT-02504162", "", "", "07/09/23", "Via M. Zanagnolo 25/S 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Raza", "Marco", "razamarco6@gmail.com", "328 6844822", "10/08/1993", "Gardone Val Trompia", "", "", "", "", "", "", "RZAMCF93M10D918O", "", "", "", "", "", "", "AT-02505244", "", "", "11/09/23", "Vicolo Fratte 5 25064 Gussago (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Sabiu", "Stefano", "", "331 3154966", "31/03/1999", "Gardone Val Trompia", "", "", "", "", "", "", "SBASFN99C31D918K", "", "", "", "", "", "", "AT-02505722", "", "", "12/09/23", "Via Maestro Zanagnolo 23 Z 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Sanzogni", "Carlo", "sanzo.94@hotmail.com", "388 3214271", "08/04/1994", "Brescia", "", "", "", "", "", "", "SNZCRL94D08B157N", "", "", "", "", "", "", "AT-02505247", "", "", "11/09/23", "Via S. G. Battista 75 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Tampalini", "Pierangelo", "", "334 1118733", "17/06/1992", "Brescia", "", "", "", "", "", "", "TMPPNG92H17B157V", "", "", "", "", "", "", "AT-02505248", "", "", "11/09/23", "Via Caselli 75 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Vivenzi", "Alberto", "albo.vivenzi@hotmail.com", "333 6993319", "03/08/1992", "Brescia", "", "", "", "", "", "", "VVNLRT92M03B157E", "", "", "", "", "", "", "AT-02505251", "", "", "11/09/23", "Via G. Matteotti 67 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170414 (`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` , `col25` ) VALUES ("", "Zanetti", "Riccardo", "riccardozanetti22@gmail.com", "333 4076239", "24/06/1992", "Gardone Val Trompia", "", "", "", "", "", "", "ZNTRCR92H24D918C", "", "", "", "", "", "", "AT-02505255", "", "", "11/09/23", "Via Zanagnolo 2 25065 Lumezzane (BS)", ""); 

Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_240429170414` ; 

*************** All done!!! Import successfully Completed
Start admin_users_importcsv_2_step2 process on 29/04/2024-17:23


Query to get line with titles: SELECT * FROM `AA_TEMP_IMPORT_240429170414` WHERE `id` = 1; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column1"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column2"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column3"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column4"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column5"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column6"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column7"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column8"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column9"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column10"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column11"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column12"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column13"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column14"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column15"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column16"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column17"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column18"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column19"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column20"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column21"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column22"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column23"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column24"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column25"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column26"; 

*************** All done!!! Import successfully Completed
Start admin_users_importcsv_2_step2 process on 29/04/2024-17:25

Open input file: /var/www/html/mioteamdata/communities/JKkP3wv5R3/config/cartel1240429170452.txt
First line with columns header read
Line contains 26 fiels

Query to create the temporary table is: CREATE TABLE `mioteam`.`AA_TEMP_IMPORT_240429170452` ( `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) , `col25` VARCHAR(150) , PRIMARY KEY (`id`)) ENGINE = InnoDB; 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("ÿþColumn1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10", "Column11", "Column12", "Column13", "Column14", "Column15", "Column16", "Column17", "Column18", "Column19", "Column20", "Column21", "Column22", "Column23", "Column24", "Column25", "Column26"); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) 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_240429170452 (`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` , `col25` ) VALUES ("
", "Bazzani", "Lorenzo", "", "389 2673325", "02/04/1999", "Brescia", "", "", "", "", "", "", "BZZLNZ99D02B157N", "", "12/02/2024", "", "", "", "", "AT-02505717", "", "", "12/09/23", "Via Valbella 24 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Cavagna", "Manuel", "", "366 2744856", "09/11/1997", "Brescia", "", "", "", "", "", "", "CVGMNL97S09B157M", "", "", "", "", "", "", "AT-02505229", "", "", "11/09/23", "Via San Filippo Neri 45 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Cocca", "Andrea", "", "335 5248087", "12/08/1979", "Brescia", "", "", "", "", "", "", "CCCNRP79M12B157R", "", "", "", "", "", "", "AT-02505230", "", "", "11/09/23", "Via Cesare Scaluggia 44 25069 Villa Carcina (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Cornacchiari", "Filippo", "", "334 7561409", "28/12/1997", "Gavardo", "", "", "", "", "", "", "CRNFPP97T28D940B", "", "", "", "", "", "", "AT-02505231", "", "", "11/09/23", "Via Strada Piana 24 25071 Agnosine (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Donati", "Alessio", "", "338 6591854", "11/04/1993", "Gardone Val Trompia", "", "", "", "", "", "", "DNTLSS93D11D918V", "", "06/10/2024", "", "", "", "", "AT-02505378", "", "", "11/09/23", "Via XXV Aprile 21 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Ghidini", "Giacomo", "ghidini.giacomo33@gmail.com", "338 7046184", "05/04/1994", "Brescia", "", "", "", "", "", "", "GHDGCM94D05B157Q", "", "21/02/2024", "", "", "", "", "AT-02505237", "", "", "11/09/23", "Via Repubblica 12 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Ghidini", "Riccardo", "", "334 1615087", "17/08/1997", "Brescia", "", "", "", "", "", "", "GHDRCR97M17B157Z", "", "", "", "", "", "", "AT-02505238", "", "", "11/09/23", "Via Sant'Andrea 98 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Graziotti", "Giulio", "g.grazio@libero.it", "333 1561532", "27/10/1993", "Brescia", "", "", "", "", "", "", "GRZGLI93R27B157R", "", "", "", "", "", "", "AT-02528398", "", "", "16/12/23", "Via Caselli 42 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Guagnetti", "Daniel", "", "331 4464492", "30/01/2004", "Gardone Val Trompia", "", "", "", "", "", "", "GGNDNL04A30D918Z", "", "", "", "", "", "", "AT-02505721", "", "", "12/09/23", "Via Renzo 10 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Lena", "Nicola", "", "389 1449783", "12/06/1992", "Brescia", "", "", "", "", "", "", "LNENCL92H12B157U", "", "16/02/2024", "", "", "", "", "AT-02505239", "", "", "11/09/23", "Via Padre Bolognini 52 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Mori", "Paolo", "mori92lume@hotmail.com", "333 9227260", "06/02/1992", "Gardone Val Trompia", "", "", "", "", "", "", "MROPLA92B06D918R", "", "", "", "", "", "", "AT-02505241", "", "", "11/09/23", "Via D. Alighieri 28 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Pasotti", "Andrea", "", "392 7905885", "24/12/1979", "Brescia", "", "", "", "", "", "", "PSTNDR79T24B157Q", "", "", "", "", "", "", "NA-02500434", "", "", "20/07/23", "Via XXV Aprile 18/A 25068 Sarezzo (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Potenza", "Luigi", "luigi.potenza@icloud.com", "320 5529590", "23/02/1992", "Gardone Val Trompia", "", "", "", "", "", "", "PTNLGU92B23D918I", "", "", "", "", "", "", "AT-02505243", "", "", "11/09/23", "Via V. Montini 178 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Primerano", "Simone", "", "380 4940271", "09/06/1998", "Brescia", "", "", "", "", "", "", "PRMSMN98H09B157V", "", "", "", "", "", "", "AT-02504162", "", "", "07/09/23", "Via M. Zanagnolo 25/S 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Raza", "Marco", "razamarco6@gmail.com", "328 6844822", "10/08/1993", "Gardone Val Trompia", "", "", "", "", "", "", "RZAMCF93M10D918O", "", "", "", "", "", "", "AT-02505244", "", "", "11/09/23", "Vicolo Fratte 5 25064 Gussago (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Sabiu", "Stefano", "", "331 3154966", "31/03/1999", "Gardone Val Trompia", "", "", "", "", "", "", "SBASFN99C31D918K", "", "", "", "", "", "", "AT-02505722", "", "", "12/09/23", "Via Maestro Zanagnolo 23 Z 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Sanzogni", "Carlo", "sanzo.94@hotmail.com", "388 3214271", "08/04/1994", "Brescia", "", "", "", "", "", "", "SNZCRL94D08B157N", "", "", "", "", "", "", "AT-02505247", "", "", "11/09/23", "Via S. G. Battista 75 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Tampalini", "Pierangelo", "", "334 1118733", "17/06/1992", "Brescia", "", "", "", "", "", "", "TMPPNG92H17B157V", "", "", "", "", "", "", "AT-02505248", "", "", "11/09/23", "Via Caselli 75 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Vivenzi", "Alberto", "albo.vivenzi@hotmail.com", "333 6993319", "03/08/1992", "Brescia", "", "", "", "", "", "", "VVNLRT92M03B157E", "", "", "", "", "", "", "AT-02505251", "", "", "11/09/23", "Via G. Matteotti 67 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`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` , `col25` ) VALUES ("
", "Zanetti", "Riccardo", "riccardozanetti22@gmail.com", "333 4076239", "24/06/1992", "Gardone Val Trompia", "", "", "", "", "", "", "ZNTRCR92H24D918C", "", "", "", "", "", "", "AT-02505255", "", "", "11/09/23", "Via Zanagnolo 2 25065 Lumezzane (BS)", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240429170452 (`col0` ) VALUES ("
"); 

Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_240429170452` ; 

*************** All done!!! Import successfully Completed
Start admin_users_importcsv_2_step2 process on 29/04/2024-17:25


Query to get line with titles: SELECT * FROM `AA_TEMP_IMPORT_240429170452` WHERE `id` = 1; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "ÿþcolumn1"; 

Query to check if custom field code already exists: SELECT * FROM `fieldscom` WHERE `id` = "85m95o1gpB"; 

Code for this custom field code : 85m95o1gpB 

Query to check last ycord in custom field: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" ORDER BY `fieldscom`.`ycord` DESC; 

ycord for this custom field: 28 

Query to create new custom field: INSERT INTO `fieldscom` (`id`,`idCommunity`,`Name`,`typeControl`,`isMultiValues`,`nullable`,`isPrivate`,`ycord`,`labeltext`) VALUES ("85m95o1gpB","JKkP3wv5R3","85m95o1gpB","1", "0", "1", "0","28","ÿþC\0o\0l\0u\0m\0n\01\0");  

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column2"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column3"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column4"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column5"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column6"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column7"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column8"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column9"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column10"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column11"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column12"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column13"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column14"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column15"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column16"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column17"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column18"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column19"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column20"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column21"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column22"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column23"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column24"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column25"; 

Query to check if custom field exists: SELECT * FROM `fieldscom` WHERE `idCommunity` = "JKkP3wv5R3" AND `labelText` = "column26"; 

*************** All done!!! Import successfully Completed