Posts: 13
Joined: Dec 2011
Reputation:
0
One of my hard drives had a meltdown and needlessly to say I lost all the files on the drive.
The info for all those files is in the Kodi database, is there some way of having Kodi generate a report of the now missing files?
Hope someone can help! TIA
Posts: 13
Joined: Dec 2011
Reputation:
0
Don't understand how a smart playlist can extract info for missing files from Kodi's database.
The link for Smart Playlist is blank.
Not familiar with sql.
Posts: 13
Joined: Dec 2011
Reputation:
0
OK once the smart playlist is generated can it be exported to be printed out?
Posts: 21,151
Joined: Apr 2017
Reputation:
1,468
No.
You will need to use the SQL method if you want to print out a list.
Posts: 14,208
Joined: Nov 2009
Reputation:
710
Klojum
Lost connection
Posts: 14,208
It'll be a bit rudimentary, and there will be no need for a smart playlist, but you can open your music database file MyMusic72.db with most SQLite database tools, and run the following command:
SELECT * FROM path WHERE strPath LIKE "%DRIVEPATH%"
Mind you, change DRIVEPATH to whatever harddisk name the problem drive has/had, and a list should follow.
Do keep the %-signs at either side in the command. The listing could then be copied to whatever text editor and be printed out.
Posts: 13
Joined: Dec 2011
Reputation:
0
Thanks to all for your help. The SQL method worked a treat. I now have a printed list of all the missing files!
