Templates: various questions not worth their own thread

[ownedbycats]

format_date and partial dates

I'm using this template to display a list of dates formatted as 'yyyy-MM-dd' as 'MMM d yyyy':

program:

	new_dates = '';

	for dates in '#datesread':
		converted = format_date(dates, 'MMM d yyyy');
		new_dates = list_union(new_dates, converted, ',')
	rof

However, several entries are just a year; e.g. '2017, 2023-06-13.' When I run them through this template, it ends up filling in the rest of the date so it becomes 2017-03-15.

What should I do here to get '2017, Jun 13 2023'? Alternately, I'd be fine removing the partial dates.

[chaley]

Originally Posted by ownedbycats

format_date and partial dates

I'm using this template to display a list of dates formatted as 'yyyy-MM-dd' as 'MMM d yyyy':

program:

	new_dates = '';

	for dates in '#datesread':
		converted = format_date(dates, 'MMM d yyyy');
		new_dates = list_union(new_dates, converted, ',')
	rof

However, several entries are just a year; e.g. '2017, 2023-06-13.' When I run them through this template, it ends up filling in the rest of the date so it becomes 2017-03-15.

What should I do here to get '2017, Jun 13 2023'? Alternately, I'd be fine removing the partial dates.

The format_date() function expects a date. A year by itself isn't a date, so calibre's parse_date() makes it into one by using the 15th day of the current month. This isn't going to change.

You don't say if you can have a date like '2020-05'. Assuming you can, a variation of this template might give you what you want.

program:

	new_dates = '';

	for dates in '2020, 2021-05, 2022-03-10':
		if list_count(dates,'-') ==# 3 then
			converted = format_date(dates, 'MMM d yyyy')
		elif '-' in dates then
			converted = re(format_date(dates, 'MMM d yyyy'), ' 15 ', ' ')
		else
			converted = dates
		fi;
		new_dates = list_union(new_dates, converted, ',')
	rof

It gives the answer

Mar 10 2022, May 2021, 2020

[ownedbycats]

I have only yyyy and yyyy-mm-dd, but that template worked on all the books I tested.

I didn't think of using a list_count with a - separator.

[dunhill]

A template has stopped working.
I was using the formula from this thread https://www.mobileread.com/forums/sh...&postcount=574

python:
def evaluate(book, context):
	vals = context.funcs.book_values('#ranking', 'title:true', '&', 0).split('&')
	vals = sorted([float(v) for v in vals], reverse=True)
	return str(1 + vals.index(float(book.get('#ranking'))))

to calculate the ranking position and now it says that there is an error on line 4
Give me a hand with the solution

[chaley]

Originally Posted by dunhill

A template has stopped working.
I was using the formula from this thread https://www.mobileread.com/forums/sh...&postcount=574

python:
def evaluate(book, context):
	vals = context.funcs.book_values('#ranking', 'title:true', '&', 0).split('&')
	vals = sorted([float(v) for v in vals], reverse=True)
	return str(1 + vals.index(float(book.get('#ranking'))))

to calculate the ranking position and now it says that there is an error on line 4
Give me a hand with the solution

It would be helpful if you provided the actual error message.

Edit: an error will be thrown if #ranking contains something that isn't a number

[dunhill]

Originally Posted by chaley

It would be helpful if you provided the actual error message.

Edit: an error will be thrown if #ranking contains something that isn't a number

I leave you screenshots
The personal column #grecuento
and the template

[chaley]

Originally Posted by dunhill

I leave you screenshots
The personal column #grecuento
and the template

Again, the actual error message is needed.

Note that line 4 will fail of the composite template returns something that isn't a number, for example the empty string.

[claracurie]

Hi, everyone!

I'm a total noob but I want to make a template for a composite column that takes the number of Goodreads' votes in the #grvotes column and adds 'thousand separators' to them, so that, for example, instead of 1678234 it shows 1,678,234.

I've been trying this

