Open Access Media Importer: Database, Upload Testing

“Since the last post, I rewrote the Open Access Media Importer to use a proper database –SQLite – instead of CSV text files. This step should aid both maintainability and performance; while generating the database using oa-cache find-media now takes longer than before, querying contents is considerably faster and easier. While the data can no longer be viewed using a text editor or office program, one can browse it using theSQLite Database Browser. For demonstration and testing purposes, I built a new source that, given a list of DOIs, downloads only metadata regarding the articles in question (if it can be found on PubMed Central). This means that importing media from specific articles only is now feasible, this function will probably be used after the bulk import is done. There have been two test runs of the bot on so far on Wikimedia Commons, both helped finding serious oversights. It turned out that new accounts on Wikimedia Commons can upload material unhindered immediately, but are only allowed to edit pages after four days or solving a CAPTCHA. Due to this, the first uploads did not have any metadata...”