Personal Video Database
English => Support => Topic started by: mntzion2000 on April 22, 2012, 04:16:36 am
-
Hey,
I was wondering if there was a way to make a list of movies in ALFA order that also includes the ID# so that i may print it. I can only seem to export what ever current view that i am using. IE if i have it set to ID# then when i export it, it shows ID# in order, but not ALFA. And if i have it set to Title then it does it in ALFA, but does not show the ID# on the report.
I would like to be able to have my list printed in ALFA order and then see the ID# assigned to that particular movie.
Thanks,
Rob~
-
The records are exported in the order they appear in the list. The details for each record are determined from the template used. Just add or edit one to produce the output you want. A simple one would be...
%OPTIONS%
filter="Text Files|*.txt"
encoding="UTF8BOM"
%OPTIONS%{%value=title} ({%value=year}) {%value=num}
-
thank you for the response and please for give my ignorance, but where and how would i apply that code to make the change?
-
Preferences > Plugins > Plain text > Add...a template. Select the 'Edit template' tab and paste the code.
-
so am i adding to the existing one, or creating a new one?
-
You can do both there
-
OK, so clearly i'm doing something wrong, when i go an add the code you wrote to the already existing code, this is what i get.
%OPTIONS%
filter="Text Files|*.txt"
encoding="UTF8BOM"
%OPTIONS%10,000 Bc (2008) 3352. 101 Dalmatians / 101 Dalmatians (1996) [Family, Comedy, Adventure]
But if just paste the code you wrote by itself it looks like this.
10,000 Bc (2008) 335101 Dalmatians (1996) 83812 Rounds (2009) 612127 Hours (2010) 91916 Candles (1984) 58217 Again (2009) 5512012 (2009) 59627 Dresses (2008) 2793 Idiots (2009) 92830 Days Of Night (2007) 397300 (2006) 43:10 To Yuma (2007) 2004 Christmases (2008) 499500 Days Of Summer (2009) 58388 Minutes (2008) 4089 (2009) 584A Bugs Life (1998) 555A Charlie Brown Christmas (1965) 711A Christmas Carol (1953) 19A Christmas Carol (1999) 493A Christmas Story (1983) 14A Few Good Men (1992) 425A Knights Tale (2001) 404A Man Apart (2003) 120A Mighty Heart (2007) 151A Perfect Get Away (2009) 592A Perfect Getaway (2009) 659A Scanner Darkly (2006) 71A Very Harold & Kumar 3D Christmas (2011) 865A Warrior's Heart (2011) 858Abduction (2011) 861Ace Ventura: When Nature Calls (1995) 342Across The Universee (2007) 115Adam (2010) 771After Life (2009) 774Alice In Wonderland (2010) 634All About Steve (2009) 750All's Faire In Love (2009) 855Alpha Dog (2006) 98Alvin And The Chipmunks (2007) 258Alvin And The Chipmunks (2009) 597Amazing Grace (2007)
What i'm looking for is for it to look like this next paste, but with the ID number added to it, that' all.
1. 10,000 Bc / 10,000 BC (2008) [Adventure, Romance] (ID NUMBER HERE)
2. 101 Dalmatians / 101 Dalmatians (1996) [Family, Comedy, Adventure]
3. 12 Rounds / 12 Rounds (2009) [Action, Crime, Thriller]
4. 127 Hours / 127 Hours (2010) [Adventure, Biography, Drama, Thriller]
5. 16 Candles / Sixteen Candles (1984) [Comedy, Romance]
6. 17 Again / (2009) [Comedy]
7. 2012 / 2012 (2009) [Action, Adventure, Drama]
8. 27 Dresses / 27 Dresses (2008) [Romance, Comedy]
9. 3 Idiots / 3 Idiots (2009) [Comedy, Drama, Romance]
10. 30 Days Of Night / (2007) [Horror]
Thanks for your help, i know ill figure it out sooner or later with your help :)
-
%OPTIONS%
filter="Text Files|*.txt"
encoding="UTF8BOM"
%OPTIONS%{%value=title} / {%value=origtitle} ({%value=year}) [{%value=genre}] {%value=num}
Be sure to include the line feed at the end. That's why your result did not have each item on a separate line. If it's possible to number the lines, I don't know how.
-
Ok, so that worked with this code;
%OPTIONS%
filter="Text Files|*.txt"
encoding="UTF8BOM"
%OPTIONS%{%value=203}. {%value=title} / {%value=origtitle} ({%value=year}) [{%value=genre}] {%value=num}
in which gives this result;
1. 10,000 Bc / 10,000 BC (2008) [Adventure, Romance] 335
2. 101 Dalmatians / 101 Dalmatians (1996) [Family, Comedy, Adventure] 838
3. 12 Rounds / 12 Rounds (2009) [Action, Crime, Thriller] 612
So, maybe one more tweek if possible, is there a way to add text in the line so it would look like this?
1. 10,000 Bc / 10,000 BC (2008) [Adventure, Romance] ID#335
2. 101 Dalmatians / 101 Dalmatians (1996) [Family, Comedy, Adventure] ID#838
-
So, maybe one more tweek if possible, is there a way to add text in the line so it would look like this?
If you mean you want 'ID #' before ID and a linefeed between lines, just add them to the template. ;)
-
Hello again,
this app has been amazingly useful!
it seems that something has changed in the export format that we figured out above a few years back. For some reason when i run the export it no longer comes out the way it used to.
This is the format im looking for.
1. 10,000 Bc / 10,000 BC (2008) [Adventure, Romance] 335
2. 101 Dalmatians / 101 Dalmatians (1996) [Family, Comedy, Adventure] 838
3. 12 Rounds / 12 Rounds (2009) [Action, Crime, Thriller] 612
im using the same code, but a different result.
%OPTIONS%
filter="Text Files|*.txt"
encoding="UTF8BOM"
%OPTIONS%{%value=203}. {%value=title} / {%value=origtitle} ({%value=year}) [{%value=genre}] {%value=num}
now it only prints in order of the the ID#
1. Unleashed / Unleashed (1997) [Horror, Comedy] 1
2. The Patriot / The Patriot (2000) [War, Drama, Action] 2
3. The Last Samuri / The Last Samurai (2003) [War, Drama, Adventure, Action] 3
4. 300 / 300 (2006) [War, History, Drama, Action] 4
5. Full Metal Jacket / Full Metal Jacket (1987) [War, Thriller, Drama, Actio
any help with this would be greatly appreciated!
Rob
-
Hello,
¿Do you have your collection sort by title or by ID? (Right button over movies titles column)
If you don't know, I can propose you a roundabout:
1) Sort the collection by title (Right button over movies titles column)
2) Reindex the database (Menu, Tools, Reindex movies)
Then the Title order and the ID order match.
-
Hello,
¿Do you have your collection sort by title or by ID? (Right button over movies titles column)
If you don't know, I can propose you a roundabout:
1) Sort the collection by title (Right button over movies titles column)
2) Reindex the database (Menu, Tools, Reindex movies)
Then the Title order and the ID order match.
The correct advice.
-
you hit spot on!!
TY!!
Rob~