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

• Installing Oracle (client & server)
• Biotics IP addresses changed on June 7, 2019
• Connection within Crystal Reports not displaying Tables but something unrecognizable! Help!
• Automate printing of Crystal Reports
• Automate data export of Biotics 5 spatial features & data

View all 30

Backups 4

• Utilizing Biotics 5 backups
• Accessing Biotics 5 backups
• Automating download of nightly 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 29

• 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
• Detected field in Visit grid with default value of 'Y'
• D_LANGUAGE.languge_desc

View all 29

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 7

• Extensible table generation tool
• 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?
• Add audit tracking triggers to an extensible table

View all 7

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 28

• Independent SFs to EOs
• Map continuously redirecting in Chrome
• Bulk Load Prep Toolbox
• Copy Saved Map for use by other User
• Centroids for EOs and Source Features

View all 28

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 22

• What's involved: NatureServe cloning data from NS AGOL to member AGOL
• Integration of Source Features and EOs (via Field Maps) with the Observations Survey (in Survey123)
• Create spatial View containing only Observations with QC Status = ‘Passed’
• Clone Observations surveys to member program
• Observations toolbox for Non-Biotics use

View all 22

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 23

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

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