I upgraded recently to the new version of Profiler from 2.xx and 290 UPCs were not converted to the new 12 digit format. I opened up the flagged list for those UPCs and per a thread I found in this forum, have started using the Michael's Movie Mayhem site to look up the UPCs and change them to the 12 digit format. So far, every UPC I have edited says it already exists in the central database under that same movie's title. I am curious if there is any reason Profiler would have been unable to automatically convert those UPCs in the original restore? I can't see anything special in those profiles that would have caused them to behave differently from the 3000+ profiles in my collection that the program successfully converted. And the more important question: is there a better way to convert the remaining 290 profiles from the old UPC format to the new one without going one by one, which is going to take me forever? Did anyone ever write a script or plug-in that might augment the program's automated conversion?

I also noticed some of the flagged nonconverted titles are under disc ID only (ie: some of the individual discs in a TV series set). Without physically inserting the disc and changing the disc ID that way, is there no other way to correct this to match the online database?

Yep. I also think it was based on some sort of algorithm. I have even encountered a case where a (Dutch) EAN/UPC was converted wrongly (it included a digit that differed from the actual one) - in the end, this profile had to be re-entered into the Invelos database by Disc ID.

Profiles in the old Intervocative database that had no images were not transferred to the Invelos database.

Regarding your question on Disc ID's: I'm afraid there's no other way than to pop the discs into your DVD-ROM drive one by one, at least not that I'm aware of.

another thing that may help is exploration of the idea that the old 2.x UPC codes were created by throwing away the first and last digit of the 12-digit 3.x UPCs. The goal is to get those two digits back. As noted above, the last digit is a check-digit and can be calculated from the other 11. The problem is that you need the missing first digit.

The first 6 digits (missing one +5 in a 2.4 profile) represent a company code, and are assigned to specific companies. Thus the easiest way to handle a large number of these is to simply sort the list numerically. This will effectively group the UPCs to be converted by company. Then once you discover that, for example, 43396xxxxx should convert to 043396xxxxxy, you can replace the missing first digit (0 in the example) on (hopefully) many UPCs at once.

There are a number of programs on the web to calculate the check-digit (I wrote one myself for convenience when I was making that list in the other thread; you're welcome to it, although it's in php [I meant it was for _my_ convenience ])

Quoting Voltaire53:

Quote:
Quoting FredLooks:

Quote:
There are a number of programs on the web to calculate the check-digit (I wrote one myself for convenience when I was making that list in the other thread; you're welcome to it, although it's in php [I meant it was for _my_ convenience ])

Or if you want to use a web one there is one at:

http://www.barcodeisland.com/ean13.phtml

which also has loads of interesting (well, to sad people like me) data on EAN and other bardcodes.

Or you can do what I've done on occasion - enter the checksum digit one at a time until you get one that Profiler accepts (starting with 0 and working up to 9. Sometimes I've had to do this 9 times before I found the right one. )  I'm gonna try the program you mentioned, Voltaire.  I often want to add a DVD to my wish list but don't have the full UPC.  I may have a scan of the covers (from the Web) but the UPC isn't always legible on those scans.

I found a lot of the unconverted UPCs are adult titles, so it is difficult for me to find the full UPC online as Deepdiscountdvd, etc. don't carry such titles, and they are not part of most online central DVD databases. Either that or they are cheapo dollar-DVD type titles which again are hard to locate online. I can't make out the UPC from the low-res scans that are in my local database for those titles to get that first digit so I can figure out the checksum, so I am a bit stuck until I find the physical DVDs (not easy when you have 3500+ DVDs all stored in a few dozen giant mail bins.)

... or if all else fails ... bring up the back cover of the scan in your database and you will be able to see the 12 digit number right there ... I only had a couple I could not make out.