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->General: General Discussion Page: 1  Previous   Next
Find titles with missing cast/images? And other Q's
Author Message
DVD Profiler Unlimited RegistrantSPIDERone
Registered: April 16, 2008
Posts: 24
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I've looked for information on this but couldn't find any, unfortunately.

A few questions -

* Can I filter out only titles with missing cast (no cast at all), coverart (either front, rear, or both), or other missing details? So I can go back and add it now.

* When using a custom format (PSP UMD), I created a "banner" for the top of the coverart. I have the option to turn it on/off for each title (good for those coverarts with the banner included). If I have a coverart with banner included on the original art, even if I turn the banner off.. it still displays in the "grid" (so it looks like a double-banner). On the actual coverart preview, it only shows the one from the coverart. Basically the banner is applying to all coverarts, whether it needs them or not.

* I created a custom logo for the UMD - it looks like in DVD Profiler, but on the mobile app (iPad/iPod) it gets squished. Is there a specific resolution I should be using to keep it "normal" looking?
DVD Profiler Unlimited RegistrantStar ContributorDanae Cassandra
Registered: Apr 11, 2004
Registered: May 26, 2007
Reputation: Great Rating
United States Posts: 2,878
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Can't answer the last two for you, but for the first question you will want a plugin called Database Query that was created by Mark Harrison.  It's a fabulous plugin that will let you query for all sorts of missing data.  And that's only scratching the surface of what it can do.

I love it and use it regularly.

You can get it here: http://mysite.verizon.net/MEJHarrison/Plugins/Plugins.htm
If more of us valued food and cheer and song above hoarded gold, it would be a merrier world.
-- Thorin Oakenshield
DVD Profiler Desktop and Mobile RegistrantStar ContributorTheMadMartian
Alien with an attitude
Registered: March 13, 2007
Reputation: Highest Rating
United States Posts: 13,201
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Quoting SPIDERone:
Quote:
* I created a custom logo for the UMD - it looks like in DVD Profiler, but on the mobile app (iPad/iPod) it gets squished. Is there a specific resolution I should be using to keep it "normal" looking?

I created custom images for some of my collections as well.  The images were, 128 x 128 and 32 x 32.  Oddly enough, the larger one is used for the mobile app.
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
DVD Profiler Unlimited RegistrantSPIDERone
Registered: April 16, 2008
Posts: 24
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Thanks! I'll try that. Mine seem to be getting "squished" on the "main" section of the DVDProfiler app, but look fine in the side listing.

I tried the Database Query but I can't find a way to search for titles missing cast - can you help me with setting that up? The coverart scan worked great though!
DVD Profiler Unlimited RegistrantStar ContributorLewis_Prothero
Strength Through Unity
Registered: May 19, 2007
Reputation: Superior Rating
Germany Posts: 6,730
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting SPIDERone:
Quote:
I tried the Database Query but I can't find a way to search for titles missing cast


AFAIK it can't do that.
Currently the only solution for your problem would be a manual scan through your collection-list.
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
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting SPIDERone:
Quote:
* Can I filter out only titles with missing cast (no cast at all), coverart (either front, rear, or both), or other missing details? So I can go back and add it now.

There is a possibility with XML/XSLT if you are up to it:

Make a XML-Export of your collection (File -> Export Profile Database -> Accept -> Single File) and put it e.g. to \Users\$Username\Documents\DVD Profiler\
copy the filter.xslt at the bottom of this post and save it to the same directory.
Now get DJ Doena's excellent XsltTransform and put the two small files in the same directory as the XML and the XSLT. Run the EXE and a window pops up with three queries: XML and XSLT should be obvious, as Output-file I suggest you navigate to DVD Profiler\Flags and name it e.g. no-actors.lst
Press "Process" and wait a few seconds depending on the size of your collection.

Now go back the Profiler and go to Collection -> Flags -> Load Set and choose the saved no-actors.lst and et voila, all titles with less than one Actor-Entry get flagged.
You can of course set the number higher for entries with suspicious few Actors or look for Credits/Credit to find profiles with no crew etc.

Only "no coverart" can't be done with this, just open the "\Users\$Username\Documents\DVD Profiler\Databases\$Databasename\Images\"-folder and look for the generic placeholder picture.

cya, Mithi

filter.xslt:
<?xml version="1.0" encoding="ISO-8859-1"?>

<!-- ***************
    by Michael 'Mithi' Cordes ( http://www.dvd-welt.de/privat/xsl.html ) 22.06.2011
    DVD Profiler Version 3.7
    *************** -->

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

<xsl:output method="text" encoding="ISO-8859-1"/>

<xsl:template match="Collection">
  <xsl:apply-templates select="DVD"><xsl:sort select="ID"/></xsl:apply-templates>
</xsl:template>

<xsl:template match="DVD">
  <xsl:if test="CollectionType='Owned' and count(Actors/Actor)&lt;1">
    <xsl:value-of select="ID"/>
    <xsl:text>&#xa;</xsl:text>
  </xsl:if>
</xsl:template>

</xsl:stylesheet>
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited RegistrantStar ContributorDanae Cassandra
Registered: Apr 11, 2004
Registered: May 26, 2007
Reputation: Great Rating
United States Posts: 2,878
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Silence_of_Lambs:
Quote:
Quoting SPIDERone:
Quote:
I tried the Database Query but I can't find a way to search for titles missing cast


AFAIK it can't do that.
Currently the only solution for your problem would be a manual scan through your collection-list.

Oh, I'm sorry.  I really thought it could, because it can search for other empty fields.
If more of us valued food and cheer and song above hoarded gold, it would be a merrier world.
-- Thorin Oakenshield
DVD Profiler Unlimited RegistrantCalebAndCo
Ralphie shot first.
Registered: October 6, 2008
United States Posts: 1,932
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I set up tags for missing data, then went through my collection once to set them for each profile as appropriate.  Now, when I am in the mood to work on scans or credits, I filter on the tag and pick a profile to work on.
    Invelos Forums->General: General Discussion Page: 1  Previous   Next