| Author |
Message |
| Registered: March 21, 2012 | | Posts: 2 |
| | Posted: | | | | The total DVDs on the tab states 329 but number count is 330. What is the problem?? |
|
| Registered: May 19, 2007 | Reputation:  |  Posts: 6,730 |
| | Posted: | | | | Incorrect "Count As"-value for one profile | | | It all seems so stupid, it makes me want to give up!
But why should I give up, when it all seems so stupid?
Registrant since 05/22/2003 |
|
| Registered: March 21, 2012 | | Posts: 2 |
| | Posted: | | | | Many thanks for that. One DVD had a count as "0" setting. All fixed |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 5,494 |
| | Posted: | | | | Would data base query find this inaccurate count ? My total count to my 'uploaded saved 'data is still about 80 titles out of whack .. of which I know now not to have duplicates marked doubled or tripled in some cases ..
I don't believe I can find this manually on the profiler side but would DB query find this ?? | | | In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.
Terry |
|
| Registered: March 13, 2007 | | Reputation: |  Posts: 485 |
| | Posted: | | | | This is asked from time to time. For instance, recently during a db upload I had:
Highest collection number: 3476
Owned (collection): 3750 (same number on tab for 'total DVD's)
Owned (upload window): 4005
Double (colection): 186 (a custom collection, containing double dipped old ones)
Other (upload window): 189
All (collection): 3936
Total entries (upload window): 4194
There are different results for your totals in the collection:
* highest collection number (after a neat renumbering)
* all profiles including those where the collection number was forcebly set to 'none'.
* Filling in the 'count as' feature different than the default '1'. For instance, both a parent and a child profile may have a 'count as' = '1' by default.
* the number of disks, where the same disk can be listed in the parent profile and in the child profile. This is caused especially with TV series boxes, where the existence of child profiles is not mandatory so double counts can exist.
* also, profiles may be in your collection with no disks (yet) added, left alone disk ID's...
You can play around with a playground database with a few profiles, say 5, to see what is what. For a playground database, generate a new blank one via the menu File -> Open database, then click New Database..., generate and open it and put a few profiles in... | | | Eric
If it is important, say it. Otherwise, let silence speak. | | | | Last edited: by eommen |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,217 |
| | Posted: | | | | Quoting widescreenforever: Quote:
I don't believe I can find this manually on the profiler... Shouldn't be any problem: - set collection-list to List-Mode (Ctrl+F1) - right-click anywhere in the collection-list and choose "view Columns -> Count As" - uncheck "Collection -> Nest Box Set" - now click on the top of the "Count As"-Column to sort by it, any anomalies should show up at the top or bottom. cya, Mithi | | | | Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 5,494 |
| | Posted: | | | | Thanks Mithi that did the trick ... I have two or three days of editing ahead me now .,,.... | | | In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.
Terry |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,217 |
| | Posted: | | | | Quoting widescreenforever: Quote:
Thanks Mithi that did the trick ... I have two or three days of editing ahead me now .,,.... "Count As" is copy&pasteable so with a bit of luck all you need is copy one profile with the right count, flag all the wrong ones and go Collection -> Flagged -> Paste and only check the "Count As" cya, Mithi | | | | Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 5,494 |
| | Posted: | | | | even Better .. . !!  | | | In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.
Terry |
|