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->General: General Discussion Page: 1... 5 6 7 8 9 ...13  Previous   Next
DVDSpot shutting down
Author Message
DVD Profiler Desktop and Mobile Registrantkahless
TaH pagh taHbe'!
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 17,804
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Dr. Killpatient:
Quote:
Oh look - mediadogg now has !


Well deserved! 
Thorsten
DVD Profiler Unlimited RegistrantStar Contributordee1959jay
Registered: March 19, 2007
Reputation: Highest Rating
Netherlands Posts: 6,014
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Congrats, mediadogg! 
Well done, everyone.
 Last edited: by dee1959jay
DVD Profiler Desktop and Mobile RegistrantStar ContributorBad Father
Registered: July 23, 2001
Registered: March 13, 2007
Posts: 4,594
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Well deserved second star Dogg, congrats .
My WebGenDVD online Collection
DVD Profiler Unlimited RegistrantCalebAndCo
Ralphie shot first.
Registered: October 6, 2008
United States Posts: 1,932
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting mediadogg:
Quote:
...Good news: it basically works. In 13 minutes I got 569 profiles, 19 ordered and 550 owned. Excel claims there are 573 (so, 4 missing). Reviews showed up in the "Notes" field OK, complete with CR/LF. Detailed review of Andy Griffith show was in tact (and damned funny!  )...

Tremendous!  I plan to block out some time to do my migration later this week.  I am in your debt.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,396
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting Rooster6975:
Quote:
Yep, that was it.  Picking one which did not work when I tried to Refresh via the Online menu, I can select DVD - Change Locality, and change US to Canada.  Subsequent refreshes correctly downloads the cover art and all the other details.  Interesting.

OK, please forgive my newbishness, but I have owned DVDP for all of 8 hours.  Since your tool is called BulkEdit, I assume there is a way to bulk edit my collection and change all the incorrect localities at once?

I have selected the first 4 as test cases of the 100 or so which don't have profiles after the CSV import.  Then using BulkEdit, I select Load - Flagged Profiles.  I correctly see the 4 I have selected, and I have also chosen the field Locality.  I can see all 4 are incorrectly set to United States.  I can also see that you have labeled the column "Select Profile Fields to Display / Edit (*)".  When I look down the list of fields I can choose, I can see that Locality does not have an asterisk beside it.  Does that mean this field cannot be bulk edited?

Oh, and incidentally, just in case you release a 1.01, if DVDP is running when BulkEdit is installed, the message comes up stating "BulkEdit is currently running...." when I am quite sure you meant to have the message state "DVD Profiler is currently running....."

Thanks,
DD.
Well you may be new, but man are you a quick study! 

You raised some great points - funny how you get so used to things that you can't see the forrest for the trees. That's why it is so refreshing to have new people in the community (sound of violins in background ...  )

Ok, back to business:

(1) There is an overlap in the GS1 numbering scheme for UPCs from Canada and the US, only for a certain range of numbers. In our database, there are profiles that are incorrectly coded locality 3 (Canada only), when they should be coded locality 0 (Canada/US), and vice-versa. Whenever I change my code to accomodate the one, the other set fails.

So, I will take your excellent suggestion and make a way to bulk change Locality - 8 hours on the scene and already you've got cool suggstions! Perhaps a 1.02 may come along soon ... I'll give it a shot.

(2) The way DVD Profiler works, when a plugin is enabled, it is in fact "running", in the sense that it is loaded into memory and available to process events. So, the installation process  detects the plugin code. I'll post this in the Developer's Forum - there may be a way to improve that message - it is controlled by the third-party installer that I use. Perhaps I can get it to check for the base Profiler code instead of mine - but that also has the risk of failing if the main progam changes in a way that is incompatible with my check process - anyway, point well taken.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantRooster6975
Registered: May 27, 2007
Posts: 175
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Ah, thanks for that.  I do have a suggestion though for future versions.  In your tool, if you have the user set their country of origin, I think your tool would end up with much closer to 100% accuracy.  For instance, if I were to select that I lived in Canada, reason would have it that most of my purchases would need to be set for the Canadian locality.  So you could make the run for me to tend towards Canadian locals, thereby increasing the number of profile downloads.  If another user set their country as US, then the other set should have precedence.  It would give the code an idea of which way to lean, depending on where the user is actually located.

