Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre Companion

Notices

Reply
 
Thread Tools Search this Thread
Old 04-19-2018, 12:03 PM   #1
jehrler
Enthusiast
jehrler began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Apr 2018
Device: iphone
"The..." series all sorted together

I tried searching the forum but not getting a hit.

Is there a way when looking at the Series filter in CC to have the series sort by what Calibre calls library order?

So basically the series are sorted ignoring articles like "The"?
jehrler is offline   Reply With Quote
Old 04-19-2018, 04:26 PM   #2
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 11,703
Karma: 6658935
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
The series_sort calibre field isn't a "real" metadata field, so it doesn't exist in normal book metadata.

Calibre passes CC the series_sort information when you connect as a wireless device, but I don't know if the iDevice CC version uses it.

The best way to solve the problem so that it works in all the connection types is to create a custom column "built from other columns" to contain the value that calibre computes. The template should be
Code:
program: series_sort()
You can then sort by that column, add it to the grouping drawer, etc.
chaley is offline   Reply With Quote
Old 04-19-2018, 05:47 PM   #3
jehrler
Enthusiast
jehrler began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Apr 2018
Device: iphone
OK, got my custom column but it is not syncing to CC.

It shows up fine on calibre and my other custom columns show up (they are just yes/no columns), but not this one. I looked in "choose columns for grouping/sorting" but this new Sorted Series one is just not there.

I even deleted CC from my iPhone and re-added but it still doesn't show.
Attached Thumbnails
Click image for larger version

Name:	Screen Shot 2018-04-19 at 4.42.38 PM.png
Views:	184
Size:	249.0 KB
ID:	163564   Click image for larger version

Name:	Screen Shot 2018-04-19 at 4.45.27 PM.png
Views:	185
Size:	344.5 KB
ID:	163565   Click image for larger version

Name:	IMG_5D7D8151A393-1.jpeg
Views:	181
Size:	215.4 KB
ID:	163566  
jehrler is offline   Reply With Quote
Old 04-19-2018, 05:49 PM   #4
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 11,703
Karma: 6658935
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
You must connect as a wireless device for CC to know about the new column.
chaley is offline   Reply With Quote
Old 04-19-2018, 05:51 PM   #5
jehrler
Enthusiast
jehrler began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Apr 2018
Device: iphone
Yup. Been doing that. Quit CC and Calibre and retrying but no joy.

Should I send you a log?
jehrler is offline   Reply With Quote
Old 04-19-2018, 06:02 PM   #6
jehrler
Enthusiast
jehrler began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Apr 2018
Device: iphone
This is the latest connection logs.

