Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Plugins Page: 1  Previous   Next
Database Consistency Checker
Author Message
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Battle Troll
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,438
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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
Amazon Price Observer

DVD Profiler Unlimited RegistrantCalebAndCo
Ralphie shot first.
Registered: October 6, 2008
United States Posts: 1,932
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
That sounds like a useful plugin to me.  I think I would use it for things like the example you listed. 
DVD Profiler Unlimited RegistrantTraunStaa
Registered: June 2, 2009
Reputation: Highest Rating
Austria Posts: 298
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Seconded, DJ 
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Battle Troll
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,438
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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
Amazon Price Observer

 Last edited: by DJ Doena
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Battle Troll
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,438
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Database Consistency Checker

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


If you are missing any filters / checks (like for audio, subtitles, ...) let me know. 
Karsten
DVD Collectors Online
Amazon Price Observer

 Last edited: by DJ Doena
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Battle Troll
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,438
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
And for those interested, the source code can be found on GitHub: https://github.com/DJDoena/DatabaseConsistencyChecker
Karsten
DVD Collectors Online
Amazon Price Observer

DVD Profiler Unlimited RegistrantStar ContributorMoses277
I'd rather be in the Sun
Registered: March 23, 2007
United Kingdom Posts: 93
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Can this also be used for profiles with an specific rating, no release date or no production Year?
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Battle Troll
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,438
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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
Amazon Price Observer

DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,778
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Moses277:
Quote:
Can this also be used for profiles with an specific rating, no release date or no production Year?

You might want to take a look at ProfilerQuery
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Battle Troll
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,438
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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
Amazon Price Observer

 Last edited: by DJ Doena
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Battle Troll
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,438
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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
Amazon Price Observer

 Last edited: by DJ Doena
DVD Profiler Unlimited RegistrantStar Contributorhydr0x
Registered: April 4, 2007
Germany Posts: 823
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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
    Invelos Forums->DVD Profiler: Plugins Page: 1  Previous   Next