Thanks for the tool.  Since I only have 100 or so to Change Locality on, I could do it manually but it is much more fun to see if we can figure this out automatically.

DD.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,396
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting Rooster6975:
Quote:
Thanks for the tool.  Since I only have 100 or so to Change Locality on, I could do it manually but it is much more fun to see if we can figure this out automatically.

DD.

Ha! Once again, my type of guy!

Interesting idea. Things like that depend a lot on the individual. I have a lot of non-US titles in my collection, for example. Using GS1 Country Codes actually produces fewer errors than if I set all my titles to US locality 0, and in your case I got 75% correct. If I had used locality 3 for all of them. I don't think it would have been that high - I'll check though ...

What I am intending to do until I understand it better is to make a "Quick Change" context menu item. So you will go Collection/Flagged/Quick Change - get a dialog box with fields available for quick change, select the value from drop-down and click "OK". I will steal the code from my "Clone" menu, and initially limit the fields to just one - locality. Stay tuned ... (Edit: this idea on hold - implemented edit of the Locality field as originally suggested).
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Desktop and Mobile RegistrantDr. Killpatient
Here's my card
Registered: May 19, 2007
Reputation: Highest Rating
United States Posts: 5,916
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
If you get errors no matter the locality with US/Canada, is it where you get the error on Profile A if set to one but not Profile B and vice versa when set to the other locality?  If so, can you process them all against one locality and then against the other if there is an error?
DVD Profiler Unlimited RegistrantStar Contributorwidescreenforever
Under A Double DoubleW
Registered: March 13, 2007
Reputation: High Rating
Canada Posts: 5,481
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting mediadogg:
Quote:
Quoting Rooster6975:
Quote:
Thanks for the tool.  Since I only have 100 or so to Change Locality on, I could do it manually but it is much more fun to see if we can figure this out automatically.

DD.

Ha! Once again, my type of guy!

Interesting idea. Things like that depend a lot on the individual. I have a lot of non-US titles in my collection, for example. Using GS1 Country Codes actually produces fewer errors than if I set all my titles to US locality 0, and in your case I got 75% correct. If I had used locality 3 for all of them.  ...

Small problem with setting the locality to any other 'but the USA' is 75 % of the time the data is not there, therefore anyone not overly familiar with Invelos will think the title hasn't been submitted, Especially for New titles. The user is then daunted to the task of scanning, and submitting lots  and lots of data, which is either time consuming at that point, or the user will come away saying that the program sucks and can't find title in question.
There are numerous times where I have had my locality 'set' for Canada' and my search brings up zero finds. but, if I look to USA locality for the same UPC, I may have as many as two titles  come up in the search. ....Upon further investigation, (title search-USA) I find the Canadian release (with differant upc) under USA locality.
.... 
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
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,396
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Once again guys, after scanning now almost 4000 profiles from DVDSpot folks, and a bunch of CollectorZ test files as well, the algorithm I am using results in 10 - 20+ % misses. So, there is no need to assert any technique that produces more errors than what I am doing, then argue against it. Try to find one that produces fewer errors than 10%, and I will use it.

