Hi,I've attempted a rudimentary import script, written in PhP, which should be run on the database server that holds the MailWatch and Baruwa databases.
It only migrates users, not domain admins. It does not check for users that monitor multiple email addresses (doesn't check the report recipient, for instance). I needed something to import about 500+ users without too much hassle - and I figured I can manually add domain accounts and the "additional" domains or email addresses.
Basically, it takes the username from MailWatch, which is also the "to be monitored" email address and moves it over to Baruwa together with whatever else we can 'guess'. I'm also splitting the username into a 'first-name - last-name" pair, assuming that we have at least one space between them.
Note, please, that I had to adjust the Baruwa table "auth_user", expanding the "username" field from varchar(30) to varchar(75) to accomodate the sometimes long-ish usernames (full email addresses)
The code could be greatly enhanced - feel free to modify it, build upon it, etc. It's a little rough around some edges, and it won't win any prizes - which is why I'm not even attempting to put it in the Wiki.
Use at your own risk. Do not fold, spindle, or mutilate. Your mileage may vary. Void where prohibited. If it breaks your database, restore it from backup and accept my apologies.
Good luck!
Frank
<<< text/html; name="migrate_users.php": Unrecognized >>>
_______________________________________________ Baruwa mailing list [email protected] http://lists.baruwa.org/mailman/listinfo/baruwa Keep Baruwa FREE - http://pledgie.com/campaigns/12056
