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->Posts by DaveM Page: 1  Previous   Next
Message Details
I am impressed with the usefulness of Mark Harrison's plugin Database Query.  Within minutes of firing it up in DVD Profiler 4, among the 2645 items in my collection, I have created Flag Sets for: UPCs missing cover art (29 items), cover art that is duplicated for front and back (20), media type of Bluray-combos (27 BR/DVD combos), and duplicate titles (174).  Not that I needed more work to do, but DBQuery will ease winnowing the chaff. 

I also like the aggregate queries, such as Production Year by Decade and Media by Type; the last of which showed a Jack Benny Show DVD labeled as a 4K UltraHD combo....... not likely.  (It was a matter, when adding this Jack Benny DVD as a new contribution, the media type defaulted to DVD, Bluray & 4K, which went unnoticed by me until running DBQuery.)  Handy tool. 

I like the tool so much I will be making a donation to the cause shortly. Thanks Mark for a nice utility.
Posted:
Topic Replies: 1, Topic Views: 58
I would like to correct a typo in my recent post about importing UPC numbers via a text file.  Do I need to contact a forum moderator to enable edits after three days have past since OP?  What are the steps to edits?

thanks

Dave
Posted:
Topic Replies: 1, Topic Views: 107
Thank you, Mithi, for your tip to export and then import a couple of flagged items in my existing collection.
That tip worked fine and pointed to the source of the problem: text file type.  My original source of UPC numbers was a .CSV file output from the UPC-to-Sheet smartphone app.  I imported this to into Excel, stripped out all column data other than the UPC column and then exported that as a Unicode text file.

Apparently, among the harem of text file choices, DVD Profiler treats the Unicode (UTF-16) format as uniquely impotent, refusing to touch such a file.  A text-file compare in Beyond Comparison 4 of the two text files, one an ANSI file and the other a Unicode file, that contains the exact same info - one UPC number shows a difference of 14 bytes in the file size, but is otherwise the same. The former imported and set a flag in DVD Profiler just fine, the latter did not.  Go figure.

Thanks also to you, Gunar, for your tip about putting the list of UPC numbers into the clipboard and pasting into the Flag-by-UPCs list box.  That process also worked nicely.

Again I am impressed by the devotion to an avocation found here on the Invelos forum.  I have enjoyed greatly both the product and the community support since I began using DVD Profiler a number of years ago.

Thanks for the tips leading to solving the Case of the Impotent Import.

Dave
Posted:
Topic Replies: 4, Topic Views: 276
I am trying to flag profiles of DVDs that are currently at the in-laws.  Rather than bring the DVDs to my place to scan their UPCs, I scanned the UPCs at their location (using a Smartphone app) and then tried to select the resultant text file of UPC numbers.  The Flag by UPCs dialog box (Collection->Flags->Flag by UPCs) does let me select the text file, but when I click on "Open", the file dialog closes, but nothing else happens - no error message and no list of UPC numbers appear in the Flag by UPCs dialog box.

I have tried this process with a text file that contains several UPC numbers, one number per line, as well as a text file with only one UPC number.  Neither work.

I have also tried importing these scanned UPC numbers using the Add Multiple dialog box (on the Add DVDs to Collection screen) with the same failure - I can select the import text file, but when I click on Open, the file dialog closes and no other action takes place.

In both test cases, the OK button in the dialog box remains dimmed as the UPC list remains empty.

I am using version 4.0.0, Build 1762 of DVD Profiler on my desktop PC.  (Upgraded this week to version 4 after successful run of "Repair Profile Database" on the Option/Utilities menu. as per upgrade instructions)

Am I missing something simple?

Thanks for any tips or workarounds,

Dave
Posted:
Topic Replies: 4, Topic Views: 276
Invelos Forums->Posts by DaveM Page: 1  Previous   Next