Ok, this was a good chance for me to catch a couple of BulkEdit juicey bugs. Snapped them up.

The conversion of your sample file produces a couple of issues. Due to the way manufacturers use their assigned UPC/EAN codes, it is possible to think a DVD was produced for sale in the wrong country. This happens for a few of your titles that appear to have been sold in the Netherlands and Sweden, when in fact they were sold in the UK, and thereby were correctly assigned a UK "Locality" within the Invelos database. BulkEdit provides a way to quickly and easily change the locality for a batch of profiles. DVDP also can do this, one profile at a time. Anyway, I will give you a step by step procedure for the conversion later.

I have a couple of questions before I publish the updated BulkEdit:

(1) Do you want to preserve the "extra features" from CZ? If so, they will appear in the "Notes" field in DVDP. The DVDP "Other Features" field is too small to contain all the CZ info.

(2) Do you want to preserve the IMDB URL and Rating? If so, they will also appear as entries in the Notes field. I am already collecting the CZ "links" entries into the Notes field. When you set Notes to run as HTML, you can just click on the links directly from the Notes panel. DVDP has other built-in fileds for links, but I cannot access them from my plugin, so I just put things into Notes, so at least you don't lose the info.

oh i just exported the large file to xml if you want me to send you a hopy ill be happy to do so

bobbie

ok has been sent , been playing around with profiler , had a few wierd probs to start but ok now , just got to work out what all the screens are for and look at different layouts , hopefully get my head round it all

ok ill have a try

ok came to my forst entry that had no barcode details, so i clicked on the region and tried to edit it , ie put in title and barcode and i got


just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
  at BulkEdit.BulkDataEdit.CellUpdateUtil(IDVDInfo dvdid, Int32 ipdata, Int32 pix, Boolean& DiscInfoFlag, Boolean ReadOnly, Int32& wscol, Int32& wsrow, Boolean addrow, Boolean onedisk)
  at BulkEdit.BulkDataEdit.UpdateGridRow(Int32 wsrow)
  at BulkEdit.DataEdit.editProfileToolStripMenuItem1_Click(Object sender, EventArgs e)
  at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
  at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
  at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
  at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
  at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
  at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
  at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
  at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
  at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
  at System.Windows.Forms.ToolStrip.WndProc(Message& m)
  at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4952 (win7RTMGDR.050727-4900)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
BulkEdit
    Assembly Version: 0.0.0.0
    Win32 Version: 0.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/DVD%20Profiler/plugins/BulkEdit/BulkEdit.DLL
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
4uoc2qn1
    Assembly Version: 0.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Ok, you are going to hit a couple of tough nuts. You know your collection, so you will probably reseolve them more easily that I can. After the dust settled, there were about 70 profiles that did not have a match in the Invelos database. These are evident by the lack of cover images and other data.

The way I fix these, is to flag them, then load them into BulkEdit and do mass changes on any obvious Locality errors. Since it is not my collection, nothing is obvious, so I just changed everything to United Kingdom. Then I went back to DVDP and ran Collection\Flagged\Refresh. This fixed about half.

So, after about 3 hours of mostly automated running of BulkEdit and Invelos download, I have a database with over 1600 Invelos profiles, plus about 40 that are not yet resolved. This means that either they are actually in the Invelos database with a different locality, or entered with a Disk ID instead of a UPC/EAN, or it could be the unlikely case that your movie is not in the database at all. It will be a matter of a bit of research, or just downloading them manually and deleting the bogus ones that got automatically generated, especially for any profiles that give you the error you mentioned before. I found only one. Just delete it, download manually from Invelos by UPC or title, and then update your personal info. Easier to do that, than debug the error for just one profile. Good luck. I'm looking at your database (99%). If you really hit a brick wall, I give you the one I created.

Quoting bobbie crofts:

Quote:
First of all i must thank you for the work you have done , it seems to have done about 90% of the titles which is great, Obviously there are going to be the odd niggle like when i found 2 empty entries in the column with the barcode numbers in , is there any way to insert a barcode number so it doesnt miss a place ?? the rest i will alter slowly as i go through them , it will still be a lot quicker than doing them all , so once again many many thanks for your work

I'm not sure what you are talking about. By barcode number, do you mean collection number? If so, there are some menu items that allow you to renumber. Also, you can assign collection numbers in the Personal Information section. Again, I caution you against editing the skeletion profiles created by BulkEdit. Those profiles need to be filled in by Invelos to be totally functional and valid. If you mean UPC/EAN, you can also change that using the "DVD" menu of DVD Profiler. But the best way is to delete any problem profiles and enter them manually. The skeleton profiles created by BulkEdit are there only to serve as a placeholder for the Invelos download. If the Invelos download doesn't fill in a particular profile, due to a UPC or Locality mismatch, try to fix it only by updating the Locality and/or UPC, then doing a refresh. If you can;t find a match, delete the skeleton and download directly from Invelos by UPC or by Title.

If you want my version of the database, I have a backup - but it may be too bog to email. I got 98%, so I think the difference is a matter of experience in using both DVDP and BulkEdit - to be expected.

Quoting bobbie crofts:

Quote:
Ok have done it as you said and i am left with 82 entries to redo , which is a hell of a lot better than having to redo them all !!!!! I will go through and edit theose ones manually so they wont take to long I must say it is looking pretty good , all i need now is a decent layout as the basic one isnt to my taste and to get to grips with Profiler, once again many many thanks for all your help

Great! For me, it makes the effort worth it, and now we have a verified procedure for the next person. And guess who we all will point to when the next CZ newbie comes along? .... right, you got it - you are the new CZ Conversion Guru!!!!

Oh, by the way, if you notice any patterns to the 82 errors that the conversion code could avoid, let me know, and I will tweak the code accordingly.