search

CRITFC / Helpdesk

Parent repository for tribal CDMS documentation and issues
1 stars 0 forks source link

Detail values missing from imports #39

Closed nowinski closed 3 years ago

nowinski commented 3 years ago

From: Tyler Stright tylers@nezperce.org Sent: Monday, September 21, 2020 2:14 PM To: Joe Nowinski nowj@critfc.org Cc: Clark Watry clarkw@nezperce.org Subject: Strange Importer Behavior CDMS

The Location mapper is working fine. I have tested this both with locations loaded via Bulk Insert in a SQL script and also using hand-entered locations to see if this was causing the problem – it isn’t. As far as I can tell, the “Import Multiple Activities” preview shows the age, n_tags, and node column properly filled (i.e. matches the csv file). It seems like CDMS is recognizing and reading the file properly, but isn’t shuffling over data from some fields for some reason. Here’s what I am observing when importing…

IPTDS_test • Node not imported for LC1, but IS imported for LC2 • N_tags imported for LC1/LC2, but not for CRLOL • Age not imported.

IPTDS_test_SITE (only site level metrics: site escapement and detection efficiency) • The node field is missing one of the values (LC1 Detection efficiency) – all detection efficiencies are associated with a node (i.e. a specific antenna in the PIT array). o Strangely, the node value imports correctly for the LC2 site.

IPTDS_test_POP (population level metrics (everything except site esc. And detection efficiency) • n_tags – does NOT import correctly (only one value in this test data, but it’s missing.) • age – all values missing, there should be an age value for each age variable (6 total here)

IPTDS_test_noDE (No Detection Efficiency) • Age is not properly imported • N_tags DOES NOT import correctly for the variable = ‘Population Escapement’ • N_tags DOES import correctly for the Site Escapement (LC1 activity)

IPTDS_test_noSITEesc (no Site escapement) • Node imported correctly • Age not imported • N_tags imported correctly for LC1/LC2, but NOT for CRLOL:population escapement

nowinski commented 3 years ago

INSERT statements did not include all detail field columns. Traced to DatasetDataDetailHelper.cs. Ken fixed.