Firmware 4.20.14601 has been released

[geek1011]

Originally Posted by sherman

I wonder why Kobo decided they needed new columns for the series stuff?

Those have been there for a while, they just weren't used for sideloaded stuff. They probably needed it for the "More in this series" button.

[sherman]

Originally Posted by geek1011

Those have been there for a while, they just weren't used for sideloaded stuff. They probably needed it for the "More in this series" button.

Ah, thanks

[kobofan99]

Originally Posted by Uncle Robin

A trivial question perhaps, but how does one play the Word Scramble? I select letters, but see no way to have the selections counted. that count stays at "0" out of however many are listed for that particular grid.

Click again on the last letter of a word. Click a, n, and t, and click again on t and 'ant' will be counted as a word.

[Uncle Robin]

Originally Posted by kobofan99

Click again on the last letter of a word. Click a, n, and t, and click again on t and 'ant' will be counted as a word.

Thanks! Now if only my hands were faster

[rtiangha]

Originally Posted by geek1011

Yes, that should work for now. Just copy the contents of 'Series' to 'SeriesID' for sideloaded books (and remember to exclude the rows used for TOC entries).

Ok, dumb question, but for TOC entries, isn't the Series data set to NULL anyways? So copying it over to SeriesID should still be NULL and be fine, right? Although I only really spot checked and didn't check every TOC entry but the ones I did encounter were NULL.

I was really hoping something like

UPDATE content SET SeriesID = Series;

would work.

Although I was playing around (haven't actually deployed it yet) and it seemed to set SeriesNumberFloat to 0.0 for all non-NULL entries at the same time. Not sure if that's a quirk of the program I'm using (DB Browser for SQLite) or if that's what's supposed to happen. Should I be copying over SeriesNumber to that column too?

[Quoth]

Dictionary popup uses scroll bar if the text doesn't fit in the popup.
Footnote popup uses scrollbar for longer notes.

Pagination is better, though on the previous FW, the physical buttons don't page in popups like dictionary, you have to tap/swipe.

[Stevex]

Hi, I‘m wondering what additional benefit Series has over Collection? I was perfectly happy with Collection functionality. At the moment, I‘d rather turn Series off.

[Semwize]

Originally Posted by rtiangha

I was really hoping something like

Immediately after installing 4.20, I applied this query and it worked fine for me. All series have appeared.

[davidfor]

Originally Posted by Stevex

Hi, I‘m wondering what additional benefit Series has over Collection? I was perfectly happy with Collection functionality. At the moment, I‘d rather turn Series off.

If you were creating collections for series and nothing else, there probably isn't any advantage. And if you were only creating collections for some other reason (TBR list, genre etc), again there probably isn't any advantage. But, if you were creating collections for both reasons, you will no longer have the series collection mixed up with the non-series collections. To me, that is a good thing. But, if you don't like it, just ignore the tab.

[Carmelocotonto]

Originally Posted by rtiangha

OK, quick question about the database changes for compatibility with the new Series tab.

I sideload everything (even the stuff I buy from Kobo; drm removed, of course) so no need for me to generate a UUID or anything like that, but for various reasons, it'd be easier and faster for me just to copy the database file off my Kobo and run the SQL directly on my computer and then copy it back rather than do it through usb (2.35 GB file, 13,000 books (blame gutenberg), etc, plus I want to compact the database after and that definitely is faster if I do it locally).

I haven't installed the new firmware yet so I can't inspect the database to see what changed, but am I correct to assume that it'd be just as simple as copying over all of the data from the 'Series' column to whatever the new column is (looking at geek1011's seriesmeta commit, is it called SeriesID?) and that's it, or is there more to it than that (sorry if the question sounds dumb; I'm weak in sql)?

Hi rtiangha, can you tell me how compacting the database?. This may not be a necessary action, but my database has >100mb. Is it too big or is it normal?
Thanks

[Calenorn]

Finally. I truly have the heart of a champion!

[davidfor]

Originally Posted by Carmelocotonto

Hi rtiangha, can you tell me how compacting the database?. This may not be a necessary action, but my database has >100mb. Is it too big or is it normal?

You can use any SQLite database management tool to do this. And if you are a calibre user, my Kobo Utilities plugin can do it. But, if your database is only around 100MB in size, it probably won't reclaim much space, or help with performance.

[rtiangha]

Originally Posted by Carmelocotonto

Hi rtiangha, can you tell me how compacting the database?. This may not be a necessary action, but my database has >100mb. Is it too big or is it normal?
Thanks

As davidfor says, any SQLite management program can do it (the tool may call the function by different names; compact, optimize, or vacuum are the common ones). If you're using the tool I linked to, you would open up the database then click on Tools->Compact Database.

However, you have a small database and if you're a Calibre user, you may as well use David's Kobo Utilities plugin to do it instead.

[mathil]

I just updated. Everything good so far (haven't really had a chance to actually read yet, just messed around a bit).

Honestly, the new series tab is nice but the thing I'm most excited about is how fast moving between tabs has become. I have a big library (2800 books more or less on my Libra) organized in about 550+ collections and whenever I had to go to the Authors or Collections tab I ended up waiting at least 20 seconds if not more for everything to load - it's gone down to a couple of seconds now. Really happy about this.

[Sirtel]

As the line-spacing patch is not working with the new update, I'm going to skip for now. Not particularly interested in the new series tab or other stuff in this update anyway. I'll probably update if the devs get the line-patch to work (very grateful for all their efforts).