Start admin_users_importcsv_2_step2 process on 14/10/2024-18:23 Open input file: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/config/myteam241014181033.csv First line with columns header read Line contains 3 fiels Query to create the temporary table is: CREATE TABLE `mioteam`.`AA_TEMP_IMPORT_241014181033` ( `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_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Cognome", "Nome", "telefono"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Vito", "Maggio", "3713388325"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Nuzzi", "Claudia", "3349281603"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Scarpiello", "Giulia", "3703471376"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("de Lillo ", "Giulia", "3518710037"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Montanino", "Laura Maria", "3534105275"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Nuzzi", "Greta", "3349281604"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Rutigliano ", "Valentina ", "3891963145"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Gargiulo", "Benedetta", "3339728448"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Valentina ", "De Stefano", "3701527413"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Valeria", "Lombardi", "3441152571"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Martina", "Caggianello", "3341216631"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Martina", "Carmellino", "3510884923"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Alessandra", "Parisi", "3703611000"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Marta", "Mancini", "3534206864"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Francesca", "Sanna", "3802171929"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Giada", "Cascioli", "3314216138"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Camilla", "Salvatore", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Isabella", "Turi", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Sara", "Luppino", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Giulia", "Algerino", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Elisabetta", "Pellegrino", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Chiara", "Di Biase", "3534093721"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181033 (`col0` , `col1` , `col2` ) VALUES ("Giorgia", "Di Palma", "3271839492"); Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_241014181033` ; *************** All done!!! Import successfully Completed Start admin_users_importcsv_2_step2 process on 14/10/2024-18:23 Query to get line with titles: SELECT * FROM `AA_TEMP_IMPORT_241014181033` WHERE `id` = 1; 1 - Cognome => Cognome 2 - Nome => Nome 3 - telefono => NumeroTelefono Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_241014181033` WHERE `id` > 1; Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Vito", "Maggio", "Maggio.Vito", "PYUOrQH1Sz", "P1LPBuzRNC", "0", "P1LPBuzRNC", "10", "20241014182337", "20241014062337","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Maggio.Vito Directory succesfully created *************** User Maggio.Vito succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Nuzzi", "Claudia", "Claudia.Nuzzi", "PYUOrQH1Sz", "jlzNmSURz8", "0", "jlzNmSURz8", "10", "20241014182337", "20241014062337","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Claudia.Nuzzi Directory succesfully created *************** User Claudia.Nuzzi succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Scarpiello", "Giulia", "Giulia.Scarpiello", "PYUOrQH1Sz", "mPO5pQbQmF", "0", "mPO5pQbQmF", "10", "20241014182338", "20241014062338","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Giulia.Scarpiello Directory succesfully created *************** User Giulia.Scarpiello succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("de Lillo ", "Giulia", "Giulia.deLillo", "PYUOrQH1Sz", "4BXyAzCyQB", "0", "4BXyAzCyQB", "10", "20241014182338", "20241014062338","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Giulia.deLillo Directory succesfully created *************** User Giulia.deLillo succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Montanino", "Laura Maria", "LauraMaria.Montanino", "PYUOrQH1Sz", "o5GZFcSg8Y", "0", "o5GZFcSg8Y", "10", "20241014182338", "20241014062338","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/LauraMaria.Montanino Directory succesfully created *************** User LauraMaria.Montanino succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Nuzzi", "Greta", "Greta.Nuzzi", "PYUOrQH1Sz", "Y3KW745o4D", "0", "Y3KW745o4D", "10", "20241014182338", "20241014062338","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Greta.Nuzzi Directory succesfully created *************** User Greta.Nuzzi succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Rutigliano ", "Valentina ", "Valentina.Rutigliano", "PYUOrQH1Sz", "TGBvZnj17b", "0", "TGBvZnj17b", "10", "20241014182338", "20241014062338","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Valentina.Rutigliano Directory succesfully created *************** User Valentina.Rutigliano succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Gargiulo", "Benedetta", "Benedetta.Gargiulo", "PYUOrQH1Sz", "Ns1cgtjvPr", "0", "Ns1cgtjvPr", "10", "20241014182339", "20241014062339","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Benedetta.Gargiulo Directory succesfully created *************** User Benedetta.Gargiulo succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Valentina ", "De Stefano", "DeStefano.Valentina", "PYUOrQH1Sz", "ZUxNZAsrTn", "0", "ZUxNZAsrTn", "10", "20241014182339", "20241014062339","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/DeStefano.Valentina Directory succesfully created *************** User DeStefano.Valentina succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Valeria", "Lombardi", "Lombardi.Valeria", "PYUOrQH1Sz", "QH7IeG08CA", "0", "QH7IeG08CA", "10", "20241014182339", "20241014062339","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Lombardi.Valeria Directory succesfully created *************** User Lombardi.Valeria succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Martina", "Caggianello", "Caggianello.Martina", "PYUOrQH1Sz", "n0mhkhbGcf", "0", "n0mhkhbGcf", "10", "20241014182339", "20241014062339","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Caggianello.Martina Directory succesfully created *************** User Caggianello.Martina succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Martina", "Carmellino", "Carmellino.Martina", "PYUOrQH1Sz", "Bq9KRc5b2k", "0", "Bq9KRc5b2k", "10", "20241014182339", "20241014062339","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Carmellino.Martina Directory succesfully created *************** User Carmellino.Martina succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Alessandra", "Parisi", "Parisi.Alessandra", "PYUOrQH1Sz", "z3tQ1Cix1w", "0", "z3tQ1Cix1w", "10", "20241014182340", "20241014062340","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Parisi.Alessandra Directory succesfully created *************** User Parisi.Alessandra succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Marta", "Mancini", "Mancini.Marta", "PYUOrQH1Sz", "ID5rc0WCB0", "0", "ID5rc0WCB0", "10", "20241014182340", "20241014062340","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Mancini.Marta Directory succesfully created *************** User Mancini.Marta succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Francesca", "Sanna", "Sanna.Francesca", "PYUOrQH1Sz", "CEtSS6tUCD", "0", "CEtSS6tUCD", "10", "20241014182340", "20241014062340","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Sanna.Francesca Directory succesfully created *************** User Sanna.Francesca succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Giada", "Cascioli", "Cascioli.Giada", "PYUOrQH1Sz", "pXpgEGglRI", "0", "pXpgEGglRI", "10", "20241014182340", "20241014062340","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Cascioli.Giada Directory succesfully created *************** User Cascioli.Giada succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Camilla", "Salvatore", "Salvatore.Camilla", "PYUOrQH1Sz", "1cDdpYH2dB", "0", "1cDdpYH2dB", "10", "20241014182340", "20241014062340","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Salvatore.Camilla Directory succesfully created *************** User Salvatore.Camilla succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Isabella", "Turi", "Turi.Isabella", "PYUOrQH1Sz", "WxOk13qkS7", "0", "WxOk13qkS7", "10", "20241014182341", "20241014062341","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Turi.Isabella Directory succesfully created *************** User Turi.Isabella succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Sara", "Luppino", "Luppino.Sara", "PYUOrQH1Sz", "JEYcGBEvYS", "0", "JEYcGBEvYS", "10", "20241014182341", "20241014062341","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Luppino.Sara Directory succesfully created *************** User Luppino.Sara succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Giulia", "Algerino", "Algerino.Giulia", "PYUOrQH1Sz", "CecTNiURwL", "0", "CecTNiURwL", "10", "20241014182341", "20241014062341","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Algerino.Giulia Directory succesfully created *************** User Algerino.Giulia succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Elisabetta", "Pellegrino", "Pellegrino.Elisabetta", "PYUOrQH1Sz", "gz8oJNN3eI", "0", "gz8oJNN3eI", "10", "20241014182341", "20241014062341","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Pellegrino.Elisabetta Directory succesfully created *************** User Pellegrino.Elisabetta succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Chiara", "Di Biase", "DiBiase.Chiara", "PYUOrQH1Sz", "ETOwMbDli2", "0", "ETOwMbDli2", "10", "20241014182342", "20241014062342","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/DiBiase.Chiara Directory succesfully created *************** User DiBiase.Chiara succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Giorgia", "Di Palma", "DiPalma.Giorgia", "PYUOrQH1Sz", "CTX9DB9zW2", "0", "CTX9DB9zW2", "10", "20241014182342", "20241014062342","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/DiPalma.Giorgia Directory succesfully created *************** User DiPalma.Giorgia succesfully added to MioTeam *************** All done!!! Import successfully Completed Start admin_users_importcsv_2_step2 process on 14/10/2024-18:31 Open input file: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/config/myteam241014181005.csv First line with columns header read Line contains 3 fiels Query to create the temporary table is: CREATE TABLE `mioteam`.`AA_TEMP_IMPORT_241014181005` ( `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_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Cognome", "Nome", "telefono"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Vito", "Maggio", "3713388325"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Nuzzi", "Claudia", "3349281603"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Scarpiello", "Giulia", "3703471376"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("de Lillo ", "Giulia", "3518710037"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Montanino", "Laura Maria", "3534105275"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Nuzzi", "Greta", "3349281604"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Rutigliano ", "Valentina ", "3891963145"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Gargiulo", "Benedetta", "3339728448"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Valentina ", "De Stefano", "3701527413"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Valeria", "Lombardi", "3441152571"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Martina", "Caggianello", "3341216631"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Martina", "Carmellino", "3510884923"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Alessandra", "Parisi", "3703611000"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Marta", "Mancini", "3534206864"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Francesca", "Sanna", "3802171929"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Giada", "Cascioli", "3314216138"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Camilla", "Salvatore", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Isabella", "Turi", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Sara", "Luppino", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Giulia", "Algerino", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Elisabetta", "Pellegrino", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Chiara", "Di Biase", "3534093721"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181005 (`col0` , `col1` , `col2` ) VALUES ("Giorgia", "Di Palma", "3271839492"); Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_241014181005` ; *************** All done!!! Import successfully Completed Start admin_users_importcsv_2_step2 process on 14/10/2024-18:31 Query to get line with titles: SELECT * FROM `AA_TEMP_IMPORT_241014181005` WHERE `id` = 1; 1 - Cognome => Cognome 2 - Nome => Nome 3 - telefono => NumeroTelefono Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_241014181005` WHERE `id` > 1; Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Vito", "Maggio", "Maggio.Vito1", "PYUOrQH1Sz", "dG2D5xyMs1", "0", "dG2D5xyMs1", "10", "20241014183111", "20241014063111","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Maggio.Vito1 Directory succesfully created *************** User Maggio.Vito1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Nuzzi", "Claudia", "Claudia.Nuzzi1", "PYUOrQH1Sz", "lIxVDFehtJ", "0", "lIxVDFehtJ", "10", "20241014183111", "20241014063111","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Claudia.Nuzzi1 Directory succesfully created *************** User Claudia.Nuzzi1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Scarpiello", "Giulia", "Giulia.Scarpiello1", "PYUOrQH1Sz", "sjWWN6apcK", "0", "sjWWN6apcK", "10", "20241014183111", "20241014063111","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Giulia.Scarpiello1 Directory succesfully created *************** User Giulia.Scarpiello1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("de Lillo ", "Giulia", "Giulia.deLillo1", "PYUOrQH1Sz", "qMQvKOIDQz", "0", "qMQvKOIDQz", "10", "20241014183112", "20241014063112","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Giulia.deLillo1 Directory succesfully created *************** User Giulia.deLillo1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Montanino", "Laura Maria", "LauraMaria.Montanino1", "PYUOrQH1Sz", "5jw4CGmaex", "0", "5jw4CGmaex", "10", "20241014183112", "20241014063112","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/LauraMaria.Montanino1 Directory succesfully created *************** User LauraMaria.Montanino1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Nuzzi", "Greta", "Greta.Nuzzi1", "PYUOrQH1Sz", "BKDtxDMnao", "0", "BKDtxDMnao", "10", "20241014183113", "20241014063113","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Greta.Nuzzi1 Directory succesfully created *************** User Greta.Nuzzi1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Rutigliano ", "Valentina ", "Valentina.Rutigliano1", "PYUOrQH1Sz", "j2C9Ge8MU5", "0", "j2C9Ge8MU5", "10", "20241014183113", "20241014063113","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Valentina.Rutigliano1 Directory succesfully created *************** User Valentina.Rutigliano1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Gargiulo", "Benedetta", "Benedetta.Gargiulo1", "PYUOrQH1Sz", "yYHFKVx6SH", "0", "yYHFKVx6SH", "10", "20241014183114", "20241014063114","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Benedetta.Gargiulo1 Directory succesfully created *************** User Benedetta.Gargiulo1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Valentina ", "De Stefano", "DeStefano.Valentina1", "PYUOrQH1Sz", "nOA4LURF0Z", "0", "nOA4LURF0Z", "10", "20241014183114", "20241014063114","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/DeStefano.Valentina1 Directory succesfully created *************** User DeStefano.Valentina1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Valeria", "Lombardi", "Lombardi.Valeria1", "PYUOrQH1Sz", "9VDAsjGrHd", "0", "9VDAsjGrHd", "10", "20241014183114", "20241014063114","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Lombardi.Valeria1 Directory succesfully created *************** User Lombardi.Valeria1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Martina", "Caggianello", "Caggianello.Martina1", "PYUOrQH1Sz", "jF7ReHW7nz", "0", "jF7ReHW7nz", "10", "20241014183115", "20241014063115","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Caggianello.Martina1 Directory succesfully created *************** User Caggianello.Martina1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Martina", "Carmellino", "Carmellino.Martina1", "PYUOrQH1Sz", "HzEHpRddt0", "0", "HzEHpRddt0", "10", "20241014183115", "20241014063115","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Carmellino.Martina1 Directory succesfully created *************** User Carmellino.Martina1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Alessandra", "Parisi", "Parisi.Alessandra1", "PYUOrQH1Sz", "TBbvkmfO9m", "0", "TBbvkmfO9m", "10", "20241014183116", "20241014063116","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Parisi.Alessandra1 Directory succesfully created *************** User Parisi.Alessandra1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Marta", "Mancini", "Mancini.Marta1", "PYUOrQH1Sz", "qnMvyMDybX", "0", "qnMvyMDybX", "10", "20241014183116", "20241014063116","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Mancini.Marta1 Directory succesfully created *************** User Mancini.Marta1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Francesca", "Sanna", "Sanna.Francesca1", "PYUOrQH1Sz", "4qchThyoNk", "0", "4qchThyoNk", "10", "20241014183117", "20241014063117","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Sanna.Francesca1 Directory succesfully created *************** User Sanna.Francesca1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Giada", "Cascioli", "Cascioli.Giada1", "PYUOrQH1Sz", "SVHTPTrLSD", "0", "SVHTPTrLSD", "10", "20241014183117", "20241014063117","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Cascioli.Giada1 Directory succesfully created *************** User Cascioli.Giada1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Camilla", "Salvatore", "Salvatore.Camilla1", "PYUOrQH1Sz", "QwBUFU3ykl", "0", "QwBUFU3ykl", "10", "20241014183117", "20241014063117","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Salvatore.Camilla1 Directory succesfully created *************** User Salvatore.Camilla1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Isabella", "Turi", "Turi.Isabella1", "PYUOrQH1Sz", "wON6v2cDW9", "0", "wON6v2cDW9", "10", "20241014183118", "20241014063118","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Turi.Isabella1 Directory succesfully created *************** User Turi.Isabella1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Sara", "Luppino", "Luppino.Sara1", "PYUOrQH1Sz", "hOUAdbLFbl", "0", "hOUAdbLFbl", "10", "20241014183118", "20241014063118","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Luppino.Sara1 Directory succesfully created *************** User Luppino.Sara1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Giulia", "Algerino", "Algerino.Giulia1", "PYUOrQH1Sz", "Ifj9WgigIP", "0", "Ifj9WgigIP", "10", "20241014183119", "20241014063119","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Algerino.Giulia1 Directory succesfully created *************** User Algerino.Giulia1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Elisabetta", "Pellegrino", "Pellegrino.Elisabetta1", "PYUOrQH1Sz", "98MdA8gLlq", "0", "98MdA8gLlq", "10", "20241014183119", "20241014063119","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Pellegrino.Elisabetta1 Directory succesfully created *************** User Pellegrino.Elisabetta1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Chiara", "Di Biase", "DiBiase.Chiara1", "PYUOrQH1Sz", "4RCJuwav6b", "0", "4RCJuwav6b", "10", "20241014183120", "20241014063120","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/DiBiase.Chiara1 Directory succesfully created *************** User DiBiase.Chiara1 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Giorgia", "Di Palma", "DiPalma.Giorgia1", "PYUOrQH1Sz", "ou125RBZYw", "0", "ou125RBZYw", "10", "20241014183120", "20241014063120","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/DiPalma.Giorgia1 Directory succesfully created *************** User DiPalma.Giorgia1 succesfully added to MioTeam *************** All done!!! Import successfully Completed Start admin_users_importcsv_2_step2 process on 14/10/2024-18:31 Open input file: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/config/myteam241014181041.csv First line with columns header read Line contains 3 fiels Query to create the temporary table is: CREATE TABLE `mioteam`.`AA_TEMP_IMPORT_241014181042` ( `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_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Cognome", "Nome", "telefono"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Vito", "Maggio", "3713388325"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Nuzzi", "Claudia", "3349281603"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Scarpiello", "Giulia", "3703471376"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("de Lillo ", "Giulia", "3518710037"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Montanino", "Laura Maria", "3534105275"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Nuzzi", "Greta", "3349281604"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Rutigliano ", "Valentina ", "3891963145"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Gargiulo", "Benedetta", "3339728448"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Valentina ", "De Stefano", "3701527413"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Valeria", "Lombardi", "3441152571"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Martina", "Caggianello", "3341216631"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Martina", "Carmellino", "3510884923"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Alessandra", "Parisi", "3703611000"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Marta", "Mancini", "3534206864"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Francesca", "Sanna", "3802171929"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Giada", "Cascioli", "3314216138"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Camilla", "Salvatore", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Isabella", "Turi", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Sara", "Luppino", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Giulia", "Algerino", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Elisabetta", "Pellegrino", ""); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Chiara", "Di Biase", "3534093721"); Query to add one line to the DB: INSERT INTO AA_TEMP_IMPORT_241014181042 (`col0` , `col1` , `col2` ) VALUES ("Giorgia", "Di Palma", "3271839492"); Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_241014181042` ; *************** All done!!! Import successfully Completed Start admin_users_importcsv_2_step2 process on 14/10/2024-18:31 Query to get line with titles: SELECT * FROM `AA_TEMP_IMPORT_241014181042` WHERE `id` = 1; 1 - Cognome => Cognome 2 - Nome => Nome 3 - telefono => NumeroTelefono Query to get all temporary data: SELECT * FROM `AA_TEMP_IMPORT_241014181042` WHERE `id` > 1; Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Vito", "Maggio", "Maggio.Vito2", "PYUOrQH1Sz", "o4Ayf1nSFq", "0", "o4Ayf1nSFq", "10", "20241014183147", "20241014063147","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Maggio.Vito2 Directory succesfully created *************** User Maggio.Vito2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Nuzzi", "Claudia", "Claudia.Nuzzi2", "PYUOrQH1Sz", "w1dNpAlOh0", "0", "w1dNpAlOh0", "10", "20241014183148", "20241014063148","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Claudia.Nuzzi2 Directory succesfully created *************** User Claudia.Nuzzi2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Scarpiello", "Giulia", "Giulia.Scarpiello2", "PYUOrQH1Sz", "9LCxNtNziR", "0", "9LCxNtNziR", "10", "20241014183148", "20241014063148","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Giulia.Scarpiello2 Directory succesfully created *************** User Giulia.Scarpiello2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("de Lillo ", "Giulia", "Giulia.deLillo2", "PYUOrQH1Sz", "hBHerats4i", "0", "hBHerats4i", "10", "20241014183149", "20241014063149","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Giulia.deLillo2 Directory succesfully created *************** User Giulia.deLillo2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Montanino", "Laura Maria", "LauraMaria.Montanino2", "PYUOrQH1Sz", "qrrHD1APin", "0", "qrrHD1APin", "10", "20241014183150", "20241014063150","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/LauraMaria.Montanino2 Directory succesfully created *************** User LauraMaria.Montanino2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Nuzzi", "Greta", "Greta.Nuzzi2", "PYUOrQH1Sz", "htEyaTBlv9", "0", "htEyaTBlv9", "10", "20241014183150", "20241014063150","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Greta.Nuzzi2 Directory succesfully created *************** User Greta.Nuzzi2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Rutigliano ", "Valentina ", "Valentina.Rutigliano2", "PYUOrQH1Sz", "02sal2W0uO", "0", "02sal2W0uO", "10", "20241014183151", "20241014063151","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Valentina.Rutigliano2 Directory succesfully created *************** User Valentina.Rutigliano2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Gargiulo", "Benedetta", "Benedetta.Gargiulo2", "PYUOrQH1Sz", "HPtPpbcPUy", "0", "HPtPpbcPUy", "10", "20241014183151", "20241014063151","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Benedetta.Gargiulo2 Directory succesfully created *************** User Benedetta.Gargiulo2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Valentina ", "De Stefano", "DeStefano.Valentina2", "PYUOrQH1Sz", "NRNDZWDZnL", "0", "NRNDZWDZnL", "10", "20241014183152", "20241014063152","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/DeStefano.Valentina2 Directory succesfully created *************** User DeStefano.Valentina2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Valeria", "Lombardi", "Lombardi.Valeria2", "PYUOrQH1Sz", "KMjfIi6GJj", "0", "KMjfIi6GJj", "10", "20241014183153", "20241014063153","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Lombardi.Valeria2 Directory succesfully created *************** User Lombardi.Valeria2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Martina", "Caggianello", "Caggianello.Martina2", "PYUOrQH1Sz", "goh0kOTKwi", "0", "goh0kOTKwi", "10", "20241014183153", "20241014063153","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Caggianello.Martina2 Directory succesfully created *************** User Caggianello.Martina2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Martina", "Carmellino", "Carmellino.Martina2", "PYUOrQH1Sz", "WVvKsfEEU1", "0", "WVvKsfEEU1", "10", "20241014183154", "20241014063154","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Carmellino.Martina2 Directory succesfully created *************** User Carmellino.Martina2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Alessandra", "Parisi", "Parisi.Alessandra2", "PYUOrQH1Sz", "fMlwgdIpZ1", "0", "fMlwgdIpZ1", "10", "20241014183154", "20241014063154","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Parisi.Alessandra2 Directory succesfully created *************** User Parisi.Alessandra2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Marta", "Mancini", "Mancini.Marta2", "PYUOrQH1Sz", "30xmXTisLt", "0", "30xmXTisLt", "10", "20241014183155", "20241014063155","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Mancini.Marta2 Directory succesfully created *************** User Mancini.Marta2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Francesca", "Sanna", "Sanna.Francesca2", "PYUOrQH1Sz", "b9cmoIaFwA", "0", "b9cmoIaFwA", "10", "20241014183156", "20241014063156","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Sanna.Francesca2 Directory succesfully created *************** User Sanna.Francesca2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Giada", "Cascioli", "Cascioli.Giada2", "PYUOrQH1Sz", "zXoTU902ju", "0", "zXoTU902ju", "10", "20241014183156", "20241014063156","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Cascioli.Giada2 Directory succesfully created *************** User Cascioli.Giada2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Camilla", "Salvatore", "Salvatore.Camilla2", "PYUOrQH1Sz", "ycYarcIeWc", "0", "ycYarcIeWc", "10", "20241014183157", "20241014063157","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Salvatore.Camilla2 Directory succesfully created *************** User Salvatore.Camilla2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Isabella", "Turi", "Turi.Isabella2", "PYUOrQH1Sz", "tyqPyN0mYG", "0", "tyqPyN0mYG", "10", "20241014183158", "20241014063158","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Turi.Isabella2 Directory succesfully created *************** User Turi.Isabella2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Sara", "Luppino", "Luppino.Sara2", "PYUOrQH1Sz", "eImnJoP9iO", "0", "eImnJoP9iO", "10", "20241014183159", "20241014063159","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Luppino.Sara2 Directory succesfully created *************** User Luppino.Sara2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Giulia", "Algerino", "Algerino.Giulia2", "PYUOrQH1Sz", "mH6e0POX8I", "0", "mH6e0POX8I", "10", "20241014183159", "20241014063159","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Algerino.Giulia2 Directory succesfully created *************** User Algerino.Giulia2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Elisabetta", "Pellegrino", "Pellegrino.Elisabetta2", "PYUOrQH1Sz", "f64rHsb1g1", "0", "f64rHsb1g1", "10", "20241014183200", "20241014063200","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/Pellegrino.Elisabetta2 Directory succesfully created *************** User Pellegrino.Elisabetta2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Chiara", "Di Biase", "DiBiase.Chiara2", "PYUOrQH1Sz", "pyxccx88UR", "0", "pyxccx88UR", "10", "20241014183200", "20241014063200","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/DiBiase.Chiara2 Directory succesfully created *************** User DiBiase.Chiara2 succesfully added to MioTeam Query to add user to anagrafica: INSERT INTO `anagrafica` (`Cognome` , `Nome` , `UserID`, `CodiceCommunity`, `Password`, `PasswordEncoded`, `PasswordClear`, `TipoAccount`, `DataCreazione`, `DataUltimoAggiornamento`,`RiferitoDaID`) VALUES ("Giorgia", "Di Palma", "DiPalma.Giorgia2", "PYUOrQH1Sz", "AGbMLFZCTr", "0", "AGbMLFZCTr", "10", "20241014183201", "20241014063201","importCsv"); Tying to create the following directory: /var/www/html/mioteamdata/communities/PYUOrQH1Sz/usersfolders/DiPalma.Giorgia2 Directory succesfully created *************** User DiPalma.Giorgia2 succesfully added to MioTeam *************** All done!!! Import successfully Completed