Miscellaneous

How do I cite Biotics as a source of data?
To cite Biotics 5 as a source, follow the citation approach we have established for NatureServe Explorer (see https://explorer.natureserve.org/AboutTheData/...
Mon, 9 Nov, 2020 at 7:41 AM
Why do I see numbers preceded by 'bt' in rec_last_mod_user?
The 'bt' stands for BridgeTrak, which is the name of the software used to submit and answer Biotics 4 support questions. The number refers to the ...
Wed, 5 Nov, 2014 at 9:20 AM
How do I add a new folder for Working Lists?
There are a lot of lists that just the Data Management staff want to see, so it would be nice if we had a folder like Botany, Zoology, and Ecology do. ...
Wed, 5 Nov, 2014 at 9:47 AM
What happens to EO Number when EOs get switched from one EST to another?
The Change Associated Element function on the EO Working List Tools menu works as follows: 1. If no EOs associated with the Element you're sw...
Wed, 5 Nov, 2014 at 9:52 AM
INACTIVE record
DESCRIPTION Records have big red INACTIVE label in the source feature table RESOLUTION The records were assigned a species name that is currently not in...
Wed, 20 Sep, 2017 at 1:15 PM
How do I get the length of data in a field?
The following syntax returns the length of data within a field, whether the field is a CLOB or not: select LENGTH(eo.eo_data) as eo_data_num from EO...
Wed, 5 Nov, 2014 at 10:54 AM
How do I enter data into Biotics as a batch update?
DESCRIPTION Is there a way to bulk load data into Botics5?  I have an excel table with Elcode and data for a field in the est.extend2 tab.  Do I hav...
Mon, 23 May, 2016 at 11:29 AM
Upload to NatureServe transfer site (Windows 7)
Right click on the Windows Start icon and choose Windows Explorer. Within Windows Explorer, right click on Computer and choose Add a network loc...
Mon, 31 Aug, 2015 at 9:39 AM
Who is logged into Biotics 5?
Although there is not a tool in Biotics 5 which enables you to see this directly, below is a workaround for determining this information: The sessio...
Tue, 1 Sep, 2015 at 9:55 AM
Inserting accented characters via SQL statements
Running sql statements in the DOS prompt containing accented characters results in improper characters being inserted. Likewise, opening a sql file in SQL D...
Fri, 3 May, 2019 at 3:38 PM