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 Technical Support Page: 1  Previous   Next
Count Problem
Author Message
DVD Profiler Unlimited RegistrantStar ContributorMagmadrag
Master of childprofiles
Registered: May 25, 2007
Germany Posts: 479
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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...
DVD Profiler Unlimited RegistrantRobAGD
Registered: June 3, 2007
United States Posts: 711
Posted:
PM this userEdit postDirect link to this postReply with quote
The first thing that comes to mind for me is you may have issues in the counts in parent/child profiles VS what you enter into excel.

Depending on the info you put into your excel sheet, you could sort by collection number and spot check every 10-20 profiles to see if you still on track with your number syncing, or by add/purchase dates. As you confirm your counts you can put in a break or note as your new starting place to check from.

As I just got my PC DB back up an running after being stupid lazy about getting it fix/sorted I would look into generating reports and print to pdf and then you should be able to copy that info into another excel sheet to run a script to compare 2 sheets.

Good luck

-Robert
DVD Profiler Unlimited RegistrantStar ContributorMagmadrag
Master of childprofiles
Registered: May 25, 2007
Germany Posts: 479
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
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.
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,906
Posted:
PM this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Just FYI, in ProfilerQuery you can list Count As, and you can also filter on Count As, so you can get a list of profiles where it is not set to one.

My freeware tools for DVD Profiler users.
Gunnar
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next