| Author |
Message |
| Registered: March 14, 2007 | Reputation:  |  Posts: 6,745 |
| | 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,745 |
| | 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,745 |
| |
| Registered: March 14, 2007 | | Reputation: | | Posts: 6,745 |
| |
| 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,745 |
| | 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,685 |
| |
| Registered: March 14, 2007 | | Reputation: | | Posts: 6,745 |
| | 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,745 |
| | 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: 887 |
| | 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,745 |
| |
| 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? |
|