Import email addresses from .csv?

[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.

[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

[wolf7901]

Any way to import from .csv from the command line?

[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

[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.

[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