Start admin_users_importcsv_2_step2 process on 07/08/2024-18:13

Open input file: /var/www/html/mioteamdata/communities/yAesWKT2DI/config/lista ragazzi squadra open b(ricevo by viga)csv240807180832.csv
First line with columns header read
Line contains 3 fiels

Query to create the temporary table is: CREATE TABLE `mioteam`.`AA_TEMP_IMPORT_240807180833` ( `id` INT NOT NULL AUTO_INCREMENT , `col0` VARCHAR(150) , `col1` VARCHAR(150) , `col2` VARCHAR(150) , PRIMARY KEY (`id`)) ENGINE = InnoDB; 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("Prog", "COGNOME", "RUOLO"); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("1", "BEOLCHI", "Portiere "); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("2", "ANGELICOLA", "Portiere "); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("3", "DI NOIA", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("4", "PICARIELLO", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("5", "ZANIOLO", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("6", "MATELLINI", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("7", "MAGNAGHI", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("8", "MADINI", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("9", "GAGLIANO", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("10", "VIGANO'", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("11", "CONSONNI", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("12", "D'ANDRETTA", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180833 (`col0` , `col1` , `col2` ) VALUES ("13", "FRANZONI", ""); 

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

*************** All done!!! Import successfully Completed
Start admin_users_importcsv_2_step2 process on 07/08/2024-18:13


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

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

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

Code for this custom field code : AgewJ4ZQYh 

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

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

*************** All done!!! Import successfully Completed
Start admin_users_importcsv_2_step2 process on 07/08/2024-18:14

Open input file: /var/www/html/mioteamdata/communities/yAesWKT2DI/config/lista ragazzi squadra open b(ricevo by viga)csv240807180844.csv
First line with columns header read
Line contains 3 fiels

Query to create the temporary table is: CREATE TABLE `mioteam`.`AA_TEMP_IMPORT_240807180844` ( `id` INT NOT NULL AUTO_INCREMENT , `col0` VARCHAR(150) , `col1` VARCHAR(150) , `col2` VARCHAR(150) , PRIMARY KEY (`id`)) ENGINE = InnoDB; 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("Prog", "COGNOME", "RUOLO"); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("1", "BEOLCHI", "Portiere "); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("2", "ANGELICOLA", "Portiere "); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("3", "DI NOIA", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("4", "PICARIELLO", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("5", "ZANIOLO", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("6", "MATELLINI", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("7", "MAGNAGHI", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("8", "MADINI", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("9", "GAGLIANO", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("10", "VIGANO'", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("11", "CONSONNI", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("12", "D'ANDRETTA", ""); 

Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_240807180844 (`col0` , `col1` , `col2` ) VALUES ("13", "FRANZONI", ""); 

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

*************** All done!!! Import successfully Completed
Start admin_users_importcsv_2_step2 process on 07/08/2024-18:14


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

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

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

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