Re: [Savannah-hackers-public] Refreshing /cooperation/groups.tsv

[Sylvain]

Hi,

https://planet.gnu.org/ is ready and eager to get an updated groups.tsv :)
Any progress?

- Sylvain

On 07/03/2018 20:38, Sylvain wrote:
> Hi!
>
> I'm working on bringing back planet.gnu.org
>
> There is a list of GNU projects exported to a flat file on a regular
> basis, and it was used by planet.gnu.org to auto-subscribe their project
> News feed.
> I see it's still available at http://savannah.gnu.org/cooperation/groups.tsv
> but it's Last-Modified "Wed, 27 Jul 2016 06:25:12 GMT" :/
>
> (I also see there was some work in 2015 to export it in .json and such,
> I don't know about that).
>
> Could you re-enable the regular export again?
>
> For reference the cron job I had setup was:
> mysql savane -h 10.1.0.101 -B -e 'SELECT group_type.type_id,
> group_type.name, unix_group_name, group_name FROM groups, group_type
> WHERE groups.type = group_type.type_id AND groups.status="A" ORDER BY
> type;' > /var/www/overlay/cooperation/groups.tsv
>
> Cheers!
> Sylvain
>
>