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.