Author Topic: Exporting  (Read 9904 times)

0 Members and 1 Guest are viewing this topic.

Offline mntzion2000

  • Member
  • *
  • Posts: 22
    • View Profile
Exporting
« 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~

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Exporting
« Reply #1 on: April 22, 2012, 04:47:23 am »
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...

Code: [Select]
%OPTIONS%
filter="Text Files|*.txt"
encoding="UTF8BOM"
%OPTIONS%{%value=title} ({%value=year}) {%value=num}

Offline mntzion2000

  • Member
  • *
  • Posts: 22
    • View Profile
Re: Exporting
« Reply #2 on: April 23, 2012, 02:31:56 am »
thank you for the response and please for give my ignorance, but where and how would i apply that code to make the change?

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Exporting
« Reply #3 on: April 23, 2012, 05:41:00 am »
Preferences > Plugins > Plain text > Add...a template. Select the 'Edit template' tab and paste the code.

Offline mntzion2000

  • Member
  • *
  • Posts: 22
    • View Profile
Re: Exporting
« Reply #4 on: April 30, 2012, 03:42:32 am »
so am i adding to the existing one, or creating a new one?

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Exporting
« Reply #5 on: April 30, 2012, 10:13:50 pm »
You can do both there
Gentlemen, you can’t fight in here! This is the War Room!

Offline mntzion2000

  • Member
  • *
  • Posts: 22
    • View Profile
Re: Exporting
« Reply #6 on: May 05, 2012, 04:11:08 am »
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 :)












Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Exporting
« Reply #7 on: May 05, 2012, 04:23:03 am »
Code: [Select]
%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.

Offline mntzion2000

  • Member
  • *
  • Posts: 22
    • View Profile
Re: Exporting
« Reply #8 on: May 05, 2012, 05:45:29 am »
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

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Exporting
« Reply #9 on: May 05, 2012, 06:10:42 am »
Quote
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. ;)

Offline mntzion2000

  • Member
  • *
  • Posts: 22
    • View Profile
Re: Exporting
« Reply #10 on: March 13, 2018, 05:04:22 am »
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

Offline VVV_Easy_Programing

  • Older Power User
  • *****
  • Posts: 199
    • View Profile
Re: Exporting
« Reply #11 on: March 24, 2018, 09:21:01 am »
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.

Offline Ivek23

  • Global Moderator
  • *****
  • Posts: 2667
    • View Profile
Re: Exporting
« Reply #12 on: March 24, 2018, 12:00:16 pm »
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.
Ivek23
Win 10 64bit (32bit)   PVD v0.9.9.21, PVD v1.0.2.7, PVD v1.0.2.7 + MOD


Offline mntzion2000

  • Member
  • *
  • Posts: 22
    • View Profile
Re: Exporting
« Reply #13 on: March 26, 2018, 08:59:36 am »
you hit spot on!!

TY!!
Rob~