Good to know. And I'm not on 2016, so I guess I was butting up against the 64 character limit. *David Lowe | The New York Public Library**Specialist II, Photography Collection* *Photographers' Identities Catalog <http://pic.nypl.org>* On Thu, Jun 8, 2017 at 10:39 AM, Danielle Uchitelle < [log in to unmask]> wrote: > David, > > > > Modifying column properties at the database level is not support in TMS, > and I’d strongly discourage doing it. For one thing, database field > properties are linked to associated controls in the user interface, so if > the control – for example, the one used for input and display of alternate > numbers – is not in synch with the underlying field length and data type > properties of the column, errors and potential data corruption and loss are > possible. Additionally, indexes for data searching are based on known > field lengths and data types, so search results could become unpredictable. > > > > We always welcome input from users regarding field lengths and use cases > for changing them. In the case of the Alternate Number field, at the > suggestion of TMS users we increased the field length from 64 characters to > 450 characters in TMS 2016. > > > > Best, > > Danielle Uchitelle > > > > *From:* The Museum System (TMS) Users [mailto:[log in to unmask]] > *On Behalf Of *David Lowe > *Sent:* Thursday, June 8, 2017 10:00 AM > *To:* [log in to unmask] > *Subject:* Re: Adding VIAF and other linked data references to > Constituents > > > > Has anyone changed the field properties to allow for > 450 characters? I > have some longer urls that got truncated, which is why I repurposed the > Remarks field. I worried that if I changed the properties of the altnum > field I'd lose some links once we upgrade to the current version. > > On Thu, Jun 8, 2017 at 9:18 AM Danielle Uchitelle <danielle.uchitelle@ > gallerysystems.com> wrote: > > At Gallery Systems, our recommended best practice for leveraging linked > data such as VIAF and ULAN is to use the Alternate Number field to hold > this information, as Jeff, Emmanuelle, and others have already said. > > Beginning with TMS 2016R2, the Alternate Number field can include a URI > that is dereferenceable (resolvable) to any linked web resource, so that > clicking on the link within the TMS record immediately opens the associated > web page in a browser: > > If you are using eMuseum to publish your collection information, these > linked data references will allow you to include canonic information from > the linked authority in your museum’s collection website. I’ll be hosting > a webinar later this summer to demonstrate this feature using eMuseum 5.1, > the latest version supporting linked open data. > > Regarding field lengths, an argument can be made for entering only the > root ID (in the above example, the ULAN ID 500017300) rather than the > entire URL (http://vocab.getty.edu/ulan/500017300). This would assure > that the linking ID would fit easily within the 450 character limit of this > field, and would also make it easier to manage in cases where a linked web > server changed URL addresses without any change to the URI, although this > should not happen often. Entering the ID without the full URL would still > allow linking data using eMuseum but would mean that you wouldn’t have a > dereferenceable URL to click on inside TMS. In practice, I’ve sometimes > done both in the same record, using the Alternate Number description field > to denote separate rows for ULAN ID and ULAN Subject URL. > > Best, > > Danielle Uchitelle > > > ------------------------------ > > Danielle Uchitelle *| *Chief Operating Officer > > [log in to unmask] *|* 646.733.2239 x264 <(646)%20733-2239> > > *GallerySystems | *www.gallerysystems.com > > > > > > > > *From:* The Museum System (TMS) Users [mailto:[log in to unmask]] > *On Behalf Of *Delmas-Glass, Emmanuelle > *Sent:* Wednesday, June 7, 2017 3:55 PM > *To:* [log in to unmask] > > > *Subject:* Re: Adding VIAF and other linked data references to > Constituents > > > > Same as Jeff: Constituent alternate numbers – using the full VIAF URL as > the number and with ULAN chosen from the drop down as source of the data. > > Emmanuelle > > > > Emmanuelle Delmas-Glass > > Collections Data Manager > > Yale Center for British Art > > 203-410-4069 <(203)%20410-4069> > > > > > > > On Jun 7, 2017, at 19:27, Smith, Jeffrey <[log in to unmask]> wrote: > > Constituent alternate numbers – using the full VIAF URL as the number. > > > > *From:* The Museum System (TMS) Users [mailto:[log in to unmask] > <[log in to unmask]>] *On Behalf Of *Welsh, Sylvia C. > *Sent:* Wednesday, June 07, 2017 11:20 AM > *To:* [log in to unmask] > *Subject:* Adding VIAF and other linked data references to Constituents > > > > Hello TMS list, > > > > I was wondering where in your Constituents Module you add information from > VIAF, etc.? We are looking to start adding that data and were wondering if > anyone had suggestions for best practices? > > > > Thank you, > > > > Sylvia, > > > > _____________________________ > > *Sylvia Welsh, MS LIS, CSI, LEED AP BD+C* > > > > Harvard Property Information Resource Center > > 1350 Massachusetts Avenue, 547 > > Cambridge, MA 02138 > > T 617-496-8275 <(617)%20496-8275> F 617-495-0559 <(617)%20495-0559> > > > > 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. > > -- > > *David Lowe** | **The New York Public Library* > *Specialist II, Photography Collection* > > *Photographers' Identities Catalog <http://pic.nypl.org>* > > 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.