All filenames were changed to lowercase, can I bulk edit database to correct the path

Nirodha · Yesterday, 06:58 PM

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?

theducks · Yesterday, 08:10 PM

I am not sure this will help;
Quality check plugin: Fix: Check and rename book paths.

kovidgoyal · Yesterday, 10:37 PM

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.

Yesterday, 06:58 PM	#1
Nirodha Junior Member Posts: 3 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?

Similar Threads
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

Yesterday, 08:10 PM	#2
theducks Well trained by Cats Posts: 30,170 Karma: 57532200 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.

Yesterday, 10:37 PM	#3
kovidgoyal creator of calibre Posts: 44,181 Karma: 23000000 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.

Advert