Topic: Database Consistency Checker

[DJ Doena]

A program for DVD Profiler that helps you to check if all profiles are in accordance to your own quality standards.

For this you generate a list of rules which are checked and low-quality profiles get listed in the result:





http://doena-journal.net/en/dvd-profiler-tools#DatabaseConsistencyChecker

[Achim]

That is something I have been planning to do. With your tool this is now in my grasp 

[DJ Doena]

If you have any questions, feel free to ask. 

[DJ Doena]

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: Birth Year must be larger / smaller than given value
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: Birth Year must be larger / smaller than given value
Crew: Must contain crew members
Disc: Must contain discs
Easter Eggs: Must be set
Event: Date is older than the purchase date
Event: Must contain event of the given event type and user
Event: Must contain event with date larger / smaller than given value
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 larger / smaller than given value
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

[DJ Doena]

That is something I have been planning to do. With your tool this is now in my grasp 

If you have any more ideas for checks and filters, let me know. 

[Achim]

Once I get to use it, I would want to check profiles that have a certain tag set whether a set of fields is empty.

I usually like to keep certain fields empty for the parents (Box Sets; audio, video, genre, runtime; anything directly related to the actual content really) or the child (TV series; audio, video, genre). As you called one of your Watchable Profile I feel you are using it quite similarly to my intent.

[DJ Doena]

Once I get to use it, I would want to check profiles that have a certain tag set whether a set of fields is empty.

That's basically what I'm doing and the program can do that.

[Antares]

Can't wait to try both this and your Six Degrees program. You are the best Karsten!