Page 1 of 1

Import email addresses from .csv?

Posted: Mon May 14, 2007 9:31 am
by wolf7901
Hi:

What is the best way to import employee first names, last names, and email addresses to a predefined scalix group from a .csv file?

Thanks.

Posted: Mon May 14, 2007 10:13 am
by craig
I am not aware of any way as of yet, other then creating a script and using the "plugins" feature in SAC, I still believe using .csv files would not be possible


Craig

what about from the command line?

Posted: Mon May 14, 2007 10:15 am
by wolf7901
Any way to import from .csv from the command line?

Posted: Mon May 14, 2007 10:28 am
by craig
using omaddpdln should do the trick, however the email addresses listed would probably not work, but specifying the user name should work.

man omaddpdln


Craig

Posted: Mon May 14, 2007 10:31 am
by wolf7901
ok, but how would I add them to their appropriate groups. I noticed when I run the command omsearch I can see numbers for the groups, but how would I import to these groups? Thanks for your help.

Posted: Fri Jul 27, 2007 1:45 pm
by Mouseclone
OK here is what i did for the move from Imail to Scalix. This is an import from csv or a text file with csv doesn't matter

Code: Select all

$mailnode = "mailnode";
$omaddu = "/opt/scalix/bin/omaddu";
$domain = "domain.com";
while (<>) {
chomp;
next if /^#/;
($first,$last,$user,$pass) = split / *, */;
print ($first,"\n",$last,"\n",$user,"\n",$pass,"\n");
system ("$omaddu -n \'$first $last/$mailnode/IA=\"$first $last\" <$user\@$domain>\' -p $pass $user --class limited");
}


your data in the file would look like

Code: Select all

first,last,email,pass


the command would be

Code: Select all


import.pl < text.csv