| Author |
Message |
| Registered: March 13, 2007 | Reputation:  |  Posts: 6,635 |
| | Posted: | | | | Quoting pdf256: Quote:
The reason that Ken has not added a way to have more then one copy of a DVD in your collection is that the profiles are keyed off of the UPC/disk-id, not off of a 'collection number'. He would need to change the way that the database is built.
pdf This is the key to the issue. The UPC/disc ID is the unique record key for each profile. If you have more than one, it's no longer unique. This is basic database architecture. | | | | Hal |
|
| Registered: March 14, 2007 | Reputation:  |  Posts: 6,744 |
| | Posted: | | | | Quoting hal9g: Quote:
Quoting pdf256:
Quote:
The reason that Ken has not added a way to have more then one copy of a DVD in your collection is that the profiles are keyed off of the UPC/disk-id, not off of a 'collection number'. He would need to change the way that the database is built.
pdf
This is the key to the issue.
The UPC/disc ID is the unique record key for each profile. If you have more than one, it's no longer unique. This is basic database architecture. Although that's true, multi-column key tables aren't that uncommon either. Let's say UPC/DiscId + Title + ReleaseDate? | | | Karsten
DVD Collectors Online
 |
|
| Registered: March 14, 2007 |  Posts: 2,337 |
| | Posted: | | | | Quoting DJ Doena: Quote:
Although that's true, multi-column key tables aren't that uncommon either.
Let's say UPC/DiscId + Title + ReleaseDate? But if it is a duplicate, all those fields are same. |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 6,744 |
| | Posted: | | | | Quoting Kulju: Quote:
Quoting DJ Doena:
Quote:
Although that's true, multi-column key tables aren't that uncommon either.
Let's say UPC/DiscId + Title + ReleaseDate?
But if it is a duplicate, all those fields are same. That's true. I was more thinking about the general issue of duplicate UPCs of different titles or re-releases... | | | Karsten
DVD Collectors Online
|
|
| Registered: March 15, 2007 | | Reputation: |  Posts: 5,459 |
| | Posted: | | | | Quoting pdf256: Quote:
The reason that Ken has not added a way to have more then one copy of a DVD in your collection is that the profiles are keyed off of the UPC/disk-id, not off of a 'collection number'. He would need to change the way that the database is built. That never occurred to me. I always thought it was to stop commercial use too. It would be nice if the program could still be adapted to allow this use. I would have thought finding some other unique key would also allow us to profile re-issue releases too wouldn't it? |
|
| Registered: March 13, 2007 |  Posts: 646 |
| | Posted: | | | | nm | | | | Last edited: by xyrano |
|
| Registered: September 10, 2008 | | Posts: 164 |
| | Posted: | | | | Skip, If there was a way to limit the user to a small number of duplicates per DVD, say 2-3, and not be a huge change to DVDP, would that not do the trick? How about a limit to how many DVDs could have duplicates, say no more than 10% of the user's library?
How would that be conducive to commercial use? | | | -R.
Windows 7 (Home Premium) SP1; 64-bit
DVD Profiler 3.8.1 |
|
| Registered: March 13, 2007 | | Posts: 646 |
| | Posted: | | | | Quoting dav4is: Quote:
Skip, If there was a way to limit the user to a small number of duplicates per DVD, say 2-3, and not be a huge change to DVDP, would that not do the trick? How about a limit to how many DVDs could have duplicates, say no more than 10% of the user's library?
How would that be conducive to commercial use? I was thinking the same!  |
|
| Registered: September 10, 2008 | | Posts: 164 |
| | Posted: | | | | Quoting northbloke: Quote:
Quoting pdf256:
Quote:
The reason that Ken has not added a way to have more then one copy of a DVD in your collection is that the profiles are keyed off of the UPC/disk-id, not off of a 'collection number'. He would need to change the way that the database is built.
That never occurred to me. I always thought it was to stop commercial use too.
It would be nice if the program could still be adapted to allow this use. I would have thought finding some other unique key would also allow us to profile re-issue releases too wouldn't it? The solution is to introduce a qualifier that could be set by the user to make two otherwise identical DVDs appear to be distinct. This could be in the form of a drop-down variable with a small number of possibilities, say A,B,C, to prevent useful use as a commercial inventory. Yes, this would require a database change, but not a huge code rewrite, is my guess. | | | -R.
Windows 7 (Home Premium) SP1; 64-bit
DVD Profiler 3.8.1 |
|
| Registered: March 15, 2007 | | Reputation: | | Posts: 5,459 |
| | Posted: | | | | @xyrano
the problem I see with those is that they are still not unique.
A new "counter" number would need to be added in order for it to work. Something like:
[UPC].[locality].[copy number]
And in order to stop commercial use, the copy number could be restricted to only fall between 1-3 or something like that.
Edit: that would work too dav4is | | | | Last edited: by northbloke |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 6,635 |
| | Posted: | | | | Quoting DJ Doena: Quote:
Quoting hal9g:
Quote:
Quoting pdf256:
Quote:
The reason that Ken has not added a way to have more then one copy of a DVD in your collection is that the profiles are keyed off of the UPC/disk-id, not off of a 'collection number'. He would need to change the way that the database is built.
pdf
This is the key to the issue.
The UPC/disc ID is the unique record key for each profile. If you have more than one, it's no longer unique. This is basic database architecture.
Although that's true, multi-column key tables aren't that uncommon either.
Let's say UPC/DiscId + Title + ReleaseDate? That's true. It's not that it couldn't be done, just that the current design does not support it. | | | | Hal |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,394 |
| | Posted: | | | | If you could have two identical profiles in the database, you would have two that need to be updated everytime someone contributes a change. I find it hard enough to keep one profile updated let alone have to worry about doing it for multiple copies.
Also, wouldn't there be a risk of someone forgetting to update the "second" copy's profile and then inadvertently contributing it with bad data?
Putting info in the notes field -- or maybe creating a tag for duplicate copies -- is less risky IMHO. | | | Another Ken (not Ken Cole)
Badges? We ain't got no badges. We don't need no badges. I don't have to show you any stinking badges.
DVD Profiler user since June 15, 2001 |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 17,334 |
| | Posted: | | | | Quoting kdh1949: Quote:
If you could have two identical profiles in the database, you would have two that need to be updated everytime someone contributes a change. I find it hard enough to keep one profile updated let alone have to worry about doing it for multiple copies.
Also, wouldn't there be a risk of someone forgetting to update the "second" copy's profile and then inadvertently contributing it with bad data?
Putting info in the notes field -- or maybe creating a tag for duplicate copies -- is less risky IMHO. I agree with you on this Ken. I would think if anything... a field in the personalize window for number of copies would be good enough. | | | | Pete |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,372 |
| | Posted: | | | | except the 2nd copy has it's own set of circumstances behind it.
All of my dups have their own collection number. They all have their own price paid. Some dups are there because of a box set purchase so the one disk has to be associated with the box set while the other does not. My guess is most people are in the same boat. I doubt there are many of us who buy 2 discs at the same time for the same price from the same place just to have a duplicate.
Just putting a quantity field in the personalize section would mean you lose a lot of information for one of the discs. Not the right solution if you ask me. |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,394 |
| | Posted: | | | | Quoting lyonsden5: Quote:
except the 2nd copy has it's own set of circumstances behind it.
All of my dups have their own collection number. They all have their own price paid. Some dups are there because of a box set purchase so the one disk has to be associated with the box set while the other does not. My guess is most people are in the same boat. I doubt there are many of us who buy 2 discs at the same time for the same price from the same place just to have a duplicate.
Just putting a quantity field in the personalize section would mean you lose a lot of information for one of the discs. Not the right solution if you ask me. You can put as much into the NOTES field as you want if you feel you need more than just a single field. But if ALL the data (other than personalized data like price paid) is the same for both discs, I think it's still a unique title. | | | Another Ken (not Ken Cole)
Badges? We ain't got no badges. We don't need no badges. I don't have to show you any stinking badges.
DVD Profiler user since June 15, 2001 |
|
| Registered: March 13, 2007 | Reputation:  | | Posts: 3,321 |
| | Posted: | | | | The flip side of this is that if we had the ability to have the same UPC in the database more than once, we'd just be a hop, skip and a jump from being able to handle multiple movies on a single disc or even giving each episode from a TV set it's own profile.
So while the duplicate issue doesn't bother me one way or the other, I'm certainly behind the ability to have the same UPC entered multiple times in my collection. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. | | | | Last edited: by Mark Harrison |
|