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: Desktop Feature Requests Page: 1 2  Previous   Next
Online Data Base
Author Message
DVD Profiler Unlimited RegistrantStar ContributorSrehtims
Registered: March 13, 2007
United States Posts: 1,796
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
A number of times I see a film I would like to have, but it is enter by disc id, but I can't find its parent.
For child profiles (profiles entered by disc id) in the Online Data Base I would like a link back to parent profile (UPC/EAN).
We don't need stinkin' IMDB's errors, we make our own.
Ineptocracy, You got to love it.
"Nearly all men can stand adversity, but if you want to test a man's character, give him power." - Abraham Lincoln
DVD Profiler Unlimited RegistrantStar ContributorKatatonia
Retired Profiler
Registered: March 13, 2007
Reputation: Highest Rating
United States Posts: 20,111
Posted:
PM this userDirect link to this postReply with quote
Quoting Srehtims:
Quote:
A number of times I see a film I would like to have, but it is enter by disc id, but I can't find its parent.
For child profiles (profiles entered by disc id) in the Online Data Base I would like a link back to parent profile (UPC/EAN).


The problem with that is many child profiles belong to multiple parents. Box Sets are reissued with different UPC's, yet the Disc ID's contained within remain the same.

Also many Blu-ray/DVD Combos have multiple releases, so the DVD childs often belongs to multiple parent profiles.
Corey
DVD Profiler Unlimited RegistrantStar ContributorSrehtims
Registered: March 13, 2007
United States Posts: 1,796
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I know, but give me a and I'll pick to pick from..
We don't need stinkin' IMDB's errors, we make our own.
Ineptocracy, You got to love it.
"Nearly all men can stand adversity, but if you want to test a man's character, give him power." - Abraham Lincoln
DVD Profiler Unlimited RegistrantStar ContributorWinston Smith
Don't be discommodious
Registered: March 13, 2007
United States Posts: 21,610
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
I see where you ate coking from, srethims. My question, not for you, is how hard might this be to implement. I wish I was more familiar with what ken, uses, it could be very difficult to implement.
ASSUME NOTHING!!!!!!
CBE, MBE, MoA and proud of it.
Outta here

Billy Video
DVD Profiler Unlimited RegistrantStar ContributorParsec
Registered: June 15, 2012
Australia Posts: 428
Posted:
PM this userDirect link to this postReply with quote
Somebody wrote a plugin or similar I saw, but haven't been able to find again, which included using sql queries on the database. You could run an sql query to seach for a upc where boxset id matches the disc id. Problem is, you'd need a copy of the entire database to do this and i don't think Invelos gives that out
DVD Profiler Desktop and Mobile RegistrantStar Contributoreommen
DVD nerd
Registered: March 13, 2007
Reputation: High Rating
Netherlands Posts: 485
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Well, you already have a copy of the WHOLE database locally: just browse the "Add to collection..."-> "Add by title". That said, it probably is only the columns you see that you have locally. What would be needed is some additional structure to map to the 'parents' (beware of the 1:n relationship of disk ID to multiple EANs). Also, as I do not think the majority of all profiles have multiple 'parents', I guess it should be doable. Preferably, such a structure would also point to parents of a parent if needed.
Anyone who has Achim's conversion to MS Access tool operational and could play with it and try out whether this extra structure would be unwieldy large or doable? (my thinking: multiple hits on the same title within a locality gives an indication, though probably inflated a bit if different disks were used).
Eric

If it is important, say it. Otherwise, let silence speak.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Aside: Happy New Year All! 

Regarding this discussion, I am a bit confused. I have not been taking into account the fact that a profile can exist in multiple box sets in my plugins. So I am trying to get a better understanding.   

For example, BulkEdit adds (among others) the following commands:

- Collection/Flags/Flag Box Sets
- Collection/Flagged/Flag Child Profiles

Do these work correctly for you?

The plugin SideCar gives you Parent Profile as a DP variable. I have to check this code - I am reasonably sure that I am not providing multiple values (array). I must be returning the first hit.

Is there another command that I could add to BulkEdit that would be helpful, such as "DVD/Flag Parents " (flag every profile containing the subject profile within its Box Set)?

Am I (mis)understanding this discussion?
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,744
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
You have to distinguish between the online global database (OGDb) and your local personal database (LPDb) / online personal database (OPDb).

In the OGDb there are many profiles that have the same child profiles assigned. Takes this for example:

My Favourite Show: Season 1 - fancy digipak with booklet and fotos.

Contains six DiscIds as children.

