Exporting messages to text

[Wilson Logan]

 
I have been able to do it with SQLite Data Wizard.

http://www.sqlmaestro.com/products/sqlite/datawizard/download/distribution/

You have to specify a database, then the table (group_message), then fields of the table (actual text is in 'content' field) and for BLOBS you have to specify the maximum length (I set it to 1200).

I chose pipe delimited text output and it worked fine.

Cheers,

Wilson.

[casstk]

I should start by saying I know nothing about MySQL. I wanted to try this and downloaded the program.

My first step was to "specify the database". I only saw one option which is Import which worked until I got to the "Add target tables to import table" - then it greyed out  at "Set Source file options".  So clearly I had down the "specifying" incorrectly.

Edited: doh, used the Export function, loaded the database that way and was able to export. The messages appear in html which has me trying to figure how to load them into a more readable format.

[Wilson Logan]

Update:

There exists now functionality to export messages as text.

You can export messages as pipe delimited plain text  or  pipe delimited HTML   or as an SQL Dump.

Right click on the group name in the groups list and choose "Export Messages" from the context menu.

It is the last (bottom) option in the list.

Cheers,

Wilson.

[casstk]

Thanks for adding this.  we're testing it right now.

[Wilson Logan]

Any problems... get back to me.

Cheers,

Wilson.