WildCam Lab - "Download My Data" is missing several fields

[shaunanoordin]

Functionality Bug

When a student downloads a "My Data" CSV file for WildCam Gorongosa Lab, a large number of fields are missing in the results.

Gorongosa example:

"user_id","assignment_id","classification_id","subject_id","species","count","camera","date","dist_humans_m","dist_water_m","image_url","land_use","latitude","longitude","month","national_park","season","time_period","veg_type","water_type","year"
"1459734","5613","81398218","825435","LNFML",,,,,,,,,,,,,,,,

Darién example:

"user_id","assignment_id","classification_id","subject_id","species","count","camera","national_park","longitude","latitude","date","month","year","season","time_period","veg_type","land_use","water_type","dist_humans_m","dist_water_m","image_url"
"1459734","6990","325405344","10821948","JAGUAR","1","CP71","Darien","-77.742094","7.981265",,"May","2017","Wet","Night 1850-0554","Lowland evergreen tropical forest","Wilderness","River","6532","3207","https://s3.amazonaws.com/hhmi-glp-prod/Gorongosa%20Waterbuck/Darien%20Trail%20Camera/Season%201/CP71b/Set%201/I__00093.JPG"
"1459734","6990","325405362","10822190","JAGUAR","1","CP75","Darien","-77.736338","7.966548",,"May","2017","Wet","Day 0617-1827","Lowland evergreen tropical forest","Wilderness","River","6565","4303","https://s3.amazonaws.com/hhmi-glp-prod/Gorongosa%20Waterbuck/Darien%20Trail%20Camera/Season%201/CP75a/Set%201/I__00090.JPG"

There appears to be a bug in the "join" action function, probably in wildcam-gorongosa.classroom-config.json.

[shaunanoordin]

This problem requires solution on two fronts:

• check the CSV download code
  • It's usually the "data to CSV adapters" in the *.map-config.js or *.classroom-config.js files.
  • There may be some fields/columns missing.
• Update the Database with newer data
  • If there's missing Subject (or Camera or Aggregations) data, then the "data" part of the "data to CSV adapter" equation is failing.

In WWKenya Lab, it was determined that several rows with missing fields were caused by (1) WWKenya using a live WF with new Subjects, which meant (2) Assignment downloads were pulling new Subject IDs, but (3) the Classrooms DB only had old Subject data.