Allow chat history (selection) to be stored as a txt/cvs file

[putt1ck]

As per comments on #35:
#35 (comment)
&
#35 (comment)

It would be useful to have the ability to export/copy a text chat history or part thereof and have it associated with a file or folder that is created as a result of the discussion, possibly as comments.

[bes1002t]

But imho this should be also encrypted on the file system.

[nickvergessen]

@jancborchardt are you okay with putting it as an option into the "…" menuof the conversation list?

[shankari]

It would be great if there would be a way to automate this via a script so that we can include standard text logs in our nightly backups. Yes, we backup the database too, but databases are a lot less portable and prone to corruption

[notklaatu]

For others looking for this functionality, you can get your logs this way (until it's added to the UI):

$ mysql -u $DB_USER -p -h $HOST -D $DB -e 'SELECT * FROM oc_comments;' > ~/chat_`date +%d.%Y`.log

[shankari]

@notklaatu this is will have duplicate entries in consecutive logs, no?

So if I have chat that extended from 1st Jan to 7th Jan

• chat_01.2019 will have the messages from 1st Jan
• chat_02.2019 will have messages from both 1st and 2nd Jan
• chat_03.2019 will have messages for 1st, 2nd and third

That seems unintuitive.

[nickvergessen]

The command from @notklaatu also adds all chats into one file.

[wiswedel]

The command from @notklaatu also adds all chats into one file.

And keep in mind: It only gets chats from rooms that still exist. Deleting a room also deletes all of its chat history from the database.

[eekhof]

it would be really nice to have this, if I can help I wil

[j-j-v]

agreed - can model it on IRC logs (timestamp/user/message/(...) per line, daily file with day's date for a filename in per conversation folder - at a sketch) & make available to users via a link & ideally a built-in search, maybe with "from:username" & such niceties.

Thanks!