Chris:
i had a similar issue migrating lists from a vopmail win2k mailserver
to this excellent toaster. don't use the browser method for realy
big lists. call from shell and pipe to file.
1) setup mysql back end, i used qmailadmin and the mktab script.
2) export your old email lists to clean csv or txt
3) add the hash with this little script:
# i forgot where i got this... it's bad enough that maybe i wrote it.
# sorry if i forgot credit for someone.
#
# it needs a recent version of php that has the ezmlm_hash function.
#
# put it on a webserver, pass it a listname=your_filename in the url.
# check the resultant browser output, save it as a file somewhere.
# use mysql load data in file, set the line delimiter to <br>
# use at your own risk. don't cry if you screw something up.
# as is etc.
<?php
$listsrc = $HTTP_GET_VARS["listname"];
$list = file("$listsrc",1);
foreach ($list as $line) {
$line = trim($line);
$hash = ezmlm_hash ($line);
print '"'.$hash.'"'.','.'"'.$line.'"'."<br>";
}
?>
4) bulk load into mysql
5) it works... maybe someone can describe any internal issue(s) of which
i'm not aware.
kelley g
Chris & Christine wrote:
><snip>
>I'd like to achieve these things:
>a. mysql databased ezmlm list -for easy php interface...
> I thought mysql was part of hsphere's ezmlm install - it is
actually not.
> I'm not comfortable upgrading it unless someone has experience
> doing so successfully without breaking hsphere.
> Alternatively, I imagine I could batch add email addresses to the
proper files
> in the path in vpopmail. Any suggestions on how to do so?
>
> Also, I've tried setting the list so that there is no confirmation
> and that subscription is moderated. Unfortunately, when the moderator
> subs/unsubs someone, it still asks for confirmation. How can I
bypass this?
>
><snip>
>
