| Registered: June 8, 2012 | | Posts: 1 |
| | Posted: | | | | I have them in an Excel Spreadsheet now, there are no upcs. I'm not keen on scanning them all, so what is the best way to import them.
Thanks! |
|
| Registered: May 19, 2007 | Reputation:  |  Posts: 6,730 |
| | Posted: | | | | Hi tzkatz!
Welcome to this forums.
DVDProfiler basically uses two different identifiers for it's database. These are UPC (or EAN) and the DiscID.
If your spreadsheet has neither I'm afraid there's no other way than having to scan them all, provided you have a barcode-scanner. If you don't have one, you'd have to enter the UPCs manually, which can take some time when having to enter 2000 of them. | | | It all seems so stupid, it makes me want to give up!
But why should I give up, when it all seems so stupid?
Registrant since 05/22/2003 |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,217 |
| | Posted: | | | | Quoting lzkatz: Quote:
I have them in an Excel Spreadsheet now, there are no upcs. I'm not keen on scanning them all, so what is the best way to import them. As Lewis_Prothero already mentioned: DVD Profiler is based on UPCs, so the least painful way is entering them by UPC. If you have a barcode-scanner[1] or a smart-phone[2] it shouldn't be to much hassle. Another question: do you have any additional, personal data in this spreadsheet that you want to carry over? If so, can you provide a sample? In that case you would have to employ the help of the Plugin "BulkEdit". Feel free to ask, I'm willing to help you with the transition. cya, Mithi [1] a "Cue-Cat" if you still can get one cost ~5-10USD and believe me that you will be glad to spend those few bucks. [2] 'barcode2file' for Android and something similar should exist for iPhone | | | | Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki |
|
| Registered: March 18, 2007 | Reputation:  |  Posts: 6,455 |
| | Posted: | | | | I have some experimental unreleased tools that can import based on title. Needless to say, the results are not perfect.
The tool works best when:
(1) The "locality" is known
(2) Other information, such as Release Date or Rating is available along with the title
(3) Your title is a close match to the actual DVD title
The tool uses proprietary matching techniques and a proprietary database that I have been trying to negotiate the use of. But I can use it for one-time, exprimental purposes. The database is for the US locality only, but sometimes the Invelos database entry can be found by simply using the same UPC with the desired locality.
So, if you, with Mithi's help, want to prepare a CSV file of your data, PM me, and I can tell you what the format should look like.
Last time I did this for somebody, he was upset that I could not do 100%, so it was a total waste of time. I'm happy to give it a shot, if you accept the reality that without the UPC, the results will not be perfect - just a head start, due to the inability to totally resolve locality issues, errors in the title match, and cases where discID is used instead of UPC to identify the DVD in the Invelos database. | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. | | | | Last edited: by mediadogg |
|