MobileRead Forums - Firmware 4.20.14601 has been released

Page 3 of 10

Last »

Show 40 post(s) from this thread on one page

MobileRead Forums (https://www.mobileread.com/forums/index.php)

- Kobo Reader (https://www.mobileread.com/forums/forumdisplay.php?f=223)

- - Firmware 4.20.14601 has been released (https://www.mobileread.com/forums/showthread.php?t=327778)

geek1011

03-03-2020 01:58 AM

Quote:

Originally Posted by sherman (Post 3959824)

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

03-03-2020 02:10 AM

Quote:

Originally Posted by geek1011 (Post 3959825)

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

03-03-2020 03:04 AM

Quote:

Originally Posted by Uncle Robin (Post 3959794)

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

03-03-2020 03:40 AM

Quote:

Originally Posted by kobofan99 (Post 3959840)

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

03-03-2020 05:41 AM

Quote:

Originally Posted by geek1011 (Post 3959818)

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

Code:

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

03-03-2020 06:07 AM

Quote:

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

03-03-2020 06:12 AM

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

03-03-2020 06:46 AM

Quote:

Originally Posted by rtiangha (Post 3959876)

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

03-03-2020 06:53 AM

Quote:

Originally Posted by Stevex (Post 3959879)

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

03-03-2020 08:34 AM

Quote:

Originally Posted by rtiangha (Post 3959816)

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

03-03-2020 08:36 AM

Finally. I truly have the heart of a champion!

davidfor

03-03-2020 09:06 AM

Quote:

Originally Posted by Carmelocotonto (Post 3959913)

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

03-03-2020 09:39 AM

Quote:

Originally Posted by Carmelocotonto (Post 3959913)

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

03-03-2020 12:51 PM

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

03-03-2020 01:51 PM

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).

All times are GMT -4. The time now is 04:56 PM.

Page 3 of 10

Last »

Show 40 post(s) from this thread on one page