Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Plugins

Notices

Reply
 
Thread Tools Search this Thread
Old 07-16-2016, 12:49 PM   #61
petzi
Connoisseur
petzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavens
 
petzi's Avatar
 
Posts: 69
Karma: 13884
Join Date: Dec 2009
Location: Austria
Device: PW2, KOA, iPad3, iPhone 6+
Question Import of meta-data with no attached files?

Why is ZMI restricting the import to records with attached files? I started with Zotoro many years ago. But with Calibre I have just a short history. Therefore I have many entries in Zotero for citation purposes, but the UI of Calibre is much nicer and more powerful. I started to use Calibre as a database not only for e-books but for organizing and managing my physical books as well.

So why not import meta-data from Zotero (at least) for "book"-items with no attached files to Calibre as well?
petzi is offline   Reply With Quote
Advert
Old 07-16-2016, 01:44 PM   #62
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,103
Karma: 100494
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Quote:
Originally Posted by petzi View Post
Why is ZMI restricting the import to records with attached files? I started with Zotoro many years ago. But with Calibre I have just a short history. Therefore I have many entries in Zotero for citation purposes, but the UI of Calibre is much nicer and more powerful. I started to use Calibre as a database not only for e-books but for organizing and managing my physical books as well.

So why not import meta-data from Zotero (at least) for "book"-items with no attached files to Calibre as well?

@petzi:

Please clarify by answering the following questions for me:

[1] Are you saying that you have Zotero metadata that should be with existing Calibre books, but there is nothing in Zotero that points at all to the Calibre books? And vice-versa?

[2] If the answer to [1] is "yes" and "yes", then how would ZMI know where to find the Zotero metadata for a Calibre book that does not exist in Zotero as a file attachment? By you manually relating them to each other?

[3] If I gave you a "magic wand" that allows you to instantly copy Zotero metadata from any single item in Zotero to any single book in Calibre by simply selecting the Calibre book and then selecting the Zotero item, would that work?

[4] If the answer to [3] is "no", what would you propose instead?

[5] If the answer to [3] is "yes", is it practical to do that 1-by-1? If not, how can it be automated (but see [2], above)?

[6] Another alternative: If I created an "empty book" in Calibre (i.e., pure metadata with no physical formats at all) for each CSV item that had no file attachments, would that be useful? Could you add some Calibre metadata to relate them to the non-empty Calibre books that you already have?

[7] If the answer to [6] is "yes, that works for me", then what Zotero item types should be used to create Calibre "empty books"? A list of the standard item types is shown below for your reference.

Spoiler:
artwork attachment audioRecording bill blogPost book bookSection case computerProgram conferencePaper dictionaryEntry document email encyclopediaArticle film forumPost hearing instantMessage interview journalArticle letter magazineArticle manuscript map newspaperArticle note patent podcast presentation radioBroadcast report statute thesis tvBroadcast videoRecording webpage


[8] Same as for [7], but instead of item types, should some other Zotero column be used? Or in combination with other columns? How would ZMI know what to ignore? It currently ignores all file attachments that have an extension of .html, .htm, etc. Should it not ignore those just for your scenario? Should it import those too? Other ZMI users have said they do not want those files imported into Calibre since they are not "books". Should I make it a user option to import or ignore them?

[9] Could you attach a CSV file exported from Zotero that has a very large assortment of the types of items that you were describing in your question? I need to see it for myself.



DaltonST
DaltonST is offline   Reply With Quote
Old 07-17-2016, 06:35 AM   #63
petzi
Connoisseur
petzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavens
 
petzi's Avatar
 
Posts: 69
Karma: 13884
Join Date: Dec 2009
Location: Austria
Device: PW2, KOA, iPad3, iPhone 6+
I am not sure if I can answer all your questions satisfactory. Maybe the best would be a more detailed explanation what I was asking for and then come back to your questions:

In Zotero I have many records without files attached. Most of the time these records are of Zotero type "book" or "bookSection". So these two types are the most important types for me out of the list you suggested. That would a nice start to begin with.

What I want is to import the Zotero metadata for these records into Calibre as it is done with the records which do have files attached. The records of all different Zotero types are downloaded into the export .csv file but only those which have a .pdf (or other file type?) attached are incorporated into the import procedure. Would I have metadata even for empty books in my Calibre database I can work with them in Calibre after they are imported from Zotero (add more metadata, organize them according to my Calibre system or exchange data with Goodreads).

Hopefully it is now better understandable was I want. Now to your questions:

