INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Create a handout list  (Read 2211 times)

ERGE

  • Regular Member
  • Recent member
  • *
  • Posts: 5
  • nothing more to say...
Create a handout list
« on: April 05, 2006, 01:21:31 pm »
 ?
Hi Folks

a stupied question you tell me. I know but i'm having no idea. I work with a prog. called DVD Profiler. In this prg is it possible to create a printable list with the image an any information about the film as a handout list for my friends to show wich dvd are mine.
Is it possible to create a sort of this list in MC?

Greatz Eric
Logged

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: Create a handout list
« Reply #1 on: April 05, 2006, 01:27:54 pm »
Surely, and it's quite flexible as well.

Find whatever view scheme you'd like to "print out" and make sure you are viewing the details list of the files.  Then...

1. Select All (Control-A)

2. Right click --> Edit --> Copy (or just type Control-C)

3. Open Excel (I imagine other spreadsheet type programs would work too).

4. Select the top-left cell and...

5. Right click --> Paste (or type Control-V)

If you then turn on Excel's List functions (Data --> List --> Create List) you can sort by the column headers, easily filter the list, and a bunch of other cool features.  If your program can take CSV files as a data type, Excel (or MC directly if you want) can also easily generate those for you.
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

Robert Taylor

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 646
  • Living in a Smokeless Zone...
Re: Create a handout list
« Reply #2 on: April 05, 2006, 04:14:22 pm »
I use a program called Gemmico FolderInfo (http://www.gemmico.com/soft/fidesc.htm) to generate an HTML directory listing of my MP3 folders.

I use it because I can customise what I output (ie. DTM, Folder size etc.) Unfortunately I can't include cover art.

That way I can give my friends a list which shows artists, with albums indented below etc.

BTW, I also use DVD Profiler to keep track of my DVDs, it's a great program.

cheers
Rob
Logged
Cheers
Rob

Doof

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 5908
  • Farm Animal Stupid
Re: Create a handout list
« Reply #3 on: April 05, 2006, 04:23:59 pm »
You might want to check out the XML Export plugin. IIRC, you can generate some really cool views of your MC library using that and some XSLT transforms.
Logged

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: Create a handout list
« Reply #4 on: April 05, 2006, 04:57:32 pm »
Quote from: Doof on April 05, 2006, 04:23:59 pm
You might want to check out the XML Export plugin. IIRC, you can generate some really cool views of your MC library using that and some XSLT transforms.
Quote from: glynor on April 05, 2006, 01:27:54 pm
If your program can take CSV files as a data type, Excel (or MC directly if you want) can also easily generate those for you.

That's how you generate CSV files from right inside MC as well.  I haven't played too much with the XML export capabilities of MC, but it certainly does look powerful.  I also misread the Parent Post's question... If he was looking to include the Images in the list, then my copy/paste method won't help.  If he was just looking to create a flexible list though, it certainly is easy.
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: Create a handout list
« Reply #5 on: May 01, 2006, 10:44:50 pm »
I noticed that this no longer works (copy --> paste track info into Excel).  I know it used to (as I was surprised to learn that it did after using the Export Playlist to ASCII delimited method previously), but it doesn't anymore with recent builds...

It was a nice feature... what happened?   :-\
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

jgreen

  • Citizen of the Universe
  • *****
  • Posts: 2419
Re: Create a handout list
« Reply #6 on: May 01, 2006, 10:55:43 pm »
Glynor--
i just tried this with OO and it works fine, unless I'm missing something.  Usual caveats apply, make a view scheme that excludes lyrics and bios, etc etc etc.
Logged

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: Create a handout list
« Reply #7 on: May 02, 2006, 03:18:41 pm »
Hmmm... Perhaps I have a field displayed that isn't liked.  I will research more upon my re-arrival home.  Thanks!!
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re: Create a handout list
« Reply #8 on: May 02, 2006, 03:46:00 pm »
I just copy-pasted succesfully a selection of 55 library fields and 1055 files to Excel.

Only the fields that may contain line breaks are problematic (e.g. Bios and Lyrics, as jgreen said). Each line break will start a new row in Excel.
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755
Pages: [1]   Go Up
« previous next »