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
the command would be