{#grvotes:format_number({0:#,##})}

But instead adds a decimal point and a trailing zero like this: 1678234,0

Could you help me?

[dunhill]

Originally Posted by chaley

Again, the actual error message is needed.

Note that line 4 will fail of the composite template returns something that isn't a number, for example the empty string.

If we see the capture of grvotes ids it says 410
The real error is described in the first image:
Exception:Error in function <listcomp> on line 4: ValueError could not convert string to float: "

The strange thing is that it used to work fine.



I really don't know what happened but it was solved by redownloading or updating metadata, I was really worried. As always, I appreciate the help always received.

[chaley]

Originally Posted by dunhill

If we see the capture of grvotes ids it says 410
The real error is described in the first image:
Exception:Error in function <listcomp> on line 4: ValueError could not convert string to float: "

The strange thing is that it used to work fine.



I really don't know what happened but it was solved by redownloading or updating metadata, I was really worried. As always, I appreciate the help always received.

Sorry that I didn't see the error. It says that the votes for the book was the empty string, which can't be converted to a float. Is an empty or missing grvotes id something that shouldn't happen? It seems to me that it will always happen for new books. Updating metadata would fix that. The template can be changed to detect a missing id and do something else.

And you are welcome.

[dunhill]

Originally Posted by chaley

Sorry that I didn't see the error. It says that the votes for the book was the empty string, which can't be converted to a float. Is an empty or missing grvotes id something that shouldn't happen? It seems to me that it will always happen for new books. Updating metadata would fix that. The template can be changed to detect a missing id and do something else.

And you are welcome.

You say that a type of alert could be added to the form in case of data not found?
I appreciate your offer, but I wouldn't want to waste your time.
When uploading a new book to my personal library of almost 500 books.
I usually load everything that depends on a template.
The error may have been that I accidentally deleted a value, leaving it at zero or without data.

[vyrmin]

Hi, sorry if this is the wrong place to post, I've searched in the forum for a bit and couldn't find something regarding this specific problem I have.

Whenever I open the get books section and search for books using a keyword, I get a lot of pop-ups displaying the following error message:

calibre, version 6.13.0
ERROR: Unhandled exception: <b>TypeError</b>:expected string or bytes-like object, got 'NoneType'

calibre 6.13  embedded-python: False
Linux-6.1.0-20-amd64-x86_64-with-glibc2.36 Linux ('64bit', 'ELF')
('Linux', '6.1.0-20-amd64', '#1 SMP PREEMPT_DYNAMIC Debian 6.1.85-1 (2024-04-11)')
Python 3.11.2
Interface language: None
Traceback (most recent call last):
  File "/usr/lib/calibre/calibre/gui2/store/search/search.py", line 387, in get_results
    self.results_view.model().add_result(res, store_plugin)
  File "/usr/lib/calibre/calibre/gui2/store/search/models.py", line 97, in add_result
    self._filter_results()
  File "/usr/lib/calibre/calibre/gui2/store/search/models.py", line 119, in _filter_results
    self.sort(self.sort_col, self.sort_order, False)
  File "/usr/lib/calibre/calibre/gui2/store/search/models.py", line 291, in sort
    self.all_matches.sort(
  File "/usr/lib/calibre/calibre/gui2/store/search/models.py", line 292, in <lambda>
    key=lambda x: sort_key(str(self.data_as_text(x, col))),
                               ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/calibre/calibre/gui2/store/search/models.py", line 263, in data_as_text
    text = comparable_price(result.price)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/calibre/calibre/gui2/store/search/models.py", line 24, in comparable_price
    match = re.search(r'(?:\d|[,.](?=\d))(?:\d*(?:[,.\' ](?=\d))?)+', text)
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.11/re/__init__.py", line 176, in search
    return _compile(pattern, flags).search(string)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
TypeError: expected string or bytes-like object, got 'NoneType'

This does not occur when I only select archive.org and feedbooks as a source, so maybe it has a problem with certain stores only? I could do a binary search to find the broken stores, but maybe I'm just missing dependencies? Obviously, there is a problem with python, but it also refers to patterns and what I assume to be search syntax.

Thanks a lot in advance and please remove this post in case it is a duplicate or in the wrong place.

[kovidgoyal]

You are using a distro package uninstall and install the official calibre binaries and you should be fine.

[vyrmin]

Originally Posted by kovidgoyal

You are using a distro package uninstall and install the official calibre binaries and you should be fine.

Thanks a lot, it worked

[ownedbycats]

For an Action Chains copy-to-clipboard, how do I insert a line break into a strcat?