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.