[1] and [2]: No, this was not was I meant. (As fas as I understood the questions…)
[3],[4],[5]: Again this is not what I asked for. This could be helpful later on, when the Calibre database is already populated and some changes were made (either in Zotero or in Calibre).
[6]: YES!
[7]: As I said: For me the most important types would be "book" and "bookSection". Maybe it would make sense also for "conferencePaper", "journalArticle", "magazineArticle", "newspaperArticle", "report" and especially "thesis". As far as I am concerned: I think I do not want a duplicate of the Zotero database in Calibre. I just want Calibre my primary source for management of books (and parts of books) and Zotero for my citations. (But see my correction later on, when I inspected some concrete examples of the exported .csv file.)

But I haven't thought through the possibility to have all Zotero types included into Calibre. This would open up the management for all types of reference material in Calibre. I am lacking experience with Calibre if this would be a good idea and if Calibre is suited for this task. Clear enough it would add some new use cases to Calibre for which it was originally not build for.

[8]: This boils down to the thoughts above: Should Calibre be used for the managements of material besides books? (But it turned out in a detailed inspection that some of my .html files link to webpages where the articles could be downloaded. See my final paragraph.)

I will add the same .csv-file we have already used for finding my import problem. But I have generated this file new from scratch today.

BTW: I noticed that ZMI is taking all my files from the CSV Import Directory but does not archive them after processing in the CSV Archive Directory.

