Author |
Message |
Registered: April 1, 2007 | Posts: 185 |
| Posted: | | | | I'm thinking about rescanning my entire 2300+ collection from scratch. I know, over the years, there have been things missed, lost and replaced/sold, but not removed that have never been updated in my DB and figure this is probably the most efficient way to fix all of that in one swoop. How would I go about purging my current DVDP database? | | | Last edited: by 69samael69 |
|
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| Posted: | | | | Quoting 69samael69: Quote: How would I go about purging my current DVDP database? File -> Open Database -> New Database | | | Karsten DVD Collectors Online
|
|
Registered: April 1, 2007 | Posts: 185 |
| |
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| Posted: | | | | Quoting 69samael69: Quote: Thanks. Just an FYI: That does not remove your old database. It just creates a new one in parallel. This way you can setup your collection from scratch while still having the old one lying (laying?) around. | | | Karsten DVD Collectors Online
|
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | BulkEdit has a little function called "ScrapeGoat" - icon looks like binoculars.
With it, you can view your old online collection from your new database and just put a check mark against those DVDs that you want to keep. No need to re-scan. Once you have checked them, you click Scrape with "Add to Collection", whatever category you want. At your convenience, you need to run a download / refresh from the online, because ScrapeGoat only puts in the minimum skeleton profile to get you started. Or, you can click "Refresh Flagged" and ScrapeGoat will issue the download command for you.
Maybe will save some scanning?
By the way, this works for any online collection - just type in the user name. Only thing the plugin is doing is grabbing the profile ID and basic info to create the skeleton. It does not use any personal data.
Another way to get "clean" copies of the online profiles, is to create a "Flag Set" from the old database, of the ones you want to keep. Then, from the new database, you can "Add multiple" and use the Flag Set file, which is just a list of profile IDs.
Hopefully, you can get a good head start on the new database by doing a bit of an audit and just checking off the physical DVDs that you want to keep in the new database. Then go ahead with your scanning of the others. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
|
Registered: April 1, 2007 | Posts: 185 |
| Posted: | | | | Thanks MediaDog. The big problem I have is that I've never rescanned in the 15-16 years I've been using DVDP. I know I've lost things or sold things that I've never removed and I'm sure there's probably stuff there that I've bought and forgot to add. I also know that early on, if I came across titles that didn't exist, common for Canadian versions back in the early days, I would just find a different UPC that matched, and I'd like to fix those as well. Even now, it's not uncommon, but I create the profiles now. | | | Last edited: by 69samael69 |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Right, just trying to save you a bit of work. Sounds like the big picture is that you are really doing an audit. In that case, if you have pile of DVDs in front of you, as you pick one up, you could either scan it immediately, or take a peek at the checklist and click on the items that match the DVDs. And then scan the remainder. Then pick up another batch of DVDs. Something like that? I'm not entirely sure which would be faster. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
|
Registered: March 14, 2007 | Reputation: | Posts: 950 |
| Posted: | | | | At one time, there was a plugin that was designed to help you audit your discs. You'd use a scanner to read the bar codes and it would compare it to your database. It would show UPCs that were not in the database and show ones that hadn't been re-scanned. I only audited mine once and it's been quite awhile but I know I found a handful of titles like you mentioned-ones where I must have just picked a title that was close to mine. It also found a couple that hadn't been added. I'm pretty sure it did export files into another program, excel maybe? but I'm not 100% sure.
I wish I could remember the name of it, but over the years, I seem to have deleted it or lost it from my copy of Profiler. I did a quick search for it, but nothing popped up: maybe someone will remember from my description? | | | Lori |
|
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| Posted: | | | | Quoting LJG: Quote: At one time, there was a plugin that was designed to help you audit your discs. You'd use a scanner to read the bar codes and it would compare it to your database. DVD Inventory? | | | Karsten DVD Collectors Online
|
|
Registered: April 1, 2007 | Posts: 185 |
| Posted: | | | | Quoting LJG: Quote: At one time, there was a plugin that was designed to help you audit your discs. You'd use a scanner to read the bar codes and it would compare it to your database. It would show UPCs that were not in the database and show ones that hadn't been re-scanned. I only audited mine once and it's been quite awhile but I know I found a handful of titles like you mentioned-ones where I must have just picked a title that was close to mine. It also found a couple that hadn't been added. I'm pretty sure it did export files into another program, excel maybe? but I'm not 100% sure.
I wish I could remember the name of it, but over the years, I seem to have deleted it or lost it from my copy of Profiler. I did a quick search for it, but nothing popped up: maybe someone will remember from my description? Thanks. That would be nice, then I wouldn't lose things like date added and sequence number, place of purchase, things like that. I'll check out the DVD Inventory thing DJ Doena mentioned and see if it does what I need. | | | Last edited: by 69samael69 |
|
Registered: March 14, 2007 | Reputation: | Posts: 950 |
| Posted: | | | | Quoting DJ Doena: Quote: Quoting LJG:
Quote: At one time, there was a plugin that was designed to help you audit your discs. You'd use a scanner to read the bar codes and it would compare it to your database.
DVD Inventory? Maybe? Sorry, just saw this... It's truly been enough time that I really don't remember what the program looks like. It did seem similar, though. I know I was able to use a scanner with it and it made checking a whole lot easier than going one by one! | | | Lori |
|
Registered: May 19, 2007 | Reputation: | Posts: 5,917 |
| Posted: | | | | What I did was to flag any disc I scanned and then moved it to a new category. Anything left over was missing. |
|