Aura HD Sort by Genre?

[Tan]

Any chance of sorting my Kobo into Genres? I do have a custom metadata column called "Genre" just need to know how. Step by step please, newbie here. Thanks.

Also I have a lot of books, any chance of also sorting in sub-folders eg, books grouped together by a genre and then each book separately in a list by author?

[davidfor]

See https://www.mobileread.com/forums/showthread.php?p=193184. You can use any column for a shelf. Just add your "Genre" column to the what you are already using. Or replace them all if you want.

[Tan]

I don't get it. In customise plugin I have under create tags for auto management #shelves,series. I added #genre to it and nothing happened when I unplugged the kobo and looked under my collections

[davidfor]

The collection management is done as part of the jobs calibre runs when you it sees a device. It should add these collections the net time you connect the device.

[Tan]

I have plugged/unplugged kobo several times and I cant see "Genres" under Collections. Should I remove the # before the word genre in customise plugin so it just reads "#shelves,series,genre?

[davidfor]

Originally Posted by Tan

I have plugged/unplugged kobo several times and I cant see "Genres" under Collections. Should I remove the # before the word genre in customise plugin so it just reads "#shelves,series,genre?

"genre" is almost definitely a custom column. You will need to refer to it as "#genre" in the field and any where else you use it. If you aren't completely sure what to use for a column, put the cursor over the column heading in the book list. The tooltip will show the lookup name in quotes. You need to use exactly what is inside the quotes.

[Tan]

ok, thanks David...will re-try and see if it appears in Collections after I unplug the Kobo the 2nd time.

[Tan]

I cannot see "genre" (as in Drama, Fantasy etc....) in My Collections on the Kobo. I have done the above twice and it is not appearing on the Kobo, I must be missing something...any ideas?

[davidfor]

If you have configured it as above, it should be working. I'd need to look at a debug log to see what is wrong. To do this:

- Right click on the preferences button and select "Restart in debug mode".
- Calibre will close and reopen displaying a message about debug mode and the log.
- Connect the Aura HD.
- Calibre will run the connect jobs. When they are finished, close calibre.
- The debug log will be displayed.

Post all of the debug log. I should be able to see what is happening from that.

[Tan]

