|YahooGroup Conversion - mdb File Import from archiver PGOffline to FUDforum [message #163022]
|Fri, 17 September 2010 21:19
I have been using YahooGroups for 10 years and I am now in the process of fleeing, since YahooGroups self-destructed by turning into a teen faceybook site.
I am trying to set up FUDforum forum with its companion Mailing List feature, on my own website.
I want to duplicate as many of the features as possible of the YahooGroups group that I already have, and make it as painless as possible for group members. This means "seamless" email posting to the forum and vice-versa.
My plan is to start by mirroring all the email postings that the YahooGroup generates and mirror all the postings that are generated on the new FUDforum forum... and then eventually turn off the YahooGroup... since it will be totally replaced by the FUDforum when all the bugs are worked out of the change over. I hope there is some way to do this!
Here is my present problem for getting started:
I have an archive file in *.mdb (MSAccess) format consisting of about 45,000 old group messages. I want all these to be shown on my new FUDforum forum.
I also have a comma and line delimited file for the user base of this group of about 10,000 members, their Yahoo-ID and email address (no passwords). I would like these all to be "subscribed" to my new FUDforum and companion FUDforum Mailing List. I need some easy way to prompt the existing users to authenticate/register/password/account at the new FUDforum.
The *mdb file (Microsoft Access database file) of messages was generated by a YahooGroup message archiving software called PGOffline by pgoffline. com Personal Groupware[/url].
This mdb file has several fields such as:
I will be running FUDforum on my own domain, a *nix based webhosting with MySQL and php, where I have Cpanel access, but I don't have shell access.
Possibly, I could convert the mdb file over to a MySQL file, if that would help.
Is there a converter already for this type of thing, or can I adapt an already made importer to this task?
What kind of resources will I need to accomplish this?
Is FUDforum a good choice for this plan?