Author Topic: Is there a way to mass-delete groups from a database?  (Read 574 times)

Max Pre-Server

  • Sr. Member
  • ****
  • Posts: 28
Is there a way to mass-delete groups from a database?
« on: December 16, 2019, 04:25:01 PM »
Hi,

I'm sorting through my databases to clear out blank groups (since I cloned my main List file, there are 400+ per clone with maybe 200 blank ones or duplicates of ones that were downloaded in another database). It seems that I can't select multiple groups to delete at a time, and so I have to go one-by-one, right-clicking and confirming to delete each of them. I'm wondering if there's a way to delete multiple groups at a time in PG Offline. It would be super useful.

Wilson Logan

  • Administrator
  • Hero Member
  • *****
  • Posts: 2794
    • Email
Re: Is there a way to mass-delete groups from a database?
« Reply #1 on: December 17, 2019, 01:11:49 AM »
This program is end-of-life so we're not going to be making any changes.

What you could do is rather than copy a full database, copy an empty one.

You can mass load a database from another database.

So, make a new, empty database, add just the groups you want from the List function and then import the actual messages from your main database which you can do en mass.

Max Pre-Server

  • Sr. Member
  • ****
  • Posts: 28
Re: Is there a way to mass-delete groups from a database?
« Reply #2 on: December 18, 2019, 03:27:21 PM »
Ok, that should work. Thank you.

Wilson Logan

  • Administrator
  • Hero Member
  • *****
  • Posts: 2794
    • Email
Re: Is there a way to mass-delete groups from a database?
« Reply #3 on: December 18, 2019, 04:24:58 PM »
No probs!

Max Pre-Server

  • Sr. Member
  • ****
  • Posts: 28
Re: Is there a way to mass-delete groups from a database?
« Reply #4 on: January 30, 2020, 05:25:58 PM »
Hi,
   What would you recommend one do if, now that the list function no longer works, I wanted to "merge" all of my message archives into one .db3 for export purposes? Manually add each one (300+) to the blank database using Add Group so that I can import from my assorted databases, or is there a different way of doing this for larger projects?

Thanks,

-Max
« Last Edit: January 30, 2020, 06:49:19 PM by Max Pre-Server »

Wilson Logan

  • Administrator
  • Hero Member
  • *****
  • Posts: 2794
    • Email
Re: Is there a way to mass-delete groups from a database?
« Reply #5 on: February 02, 2020, 04:32:07 PM »
The bigger your db gets the slower it will be.....

Anyway, you can add manually OR...  you can 'poke' the db manually.

You want the discussion_group table.

You can just add entries manually. Very fast.

When you see the table it will be immediately apparent what to do.

Use SQLiteStudio.  Its a free SQLite database editor.

 

SMF spam blocked by CleanTalk