Conversion 11

• Biotics 6 Conversion: Known Issues and Workarounds
• Conversion Schedule and Program Readiness
• Setting up MFA for Biotics 6
• Filling out Conversion Spreadsheets for Extensible/Custom Objects
• Addressing Pre-Migration Issues found in CSVs

See all 11 articles

Biotics 6 Specific Documentation 1

• Why do new EO and Source Feature IDs sometimes jump by 33 (or another large number)?

Accessing Biotics 6 via Third-Party Applications and using them 6

• How to Test Your Connection to the Biotics 6 Database
• exception: access violation in pgAdmin v 9.18
• Permission denied to cancel query in pgAdmin
• Creating an ODBC connection to the B6 Postgres Database
• Connecting to the Postgres Database via PgAdmin

See all 6 articles

Demo's and Recordings 13

• 2025-09-16 Biotics 6 Demo and Recording
• 2026-08-10 Biotics 6 Rollout Meeting
• 2025-05-20 Biotics 6 Demo and Recording
• 2026-01-15 Network Demo and Recording
• 2026-05-15 Biotics 6 Demo and Recording

See all 13 articles

Backups 3

• Create the Biotics 6 Database from the Backup
• Pavel Stehule's blog: fresh dll of orafce and plpgsql_check for PostgreSQL 17 and PostgreSQL 18
• Importing NatureServe Postgres Backups into an Esri SDE Environment

SQL and Query Builder 6

• Why does the Query Builder table list look funny in Biotics6?
• Translation of some Oracle/B5 SQL into PostgreSQL/B6
• DELIMLIST replacement in B6 (STRING_AGG)
• Useful functions
• ELEMENT_OCCURRENCE_SOURCE view not in Biotics 6

See all 6 articles

Accessing Biotics 5 via Third-Party Applications and using them 33

• Installing Oracle (client & server)
• Adding custom Crystal Report to Biotics instance
• Biotics IP addresses changed on June 7, 2019
• Connection within Crystal Reports not displaying Tables but something unrecognizable! Help!
• Automate printing of Crystal Reports

See all 33 articles

Backups 6

• Automating download of nightly Biotics 5 backups
• Automate Publishing of Biotics Backups to AGOL
• Utilizing Biotics 5 backups
• Accessing Biotics 5 backups
• Change settings for nightly backups

See all 6 articles

Configuration 3

• Change data displayed in Details dialogs
• Replace layer in SpatialCalculations.gdb
• Set REC_LAST_MOD_USER to a custom value (rather than BIOTICS_DLINK)

Conversion 6

• Points of Contact
• Conversion Guide
• Biotics Status
• Fix data in checkbox fields in extensible tables
• Observation Data Standard (DRAFT)

See all 6 articles

Data Exchange 7

• Biotics 5 Status & Data Exchange Map
• Non-Biotics programs: Providing spatial data for data exchange
• Upload data via NatureServe's transfer site
• Establishing the Data Exchange Rollout Schedule (spreadsheet)
• Inactive Elements: What, When, How, Why

See all 7 articles

Data Model Changes in Biotics 5 32

• Data Exchange views dropped in 5.13.16
• Obsolete Tables & Views being dropped in version 5.13.16
• Ecological Name Category updates
• Remove Export to Data Exchange Shapefile Views for all Managed Records
• Update to USESA (U.S. Endangered Species Act) domain values

See all 32 articles

Development Priorities 6

• Biotics Roadmap
• Data Backlog Working Group Development Plan
• Implementation of 2016 Survey Results - Development Priorities of Issues
• Survey Results: Biotics 5 Development Priorities - Roadmap (2017)
• Biotics 5 Development Priorities - Issues - 2017

See all 6 articles

Errors and other messages 11

• "Service Unavailable" message received after Grant/Refresh Database Privileges
• Required codec not installed for viewing recorded Biotics 5 sessions
• ORA-00001: unique constraint BIOTICS_USER.[table_name]_PK violated
• Get error when running FIX_NEXT_SEQ stored procedure
• Update syntax to avoid trigger error: ORA-01400: cannot insert NULL into ("BIOTICS_USER"."AUDIT_LOG"."USER_NAME")

See all 11 articles

Extensibility 9

• Extensible table generation tool
• Create an EO Rank Change extensible section
• Using CLOB fields in an extensible table
• "Extensibility RS_Error: ORA 00904: "DISPLAY ORDER": invalid identifier" error
• What is the HDMS_TABLE table used for?

See all 9 articles

How To... 29

• Bulk create ENTs & ESTs (Central Only)
• Toolbox to Calculate Representation Accuracy Values
• Toolbox to Review & Update EO Data based on Source Feature Working List
• Bulk Create ESTs
• How To Import Excel Rank Calculator Data into Biotics

See all 29 articles

Map 33

• CURVEPOLYGON Import Error when using Bulk Create/Replace
• Feature Class Field Type incompatible with Add Resources from File in Map Viewer
• Toolbox: Independent SFs to EOs
• Check for & Fix Pending spatial attributes
• Add Resource from File fails due to DateOnly field

See all 33 articles

Miscellaneous 10

• How do I cite Biotics as a source of data?
• Why do I see numbers preceded by 'bt' in rec_last_mod_user?
• How do I add a new folder for Working Lists?
• What happens to EO Number when EOs get switched from one EST to another?
• INACTIVE record

See all 10 articles

Observations 29

• What's involved: NatureServe cloning data from NS AGOL to member AGOL
• Observations survey in Survey123 - All you need to know!
• Observations documentation
• Collect Data via Survey123
• Using the Observations Dashboards

See all 29 articles

Oracle Functions, Procedures, Queries, Scripts, Views... 69

• FUNCTION: DELIMLIST Function
• FUNCTION: Remove ALL html tags from a string of text
• FUNCTION: Determine tiebreakers are used for a reference
• FUNCTION: Retrieve ELCODE_BCD for an EO
• FUNCTION: GetCLASSIFCODE

See all 69 articles

QC Queries 24

• Threats Assessment Missing Higher Level Threat
• Threats Assessment: Mismatches between Calculated Threat Impact and Scope/Severity/Timing
• Identify Invalid References
• Use of Central references in program databases
• Review of EO records that are marked "Do Not Exchange"

See all 24 articles

Query Builder 2

• Query Builder results blocked in Google Chrome
• Using queries saved in Biotics 4

Record Management 13

• Managing U.S. Endangered Species Act status in your local Biotics database
• Adding New Elements - UPDATED
• Removing old character codes from text fields
• Option to change color background and font of data records in Biotics 5
• HTML tags and codes in Biotics5

See all 13 articles

Service Level Agreement 8

• Service Level Agreement
• Biotics 5 Hosted Service Details
• NatureServe Software, Information, and Support Services Fee Schedule
• Service Health Dashboard
• System Requirements

See all 8 articles

Taxonomic Updates 20

• AA- Read Me - creating Taxonomic Update tickets
• Brazoria enquistii
• Centaurium blumbergianum
• Cirsium clavatum
• Cirsium perplexans

See all 20 articles