This is an old revision of the document!


How do I import a Mendeley library into Zotero?

Zotero includes support for directly importing from a Mendeley database into Zotero via File → “Import…”, but due to recent changes by Mendeley a couple extra steps may be required.

Mendeley Database Encryption

Mendeley 1.19 and later have begun encrypting the local database, making it unreadable by Zotero and other standard database tools. Mendeley made this change a few months after Zotero publicly announced work on an importer, despite having long touted the openness of its database format as a guarantee against lock-in. At the same time, Mendeley continues to import data from Zotero’s own open database.

The Mendeley 1.19 release notes claim that the encryption is for “improved security” on shared machines, but applications rarely encrypt their local data files, as file protections are generally handled by the operating system with account permissions and full-disk encryption, and anyone using the same operating system account or an admin account can already install a keylogger to capture passwords.

Direct access to the Mendeley database is the only local way to export the full contents of one’s own research. The export formats supported by Mendeley don’t contain folders, various metadata fields (date added, favorite, and others), or PDF annotations. Mendeley offers a web-based API, but it only contains uploaded data, so relying on it would mean that anyone wanting to export their own data would first need to upload all their data and files to Mendeley’s servers. The API is under Mendeley’s control and can be changed or discontinued at any time.

The Import Process

If you haven’t yet upgraded to Mendeley 1.19:

Start the import in Zotero by going to File → “Import…” and choosing the “Mendeley” option.

If you’ve already upgraded to 1.19 and have an automatic backup of your Mendeley SQLite database in the Mendeley data directory:

Locate your Mendeley data directory and look for a backupSlot1 (or higher) folder. If you see a database in the form <email>@www.mendeley.com.sqlite, copy it into the data directory one level up. Then start the import in Zotero by going to File → “Import…”, choosing the “Mendeley” option, and selecting that database.

If the backupSlotN folder contains an .sqlite filename with a long string of random characters, the backup has already been overwritten by the encrypted database. Check another backupSlot folder or use one of the methods below.

If you’ve already upgraded to 1.19 and have a recent backup of your Mendeley SQLite database:

Start the import in Zotero by going to File → “Import…”. If you haven’t moved your backup files back into the Mendeley data directory, use the file option to select the <email>@www.mendeley.com.sqlite or online.sqlite database in your backup directory.

If you’ve already upgraded to 1.19 and are not able to import from a recent backup of your Mendeley SQLite database:

  1. Move your database out of the Mendeley data directory to a temporary location.
  2. Download Mendeley 1.18.
  3. Perform a fresh sync to pull down your Mendeley data from the Mendeley servers.
  4. Start the import in Zotero by going to File → “Import…” and choosing the “Mendeley” option.

Mendeley 1.18 installers

Troubleshooting

If anything doesn’t come through how you expect or you run into any trouble, let us know in the Zotero Forums.

kb/mendeley_import.1528954312.txt.gz · Last modified: 2018/06/14 01:31 by dstillman