See attached spreadsheet for queries to output the data in the format necessary for NatureServe to run the bulk insert statements, according to the instruc...

This solution applies to Member Programs only. Attached is a zip file containing instructions and queries for bulk creating ESTs. The presentation and recor...

Instructions for importing from any version 3.2 rank calculator into Biotics 5 are attached. Your data must be in version 3.2 of the rank calculator (availa...

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...

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...

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...

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...

Disable all triggers (see attached scfor tables that you want to apply The attached script is currently applied to EO, SOURCE_FEATURE, MA, CONSERVATIO...

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...

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...