News:

Yahoo Groups closing on Dec 14th 2019

Main Menu

How to export search results.

Started by Wilson Logan, November 12, 2019, 02:00:34 PM

Previous topic - Next topic

Wilson Logan

You can copy and paste the search output by displaying it in Digest Mode.

I show how to do it here:

https://www.youtube.com/watch?v=Fs--bRiKjaU&t=170s


In the example  I’m saving as MHTML  which is basically a universal format but as I’m pasting into Word I could save it as any Word format e.g. DOCX, RTF, PDF, etc.

I tend to set messages per page in PGO to 5000 ish so you’re not doing hundreds of manual copy & paste operations.

ALSO:

You can export the search result as a database, CTRL+A to highlight all messages, right click on the selection and choose “Save selected as a database”, then open that database, File -- >Open database, right click on the group name and choose Export Messages.

HTML is an export option.

Cheers,

Wilson.

BMaverick

Wilson,

Your program worked so excellent.  Got the 31,000+ messages on the first try.  Took a long time due to the slowness of Yahoo.

Then EXPORTed to all of the export methods PGO offers. 

Opened the .csv text file into OpenOffice Calc program using the pipe character as the column divider.  It worked so excellent.  Then tried the same with Excel from Office 2013.  Same results.

In either of these Office programs, I can use the FIND/REPLACE to rid the message data base of SPAM, porn link ads, Yahoo & AOL ads and known banned members that caused mischief.   Also, there was a bunch of wild HTML-5 characters in the mix too.   

Once I had all of the Excel cleaned up and retained the good content from 1998 till now, I then saved this to the Excel extended xls format of .xlsx, then to the CSV format again for OpenOffice to load and save to .ods, then to a clean HTML.  Amazing how easy all of this was thanks to PGO.

Our big group of a combined 4,100+ membership over the years is now SAVED.  No hiccups likes the Yahoo to Groups.io transfers are having.  Much of our members are in their 60s to 80s as farmers on homesteads helping out the next generation of organic farming. Nobody really has any computer skills save a handful of us.

Looking forward to the import to Groups.io when it becomes available.   8) 

Bret

SMF spam blocked by CleanTalk