Switching from Mendeley to Zotero (Windows)

My Mendeley database contains about 20,000 references neatly organized in folders and some with notes in the pdf. I do not care too much about the notes but I care about the folder structure especially as I am dealing with taxonomy and have folders for different taxonomy levels. One key issue is that starting from version 1.19 of the Mendeley desktop manager, Mendeley encrypeted the Mendeley database that resides on your computer and therefore other applications cannot access the SQlite Mendeley database which makes any transfer to another reference manager painful.

Mendeley file structure

One caveat is that I do not use Word or Google docs to write up papers. I switched completely to Latex using Oveleaf for collaborative work and have no intent whatsoever to switch back to Word. So basically, I am exporting references as Bibtex.

Alternatives to Mendeley.

I have tried a couple of alternatives:

  • Papers from ReadCube. It is owned by a big company related to the Nature group. I did not like really the interface and it lacked some of capabilities of Mendeley. Also does not import easily Mendeley folder structure.
  • Paperpile. It imports very easily the Mendeley database and data structure by going directly to the Mendeley web interface (it does not read your local Mendeley database) but I do not really like the interface and the search capacities are super limited. It only interface at present with Google docs, not Word nor Overleaf
  • Zotero. It is open source and has many plugins which add a lot of functions. It is more complex to master than Mendeley, but finally I decided to switch to Zotero because it has more or less all the functions I need in particular, creating public and private groups. Moreover it can be linked to Overleaf. Some nice tutorials:

Moving from Mendeley 1.19 to Zotero

The following instructions are valid for Mendeley 1.19. If you have version 1.18, things will be more easy

Just as a foreword, it is a very painful process if you have a lot of references and you are bound to loose some references in the process

Detailed instructions can be found on the Zotero web site.

Install and configure Zotero

  • Install Zotero and Chrome connector
  • Install DOI plugin for managing DOIs.
  • Install Zutilo mlugin that allows to correct very quickly a lot of references together e.g. to change the Journal Name.
  • Install Zotfile plugin to manage pdf file storage. Once you have it installed you can configure Zotfile:
    • to attach the files to the database and synchronize them to the Zotero server. For a medium size database (about 2500 files) the best Zotero deal is “unlimited storage” which costz is 120US$ per year.
    • to link your pdf files to a folder on your Google drive (this way your files will be synchronized without having to pay for space on Zotero server)
  • Install and configure Better bibtex plugin. This allows to customize bibtex citation keys and drag and drop citations from Zotero to any editor such as overleaf.

Better bibtex define keys

Zotero quick export

In Mendeley:

  • select all your references, left click and press update (see image below). This will use the DOI to update all your Mendeley references. Zotero lacks this capacity.

Mendeley update references

  • synchronize your database including your files to Mendeley server

Mendeley synchronize

  • exit Mendeley

Move Mendeley database and install version Mendeley 1.18

  • Locate your Mendeley database in directory: Username\AppData\Local\Mendeley Ltd\Mendeley Desktop

Mendeley database

  • Move this database to a safe location
  • Install Mendeley 1.18
  • Resynchronize your entire database with the pdf files. I use the following organization for the file but this really does not matter. This step may take several hours depending on the size of library and the speed of your connection.

Mendeley database

  • Finally import into Zotero. This took a long time especially with 20,000 references and crashed a few times… In my case it crashed after 5,600 import. One thing that helped is to move some references that were “Unsorted” to trash. You can recover them later to import them through bibtex.

Groups

Groups from Mendeley are not imported into Zotero.

  • Save all the pdf from the Group in a directory
  • If you have files in subfolders, use tags to mark the subfolders (eg. 18SV4, 18SV9)
  • Export as bibtex (making sure that in the Mendeley settings you do not escape the characters for Latex)
  • Import into Zotero
  • Note: files in Groups have to be attached and cannot be linked. So you if you want to move some references from your Library to a Group Library you will need first to attach them (Menu Tools/Manage attachment/Convert Files to Stored files).

Conclusion…

What a pain, should have moved to Zotero a few years ago….