+- 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: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: empty keyword (/showthread.php?tid=377792)
empty keyword - WarpLover - 2024-06-02
How do you test for empty keywords in a smart playlist? In some programming languages it would look like if x = ""
examples
I want to know if there is no plot, or no year, or no title, as some random examples:
<plot></plot>
<year></year>
<title><title>
My intention is to find these missing elements and correct them. I am writing error-finding-playlists for musicvideo nfo's that are made by hand. There's got to be a better way to find these empty elements than the brute force method I use now.
Thank you
RE: empty keyword - DarrenHill - 2024-06-02
@WarpLover - please use the support sections for questions.
Do not post them in discussions, that is not what that area is for.
Thread moved to OS independent support.
RE: empty keyword - WarpLover - 2024-06-03
(2024-06-02, 22:38)DarrenHill Wrote: @WarpLover - please use the support sections for questions.
Do not post them in discussions, that is not what that area is for.
I will comply, but I want you to know that my searches for the subject matter before I ever posted, were all found in that other discussion group. Based on that, I posted there.
RE: empty keyword - Karellen - 2024-06-03
(2024-06-02, 22:11)WarpLover Wrote: My intention is to find these missing elements and correct them. I am writing error-finding-playlists for musicvideo nfo's that are made by hand. There's got to be a better way to find these empty elements than the brute force method I use now.Check the database.
RE: empty keyword - scott967 - 2024-06-03
Agree that running a query against your database is the way to go. Just get an SQL utility like Heidisql. So
for example. You have to look at the wiki for videodatabase to get the column names as they aren't descriptive in most cases.sql:SELECT * FROM musicvideo WHERE c12 IS NULL;
scott s.
.
RE: empty keyword - WarpLover - 2024-06-03
(2024-06-03, 05:05)scott967 Wrote: Agree that running a query against your database is the way to go. Just get an SQL utility like Heidisql. So
for example. You have to look at the wiki for videodatabase to get the column names as they aren't descriptive in most cases.sql:SELECT * FROM musicvideo WHERE c12 IS NULL;
scott s.
.
Is Heidisql in a repository?
RE: empty keyword - Karellen - 2024-06-03
(2024-06-03, 06:47)WarpLover Wrote: Is Heidisql in a repository?No, it is a 3rd party database program.
The one I use is this one... https://sqlitebrowser.org/
Are you comfortable with databases?