Through a GLAM collaboration, Wikimedia Spain has obtained access to hundreds of images of old coins and their catalogue information under a CC-BY-SA license. A work flow is already in place to download the images from the collaborator's website, process them, categorize them and automatically create a Commons-format description of the file usin spreadsheet functions. Then each of the files is uploaded to Commons one by one, as the description has to be manually copied for each file to the appropriate field of the upload form. This last step is currently the bottleneck of the entire process.
We would like to have an automated system to upload batches of JPG files to Commons using as description the text provided in a spreadsheet. In addition, for good housekeeping, we would like the automated system to add a third column to the spreadsheet with the URL of the file in Commons.
As a test, we are providing a ZIP file with 25 of the images we would like to upload along with a spreadsheet in Open Office format.