|
![]() |
|
Thread Tools | Search this Thread |
![]() |
#1 |
Junior Member
![]() Posts: 4
Karma: 10
Join Date: Oct 2023
Device: Onyx Boox Note Air
|
All filenames were changed to lowercase, can I bulk edit database to correct the path
I recently moved my libraries from my Windows desktop to a Debain media server. I stupidly bulk renamed all my files/folders for avoid case-sensitivity problems going forward. This was fine for my other purposes (e.g. Plex data) because the databases are rebuilt quickly and easily. But my Calibre database has tons of hand edited values from years of use. I could rebuild from scratch, but I'm hoping there's a way to just change the paths to lower in the existing db. I tried doing it using sqlite3, but keep running in to "no such function: title_sort", I'm not sure why. I assume it's a custom function.
Can I use calibredb to edit these paths? |
![]() |
![]() |
![]() |
#2 |
Well trained by Cats
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 30,333
Karma: 58000000
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
I am not sure this will help;
Quality check plugin: Fix: Check and rename book paths. |
![]() |
![]() |
![]() |
#3 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 44,302
Karma: 23661992
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
Create a new empty calibre library, then right click the add books button and choose add books from folders and sub folders and then one book per folder and select the old library folder, it will re-create your library restoring all metadata.
|
![]() |
![]() |
![]() |
#4 | |
Junior Member
![]() Posts: 4
Karma: 10
Join Date: Aug 2024
Location: Seattle, United States
Device: Amazon Kindle
|
Quote:
I tried to create a new library as you mentioned, and it worked. Thanks for the help. Elena |
|
![]() |
![]() |
![]() |
#5 |
Junior Member
![]() Posts: 4
Karma: 10
Join Date: Oct 2023
Device: Onyx Boox Note Air
|
That worked! Thank you!
I'm so grateful for Calibre and all your efforts and that of all the volunteers in maintaining it. |
![]() |
![]() |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Correct path to stylesheet? | Springtide | Editor | 5 | 04-23-2023 06:12 PM |
Override database path | ama | Library Management | 5 | 11-18-2021 08:10 PM |
Title not changed with Bulk Editing | stormsh | Calibre | 6 | 09-23-2013 09:18 PM |
Bulk metada edit error trying to edit tags | Purple Lady | Calibre | 8 | 02-17-2011 06:09 PM |
Lastname, Firstname filenames - Any way to import correct author name? | Starson17 | Calibre | 5 | 12-23-2009 11:03 PM |