| Author |
Message |
| Registered: May 22, 2007 | Reputation:  |  Posts: 1,033 |
| | Posted: | | | | 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 |
|
| Registered: March 28, 2007 | | Reputation: |  Posts: 1,299 |
| | Posted: | | | | 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 |
|
| Registered: May 22, 2007 | | Reputation: | | Posts: 1,033 |
| | Posted: | | | | 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 |
|
| Registered: March 13, 2007 | Reputation:  | | Posts: 3,321 |
| | Posted: | | | | 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. |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 2,217 |
| | Posted: | | | | 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 |
|
| Registered: March 28, 2007 | | Reputation: | | Posts: 1,299 |
| | Posted: | | | | 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=pluginsKM | | | 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 |
|
| Registered: May 22, 2007 | | Reputation: | | Posts: 1,033 |
| | Posted: | | | | 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 |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,217 |
| | Posted: | | | | 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 |
|
| Registered: May 22, 2007 | | Reputation: | | Posts: 1,033 |
| | Posted: | | | | 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 |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,217 |
| | Posted: | | | | 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 |
|
| Registered: March 13, 2007 | | Posts: 21,610 |
| | Posted: | | | | 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 |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,005 |
| |
| Registered: March 13, 2007 | | Posts: 21,610 |
| | Posted: | | | | 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 |
|