Field Data Import - Secondary Events Created from Pseudo Events Are Not Imported #140
Assignees
Labels
design issue
Current design needs revision to avoid data issues, improve workflow/functionality.
Milestone
Comments
blcampbell
added
the
design issue
blcampbell
pushed a commit
that referenced
this issue
Apr 21, 2021
Version 9.8.0.9005 2021 Pre-Season Updates Incremental release addresses the following… **Export issues** Closes #9(Prevent RFS tag exports) Closes #16(Browse data not exported for herbaceous species) Closes #18(DBH/basal area not exported for dead trees) Closes #76(Saplings w/o habit excluded) Closes #77(Include DBH double-checked? w/ @ DBH record) Closes #80(Export DBH double checked In tree/sapling CSVs) Closes #83(Add comments) Closes #90(Add state/county to plots export) Closes #105(Trees w/o azimuth/distance not exported) Closes #107(Tree/sapling vigor not exported) Closes #138(CWD exports incorrectly) Closes #201 (Export function does not work) Closes #216(Change UnitCode to Unit_Code) Closes #217(Duplicate records for synonyms) Closes #220(Add and expose plant species export field) Closes #221(Add tlu_Plants Export field) Closes #222(Export species lists) **Event Report issues** Closes #3 (Identify trees surpassing threshold) Closes #20(Equivalent DBH should display) Closes #63(Report doesn't open from gateway form) Closes #64(No Tree Conditions red bar appears on all living trees w/o tree conditions selected) Closes #65(Sapling foliar conditions don't show) Closes #72(Sapling foliar issues not showing) Closes #75(Missing tree/sapling/shrub ID doesn't highlight) Fixes #112(Number appears at top) Fixes #113(Not showing trees) Closes #157(Sapling VCF checkboxes not showing) Closes #158(Missing sapling DBHs not highlighted) Closes #174(Monster saplings because of dead standing DBH) Closes #178(Remove RIO from unsampled tags & event report) Closes #184(Highlight herbaceous species cover < 0%) Closes #197(Prior DBH's not correct) Closes #294(Add stem prior DBHs) **Import Issues** Fixes #127(Quadrat data doesn't import) Closes #139(Only 1 event imports per day) Fixes #140(Secondary events from pseudoevents not imported) Fixes #199 (Issue w/ importing tables from field data) **Species Issues** Closes #99(Add Berberis bealei to plants) Closes #219(Add Parthenocissus tricuspidata) **Data Issues** Closes #66(Update tag status for all dead fall trees) Closes #71(Delete MONO-0026 tag 99999) Fixes #74(Move 2 trees from PRWI-0082 to PRWI-0028) Closes #95(Retag 3593 to 25278) Closes #96(Issues w/ tag 3250) Fixes #89(Extra event) Closes #223(Synonyms - change to new TSN_Accepted) Closes #224(Synonyms - split out distinct species) Closes #225(Synonyms - add new species as new default TSN_Accepted) **General issues** Closes #12(Add new plot data to locations table) Closes #21(Deleted issue) Closes #44(Species pad allow double click selection) Closes #68(Vigor data field highlighted after crown class entry) Closes #69(Target herb percent cover autofills to 0 after taxon entry) Closes #70(Add quick comment "old primary branch broken") Closes #78(Display all vs active tags) Closes #85(Handle pseudo-events) Closes #87(Sort tag history by date) Closes #88(Add change log functionality to browse tag form) Closes #91(Sapling tag status doesn’t update) Closes #92(Pseudoevent - conversion to actual event) Closes #103(Automatically update "habit" for saplings/shrubs based on species ID) Closes #106(Preserve pseudo-event date) Closes #111(Add tree/sapling/shrub condition for stress related to vines) Closes #114(Tags not shifting to sampled on events form) Closes #115(DBH double checked background remains) Closes #120(RIO tags show at top of dropdown) Closes #121(Targeted herbs % autofills to 0 w/ species selection) Closes #122(Minimum 1.0 sapling DBH frequenlly pops up) Closes #123(Add Show/Hide for trees we won't sample in unsampled tag dropdown) Closes #124(Add buttons to browse plants/tags from events form) Fixes #126(Lookup code for spotted lanternfly missing) Closes #128(Sampled tag dropdown missing tree/sapling status) Closes #136(Highlight when tag RFS flag set) Closes #145(Post-Season review - RIO tags) Closes #146(Event date(s) need to be updated) Closes #156(Drop-down comments for change log not populating for azimuth/distance) Closes #166(Shrinking DBHs not flagged) Closes #171(64-bit conversion) Closes #172(Integrate framework modules) Closes #176(Herbaceous species w/o % cover or browse) Closes #196(Cannot input multiple DBH measurements for multi-stemmed sapling) Closes #198 (Unexpected popup when inputting living status for saplings) Fixes #200 (Cannot create Db backup) Fixes #202 (PriorDBH Incorrect) Closes #203 (Add PriorDBH to tree/sapling Forms) Fixes #205 (Advanced Data Summary - Event Summary report displays overlain text) Fixes #207(New Event triggers null error for DBH) Fixes #208(Unable to create new event) Partially addresses (these are not fully exposed/implemented) #100 (Add taxonomic reference adjustments) #181 (Event Report - tree/sapling vine loss) #186 (Allow event date changes) #187 (Add measurement data flags set/edit/delete) #188 (Add SOP version tracking) #189(Add data flag utilities) #192(Add event DPL utilities)
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
When a pseudo event is created prior to the season, it generates an event ID.
That event ID exists in the master back-end which is copied to both primary & secondary tablets.
When pseudo-events are converted to regular events, those events retain their Event_IDs.
RESULT: The same Event_IDs exist on BOTH the primary & secondary tablets.
During import, Event IDs that already exist on the master are not imported.
So, even if pseudo-events are archived & deleted from tbl_Events in the master, after the primary tablet import the secondary tablet does not import events that were originally pseudo-events because their Event_IDs already exist in the master database (they were imported when the primary tablet events were imported).
The text was updated successfully, but these errors were encountered: