Solved - How to modify my folder structure by modifying the database file

Solved How to modify my folder structure by modifying the database file - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Windows (https://forum.kodi.tv/forumdisplay.php?fid=59)
+---- Thread: Solved How to modify my folder structure by modifying the database file (/showthread.php?tid=379193)

How to modify my folder structure by modifying the database file - srich12 - 2024-10-19

Hi - I'm using Kodi 21 in Windows 10 Pro.
I typically browse movies in folder view (by clicking 'folder > files > (my media drive)'. But the folder view was screwed up after using the default python scraper (some of my folder names were automatically modified (to movies that are similar to the original folder name, but which are not even in my collection)).
I've got my database file open in DB Browser (a SQLite modification tool). I can modify movie names just fine. But can't figure out how to modify the names of the folders that were modified by the scraper.

This problem originally occurred because, when I was setting up the source/scraper, I selected 'each movie is in a folder of the same name', and 'scan recursively' (when I didn't use those settings, nothing was scraped at all).
On my media drive, folders are named by movie genre. Each genre folder contains movies in that genre, each of which is in a folder of the same name (some are there without their own folder, however).
So I understand why the scraper is getting confused - I just don't know how to fix it.

This also seems like a design flaw, because the file/folder view should (ideally) remain unchanged by any database updates and/or manipulation (IMHO that's what file/folder view is for: to browser your drive using the exact folder structure that is on the drive itself).

Thanks for any help!

RE: How to modify my folder structure by modifying the database file - Karellen - 2024-10-19

(2024-10-19, 06:34)srich12 Wrote: some of my folder names were automatically modified

Disable this... https://kodi.wiki/view/Settings/Media/Videos#Replace_file_names_with_library_titles

(2024-10-19, 06:34)srich12 Wrote: to movies that are similar to the original folder name, but which are not even in my collection

Possibly something wrong with your naming.

(2024-10-19, 06:34)srich12 Wrote: I've got my database file open in DB Browser (a SQLite modification tool). I can modify movie names just fine.

Yea, I wouldn't do that at all.
You say they are the wrong movie, then changing the title does not fix anything.
Just hit Refresh and pick the correct movie from the list.

(2024-10-19, 06:34)srich12 Wrote: I selected 'each movie is in a folder of the same name',

Something wrong with your folder naming.

(2024-10-19, 06:34)srich12 Wrote: So I understand why the scraper is getting confused - I just don't know how to fix it.

Ok.
Provide a screenshot of a few movies in your Source. Let's see how it is laid out and named.

(2024-10-19, 06:34)srich12 Wrote: This also seems like a design flaw

More like a user flaw Wink

See my first comment.

RE: How to modify my folder structure by modifying the database file - jjd-uk - 2024-10-19

If all movie folders sit under a genre folder, then each genre folder should be added as a separate source, or you can setup a multi-path source containing each genre folder as source.

I am assuming you have something like

1 - Movie Folder
1.1 -- Genre 1
1.1.1 ---- Movie 1
1.1.2 ---- Movie 2
1.2 -- Genre 2
1.2.1 ---- Movie 3
1.2.2 ---- Movie 4

Then I guess what you've done is add 1 - Movie Folder as the source which is wrong.

As Karellen said, we'll need to know exact folder/file layout to advise properly.

RE: How to modify my folder structure by modifying the database file - srich12 - 2024-10-20

You're right, it was a user flaw - your suggestion totally fixed my problem.
A million thanks to you, Karellen!!

RE: How to modify my folder structure by modifying the database file - Karellen - 2024-10-20

(2024-10-20, 01:55)srich12 Wrote: your suggestion totally fixed my problem.

Great!! Glad it is now working.

How to modify my folder structure by modifying the database file - PatK - 2024-10-20

Thread marked solved.