[GUI Plugin] Import List

[chaley]

Originally Posted by jpkar

Hello everyone,
I use caliber to manage videos!
Now I would like to import the metadata from the videos into "Custom Columns" to be created accordingly with "Import List".
In a first step, I tried to create and import a separate column for the length of the video.
The metadata from the videos are available to me as a csv file.
Example:
"Name","Author","Length"
"Example title","TestAuthor","00:14:16"

Here is the actual question: How must the "Own Column": "length" of the video be formatted so that the Import works?

When trying to import I get the error message:

Column "
The following rows have invalid type for column #länge:
row (1) => 00:14:16

Vielen Dank

Calibre doesn't support duration as a column type. Using integer is the best solution. The input should be formatted as the number of seconds. For example,

00:14:16 ==> 14 minutes + 16 seconds ==> 856 seconds

You can use a column built from other columns to display the number of seconds however you wish. For example, this template displays the number of seconds (I used a constant instead of the correct column lookup name) as hh:mm:ss

program:
	number_of_seconds = 856;
	hours = floor(number_of_seconds/3600);
	minutes = floor((number_of_seconds - (hours * 3600))/60);
	seconds = mod(number_of_seconds, 60);
	format_number(hours, '02d') & ':' & format_number(minutes, '02d') & ':' & format_number(seconds, '02d')

Note that you couldn't edit the value shown in the column built from other columns. You must edit the number_of_seconds column

[BetterRed]

Originally Posted by chaley

Calibre doesn't support duration as a column type.

FWIW: I have duration column in my Media library, which is a Date, viz:



My media items are short news video and audio clips. I key the data into the booklist - not sure if/how that could work with IL.

BR

[chaley]

Originally Posted by BetterRed

FWIW: I have duration column in my Media library, which is a Date, viz:

Attachment 196487

My media items are short news video and audio clips. I key the data into the booklist - not sure if/how that could work with IL.

BR

I thought of that then rejected it as too complicated because it is actually a date column, not a duration. It isn't clear to me how it will work over time, for example for sorting, and whether arithmetic would work. I am sure that one must guarantee that the date portion is always the same date and that the timezone never changes. Possibly 01-01-0101Tmm:dd:ssZ would do.

That said, I am glad it works for you.

[capink]

if @jpkar does not need to use arithmetic for his duration column, he can proceed with the same format (hh:mm:ss) he currently has and it will work well for sorting. He just needs to change the target column datatype to text to avoid the validation error.

[BetterRed]

Originally Posted by chaley

I thought of that then rejected it as too complicated because it is actually a date column, not a duration. It isn't clear to me how it will work over time, for example for sorting, and whether arithmetic would work. I am sure that one must guarantee that the date portion is always the same date and that the timezone never changes. Possibly 01-01-0101Tmm:dd:ssZ would do.

That said, I am glad it works for you.

I've never wanted to sort on it, much less do arithmetic. If I wanted to do something like that I'd create a csv and use Excel. I also use the column as a hook on which to hang an icon.

But wait, I just did a sort on my duration column - perfect.



And then I remembered the sort_dates_using_visible_fields tweak takes care of it. Perhaps there should be a companion tweak zero_non_visible_fields_in_dates.

BR

[jpkar]

Originally Posted by chaley

Calibre doesn't support duration as a column type. Using integer is the best solution. The input should be formatted as the number of seconds. For example,

00:14:16 ==> 14 minutes + 16 seconds ==> 856 seconds

You can use a column built from other columns to display the number of seconds however you wish. For example, this template displays the number of seconds (I used a constant instead of the correct column lookup name) as hh:mm:ss

program:
	number_of_seconds = 856;
	hours = floor(number_of_seconds/3600);
	minutes = floor((number_of_seconds - (hours * 3600))/60);
	seconds = mod(number_of_seconds, 60);
	format_number(hours, '02d') & ':' & format_number(minutes, '02d') & ':' & format_number(seconds, '02d')

Note that you couldn't edit the value shown in the column built from other columns. You must edit the number_of_seconds column

Danke für deinen Vorschlag, habe Ihn wie folgt übernommen!
2 neue Spalten angelegt:
1. Spalte = aus anderen Spalten aufgebaute Spalte = #länge
2. Spalte = Ganzzahlen = #sekunden

Wie gelingt mir der Verweis auf die selbst definierte Spalte:"#sekunden"?

