[slinkelist] Sorting albums, any ideas ?

Michael Roper michaelr@encraft.com
Fri, 17 Dec 1999 12:46:47 -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_01BF48CF.D92C6CC0
Content-Type: text/plain;
	charset="iso-8859-1"

George, this approach wouldn't solve my problem and seems more complex
than necessary.  Any solution that doesn't allow me to sort based on a
non-displayed field just won't be flexible enough.  The "sort
field/display field" solution is intuitive to use, simple to implement,
and powerful enough to allow complete control over sort order (for
example, subsorting albums by an artist chronologically).

-----Original Message-----
From: George Tang [mailto:GeorgeT@concur.com]
Sent: Friday, December 17, 1999 12:18 PM
To: Michael Roper; 'slinkelist@nirvis.com'
Subject: RE: [slinkelist] Sorting albums, any ideas ?


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_01BF48CF.D92C6CC0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IjYUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAAzwcMABEADAAuAC8ABQBhAQEggAMADgAAAM8HDAAR
AAwALgA0AAUAZgEBCYABACEAAABEOTQ4OThDQURGQUZEMzExOEE0NzAwMDBDMEI2QThFOQBOBwEE
gAEALQAAAFJFOiBbc2xpbmtlbGlzdF0gU29ydGluZyBhbGJ1bXMsIGFueSBpZGVhcyA/AK4PAQ2A
BAACAAAAAgACAAEDkAYARBEAADQAAAADAAlZAQAAAAMA3j+vbwAAAwA2AAAAAAADAAWACCAGAAAA
AADAAAAAAAAARgAAAABShQAAJ2oBAB4ACYAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAA
ADkuMAALAA6BCCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAAMACoAIIAYAAAAAAMAAAAAAAABG
AAAAAAGFAAAAAAAACwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAALABOACCAGAAAAAADA
AAAAAAAARgAAAAAOhQAAAAAAAAMAAoAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAUgAgg
BgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADABaACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAA
AB4AJYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeACaACCAGAAAAAADAAAAA
AAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgAngAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAAB
AAAAAAAAAAsAD4EIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAAAgEJEAEAAAA+CwAAOgsAAPUX
AABMWkZ1EQMC2AMACgByY3BnMTI14jIDQ3RleAVBAQMB9/8KgAKkA+QHEwKAD/MAUARWPwhVB7IR
JQ5RAwECAGNo4QrAc2V0MgYABsMRJfYzBEYTtzASLBEzCO8J97Y7GB8OMDURIgxgYwBQMwsJAWQz
NhZQC6YgRwJlBbBnZSwgdGhhBAAgYXBwA2AA0GiEIHcIYGxkbicFQAJzBvB2ZSBteSCTHeECYGVt
HbBuZB7QXQngbQQgBGAYICAFoG1vC1AOwB1hA5FuBZAHkHPRCsB5LiAQwG4fUB7hOHV0aQIgIVIF
QGRvfweQHqIHQBewB+AHgB1gb+Me0QAgIGJhFBAgECMRZmEhoAIgLWQEAAtReQ0lUWYIkB6AIGp1
c1cFQB5QHqJiHyBmISFpTR+hIAnwCGBnaCJBVNpoHyAiJNMmsy8mFSakjiIiqB2RC4B0dWki8P8f
ESShJyAdQQCQIQIkkizzbweAAjAdUB/ycCRABJBm/x5wKHUkkiQUIOQOsCDRAjD7A2ADIG8fEAXA
JNMFsASB3CAoAhAFwA7AYSECLMEsdWIk0guAZyQBYnX9IGFiH1ADkQrAIvAnMRPQNwNgJdAXsGcN
4CQReSmuLgqiCoQKgC02sk8FEP01YG4HQAXQIeIdMDazNfR6RgNhOhzlKQAAcDOAW5cAwAMQJKA6
HPRUQDCR6mMIcC4g4V019AZgAjCzOPA4sGlkJmAdUEQhwZMG0BKBMTcdUDE5PaABPUAyOjE4IFBN
/TX0VDowBdAN4BPgJtAH8YJwBJA7ICdzbAuAlmsm0DShQAMAcnYEAG07Mic7hTMAagWQPBFS6kU4
8FtACF0GADM7LhLLH1A8YGUlMCA/Nfo19E8IUDOwNCIgEERhQOBkriw1+ikQHZFtNyBoJ6N5KSBs
cC7CIxMdkSSgcPsN4CJBSUjARuAfICWwPHD/AZElMSM0SlAskSagBbEfQfJLCsBhb0BAIkIdoSKB
sG9mIHkIYB5AaCSwTmcjoSSSTJUgayXQd/9JsSNSMyYdkiUQNyArgTLw/0zyR/MdkU4gB+BKUC2H
JVH/HXAfIErmNespESCxCsAkgf8eUCakRDECIB8gC2AnwB+wLSAQTCUwBUBOMoBlL3JHA2B1cFcj
H+NTMm+3UzEFwFYqRkDAVwZMLABzBJAiESBXMbFBAFF1d/88gk3SAiA1sCGhUwIksFLS/wXAUzI0
dQuAMiEAwCLzOuH/UVQJ8EpGBaABAE+VA/AkIP8kxR9QUzImsFnyJrRYNQOglxQQMJEmlihW5yAt
Wcn/MaEc4FeYZNBajDXQKPRW4v4vYgRX4x2RH5BA4AhgW1T/Z+Falh5QWzEeRCeyJBFTI8oiKREi
HVAiQWxRH/LpbIBuIiJBV1+UXMYqFv9dqB1QSlAs4x9QbnpjW2IE+2LHYc4oZPlmgWRHBbFajLdk
wVeIZ4JGBbEdcG9LQf8JwFeiN1AHgiNFJcEewQGQ/yTxA/AdcCWhQBBqOSzFH1DfH7BKgnDPAmAA
cGsiQ1MV/SolbSciJ8ErwSbQH7AdMPcCMC75eUJwIuAloSYwAND/fwInsVVgCeFTI1VoK4BNsP9T
MlqHJrQdkX0md2hWInhibzRlRDFAEE8hQ1jTBcBC/xewIAAIkG+SgMJTMR/QgYF/Yc8EIFbnQQBU
DVxkUNB0/x4hAaAIYIiSSBIUIE4ghGPhI0NDRERCI4N5NFew/y5wJPGNKSJBQ2BME3ekThIfW+B/
sSShAZBPIWFkdv+RwTfRTZIdch1QawRKcySh/QOBdTWSXT9bV411E+Bq4u5yQEAmkQtgdx+wBBBc
kf+BgUxoU282AzkZNf83Dzge7UAILZKASEBuQKk5x56PmUC4XU8LkJtzQmUT4PpsTbBPTbA/CzuP
PJ89o/AxOjQ3EMA+WT//QQ//Qh9DL0Q/RU1KUCcTLnAnMP8lUYEBB3ADEArBIOMLcWgwpyK3IxMf
IEJCBfBhAYD7MTKswHIT0DNiJhAekyDh/x8gV7F55CKAHXEzcRgglNP3LJEuwSJBTVylSaNKZI5g
fkpub4ahiPYxtG+xP6Bj7waQpYEe4FMjcQpQWuEjll9I0lMiGCCLDyK3KFViIv80dCrggraJFDOj
kiEfoZwgf1YiLGRMEzMnWEu/+SYVKf8gJSzoGCAwwSawXjIkobaS/3nijOJ+oB4jl4BlkmqhIiC/
nCBOID+gLsFckS6QJ2ES/wngK4BeMVKJHuACIDXvnG8/nX85HzovOz+lPz1XOTr6MqcdUwWgAkAG
ALkRqED8cic/36jvqf+rD6wfrS//KRK0YR7gA6BOEB9QTdKylf/IItgiGCALUAiQUcMnwDWA/0vi
HXMdkl7xJuGH0ZtVIvDfJHF5gYfxUFNRNE3YIiYRX86wBBAjAVHxSoNstGFk/2GhkkEDoAtRgVFJ
Vd51SeV/ooCRUW7CblG5olG0JKF35wUQMGEDkUFjIdK59SNC98fi5NMfIGofkMmkMiJN0r9MsMG0
IXKUlChwJhB0IkHuWU3hNYADoGUfEGMyXjF/BUBXsbmTI2FN0kp0yaRX9wuAI5BPgXNOIAAgzrCI
kvvnNAtgdc6gHjDmRFYBP6D3iRRK5i4Ucu9QgPIFA9517+cl8ZK5xyJBQoDR2uN5If1c1WPT0NNA
sNbuKMQh8aHvLADJpJSWyZtIP5EdZEjSx4r2mr/JpFAuUyJAh0H79ZFTMk7Ug7FDMiJYtNhk/0lc
ya/Kv52PoN+fr6C/oc/fotvSu88/0E/RVDA9wKc6f9PPzuLVL9Y/10/YX/+HV99/UUpB2y/cMyJA
SedAa0P/A4CBUqOAtpRTEh2R6JYzwP+OQHlB91cfUxmgMoDhJRVkPxCAK+AgscBq1CKK/Ekn/ywy
4iMkox8AUEOIkyUQ8ZDvMGHCcYFR5GIuHbDpyjNh/xPBGvJOUCGw8lZXkS9BTGH9IvB0mBFYIz8h
M3Cu4mulz77keGSG82wSIFgjoyrg+5IA/7QiI6STkGwiE8FjMd+zEjWAw0BQkK41ZDUAj2D9ySEi
UzEq4MKBvXBsURYyfm2usZMUH3be4kvEa9Ms/21A/1p3Yk4QT9DrMf3x50D/l0N6AEcl0rP/XwBv
AX8Ez/8DnwSvBb+i3z9C+QCH0C3AVy8Af+AIalS6EHMJU04mbxsAPQMzMD14NDV/Cw8MHw0tDl8P
bxB/LgVE/05iPrFWIk9SUKHpkeHh5GXv7iM+JX2AvuBwlyCBsUoA/5TTRmJd8y4UhhMu4ICA8hD/
PgFr12zEKABGtW0wXdP1YP9lg4k4hhNNoC4UXeXFZr7g/1qhReZFRLfggtAUwD9bi9P/aUS8iN1i
8FzAE5HAWLRzZP+SAS8AiHVJm0VE8bBgYdSA/5eiXoPAVO4yHqI09YiEF0L/v2GI4L3AYQL5ckFh
kgEvoN+OQrawv/WOE3NkL70Q7bF8ZXhngC26bSCYwN/QZ88voFYRvPE/VShJFMBf0P/cEGSgCePS
wMbQDcH4EJOQ3YGBIuCxkgCvUHqF8LEg/zGAuiAkAbtCkaGO4uRVLhT7LwD1YHW4oD6jMYAecrzw
+y8hHOB4ibVncK17eKJekv8+shhAYNDrUS+gw3GTIVdT/+xiGuCI4O9Ql/CvgJMF7HH/lNFWtLTR
SZVK8i8QUiAbAT9Y47DSTzc/W69Qo8QoQftiKy4UX2wvbT9uCi4UOqi/lIFWMUoidHE6nzupaNLg
oHA6Ly93cxAuMej2L82S6dEv1CIvAMJwsED/cQdrD2u/d894327vb/9xD/9yH3MvdD91T3Zfgm+D
f3mPf3qfe698v33Pft9/7y3hfQGMQAAAHgBwAAEAAAApAAAAW3NsaW5rZWxpc3RdIFNvcnRpbmcg
YWxidW1zLCBhbnkgaWRlYXMgPwAAAAACAXEAAQAAACUAAAABv0i2pT/KmEier98R04pHAADAtqjp
AANqIBAAAWTAIAABSYhQAAAAAwAmAAAAAAADAC4AAAAAAAsAAgABAAAAHgBCEAEAAAAyAAAAPEQ0
NzEwMzlGQ0I4RkQzMTFCQkE2MDA5MDI3QjhENDU3MDEzRDVFRjRAR0VNSU5JPgAAAAMA/T/kBAAA
QAA5AFB/0dXPSL8BAwDxPwkEAAAeADFAAQAAAAkAAABNSUNIQUVMUgAAAAADABpAAAAAAB4AMEAB
AAAACQAAAE1JQ0hBRUxSAAAAAAMAGUAAAAAAAwCAEP////8LAPIQAQAAAAIBRwABAAAALgAAAGM9
VVM7YT0gO3A9U2VyZW5ldDtsPUhPU1QtUzEtOTkxMjE3MjA0NjQ3Wi00MgAAAAIB+T8BAAAATgAA
AAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAAAAAvTz1TRVJFTkVUL09VPUNPUlBPUkFURS9DTj1S
RUNJUElFTlRTL0NOPU1JQ0hBRUxSAAAAHgD4PwEAAAAOAAAATWljaGFlbCBSb3BlcgAAAB4AOEAB
AAAACQAAAE1JQ0hBRUxSAAAAAAIB+z8BAAAATgAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAA
AAAvTz1TRVJFTkVUL09VPUNPUlBPUkFURS9DTj1SRUNJUElFTlRTL0NOPU1JQ0hBRUxSAAAAHgD6
PwEAAAAOAAAATWljaGFlbCBSb3BlcgAAAB4AOUABAAAACQAAAE1JQ0hBRUxSAAAAAEAABzAwHtDV
z0i/AUAACDDAbCzZz0i/AR4APQABAAAABQAAAFJFOiAAAAAAHgAdDgEAAAApAAAAW3NsaW5rZWxp
c3RdIFNvcnRpbmcgYWxidW1zLCBhbnkgaWRlYXMgPwAAAAAeADUQAQAAADUAAAA8OTE5OTRDNTNF
Qzg5RDAxMTg4OTIwMDAwQzBCNkE4RTkwOTE2OENAZW5jcmFmdC5jb20+AAAAAAsAKQAAAAAACwAj
AAAAAAADAAYQCOmQDQMABxBjEAAAAwAQEAAAAAADABEQAAAAAB4ACBABAAAAZQAAAEdFT1JHRSxU
SElTQVBQUk9BQ0hXT1VMRE5UU09MVkVNWVBST0JMRU1BTkRTRUVNU01PUkVDT01QTEVYVEhBTk5F
Q0VTU0FSWUFOWVNPTFVUSU9OVEhBVERPRVNOVEFMTE9XTUUAAAAAAgF/AAEAAAA1AAAAPDkxOTk0
QzUzRUM4OUQwMTE4ODkyMDAwMEMwQjZBOEU5MDkxNjhDQGVuY3JhZnQuY29tPgAAAAAYjQ==

------ =_NextPart_000_01BF48CF.D92C6CC0--