PG Offline

PG Offline => I need Help ! => Topic started by: wapfinator on January 17, 2016, 07:19:23 PM

Title: Tasks - external utility
Post by: wapfinator on January 17, 2016, 07:19:23 PM
Is there an SQLite utility that would let me do what I used to do in Access - namely, rename groups in a database? This used to come up when a group would close and I would want to change its name to, e.g., GroupA-CLOSED, or the like.  Of course it makes sense that one would be disallowed to rename active groups from within PG Offline. it's just that once closed, the name of the group no longer matters to Yahoo since one is no longer going online for it. Thanks!
Title: Re: Tasks - external utility
Post by: Wilson Logan on January 18, 2016, 10:34:11 AM
I recommend SQLite Studio.

http://sqlitestudio.pl/

To change the group name I think you only need to change one field in one table:

discussion_group.name

(See attached).

Cheers,

Wilson.
Title: Re: Tasks - external utility
Post by: wapfinator on January 21, 2016, 02:48:12 AM
Hi Wilson, This is terrific, thanks.
Title: Re: Tasks - external utility
Post by: Wilson Logan on January 21, 2016, 08:26:24 AM
Hi Debbie,

Note that if its in a database with other active groups you can set a flag on the group so that it is not part of a Refresh.

Right click on group name choose Groups Settings--> Download Settings--> Skip during Refresh all Groups

Cheers,

Wilson.