Data Entry Assistant (DEA) 2.0 Procedures
Introduction
This section contains information on the practices for preparing occurrence records for entry into the xBio:D database using the Data Entry Assistant (DEA) 2.0. The DEA2 web application requires that occurrence records be present in a properly formatted data entry template (File:Data Entry Template 28-Aug-2014.xls) file according to the Data Transcription Procedures protocol or a properly pre-formatted data entry template File:DEA data entry template-full 28-Aug-2014.xls.
The DEA Preparation steps do not have to follow the order defined in this document, but all of the parts specified do need to be completed when processing from verbatim label data. If pre-formatted specimen data is used, DEA2 will checked to see if the specified values are valid according to xBio:D Controlled Vocabularies.
DEA Preparation
Login
Go to the Data Entry Assistant (DEA) 2.0 web application, click on the login link on the upper-right hand part of the page, and log in. An xBio:D user account is required to prepare a file within DEA2. If an xBio:D account is needed, go to the DB Manager web application, and sign up for an account.
File Upload
After logging in, the specimen data file within an Excel spreadsheet must be uploaded into DEA2. Go to File -> Load File from the menu to go to the Load File page. Once there, click on the Browse button and select the Excel file to upload. Click the Upload button and the Excel file will be uploaded and standardized in DEA2. Standardization involves created two additional worksheets, Main and Localities, and copying the specimen records from the Raw_Data worksheet to the Main worksheet, if the file has not already been standardized. During standardization, DEA2 will verify the consistency of certain fields to make sure that they conform to expected values, i.e., dates are properly formatted, numbers do not contain improper characters, etc. DEA2 will also assure that each cuid is unique within the file and report those that are duplicates before proceeding. The Main worksheet will contain the DEA-formatted information necessary for occurrence entry into the xBio:D database. File upload and processing is extremely variable and may take a few minutes to complete depending on the number of records within the Excel file. After standardization is completed, the uploaded file is set as the current loaded file to begin DEA Processing. When matching specimen records are already within the xBio:D database, a list of cuids is displayed to allow the user to confirm that the existing records are authentic. There records can be downloaded within an Excel spreadsheet by clicking on the Excel logo preceding the list of records.
Changes from DEA to DEA2
- All actions performed within DEA2 are recorded, which requires an xBio:D user account. This allows a user to process a file seamlessly between multiple computers.
- DEA2 is at least 4 times faster than the original DEA, and also contains more consistency checks and better error handling.
- Verbatim label fields do not need to be merged with the comments field prior to entry into DEA2 unlike the original DEA.
- DEA2 can handle many more specimen records in a single file. Whereas DEA maxed out at ~500 specimens, DEA2 has easily processed files with as many as 8000 specimens.
- DEA2 performs some consistency checks upon upload to verify that cuids are unique within the file, dates are properly formatted, required fields are present, etc. After the consistency check, DEA2 will report any specimens within the file that are already located within the xBio:D database.