[GUI Plugin] Import List - Page 19

Tanjamuse · 10-31-2017, 04:15 PM

Could the plugin be changed to only pick up the books in a VL?

davidfor · 10-31-2017, 09:18 PM

Quote:

Originally Posted by Tanjamuse

Could the plugin be changed to only pick up the books in a VL?

I can't think of a good reason to do that and I think it would be dangerous. What happens when you don't find a book and decide to add a new book? Suddenly you have a duplicate that doesn't display in the VL. Or you modify the metadata of a book outside the VL.

Also, while I do some maintenance of this plugin, that is mainly to make sure it keeps working. I'm only doing so because the original author is absent. I'm not very interested in extending its function. If someone wants to do that, then I am very happy for them to do so.

Tanjamuse · 11-01-2017, 05:13 AM

I just got this error:

Code:

calibre, version 3.6.0
ERROR: Unhandled exception: <b>IndexError</b>:list index out of range

calibre 3.6 [64bit]  embedded-python: True is64bit: True
Windows-7-6.1.7601-SP1 Windows ('64bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.12+
Windows: ('7', '6.1.7601', 'SP1', u'Multiprocessor Free')
Interface language: None
Successfully initialized third party plugins: Job Spy (1, 0, 75) && FanFicFare (2, 15, 0) && User Category (1, 5, 3) && Import List (1, 2, 0) && Edit Columns (0, 0, 1) && Reading List (1, 6, 6) && Count Pages (1, 8, 0) && View Manager (1, 4, 3) && MultiColumnSearch (1, 0, 74) && Find Duplicates (1, 6, 3) && Save Composite Custom Columns (1, 1, 0) && Tanja's Tools (0, 0, 6) && Generate Cover (1, 5, 21)
Traceback (most recent call last):
  File "calibre_plugins.import_list.page_resolve", line 853, in _on_search_matches_select
  File "calibre_plugins.import_list.page_resolve", line 857, in _on_search_matches_double_clicked
IndexError: list index out of range

davidfor · 11-01-2017, 09:08 AM

What were you doing when this happened?

Ricky56 · 11-01-2017, 05:05 PM

I have a csv file with 252 rows exported from another DB and I want to import using Import list.
I made 3 or 4 attempts but there are always wrong input data, so I deleted each time all new items. Now I make again a correction on input and I want to make a new attempt, but the "bottom" next isn't active and I don't understand why. I restart Calibre, but with no result
Sorry for my english

davidfor · 11-01-2017, 08:17 PM

I think you are on the page to set what columns in the CSV are to match with what columns in the library. Did you click the preview button? You have to do this before you can move to the next page of the wizard.

If that isn't were you are, I need a better description. Or maybe a screen shot.

Ricky56 · 11-02-2017, 02:40 AM

Thank for the answer, I'm doing the same actions of the previous 3-4 attempts, I need to re-import again and again because there are blank value in some fields of some records that prevent a right and complete import, but the input set up is always the same and it's OK. I attach also the log af the previous import and I hope that data now is OK.
As you can see from the screenshot "next" is grey and can't click it
I also tried to reinstall the plugin.
I'm going to work so I'll be able to continue this thread this evening

davidfor · 11-02-2017, 07:36 AM

Quote:

Originally Posted by Ricky56

Thank for the answer, I'm doing the same actions of the previous 3-4 attempts, I need to re-import again and again because there are blank value in some fields of some records that prevent a right and complete import, but the input set up is always the same and it's OK. I attach also the log af the previous import and I hope that data now is OK.
As you can see from the screenshot "next" is grey and can't click it
I also tried to reinstall the plugin.
I'm going to work so I'll be able to continue this thread this evening

The error is that one of the fields doesn't have a valid date in it. Are you closing the wizard between attempts? Or have you opened it, tabbed through to check and then gone back to reload the file? If that is what you are doing, then the error is probably causing it. Closing the wizard and starting again should fix this.

Otherwise, I probably need to see the CSV file. Then I can try it and see what happens here.

Ricky56 · 11-02-2017, 03:07 PM

I restart several times the plugin and also Calibre, but I can't see the option "newt" active as yopu can see in the screenshot
I'm sending the csv file, but it seems a problem of the software

theducks · 11-02-2017, 03:19 PM

Quote:

Originally Posted by Ricky56

I restart several times the plugin and also Calibre, but I can't see the option "newt" active as yopu can see in the screenshot
I'm sending the csv file, but it seems a problem of the software

I suspect you Finished Reading column is confusing things
It looks like it is a mish-mash:
T/F, Date (YYYY), Text

That columns destination field MUST be text

Terisa de morgan · 11-02-2017, 03:26 PM

Removed

davidfor · 11-02-2017, 08:17 PM

Quote:

Originally Posted by theducks

I suspect you Finished Reading column is confusing things
It looks like it is a mish-mash:
T/F, Date (YYYY), Text

That columns destination field MUST be text

It will depend on what type of column is used. But, it looks like it should be a date. If it is, then the contents need to be something that can be converted to a date. Some of them will, but a lot of will fail.

The previous error was with the publishing date. I think just the year will work, but I need to test.

@Ricky56: I probably need to know the column types. Can you post an OPF file from one of the book directories in the library. I should be able to recreate the custom columns from that.

Ricky56 · 11-03-2017, 02:48 AM

I attached an opf file and a new versione of the csv file where I put xxx in some columns to be sure that these columns are not a problem. But the next option is always disabled

davidfor · 11-03-2017, 03:02 AM

Quote:

Originally Posted by Ricky56

I attached an opf file and a new versione of the csv file where I put xxx in some columns to be sure that these columns are not a problem. But the next option is always disabled

Thanks, I will have a look at it over the weekend.

But, I am fairly sure it is to do with bad data in one or other of the columns. What you can do to test this is to remove the columns one at a time, press the preview and then see if the next button is enable. When when it does get enabled, then you can look at the data in the last column removed and see what is wrong with it.

Or, do it the other way. Start from title and author and add the columns until next doesn't get enabled after adding a column.

Ricky56 · 11-03-2017, 07:03 PM

Thanks a lot for your suggestion, I tried with a few columns, but it didn't work
I tried with one row and next reappeared!
Then I found an empty row, deleting this row the plugin now works fine. After the correction of other wrong data I have 251 new records loaded in Calibre DB.

11-01-2017, 05:05 PM	#275
Ricky56 Junior Member Posts: 7 Karma: 10 Join Date: Nov 2017 Device: kindle	Unable to click "next" no more I have a csv file with 252 rows exported from another DB and I want to import using Import list. I made 3 or 4 attempts but there are always wrong input data, so I deleted each time all new items. Now I make again a correction on input and I want to make a new attempt, but the "bottom" next isn't active and I don't understand why. I restart Calibre, but with no result Sorry for my english

11-02-2017, 03:26 PM	#281
Terisa de morgan Grand Sorcerer Posts: 6,233 Karma: 11768331 Join Date: Jun 2009 Location: Madrid, Spain Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2	Removed Last edited by Terisa de morgan; 11-02-2017 at 03:27 PM. Reason: Duplicated

11-03-2017, 07:03 PM	#285
Ricky56 Junior Member Posts: 7 Karma: 10 Join Date: Nov 2017 Device: kindle	Finally I succeeded to import my list Thanks a lot for your suggestion, I tried with a few columns, but it didn't work I tried with one row and next reappeared! Then I found an empty row, deleting this row the plugin now works fine. After the correction of other wrong data I have 251 new records loaded in Calibre DB.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[GUI Plugin] Reading List	kiwidude	Plugins	1319	Yesterday 09:27 AM
[GUI Plugin] Manage Sony x50 Reader Book List	kpw	Plugins	170	10-02-2014 08:23 PM
Import List plugin idea thread	kiwidude	Development	45	08-13-2012 06:05 AM
[GUI Plugin] WebOS Kindle-Import	CranstD	Plugins	0	01-24-2012 03:36 PM
[GUI Plugin] Plugin Updater Deprecated	kiwidude	Plugins	159	06-19-2011 12:27 PM

10-31-2017, 04:15 PM	#271
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	Could the plugin be changed to only pick up the books in a VL?

11-01-2017, 09:08 AM	#274
davidfor Grand Sorcerer Posts: 24,907 Karma: 47303748 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	What were you doing when this happened?

11-01-2017, 08:17 PM	#276
davidfor Grand Sorcerer Posts: 24,907 Karma: 47303748 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	I think you are on the page to set what columns in the CSV are to match with what columns in the library. Did you click the preview button? You have to do this before you can move to the next page of the wizard. If that isn't were you are, I need a better description. Or maybe a screen shot.

Advert

Advert