Quoting CalebAndCo:

Quote:
I am a DVDSpot refugee.

mediadogg:

DVDSpot allowed line returns in the Review field, which in my CSV file caused the data following to go to the next row.  I manually corrected my file, but does your plugin account for this as it could cause problems for some users?

I think it's great you put this together and I plan to utilize it later this week.

BTW (I'm sure you know, but for the others reading this) leading zeros are retained in the CSV file.  If you don't see them, the prg you are using is interpreting the data.

Hmmm ... not sure. I'm using a ready-made Microsoft parser. I'll PM you an email address if you don't mind sending me a sample. (if the review field is enclosed in quotes, it will probably work. I found that when the title field had commas, DVDSpot put quotes around it, and it worked.) By the way, I prefer to get the file untouched. I doubt that I will be successful in handling variations that may occur from manual editing. First I want to make sure I can handle what DVDSPot produces. In another month, that may not matter so much, and then I will focus on making a more general CSV import.

Edit: Ok got the file. Some good news and bad news ...

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!  )

Edit: I found the missing 4 profiles. You have 4 titles with a UPC of "0". I will put in some code to protect against that (as I do for UPC = ""), but you might also want to fix those.

Bad news: I did see some errors. Some bug that made Profiler sick showed up, but the thing kept going I had to stop Profiler after the import was done with Task Manager, but when I restarted DVD Profiler, it was OK again, and the datbase was there.

Refresh from Invelos database took about 20 minutes. 46 profiles failed. I will analyze those UPCs to see if they failed due to missing UPCs in the database or locality errors, and fix whatever I can.

So, it was a good test. Thanks for the data. I will try to code some improvements based on the errors.
You have a bunch of sources (we call them Retailers a.k.a Purchase Places). It is IMPERATIVE that they be defined either (1) ahead of time, (2) After the import but before the bulk update of Purchase Places, or (3) Enter them manually into each profile (yucch, no way).

To get the list of Retailers, Click View My Purchase Places after the import is complete, or you can view the log and print it. Each discovered retailer is posted to the log. You can check them off or cut and paste as you add them manually using Tools\Edit Retailers. Then you can run the BulkEdit "Save Validated Changes" and all the Retailers will be loaded into the profiles - but they have to be defined first due to technical factors. Don't forget to display the Purchase Places column during the import, or you will lose them - they are cached in the datagrid until you can validate and run the update. All the other data is saved on the fly during the import phase.

I will post more news when I analyze the errors.

Hi Mediadogg,

I have tried the plugin, but I must be doing something wrong.  I followed the instructions, and selected only Purchase Place in the BulkEdit dialog box.  When I check the log, it just says "Starting CSV Validation" and does not change.

I am trying to import 500 DVDs into Profiler which used to be listed at DVDSpot.  My exported CSV looks to be fine, first column is UPC.

Thanks,
DD.

@CalebAndCo:

Obviously didn't have time to research all 46 profiles in detail, but the ones I looked at could not be fixed programmatically.

- Several cases of same movie in the Invelos database, but with a different UPC
- A couple of instances where Canadian locality was assigned to a UPC in our database in error. There is a range of UPCs that overlap for Canada and US, but they should be coded locality "0". Instead they are in the Invelos database as locality "3" (also Canada).

That's the kind of good fun you will be having as you reconcile the differences and decide whether to accept the Invelos values or submit changes that you feel are justified and can substantiate. The Canadian locality 3 vs 0 are clearly database errors when they conflict with the CS1 listing. (At least I think so ...  )

I have no way of testing on Vista 64 bit, so I suggest using a 32 bit OS, and see what happens. The fact that it is not hanging suggests that a wierd error just cause the plugin to quit in an unexpected way - therefore no message is displayed. I found some debugging code was still in 1.0. I think I'll upload a version without it and see if that makes a difference (it was writing a small test file to the c:\ drive for test purposes).

Quoting Rooster6975:

Quote:
Quoting mediadogg:

Quote:
I have no way of testing on Vista 64 bit, so I suggest using a 32 bit OS, and see what happens. The fact that it is not hanging suggests that a wierd error just cause the plugin to quit in an unexpected way - therefore no message is displayed. I found some debugging code was still in 1.0. I think I'll upload a version without it and see if that makes a difference (it was writing a small test file to the c:\ drive for test purposes).

Hi,

I'd be happy to test the non-debugged code if you like under Vista 64.  However, I rebooted into XP 32 and it works like a charm.  Successfully imported 477 titles.  Am now running the Online features of DVDP (sorry, just started with this today, can't remember the actual menu items), but it seems to be happily downloading away.  And incidentally, your import was far faster than what you list in this forum.  All 477 titles showed up in DVDP in less than a minute.  Then I selected Online - Refresh Profiles from Invelos, and it happily went off and started grabbing cover art.  There are some gaps where it was unable to find a profile, but I'll figure it out.  The important thing is I see the complete list in DVDP.

Thanks,
DD.

Oh joy            !  (But I wonder why my system is so sluggish ?????)

Quoting Mark Harrison:

Quote:
Quoting 8ballMax:

Quote:
Quoting mediadogg:

Quote:
Thanks all. I benefit every day from the database and the amazing program. Just trying to give a little back. Eagerly awaiting actual results. Hoping for no major bugs. 

I'm surprised that you haven't received that second gold star yet because it's well deserved .

I think should give him a freebie on this one.

mediadogg got the 2nd gold star (and now, I don't have any positive votes left)

Hi Mediadogg,

This may not be the correct forum, but since I have your attention......

The import seemed to work perfectly.  However, when I run from within DVDP "Online - Refresh Updated Profiles from Invelos", about 75% were correctly updated and I have now cover art and all the rest of the details.  About 25% were not.  If I pick one of them from my DVDP list, and choose "Online - Refresh DVD from Invelos --> Refresh PRofile and Images, I get an error message :"Unable to download file.  Continue anyway?"

I am not sure why this is occurring.  I can see the UPC number in my profiler.  When I choose DVD - Add to Collection, and I pick that exact UPC, it finds it!

Any idea why this would be the case?

Thanks,
DD.

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.