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.)
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
branchandroot
(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.)