2
hi'
You should test this script
<?php
// christian@frxoops.org - http://www.frxoops.org
// Import users from a csv or text file into XOOPS 2.3.2
// variables
$bdd= "bdd-name";
$host= "localhost";
$user= "root";
$pass= "";
$prefix= "xc2234"; // tables prefix, without _
$separator = ";";//separator used in original file
$regdate=time();
$fichier = "file-name.csv"; // file name to read
// IMPORTANT : DO NOT LEAVE AN EMPTY LINE IN YOUR ORIGINAL DOCUMENT (file-name.csv)
mysql_connect($host,$user,$pass) or die("Unable to connect Database");
mysql_select_db($bdd);
//Open file for read
if (file_exists($fichier))
$fp = fopen("$fichier", "r");
else{ // unknown file
echo "File not found !<br />Import stopped.";
exit();
}
echo 'Begin file import : <b>'.$fichier.'</b><br /><br />';
echo '<table border="1" cellspacing="3">';
echo '<tr><td>UID</td><td>Pseudo</td>';
// import line by line
while (!feof($fp)){
$ligne = fgets($fp,4096);
$liste = explode($separator,$ligne); //create array
// Add real name
$uname = $liste[0];
// End
// Add website
$url = $liste[1];
// End
// Add avatar
$user_avatar = $liste[2];
// End
// Add "From" info
$user_from = "xoops.org";
// End
// Add Sign
$user_sig = $liste[3];
// End
// Add Password
$pass= md5(trim($liste[4]));
// End
$rank = "1"; // Choose rank
// Add occupation
$user_occ = "Xoops Designer";
// End
$user_mailok = "1"; // Choose 1 if you allow administrator to send email
// Add user in xoops_users table
$query = "insert into ".$prefix."_users (uname, url, user_avatar, user_regdate, user_from, user_sig, pass, rank, user_occ, user_mailok) VALUES ('".$uname."', '".$url."', '".$user_avatar."', '".$regdate."', '".$user_from."', '".$user_sig."', '".$pass."', '".$rank."', '".$user_occ."', ".$user_mailok.")";
$result= mysql_query($query);
$uid = mysql_insert_id();
//Add user in group : registered users per default
$numgroup ='2';// choose Group number
$query = "insert into ".$prefix."_groups_users_link (groupid, uid) VALUES('".$numgroup."', '".$uid."')";
$result= mysql_query($query);
if (mysql_error()){
echo "Error in database : ".mysql_error();
echo "</table><br /><br /><b>Importation stoppée.</b><br /><br />";
fclose($fp);
exit();
}else{
echo "<tr><td> ".$uid." </td><td> ".$uname." </td></tr> ";
}
}
echo "</table><br />Import finished successfully.";// That's ok !
fclose($fp);
?>
Found on frxoops forums for months (I can't find link anymore). It works fine with XOOPS 2.3.2
You have to customize some informations (comments translated by me, sorry
)
Still learning CSS and... english