[slinkelist] Sorting albums, any ideas ?
George Tang
GeorgeT@concur.com
Fri, 17 Dec 1999 12:18:01 -0800
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_000_01BF48CB.D118B3E2
Content-Type: text/plain;
charset="iso-8859-1"
Colby and David,
This might be helpful on this topic. I have a database that I use for my
Karaoke. As any of you who goes to Karaoke knows that sorting is a big
issue. This is how I implemented the database.
There are two fields, one labeled Last Name/Group Name and the other one
labeled First Name/Literary Words. This way, you only need to enter the
artist information once. Then I have codes that will sort by the first
field and then second field (Last Name - First Name or Group Name - Literary
Words). The Last/first Name is obvious. The Literary words would be all
the "The", "A", and "An". When I need to display the artist, I simply
display the second field first and then the first field (First Name - Last
Name or Literary Words - Group Name). For those group names that do not
start with a literary word, simply leave the second field blank. And the
display must be intellegent enough to not put a space in between the two
fields if the Literary field is blank. For those one name artists, like
Cher or Blondie, I put them in the first field as Last Names.
The only bitch about this method is that CDDB does not support this method.
So for those who want to take advantage of this, would have to manually
enter the artists. This method has worked flawlessly in my Karaoke
database.
George Tang
-----Original Message-----
From: slinkelist-admin@nirvis.com [mailto:slinkelist-admin@nirvis.com]On
Behalf Of Michael Roper
Sent: Friday, December 17, 1999 11:47 AM
To: 'slinkelist@nirvis.com'
Subject: RE: [slinkelist] Sorting albums, any ideas ?
I just posted a similar complaint/solution on the BBS after searching didn't
come up with anything really useful. My need is to have CDJ display the
artists in the order I specify, so the query doesn't help there.
The solution (two "artist" fields in the album table--one to use for sorting
and the other to use for display) seems simple to retrofit into CDJ without
much work or worry--hopefully we'll see it implemented soon.
-----Original Message-----
From: George Tang [mailto:GeorgeT@concur.com]
Sent: Friday, December 17, 1999 9:27 AM
To: 'Scott Specker'; 'slinkelist@nirvis.com'
Subject: RE: [slinkelist] Sorting albums, any ideas ?
The reason why you didn't see any replies is because this is an old long
time standing issue. Many discussions have already taken place on this
topic. One way to do this is to write an Access query that'll do the job
for you rather than manual edit. You can even set it up so that you have a
Windows shortcut that'll launch Access, open the database, and run a script
that'll run the query. But you do need to click on the shortcut to run it
manually.
Hope this helps.
George Tang
P.S. Check the Nirvis BBS for other ideas on this topic.
-----Original Message-----
From: slinkelist-admin@nirvis.com [mailto:slinkelist-admin@nirvis.com]On
Behalf Of Scott Specker
Sent: Friday, December 17, 1999 9:09 AM
To: slinkelist@nirvis.com
Subject: RE: [slinkelist] Sorting albums, any ideas ?
Well I didn't see any replies. It'd be nice if CDJ did this for you but not
many programs have this feature for sorting lists.
I've taken to solving it the brute force way ... manual editing. I've gone
through my titles and changed all the album names like "The XXXXXX" to
"XXXXXX, The". In some cases I just dropped "the" or "a", but most of the
time I use the ",".
For whatever it's worth,
Scott
-----Original Message-----
From: slinkelist-admin@nirvis.com [mailto:slinkelist-admin@nirvis.com]On
Behalf Of Michael Holopainen
Sent: Tuesday, November 30, 1999 12:45 AM
To: slinkelist@nirvis.com
Subject: [slinkelist] Sorting albums, any ideas ?
Does anyone know a handy way to short albums alphabetically by artist
name ignoring the "The" and "a" and "an" article or the first name of
artist without altering the name itself ?
The obvious solution is in the database use another field to input the
artist name in desired format for shorting.
But the problem still is how to get CDJ to use that field / (index).
Any suggestion ?
(If I remember correctly, in "customize header" there was no way to
include any additional text fields)
Is there any hidden gems of CDJ that I'm unaware of that allow to use
alternative index on database ?
michael (A)
_______________________________________________
slinkelist maillist - slinkelist@nirvis.com
http://www.nirvis.com/mailman/listinfo/slinkelist
_______________________________________________
slinkelist maillist - slinkelist@nirvis.com
http://www.nirvis.com/mailman/listinfo/slinkelist
_______________________________________________
slinkelist maillist - slinkelist@nirvis.com
http://www.nirvis.com/mailman/listinfo/slinkelist
------_=_NextPart_000_01BF48CB.D118B3E2
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IgMUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAAzwcMABEADAASAAEABQAXAQEggAMADgAAAM8HDAAR
AAwAEgABAAUAFwEBCYABACEAAAA0MERFNDZGN0JCQjREMzExQkJBOTAwOTAyN0I4RDQ1NwA1BwEE
gAEALQAAAFJFOiBbc2xpbmtlbGlzdF0gU29ydGluZyBhbGJ1bXMsIGFueSBpZGVhcyA/AK4PAQ2A
BAACAAAAAgACAAEDkAYAJBAAADQAAAADAAlZAQAAAAMA3j+vbwAAAwA2AAAAAAADAAGACCAGAAAA
AADAAAAAAAAARgAAAABShQAAJ2oBAB4AAoAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAA
ADkuMAALAGuBCCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAAMAA4AIIAYAAAAAAMAAAAAAAABG
AAAAAAGFAAAAAAAACwAEgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAALAAWACCAGAAAAAADA
AAAAAAAARgAAAAAOhQAAAAAAAAMABoAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAHgAgg
BgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADAAiACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAA
AB4ACYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAAqACCAGAAAAAADAAAAA
AAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgALgAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAAB
AAAAAAAAAAsA4YAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAAAgEJEAEAAAA8CgAAOAoAAGEV
AABMWkZ1HN/LrQMACgByY3BnMTI14jIDQ3RleAVBAQMB9/8KgAKkA+QHEwKAD/MAUARWPwhVB7IR
JQ5RAwECAGNo4QrAc2V0MgYABsMRJfYzBEYTtzASLBEzCO8J97Y7GB8OMDURIgxgYwBQcwsJAWQz
NhZQC6YSIWwIYnkgAHBkIERhcHZpZCwKogqECoBUgmgEACBtaWdoBUAAYmUgaGVscGYmdQMgAiAg
dB7CdG/CcA3gLiAgSR+AHaChH3BhIGRhAZFhFBB3IDEhsCEBdSIBAhAFwG2FHTBLCsBhb2tlIOEO
QQQgAHAdMG9mIHkBCGAgd2hvIGdvBweRIJAjRiBrbm93myBxIkJzF8ELgGcgHtHtIYBiHxAnMXMK
UCDhHrO/HtEk4AfgIRAHcAtQZQeA3wIwCYAgMR9wIaYuHfwEkFMhYSuxdHck8GYIkGz4ZHMsIAEf
cAtgH2ApYE0dcEwh8AVATmEHgC9yRwNgdXAt4x1DKfJvZynxBcAs6kZpFAAt1UzWaQ6wI3ByHTBX
BbAsoHEoJndheSzAJJICIGz/HTAs8CnCJPApkgXAKfIKwP8m8C3BC4Ai4QDAJvAgEQIg/mMoFAnw
IQYFoAEAJlUD8P5sAyAmwh9QHTAp8ixgMLJ/LGMu5gOgFBAFoB1hOSQo+S2nIC0wiSAABcAuSTuQ
7TFMKTYULZMvOMQuox7R/G9iHbAIYDIUPqExViww/zHxQVEf4B1wH2EHQAMgKfLKIiuBIizAIkFD
ER1SaUNAbiIg4Vc2VDOGZP8EAAtROGQ0pCzAIRAAkClBvx0wRTo6GzjEOYc4jig7uX89QTsHBbEx
TDuBLkg+Qka7BbEgQG8iAQnALmJuLgH9JlVkJPAmICahAZA4IQPw+yBAIXFsQOoswEaVKWAhQndH
jwJgAHBrI8IvBUU2bZ8ioB9DC4AOsDfQZWcpkZ8z8QhgHyAlUlACcHVI0f8msAqwNfA1AR9RLCAJ
4Snj/ywoJzAkcCnyMUc5JB7RU+Z/Tigs4k8iNJUssVEQJeFD+y+TBcBCF7AdYAiQRlJXgv0p8W1Y
MjiPBCAtpzIQKs37MyQnkHQT0B1ABuBfQx7SDxQgJOBbIyIzQ0REQu9PwQeRUAMucHA4EmPpIOH+
UyxBTjck0jKgVnElYQGQ0SXhYWR2aIFhVlAkUr8gQizAQcQhMyVhA4F1QlG/HTA0DjIXZDUT4EGi
ciOg+zphC2B3KWAEEDNRWEEjKLMqLx4DR2UFsGmxVABwqmcd+i1y4k8FEGcLgL8HQAXQbuFpoXLj
HfRGA2G+OiawURBUEB+gNNEtaUDpHwBuQAMAch2wMhAFoN1foFsAwAMQIJA6dU92WExdTwuQHgNC
ZRPgbPUkcE8kcE0N4BPgH6AH8f5wBJAd9AZgAjB1IHTgHcA9MrJEBZApcB9gBcAxNxkswDE5fVB8
8DE6NJo3EMBNHlV3YCAnd4jFdkknezV1YmoFkHvB1FJFdSBbd4hdZ1Em5PEHQGJ1bSyxJCIdwFKA
3QQgPx36HfQhEGpVcmYw/y3AKcFXwQdwAxAKwXbBC1OfPvAmwApANYUp40JCBfD+YQGAEoEUEArA
E9AnAkUw+GRuJwVAdsEfcC5xUKT/JDAgQScRGCBrkyKhH9Eg4d5NM2UgYyEkZSBKRS9dYd9ftjHh
EoFGcXsAYwaQMsH7JsAp43EKUDGhZXKJgh+SryniGCBhz4cXKCwiIjSk/iJZZ1/UgqNo4QJgdCEs
4r8lYSKmJsYu/Ja5jZUpOgHfKXAEIEaTawMYIHQDYCxg/zTyJWGNUlCiY6JVYGNRbiL/PFJBYTGg
cuAk4HsAH9EzUf1YoCc30gngJzA08SlJJsD/AiAqu3Lvc/91AnF5dvdxdPRUQDoxYwhwePN7P3xP
0X1SOToyfd1TBaACQMcGAI/RI6ByJzt+r3+//4DPgd+C74P+PoKLISbAA6D/JNAdMCSSiVWe4iQi
GCALUOcIkCiDH2BjYSKiIEMnQv81sTlRXpFyFSbwLsFQQV6x+ycTJ/RNJCKNkaVwBBA1kesosSFD
bIshZDhhaQEDoP8LUVgRIBW1NSCleUBoEUWC70URkGIodCVhdwUQDrC0cvxBYzXwBBGQxCIynqK7
k/0fcGo/8B30IuIkkiNwmHRfE+BvUWtja9CNkHQg4Vn3JKGzoAOgZSFQOfI08QVAvy5xkFMiUSSS
ITQd9FcLgPtP0CZBcyTgACClcF9SvfT9C2B1NeBQ0L0ELMF7AF/U+yGmQ3RyxhBXsgUDtTW95ffI
UpCHIOFCV5Gxo0/hM5X+Y1EQqgCHlsTomuHIYTFQ9x30a1Yqu0h68SA0H5JhtuNxfx30UC5TIOBe
AcxR/SnyTnZjiAMi4i90ryQgHP+gb6F/dE93n3Zvd394j3mb76l7pf+nD6gUMH1wffqqj7/aoqvv
rP+uD68fHidXVhHvIQGx77LzIOBJvgBCAwMA/1gSJHCNVCnSHtG/VuaABUD3UAHOFx0wcANgCcAu
ALfle+wkUoB0CHCXDNvSYbxJ/idSorjjJWGHER2wJxJfU78fUMhQvKEi4VgRuyIu9HD/wIonAeqB
8bIlECzwyRYuUfdW4SMhJvB0btEdQxPRJxA/haJCZZWkTyRds0LSIFjv+mOUoCCQHfQi+mQswELi
f+qBOfGJ0rOgFBAEIIT1ZPcDYGYgKcEiKfGUoAWxlDD/QxHs8gRgLcFp4/Y2taIihP1CkyxEAB36
TiIk0CGwwfH/1LG+AG4DUMAd5alz1h/XL//YP9uP2l/bb9x/eZ96os/AXxewGxAFwBig3ypUGQBz
meATTm8hUHyzMzB9JvoyfbA14c/i3+Pt5R/mL/vnPx5FRCUiJCEs4iYSJ2F/wFG4obslxOMU5VRA
+QBw/23gWHEgwGuTHSI0s/sEXNP/HxAmIMjQJxFCl0OE/sAddf9D8DSTzCA8Q1/4XNMkYPsE/zSl
nCb5ADFhHKYcBF1w0HD/64AWG2KTQASTSChyxxyW0/9ogC90SiTL8QXAXzUgWxwE/8hwNyEwoG5i
NUOXFMTy9WL/C7VfRO4CliFfoDsQN8LQMv8YIcvxVlBlAo1wlrVPg0ok5i860MRxZXg+QOf6Q+B7
9FBmAGdWUCzRk7EWFSj+SeuANpCy0DtgfLOpgJ2Q7+SBi2DGwFhBIrdxumCGEP5661DQYGlAkOD6
wZICaGHfZaK7FfsEBcDMIHWPYLKD32lA9TKTsAXhVgB4YHU+MP+EO09iNVLt0tVwN5DCEVZQ/5ox
aeEuE0+S8aBfoMYQbrD/hkBpxU+hQlEtdJbhIFUhsv9PIPAww8Evo9UiJfcWG4YQ2XqEKEE46/sE
X0LvQ///RMr7BAnYa0Es8SDiTRERXwUSaWipoHA6Ly93tUnQLgioL6RSwJEvCjL/BcCZMIcACedB
z0J/To9Pn/9Fr0a/R89I30nvSv9MD00f/1kvWj9QT1FfUm9Tf1SPVZ8LVq/oIX1jAB4AcAABAAAA
KQAAAFtzbGlua2VsaXN0XSBTb3J0aW5nIGFsYnVtcywgYW55IGlkZWFzID8AAAAAAgFxAAEAAAAg
AAAAAb9ItqU/yphInq/fEdOKRwAAwLao6QADaiAQAAFkwCADACYAAAAAAAMALgAAAAAACwACAAEA
AAAeAEIQAQAAADIAAAA8RDQ3MTAzOUZDQjhGRDMxMUJCQTYwMDkwMjdCOEQ0NTcwMTdBMUFDQUBH
RU1JTkk+AAAAAwD9P+QEAABAADkAMLoA0ctIvwEDAPE/CQQAAB4AMUABAAAACAAAAEdFT1JHRVQA
AwAaQAAAAAAeADBAAQAAAAgAAABHRU9SR0VUAAMAGUAAAAAAAwCAEP////8LAPIQAQAAAAIBRwAB
AAAAOgAAAGM9VVM7YT0gO3A9UG9ydGFibGUgU29mdHdhcjtsPUdFTUlOSS05OTEyMTcyMDE4MDFa
LTI2MzA0NgAAAAIB+T8BAAAAUAAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAAAAAvTz1QT1JU
QUJMRSBTT0ZUV0FSRS9PVT1IUS9DTj1SRUNJUElFTlRTL0NOPUdFT1JHRVQAHgD4PwEAAAAMAAAA
R2VvcmdlIFRhbmcAHgA4QAEAAAAIAAAAR0VPUkdFVAACAfs/AQAAAFAAAAAAAAAA3KdAyMBCEBq0
uQgAKy/hggEAAAAAAAAAL089UE9SVEFCTEUgU09GVFdBUkUvT1U9SFEvQ049UkVDSVBJRU5UUy9D
Tj1HRU9SR0VUAB4A+j8BAAAADAAAAEdlb3JnZSBUYW5nAB4AOUABAAAACAAAAEdFT1JHRVQAQAAH
MAR6/tDLSL8BQAAIMOKzGNHLSL8BHgA9AAEAAAAFAAAAUkU6IAAAAAAeAB0OAQAAACkAAABbc2xp
bmtlbGlzdF0gU29ydGluZyBhbGJ1bXMsIGFueSBpZGVhcyA/AAAAAB4ANRABAAAAMgAAADxENDcx
MDM5RkNCOEZEMzExQkJBNjAwOTAyN0I4RDQ1NzAxM0Q1RUY0QEdFTUlOST4AAAALACkAAAAAAAsA
IwAAAAAAAwAGELYtUBwDAAcQZQ4AAAMAEBAAAAAAAwAREAAAAAAeAAgQAQAAAGUAAABDT0xCWUFO
RERBVklELFRISVNNSUdIVEJFSEVMUEZVTE9OVEhJU1RPUElDSUhBVkVBREFUQUJBU0VUSEFUSVVT
RUZPUk1ZS0FSQU9LRUFTQU5ZT0ZZT1VXSE9HT0VTVE9LQVJBAAAAAAIBfwABAAAAMgAAADxENDcx
MDM5RkNCOEZEMzExQkJBNjAwOTAyN0I4RDQ1NzAxM0Q1RUY0QEdFTUlOST4AAADuEw==
------_=_NextPart_000_01BF48CB.D118B3E2--