Sounds like a plan - thanks, Danielle.
Kim
*From*: Danielle Uchitelle [mailto:[log in to unmask]]
*Sent*: Thursday, December 18, 2014 03:31 PM
*To*: [log in to unmask] <[log in to unmask]>
*Subject*: Re: Alpha sort for titles starting with "The"?
Kim,
TMS 2014 is release-ready right now (we’re still revising some technical
documentation), so it wouldn’t be a candidate for this new feature, but
we’re already working on a TMS 2014 service pack that will have some new
features. My hope is that this new title sort feature will show up in the
service pack.
Best,
Danielle
*From:* The Museum System (TMS) Users [mailto:[log in to unmask]] *On
Behalf Of *Kimberly Koons
*Sent:* Thursday, December 18, 2014 4:03 PM
*To:* [log in to unmask]
*Subject:* Re: Alpha sort for titles starting with "The"?
Danielle,
When you say the 'next release', can you clarify, please - are you
referring to TMS2014, or something later?
thanks!
Kim Koons
Office of Presidential Libraries
National Archives & Records Administration
On Tue, Dec 16, 2014 at 2:58 PM, Danielle Uchitelle <
[log in to unmask]> wrote:
Chad’s is a good interim approach, but it would be useful to have a title
sort field in the Objects module, analogous to the Alpha Sort field in
Constituents, which is both automatically created and editable. We’ve
added this to the enhancement list for the next TMS release.
Danielle
------------------------------
Danielle Uchitelle *| *Managing Director
[log in to unmask] *|* 646.733.2239 x264
*GallerySystems | *www.gallerysystems.com
*From:* The Museum System (TMS) Users [mailto:[log in to unmask]] *On
Behalf Of *Chad Petrovay
*Sent:* Monday, December 15, 2014 3:31 PM
*To:* [log in to unmask]
*Subject:* Re: Alpha sort for titles starting with "The"?
You could use some snazzy SQL to help with that:
CASE WHEN Title LIKE 'The %' THEN SUBSTRING(Title,5,LEN(Title))+', The'
ELSE Title END AS TitleSort
Add this as a separate field, and include in list views and report. Is
reports, you would use it in the sorting formulas and in list views you
would place it after the title, hide it, and set the title to sort by the
next field.
Chad Petrovay *| *Project Manager
[log in to unmask] *|* 646.733.2239 x252
*GallerySystems | *www.gallerysystems.com
On Mon, Dec 15, 2014 at 2:09 PM, Morgan, Amber <[log in to unmask]> wrote:
Just wondering how others are handling data entry for titles that begin
with the word “the.” Our curators dislike how including “The” at the
beginning interferes with alpha sort. But the idea of entering the titles
inverted seems absurd to me. For example, a film called “The Chelsea
Girls” will alpha sort under the letter T. Is there a way to get it to
sort under the letter C without changing the title to “Chelsea Girls,
The”? The only thing that comes to mind is creating a separate title type
for alpha sort, sort of like the alpha sort field in constituents. But in
order for it to work, we’d have to enter an alpha sort field for everything
and build reports and views that display that field rather than the primary
title. I’m sure that would work but we just don’t have time to do that
kind of data entry. Anyone have any clever tricks for this?
Thanks,
Amber
*the warhol**:*
*Amber E. Morgan*
Collections Manager
117 Sandusky Street
Pittsburgh, PA 15212
*T* 412.237.8306
*F* 412.237.8340
*E* [log in to unmask]
*W* www.warhol.org
*The Andy Warhol Museum*
*One of the four Carnegie Museums of Pittsburgh*
Email newsletter http://members.carnegiemuseums.org/email
Membership http://members.carnegiemuseums.org/SupportCMP
warhol: facebook <http://www.facebook.com/thewarholmuseum> | warhol: twitter
<http://www.twitter.com/thewarholmuseum>
The information contained in this message and/or attachments is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the sender and
delete the material from any system and destroy any copies. Any views
expressed in this message are those of the individual sender.
To unsubscribe, send an email to [log in to unmask] with the
following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the
following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the
following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
--
Kimberly Koons, Presidential Libraries Museum Collections Officer
National Archives & Records Administration
700 Pennsylvania Ave., NW
Washington, D.C. 20408
202-357-5082
301-837-0873
To unsubscribe, send an email to [log in to unmask] with the
following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the
following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.