Additional fields in bait station csv export files

Feature Requests
#1

I am setting up a database for the project I am in, hoping to analyze progress better. Initially I am focused on bait station records. I have found the following csv exports: “Bait station records total”, “Bait taken”.
I see that bait stations have a unique ID (nid) and a non-unique ‘Code’. In fact we have multiple instances where the same Code is used for different bait stations.

“Bait taken” has coordinates (useful if moved), but not Date
“Bait station record totals”: has Date but not coordinates.
Neither has ‘Bait remaining’.
Neither has the unique Bait station ID (NID in “Bait station type”) - which means I can’t reliably link the record to the correct bait station.

Would it be possible to have a new report (or change one of the existing) that includes the combined fields of “Bait station records total” and “Bait taken”? And also include:

  • RecordID - Unique ID for the bait-taken record
  • BaitStationID - FK to “Bait Station Type”.NID
  • BaitRemaining - useful when finding data-entry errors

With thanks :slight_smile:

#2

A slight correction: The Bait station NID field (which I assume is the primary key) is available in the csv file of the “Multi-project Bait station list” report (not the “Bait Station Type” report, as I originally said).