One possibility I have considered is allowing the user to select an option to produce duplicate profiles: one by algorithm, one by preferred locality. When they match, you get one profile. When they differ, you get two - at least one of which is likely to be in the database. Then you just delete the unneeded ones. What about that?
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,396
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting Dr. Killpatient:
Quote:
If you get errors no matter the locality with US/Canada, is it where you get the error on Profile A if set to one but not Profile B and vice versa when set to the other locality?  If so, can you process them all against one locality and then against the other if there is an error?
Oh that would the way to go, but I am not in control of that process. The plugin is nowhere to be found during the refresh process (any plugin developers - if I'm wrong, say so).
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,396
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting Rooster6975:
Quote:
Ah, thanks for that.  I do have a suggestion though for future versions.  In your tool, if you have the user set their country of origin, I think your tool would end up with much closer to 100% accuracy.  For instance, if I were to select that I lived in Canada, reason would have it that most of my purchases would need to be set for the Canadian locality.  So you could make the run for me to tend towards Canadian locals, thereby increasing the number of profile downloads.  If another user set their country as US, then the other set should have precedence.  It would give the code an idea of which way to lean, depending on where the user is actually located.

Thanks for the tool.  Since I only have 100 or so to Change Locality on, I could do it manually but it is much more fun to see if we can figure this out automatically.

DD.
It is not that simple. Poking around in your set of "missed" profiles, so far I have found:

- Profiles I coded Sweden that are coded Norway in our database. Quite a few.
- UPCs that you have that are not in our database. Search by title produced the movie with a different UPC
- Profiles I coded US that should have been Canada. These so far are not predominant. (Edit: Wrong - there are a lot of them - as you said!!!!  )

Folks we might as well face the grim reality that the "Locality" is used, does not allow it to be determined algorithmically with 100% success. If I can be proved wrong, I'll buy you a beer and happily change my code.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantRooster6975
Registered: May 27, 2007
Posts: 175
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Right, I can see the problem.  OK, then how about making the Locality one of the Editable fields within BulkEdit, and that will make it much easier for me to go ahead and select the 100 or so missed profiles?  I know that there will still be missing ones even after that (the Norwegian DVDs), but of the 100 which can't find profiles via the Online menu function despite having the correct UPC, I am willing to bet at least 90 of them are because of the incorrect Locality.

DD.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,396
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting Rooster6975:
Quote:
Right, I can see the problem.  OK, then how about making the Locality one of the Editable fields within BulkEdit, and that will make it much easier for me to go ahead and select the 100 or so missed profiles?  I know that there will still be missing ones even after that (the Norwegian DVDs), but of the 100 which can't find profiles via the Online menu function despite having the correct UPC, I am willing to bet at least 90 of them are because of the incorrect Locality.

DD.
Working on it as we "speak" ... 

And oh yeah, they're all over the place. It is painstaking, but maybe not for the original owner of the data. You'll have a better feel for what the locality should be than I ...

Edit: Ok, V1.02 available. I had the code nearly done to do your orginal proposal, but it hadn't been completely debugged.

Steps:

(0) Backup your database = The Golden Rule of Profiler
(1) Flag the profiles that you want to change
(2) In BulkEdit, Load Flagged Profiles (checkbox to display Locality)
(3) Select any cell in the Locality column. You can select the new Locaility from the dropdown, OR
    For multiple changes in bulk:
        (3a) Click "MultiCopy"
        (3b) In the Column Toolbox, type (exactly) the old locality in the "Find" box, and the new
              Locaility in the "Replace With" box
(4) Click Replace All, and Finished
(5) Click File\Save Validated Changes

When finished, you will have two copies of the profile - one with the old locality, and one with the new. The "last edited" date will have been changed on the new one, and its flag set. The flag on the old one has been cleared.

(6) Exit BulkEdit and do Collection\Flagged\Refresh

If your new localities were all correct, you can then display the collection list in UPC sorted order, and the old unflagged profile will be sitting alongside the newly refreshed flagged profile. You can then reverse the flags (manually - the automated one will set unwanted flags) and delete the old profiles.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantEscuby Du
Registered: October 5, 2008
United States Posts: 1
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
mediadogg!

I'm yet another DVDSpit refugee and I want to thank you for the plug-in — very cool of you.  I'm going to open a new database this weekend when I have more time and play around with it.

I took the plunge last weekend and imported my Spot CSV file and, out of 1,500 DVDs, I only had 40 that weren't in the Profiler database. For the most part they're weird titles that I had to enter in the Spot database, so it seems to make sense.

I'm still wading through the Submission threads but I'll soon gird my loins and try my hand at it — seems pretty intimidating though.

BTW, I'm developing a serious case of "like" with Profiler.

Thanks again,
Dave
DVD Profiler Desktop and Mobile RegistrantStar ContributorFunkyLA
Will you remove your hat?
Registered: March 13, 2007
United Kingdom Posts: 1,136
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting kahless:
Quote:
Quoting Dr. Killpatient:
Quote:
Oh look - mediadogg now has !


Well deserved! 

Lets go for the

Or would that be overkill?
Signature? We don't need no stinking... hang on, this has been done... blast [oooh now in Widescreen]
Ah... well you see.... I thought I'd say something more interesting... but cannot think of anything..... oh well
And to those of you who have disabled viewing of these signature files "hello" (or not) Registered: July 27, 2004
    Invelos Forums->General: General Discussion Page: 1... 5 6 7 8 9 ...13  Previous   Next