Hi Jeremy, we recently set up a TMS/ResourceSpace integration for the Williams College Museum of Art. The college is sharing RS with three departments. The Museum needed the TMS integration and I will be happy to share what we learned. I will add more detail tomorrow.   Jim Allison WCMA Collections Developer. 

On Mon, Nov 20, 2017 at 12:03 PM, Jeremy Munro <[log in to unmask]> wrote:

Hi all,

 

We recently migrated to ResourceSpace for our DAMS which has a TMS plugin in order to populate metadata using ObjectID. However, it can only function on a singular table or a data view. The fields I want populated upon upload live on two tables – Objects and ObjRights. However, I also want the artist as well. I’m hoping to get around having to include the constituent tables by creating a new view off vgsrpObjTombstoneD_RO and vgsrpObjRightsS_RO, is this possible?

 

Regardless, I don’t have much experience with creating new views database side I was wondering if anyone could help me out with the syntax for adding the following fields to a new database view?

 

Artist

Title

Date

Medium

Dimensions

Object Number

Department

Credit Line

Copyright

Restrictions

Credit Line Repro

Thanks!

 

Jeremy Munro

Collections Information Coordinator

 

Crystal Bridges Museum of American Art

600 Museum Way

Bentonville, AR 72712

 

479.418.5710 (direct)

479.418.5700 (main)

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