TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Adding Constituents to an Object using SQL
From:
David Lowe <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Mon, 24 Feb 2014 16:24:23 -0500
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (871 bytes) , text/html (1078 bytes) 
I've used the TMS Bulk Importer to migrate legacy records from our Catalog
and from our Digital Gallery into TMS. This has worked pretty well, as I'm
dealing with several 10s of thousands of records. *However*, you can only
put one Constituent in that way. I've been able to write SQL to map other
data which isn't accommodated by the Bulk Importer, but the relationships
between Objects & Constituents tables is impossibly complex to me. If I
upload a table AddConstit with ConstituentID, ObjectID, and RoleID, how do
I actually attach the name to the object? Any SQL masters out there?
Thanks in advance,
David Lowe
Photography Specialist
New York Public Library

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.

ATOM RSS1 RSS2