yahoo groups to phpNuke

Worker Joined: May 30, 2006 Posts: 100

Does anyone know of a mod to archive a yahoo groups to phpNuke or even phpBB within phpNuke?

I have found some info....scarce as it is...but its strictly a discussion of someone migrating to a stand alone phpBB.

Thought I would post this question here to see if anyone in the phpNuke community knew of something that I havent found yet.

Thanks!

registered · Posted: Thu Jun 01, 2006 6:46 pm

What exactly are you trying to accomplish?

Posted: Thu Jun 01, 2006 8:02 pm

Well I am not exactly sure. This is a project I would be doing for someone else.

They currently have been using yahoo groups as a discussion mechanism. Within the main YG they have several different groups that members can subscribe to. I am not currently nor ever have been a user of YG.

They are now currently using phpNuke....but dont want to lose the plethora of information that they have accumulated with the YG process over the past several years.

So what I would like to do is to disable the YG so no one can post any new content to it...archive it in some way....then either import it into a forum in phpBB of the phpNuke site....or just archive it and create a custom module that would show all of the topics like a blog or something.

I am really open to any way of doing it since there will not be any new content added to YG....only archiving what is already there and making it available on the phpNuke site so all members can have access to the old information from one site.

Does that answer your question?

Thanks for any reply you might have in advance. Very Happy

Posted: Fri Jun 02, 2006 6:39 am

Quote:

Does that answer your question?

Absolutely! Laughing

Thanks.

Well, unfortunately, I have never heard of anyone doing this. I have not used YGs myself, so I don't even know if they have an export capability. If they do and you can get the file into some form of delimited text format, you would need to then review the nuke phpBB tables and write something to load the data in. As long as you can get the data out, I am pretty sure you could get it back into phpBB.

I'd first check to make sure you can export the data. If you cannot, do you really want to "scrape" each screen manually to grab all the information? Uuughhh...

Posted: Fri Jun 02, 2006 8:34 am

montego wrote:

Quote:

Does that answer your question?

Absolutely! Laughing

Thanks.

Well, unfortunately, I have never heard of anyone doing this. I have not used YGs myself, so I don't even know if they have an export capability. If they do and you can get the file into some form of delimited text format, you would need to then review the nuke phpBB tables and write something to load the data in. As long as you can get the data out, I am pretty sure you could get it back into phpBB.

I'd first check to make sure you can export the data. If you cannot, do you really want to "scrape" each screen manually to grab all the information? Uuughhh...

No I dont want to do it manually.

There is for a fact a way to do this with a perl script....extracting the data that is.

I will toy with this idea for a while and update this thread with my findings.

Thanks

Posted: Fri Jun 02, 2006 9:13 am

I found this last night and emailed the developer with basically the same question I posed here. However I didnt actually check my email before I made the above post.

Here is his reply and links in their entirety.

Quote:

Hi,

The tool I have is a program to download and read Yahoo messages. It uses MS Access as its database. I also have some unsupported free scripts to convert the MS Access database to an SQL load file and scripts to convert the SQL db to phpBB format.

I’m not sure this will help you as I’m sure that getting the SQL db to phpNuke format won’t be trivial. If you can find a phpBB to phpNuke convertor it might be worthwhile getting my software:

http://www.pgoffline.com/pgo-plus.htm

Cheers,

Wilson.

So this looks promising at least. I would think that since he is targeting phpBB that perhaps it would need to be ported to phpNuke for at least the db prefixes.

Any thoughts on this?

Posted: Fri Jun 02, 2006 8:15 pm

I would definitely start there and get the data down locally where you can do something with it. I would familiarize yourself a bit with what the nuke_bb* tables look like within nuke (assuming your table prefix is "nuke" of course) and you may find that it is only 2 - 3 tables to be concerned with. The one thing, though, that you may need to do is "map" the YG users to what their usernames are in nuke (assuming they have already registered on your friends nuke site). You would want these posts, I think, to be tied to their right owners OR you would have to set them all to some hard-coded default user in the nuke_users table.

Good luck!

Posted: Fri Jun 02, 2006 9:29 pm

montego....

I am not sure if ALL users have registered on the new site and then again there are probably users from the YG site that will never be members of the new site. So this would leave me to "map" the email address field to perhaps a user labled "YG-ArchiveBOT" or something like that.

Just thinking out loud but your optimisim gives me confidence!

I'll be sure to update this thread as I progress with this so others looking to do this may learn from it as well.

Posted: Sat Jun 03, 2006 6:38 am