View Single Post
Old 08-12-2016, 11:43 AM   #75
ZoteroCalbrNote
Member
ZoteroCalbrNote began at the beginning.
 
Posts: 10
Karma: 10
Join Date: Aug 2016
Device: pc, ipad, kobo, kindle, iphone, android
Quote:
Originally Posted by DaltonST View Post
I think it is because "sanders_2003_from_transactional_to_transcendental . pdf" has a space between the dot and the pdf. That is why you see in debug the "list_failed_adds".

Try renaming it in Zotero, and then reexporting the CSV.

Also, the Zotero CSV file must be untouched by human hands at the risk of corrupting it. It must be the originally exported CSV file still in UTF8 format. Excel corrupts UTF8 formatted CSV files. Do not use Excel. Fix Zotero, not the CSV.

Having said that, LibreOffice Calc saves CSV files properly in UTF8 if you specify the "filter" option when you save. I used Calc a lot to create test data for ZMI. However, I still think it would be far preferable to fix Zotero using one of its plug-ins, such as Zotfile, to change all ". pdf" extensions to ".pdf".

Hope this helps.


DaltonST
Wow that was a quick response, I appreciate it.

Renamed 10 test files using ZotFile > Exported CSV using UTF-8 encoding > Create fresh Calibre library > Select these options 1 and 2 > Generate custom columns > select this CSV file > Result 1 and 2

There was also a similar "Cursor Closed" error but the text was overwritten on my clipboard. I repeated the above steps starting with creation of a new library, and the same error occurred:
Quote:
calibre, version 2.64.0
ERROR: Unhandled exception: <b>CursorClosedError</b>:The cursor has been closed

calibre 2.64 embedded-python: True is64bit: False
Windows-8-6.2.9200 Windows ('32bit', 'WindowsPE')
32bit process running on 64bit windows
('Windows', '8', '6.2.9200')
Python 2.7.9
Windows: ('8', '6.2.9200', '', 'Multiprocessor Free')
Successfully initialized third party plugins: Extract ISBN (1, 4, 4) && Find Duplicates (1, 6, 2) && Zotero Metadata Importer (1, 0, 34) && EpubSplit (2, 1, 2) && Favourites Menu (1, 0, 4) && EpubMerge (2, 0, 12) && Quality Check (1, 9, 11)
Traceback (most recent call last):
File "calibre_plugins.zotero_metadata_importer.zmi_dial og", line 1096, in select_zotero_export_csv_file
File "calibre_plugins.zotero_metadata_importer.zmi_dial og", line 1138, in import_exported_csv
File "calibre_plugins.zotero_metadata_importer.zmi_dial og", line 1347, in check_csv_for_keys_missing_from_calibre_zkeys
File "calibre_plugins.zotero_metadata_importer.zmi_dial og", line 3200, in add_missing_books_via_calibredb
File "calibre_plugins.zotero_metadata_importer.zmi_dial og", line 3276, in list_failed_adds
CursorClosedError: The cursor has been closed

Last edited by ZoteroCalbrNote; 08-12-2016 at 11:55 AM.
ZoteroCalbrNote is offline   Reply With Quote