Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[steveklein]

I have a problem in my database of music and was wondering if there was any way Media Center could help me fix this. I have been unable to come up with an easy solution up to now.

Here's the dilemma:

I've got several thousand albums and I estimate a few dozen of them have incorrect track numbers because they were simply numbered 01-XX based on their alphabetic track title. For instance, an Evanescence album of mine has track 1 and 2 starting with A's, track 3 with a C, track 4 with an F and so on and so forth.

I was curious if there was any way I could filter my library for albums that had track listings that were alphabetical like this so I could at least identify the albums. Then, I could manually look up the CDs, and manually correct the track numbers.

Anyone got any ideas?

[steveklein]

bump, anyone??

[gappie]

ok... its a long shot, cant think of anything else...
make a backup first. 

make two user defined library fields. make them integer and call them for instance CTrack and CName
now make a smartlist that has all the audio sorted by album artist (auto), album and track #
add the collumn CTrack
click on the first CTrack select all songs in there (ctrl A) and click F2.
now in the field that opens type =Counter()
all the songs get there own number in CTrack

change the sorting of the smart list to: album artist (auto), album and Name
add the CName cullumn to also to the view
do the same to that collumn as you did to CTRack

now add a collumn with an expression to the smartlis that say something like
if(IsEqual([Ctrack],[CName],2), Y,N)
for all the songs with a Y the track number could be the same as alphabetic. this of cource gives also the songs where this happens by change.
you could make it more fancy by making a third user defined library field with the code from above, and make smart lists base on the Y value, and add full album. the albums with only Y in the collumn are the ones whith all songs and tracks in track and alphabetc order.

i hope someone has a better idea. could not really test it because i dont have that problem. so maybe there is a flaw somewhere.. guess/hope it works though.

succes
 
gab


btw: i wish that steve klein would start to produce elctric guitars again.. 

[steveklein]

wow thanks so much for the help... though i think you lost me just a little bit.

i see what you were doing with the CTrack and CName fields. Basically We want to find places where an entire album counts up in consecutive integers in both the CTrack and CName fields, correct?

The expression if(IsEqual([Ctrack],[CName],2), Y,N) did not seem to do this? It gave me some bizarre results. Some tracks off albums returned a Y value, while other tracks off the same album would return a N value. I would expect all tracks from a specific album to return either an N or a Y value, right?

[gappie]

see what you were doing with the CTrack and CName fields. Basically We want to find places where an entire album counts up in consecutive integers in both the CTrack and CName fields, correct?

correct! but now you could expect some strangness, when a song is for instance on the third place in the albhabetic order and in the track order, but the other songs are not, the third song get a Y and the rest from that album a N.. but it is not to hard to get that out. and that is where the third calculated library field is handy with if(IsEqual([Ctrack],[CName],2), Y,N). when you use that field in a new smartlist: select for all songs with N and make it full album,
and then make a smartlist with all audio, excluding everything in the first smartlist...

im not behind a machine with mc on it now.. so if you need help with the smartlists, just say and i can help out tonight...