This tool probably will not work on any newer versions of Mendeley (>=1.19), since they started encrypting the local database. In addition, Zotero has since added official Mendeley import functionality, which I would recommend giving a shot before trying anything else.
Tool to transfer metadata which is not covered in the existing Mendeley export formats (biblatex, rsi) from Mendeley to Zotero.
It might not be efficiently written but it does the job. Feel free to extend to further metadata.
During switching from Mendeley to Zotero you will be faced with diverse nontransferred metadata. The most important of these are dates you added publications to the library and the Mendeley Folder structure.
The export formats provided in Mendeley (biblatex, rsi) do not include any of these data.
NOTE: This script works directly on the sqlite databases of both programs. BACKUP your sqlite files before letting this script change them.
python mendeley2zotero.py -m M -z Z {added_dates, collections, repair_dates}
Path to mendeley sqlite file - on OSX this should reside in /Users/USERNAME/Library/Application Support/Mendeley Desktop
Path to zotero sqlite file - on OSX this should reside in /Users/USERNAME/Library/Application Support/Zotero/Profiles/KEY.default/zotero
transfer "date added" information to Zotero
Usage:
python mendeley2zotero.py -m M -z Z added_dates
transfer Mendeley folders to Zotero collections
For now, beforehand, create by hand in Zotero the desired structure of Collections/Subcollections. Then run the below.
NOTE: Nonunique names are not supported for now - i.e. all your Collections should have a distinct name.
only neccessary if you ran v.0.1 to import added dates. this forces all added_date entries to the zotero compliant datetime. This was fixed in v.0.2 and should not be neccessary.
Usage:
python mendeley2zotero.py -m M -z Z repair_dates
- SQLAlchemy.
- Indirectly: SQLACodegen. SQLACodegen was used to reverse engineer the database object relational model of mendeley and zotero in the db_classes_*.py files.
- 0.1.1: fixed a bug with the sqlite datetime format that prevented syncing with the zotero server - see the repair dates function if you were affected.
- 0.1.0: initial version