Solved How to modify my folder structure by modifying the database file
#1
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!
Reply
#2
(2024-10-19, 06:34)srich12 Wrote: some of my folder names were automatically modified
Disable this... https://kodi.wiki/view/Settings/Media/Vi...ary_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.
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki)  ||  Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#3
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.
Reply
#4
Rainbow 
You're right, it was a user flaw - your suggestion totally fixed my problem.
A million thanks to you, Karellen!!
Reply
#5
(2024-10-20, 01:55)srich12 Wrote: your suggestion totally fixed my problem.
Great!! Glad it is now working.
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki)  ||  Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#6
Thread marked solved.
Reply

Logout Mark Read Team Forum Stats Members Help
How to modify my folder structure by modifying the database file0