Advertisement:

Author Topic: Importing Yahoo group messages  (Read 16227 times)

Offline Dan_

  • Semi-Newbie
  • *
  • Posts: 79
  • Gender: Male
    • Eagler's Nest
Importing Yahoo group messages
« on: January 31, 2014, 10:20:30 AM »
I have rescued over 30,000 posts from my old Yahoo group using PG Offline software.   http://www.personalgroupware.com/index.htm

They have an SMF forum.  http://www.personalgroupware.com/smf/index.php

PGO will export the msgs to a .DB3 file extension.   I would like to import these into SMF.  Has anyone been able to do this..?

Thanks.

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: Importing Yahoo group messages
« Reply #1 on: January 31, 2014, 11:01:02 AM »
For anyone interested, I tried already but cannot really do it.

I managed to import a fraction of that backup to MySQL and I guess it would be possible to import that to SMF topics/posts.

The problems I found:
- There is no distinction between topic start/reply. It's all messages, which probably implies to compare by subject.
- The content of each message is stored as BLOB. No big issue here, *except* the fact that each message stores the full "history" until itself. Full HTML. To make it "forum-compatible", it would be necessary to find each part of the message, separate it and relate it to the "parent" one...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Dan_

  • Semi-Newbie
  • *
  • Posts: 79
  • Gender: Male
    • Eagler's Nest
Re: Importing Yahoo group messages
« Reply #2 on: January 31, 2014, 11:42:37 AM »
each message stores the full "history" until itself. Full HTML. To make it "forum-compatible", it would be necessary to find each part of the message, separate it and relate it to the "parent" one...

What I think you are seeing there is total lack of member "etiquette".  They never ever "trimmed" a post of the string of former replies.  Also most members had no idea how to start a topic.  They just wait until something shows up in their inbox and hit reply, no matter what the topic subject was.

I suppose it would be best to make an "old yahoo posts" category and make it read only...   Having these old posts available in our SMF to search through, makes it un-necessary for someone to have to join Yahoo to search.

Offline evildrome

  • Semi-Newbie
  • *
  • Posts: 21
Re: Importing Yahoo group messages
« Reply #3 on: June 18, 2015, 09:34:17 AM »
"What I think you are seeing there is total lack of member "etiquette".  "

That is precisely correct.

Each message in PG Offline is the exact HTML of each message in Yahoo.

If that message happens to contain the last 3 messages as well then there's not a lot to be done about it.

In essence though, how much of a problem is it?  No one says, Ha! I'm not going to use Yahoo groups because people reply to full messages.

There is a small utility to export PGO's message database to .CSV format (plain text).

Cheers,

 Wilson Logan  (PG Offline Creator).


Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,430
  • Gender: Male
    • Kindred-999 on GitHub
Re: Importing Yahoo group messages
« Reply #4 on: June 18, 2015, 11:25:58 AM »
What I did for an old yahoo group was use the RSS import mod --   I then parsed the Yahoo Group RSS feed to import the old (and future) messages.

I know of no good way to do the import from a scrape like the OP acquired...
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline evildrome

  • Semi-Newbie
  • *
  • Posts: 21
Re: Importing Yahoo group messages
« Reply #5 on: June 09, 2016, 09:48:06 AM »
Just as an update, I have a procedure to import PGO databases of Yahoo messages to SMF.

info (at) personalgroupware (dot) com

Cheers,

 Wilson Logan  (PG Offline Creator).

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,430
  • Gender: Male
    • Kindred-999 on GitHub
Re: Importing Yahoo group messages
« Reply #6 on: June 09, 2016, 06:35:58 PM »
why not post it here then?
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline tonzodehoo

  • Semi-Newbie
  • *
  • Posts: 30
Re: Importing Yahoo group messages
« Reply #7 on: October 29, 2018, 07:33:05 PM »
I know its an old post this but is there any substance to the method of importing a yahoo message database into smf?
I'd be interested to know what the possibilities are.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,430
  • Gender: Male
    • Kindred-999 on GitHub
Re: Importing Yahoo group messages
« Reply #8 on: October 29, 2018, 11:04:04 PM »
We don’t know, because evildrome never shared
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.