Author |
Message |
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| Posted: | | | | Hi,
I'm a bit of a statistics freak when it comes to my DVD database. So, once a year I run these statistics.
But to make sure they are meaningful, I have to check if my database is consistent to my own personal standards.
For example, every single movie and TV series disc has a running time, but no box-set or season has. If it had, times would be counted double and make the whole number meaningless. So I erase the number on seasons and then lock the field. But sometimes I just forget to lock it and with the next update the number is back again.
I do most of my checking based on tags (I have tags for box sets, box set contents, purchase items and so forth).
In order to not have to check every year by hand, I'm planning to write a small plugin for myself which checks these simple rules. If a profile doesn't comply, I get informed.
My rules all follow the pattern if A=x, then B must be y and C must be z. One base condition clause and several follow up checks.
And I was just wondering if other people have similar standards they hold their database to and might be interested in such a checker as a public plugin. If so, I'd just need the conditions so I can analyze if it's feasable to be put into a programmable routine. | | | Karsten DVD Collectors Online
|
|
Registered: October 6, 2008 | Posts: 1,932 |
| Posted: | | | | That sounds like a useful plugin to me. I think I would use it for things like the example you listed. |
|
Registered: June 2, 2009 | Reputation: | Posts: 305 |
| Posted: | | | | Seconded, DJ |
|
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| Posted: | | | | Okay, so this topic is two (or maybe three ) weeks old, but with my recent experiences at work I managed to find a solution to make my specialized checker so generalized that it can work for other people as well. I'll just have to create a configuration tool and then off we go. | | | Karsten DVD Collectors Online
| | | Last edited: by DJ Doena |
|
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| |
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| |
Registered: March 23, 2007 | Posts: 97 |
| Posted: | | | | Can this also be used for profiles with an specific rating, no release date or no production Year? |
|
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| Posted: | | | | Quoting Moses277: Quote: Can this also be used for profiles with an specific rating, no release date or no production Year? No production year is already in there. Rating and Release Date were of no interest to me personally, that's why they're not in there (yet). Same with audio. I'll add these additional filters per request. | | | Karsten DVD Collectors Online
|
|
Registered: March 14, 2007 | Reputation: | Posts: 4,667 |
| |
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| Posted: | | | | The following checks and filters are now available:
Audio Track: Must contain audio tracks Audio Track: Must contain given value Box set: Must have child profiles Case Type: Must be equal to given value Case Type: Must be set Cast: Must contain cast members Collection Number: Must be set Collection Type: Must be part of given collection type value Collection Type: Must be part of Owned collection Count As: Must be equal to given value Country of Origin: Must contain countries of origin Crew: Must contain crew members Disc: Must contain discs Easter Eggs: Must be set Event: Must contain event of the given event type and user Exclusion: Must be excluded from DVD Profiler for iPhone / Android Exclusion: Must be excluded from DVD Profiler Mobile (PDA) Exclusion: Must be excluded from online private listing Exclusion: Must be excluded from online public listing Features: Must contain features Genre: Must contain genres Genre: Must contain given value Logic: Combine filters/checks with AND Logic: Combine filters/checks with OR Logic: Exclude profiles Media Company: Must contain media companies Media Type: Custom Type must be equal to given value Media Type: Custom Type must be set Media Type: Must be Blu-ray Media Type: Must be DVD Media Type: Must be HD-DVD Media Type: Must be Ultra-HD Overview: Must be set Production Year: Must be set Purchase: Currency must be equal to given value Purchase: Currency must be set Purchase: Date must be set Purchase: Place must be equal to given value Purchase: Place must be set Purchase: Price must be set Rating: Must be equal to given value Rating: Must be set Rating: Rating System must be equal to given value Release Date: Must be set Review: Audio must be set Review: DVD / Video must be set Review: Extras must be set Review: Movie must be set Running Time: Must be set SRP: Currency must be equal to given value SRP: Currency must be set SRP: Price must be set Studio: Must contain studios Subtitle: Must contain given value Subtitle: Must contain subtitles Tag: Must contain given value Video Format: Any Color Format must be checked Video Format: Any Dimension must be checked Video Format: Any Video Format must be checked Video Format: Aspect Ratio must be set | | | Karsten DVD Collectors Online
| | | Last edited: by DJ Doena |
|
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| Posted: | | | | New version with new checks is out:
Cast: Birth Year must be larger / smaller than given value Crew: Birth Year must be larger / smaller than given value Event: Date is older than the purchase date Event: Must contain event with date larger / smaller than given value Purchase: Date must be larger / smaller than given value
These checks are there to find invalid birth years (e.g. before 1890 or after 2020) or purchases or watched events that are in the future. | | | Karsten DVD Collectors Online
| | | Last edited: by DJ Doena |
|
Registered: April 4, 2007 | Posts: 879 |
| Posted: | | | | Thank you, this tool is extremely useful for a tag power user like myself with hundreds of tags, quite a few of which have dependencies on each other and/or on basic profile values. Not to mention making sure that "required" tags are always set | | | - Jan |
|
Registered: June 3, 2007 | Posts: 10 |
| Posted: | | | | I've tried but the tool doesn't start at all. Are there any requirements that I'm missing? |
|
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| |
Registered: March 13, 2007 | Reputation: | Posts: 767 |
| Posted: | | | | How about profile ID: must be the same as the first disc ID in the disc info field? |
|
Registered: June 3, 2007 | Posts: 10 |
| Posted: | | | | Quoting DJ Doena: Quote: Try out the new version Hi, Thanks for your reply. I downloaded the newest version from your website. Any ideas? |
|