| Registered: May 25, 2007 | Posts: 479 |
| | Posted: | | | | 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... |
|
| Registered: June 3, 2007 | Posts: 711 |
| | Posted: | | | | 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 |
|
| Registered: May 25, 2007 | Posts: 479 |
| | Posted: | | | | 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. |
|
| Registered: March 14, 2007 | Reputation:  | Posts: 4,906 |
| |