How To...

How to do various things

Bulk Create ESTs
This solution applies to Member Programs only. Attached is a zip file containing instructions and queries for bulk creating ESTs. The presentation and recor...
Fri, 19 Apr, 2019 at 9:24 AM
How To Import Excel Rank Calculator Data into Biotics
Instructions for importing from any version 3.1 rank calculator into Biotics 5 are attached. The instructions include steps for copying your data into the m...
Wed, 17 Apr, 2019 at 2:22 PM
Recover a deleted EO
Updated May 23, 2019 If you accidentally delete an Element Occurrence, you can recover your data from the deleted schema and insert it back into the sou...
Thu, 23 May, 2019 at 8:10 AM
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
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, 23 Apr, 2019 at 6:26 AM
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
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