INTERACT FORUM

Please login or register.

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

Author Topic: Displaying html list of just albums  (Read 1219 times)

JONCAT

  • Guest
Displaying html list of just albums
« on: September 15, 2004, 03:50:01 pm »

I am importing my html lists into Excel, but I can't find I way to create html list of just the albums I have.

Anyone got any ideas; I keep getting lists with files, if I choose not to display the file names (field) in Media Center, I end up with a list that has the album name listed multiple times for every track there was on the album.

Is there any way to combine Excel spreadsheet entries?

My html lists & Excel spreadsheets look like this:

Over The Rainbow's End (Gaylads 68-71)
Over The Rainbow's End (Gaylads 68-71)
Over The Rainbow's End (Gaylads 68-71)
Over The Rainbow's End (Gaylads 68-71)
Over The Rainbow's End (Gaylads 68-71)
Over The Rainbow's End (Gaylads 68-71)
Over The Rainbow's End (Gaylads 68-71)
Over The Rainbow's End (Gaylads 68-71)
Over The Rainbow's End (Gaylads 68-71)
Paul's Mall 15JUL73 Boston
Paul's Mall 15JUL73 Boston
Paul's Mall 15JUL73 Boston
Paul's Mall 15JUL73 Boston
Paul's Mall 15JUL73 Boston
Paul's Mall 15JUL73 Boston
Paul's Mall 15JUL73 Boston
Paul's Mall 15JUL73 Boston
Pay The Piper
Pay The Piper
Pay The Piper
Pay The Piper
Pay The Piper
Pay The Piper
Pay The Piper
Pay The Piper
Pay The Piper
Pay The Piper
Pay The Piper
Pay The Piper
Pay The Piper
Payday
Payday
Payday
Payday
Payday
Payday
Payday
Payday
Payday
Payday
Payday
Payday
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Peace & Love
Pick A Dub
Pick A Dub


I tried to combine them to no avail. If you right click on the spreadsheet in a cell and choose, Pick From File, a java-like window pops up with all the album entries from the book letting you choose what you want to insert into that particular cell. That's exactly what I need, that list of albums but I can't get it....!

thanks
Jon
Logged

IlPadrino

  • MC Beta Team
  • Galactic Citizen
  • *****
  • Posts: 496
Re:Displaying html list of just albums
« Reply #1 on: September 15, 2004, 04:02:35 pm »

You need to use a playlist that removes duplicates, or a more elegant solution would be to try MC XML Export with some of the presets found here:  http://pages.sbcglobal.net/scottraymond/Presets.htm
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42323
  • Shoes gone again!
Re:Displaying html list of just albums
« Reply #2 on: September 15, 2004, 04:03:09 pm »

Look at: Action Window > File Properties > Albums (or other pages)

Copy to clipboard and paste anywhere.

Excel can also do grouping if you play around a little.
Logged
Matt Ashland, JRiver Media Center

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
Re:Displaying html list of just albums
« Reply #3 on: September 15, 2004, 11:39:29 pm »

or a more elegant solution would be to try MC XML Export with some of the presets found here:  http://pages.sbcglobal.net/scottraymond/Presets.htm

Does MC XML Export plugin work with MC 11 ?
Logged

IlPadrino

  • MC Beta Team
  • Galactic Citizen
  • *****
  • Posts: 496
Re:Displaying html list of just albums
« Reply #4 on: September 16, 2004, 01:43:13 pm »

or a more elegant solution would be to try MC XML Export with some of the presets found here:  http://pages.sbcglobal.net/scottraymond/Presets.htm

Does MC XML Export plugin work with MC 11 ?


It's working for me.
Logged

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re:Displaying html list of just albums
« Reply #5 on: September 16, 2004, 07:37:39 pm »

JONCAT,

Could this work for you?

http://yabb.jriver.com/interact/index.php?board=3;action=display;threadid=20382

In "Customize Current View" you could include: "Album Artist (auto)" and "Album".

After you have the list as you like on screen you can also just select all, right click, copy and paste to an empty Excel sheet.
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755
Pages: [1]   Go Up