calibre Debug log
calibre 1.37 isfrozen: True is64bit: False
Windows-7-6.1.7601-SP1 Windows ('32bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.5
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Starting up...
DEBUG: 0.0 KoboUtilites::action.py - loading translations
DEBUG: 0.0 KoboUtilites::dialogs.py - loading translations
DEBUG: 0.0 KoboUtilites::action.py - loading translations
DEBUG: 0.8 No Kobo Touch, Glo or Mini appears to be connected
DEBUG: 0.8 rebuild_menus - self.supports_ratings=False
Job: 1 Get device information started
DeviceJob: 1 Get device information done, calling callback
DeviceJob: 1 Get device information callback returned
Job: 2 Get list of books on device started
DEBUG: 0.0 KoboTouch:books - oncard='None'
DEBUG: 0.0 KoboTouch:books - oncard='None', prefix='G:\'
DEBUG: 0.0 Kobo device: Kobo Aura HD
DEBUG: 0.0 Version of driver: (2, 1, 7) Has kepubs: True
DEBUG: 0.0 Version of firmware: (3, 2, 0) Has kepubs: True
DEBUG: 0.0 Firmware supports cover image tree: True
DEBUG: 0.0 KoboTouch:books - opts.extra_customization= [u'#shelves, Series', True, True, False, False, False, False, False, False, True, False, False, u'']
DEBUG: 0.0 KoboTouch:books - prefs['manage_device_metadata']= on_connect
DEBUG: 0.0 KoboTouch:books - set_debugging_title to ''
DEBUG: 0.0 KoboTouch:books - length bl=0
DEBUG: 0.1 KoboTouch:books - length bl after sync=8
DEBUG: 0.1 KoboTouch:books - reading device database
DEBUG: 0.2 Database Version=96
DEBUG: 0.2 KoboTouch:books - shelf list: [u'Delia']
DEBUG: 0.2 KoboTouch:books - query= SELECT Title, Attribution, DateCreated, ContentID, MimeType, ContentType, ImageID, ReadStatus, ___ExpirationStatus, FavouritesIndex, Accessibility, IsDownloaded, Series, SeriesNumber, ___UserID, ExternalId FROM content where BookID is Null and ((Accessibility = -1 and IsDownloaded in ('true', 1 )) or (Accessibility in (1,2) and IsDownloaded in ('true', 1)) ) and not ((___ExpirationStatus=3 or ___ExpirationStatus is Null) and ContentType = 6) AND (externalId IS NULL OR externalId = '') AND contentId NOT LIKE 'file:///mnt/sd/%'
DEBUG: 0.3 KoboTouch:books - looping on database - row=9
DEBUG: 0.3 KoboTouch:books - title='' authors= Kobo Inc.
DEBUG: 0.3 KoboTouch:books - row= (u'', u'Kobo Inc.', None, u'file:///usr/local/Kobo/help/10UserGuide-Legal.kepub.epub', u'application/x-kobo-epub+zip', u'6', None, 0, 0, -1, 1, 1, None, None, u'', None)
DEBUG: 0.3 KoboTouch:books - looping on database - row=10
DEBUG: 0.3 KoboTouch:books - title='' authors= Kobo Inc.
DEBUG: 0.3 KoboTouch:books - row= (u'', u'Kobo Inc.', None, u'file:///usr/local/Kobo/help/09UserGuide-Contacting_FNAC.kepub.epub', u'application/x-kobo-epub+zip', u'6', None, 0, 0, -1, 1, 1, None, None, u'', None)
Job: 1 Get device information finished
No details available.
DEBUG: 0.6 KoboTouch:books - automatically managing metadata
DEBUG: 0.6 KoboTouch:books - about to sync_booklists
DEBUG: 0.6 USBMS: starting sync_booklists
DEBUG: 0.8 USBMS: finished sync_booklists
DEBUG: 0.8 KoboTouch:books - have done sync_booklists
DEBUG: 0.8 KoboTouch:books - end - oncard='None'
DEBUG: 0.8 KoboTouch:books - oncard='carda'
DEBUG: 0.8 KoboTouch:books - Asked to process 'carda', but do not have one!
DEBUG: 0.8 KoboTouch:books - oncard='cardb'
DEBUG: 0.8 KoboTouch:books - Asked to process 'cardb', but do not have one!
DeviceJob: 2 Get list of books on device done, calling callback
DeviceJob: metadata_downloaded: Starting set_books_in_library
DeviceJob: set_books_in_library: books to process= 8
DeviceJob: set_books_in_library finished: time= 0.00499987602234
DeviceJob: metadata_downloaded: updating views
DeviceJob: metadata_downloaded: syncing
DeviceJob: metadata_downloaded: refreshing ondevice
DeviceJob: metadata_downloaded: sending metadata_available signal
DEBUG: 55.6 KoboUtilites:_on_device_metadata_available - Metadata available: {'main': {u'device_store_uuid': u'b5cfa5b3-7fce-451d-8f7e-431a8a67371b', u'location_code': 'main', u'device_name': u'Kobo Aura HD', u'calibre_version': u'1.37.0', u'prefix': 'G:/', u'last_library_uuid': u'd7a7eee8-eb0f-4aed-b3d5-a2830ae7ab20', u'date_last_connected': u'2014-05-22T00:46:15.110000+00:00'}}
DEBUG: 55.6 Have a Kobo device connected connected
DEBUG: 55.6 KoboUtilites:_on_device_metadata_available - About to start auto store
DEBUG: 55.6 auto_store_current_bookmark - start
DEBUG: 55.6 Have a Kobo device connected connected
DEBUG: 55.6 BEGIN Get Device Path
DEBUG: 55.6 Root path of device: G:\
DEBUG: 55.6 END Get Device Path
DEBUG: 55.6 QueueProgressDialog::__init__
DEBUG: 55.6 QueueProgressDialog::do_books - Start
DEBUG: 55.6 QueueProgressDialog::do_books - kobo_percentRead_column= #percentread
DEBUG: 55.6 QueueProgressDialog::do_books - search_condition= ondevice:True
Job: 2 Get list of books on device finished
No details available.
DEBUG: 56.1 QueueProgressDialog::do_books - Finish
DEBUG: 56.1 QueueProgressDialog::do_queue
DEBUG: 56.1 KoboUtilitiesAction::_store_queue_job
DEBUG: 56.2 Have a Kobo device connected connected
DEBUG: 56.2 rebuild_menus - self.supports_ratings=True
DeviceJob: 2 Get list of books on device callback returned
Job: 3 Send metadata to device started
DEBUG: 1.7 KOBO:sync_booklists - start
DEBUG: 1.8 KoboTouch:update_device_database_collections - oncard='main'
DEBUG: 1.8 KoboTouch:update_device_database_collections - set_debugging_title to ''
DEBUG: 1.8 KTCollectionsBookList:get_collections - start - collection_attributes= [u'#shelves', u'series']
DEBUG: 1.8 KTCollectionsBookList:get_collections - collection_attributes= [u'#shelves', u'series']
DEBUG: 1.8 KTCollectionsBookList:get_collections - end
DEBUG: 1.8 KoboTouch:update_device_database_collections - category='Delia' books=3
DEBUG: 1.8 KoboTouch:update_device_database_collections - end for category='Delia'
DEBUG: 1.8 KoboTouch:update_device_database_collections - managing bookshelves and series.
DEBUG: 1.9 KoboTouch:update_device_database_collections - about to clear empty bookshelves
DEBUG: 1.9 KoboTouch:delete_empty_bookshelves - start
DEBUG: 1.9 KoboTouch:delete_empty_bookshelves - end
DEBUG: 1.9 KoboTouch:update_device_database_collections - Number of series set=0 Number of books=8
DEBUG: 1.9 KoboTouch:update_device_database_collections - Finished
DEBUG: 1.9 USBMS: starting sync_booklists
DEBUG: 2.0 USBMS: finished sync_booklists
DEBUG: 2.0 KOBO:sync_booklists - end
DeviceJob: 3 Send metadata to device done, calling callback
DeviceJob: 3 Send metadata to device callback returned
Job: 4 Storing reading positions for 8 books started
Job: 2 Get list of books on device finished
No details available.
Job: 3 Send metadata to device finished
No details available.
Worker Launch took: 0.615000009537
Job: 5 Store locations finished
Store locations

DeviceJob: 4 Storing reading positions for 8 books done, calling callback
DeviceJob: 4 Storing reading positions for 8 books DEBUG: 58.1callback returned
KoboUtilitiesAction::_store_completed - options {u'storeBookmarks': True, u'rating': False, u'storeIfMoreRecent': False, u'promptToStore': True, u'setDateToNow': False, u'doNotStoreIfReopened': False, 'supports_ratings': True, u'backgroundJob': True, u'clearIfUnread': False, u'readingStatus': False, 'job_function': 'store_current_bookmark', 'allOnDevice': True, 'device_database_path': u'G:\\.kobo\\KoboReader.sqlite', u'count_selected_books': 0}
Job: 4 Storing reading positions for 8 books finished
No details available.
Started up in 80.59 seconds with 968 books

[davidfor]

Originally Posted by Tan

DEBUG: 0.0 KoboTouch:books - opts.extra_customization= [u'#shelves, Series', True, True, False, False, False, False, False, False, True, False, False, u'']

DEBUG: 1.8 KTCollectionsBookList:get_collections - start - collection_attributes= [u'#shelves', u'series']
DEBUG: 1.8 KTCollectionsBookList:get_collections - collection_attributes= [u'#shelves', u'series']

According to those lines in the log, you are creating collections based on two columns. One is the calibre series column, the other is a custom column called "#shelves". You need to add your genre column to the driver configuration. To do this:

1. Start calibre
2. Connect your Kobo device.
3. Wait for the jobs to finish.
4. Right click on the device button.
5. Select "Configure this device".
6. The field for the collections currently has "#shelves, Series". You need to change this to include the genre column. Based on comments in the other posts, you will need "#shelves, Series,#genre". Or you might want to replace the other column names with just "#genre".
7. Press the OK button to save the changes.
8. Calibre will prompt you to restart. Do this.
9. When calibre restarts, it will see the device and run the jobs which should create the collections.
10. Eject the device and check the genre collections have been created correctly.

If that doesn't work, can connect again and see if creates the collections then. If it still doesn't, then I don't know what is happening, but I would need to see a debug log with the corrected configuration.

[Tan]

Thanks David will try this

[Tan]

I think I am slowly getting the hang of configuring the Kobo.
Is there any chance of say in "My Collections" I am sorting by "Genre" - Fiction, Fantasy, Mystery etc...of within this then sorting by Author, within Author sorting by Series eg: My Collections/Genre/Author/Series (in order)?

Or is it you can only sort by one thing eg Genre OR Series within My Collections?
BTW I emailed Kobo and asked if there would be an update that allows for better sorting eg: adding Genre, Series etc... and they replied- not in the near future. So we have to keep on tweaking plug boards etc to get the devices like Kobo to do what we want them to.

[davidfor]

The only way to sort the collections are in the sort menu of the collection. The series ordering that the utilities plugin is a cheat. I plan to extend this a bit, but it might be a little while before I do.

The only other way to do this is with a plugboard that changes the title or author so that sorting by them does what you want.

[Tan]

Can I use a plugboard to include "Series" and "Series no." in with "title"?
If so How do I do this (in steps please)?
Thanks for your patience, I'm a slow learner.