Record Management

Adding New Elements - UPDATED
In the Biotics 5.0 release (the first release, back in summer 2013), users could not create new Global or National Element Tracking records, only new Subnat...
Wed, 26 Feb, 2014 at 2:09 PM
Removing old character codes from text fields
APRIL 3, 2014; REVISED Nov 19, 2014 In early releases of Biotics 5, the rich-text editor in Biotics 5 inserted some unwanted HTML codes for "s...
Wed, 19 Nov, 2014 at 12:24 PM
Option to change color background and font of data records in Biotics 5
The following information was provided by Kim Taylor: Rather than using Chrome, use FireFox which enables modification of both screen color and font...
Wed, 22 Oct, 2014 at 10:14 AM
HTML tags and codes in Biotics5
HTML is used to store some text formatting and special html characters in Biotics as shown in the table below. The html formatting codes have not chang...
Wed, 19 Nov, 2014 at 2:35 PM
Benchmark Data Content Standards
We are often asked of all the many fields to complete in Biotics, what should member programs be focused on?  In response, I would point you to the Benchmar...
Tue, 2 Jun, 2015 at 7:58 AM
Batch create new EST records
Attached is a spreadsheet template used for creating bulk insert/update SQL statements, once the spreadsheet has been populated with the pertinent...
Wed, 29 Aug, 2018 at 9:49 AM
Query to get Element Working List fields
select * from (SELECT element_global.element_global_id as Id,cast('Global' as VARCHAR(6)) as GeoLevel,to_char(element_global.element_global_id) as...
Mon, 2 Nov, 2015 at 11:38 AM
How can I tell where a scientific name record is used?
The view SCI_NAME_USAGE_VW makes this very easy. The fields are: SN_ID the scientific_name_id SCI_NAME the scientific_name for that record TA...
Mon, 19 Dec, 2016 at 8:20 AM
Batch create new EGR records, update EGT to reflect new/updated rank, create new TAXON_GBL_RANK_CHANGES, update ENT to reflect new/updated rank
Attached is a spreadsheet template and scripts (for use in template) to create batch SQL statements for creating new EGR records, update EGT to reflect...
Mon, 23 May, 2016 at 11:29 AM
Populating Rounded Ranks via SQL
Log into SQL Developer, Tora, Toad or SQLPlus as the biotics_dlink user. Run the following SQL statements: set serverout on exec reround_ranks; commit; ...
Tue, 6 Feb, 2018 at 1:54 PM