Maybe this example will help some...
Field, Rule, Local profile 1, MDB profile 1, Local profile 2, MDB profile 2, Local profile 3, MDB profile 3 Title, Not null, 1, 0, 1, 1, 1, 1 Prod Year, Not null, 0, 0, 1, 1, 1, 1 Run Time, Not null, 1, 0, 0, 1, 1, 1 Release Date, Not null, 0, 0, 0, 1, 1, 1 Case Type, Not null, 0, 0, 1, 1, 1, 1 Genres #1, Not null, 0, 0, 0, 1, 1, 1 Studios #1, Not null, 1, 0, 0, 1, 1, 1 Media Companies #1, Not null, 0, 0, 0, 0, 0, 0 Vide Format, Other than default, 1, 0, 0, 1, 1, 1 Features, Other than default, 0, 0, 0, 0, 0, 0 Audio Tracks #1, Not null, 1, 0, 0, 1, 1, 1 Subtitles # of, >0, 0, 0, 0, 0, 1, 0 Cast # of, >0, 0, 0, 0, 0, 0, 0 Crew # of, >0, 0, 0, 0, 0, 0, 0 Overview length, >0, 0, 0, 0, 0, 0, 0 Discs # of, >0, 1, 0, 0, 0, 1, 0 Cover front, Has image, 0, 0, 0, 1, 1, 1 Cover back, Has image, 0, 0, 0, 1, 1, 1
Sum of fields: 18 Sum: 6, 0, 3, 11, 13, 11 Percentage / profile: 33%, 0%, 17%, 61%, 72%, 61%
LP 1: 33% MP 1: 0% Result: Profile is new.
LP 2: 17% MP 2: 61% Result: Update available.
LP 3: 72% MP 3: 61% Result: Changes made.
Sorry about the format, it was the best I could come up with to show the logic.
I purposefully, left out fields I thought not to be applicable in this. |