Sounds like something we'd be interested in!


Jared Case
Head of Collection Information, Research, and Access
Motion Picture Department
George Eastman House
585-271-3361, ext. 334

The Nitrate Picture Show - May 1-3, 2015 at the Dryden Theatre, George
Eastman House
http://eastmanhouse.org/nitratepictureshow/The_Nitrate_Picture_Show.php


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.
>

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.