Page MenuHomePhabricator

Wikimedia Commons: Reconcile & upload images of old prints from Erfgoedcentrum Rozet to Commons with OpenRefine & Pattypan
Open, MediumPublic

Description

Proposed workflow
In the attached spreadsheet:

  1. reconcile the names of the authors of the prints with WD q-numbers using Open Refine.

1.a. for reconciled authors with known death-date: add creator template
add death date to license template {{PD-old-auto-expired |deathyear= }} and add license template to column M (license)
1.b. for authors that cannot be reconciled; leave author name as is and add license template {{PD-Old-70}}

  1. c. for unknown authors, add template {{Author|unknown}} to column F and add license {{template {{PD-old-assumed |duration= 70}} to column M (license)
  2. rework inscriptions in column I to match format for Template:Inscription
  3. rework dates in column J to match Commons requirements (see template:Other date) (with Excel or Open Refine)
  4. Download images and add path to filename by creating new Pattypan sheet (make sure the order of the files on your computer is the same as in the excel file)
  5. validate & check the format of the files with the Pattypan preview function
  6. upload the images with Pattypan

optional:

  1. add categories to the files using hot cat
  2. add structured data information to the files, using SDC or ACDC

Background
Erfgoedcentrum Rozet is a small heritage institution located in Arnhem. In the light of a WiR-project, they have uploaded images of their large engraving collection (mainly famous persons and local mansions) to Wikimedia Commons. They want to expand that collection with this upload, but lack the time and knowledge to do the upload themselves.
See: https://commons.wikimedia.org/wiki/Category:Media_from_Erfgoedcentrum_Rozet

Documentation

Event Timeline

MichellevL_WMNL renamed this task from Reconcile & upload images of old prints from Erfgoedcentrum Rozet to Commons with Pattypan to Reconcile & upload images of old prints from Erfgoedcentrum Rozet to Commons with OpenRefine & Pattypan .Oct 29 2019, 10:12 AM
MichellevL_WMNL renamed this task from Reconcile & upload images of old prints from Erfgoedcentrum Rozet to Commons with OpenRefine & Pattypan to Wikikmedia Commons: Reconcile & upload images of old prints from Erfgoedcentrum Rozet to Commons with OpenRefine & Pattypan .Oct 31 2019, 1:48 PM
MichellevL_WMNL added a project: OpenRefine.
Ecritures renamed this task from Wikikmedia Commons: Reconcile & upload images of old prints from Erfgoedcentrum Rozet to Commons with OpenRefine & Pattypan to Wikimedia Commons: Reconcile & upload images of old prints from Erfgoedcentrum Rozet to Commons with OpenRefine & Pattypan .Nov 4 2019, 1:17 PM
Ecritures triaged this task as Medium priority.
Ecritures moved this task from Backlog to SPARQLstation on the Wiki-Techstorm-2019 board.

Example excel of first ten records allready filled out (& uploaded partly)

@A_ka_es; at the tech storm you mentioned that you were unable to upload the files completely, could you attach the excel you used to this task so I can take a look? Thanks!