update:
all we wanted was the users to transfer over so we exported the member list from ips and used the following
Code:
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.