Spoiler:
2018-04-19 16:59:04.753 [Default|INFO] --- Starting CalibreCompanion ---
2018-04-19 16:59:04.757 [Default|INFO] CC version 1.3.2, build 165, ccCalibreProtocolVersion 128. iOS 11.4, device iPhone
2018-04-19 16:59:04.799 [Default|INFO] Firebase init with GoogleService-Info
2018-04-19 16:59:04.942 [Default|INFO] Realm instance loaded, schema: 52
2018-04-19 16:59:04.997 [Default|INFO] --- applicationDidBecomeActive ---
2018-04-19 16:59:05.298 [Default|INFO] Log event: V_MainList [:]
2018-04-19 16:59:08.799 [Default|INFO] Log event: A_ConnectWireless ["MobileDataEnabled": false, "WirelessPortPreset": false, "WirelessIpPreset": false, "WirelessAttemptFailure": false]
2018-04-19 16:59:08.803 [Default|INFO] WirelessDevice: begin scanning
2018-04-19 16:59:08.826 [Default|INFO] ServerScan: Broadcasting on port 54982
2018-04-19 16:59:08.828 [Default|INFO] ServerScan: Broadcasting on port 48123
2018-04-19 16:59:08.829 [Default|INFO] ServerScan: Broadcasting on port 39001
2018-04-19 16:59:08.830 [Default|INFO] ServerScan: Broadcasting on port 44044
2018-04-19 16:59:08.832 [Default|INFO] ServerScan: Broadcasting on port 59678
2018-04-19 16:59:08.835 [Default|INFO] Searching Bonjour
2018-04-19 16:59:08.868 [Default|INFO] Received response from 192.168.0.52 via Bonjour
2018-04-19 16:59:12.842 [Default|INFO] WirelessDevice: Found 1 servers
2018-04-19 16:59:12.849 [Default|INFO] WirelessDevice: Connecting to http://192.168.0.52:8517
2018-04-19 16:59:13.069 [Default|INFO] Communicator connected to host 192.168.0.52 on port 8517
2018-04-19 16:59:13.985 [Default|INFO] Received OpCode: getInitialisationInfo
2018-04-19 16:59:13.993 [Default|INFO] GetInitializationInfo: calibre version: 3, 21, 0
2018-04-19 16:59:14.004 [Default|INFO] GetInitializationInfo: sent sync column info to calibre
2018-04-19 16:59:14.034 [Default|INFO] Received OpCode: getDeviceInformation
2018-04-19 16:59:14.053 [Default|INFO] Received OpCode: setCalibreDeviceInfo
2018-04-19 16:59:14.443 [Default|INFO] Received OpCode: freeSpace
2018-04-19 16:59:14.520 [Default|INFO] Received OpCode: setLibraryInfo
2018-04-19 16:59:14.538 [Default|INFO] Received OpCode: getBookCount
2018-04-19 16:59:14.550 [Default|INFO] Realm instance loaded, schema: 52
2018-04-19 16:59:14.614 [Default|INFO] GetBooks: Total books=334, of which are new=0
2018-04-19 16:59:14.615 [Default|INFO] GetBooks: Asking calibre what metadata it needs
2018-04-19 16:59:14.617 [Default|INFO] GetBooks: Syncing newer books
2018-04-19 16:59:14.619 [Default|INFO] GetBooks: Sending metadata 1. PriKey 1, More Than Honor - David Weber & David Drake & S. M. Stirling (205).epub
2018-04-19 16:59:14.654 [Default|INFO] GetBooks: Sending metadata 31. PriKey 31, Shadow of Victory - David Weber (377).epub
2018-04-19 16:59:14.682 [Default|INFO] GetBooks: Sending metadata 61. PriKey 61, Space Between_ An Outlander Novella, The - Diana Gabaldon (406).epub
2018-04-19 16:59:14.712 [Default|INFO] GetBooks: Sending metadata 91. PriKey 91, Lost Stars_ Tarnished Knight, The - Jack Campbell (194).epub
2018-04-19 16:59:14.737 [Default|INFO] GetBooks: Sending metadata 121. PriKey 121, Llana of Gathol - Edgar Rice Burroughs (154).epub
2018-04-19 16:59:14.762 [Default|INFO] GetBooks: Sending metadata 151. PriKey 151, Gibraltar Sun - Michael McCollum (283).epub
2018-04-19 16:59:14.786 [Default|INFO] GetBooks: Sending metadata 181. PriKey 181, Cibola Burn_ Book Four of the Expanse - James S. A. Corey (215).epub
2018-04-19 16:59:14.811 [Default|INFO] GetBooks: Sending metadata 211. PriKey 211, Fifth Season_ The Broken Earth_ Book One, The - N. K. Jemisin (486).epub
2018-04-19 16:59:14.835 [Default|INFO] GetBooks: Sending metadata 241. PriKey 241, Final Stroll on Perseus's Arm (Perseus Gate Book 6), The - M. D. Cooper (508).epub
2018-04-19 16:59:14.859 [Default|INFO] GetBooks: Sending metadata 271. PriKey 271, CRASH OF MH370, THE - James Nixon (402).epub
2018-04-19 16:59:14.882 [Default|INFO] GetBooks: Sending metadata 301. PriKey 301, Book Thief, The - Markus Zusak (186).epub
2018-04-19 16:59:14.906 [Default|INFO] GetBooks: Sending metadata 331. PriKey 331, Grant - Ron Chernow (515).epub
2018-04-19 16:59:14.908 [Default|INFO] GetBooks: Sending metadata 333. PriKey 333, It's Even Worse Than It Looks_ How the American Constitutis of Extremism - Thomas E. Mann & Norman J. Ornstein (138).epub
2018-04-19 16:59:14.910 [Default|INFO] GetBooks: Have sent all known book metadata. Books.size=334, including discovered=334
2018-04-19 16:59:14.911 [Default|INFO] GetBooks: Have finished sending placeholders for all discovered books.
2018-04-19 16:59:16.649 [Default|INFO] GetBooks: Number of books needed by Calibre: 0
2018-04-19 16:59:16.653 [Default|INFO] Completed Sending books and paths
2018-04-19 16:59:17.157 [Default|INFO] Received OpCode: sendBooklists
2018-04-19 16:59:17.177 [Default|INFO] SendBookLists: 0 books with updated metadata about to be sent
2018-04-19 16:59:17.750 [Default|INFO] Received OpCode: freeSpace
2018-04-19 16:59:17.773 [Default|INFO] Received OpCode: noOp
2018-04-19 16:59:19.447 [Default|INFO] Log event: A_OpenedExtraMenu [:]
2018-04-19 16:59:19.819 [Default|INFO] Received OpCode: noOp
2018-04-19 16:59:21.484 [Default|INFO] Log event: V_Settings [:]
2018-04-19 16:59:21.868 [Default|INFO] Received OpCode: noOp
2018-04-19 16:59:23.915 [Default|INFO] Received OpCode: noOp
2018-04-19 16:59:24.852 [Default|INFO] Log event: V_SettingsGrouping [:]
2018-04-19 16:59:25.963 [Default|INFO] Received OpCode: noOp
2018-04-19 16:59:26.004 [Default|INFO] Log event: V_SettingsGroupingCustomColumns [:]
2018-04-19 16:59:26.666 [Default|INFO] Log event: A_SettingsToggleTableReset ["Title": Groupsort_on_custom_columns]
2018-04-19 16:59:28.112 [Default|INFO] Received OpCode: noOp
2018-04-19 16:59:30.853 [Default|INFO] Log event: V_SettingsGrouping [:]
2018-04-19 16:59:32.116 [Default|INFO] Log event: V_Settings [:]
2018-04-19 16:59:38.140 [Default|INFO] Received OpCode: noOp
2018-04-19 16:59:42.979 [Default|INFO] Log event: V_MainList [:]
2018-04-19 16:59:44.649 [Default|INFO] Communicator disconnected
2018-04-19 16:59:57.815 [Default|INFO] Log event: A_OpenedExtraMenu [:]
2018-04-19 16:59:59.166 [Default|INFO] Log event: A_OpenedAboutHelp [:]
2018-04-19 17:00:02.919 [Default|INFO] Log event: A_ClosedAboutHelp [:]
2018-04-19 17:00:04.536 [Default|INFO] Log event: A_OpenedExtraMenu [:]
2018-04-19 17:00:06.695 [Default|INFO] Log event: V_Settings [:]
2018-04-19 17:00:07.004 [Default|INFO] --- applicationWillResignActive ---
2018-04-19 17:00:09.323 [Default|INFO] --- applicationDidBecomeActive ---
2018-04-19 17:00:11.289 [Default|INFO] Log event: A_EmailLog [:]
jehrler is offline   Reply With Quote
Old 04-20-2018, 07:57 AM   #7
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 11,703
Karma: 6658935
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by jehrler View Post
This is the latest connection logs.
There isn't anything in that log about columns.

