solved How to clear Simple Chat data ?

My site is about to be filled to the max on space, so i did some digging to see what is using up so much space because it dousnt seem correct but i see now its simple chat that is storing lots of data like file uploads into the chat. can this be deleted to save space? and how do you clear it all out?
updated by @zachary-moonshine: 10/01/18 04:06:47AM

let me guess go to simple chat module click tools click data store and delete each item one by one?

I am gonna get carpal tunnel from this

How much disk space will you save by deleting your chat data?

Are you looking to delete a few massive files or many small files?


--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)

well it just went from 89% down to 69% just from deleting all the mp3s and pngs working on the jpgs now there is no need for those files to stay in the chat more than day we only use it to show something or share something for the moment and then its no longer needed but mine had over 6 thousand items since we created the site

So you have solved the problem?

Limit the size of the upload, or make a simple module to delete your chat uploads after 24 hours.


--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)

i wonder if i delete the chat rooms would that delete everything automatically ?

nope that does not work lmao just have to sit here for a few more hours one by one deleting them

Solve your problem by preventing it:



--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)

maybe delete the room then re-add it. Or if you want to delete all from all chat rooms, TRUNCATE the table for chat in the database.

What Michael said.
Deleting a room removes all its messages from the DB message table (have just tried it )


--
Paul Asher - JR Developer and System Import Specialist

Hmm. So are you saying if a particulr chatroom is like a year old... does that mean that every single file attachment or MP3 that members have posted in it stays on our server... all that time...for the entire life of the room? I have chat rooms created by my moderators that I don't want to delete and recreate- it's better to have them show as having been created by the chat moderator. But i dont want to have to periodically delete his chatroom and ask him to recreate it.
Ning's ancient chatrooms,, and also Cometchat.. both had buttons to simply 'clear/delete' all chat messages from a room with an admin button right there in the chat settings. I always thought it was a bit odd not to have a 'clear messages' button in addition to just deleting messages one at a time with an X box.
Would a 'clear all' button remove the space-hogging files from the server so they don't accumulate on my server for weeks or months?


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

yes correct all the data including mp3s and images has been stored in my database building up now for over a year going back to jan 2017 it was well over 6 thousand items i have it down now to 2300 but i had to give my hand a rest. I don't want to have to get rid of the upload feature in chat as its obviously loved by my members i like using it too. but yes if i could at least have a select all button to delete the items at once that would make life much easier. and i did try deleting the chat rooms and creating new ones and it erased the transcripts but it still saved the mp3 and images

if u wanna see what yours has @strumelia go to your dashboard click data browser and select simple chat and u can view all items stored
updated by @zachary-moonshine: 06/10/18 09:18:06AM

Oh my lord.... !
As a musician based site, we have TONS of members in chat that post MP3s and videos and photos of their instrument builds, etc.
I can see over 400 obsolete files there taking up WAY too much space for the past year.
Time to exercise the delete finger for sure. But would make total sense to find a way to delete all these accumulated large files periodically with just one click.
--> Better yet- I'd love to be able to simply set things to AUTO-DELETE chat attachments after X amount of time.. (choices of: 1 week, 1 month, 6 mon for example would be great)


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
updated by @strumelia: 06/10/18 09:52:36AM

We have 150,000+ here on Jamroom.net

Clearing all chat data for a chat room is something we can look into.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

That would be terrific... and a hugely helpful ability, Brian.
Thank you!


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

thanks @brian

Thanks for the new Global Option in SimpleChat to 'prune' chat messages after X number of days. It's much appreciated!
I just have one question on this new update-
when these messages get 'pruned' (say after 2 or 3 days) does that mean the ATTACHMENTS that members added to those chat posts also get DELETED from our JR server? I mean like MP3s and JPGs that they may have attached (that up until now have gotten stored on our server in perpetuity) ? My musician members attach/embed all kinds of big files in chat every day, and my main concern (Zachary's too, I believe) is that I don't want those files accumulating on my server forever.
Thanks for clarifying...


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

I just set mine to clear out after one day so i hope tomorrow when i check the datastore it show's zero items under simple chat datastore. But the way its stated as saying it removes messages it makes me think its just talking about the text and not the attachments?

We also need clarity on this thread:
Does the new chat "prune" option actually delete chat file attachments?

Of course it does If the message contains an attachment, then yes - the attachment is deleted when the message is deleted.

Let me know if that helps.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

That is Great News - this helps our decision, since we actually have interest to "invest" custom hours into the Chat module.

Hope your team has time for custom work to upgrade chat, and make it even better for the whole community
updated by @softdesigns: 07/01/18 07:05:44AM

thank you soo much guys this works i tested it out yesterday i changed it to hold for 1 day and today i see the list went from thousands down to one page! Much much much easier ... my mouse clicking finger thanks you

This is so awesome! :D
Zach i was waiting to hear the results of your '1-day test'.
Wheee... happy dance!


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015