That’s our current tactic actually…we have the skills in-house, but IT folks have everything locked down. Trying to convince the powers that be that they need to insist that we have some control. Frustrating to be a db admin, but not be able to get on your servers….<sigh> …that’s the end of my Friday pity-party…sorry to the rest of you getting sucked into the string J
Everyone have a great weekend!
==================================================================
Diane Lee | Collections Manager
[log in to unmask] | (860) 236-5621 x(242)
Connecticut Historical Society | One Elizabeth Street | Hartford, CT 06105 | www.chs.org
Upcoming Events | Membership | Donate | Volunteer
Visit us on Facebook and Twitter @ConnHistSoc
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of David Lowe
Sent: Friday, June 06, 2014 5:00 PM
To: [log in to unmask]
Subject: Re: search and replace null field?
Diane,
who is it you would ask permissions from? Perhaps they'd do it for you, if they have the skills? Else, nominate your most tech savvy (or simply willing) staff member to learn some basics. Then convince them to give you permission for that one person, promise to always back everything up before making any changes... You'd be amazed at the data cleaning & augmentation you can do in minutes versus months (or years).
On Fri, Jun 6, 2014 at 4:52 PM, Diane Lee <[log in to unmask]> wrote:
No permission L - and IT contractors, so we have to pay them for any jobs, and I’m trying to avoid that if possible.
I will save your email though David, in the misguided hope that someday they’ll let us on!!
Thanks!
Diane.
==================================================================
Diane Lee | Collections Manager
[log in to unmask] | (860) 236-5621 x(242)
Connecticut Historical Society | One Elizabeth Street | Hartford, CT 06105 | www.chs.org
Upcoming Events | Membership | Donate | Volunteer
Visit us on Facebook and Twitter @ConnHistSoc
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of David Lowe
Sent: Friday, June 06, 2014 3:53 PM
To: [log in to unmask]
Subject: Re: search and replace null field?
A tiny bit of SQL goes a long way! You could update those 5,000 records in less time it took to ask the question. (I realize you have to have permissions to access the server, which is probably not the case with most folks).
Update Objects
Set Cataloger = ' [cataloger's name] '
Where ObjectNumber in ( [list of ObjectNumbers separated by commas] )
Perhaps someone in your IT department can do you a (VERY) quick favor?
On Fri, Jun 6, 2014 at 3:32 PM, Diane Lee <[log in to unmask]> wrote:
Boo on not being able to do it – and yes, this would be an extremely useful feature!!
Thanks all for the replies – and maybe Gallery Systems will give us a present and it’ll be in TMS2014! Not that’ll it’ll help me for the 5000ish record project I’m working on this summer…..
Diane.
==================================================================
Diane Lee | Collections Manager
[log in to unmask] | (860) 236-5621 x(242)
Connecticut Historical Society | One Elizabeth Street | Hartford, CT 06105 | www.chs.org
Upcoming Events | Membership | Donate | Volunteer
Visit us on Facebook and Twitter @ConnHistSoc
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Karen Hines
Sent: Friday, June 06, 2014 2:58 PM
To: [log in to unmask]
Subject: Re: search and replace null field?
Funny this appears now - I was also trying to perform this (unsuccessfully) earlier this week and had started an email to send out and see if anyone else knew of a way to do this. It would be extremely useful and time saving!
Thanks,
Karen
Karen Casey Hines Assistant Registrar Frances Lehman Loeb Art Center
Vassar College Box 703, 124 Raymond Avenue, Poughkeepsie, NY 12604 | T845.437.5249 F845.437.5955
April 11 - June 29, 2014 Mastering Light: From the Natural to the Artificial
On Fri, Jun 6, 2014 at 2:42 PM, Hansen, Stephanie <[log in to unmask]> wrote:
I wasn't able to do that either, but it would be a great feature!
Stephanie Hansen
Database Administrator / Assistant Registrar for Exhibitions & Loans
Milwaukee Art Museum
700 N. Art Museum Dr. | Milwaukee, WI 53202
Tel. 414.224.3273 | Fax. 414.271.7588 | [log in to unmask]
Kandinsky: A Retrospective
Opens June 5th
On Fri, Jun 6, 2014 at 1:39 PM, Kimberly Koons <[log in to unmask]> wrote:
Diane -
Our understanding is that you cannot search on null and replace with data using Search/Replace, but we have asked Gallery Systems to work on adding this function. Our users could really use this. Perhaps if others chime in it might encourage making this happen :)
Kim Koons
Office of Presidential Libraries
National Archives
On Fri, Jun 6, 2014 at 1:53 PM, Diane Lee <[log in to unmask]> wrote:
Hello all –
Wondering if anyone has any tricks for me. I’m working on groups of bulk loaded records, and trying to update the Cataloguer Field using the Search and Replace utility. Currently the field has nothing in it, and I want to add the cataloguers name to all the records so we don’t have to do it record by record.
I am able to do it when there is something in the field, but if I don’t put anything in the Search it just sits there and doesn’t do a thing.
Anyone have any ideas what I could put into the field to get it to work?
Thanks!
Diane.
==================================================================
Diane Lee | Collections Manager
[log in to unmask] | (860) 236-5621 x(242)
Connecticut Historical Society | One Elizabeth Street | Hartford, CT 06105 | www.chs.org
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.
--
Kimberly Koons, Presidential Libraries Museum Collections Officer
National Archives & Records Administration
700 Pennsylvania Ave., NW
Washington, D.C. 20408
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.
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.