First of all: I count the number of my discs twice. Once in Profiler, once parallel in Excel. The only chance for me to control, if I have forgotten to add a title or even more.
Well, sometimes I have differences. And even if it is only one (sometimes one more in profiler, sometimes in Excel), it is a lot of work to control. In the past I checked the counts of the whole collection, what I usually have to spend at least a whole week for. As I actually have 3 discs more in Excel, I decided to make the control easier. At least I thought so. My collection is stored on several different shelfes, and so I added tags to each profile for the shelfes. Checking the number of counts then - at least I thought so - will be easier, as then I only have to control the profiles of this or that shelf. The first shock I got was that there are differences now in 6 shelfes (of totally 37). Twice there is one disc more in profiler, the others have less there.

But meanwhile I have problems in believing: I filtered Excel with only that shelf and did the same in profiler. I coloured all in Excel, and when I found them in profiler, I tagged them there and uncoloured them in Excel. This way it should happen, that the missing one(s) not yet in profiler should remain coloured in Excel. But as I meanwhile did it twice with the same number of profiles and the counts are entered exactly the same in profiler as in Excel, I am simply not able to understand where the difference of two discs come from.
Is there known anything that profiler sometimes "counts" the wrong way? What I mean: 1000 profiles, each with "count as 1", is it possible that then the sum says "filtered 998"? It is possible that I didn't check totally correct if the numbers are the same, but doing the same thing wrong twice is hard to believe.

And: If there IS that kind of a technical issue, then - at least in theory - there could be all discs in profiler, but the sum is not correct.

I only can hope that this is not too complicated to be understood...

Any ideas?

PS: My alternate idea was to create a report for direct comparsion of profiler and Excel - but I can export neighter the counts nor the tags. So if anybody is able to create kind of a report out of the xml (as far as the tags are inside there?) this could be anpther chance to find out what's wrong...

The idea with the report also was mine. The only problem is that there is no chance to get the "count as" into the report. At least I can't find it in all fields available for reports.

Concerning parents/childs I count them different in Excel and profiler: In Excel I "only" enter the full season with the number of discs. The season-profile in profiler has a zero-count but a 1-count for every single child.
And if it is kind of a "multi movie disc", then only the parent has a count, all childs are counted zero. Here I put the "1" in Excel for the very first movie of this disc.

Concerning collection numbers: I don't add them in Excel as I re-arrange them in profiler each time I add new discs. It is easier for me this way. But so the alphabetical order is identic with the numbers.

I don't know if there is anything I haven't tried yet to find out the mistake(s). So far at least - by control by shelf - I had to enter 1 disc into Excel which was only on profiler (no idea how that happend), but this way the differences of 5 other shelfs are still remaining.

Well, that count does not make so much sense in this case. Especially as I have hundreds of profiles with a zero count. But at least I found a way to export to csv with ProfilerQuery. No chance to get my tags, but maybe this now helps to finde the mistake(s). I am curious how long it is going to last until there is the same number of discs in both, excel and profiler...^^

It will be hard work now to control an Excel-File with more than 67.000 lines....^^

It depends on kind of the childs, if the count is 0 or 1:
If it is a box set (like season of a tv series), then the box itself has 0, and each child/disc has 1
If it is a multi-movie-disc (3 or more movies on 1 disc), then the parent (the disc) has 1, and each child zero.

"Anyhwere!" in my collection I set some wrong counts. Now I need/want to find out, where this is.
At least, that there is the same number of discs in Excel and profiler.
Hell of a job by the size of my collection, but I "simply" want both listings correct.

As I could export tags as well with ProfilerQuery, it might be easier for a direct comparsion of the entries/counts of this-and-that shelf. I hope I only need to care about the ones with actual differences. But maybe there are more which cause differences in other shelfes. I will see. Hopefully I am done within the next few weeks...^^

My System works quite well - until I do anything wrong. And within the last couple of months I got SO MANY new discs or created childs for every single movie of a multi-movie-disc (found some more I didn't yet during my check^^), that obviously this way I did something wrong. The mistake(s) themselves are not the problem, the size of my collection probably is...^^

So actually the plan is to end up collecting by the end of this year. I hope to get all the stuff from my wishlist and then I am simply done.... (at least I hope so...^^)