My Favourite Show: Season 1 - simple keep case with no extras.

Contains the same six DiscIds as children.

My Favourite Show: The Complete Series

Contains 30 DiscIds as children of which six are the same as above.


In the LPDb you can have every DiscId = ProfileId only once and it can only be assigned to one parent.

If you have first bought Season 1 and later The Complete Series you have to use manual profiles for one of them.

But the OGDb can have many profiles with the same children.
Karsten
DVD Collectors Online

 Last edited: by DJ Doena
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Ah, thanks DJ for that clear explanation with examples. That totally sucks!!! (I hate that phrase, but it really applies here).

I wonder how this limitation manifests itself when you are adding DVDs to your local. I am tempted to try it and see what happens. I mean, it is possible that a person could own all those titles and want to add them, correct?

I mean, I have seen any number of posts where people have unexplained problems when adding Box Sets and children. I wonder how many of them were in fact manifestations of this issue? This is probably one of the most serious limitations I have seen of the database design - right up there with multiple copies, and the well known linking problems. That said, I support the original feature request to fix it.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,744
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
I believe the program is intelligent enough to recognise that a profile is already used locally and does not offer to add it again when you add the parent profile.

I first ran into that problem when I bought my first complete box set (Babylon 5, all seasons, all movies). The set was great but the discs were exactly the same as the single seasons.

So I use manual profiles for the older ones and the DiscId for the box set discs:

http://doena-soft.de/phpdvdprofiler_en/index.php?lastmedia=M129.5
http://doena-soft.de/phpdvdprofiler_en/index.php?lastmedia=IF45C27814F509D7C.5

Add on top of that that the complete box set had no barcodes for the seasons, so people started using the Season X: Disc 1 Id as season identifier.

So even when you only have the single season + disc profiles you suddenly got

Babylon 5: Season 1
+ Babylon 5: Season 1
+ Babylon 5: Season 1: Disc 2
+ Babylon 5: Season 1: Disc 3
+ Babylon 5: Season 1: Disc 4
+ Babylon 5: Season 1: Disc 5
+ Babylon 5: Season 1: Disc 6

I've since then made it a habit to lock my season disc profiles completely right from the start. I even unset the "Download from Invelos" checkbox when adding the discs.
Karsten
DVD Collectors Online

 Last edited: by DJ Doena
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Ha! You just edited your post to answer the question I had!!! 
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantStar ContributorSrehtims
Registered: March 13, 2007
United States Posts: 1,796
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Oh, I forgot to mention that when I make contribution of a child profile I always add at the top of the contribution note the following:
Child profile for "Scarecrow and Mrs. King: The Complete Third Season", UPC: 883929215065;
form the parent profile.
example from today's contribution.
I wish some of the rest of you would be so eleemosynary, Please.
We don't need stinkin' IMDB's errors, we make our own.
Ineptocracy, You got to love it.
"Nearly all men can stand adversity, but if you want to test a man's character, give him power." - Abraham Lincoln
 Last edited: by Srehtims
DVD Profiler Unlimited RegistrantStar ContributorWinston Smith
Don't be discommodious
Registered: March 13, 2007
United States Posts: 21,610
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Perfect, srethims. And I agree with you, boy do I wish
ASSUME NOTHING!!!!!!
CBE, MBE, MoA and proud of it.
Outta here

Billy Video
DVD Profiler Unlimited RegistrantStar ContributorKulju
Registered: March 14, 2007
Finland Posts: 2,337
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Srehtims:
Quote:
Oh, I forgot to mention that when I make contribution of a child profile I always add at the top of the contribution note the following:
Child profile for "Scarecrow and Mrs. King: The Complete Third Season", UPC: 883929215065;
form the parent profile.
example from today's contribution.
I wish some of the rest of you would be so eleemosynary, Please.

But how would you do this if the same child is attached to another parent later? As stated before same childrens can be part of several boxsets.
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Kulju:
Quote:
But how would you do this if the same child is attached to another parent later?

"Also Child to 12345678900" as a comment on a valid profile-update?

But as the data is already there a reverse-search to find possible parents would be better.


cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited RegistrantStar ContributorKulju
Registered: March 14, 2007
Finland Posts: 2,337
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Mithi:
Quote:
Quoting Kulju:
Quote:
But how would you do this if the same child is attached to another parent later?

"Also Child to 12345678900" as a comment on a valid profile-update?

There is no need to contribute child if you add it to another boxset.
    Invelos Forums->DVD Profiler: Desktop Feature Requests Page: 1 2  Previous   Next