Learning patterns/Uploading files using Pattypan

A learning pattern forGLAM
Uploading files using Pattypan
Pattypan.svg
problemHow to successfully prepare and process batch upload using the tool Pattypan
solution.
creatorYarl
endorse
created on18:03, 5 July 2016 (UTC)
status:DRAFT


What problem does this solve?Edit

Upload batches of files with extended description templates like Artwork or Photograph and be able to check for possible errors, and preview results before uploading.

What is the solution?Edit

Install PattypanEdit

  1. Before installing, make sure that the latest version of Java is installed on your computer. Download Java here: https://www.java.com/download/
  2. Download Pattypan from: https://github.com/yarl/pattypan/releases and save the .jar file.
  3. If there is an issue in opening the .jar file even after installation of latest version of Java, then you can download jarfix.exe software that easily opens any jar file.

Prepare a folder containing the files you wish to upload to Wikimedia Commons on your computer.Edit

  • (Note: It can help to provide recognizable names for files in that folder).

Create a spreadsheet to be filled inEdit

 
Pattypan - selection of description fields
  1. Run the pattypan.jar file,
  2. Click Generate spreadsheet and navigate to a folder on your computer containing the files you would like to upload.
  3. Choose columns: Select the fields, which you would like to include in the file descriptions (e.g. date, dimensions, institution, source, etc.) The selected values will be converted into column headings — you will then be able to fill the columns with appropriate information. At this stage, you can pre-fill selected fields with repetitive information by writing it into the provided boxes.
  4. After selecting your chosen fields, click Create File. The spreadsheet will be created in the same folder in which your image files (to be uploaded) are placed.
  5. Click Open to open the generated spreadsheet.
Name columnEdit

Beware that the name column will be the filename of the image. If you have names as 1993-001 or 123445 they can't be uploaded. Try to fill it with correct title names.

Fill in the spreadsheet with file descriptionsEdit

 
Pattypan generated xml sheet
 
Pattypan generated sheet
 
Pattypan - verifying before upload
 
Pattypan: warnings, possible errors
  1. Fill in the fields (Author, title, and all your chosen fields) with appropriate information.
    • To enter multiple target categories on Wikimedia Commons in the spreadsheet, separate them by a semicolon (;). Example: Raphus cucullatus;Crocodilia Note: All fields can (but do not have to) be filled in using wikicode; the License field must be filled in using wikicode, e.g. {{cc-by-sa-4.0}}. Find the right license here: Copyright tags
  2. Click File --> Save.
  3. Go back to Pattypan, navigate to the starting screen and click Validate and upload.
  4. Navigate to the folder on the computer containing the spreadsheet (and images) and select the spreadsheet. Check for error notifications (empty fields, other errors). You can also click through to test views of file descriptions to preview them before uploading. Then click Next.
  5. Login with your Wikimedia Commons username and password. Click Upload to upload all items and descriptions to Wikimedia Commons.

Things to considerEdit

  • Make sure that the latest version of Java is installed on your computer. Download Java here: https://www.java.com/download/
  • To enter multiple target categories on Wikimedia Commons in the spreadsheet, separate them by a semicolon (;). Example: Raphus cucullatus;Crocodilia
  • Instructions with screenshots can be found on Commons:Pattypan/Simple manual.
  • If you make a copy of the sheet generated by Pattypan, make sure to copy both the pages - data and template, otherwise during the sheet upload, it will keep showing error.

When to useEdit

  • When uploading a batch of files with repetitive description fields (e.g. Artist, Photographer, Institution, License)
  • When flexibility and control over descriptions is needed
  • For GLAM projects: in order to create a custom description format
  • This software can be downloaded for Windows and its app version has been created for Mac as well.

When you cannot useEdit

  • This tool unlike VicuñaUploader cannot upload files to any other project apart from Wikimedia Commons.

EndorsementsEdit

  • This is such an amazing tool, Earl. Thanks for creating and sharing it here. We've started using it for batch uploading pronunciation of Odia-language words under the scope of the Kathabhidhana project (example). Thanks to Shrijagannatha who shared this with me. --Subhashish Panigrahi (talk) 12:06, 8 March 2017 (UTC)
  • Love this tool. It can help in uploading batch files in structured way. It was useful learning pattern. Helped me in uploading files for Heritage GLAM project.Wikilover90 (talk) 19:10, 25 September 2019 (UTC)
  • It works great! Theklan (talk) 09:20, 7 October 2019 (UTC)

See alsoEdit

Related patternsEdit

External linksEdit

ReferencesEdit