How To...

How to do various things

Instructions to remove <strong> and <em> in rich text fields for biotics tables
Disable all triggers (see attached scfor tables that you want to apply The attached script is currently applied to EO, SOURCE_FEATURE, MA, CONSERVATIO...
Mon, 9 Apr, 2018 at 11:31 AM
Managed Area Element List: Change EGT to EST
During conversion from BCD to Biotics, any ET that was in the Managed Area Element list was converted at the Global level. If you would like to change the...
Mon, 9 Apr, 2018 at 11:37 AM
Recover a deleted EO
Updated August 2, 2018 If you accidentally delete an Element Occurrence, you can recover your data from the deleted schema and insert it back into the s...
Thu, 2 Aug, 2018 at 3:31 PM
Restore a record from the deleted schema
You can restore any record from the deleted schema that you may have deleted in error. This is done by using SQL insert statements that will copy over selec...
Tue, 22 May, 2018 at 2:32 PM
Build a SQL Script
If you have many SQL statements to run, insert or update statements for example, you can build a sql script and then run that script. How do do this: 1) E...
Mon, 9 Apr, 2018 at 11:48 AM
Fix out-of-synch NEXT_SEQ values
This will set the sequence of tables to the next value to prevent PK constraint violations when you try to add a record. You can also get other strange, une...
Tue, 13 Mar, 2018 at 10:55 AM
Create a working list in the database outside of Biotics
I was wondering if there was a way to create a working list outside of Biotics? Is there a sql statement that can be written to create a working list? I am ...
Mon, 9 Apr, 2018 at 3:38 PM
Enter species in the COMM_EO_COMPOSITION table with a batch update
How can I populate the COMM_EO_COMPOSITION table with a list of species in a batch update? There's several ways do it. These steps assume that the ...
Mon, 9 Apr, 2018 at 3:40 PM
Update working list record counts
Problem: The working list record count displayed in Biotics5 comes from the field working_list.working_list_record_count, but that field is only updated...
Mon, 9 Apr, 2018 at 3:51 PM
Users Guide to the Distribution Data and Subnational Conservation Status Ranks Consistency Validation Function (DDF)
See the attached documents and Rank and Distribution Data Consistency help topic. As of 5.8.4, all Biotics instances include the DDF_UPDATE_SUBNATIONA...
Tue, 11 Sep, 2018 at 7:46 AM