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:
From:
Chad Petrovay <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Thu, 17 Aug 2017 12:14:40 -0400
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (3352 bytes) , text/html (8 kB)
It is possible to change ObjectNumber in SQL server, but here are the
following considerations:

1. Update both the ObjectNumber, and SearchObjectNumber values for the
Object record.
2. Update the ComponentNumber for the Component Record.
3. Optionally, add the previous number to alternate numbers to aid in
discovery.
4. Add the change to the Audit Trail.

The Sort Numbers can be fixed afterwards using DBConfig.

It is possible to fix this using a cursor; but as Julie pointed out the
Accession lot tool may be an easier solution. ~Chad

On Thu, Aug 17, 2017 at 11:15 AM, Julie Thies <[log in to unmask]> wrote:

> 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 <(713)%20525-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]> 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] 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.


ATOM RSS1 RSS2