Re: BUG #15706: Support Services page out of date

On 4/27/19 6:41 AM, Magnus Hagander wrote:
>
>
> On Sat, Apr 27, 2019 at 5:48 AM Jonathan S. Katz <jkatz@postgresql.org
> <mailto:jkatz@postgresql.org>> wrote:

>     This is also a long way of saying that I think we should proceed with
>     the solution to help automate this. After going through the painstaking
>     process again, I'd recommend it works kind of like this:
>
>     - An email goes out once every {6 months, 1 year} to the organizational
>     contact that says something like: "Hi, This is an automated check to
>     ensure your company is still an active PostgreSQL service provider.
>     Please click the URL provided to confirm. <UniqueURL> If you do not
>     confirm within 7 days, your listing will be unpublished"
>
>
> 7 days might be a bit on the short side. If someone is unlucky they get
> the notification while on vacation for example, and then they're
> delisted before they can even see it.

Well, that's why I suggested it gets de-listed, so one of us can
manually check and determine if indeed it should be delisted, or it's
the case of out-of-office, or a bad email address, etc.

>     - If user clicks URL, it is confirmed and the last_confirmed_date is set
>     to CURRENT_DATE
>
>     - If user does not click URL, we set the entry to unpublished. This
>     would put it into the moderator feed, and one of the pgweb moderators
>     can then take further action if need be.
>
>
> That's pretty close to my original thoughts around that, except I'd just
> delete them as step 3 and not bother the queue.  I'm fine with
> de-listing it as well, as long as pgweb moderators are happy to handle
> that :) That would also take care of the scenario where the email
> bounces, by simply being able to ignore that fact and leave it up to the
> individual moderator to handle manually.

I would de-list it. It's certainly easier for a moderator to check a few
of said entries vs. the whole slew.

>     Anyway, products needs a scrub as well, which I will try to block out
>     some time for in the coming days to handle those as well. Those should
>     hopefully not take as much time as they are a bit easier to verify.
>
> Cool. Thanks!

NP, feels good to do some spring/fall cleaning :)

Jonathan