PDA

View Full Version : Import users from ips


emberlegion
10-24-2016, 10:14 PM
I'm moving my board from ips to vb5. I was unable to find a built in way to do so.

is this the only way? https://vborg.vbsupport.ru/showthread.php?t=319738

and does this work for vb5?

any help is appreciated,

emberlegion
10-26-2016, 01:51 AM
update:
all we wanted was the users to transfer over so we exported the member list from ips and used the following


use strict;
use warnings;

my $joinDate = 1477441800;

my $insertStmt = "INSERT INTO user(username,email,ipaddress,usergroupid,joindate )values";
my $fh;
if (open($fh, '<', "members.csv")) {
while (my $row = <$fh>) {
chomp $row;
$row =~ /(.*),(.*),(.*)/;
my $name = $1;
my $email = $2;
my $ipaddress = $3;
$name =~ s/"//g;
$insertStmt .= "('$name','$email','$ipaddress',2,$joinDate),";
}
}
close $fh;

if (open($fh, '>', "insert.txt")) {
print $fh $insertStmt;
}
close $fh;


it imported all the users from the csv file. all they had to do was request a password reset. i'm sure with a bit more work other fields could be made to work as well.