Cleanup Date Accessioned field - efmnhtransactions

rondlg commented 1 month ago

Discussed in https://github.com/fieldmuseum/EMu-Documentation/discussions/1069

^{Originally posted by **rondlg** June 5, 2024} Description: Date Accessioned (AccDateAccessioned) in Transactions is a Text field though it should be a Date field. It already has the calendar icon next to it. Do we want to correct this? If so, we first need to clean the data to match the Date format.

data in AccAccessionDate	Catalogue
10 October - 11 October 1963	Fossil Invertebrates
16 Februrary 1970	Fossil Invertebrates
1930's	Fossil Invertebrates
1961-1968	Fossil Invertebrates
197?	Fossil Invertebrates
25 Februrary 1947	Fossil Invertebrates
27 April -29 April 1949	Fossil Invertebrates
29 April - 1 May 1952	Fossil Invertebrates
3 Febuary 1949	Fossil Invertebrates
9 Februrary 1977	Fossil Invertebrates
Myron J. Umbach	Fossil Invertebrates
31 Jul 19814	Insects
02 Han 1970`	Insects
056 May 1978	Insects
10 Apr 14950`	Insects
11 Dep 1957	Insects
11 Jam 1971	Insects
158 Mar 1946	Insects
17 Apri 1947	Insects
20 Jan 1948`	Insects
20 Jun 1979`	Insects
58 Oct 1935	Insects
M. Holec : University of J.E.	Insects
R. M. Brattain	Insects
Jan, 30, 1962	Invertebrate Zoology
Nov. 18, 19785	Invertebrate Zoology
March 31, 19959	Invertebrate Zoology
13 2 2012	Invertebrate Zoology
13. Sept 1977	Invertebrate Zoology
15 9 2016	Invertebrate Zoology
16 11 2016	Invertebrate Zoology
17 Sept. 1923	Invertebrate Zoology
19 Februrary 2004	Invertebrate Zoology
21 9 2010	Invertebrate Zoology
Apil 4, 2008	Invertebrate Zoology
Asdug. 26, 1960	Invertebrate Zoology
Auag. 5, 1971	Invertebrate Zoology
Feb. 10., 1944	Invertebrate Zoology
May-50	Invertebrate Zoology
Nov.. 18, 1942	Invertebrate Zoology
11 Set 1958	Mammals
22 Spt 1959	Mammals
1891-92	Paleobotany
25-7-2014	Paleobotany
4-Jan-1951 ; 29-Nov-1950	Paleobotany
5-Jan-1972 ; 1-Nov-1967; 12-Oc	Paleobotany
May-39	Paleobotany
Octobe, 10, 2015	Paleobotany

rondlg commented 1 month ago

These collections all have records that need to be updated.

Mammals
Insects
Invertebrates
Paleobotany
FossilInverts

seanmkeogh commented 1 month ago

IZ records have been cleaned.

Mayer80 commented 1 month ago

Fossil Invertebrate records cleaned (assuming I understand how EMu wants dates entered).

Paul Mayer Collections Manager Fossil Invertebrates Gantz Family Collections Center Collections, Conservation, and Research Division

Primary Number (Cell) 312 401-2081

Office Phone 312.665.7631

The Field Museum 1400 S. Jean-Baptiste Pointe DuSable Lake Shore Drive Chicago, IL 60605-2429 fieldmuseum.org

@.***

On Wed, Jun 5, 2024 at 5:36 PM Sean Keogh @.***> wrote:

IZ records have been cleaned.

— Reply to this email directly, view it on GitHub https://github.com/fieldmuseum/EMu-Documentation/issues/1070#issuecomment-2151074261, or unsubscribe https://github.com/notifications/unsubscribe-auth/AXLPHXXDMMJU54D7WFRWLGDZF6HIPAVCNFSM6AAAAABI26WM2KVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNJRGA3TIMRWGE . You are receiving this because you were assigned.Message ID: @.***>

cmaves3 commented 3 weeks ago

In addition to those above, values with only numbers (month not spelled) should be reviewed by each department to ensure compatibility with EMu date format. The month may be written out but If kept as numbers, the dates need to be formatted as DD/MM/YYYY (slash or dash is ok). EMu reads 01/02/1999 as 01 Feb 1999 and 01/02/99 as 01 Feb 2099. Year should always be 4 digits.

The following departments have records with a slash or dash (/ or -): Amphibians and Reptiles - 2435 records Anthropology - 1 DONE Botany - 42 DONE Fishes - 909 Insects - 43 DONE Invertebrate Zoology - 1048 DONE Mammals - 3 DONE Paleobotany - 119 DONE

The records are in the Group "Accession Date Cleanup (slash 'n dash)" in Transactions. You can do an Intersect type Additional Search to see only your department's records. Please post when you have reviewed and updated your records.