![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
morgandawn(Updated Oct 25, 2019)
Starting Oct 28, 2019 no new files (photos, documents, etc) will be allowed to be uploaded. Starting Dec 14, 2019, Yahoo Groups will be limited to emails only - functions like digest will be eliminated and all files and photos will be deleted. Admins will have limited tools and all groups will be invite only. And archives of existing messages will not longer be accessible.
What To Do?
I have a step by step guide here. The short version
1. Admins - back up your Groups and decide whether and where to move
2. Members - back up your Groups - don't leave this to the admins.
3. Everyone - consider documenting Yahoo Groups on Fanlore, help spread the word
The OTW has made an announcement. Their Open Doors preservation program is open to providing storage of Yahoo Groups backups that are assembled by moderators and non-moderators alike. Details here.
Fans are gathering on a Discord Channel to chat and ask for and give help: https://discord.gg/ek2xFyJ (updated invite)
Please follow the Yahoo Group Rescue Tumblr for updates
Starting Oct 28, 2019 no new files (photos, documents, etc) will be allowed to be uploaded. Starting Dec 14, 2019, Yahoo Groups will be limited to emails only - functions like digest will be eliminated and all files and photos will be deleted. Admins will have limited tools and all groups will be invite only. And archives of existing messages will not longer be accessible.
What To Do?
I have a step by step guide here. The short version
1. Admins - back up your Groups and decide whether and where to move
2. Members - back up your Groups - don't leave this to the admins.
3. Everyone - consider documenting Yahoo Groups on Fanlore, help spread the word
The OTW has made an announcement. Their Open Doors preservation program is open to providing storage of Yahoo Groups backups that are assembled by moderators and non-moderators alike. Details here.
Fans are gathering on a Discord Channel to chat and ask for and give help: https://discord.gg/ek2xFyJ (updated invite)
Please follow the Yahoo Group Rescue Tumblr for updates
(no subject)
Date: 2019-10-18 11:41 pm (UTC)In the meantime, I've discovered another limitation of the free version: it will only export 1000 messages, max, in the nice-looking human-readable html format.
But also, I've discovered that the format the data is saved in, .db3, is not actually proprietary, and there are other (freeware) readers that can open it.
(no subject)
Date: 2019-10-19 12:13 am (UTC)(no subject)
Date: 2019-10-19 12:46 am (UTC)and successfully used it to open the .db3 file that PG Offline had created out of my downloaded Yahoo group. The interface was pretty confusing, but I was able to see the list of messages and open them.
(no subject)
Date: 2019-10-19 12:50 am (UTC)(no subject)
Date: 2019-10-19 02:06 am (UTC)As an example, if I click on the contents of a message I sent on 2001-07-14 19:20:21 (message #251 in the listing; I can see the message #, the subject, and the contents of the message), I get a text box with:
(Actually it includes html formatting, which I can't show you verbatim because Dreamwidth is going to render it.)
I might not be describing it very well; I only understand maybe 25% of what I'm doing here, though I'm certainly in the process of trying to educate myself!
(no subject)
Date: 2019-10-19 04:32 am (UTC)(no subject)
Date: 2019-10-19 04:35 am (UTC)Since I don't really understand what I'm doing here, I might not be telling you all the important things, but if you ask me any more questions about it I'll do my best to answer!
(no subject)
Date: 2019-10-19 04:52 am (UTC)(no subject)
Date: 2019-10-20 02:11 am (UTC)(no subject)
Date: 2019-10-20 02:14 am (UTC)(no subject)
Date: 2019-10-20 02:45 am (UTC)You can also export all of the messages as one big text file by choosing the "pipe delimited html" option; that works without any limits in the free trial version. If you change the filename extension to .html instead of .txt afterwards, you can open it in a browser like Chrome or Firefox or whatever. It's a bit ugly, but easily human-readable. (Note: I'm speaking only from my own experience of doing it with the ~2500 messages from my one group.)
(no subject)
Date: 2019-10-20 02:46 am (UTC)(no subject)
Date: 2019-10-20 03:29 am (UTC)EDIT: Replied to the wrong person, sorry!
(no subject)
Date: 2019-10-20 03:49 am (UTC)I don't know about exporting messages to HTML with SQLiteStudio; I have not tried. The only thing I've done so far is discover that I can essentially grab the messages one-by-one by hand in HTML format (by opening them up one-by-one in the database and copy-pasting the text).
I should mention that I really don't know anything about SQLiteStudio, or SQL in general.
(no subject)
Date: 2019-10-20 03:59 am (UTC)(no subject)
Date: 2019-10-20 04:19 am (UTC)I went to Tools->Export.
When it asks "What do you want to export?" I selected "A single table." Hit next.
Then I selected the correct database (the group I wanted to export, the .db3 file for which needed to have been previously opened in SQLiteStudio), and selected the table "group_message" from the drop-down box.
I kept all of the default ticky-boxes ticked under "options" in this window, and hit "next".
That brought me to the "Export File and Options" window.
Export format: HTML
Output: file (select your desired location to save it)
Export format options: I ticked all the boxes, including "Don't escape HTML characters" (which was not ticked by default).
Maximum number of characters per cell: change it to something ridiculously high so that long fic posts won't get cut off. I set it to 10000000.
Output format: Format document (new lines, indentation)
Click finish.
This resulted, as I said, in one giant and very readable giant HTML document with every single message ever sent to the group. (It's actually in a grid, with the date and subject line in cells next to the message contents.) The one with my group's 2500 messages is 14,781KB in size.
Whether there's a way to select only certain messages to output in the file is something I do not yet know. (But of course you could always open up the HTML file in an editor and start chopping bits out.)
(no subject)
Date: 2019-10-20 04:37 am (UTC)(no subject)
Date: 2019-10-20 04:57 am (UTC)*headdesk* I just realized… it would've been smarter for me to create a new db3 for each group. I've got multiple groups saved into the same db3 file. Is it still possible to separate those out or will it smush all of those into a single export? (I will totally separate them from now on!)
And I do know a bit of SQL now since I taught myself (with copious amounts of help from kind souls on the OpenOffice forum) how to create a database this summer. I'm still not super experienced in creating queries and whatnot, but those tables can be easily matched up that way. You do a SELECT and grab the name column from the person table along with the data from the table of the messages, and you have to add a line that goes WHERE "person"."personID" = "messages"."personID" essentially (I don't know what the actual table info is there so I just made up names so it's clear what's going on). But I did all my SQL queries with a LibreOffice Base files, so this might be a bit different, we'll see.
(no subject)
Date: 2019-10-20 05:06 am (UTC)Since I've only downloaded the one group, I can't really say. When I was doing the export it looked as though, if I had more than one database, I could choose to select only one of them. What I don't know is whether the program would generate (read? differentiate?) multiple databases from one .db3 file if you'd downloaded multiple groups.
(no subject)
Date: 2019-10-22 10:02 pm (UTC)(no subject)
Date: 2019-10-20 03:31 am (UTC)(no subject)
Date: 2019-10-20 02:58 am (UTC)(no subject)
Date: 2019-10-20 03:03 am (UTC)Would it be helpful possibly if I sent you a screenshot of what mine looks like with the database open? Is there a way for me to do that? (Email, maybe?)
(no subject)
Date: 2019-10-20 03:04 am (UTC)