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
> <https://maps.google.com/?q=600+Museum+Way%0D+Bentonville,+AR+72712%0D+%C2%A0%0D+479&entry=gmail&source=g>
>
> Bentonville, AR 72712
> <https://maps.google.com/?q=600+Museum+Way%0D+Bentonville,+AR+72712%0D+%C2%A0%0D+479&entry=gmail&source=g>
>
>
>
> 479.418.5710 <(479)%20418-5710> (direct)
>
> 479.418.5700 <(479)%20418-5700> (main)
>
> CrystalBridges.org <http://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.