Jeff, the Display Order can be fixed using the DBConfig > Maintenance >
Database > Update ConXref Display Order.


On Mon, Feb 24, 2014 at 5:55 PM, Richard Grant <[log in to unmask]> wrote:

> Dimitry helped us come up with a SQL query to gang in a ConXref for a
> particular constituent to everything in an object package. The only
> restriction is that you have to know the display order in advance and it
> must be consistent across all the object records. This might keep it from
> being usable for you. If anyone wants it I would be happy to send it out.
>
>
>
> Dick
>
>
>
>
>
> Richard Grant
>
> Executive Director
>
> The Richard Diebenkorn Foundation
>
> 3214 College Avenue
>
> Berkeley, CA 94705
>
> 510-428-1400
>
> 510-459-4556 (mobile)
>
>
>
>
>
>
>
> *From:* The Museum System (TMS) Users [mailto:[log in to unmask]]
> *On Behalf Of *David Lowe
> *Sent:* Monday, February 24, 2014 2:03 PM
> *To:* [log in to unmask]
> *Subject:* Re: Adding Constituents to an Object using SQL
>
>
>
> 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.
> 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.