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->DVD Profiler: Layouts and Reports Page: 1  Previous   Next
Report with total runtime
Author Message
DVD Profiler Desktop and Mobile RegistrantAgrare
Registered: May 22, 2007
Reputation: High Rating
United States Posts: 1,033
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I didn't see it, but is there anyway to get total runtime on a report? And if not, consider this a feature request for total runtime

-Agrare
DVD Profiler Unlimited RegistrantAstrakan
Registered: Feb 12, 2000
Registered: March 28, 2007
Reputation: High Rating
Canada Posts: 1,299
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
The Running Time data field is available under the Content->DVD tabs when creating/editing a report.

And if you're only after a quick listing of all your movies with runtime displayed, there's also the option of adding a runtime column to the title listing in the main program. This has the added benefit of being able to sort by runtime.

KM
Tags, tags, bo bags, banana fana fo fags, mi my mo mags, TAGS!
Dolly's not alone. You can also clone profiles.
You've got questions? You've got answers? Take the DVD Profiler Wiki for a spin.
 Last edited: by Astrakan
DVD Profiler Desktop and Mobile RegistrantAgrare
Registered: May 22, 2007
Reputation: High Rating
United States Posts: 1,033
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Sorry, when i said total runtime, I meant for the whole collection. I saw that I can add the runtime to the report, but I would like to see the total runtime for all my dvds (similar to total SRP).

-Agrare
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
I've done this in the past by exporting to a CSV file and totaling the runtime in Excel.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
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 Agrare:
Quote:
I didn't see it, but is there anyway to get total runtime on a report? And if not, consider this a feature request for total runtime

If you are comfortable with XSLT:
<xsl:value-of select="sum(/Collection/DVD[CollectionType='Owned']/RunningTime)"/>
could do the trick as a workaround.

But there is always the problem with boxsets. Of the parent and the childs have runtime they will screw up the result. I have solved that by setting the RT of Boxset parents to 0.

cya, Mithi

PS
unwatched: 13854 minutes
watched: 98129 minutes
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited RegistrantAstrakan
Registered: Feb 12, 2000
Registered: March 28, 2007
Reputation: High Rating
Canada Posts: 1,299
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
I've done this in the past by exporting to a CSV file and totaling the runtime in Excel.

Good idea. And in case someone reading this is unaware, you need the CSVExport plugin in order to export a CSV file. The plugin is available here:

http://www.invelos.com/Downloads.aspx?display=plugins

KM
Tags, tags, bo bags, banana fana fo fags, mi my mo mags, TAGS!
Dolly's not alone. You can also clone profiles.
You've got questions? You've got answers? Take the DVD Profiler Wiki for a spin.
 Last edited: by Astrakan
DVD Profiler Desktop and Mobile RegistrantAgrare
Registered: May 22, 2007
Reputation: High Rating
United States Posts: 1,033
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Mithi:
Quote:
Quoting Agrare:
Quote:
I didn't see it, but is there anyway to get total runtime on a report? And if not, consider this a feature request for total runtime

If you are comfortable with XSLT:
<xsl:value-of select="sum(/Collection/DVD[CollectionType='Owned']/RunningTime)"/>
could do the trick as a workaround.

But there is always the problem with boxsets. Of the parent and the childs have runtime they will screw up the result. I have solved that by setting the RT of Boxset parents to 0.

cya, Mithi

PS
unwatched: 13854 minutes
watched: 98129 minutes


Ok, I hadn't worked with xsl before, but after some quick research I got a basic understanding and managed to get what i wanted.

However, i then tried to expand on it, and was wondering if I can select out only dvds with a certain tag. Along the lines of how you only select owned dvds. But the xml for tags is set up a bit differently.

-Agrare
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 Agrare:
Quote:
However, i then tried to expand on it, and was wondering if I can select out only dvds with a certain tag. Along the lines of how you only select owned dvds. But the xml for tags is set up a bit differently.

Easy as pie #cough, cough# Code re-use rulez:

<xsl:value-of select="sum(/Collection/DVD[Tags/Tag[@Name = 'Criterion']]/RunningTime)"/>

Would get you the accumulated RTs of all <DVD> with the Tag 'Criterion'. And it doesn't matter if the Tag is a Child-tag or not, because I use 'Name' and not 'FullName'

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Desktop and Mobile RegistrantAgrare
Registered: May 22, 2007
Reputation: High Rating
United States Posts: 1,033
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
figured i'd post some of what I found.

You can filter out box set parent profiles with something like this (this gets total runtime of your owned collection, but doesn't include box set parents)

<xsl:value-of select="sum(/Collection/DVD[CollectionType='Owned'][BoxSet/Contents='']/RunningTime)"/>

I also use a for-each to display all the titles with their run time. and then have a choose inside the for-each that allows me to only print out the titles that I am totaling the run time for. You could do a for-each and use the same branch in the select (ie: select="Collection/DVD[CollectionType='Owned'][BoxSet/Contents='']" ) but i found that using the choose makes it to deal with != when working with tags (ie, the profile doesn't have a specific tag)

-Agrare
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 Agrare:
Quote:
<xsl:value-of select="sum(/Collection/DVD[CollectionType='Owned'][BoxSet/Contents='']/RunningTime)"/>

Nice. Shows some little inconsistencies for me because some of my Boxsets doesn't have the Childs they are supposed to have, as soon as that is cleared up it should work like a charm.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited RegistrantStar ContributorWinston Smith
Don't be discommodious
Registered: March 13, 2007
United States Posts: 21,610
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
If such a report were available, i would be scared to death to run it. 



Skip
ASSUME NOTHING!!!!!!
CBE, MBE, MoA and proud of it.
Outta here

Billy Video
 Last edited: by Winston Smith
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
SQL query on my collection tells me:
277 days 4 hrs 2 min


DVD Profiler Unlimited RegistrantStar ContributorWinston Smith
Don't be discommodious
Registered: March 13, 2007
United States Posts: 21,610
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Which means by dead reckoning, I should be somewhere around 600 days. 

Skip<shivers>
ASSUME NOTHING!!!!!!
CBE, MBE, MoA and proud of it.
Outta here

Billy Video
    Invelos Forums->DVD Profiler: Layouts and Reports Page: 1  Previous   Next