INTERACT FORUM

Please login or register.

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

Author Topic: Selected Field Exporting in MC11?  (Read 1878 times)

LeoH

  • Regular Member
  • World Citizen
  • ***
  • Posts: 109
Selected Field Exporting in MC11?
« on: August 09, 2004, 04:38:17 pm »

Is there a way to export a list of just artists or a list of just album names? I can get at this by exporting a playlist but the redunancies need to be filtered out. It would be useful to just get a list of artists or albums outside of the MediaCenter environment. I am using MC11. Thanks.
Logged

Jaguu

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1336
Re:Selected Field Exporting in MC11?
« Reply #1 on: August 09, 2004, 05:18:10 pm »

You may download the MC XML Export plugin by Scott_R at:

http://homepages.paradise.net.nz/~scottray/MC/xmlexport/

It will do exactly what you want!
Logged

LeoH

  • Regular Member
  • World Citizen
  • ***
  • Posts: 109
Re:Selected Field Exporting in MC11?
« Reply #2 on: August 10, 2004, 04:14:49 pm »

Scott's XML Export is excellent and comes close to what I was requesting in my post. However, what I need is to be able to get a list of unique artist names and unique album names from my database. XML Export seems to be a highly configurable playlist export in XML instead of the ASCII, MPL, and M3U formats found in Media Center. So, one can export just Arist Name, for instance, but the name will appear as many times as there are tracks by that artist. Of course, one can write a parser that removes redundancies, but I was hoping to find something already coded. The XML Export plug-in is very well thought out and complete so I very likely am just overlooking something. If so, I would be grateful to be pointed in the right direction. Thanks.
Logged

IlPadrino

  • MC Beta Team
  • Galactic Citizen
  • *****
  • Posts: 496
Re:Selected Field Exporting in MC11?
« Reply #3 on: August 10, 2004, 04:58:15 pm »

Scott's XML Export is excellent and comes close to what I was requesting in my post. However, what I need is to be able to get a list of unique artist names and unique album names from my database. XML Export seems to be a highly configurable playlist export in XML instead of the ASCII, MPL, and M3U formats found in Media Center. So, one can export just Arist Name, for instance, but the name will appear as many times as there are tracks by that artist. Of course, one can write a parser that removes redundancies, but I was hoping to find something already coded. The XML Export plug-in is very well thought out and complete so I very likely am just overlooking something. If so, I would be grateful to be pointed in the right direction. Thanks.

LeoH,

You're on the right track.  Scott_r's MC XML Export plubin will produce precisely what you want, but you need the appropriate XSLT to do what you're asking.  Have you checked the presets at http://pages.sbcglobal.net/scottraymond/Presets.htm for one that's already done?
Logged

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re:Selected Field Exporting in MC11?
« Reply #4 on: August 10, 2004, 08:02:53 pm »

No plugins are needed. E.g. a list of all albums:

1. Search: ~nodup=[Album]
2. Select all and send to a new playlist. Go to that playlist. You can sort and update the list order if you wish.
3. In "Customize Current View" select only "Album Artist (auto)" and "Album".
4. Export the playlist in HTML or ASCII Delimited format (Only Visible Fields).

You can open an ASCII Delimited playlist with a spreadsheet program (Excel or similar). Use the | character as a column delimiter when opening.
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755

IlPadrino

  • MC Beta Team
  • Galactic Citizen
  • *****
  • Posts: 496
Re:Selected Field Exporting in MC11?
« Reply #5 on: August 10, 2004, 08:32:39 pm »

No plugins are needed. E.g. a list of all albums:

1. Search: ~nodup=[Album]
2. Select all and send to a new playlist. Go to that playlist. You can sort and update the list order if you wish.
3. In "Customize Current View" select only "Album Artist (auto)" and "Album".
4. Export the playlist in HTML or ASCII Delimited format (Only Visible Fields).

You can open an ASCII Delimited playlist with a spreadsheet program (Excel or similar). Use the | character as a column delimiter when opening.

Granted...  but this isn't as elegant as the MC XML Export solution which is one-click.  Wouldn't you need to recreate the playlist each time changes to the database where made.  How about with a smartlist instead?
Logged

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re:Selected Field Exporting in MC11?
« Reply #6 on: August 10, 2004, 09:04:03 pm »

You cannot export smartlists. You can of course make a smartlist with that search expression so the list is always ready for a quick playlist creation.
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755

LeoH

  • Regular Member
  • World Citizen
  • ***
  • Posts: 109
Re:Selected Field Exporting in MC11?
« Reply #7 on: August 12, 2004, 01:16:49 pm »

Alex,

I have been creating scheme views for a long time and just overlooked ~nodup, oh well. Thanks very much for the tip, you saved me much time!

-Leo
Logged
Pages: [1]   Go Up