Hi Diane,
Unfortunately I am way too familiar with this kind of thing – although I actually discovered five ways to spell Mississippi in our system. Also, apparently Arkansas is a country in Europe.
Sadly, I don’t know of an easy way to fix this short of searching for the incorrect spellings and then doing a batch-change, but perhaps others might. In our case, part of my project was to look at all the records very carefully, so I had to combine these batch changes with looking at each record individually. A terrifying prospect, I know.
Sarah
Sarah J Biggs | Collections Cataloguer
Saint Louis Art Museum
1 Fine Arts Drive
St Louis, Missouri
63110
314.655.5374
[log in to unmask]<mailto:[log in to unmask]>
https://nam02.safelinks.protection.outlook.com/?url=www.slam.org&data=02%7C01%7Ctmsusers%40si-listserv.si.edu%7Cefada2c74dc1453ea5e708d6bea30b62%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C1%7C0%7C636906004814522664&sdata=eaQYwo4PW0i4iNqeZUVWWAhcCtTwY6pP%2FUZbruw9lzs%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.slam.org%2F&data=02%7C01%7Ctmsusers%40si-listserv.si.edu%7Cefada2c74dc1453ea5e708d6bea30b62%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C1%7C0%7C636906004814522664&sdata=IQAKY8R5Ke6xk2Plpr1jzY3dtUozbzE8zlBylwyACvQ%3D&reserved=0>
[/Users/jpelhank/Library/Containers/com.microsoft.Outlook/Data/Library/Caches/Signatures/signature_832476735]<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.slam.org%2Fexhibitions%2Frachel-whiteread%2F&data=02%7C01%7Ctmsusers%40si-listserv.si.edu%7Cefada2c74dc1453ea5e708d6bea30b62%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C1%7C0%7C636906004814522664&sdata=dDMpdSgk2FpgqBZ6IH76i%2F3fnFbaF1OvU8LKg8aUCG8%3D&reserved=0>
[signature_1867022149]<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FSaint.Louis.Art.Museum%2F&data=02%7C01%7Ctmsusers%40si-listserv.si.edu%7Cefada2c74dc1453ea5e708d6bea30b62%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C1%7C0%7C636906004814522664&sdata=Sfivgc%2BITIJpOd8xWX01FsWtRkhYNUsyRAtTEsRNvuw%3D&reserved=0> [signature_1726913623] <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fstlartmuseum%2F&data=02%7C01%7Ctmsusers%40si-listserv.si.edu%7Cefada2c74dc1453ea5e708d6bea30b62%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C1%7C0%7C636906004814522664&sdata=pcSobThESPuVhlGb1SVCQkAJZVpy94yIpApvYt67Fww%3D&reserved=0> [signature_1657873252] <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FStlArtMuseum&data=02%7C01%7Ctmsusers%40si-listserv.si.edu%7Cefada2c74dc1453ea5e708d6bea30b62%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C1%7C0%7C636906004814522664&sdata=LeoXqSh%2FeGGYHgVd9BSCA6Go03Kys8eOa%2BJg8ZlxqpE%3D&reserved=0> [signature_1069970599] <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fuser%2FSaintLouisArtMuseum&data=02%7C01%7Ctmsusers%40si-listserv.si.edu%7Cefada2c74dc1453ea5e708d6bea30b62%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C1%7C0%7C636906004814532677&sdata=mPcFFyNc6%2FCxA9ges%2BQV1D2YX9zB4S1hyc0SZZOUe%2BI%3D&reserved=0>
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Diane Karlson
Sent: Thursday, April 11, 2019 10:38 AM
To: [log in to unmask]
Subject: Geography section of Objects Module
Happy Friday Eve-
Recently, I discovered in the geography section of the Object Module is not an authority field but a fill in the blank type.
Did you know there are three ways to spell Mississippi if you looked at our database?
Is there a way to clean up this field using a package or a report?
Thanks-
Diane
Diane Karlson
Museum Registrar
William J. Clinton Presidential Library
1200 President Clinton Avenue
Little Rock, AR 72201
501.244.2842
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.