PG Offline

PG Offline => I need Help ! => Topic started by: Max Pre-Server on December 16, 2019, 11:25:01 PM

Title: Is there a way to mass-delete groups from a database?
Post by: Max Pre-Server on December 16, 2019, 11: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.
Title: Re: Is there a way to mass-delete groups from a database?
Post by: Wilson Logan on December 17, 2019, 08: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.
Title: Re: Is there a way to mass-delete groups from a database?
Post by: Max Pre-Server on December 18, 2019, 10:27:21 PM
Ok, that should work. Thank you.
Title: Re: Is there a way to mass-delete groups from a database?
Post by: Wilson Logan on December 18, 2019, 11:24:58 PM
No probs!
Title: Re: Is there a way to mass-delete groups from a database?
Post by: Max Pre-Server on January 31, 2020, 12:25:58 AM
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
Title: Re: Is there a way to mass-delete groups from a database?
Post by: Wilson Logan on February 02, 2020, 11: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.