*****
Some exemplary notes to the attached file:
  • An example of a book record which is not imported is Weinert, Franz (Line 33 with the headline of column names included). It is a book but has no file attached.
  • Number 12: Anderson Terry and Dron Jon is a Journal Article which has a HTML Reference to a website (http://www.irrodl.org/index.php/irrodl/article/view/890) where the file could be downloaded. Even EPUB-Format is provided. After my discussion above I would not have included this record, but actually it turns out it would be nice to include it!
  • Number 13: This record has a .html file attached refering to chapter one of google book: https://books.google.at/books?id=Rif...page&q&f=false. So again this would be a valuable information which could be used for further processing inside Calibre.

So after a more detailed inspection it turned out that "Yes, it would make sense to import all detailed information into Calibre". Maybe the best way would be to give the user a selection what Zotero types metadata should be imported into Calibre?
Attached Files
File Type: txt export-2016-07-17.csv.txt (88.9 KB, 88 views)
petzi is offline   Reply With Quote
Old 07-17-2016, 06:57 AM   #64
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,103
Karma: 100494
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Excellent. Just what I needed for now. Thanks.
DaltonST is offline   Reply With Quote
Old 07-18-2016, 08:22 AM   #65
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,103
Karma: 100494
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Version 1.0.28 - 2016-07-18 Major enhancements

Version 1.0.28 - 2016-07-18 Major enhancements.
  • New Identifier: zkey_file. Since Zotero items may have many file attachments, this new identifier will uniquely identify each Calibre book created from each of those many file attachments, although all of those books will have the identical Zotero zkey since they belong to the same Zotero item.
  • New user option to import .txt, .text, .html and .htm file attachments as Calibre "books", although Calibre will automatically convert the html files into .zip formatted books. Those must then be converted from .zip to .epub to be readable in an e-reader. In Calibre: Preferences > Conversion. To execute a conversion, simply select all of the .zip formats using the Tag Browser, right click them, and select Convert Books > Bulk Convert. Formats of .txt and .text need no conversion.
  • New user option to import Zotero items that have no file attachments. ZMI will create an empty .txt book for those items. You can edit that .txt book, of course. Otherwise, the metadata will be just as for normal Zotero items that have a file attachment.

DaltonST


p.s. If you have issues, and post a comment here to express it, please also attach the associated Zotero CSV export file AND a .zip file containing the Zotero collection's entire "data directory". That is the one with the zotero.sqlite database, and the "storage" directory that contains your file attachments. I need your "real" data to use with Zotero and Calibre in order to be able to reproduce and resolve your issues. Thanks.
DaltonST is offline   Reply With Quote
Advert
Old 07-18-2016, 07:06 PM   #66
petzi
Connoisseur
petzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavenspetzi is a rising star in the heavens
 
petzi's Avatar
 
Posts: 69
Karma: 13884
Join Date: Dec 2009
Location: Austria
Device: PW2, KOA, iPad3, iPhone 6+
Thumbs up

WoW!
I wanted to give you some karma but got the answer: "You must spread some Reputation around before giving it to DaltonST again."

As I have no automatic tags from Zotero (I turned this feature off to have full control on my tags) I wanted to copy all my imported ZManual Tags to the Calibre Standards Tags. But the format #zotero_manual_tags:tags did not work as this feature is only for custom columns. So I had to create a custom column as you suggested in the tool tip.

Just a minor think: It would be nice if ZMI could remember place and size of the ZMI window.
petzi is offline   Reply With Quote
Old 07-18-2016, 07:47 PM   #67
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,103
Karma: 100494
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
It does, or did, but I just turned that off yesterday until I finished adding new widgets and moving them around. I will turn that back on soon.
DaltonST is offline   Reply With Quote
Old 07-19-2016, 12:28 PM   #68
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,103
Karma: 100494
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Version 1.0.30 New: User options to copy Zotero tags to Tags

Version 1.0.30 - 2016-07-19 New: User options to copy Zotero automatic and/or manual tags to Calibre Tags.


DaltonST


p.s. As of version 1.0.27, there were ~250 users of ZMI. As of version 1.0.28, ZMI automatically converts 'legacy' pre-1.0.28 ZMI-created books in Calibre to add the new Identifier 'zkey_file' to those preexisting books. That automatic conversion is performed silently for the current Calibre library whenever you start ZMI.

For those ~250 users of ZMI version 1.0.27, if you used more than one (1) Calibre library with ZMI, please be sure to execute ZMI in those libraries in the near future, and not just the last library that you have been using with ZMI. I have set the automatic legacy conversion process to self-terminate after 2016-08-15 in order to save the ~1 second or so that it takes per library whether it needs it or not. Each library with which you have used ZMI must be automatically converted by then by executing a more recent version of ZMI within that library. Thanks.
DaltonST is offline   Reply With Quote
Old 07-20-2016, 10:45 AM   #69
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,103
Karma: 100494
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Version 1.0.32

Version 1.0.32 - 2016-07-20 Enhancement to the handling of complex .html files having many associated images and javascript files that need to be zipped together prior to adding to Calibre.

The entire directory containing the ".html" file and all of its pieces will be zipped and then imported directly as a .zip file by Calibre. Click "V" for "View" in Calibre to view any book, including a .zip format.


Version 1.0.33 - 2016-07-20 Changed temporary file creation for "empty books" to avoid failures.



DaltonST

Last edited by DaltonST; 07-20-2016 at 01:30 PM. Reason: Version 1.0.33
DaltonST is offline   Reply With Quote
Old 07-28-2016, 03:09 AM   #70
aliabbasjp
Enthusiast
aliabbasjp began at the beginning.
 
Posts: 25
Karma: 10
Join Date: Apr 2012
Device: Kindle DX Graphite
No import of file attachments

For the CVS files it does not import file attachemnts:

"Key","Item Type","Publication Year","Author","Title","Publication Title","ISBN","ISSN","DOI","Url","Abstract Note","Date","Date Added","Date Modified","Access Date","Pages","Num Pages","Issue","Volume","Number Of Volumes","Journal Abbreviation","Short Title","Series","Series Number","Series Text","Series Title","Publisher","Place","Language","Rights","Ty pe","Archive","Archive Location","Library Catalog","Call Number","Extra","Notes","File Attachments","Link Attachments","Manual Tags","Automatic Tags","Editor","Series Editor","Translator","Contributor","Attorney Agent","Book Author","Cast Member","Commenter","Composer","Cosponsor","Counse l","Interviewer","Producer","Recipient","Review ed Author","Scriptwriter","Words By","Guest","Number","Edition","Running Time","Scale","Medium","Artwork Size","Filing Date","Application Number","Assignee","Issuing Authority","Country","Meeting Name","Conference Name","Court","References","Reporter","Legal Status","Priority Numbers","Programming Language","Version","System","Code","Code Number","Section","Session","Committee","History", "Legislative Body"
"JB24V5QK","journalArticle","2000","Pfeifer, Phillip E.; Carraway, Robert L.","Modeling customer relationships as Markov chains","Journal of interactive marketing","","","","http://search.proquest.com/openview/c9190516daad6e079e538d40546fd4f9/1?pq-origsite=gscholar","","2000","2016-05-13 13:14:15","2016-05-13 13:14:15","2016-05-13 13:14:15","43","","2","14","","","","","","","","" ,"","","","","","","Google Scholar","","","","D:\zoterolib\storage\KTJDJ2K6\0 B1o_Kp1njJF0d2theVVwSDI4QlU.pdf","","","","","","" ,"","","","","","","","","","","","","","","",""," ","","","","","","","","","","","","","","","","", "","","","","","","","","",""
"JPEUSBKS","journalArticle","2004","Ching, Wai-Ki; Ng, Michael K.; So, Meko","Customer migration, campaign budgeting, revenue estimation: the elasticity of Markov Decision Process on customer lifetime value","Advanced Modeling and Optimization","","","","http://core.ac.uk/download/pdf/22997.pdf","","2004","2016-05-13 13:14:26","2016-05-13 13:14:26","2016-05-13 13:14:26","65–80","","2","6","","","Customer migration, campaign budgeting, revenue estimation","","","","","","","","","","","","Goog le Scholar","","","","D:\zoterolib\storage\SC7TT3GI\0 B1o_Kp1njJF0WEgtbGhYX05Bd20teVdVdnFOYmVnX250ZXNR.p df","","","","","","","","","","","","","","",""," ","","","","","","","","","","","","","","","","", "","","","","","","","","","","","","","",""," ",""
aliabbasjp is offline   Reply With Quote
Old 07-28-2016, 05:56 AM   #71
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,103
Karma: 100494
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
You need to provide more information that shows exactly what you were doing and what your options were.

Attach the original .csv file zipped. Also include in that same zip pictures of the first 2 ZMI tabs immediately after you tried to import the .csv.

Also please clarify what it did and did not do. Exactly.

Have you imported other .csv files? Ever?

What OS?

What version of ZMI?

What version of Calibre?
DaltonST is offline   Reply With Quote
Old 08-12-2016, 06:37 AM   #72
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,103
Karma: 100494
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Version 1.0.34 Implemented the new Calibre 2.64 Custom Column 'comments' plain text

Version 1.0.34 - 2016-08-12 Implemented the new features of Calibre 2.64 Custom Columns datatype of 'comments'. Zotero Custom Columns have been changed to always be 'long-text' with the heading on the 'side' of the book detail pane.


Calibre version 2.64 is now the minimum version of Calibre that may be used with ZMI. You must upgrade Calibre to 2.64 prior to upgrading ZMI to release 1.0.34.




DaltonST
DaltonST is offline   Reply With Quote
Old 08-12-2016, 10:58 AM   #73
ZoteroCalbrNote
Member
ZoteroCalbrNote began at the beginning.
 
Posts: 10
Karma: 10
Join Date: Aug 2016
Device: pc, ipad, kobo, kindle, iphone, android
Thank you very much for making this extension.

Questions:
  1. Do the book files (pdf, epub, etc) need to be in the native Zotero file directories in order to be imported by ZMI correctly?
  2. Does it matter if the file locations are set to "relative" or "absolute" in the Zotero preferences?
  3. Are there any ZotFile settings that will cause ZMI to fail to import files?
My problem is:
  • ZMI doesn't import the actual book files despite the ZFileAttachments tag having the correct location of the file. ZMI correctly imports all metadata when I enable the "create empty book" option. I've checked the CSV file itself using Microsoft Excel (comma delimited) and made sure each entry has a single attachment and that none of the entries have been altered or have special characters other than periods and underscores.

This is the ZFileAttachments for one of the entries as copied out of Calibre:

Quote:
C:/Users/[my name removed]/AppData/Roaming/Zotero/Zotero/Profiles/1ecwize6.default/zotero/storage/3W5AGUKQ/sanders_2003_from_transactional_to_transcendental. pdf
Here is the error I get at the conclusion of import:
Quote:

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: Favourites Menu (1, 0, 4) && Extract ISBN (1, 4, 4) && Zotero Metadata Importer (1, 0, 34) && EpubSplit (2, 1, 2) && Find Duplicates (1, 6, 2) && 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:08 AM.
ZoteroCalbrNote is offline   Reply With Quote
Old 08-12-2016, 11:08 AM   #74
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,103
Karma: 100494
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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
DaltonST is offline   Reply With Quote
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
Reply

Tags
ris, zotero

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] KindleUnpack - The Plugin DiapDealer Plugins 412 04-24-2018 06:07 PM
[GUI Plugin] Consolidate All Library Metadata (CALM) DaltonST Plugins 188 06-09-2017 11:20 AM
[GUI Plugin] OPML Importer (RSS feeds from feedly/google reader) fem Plugins 14 07-19-2014 10:41 AM
Getting custom metadata field in GUI plugin SauliusP. Development 7 02-11-2012 01:31 AM
[GUI Plugin] Plugin Updater **Deprecated** kiwidude Plugins 159 06-19-2011 12:27 PM


All times are GMT -4. The time now is 09:52 PM.


MobileRead.com is a privately owned, operated and funded community.