INTERACT FORUM

More => Old Versions => JRiver Media Center 19 for Windows => Topic started by: laerm on January 17, 2014, 03:55:01 pm

Title: export a field?
Post by: laerm on January 17, 2014, 03:55:01 pm

Hi all –

Is there a way to export a field? I could make a view that only has that field in it, then export that playlist with "only visible fields" selected, but I was wondering if there was a more straightforward way.

Thanks –
Micah

Title: Re: export a field?
Post by: MrC on January 17, 2014, 04:09:16 pm

That's the way.

Or you could use MCWS to retrieve it.

Title: Re: export a field?
Post by: laerm on January 17, 2014, 04:10:16 pm

Then onward ho for me.

Gracias –
Micah

Title: Re: export a field?
Post by: MrC on January 17, 2014, 04:11:35 pm

De nada.

Note I edited my post shortly afterwards - you may not have seen the MCWS comment.

Title: Re: export a field?
Post by: laerm on January 17, 2014, 04:15:04 pm

I didn't; I was too quick on the draw.

I'll play with MCWS a bit, too. I'm trying to grab all lyrics by an artist, and it looks like you can't really filter, but I'll see...

Micah

My turn to edit: looks like I can do it. Thanks!

Title: Re: export a field?
Post by: MrC on January 17, 2014, 04:20:59 pm

Here's the idea:

    http://192.168.2.20:52199/MCWS/v1/Browse/Files?Action=mpl&ActiveFile=-1&Zone=-1&Fields=Lyrics&ID=1

You'll get also the FileKey, so the MPL list will include even files without Lyrics.  But you could pre-filter your list of File Keys first with a Search Query on files with non-empty Lyrics.

Title: Re: export a field?
Post by: laerm on January 17, 2014, 04:27:47 pm

Interesting. The doc says URLs go
http://.../MCWS/v1/Library/Values
but yours is
http://.../MCWS/v1/Browse/Files

What's the difference there?

Also, it looks like you're generating a playlist. Take out the 'Action=' statement and it just displays in browser, right? I.e. that's the "default" action?

Title: Re: export a field?
Post by: MrC on January 17, 2014, 04:32:57 pm

I used the Browse interface, just so I didn't have to lookup any FileKey's or do any Queries, just as a demo it can be done.  Use which ever is easiest.

Yup, the Action here is unnecessary for our purposes.  You get an MPL with Browse.

Title: Re: export a field?
Post by: MrC on January 17, 2014, 04:37:49 pm

If you use:

   http://localhost:52199/MCWS/v1/Library/Values?Field=Lyrics

You'll get all your Lyrics, but no associated Filename.  To get more Fields, you have to use the Filter parameter too.

Title: Re: export a field?
Post by: laerm on January 17, 2014, 04:49:25 pm

Quote from: MrC on January 17, 2014, 04:32:57 pm

I used the Browse interface, just so I didn't have to lookup any FileKey's or do any Queries, just as a demo it can be done.  Use which ever is easiest.

Yup, the Action here is unnecessary for our purposes.  You get an MPL with Browse.

Got it. Makes sense to me.

Quote from: MrC on January 17, 2014, 04:37:49 pm

If you use:

   http://localhost:52199/MCWS/v1/Library/Values?Field=Lyrics

You'll get all your Lyrics, but no associated Filename.  To get more Fields, you have to use the Filter parameter too.

Aha, yep, and that was what I was just working on. :D Trying to get the filter to apply to the right field now, as it seems to be stuck on filter [Name] and not [Artist].

http://192.168.1.113:52199/MCWS/v1/Library/Values?Field=Artist&Filter=Eno&Field=Lyrics

EDIT: duh, it is filtering the lyrics and not artist. Is there a hierarchy of the & elements, or some kind of nesting? I tried other orders and other text, all filter lyrics only. (But if I leave the &Field=Lyrics off, Artist filters properly.)

Title: Re: export a field?
Post by: MrC on January 17, 2014, 06:03:57 pm

I think you want a Fields=Artist,Lyrics approach, not multiple Fields parameters.  I'm not sure this solves the issue.

Title: Re: export a field?
Post by: laerm on January 17, 2014, 07:45:44 pm

You are absolutely correct. Thanks!

Micah