[slinkelist] Sorting albums, any ideas ?

Fri, 17 Dec 1999 11:46:38 -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_01BF48C7.7072CF40
Content-Type: text/plain

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_01BF48C7.7072CF40
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IioTAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAAzwcMABEACwAuACYABQBXAQEggAMADgAAAM8HDAAR
AAsALgApAAUAWgEBCYABACEAAABBRDQ4OThDQURGQUZEMzExOEE0NzAwMDBDMEI2QThFOQBWBwEE
gAEALQAAAFJFOiBbc2xpbmtlbGlzdF0gU29ydGluZyBhbGJ1bXMsIGFueSBpZGVhcyA/AK4PAQ2A
BAACAAAAAgACAAEDkAYAoA0AADMAAAADAAlZAQAAAAMA3j+vbwAAAwA2AAAAAAADAAWACCAGAAAA
AADAAAAAAAAARgAAAABShQAAJ2oBAB4ACYAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAA
ADkuMAALAA6BCCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAAMACoAIIAYAAAAAAMAAAAAAAABG
AAAAAAGFAAAAAAAACwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAALABOACCAGAAAAAADA
AAAAAAAARgAAAAAOhQAAAAAAAAMAAoAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAUgAgg
BgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADABaACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAA
AB4AJYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeACaACCAGAAAAAADAAAAA
AAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgAngAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAAB
AAAAAAAAAAIBCRABAAAAxgcAAMIHAADhDgAATFpGdeImxJADAAoAcmNwZzEyNeIyA0N0ZXgFQQED
Aff/CoACpAPkBxMCgA/zAFAEVj8IVQeyESUOUQMBAgBjaOEKwHNldDIGAAbDESX2MwRGE7cwEiwR
MwjvCfe2OxgfDjA1ESIMYGMAUDMLCQFkMzYWUAumIEmQIGp1cwVAcG8dMNEJgCBhIACQbQMQCsFF
BaBtC1N0L3MG8HUUdGkCICAfcXRoZeggQkIF8GEBgBKBFBAHCsAT0AuAZyBkaWQcbicFQB5xH/B1
cCDnA/Af0B3Abnkf0CESGCAZB0BseSIAFBBmdWzsLiAF0CNwbgngHbAEACkfwG8gE+B2H/BDRPpK
IUFzC1EjcB/SCsAfUP8dMAQgC4AfwwWwBIEc4SWwcwWQBpB5LB3gJOAf0nHlClByI3BkbweQIYIf
4O5sIiAf0RggLgqiCoQKgEZUH+EfFyh0dyTgIpEmVCIgZgiQbGQmtzEHQGJ1bR/AAaBsZfwtLQIg
H/Ak0SORLLAFsf8fECZhISEAcB2wJwMp8i6q5SWVKSChZW0EIB3xC1D7LpMYIHQDYCzABUAe0STg
7yVSIkIIYAVAbRrQInAsAPxyaycxNOIo8C5QNFAn0OMjwSNhd2UnI1Ax8iSQ/zNxMoIHgAIwHaEf
EAIgKkvrLlA5IU8FEGcLgAdABdBxB5BzYWcuQTkhKlRGYQNhOiBHZQWwOlAgdlQAcCEwWwDAAxAk
0DpJO4RUQAWgbmMIcC79HnFdKlQGYAIwO2A7ICFgWyXgKDBEBZAyIGISgTESNygwMTlAECA5OjQy
NxDATSq1PKAgJ15TBaACQAYAJ9FrBJAn8jtBUHNsC4BCEEKQHTCyQAMAcnYEAD2iJz31mHViagWQ
PoFSRTtgultCiF0GAC92LbJzKDDXIpEkkAEAYQQgPypaKrinIyEfEAOgd2gjcHkIYP8hRjbiRuIY
IAtQCJAmsQQg+T+AY2Eu4iLBSzMDkQbw/x2wF7AhICpUH1Ah4R0wL+H/IRIEAQpQI/JG4iWRPXAE
EF8fYQQgJQMHQCMhZCXxYf9CEAOgC1E/UB+UBABNNTXw6w3gI/FPLoF3JeIk4CkgO0v3JNF3BRAO
sExyQWPPP1AEESjEH9BhdDaiU5N5H/BqbwwwKmMvIkmict9V8DCDE+ADoAOBdTnRCYC7IlAj8VlJ
sUugA6BlJSD/A6AUETcSIhEoU1XwSZNQBO0qVFcLgCkgdzJBNFAAIO89cAVAVdYLYHU9YCJwVQS/
KDA18R+0PuABkUdQZUbC/R2wcl4QHcIFA001VeVgUvsohyPxQjRxSaMk4CRTJNH+Y0KQQgAfllzo
MuFgYSJQ7ypUWJQjYCpLSDXxS/Qpoo9DgCpUO4kqWlAuUyPw7kMf4GRRH9JOQ0MgAy8i/zBkRyRR
lSTBUoI4bzl/Oo7tQogtUJAeEG5DKTw3cT9NQzhdUuAqVEJlE+BsfmZS0HYAQXs9/z8PQBQw/0Aw
QKpCjz2iQ+9E/0YPRx/9KodXKbADIBzwSe9K8yPw/klWAB2wP4AkQA3gNwF2AL8lVDACJKFXVi3A
BUBuMGDbZhcjcHADYAnAYTIxJQP7hCQgwHQIcC8MQuJopipU/EknhsJQ4yTRHxFDYE5C+11SH/Bi
YFBUoS8hUWFTIr4ujHBYiiERgoGJsmcucdNhFgNgdWcicG0l8SJQ/y4wTGIdsBPRISAdojaxLWi/
b3AHgnqgQhAsICsSWJJjdyygJNAqVCKSZCgwKxEif4KBWiEh0kugFBAEIBz1ZO0DYHAn0B2wIh/R
LKAFsf0sMCIoMITyBGAdMTNAH8JvTTkc8EvEkfEslCAqWkb/NUJV4VnxbLFWAAQgNPEf0P4sdyVB
gm4fby9wP3OPcl93c290f3WLTQ3gE+ApsCC/Z8AXsAqwC4AJ8HcqVApQMnN4E05vJSA/czMw4z/l
DiA6NDV5z3rfe+3vfR9+L38/KqVEKTEigi5y/muFMAfgHdBYUVChUyVc4/es5SQAB0BwE+A/gB9Q
S6B9I1JiI3AmVCpUkWIkkGf/hTAFECEhmQOT8i/TlrG1df5utWEmYWQgJyIfwyzAFAD/hRG0EjNA
KlQmVDQXB0Agcf+0prQEJqApsHYArhsrElbQ/0NgCGAyQR8mTCJfHC7TAHDvMGQswyTCC4BwXUOO
Nbi1/7QEA6ABAACQGCEvEgDABUD/LyNc8o1idVXABIYCLiEt4P8dMAMQAyBoMrAhJNGeYAVA7yVS
LrVbE79ELyvQXHEOwNopKktBrYFOkGeeYMTR8x9xrhUoSXYAHPAYIAeAfz9zBaEYIHyQI2AoMCbR
IvdPcSTQHhB6H/Af4FCQBJD/ksEqAlMRBCCFMFMVKlQLgP1kIHUBAK1jUJCNMgIgneH7DrMsxCmI
6ySxzUOtciEA/8+QUQGeYDIxl5HGE1siiaD7LeBeEGFTIIeRl5NbMSNB/8V0I5G4VbmyndAfUCUh
x6OfH5K9964bHhCk1ChB0Ov9KlRf2u/b/9zKKlSpaFiBc8TxuOIgLSQAqW+qeGhBAkBwOi8vd+HQ
Lu1DOC88UgOBL0LiC4ACEP8fAN/H2c/af+aP55/dr96//9/P4N/h7+L/5A/lH/Ev8j//6E/pX+pv
63/sj+2f7q8qgQJ9+wAAAB4AcAABAAAAKQAAAFtzbGlua2VsaXN0XSBTb3J0aW5nIGFsYnVtcywg
YW55IGlkZWFzID8AAAAAAgFxAAEAAAAbAAAAAb9ItqU/yphInq/fEdOKRwAAwLao6QADaiAQAAMA
JgAAAAAAAwAuAAAAAAALAAIAAQAAAB4AQhABAAAAMgAAADxENDcxMDM5RkNCOEZEMzExQkJBNjAw
OTAyN0I4RDQ1NzAxM0Q1RUYxQEdFTUlOST4AAAADAP0/5AQAAEAAOQCQqu5ux0i/AQMA8T8JBAAA
HgAxQAEAAAAJAAAATUlDSEFFTFIAAAAAAwAaQAAAAAAeADBAAQAAAAkAAABNSUNIQUVMUgAAAAAD
ABlAAAAAAAMAgBD/////CwDyEAEAAAACAUcAAQAAAC4AAABjPVVTO2E9IDtwPVNlcmVuZXQ7bD1I
T1NULVMxLTk5MTIxNzE5NDYzOFotNDEAAAACAfk/AQAAAE4AAAAAAAAA3KdAyMBCEBq0uQgAKy/h
ggEAAAAAAAAAL089U0VSRU5FVC9PVT1DT1JQT1JBVEUvQ049UkVDSVBJRU5UUy9DTj1NSUNIQUVM
UgAAAB4A+D8BAAAADgAAAE1pY2hhZWwgUm9wZXIAAAAeADhAAQAAAAkAAABNSUNIQUVMUgAAAAAC
Afs/AQAAAE4AAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAAAAAAL089U0VSRU5FVC9PVT1DT1JQ
T1JBVEUvQ049UkVDSVBJRU5UUy9DTj1NSUNIQUVMUgAAAB4A+j8BAAAADgAAAE1pY2hhZWwgUm9w
ZXIAAAAeADlAAQAAAAkAAABNSUNIQUVMUgAAAABAAAcwQJ/rbsdIvwFAAAgwQM9ycMdIvwEeAD0A
AQAAAAUAAABSRTogAAAAAB4AHQ4BAAAAKQAAAFtzbGlua2VsaXN0XSBTb3J0aW5nIGFsYnVtcywg
YW55IGlkZWFzID8AAAAAHgA1EAEAAAA1AAAAPDkxOTk0QzUzRUM4OUQwMTE4ODkyMDAwMEMwQjZB
OEU5MDkxNjhCQGVuY3JhZnQuY29tPgAAAAALACkAAAAAAAsAIwAAAAAAAwAGEB1Gc08DAAcQegkA
AAMAEBAAAAAAAwAREAAAAAAeAAgQAQAAAGUAAABJSlVTVFBPU1RFREFTSU1JTEFSQ09NUExBSU5U
L1NPTFVUSU9OT05USEVCQlNBRlRFUlNFQVJDSElOR0RJRE5UQ09NRVVQV0lUSEFOWVRISU5HUkVB
TExZVVNFRlVMTVlORUVEAAAAAAIBfwABAAAANQAAADw5MTk5NEM1M0VDODlEMDExODg5MjAwMDBD
MEI2QThFOTA5MTY4QkBlbmNyYWZ0LmNvbT4AAAAAWNg=

------ =_NextPart_000_01BF48C7.7072CF40--