Ha, yes, I've learned a few SQL lessons the hard way!
On Mon, Feb 24, 2014 at 4:59 PM, Smith, Jeffrey <[log in to unmask]> wrote:
> David,
>
>
>
> I have successfully inserted constituent links between objects and even
> media records using SQL, but you have to be very CAREFUL and there must be
> consistency concerning display order (among other things) in the records
> you are batch updating this way. It can be done, but is you must be super
> methodical!
>
>
>
> *From:* The Museum System (TMS) Users [mailto:[log in to unmask]]
> *On Behalf Of *David Lowe
> *Sent:* Monday, February 24, 2014 4:24 PM
> *To:* [log in to unmask]
> *Subject:* Adding Constituents to an Object using SQL
>
>
>
> 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.
> 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.