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

• 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

View all 32

Backups 5

• 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

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 5

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

Data Exchange 6

• 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

View all 6

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

View all 32

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

View all 6

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")

View all 11

Extensibility 8

• 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?

View all 8

How To... 25

• Bulk create ENTs & ESTs (Central Only)
• Bulk Create ESTs
• How To Import Excel Rank Calculator Data into Biotics
• Recover a deleted EO
• Restore a record from the deleted schema

View all 25

Map 31

• Feature Class Field Type incompatible with Add Resources from File in Map Viewer
• Independent SFs to EOs
• Check for & Fix Pending spatial attributes
• Add Resource from File fails due to DateOnly field
• Map continuously redirecting in Chrome

View all 31

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

View all 10

Observations 26

• 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

View all 26

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

• 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

View all 65

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"

View all 24

Query Builder 2

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

Record Management 12

• 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
• Benchmark Data Content Standards

View all 12

Service Level Agreement 7

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

View all 7

Taxonomic Updates 20

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

View all 20