I have a dim memory that iOS CC might not fully support columns built from other columns. I own neither a Mac nor an iOS device so I can't test it.

One test that will tell us what is happening: create a standard text custom column and see if CC "sees" it. If it does then we know that calibre and CC are passing the column information. Next try a "Column built from other columns, acts like tags" and see if CC sees that. If CC sees the standard text column but neither of the "columns built ..." then we know my suggestion won't work.

The above experiment would also point at a solution, albeit somewhat clumsy. You could create a standard text column then use Bulk Metadata search/replace to populate it. Use: RegEx mode, "Template" as the source, the above template as the template, (.*) as the search expression, \1 as the replacement expression, and the name of the text column as the destination. This S&R will fill in the column with the correct series sort.
chaley is offline   Reply With Quote
Old 04-20-2018, 09:24 AM   #8
jehrler
Enthusiast
jehrler began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Apr 2018
Device: iphone
Quote:
Originally Posted by chaley View Post
There isn't anything in that log about columns.

I have a dim memory that iOS CC might not fully support columns built from other columns. I own neither a Mac nor an iOS device so I can't test it.

One test that will tell us what is happening: create a standard text custom column and see if CC "sees" it. If it does then we know that calibre and CC are passing the column information. Next try a "Column built from other columns, acts like tags" and see if CC sees that. If CC sees the standard text column but neither of the "columns built ..." then we know my suggestion won't work.

The above experiment would also point at a solution, albeit somewhat clumsy. You could create a standard text column then use Bulk Metadata search/replace to populate it. Use: RegEx mode, "Template" as the source, the above template as the template, (.*) as the search expression, \1 as the replacement expression, and the name of the text column as the destination. This S&R will fill in the column with the correct series sort.
You nailed it. The built from other columns is not working on iOS.

Thanks for the workaround.
jehrler is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Aura Display "next in series" instead of "finished"? Calibrefan Kobo Reader 3 10-11-2014 12:44 PM
PRS-T1 Sony "Collections" vs Calibre "Series" ted13b Sony Reader 3 02-20-2012 09:46 AM


All times are GMT -4. The time now is 06:53 AM.


MobileRead.com is a privately owned, operated and funded community.