TMSUSERS Archives

The Museum System (TMS) Users

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

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

Print Reply
Message-ID:
<[log in to unmask]>
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
Adding Constituents to an Object using SQL
From:
David Lowe <[log in to unmask]>
Date:
Mon, 24 Feb 2014 16:24:23 -0500
Content-Type:
multipart/alternative; boundary=f46d0435c08273eb4204f32d98a3
MIME-Version:
1.0
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
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