[Logo] Jaikoz and SongKong Forums
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Move the "The" in Artist & Album Artist  XML
Forum Index -> Jaikoz Questions
Author Message
Porthos

Pro

Joined: 24/05/2009 10:06:02
Messages: 39
Offline

I manually fix this but maybe there is a better way.
Bands like:
"The Police" changed to "Police, The"
"The Rolling Stones" to "Rolling Stones, The"
"The Bla Bla" to "Bla Bla, The"
in both Artist and Album Artist.

Any one know of a slick way to do this?
Much Thanks if you do..

Side Note:
Thanks Paul for such a Great App.

License Type:Full
Rob

Pro
[Avatar]
Joined: 02/05/2011 05:14:28
Messages: 21
Offline

This is one thing that annoys me with Discogs lookups. The artist always comes as "blahblah, The". I want to keep the "The" at the beginning.
Porthos

Pro

Joined: 24/05/2009 10:06:02
Messages: 39
Offline

lol we do have are ways

I find there are just to many "The" band name.. it more of a grammar thing than hey lets call are selves.. hmm but it must start with "The"

So when I look on my iPod or anywhere else I think Rolling Stones, or Who
But that's why we love Tag editors

Need a little util that looks at 1st 4 characters = "The " then fix it
I'm sure I can do it in Foobar (btw best player on the planet) but doesn't help when it comes time to using the iPod.

anyway cheers

License Type:Full
paultaylor

Pro
[Avatar]

Joined: 21/08/2006 09:21:27
Messages: 7298
Online

Yes bit silly because seems to use the sortname as the name for bands

http://api.discogs.com/release/732004?f=xml

but doesnt use sort name for individual artists

http://api.discogs.com/release/716019?f=xml

so is complelety inconsistent. I guess I could do a rough fix of

Code:
 if find (,The) at end of artist name from Discogs
 Move it to start of Name
 endif
 

thanks Paul (Administrator)
paultaylor

Pro
[Avatar]

Joined: 21/08/2006 09:21:27
Messages: 7298
Online

Done for next release.

thanks Paul (Administrator)
Porthos

Pro

Joined: 24/05/2009 10:06:02
Messages: 39
Offline

I like and want

, The

To be at the end.. Just noticed no one read what I ask for.

License Type:Full
paultaylor

Pro
[Avatar]

Joined: 21/08/2006 09:21:27
Messages: 7298
Online

So you want to the values to be the same as Sort Artist and Sort Album columns ?
You could do Empty Column on Artist column, then drag Sort Artist column so it is to the right of Artist column and use Preprend to Left to copy corresponding value from Sort Artist to Artist

But I'm not going to add an option so that 'Beatles,The' is stored in Artist field rather than 'The Beatles' because that is just wrong, why do you want to do this ?

thanks Paul (Administrator)
Porthos

Pro

Joined: 24/05/2009 10:06:02
Messages: 39
Offline

Paul you made me laugh..
"because that is just wrong, why do you want to do this ?"

I started this post and if you read the first 2 post you will see why..

I know it just wrong.. but like I said..
When I'm browsing my ipod I don't thing "The Who" and go to the "T's"
I go to the "W" and look for Who
"P" for "The Police"
R for "Rolling Stones"
Hell no one says "The Rolling Stones" they say "Rolling Stones"

No worries.. just wanted a slick way to fix it if the 1st 3 letters were "The" then move to end. LOL
Thanks for putting me in my place.. guess I'll have to fix them manually in secret
Have a great day..

License Type:Full
paultaylor

Pro
[Avatar]

Joined: 21/08/2006 09:21:27
Messages: 7298
Online

Heh okay - I thought the ipod would use Sort Artist like iTunes does anyway but mine doesn't seem to, although it a few years old.

Why not just remove 'The' rather than moving it, you can do that easily using the Jaikoz Find and Replace action.

Actually its irrelevant to your problem but I would say people do say 'The Rolling Stones' rather than 'Rolling Stones', i.e 'I'm listening to the Rolling Stones'. The problem comes with bands such as 'Pixies' , as it seems bad English to say 'I'm listening to Pixies' you would usually say 'I'm listening to the Pixies', at least in England.

thanks Paul (Administrator)
Porthos

Pro

Joined: 24/05/2009 10:06:02
Messages: 39
Offline

lol more like
i.e 'I'm listening to the The Rolling Stones' or maybe you just proved my point.. the The..
btw You do great work..

License Type:Full
 
Forum Index -> Jaikoz Questions
Go to:   
Powered by JForum 2.1.6 © JForum Team