| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
| kb:mendeley_import [2019/01/15 04:16] – [Known Issues] dstillman | kb:mendeley_import [2020/02/29 18:49] – SQLite references have been removed from Mendeley documentation dstillman |
|---|
| ===== Mendeley Database Encryption ===== | ===== Mendeley Database Encryption ===== |
| |
| Mendeley 1.19 and later have begun encrypting the local database, making it unreadable by Zotero and other standard database tools. Elsevier 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 and [[https://service.elsevier.com/app/answers/detail/a_id/22098/kw/database/supporthub/mendeley/|erroneously continuing to state]] in its documentation that the database can be accessed using standard tools. At the same time, Mendeley continues to import data from Zotero’s own open database, as it has since 2009. | Mendeley 1.19 and later have begun encrypting the local database, making it unreadable by Zotero and other standard database tools. Elsevier 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 and explaining in its documentation that the database could be accessed using standard tools. At the same time, Mendeley continues to import data from Zotero’s own open database, as it has since 2009. |
| |
| The [[https://www.mendeley.com/release-notes/v1_19|Mendeley 1.19 release notes]] claimed that the encryption was for “improved security” on shared machines, yet 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. Elsevier later [[https://twitter.com/mendeley_com/status/1006915998841221120|stated]] that the change was required by new European privacy regulations — a bizarre claim, given that those regulations are designed to give people control over their data and guarantee data portability, not the opposite — and continued to assert, falsely, that full local export was still possible, while [[https://twitter.com/mendeley_com/status/1006919608471818240|repeatedly]] [[https://twitter.com/MendeleySupport/status/1006920802120470528|dismissing]] reports of the change as "#fakenews". | The [[https://www.mendeley.com/release-notes/v1_19|Mendeley 1.19 release notes]] claimed that the encryption was for “improved security” on shared machines, yet 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. Elsevier later [[https://twitter.com/mendeley_com/status/1006915998841221120|stated]] that the change was required by new European privacy regulations — a bizarre claim, given that those regulations are designed to give people control over their data and guarantee data portability, not the opposite — and continued to assert, falsely, that full local export was still possible, while [[https://twitter.com/mendeley_com/status/1006919608471818240|repeatedly]] [[https://twitter.com/MendeleySupport/status/1006920802120470528|dismissing]] reports of the change as "#fakenews". |
| ** If you’ve already upgraded to 1.19 and have an automatic backup of your Mendeley SQLite database in the Mendeley data directory:** | ** 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 [[https://service.elsevier.com/app/answers/detail/a_id/22098/kw/database/supporthub/mendeley/|Mendeley data directory]] and look for a backupSlot1 (or higher) folder. If you see a database in the form %%<email>@www.mendeley.com.sqlite%% within one of the backup directories, 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. | Locate your [[https://service.elsevier.com/app/answers/detail/a_id/18153/|Mendeley data directory]] and look for a backupSlot1 (or higher) folder. If you see a database in the form %%<email>@www.mendeley.com.sqlite%% within one of the backup directories, 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 backupSlot//N// 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 the backupSlot//N// 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. |
| |
| - Make sure you've synced all data and — if you want to avoid reassociating files manually — files to Elsevier's servers. | - Make sure you've synced all data and — if you want to avoid reassociating files manually — files to Elsevier's servers. |
| - Move your database out of the [[https://service.elsevier.com/app/answers/detail/a_id/22098/kw/database/supporthub/mendeley/|Mendeley data directory]] to a temporary location. | - Close Mendeley. |
| - Download Mendeley 1.18. | - Move your database (the .sqlite file) out of the [[https://service.elsevier.com/app/answers/detail/a_id/18153/|Mendeley data directory]] to a temporary location. |
| - Perform a fresh sync to pull down your Mendeley data from the Elsevier servers. | - Download and install Mendeley 1.18. |
| | - Open Mendeley and perform a fresh sync to pull down your Mendeley data from the Elsevier servers. |
| - Start the import in Zotero by going to File → “Import…” and choosing the “Mendeley” option. | - Start the import in Zotero by going to File → “Import…” and choosing the “Mendeley” option. |
| |
| |
| - Close Mendeley | - Close Mendeley |
| - Make a backup of your [[https://service.elsevier.com/app/answers/detail/a_id/22098/kw/database/supporthub/mendeley/|Mendeley data directory]], including the ''Downloaded'' folder that holds your PDF files (and other locations on your computer where you have PDF files you wish to save Mendeley annotations to) | - Make a backup of your [[https://service.elsevier.com/app/answers/detail/a_id/18153/|Mendeley data directory]], including the ''Downloaded'' folder that holds your PDF files (and other locations on your computer where you have PDF files you wish to save Mendeley annotations to) |
| - Download and unzip the menextract2pdf script from [[https://github.com/cycomanic/Menextract2pdf/archive/master.zip|here]] | - Download and unzip the menextract2pdf script from [[https://github.com/cycomanic/Menextract2pdf/archive/master.zip|here]] |
| - Open Terminal, navigate to the unzipped Menextract2pdf folder, and run the following command (filling in the correct file paths): | - Open Terminal, navigate to the unzipped Menextract2pdf folder, and run the following command (filling in the correct file paths): |
| * <code>menextract2pdf_overwrite.sh "/Path/To/Mendeley/Data Folder/" "/Path/To/Mendeley/PDF/Folder/"</code> | * <code>menextract2pdf_overwrite.sh "/Path/To/Mendeley/Data Folder/" "/Path/To/Mendeley/PDF/Folder/"</code> |
| - For example, on macOS, if you have your Mendeley database in the [[https://service.elsevier.com/app/answers/detail/a_id/22098/kw/database/supporthub/mendeley/|default location]] and your PDFs stored in Mendeley's "Downloaded" folder, you would enter: | - For example, on macOS, if you have your Mendeley database in the [[https://service.elsevier.com/app/answers/detail/a_id/18153/|default location]] and your PDFs stored in Mendeley's "Downloaded" folder, you would enter: |
| * <code>menextract2pdf_overwrite.sh "/Users/"Your Name"/Library/Application Support/Mendeley Desktop" "/Users/"Your Name"/Library/Application Support/Mendeley Desktop/Downloaded/"</code> | * <code>menextract2pdf_overwrite.sh "/Users/"Your Name"/Library/Application Support/Mendeley Desktop" "/Users/"Your Name"/Library/Application Support/Mendeley Desktop/Downloaded/"</code> |
| |
| - Install [[https://www.python.org/downloads/|Python]] | - Install [[https://www.python.org/downloads/|Python]] |
| - Close Mendeley | - Close Mendeley |
| - Make a backup of your [[https://service.elsevier.com/app/answers/detail/a_id/22098/kw/database/supporthub/mendeley/|Mendeley data directory]], including the ''Downloaded'' folder that holds your PDF files (and other locations on your computer where you have PDF files you wish to save Mendeley annotations to) | - Make a backup of your [[https://service.elsevier.com/app/answers/detail/a_id/18153/|Mendeley data directory]], including the ''Downloaded'' folder that holds your PDF files (and other locations on your computer where you have PDF files you wish to save Mendeley annotations to) |
| - Download and unzip the menextract2pdf script from [[https://github.com/cycomanic/Menextract2pdf/archive/master.zip|here]] | - Download and unzip the menextract2pdf script from [[https://github.com/cycomanic/Menextract2pdf/archive/master.zip|here]] |
| - Open Command Prompt, navigate to the unzipped Menextract2pdf folder, and run the following command (filling in the correct file paths): | - Open Command Prompt, navigate to the unzipped Menextract2pdf folder, and run the following command (filling in the correct file paths): |
Upgrade Storage