Author |
Message |
Registered: January 9, 2008 | Posts: 2 |
| Posted: | | | | Has anyone come up with an easy way to do a DVD audit? It would be great to just use a scanner and hit every dvd, then have the system report which ones are missing or not entered in dvd profiler? |
|
Registered: March 13, 2007 | Reputation: | Posts: 5,494 |
| Posted: | | | | not too sure what it is you are asking,, but if it isn't in Profiler it probably can't find what is missing from what you bought the last few months to what is in data base.. What I could and would use is an electronic cheque book or bank statements., every time I would charge or pay cash for new DVD's I use the cheque book to deduct the funds from my account.. when I do this there is an area for notes ., in this area for notes I would put what titles I bought. then after a few weeks you could cross-check the bank program to your library first hand on the screen and see if all is copacetic. | | | In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.
Terry |
|
Registered: January 9, 2008 | Posts: 2 |
| Posted: | | | | what i want to do is basically use a barcode scanner, and scan every title in my library, dont check them or anything, just scan them. Then at the end have a report produced that would check against the database and list which ones were not scanned, and it could also list which ones were scanned but no in the system yet. |
|
Registered: March 13, 2007 | Reputation: | Posts: 5,494 |
| Posted: | | | | If you supply your list to Invelos ( backup ) not the backup on your harddrive, when you go the add a DVD and use thesame upc ( via the bar code) it will know if that title is part of your collection or not, it knows ( with little icons) whether the title is owned, ordered or wishlisted.. Hope this helps. | | | In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.
Terry |
|
Registered: March 13, 2007 | Reputation: | Posts: 2,217 |
| Posted: | | | | I would go the road to Excel: Get the CSV-Export-Plugin, export Titles and UPC. Now scan all your DVDs, store the UPCs in a text-file. Open both files in Excel (File - Open, not by double-click), be careful to mark the UPC columns as text and sort by UPC and paste the scanned UPCs next to the UPCs of Profiler. Now compare away, if you want you could use something like: =IF(B1=C1;"";"!!!")(hope 'if' is right, I have the german Excel where this would be 'wenn') cya, Mithi | | | Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki |
|
Registered: March 13, 2007 | Reputation: | Posts: 13,202 |
| Posted: | | | | The program does not have a built in inventory feature...though it would be nice. When I moved, I had to do it all by hand. | | | No dictator, no invader can hold an imprisoned population by force of arms forever. There is no greater power in the universe than the need for freedom. Against this power, governments and tyrants and armies cannot stand. The Centauri learned this lesson once. We will teach it to them again. Though it take a thousand years, we will be free. - Citizen G'Kar |
|
Registered: May 26, 2007 | Posts: 117 |
| Posted: | | | | I resorted to a low tech method. I used my Ptouch and numbered my collection so all I have to do is look for the missing number. Once I buy a movie it stays on my desk until I enter it into the database. |
|
Registered: March 17, 2007 | Posts: 43 |
| Posted: | | | | Actually there used to be a plugin that would do exactly what you want. It was called upcFilter, by user Tlevel. I still have it installed on my program. Not sure where to get it now. The file is called upcfiltercontroll.dll. I would think that someone here still has the install file for it.
You get a small window that you scan the barcode into, and it flags the scanned DVD. When finished, just show the unscanned DVDs and those are missing. |
|
Registered: March 13, 2007 | Posts: 793 |
| Posted: | | | | Quoting Cary B: Quote: Actually there used to be a plugin that would do exactly what you want. It was called upcFilter, by user Tlevel. I still have it installed on my program. Not sure where to get it now. The file is called upcfiltercontroll.dll. I would think that someone here still has the install file for it.
You get a small window that you scan the barcode into, and it flags the scanned DVD. When finished, just show the unscanned DVDs and those are missing. It is hosted on mediadogg's website, as reported in this thread |
|