On cawiki we have a bot checking that all images used in lists have the correct monument template. It has been usefull to check new entries in the lists and to organize the images on Commons. I think this can solve your point 3)
Date: Fri, 24 Feb 2012 23:35:01 +0100
From: jane023@gmail.com
To: wikilovesmonuments@lists.wikimedia.org
Subject: Re: [Wiki Loves Monuments] Structured lists: a bilingual list of monuments
Thanks again for these responses: that is exactly what I meant!
So summing up, it's a bi-directional list update process between Wikimedia Commons and XX Wikipedia (in my case en):
1) Put all of the en list pages on my watch list (if I create them I guess they are there automatically)
2) " register" these en lists with Maarten to make sure they are included in the update process; and create an en "unused photo holding page"
3) If someone adds a picture to one of the en lists, check manually to see it's actually a commons picture, because if it isn't, it needs to be transferred (with the proper tag, yada yada) to Commons or replaced with a Commons equivalent (if there). This is the update direction from en Wikipedia to Commons
4) Check the en "unused photo holding page" periodically for updating manually the other way around (these are photo suggestions coming in from Commons to the en Wikipedia)
Is this everything? How do I make an unused photo holding page?
2012/2/24 Platonides
<platonides@gmail.com>
>> I think the monuments_all entries from ca will get overwritten by the fr
>> ones, though.
> No, that's not the case. The monuments_all table contains a lang field.
> So it's possible to have the exact same entry, but with a different
> language.
>
> Maarten
Oh, right. I didn't remember the PK was [country,lang,id]
Sorry.
_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.eu