|
|
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: New Users Forum |
Page:
1 2 3 Previous Next
|
Other Databases |
|
|
|
Author |
Message |
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | 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. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: October 28, 2010 | Posts: 36 |
| Posted: | | | | i would like to keep as much info as possible i can allways edit them afterwards i hope dont worry to much if they cant be added i will have to go through each one individually later i think
anyeway thank you for all your work and help |
| Registered: October 28, 2010 | Posts: 36 |
| Posted: | | | | 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 | | | Last edited: by bobbie crofts |
| Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Quoting bobbie crofts: Quote: 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, cool. I can probably do the whole thing in less time than it would take to type up a set of clear instructions for you. I don't usually do this, but this is a good chance for me to improve my CZ import function, as it was done quite awhile ago. (Edit: No more trick or treaters knocking. Going to bed. Maybe the file will arrive tomorrow ... ) (Edit: woke up to lots of email from friends and family - still no file from bobbie - maybe send again?) | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: October 28, 2010 | Posts: 36 |
| Posted: | | | | 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 |
| Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Quoting bobbie crofts: Quote: 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 Not sure what is going on with this. Never got the file. So, I released BulkEdit 2.18, whch correctly converts your sample XML file (note that you had created an extraneous "?" at the beginning of the file. Make sure you don't disturb the CZ format in the future). In BulkEdit, Load the XML file with the Locality field checked. Make any required changes to Locality (in the sample, I had to change a few titles from Nettherlands to UK, and 1 from Sweden to UK - this takes a matter of seconds). Then run "Save Validated Changes". Exit BulkEdit and Run Online\Refresh Updated Profiles From Invelos. Depending on your network speed, the whole process start to finish takes about 1 minute per 5 - 10 profiles. You can do this in a new database or load into an existing one. Just make sure you backup first, just in case. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: October 28, 2010 | Posts: 36 |
| Posted: | | | | ok ill have a try |
| Registered: October 28, 2010 | Posts: 36 |
| Posted: | | | | sorry if i seem a bit thick, ok i have entered all the films as you said (1105) so took a while so what do i do to change it from say Sweden to United kingdom please?? |
| Registered: October 28, 2010 | Posts: 36 |
| Posted: | | | | 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. |
| Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | You should have followed the exact sequence I gave you. Sounds like you didn't run the Invelos update as I specified. I won't try to debug errors that occur unless you follow the directions. If you want, you can delete all that error info to reduce thread clutter. Hopefully, you won't hit that error again. When finished, your profiles will be complete. Everything gets downloaded for you. That's the real power of DVD Profiler. All your personal data will have been preserved. There will be no need to edit any regions or anything else except personal data, once this is complete.
Again, here is what to do (sample times are on my laptop, connected Wi-Fi)
(1) Load the XML file with the Locality field checked. (40 minutes) (2) Use the MultiCopy Tool 2 Find/Replace to change Sweden and Netherlands to United Kingdom (5 minutes). Your cursor should be somewhere in the Locality column before clicking the MultiCopy menu. (3) Run "Save Validated Changes". (1 min) (4) Exit BulkEdit (5) Run Online\Refresh Updated Profiles From Invelos. ( Nearly 2 hours and still running on my system). All profiles downloaded OK, but now the child profiles are being automatically downloaded. (6) Backup the database (7) Now you can begin to use the database in a normal way - but not before, as you found out the hard way.
There still could be some loose ends, for example if you have a network error during download. This is easy to recover from by jusr re-running the download for any profiles that didn't get completely updated. Or re-run the whole thing again. Only the missing bits will come down the second time. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | 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. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: October 28, 2010 | Posts: 36 |
| Posted: | | | | 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 |
| Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | 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. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: October 28, 2010 | Posts: 36 |
| Posted: | | | | 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 |
| Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | 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. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: October 28, 2010 | Posts: 36 |
| Posted: | | | | The blank entries that it found was due to the original cz file not having the barcode/upc entry when it was exported |
|
|
Invelos Forums->General: New Users Forum |
Page:
1 2 3 Previous Next
|
|
|
|
|
|
|
|
|