Page MenuHomePhabricator

Implement CSV export to Monuments API
Open, Needs TriagePublic

Description

@BeatEstermann indicated this would be helpful to him for the Wikidata migration. Should be fairly straightforward to implement another export format to the Monuments API.

Event Timeline

I believe the desire was to have this export the country specific tables. Not just monuments_all.

Yes, being able to download the contents of the various monuments list templates that are harvested by erfgoedbot would be very useful in view of the data migration to Wikidata (until all the monuments lists have been switched to pulling their data directly from Wikidata).

Sorry for dropping the ball on this @BeatEstermann

I had to do a similar thing for @Braveheart − a straight Database dump is somehow similar to .tsv, and then to make it available in public_html for download.

So I can run this on demand, or slap a tiny Python/Shell script in a cron to run a daily export with

echo "SELECT * from `monuments_XX_(YY)`;" | mysql -h tools-db s51138__heritage_p > ./public_html/csv_dump/XX_YY.tsv