Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Export function data does not work #201

Closed
johnpauls opened this issue Jul 20, 2020 · 1 comment
Closed

Export function data does not work #201

johnpauls opened this issue Jul 20, 2020 · 1 comment
Labels
bug Functionality does not work as designed data analysis need Issue with data that will likely impact ongoing analysis data closeout Issue needs to be resolved *before* annual data closeout field season need Issue needs to be resolved for upcoming field season P1 - Critical Priority 1 - Issue is a critical priority to resolve S1 - Critical Severity 1 - Issue has wide impact or blocks use of important features (it doesn't work!)
Milestone
2020 Pre-Season U...

Comments

@johnpauls
Copy link
Member

The button to export the data throws an error. If you choose:
Summarize > Advanced Summary Tools > Export All Data
you get an error which says
"Error #94: Invalid use of Null".

Also I tried the Annual Data Export form the same place for 2020 it threw a different error:
"Error #3079 The specified field [Event_Date] could refer to more than one table listed in the FROM clause of your SQL statement."

I have never tried that export before, so that could be an old error for all I know.
It did export Events, Tree and Plots .csv files though. The rest did not export.
@johnpauls johnpauls added bug Functionality does not work as designed S1 - Critical Severity 1 - Issue has wide impact or blocks use of important features (it doesn't work!) P1 - Critical Priority 1 - Issue is a critical priority to resolve data closeout Issue needs to be resolved *before* annual data closeout field season need Issue needs to be resolved for upcoming field season data analysis need Issue with data that will likely impact ongoing analysis labels Jul 20, 2020
@blcampbell blcampbell added this to the 2020 Pre-Season Updates milestone Jul 30, 2020
@blcampbell
Copy link
Contributor

Until this issue is fully addressed use the Annual Data Export at the bottom of the Advanced Data Summary form.
Set the year and select the location you wish to save the csvs. You will need to confirm the file name however all CSVs will be saved for the export.

The export all data function has been temporarily disabled until the cumulative export portion of the export functionality can be fully addressed.

blcampbell added a commit that referenced this issue Aug 25, 2020
@blcampbell
Version 9.8.0.9002
f2e45e8 
2020 Mid-Season Updates
Incremental release
Closes #77 (Export DBH Double-Checked )
Closes #166 (Db not Flagging Shrinking DBHs)
Closes #196 (Can't Input Multiple DBH for Multi-Stemmed Sapling)
Closes #197 (Event Report Prior DBH Incorrect)
Closes #198 (Unexpected popup entering sapling living status)
Closes #199 (Issue importing tables from field data)
Closes #200 (Cannot create Db Backup)
Closes #202 (Prior DBH Incorrect)
Closes #203(Add Prior DBH to Tree/Sapling forms)
Closes #205 (Advanced Data Summary Event Report displays Overlain Text)

Partially addresses
#201 (Export function does not work)
@blcampbell blcampbell mentioned this issue Aug 27, 2020
Closed
blcampbell pushed a commit that referenced this issue Apr 21, 2021
v9.8.0.9005 - incremental release
7e60ead 
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
Assignees
No one assigned
Labels
bug Functionality does not work as designed data analysis need Issue with data that will likely impact ongoing analysis data closeout Issue needs to be resolved *before* annual data closeout field season need Issue needs to be resolved for upcoming field season P1 - Critical Priority 1 - Issue is a critical priority to resolve S1 - Critical Severity 1 - Issue has wide impact or blocks use of important features (it doesn't work!)
Projects
None yet
Milestone
2020 Pre-Season Updates
Development

No branches or pull requests
2 participants
@johnpauls @blcampbell