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:
Re: batch changing object number
From:
Julie Thies <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Thu, 17 Aug 2017 15:15:17 +0000
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (2597 bytes) , text/html (8 kB) 
You might want to consider using the accession lot tool.
You can batch object numbers there.

Good luck,
Julie

Julie Thies
Head of TMS Administration
The Menil Collection
713-525-9468


From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of David Lowe
Sent: Thursday, August 17, 2017 10:11 AM
To: [log in to unmask]
Subject: Re: batch changing object number

Caroline,

I was once overly cavalier about changing ObjectNumbers with SQL and regretted it. There are lots of dependencies. I'm sure it could be figured out, but.... When I needed to change a bunch of numbers a second time, I actually pulled all the records out into spreadsheets, deleted the original records, then used the Batch Importer to put them back in (and other SQL updates for info the Importer didn't include).

David


David Lowe | The New York Public Library
Specialist II, Photography Collection

Photographers' Identities Catalog<http://pic.nypl.org>

On Thu, Aug 17, 2017 at 10:50 AM, Caroline Im <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Hello all,

We have some object numbers entered wrongly by an intern who confused 1 with I for about a hundred entries. I would like to just edit it directly in SQL Server using the Object Number column. However, I do see that there are other columns that use run off the Object Number. For example, SortNumber is an edited version of ObjectNumber, as is SearchObjectNumber.

Would it be a terrible idea to edit these three fields in SQL Server directly, or are there are caveats and other places that use ObjectNumber and it would cause a distressful mess?

Is there anything anyone does specially?

TMS does have a "change object number" option but that is per object/ entry and would take us ages to do one by one.

To unsubscribe, send an email to [log in to unmask]<mailto:[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]<mailto:[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.

ATOM RSS1 RSS2