1 / 15

Software application that allow user to: Import Data into Biotics Export Data out of Biotics

What is it?. Software application that allow user to: Import Data into Biotics Export Data out of Biotics Developed internally by NatureServe staff 3 rd component of Biotics Trinity Mapper, Tracker, Exchanger Network rollout/installation in progress. How can I use it?.

oakley
Download Presentation

Software application that allow user to: Import Data into Biotics Export Data out of Biotics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What is it? • Software application that allow user to: • Import Data into Biotics • Export Data out of Biotics • Developed internally by NatureServe staff • 3rd component of Biotics Trinity • Mapper, Tracker, Exchanger • Network rollout/installation in progress

  2. How can I use it? • Annual Data Exchange with NatureServe • Code Requests from NatureServe • Data transfers between NHPs (Biotics format) • Future Uses – Generic Import/Export • Field Form Data in Access format, etc

  3. Database Details… • File Transfer Format: XML • Functional transfers • Biotics-Biotics • BCD-Biotics • Prototype (not yet supported) transfers • Access-Biotics

  4. Exporting Data • User can choose (using SQL or working lists): • Records to export • Fields to export • Export template: User can save common export tasks as a project for re-use • Exporting data to NatureServe for Data Exchange

  5. Importing Data Steps Load Match Import Rules Commit

  6. Loading Process • User loads incoming data into “holding area”: • Tables in Biotics 4 database • Exchanger compares records in holding area (incoming) against records in Biotics database (target) • Incoming Data Loaded as Project • Project properties • Purging Projects

  7. Matching Process • Generic matching • Alternate Keys • Universal Keys • Specialized matching • Scientific Name matcher: Scientific Name + Author Name • Element Matcher: ELCODE + Scientific Name

  8. Matching Statuses • Pending • Matched • New • NoMatch • Partial Match • Manually Matched • Reject • Fail

  9. Applying Rules Process • Tool applies user-defined import rules: • Rules applied at record level or field level • Example 1: Accept all NEW records • Example 2: Reject all <null> GRANKs • Example 3: Accept all newer GRANKs • User can configure rules to be as simple or complex as needed

  10. Apply Rules Process • Assigns Import Status: • Pending • Rules_Flag • CommitReady • Rules_Fail • Reject • Flags records for user review

  11. Commit Process • Only step that actually changes records in target database • Records must have completed match and import rule status before commit • Commit is non-reversible

  12. Example Process: NatureServe Annual Data Exchange • NatureServe Refreshes • Element Subnational Data: SNAME, SRANK • EO data • Natural Heritage Program Refreshes • Element Global Data: Taxonomy, GNAME, GRANK • Products • NatureServe Explorer Web-Site • Publications – Precious Heritage • MJD Products – DOD Species at Risk

  13. Advanced functionality • Uploading Data from other formats (e.g. ACCESS) • Structure data in Biotics-like data model • Export to XML format • Load into holding area • Tranform data to conform to Biotics data model • NatureServe Examples • Central Ecology data conversion (ACCESS) • Non-Biotics Data Exchanges • Coming Soon (funding dependent): • documentation and support for NHP use • Tool usability improvements

  14. Installation/Rollout Strategy • Self-install • software & directions on our FTP site • As-needed rollout • data exchanges • code requests/other data needs from NatureServe • Contact: Debbie Albert • deborah_albert@natureserve.org

More Related