TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Mime-Version:
1.0
Content-Type:
text/plain; charset="UTF-8"
Date:
Thu, 17 Aug 2017 10:50:38 -0400
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
Content-Transfer-Encoding:
quoted-printable
Message-ID:
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
From:
Caroline Im <[log in to unmask]>
Parts/Attachments:
text/plain (19 lines)
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.

ATOM RSS1 RSS2