Vielen Dank

[jpkar]

program:
	number_of_seconds = 856;
	hours = floor(number_of_seconds/3600);
	minutes = floor((number_of_seconds - (hours * 3600))/60);
	seconds = mod(number_of_seconds, 60);
	format_number(hours, '02d') & ':' & format_number(minutes, '02d') & ':' & format_number(seconds, '02d')

Danke für den Tipp
Wie gelingt mir ein Verweis auf die Spalte "#sekunden"? siehe Bilder

[chaley]

Originally Posted by jpkar

program:
	number_of_seconds = 856;
	hours = floor(number_of_seconds/3600);
	minutes = floor((number_of_seconds - (hours * 3600))/60);
	seconds = mod(number_of_seconds, 60);
	format_number(hours, '02d') & ':' & format_number(minutes, '02d') & ':' & format_number(seconds, '02d')

Danke für den Tipp
Wie gelingt mir ein Verweis auf die Spalte "#sekunden"? siehe Bilder

Try this:

	number_of_seconds = $#sekunden;
# Alternate 1: number_of_seconds = field('#sekunden');
# Alternate 2: number_of_seconds = raw_field('#sekunden', '');

# Add this line if you want empty duration to display as empty instead of 00:00:00
	if ! number_of_seconds then return '' fi;

[jpkar]

[CODE] number_of_seconds = $#sekunden;

Vielen Dank,
Das war die Lösung

[kiwidude]

Release Notes:
https://github.com/kiwidude68/calibr...rt_list-v1.9.0

[Tharos]

I am not sure if it is a bug in the extension or if I am doing something wrong. I want to import a list of books via a .csv (utf-8). The book titles are structured as follows:
Book v1
book v2
Book v3

In "Books in list:" they are also displayed like this.

However, in "Matches in library" it says:
Book V1
Book V2
Book V3
The small v becomes a big V. These are then of course also imported in this way.

[Rellwood]

Hi!
I am trying to import my GR library list, it has pages and number of ratings. The columns are {0:,d} intengers.

I am getting the following error:
calibre, version 6.19.1
ERROR: Failed:

Traceback (most recent call last):
File "calibre_plugins.import_list.page_persist", line 42, in to_int
ValueError: could not convert string to float: '202,520'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "calibre_plugins.import_list.page_persist", line 150, in do_it
File "calibre_plugins.import_list.page_persist", line 459, in pd_callback
File "calibre_plugins.import_list.page_persist", line 316, in _apply_metadata_updates
File "calibre_plugins.import_list.page_persist", line 369, in _update_mi_for_book
File "calibre_plugins.import_list.page_persist", line 405, in _update_mi_custom_column
File "calibre_plugins.import_list.page_persist", line 44, in to_int
ValueError

Can someone help?

[theducks]

First of all: update calibre. 6.23 is the latest and that fixed some issues

[capink]

Originally Posted by Rellwood

Hi!
I am trying to import my GR library list, it has pages and number of ratings. The columns are {0:,d} intengers.

I am getting the following error:
calibre, version 6.19.1
ERROR: Failed:

Traceback (most recent call last):
File "calibre_plugins.import_list.page_persist", line 42, in to_int
ValueError: could not convert string to float: '202,520'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "calibre_plugins.import_list.page_persist", line 150, in do_it
File "calibre_plugins.import_list.page_persist", line 459, in pd_callback
File "calibre_plugins.import_list.page_persist", line 316, in _apply_metadata_updates
File "calibre_plugins.import_list.page_persist", line 369, in _update_mi_for_book
File "calibre_plugins.import_list.page_persist", line 405, in _update_mi_custom_column
File "calibre_plugins.import_list.page_persist", line 44, in to_int
ValueError

Can someone help?

Python functions to convert strings to numerals (int and float) do not handle numbers with commas. Until kiwidude responds to this and decides whether he wants to make the to_int() function capable of removing these automatically, you should remove the commas yourself from your csv column using a program like excel.

[Rellwood]

Originally Posted by capink

Python functions to convert strings to numerals (int and float) do not handle numbers with commas. Until kiwidude responds to this and decides whether he wants to make the to_int() function capable of removing these automatically, you should remove the commas yourself from your csv column using a program like excel.

Sweet, no problems. Does this mean that Calibre will automatically add the comas though?