INTERACT FORUM

Please login or register.

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

Author Topic: Library LIsting  (Read 1105 times)

NickM

  • Citizen of the Universe
  • *****
  • Posts: 630
  • Simplicity isn't always best, but it's easy to fix
Library LIsting
« on: September 08, 2005, 10:02:40 pm »

I would like to print out a booklet showing cover art, files and album information.  I can cut and paste raw lists from MC, but cannot select the cover art.

Has anyone tried printing a library booklet?  I am not suggesting this should be a feature of MC as I am sure it will be of little use to most people!

Is there a way to read directly from the MC library database?  Maybe set it up as a datasource in Windows and use an SQL query to extract the information?  I wonder if the cover art would come too?

nick

Logged

NickM

  • Citizen of the Universe
  • *****
  • Posts: 630
  • Simplicity isn't always best, but it's easy to fix
Re: Library Listing
« Reply #1 on: September 10, 2005, 06:32:00 am »

I can't believe that no one else has 80+ year old parents who need a print out of all their music! 

nick
Logged

lee269

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 575
  • sleep eat sleep eat sleep eat
Re: Library LIsting
« Reply #2 on: September 10, 2005, 12:18:53 pm »

Nick

No way to access the library as a datasource in the way you mention, AFAIK. Most solutions to this sort of thing seem to revolve around MCs ability to export the library in XML format and transform that into something you can use, eg suitable for import into a third party database, or a nicely formatted HTML document. Although the details of XML are mostly beyond my knowledge, there are/were people on the forum with an interest in this. If you know all about XML you can probably discount all of the rest.

Try this thread, and follow the links to scotts MCXML export plugin and the related links (below) which will take you to scotts useful MC XML primer.

You can get the presets at http://pages.sbcglobal.net/scottraymond/Presets.htm - plenty of XSL to get you started.

A less elegant and more restrictive way it seems might be to export your entire library (as a playlist) to HTML, including the coverart filename field, and edit the output to make those filenames appear as images.

Hope that helps. Perhaps someone with more detailed experience will chip in.
Logged

NickM

  • Citizen of the Universe
  • *****
  • Posts: 630
  • Simplicity isn't always best, but it's easy to fix
Re: Library LIsting
« Reply #3 on: September 11, 2005, 03:44:55 am »

Thanks Lee, I will export to XML and see  how I can format it.  I'll post the result if it looks any good!
nick
Logged

NickM

  • Citizen of the Universe
  • *****
  • Posts: 630
  • Simplicity isn't always best, but it's easy to fix
Re: Library Listing
« Reply #4 on: October 21, 2005, 05:16:04 am »

It's a real KLUDGE, but I have managed to printout an album list with coverart.  At this stage someone will say, "But that's easy, just click, click" etc.

From Marko's Album playlist, I select and copy to an Excel spreadsheet.  Some formatting, some macro's and voila !...

I have not yet worked out how to put the XLS file in this message, but if anyone wants to try it, mail me

nicholas at hotmail dot com

nick
Logged
Pages: [1]   Go Up