bioticssupport.natureserve.orgINSERTUPDATE Allow the special characters & and in

Welcome Login Sign up Home Solutions Forums Server Status How can we help you today? Enter your search term here... Search ., Login or Signup to submit a new ticket Check ticket status Knowledge base Biotics 5 Solutions Accessing Biotics 5 via Third-Party Applications and using them 29 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 See all 29 articles Backups 3 Utilizing Biotics 5 backups Accessing Biotics 5 backups Automating download of nightly Biotics 5 backups 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 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 3 Establishing the Data Exchange Rollout Schedule (spreadsheet) Data Exchange Status Non-Biotics programs: Providing spatial data for data exchange Data Model Changes in Biotics 5 16 Observation table renamed Visit Columns added to EO_SOURCE_FEATURE table Rank Calculator Export for Biotics5 Data Model changes between Biotics 4 and Biotics 5.5 Changes to Element Ranking tables See all 16 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 6 Creating an extensible table Extensible table generation tool "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 See all 6 articles How To... 21 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 See all 21 articles Map 25 Collect Data via Survey123 Source Features survey in Survey123 - from creating survey to Bulk Create in Biotics Bulk Load Prep Toolbox Copy Saved Map for use by other User Centroids for EOs and Source Features See all 25 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 1 Darwin Core Oracle Functions, Procedures, Queries, Scripts, Views... 64 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 64 articles QC Queries 21 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 21 articles 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 See all 12 articles Service Level Agreement 7 Service Level Agreement Biotics 5 Hosted Service Details Biotics Fee Schedule Service Health Dashboard System Requirements See all 7 articles Community forums Showing recent updates Biotics 5 Release Update Newsletters 9 Biotics Release Newsletter - Releases 5.7.10 Posted by Whitney Weber , almost 4 years ago Last Reply by Shaun, 8 months ago Biotics Release Newsletter - Releases 5.8.4 & 5.9/5.9.1 Posted by Whitney Weber , about 3 years ago Last Reply by Whitney Weber, about 3 years ago Biotics Release Newsletter - Releases 5.8.3 Posted by Whitney Weber , about 3 years ago Last Reply by Whitney Weber, about 3 years ago See all 9 topics Home Solutions Forums...