Upgrade Storagehelp: batch import files while parsing filename for metadata
I have ~2000 local pdf files that I want added as items in a Zotero collection. The file names consistently contain metadata to be imported (name, year, title, doi, journal and so on) and most files have a standalone txt file (same filename apart from the extension) with abstract and other details.
Any suggestions on how to best move forward?
My hunch is that I have to write a script that loops over all the files, extracts metadata from filenames and generates some type of database file that Zotero then can import. I'd appreciate informed suggestion on what format to use and relevants links.
Or are there already tools out that for doing just that? To make a comparison what I'm after would be similar to what tools like http://www.mp3tag.de/en/ does for importing/exporting to/from mp3 filename/file metadata.
Any suggestions on how to best move forward?
My hunch is that I have to write a script that loops over all the files, extracts metadata from filenames and generates some type of database file that Zotero then can import. I'd appreciate informed suggestion on what format to use and relevants links.
Or are there already tools out that for doing just that? To make a comparison what I'm after would be similar to what tools like http://www.mp3tag.de/en/ does for importing/exporting to/from mp3 filename/file metadata.
What I'd probably do is get the file metadata into JSON format using perl and then write some javascript probably using the POW extension to make things a bit easier for me (firefox 3.5 only at the moment though :-[ ) to get the JSON + file attachment into zotero.
The alternative would be to write RIS with an LI entry giving the file:// to the attachment, but to be honest I think using the API will be easier if you're comfortable with programming.