<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body dir="auto">
<div>Peter</div>
<div id="AppleMailSignature"><br>
</div>
<div id="AppleMailSignature">I think what everyone is getting at is a batch edit rather than a global edit i.e. Identifying a batch of records using a search criterion and then performing a batch edit of those records to edit or augment the set. Specify has
toyed with various iterations of this idea and will likely include something like this in a future Specify 7 release - hopefully.</div>
<div id="AppleMailSignature"><br>
</div>
<div id="AppleMailSignature">Andy<br>
<br>
Sent from my iPhone</div>
<div><br>
On Oct 2, 2015, at 12:16 PM, Peter Rauch <<a href="mailto:peterar@berkeley.edu">peterar@berkeley.edu</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>
<div dir="ltr"><br>
<div class="gmail_extra">
<div class="gmail_quote">On Fri, Oct 2, 2015 at 9:39 AM, angie thompson <span dir="ltr">
<<a href="mailto:angie.c.thompson@gmail.com" target="_blank">angie.c.thompson@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">Tom,
<div><br>
</div>
<div>... You cannot yet create a record-set and update only those records included in the set.</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>How would you create a "record-set" without explicitly specifying each of the records that will need to be included in that set ?
<br>
<br>
</div>
<div>If you need to be that explicit, then can't you simply update each of those explicitly-selected records ?<br>
<br>
</div>
<div>It seems to me that the notion of "global" edit is not a proper characterization of the issue. It is precisely because there is no "global" set to search for, according to your scenario, that you can not do a "global edit".<br>
</div>
<div><br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div>... Granted, if you have someone who can work directly with the SQL database, none of these issues apply.</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>The same issue applies even in raw SQL queries. How would you search for / retrieve an arbitrary sub"set" of records that need to be changed if you can not "globally" identify those records ?
<br>
</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div>The edit records limitation only applies to interacting with data from the 'normal' interface. </div>
<div><br>
</div>
<div>I have asked the Specify crew about downloading ALL the data for each record into a huge spreadsheet, fixing the records that need tweaking, then blowing away the current install of Specify and reinstalling it. Shockingly*, this was not met with much approval.</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>Sounds very dramatic and not a sound approach. And, again, how would you "select" the records needing to be updated in Excel if there is no "global" characteristic of those records upon which to select ? You'd still have to identify them one by one, and
only then --perhaps-- update that group of records "globally". To do this, one would have to know something about manipulating (programming?) Excel, which raises the question about whether learning to use SQL sufficient to do the same task(s) might be a better
alternative.<br>
<br>
</div>
<div>If your problem is not actually one of having to select/retrieve/update a set of records ("some but not others") that can not be "globally" identified (as you state., " An example would be if a taxa is split, with some saying with the original genus but
others getting reassigned"), then just ignore the above comments, and perhaps clarify the actual problem that confronts you.<br>
<br>
</div>
<div>Peter<br>
<br>
</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div></div>
<div>-Angie</div>
<div><br>
</div>
<div><br>
</div>
<div>*note: It was not really shocking that the crew didn't approve. In truth, it was more shocking that nobody fainted at the notion. I would NEVER seriously suggest this as an option. But I think I did get my point across for how much we want GUI based mass
editing capabilities!</div>
</div>
<div>
<div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Fri, Oct 2, 2015 at 9:19 AM, Thomas J Trombone <span dir="ltr">
<<a href="mailto:trombone@amnh.org" target="_blank">trombone@amnh.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Hi Angie,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">If you and Lien don’t mind my jumping in, I have a question about Specify’s capabilities. Is there no means of performing a single global update operation
across a set of records? For example, in the case you gave where some records are assigned to a new taxonomic name, does the user need to edit each record individually as opposed to performing one operation that automatically edits all of them? (Or perhaps
some global updates are possible in Specify, but not in this particular case involving taxonomic reassignments?)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Alternatively, can data be exported, edited externally (in something like Excel or Access) and then re-imported, allowing one to avoid having to edit
each record individually?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">We use KE EMu in my department at AMNH but I’m always interested in learning about the alternatives, particularly Specify. Thanks!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Tom<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">__________________<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Thomas J. Trombone<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Data Manager<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Division of Vertebrate Zoology - Ornithology<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">American Museum of Natural History<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Central Park West @ 79th Street<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">New York, NY 10024-5192<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Phone:
<a href="tel:%28212%29%20313-7783" value="&#43;12123137783" target="_blank">(212) 313-7783</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Email:
<a href="mailto:trombone@amnh.org" target="_blank">trombone@amnh.org</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">URL:
<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__research.amnh.org_ornithology_&d=AwMFaQ&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=CLFZJ3fvGSmDp7xK1dNZfh6uGV_h-8NVlo3fXNoRNzI&m=z7Qo_ufelFNN-andM8YuVcOMHeswaYuyEbJqJ3dQNmg&s=2iUVEvjmbJwD1TDWaRux754w_a5y56CeooyXIvDVQvk&e=" target="_blank">
http://research.amnh.org/ornithology/</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:nhcoll-l-bounces@mailman.yale.edu" target="_blank">nhcoll-l-bounces@mailman.yale.edu</a> [mailto:<a href="mailto:nhcoll-l-bounces@mailman.yale.edu" target="_blank">nhcoll-l-bounces@mailman.yale.edu</a>]
<b>On Behalf Of </b>angie thompson<br>
<b>Sent:</b> Friday, 02 October 2015 9:52 AM<br>
<b>To:</b> NHColl<br>
<b>Subject:</b> Re: [Nhcoll-l] Has anyone had experience using Specify as electronic museum management system?<u></u><u></u></span></p>
<div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Lien,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">My lab has used Specify database for years. I love it. Everything is *finally* in one database - there's a table for scanning and attaching accession paperwork and permits, a table for publications so you can easily link specimens to their
citation history, all of our loans are 'in' and we can quickly find who is coming due. Use of authority tables and 'trees' that tie to lookup fields cuts down on misspellings, and helps keep mistakes down to a mild roar (our original database has issues with
people putting data into the wrong field, such as in the taxon field, they would put 'Jurassic'). <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">It's a complex thing but it's worth it. We make extensive use of wikis to train people, as well as to provide them with a quick reference. (wikis [dot] utexas [dot] edu/display/specify6/Specify+Database)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Finding the information you need is really quick, too. It's been a learning curve, of course, but we can now generate reports that count number of specimens per locality, how many research loans vs. outreach loans for any given year, and
so on. It's nice having good tools to look at the collections with, but it's also a great help for gathering statistical data about how the collection is *used*. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I find one of the biggest drawbacks is how hard it is to change information once it's in the database. If data got added incorrectly, or even if you just want to refine some information, in many cases each record has to be edited individually.
An example would be if a taxa is split, with some saying with the original genus but others getting reassigned. In this case, you would have to first update the taxon 'tree', then open *only* the records that are getting reassigned and edit each of them. Sure,
it's a small thing, but if you have a lot to do then it gets really tedious and time consuming. The silver lining is if *all* the specimens get reassigned, you just edit the 'tree' and the individual records tied to that entry all change (this features comes
with its own dangers, though!). <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Hope this helps. Feel free to contact me if you have other questions. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Angie<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Thu, Oct 1, 2015 at 6:37 AM, Huong Lien Tran <<a href="mailto:huong.tran@uq.net.au" target="_blank">huong.tran@uq.net.au</a>> wrote:<u></u><u></u></p>
<div>
<div>
<p style="background:white none repeat scroll 0% 0%"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Hi all, </span><span style="font-family:"Calibri","sans-serif";color:black"><u></u><u></u></span></p>
<p style="background:white none repeat scroll 0% 0%"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">I am posting for my colleague who is working in natural history collection management. Currently her museum in Vietnam
is looking to digitise their current specimens collections and is looking for an affordable management system. We've done some research and found that the common ones like KEmu or Vernon are a bit too expensive for their museum to handle. We've come upon Specify
(<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__specifyx.specifysoftware.org_specify7_&d=AwMFaQ&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=CLFZJ3fvGSmDp7xK1dNZfh6uGV_h-8NVlo3fXNoRNzI&m=InDsYKRaBducE-o3tDKHCN6uuQ0o7Lm03va1z7qaUrM&s=HI7xEF19TJNrx5S6GJap8u-oro_8dmJyrNXJhL5-zis&e=" target="_blank">http://specifyx.specifysoftware.org/specify7/</a>)
and it seems to be very good in the prospect of having local technicians handling the development and maintenance the database, keeping the cost at affordable level. Nevertheless, we would really want to have some insights from professionals who had experience
with Specify. Are there any pitfalls we should look for? Or maybe a contact points where we can get help when using Specify?</span><span style="font-family:"Calibri","sans-serif";color:black"><u></u><u></u></span></p>
<p style="background:white none repeat scroll 0% 0%"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Thanks You,</span><span style="font-family:"Calibri","sans-serif";color:black"><u></u><u></u></span></p>
<p style="background:white none repeat scroll 0% 0%"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Lien</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>Nhcoll-l mailing list</span><br>
<span><a href="mailto:Nhcoll-l@mailman.yale.edu">Nhcoll-l@mailman.yale.edu</a></span><br>
<span><a href="http://mailman.yale.edu/mailman/listinfo/nhcoll-l">http://mailman.yale.edu/mailman/listinfo/nhcoll-l</a></span><br>
<span></span><br>
<span>_______________________________________________ </span><br>
<span>NHCOLL-L is brought to you by the Society for the Preservation of</span><br>
<span>Natural History Collections (SPNHC), an international society whose</span><br>
<span>mission is to improve the preservation, conservation and management of</span><br>
<span>natural history collections to ensure their continuing value to</span><br>
<span>society. See <a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.spnhc.org&d=AwMF-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=CLFZJ3fvGSmDp7xK1dNZfh6uGV_h-8NVlo3fXNoRNzI&m=oyUNI-VgYKhdH18cnjvc_NgnfQS9ce5wVGs3dqCVH3Y&s=2Egtkne8Xn9TCqr3OqznK3BwQtxETl4f50e5CqV50C8&e=">http://www.spnhc.org</a> for membership information.</span><br>
<span>Advertising on NH-COLL-L is inappropriate.</span><br>
</div>
</blockquote>
</body>
</html>