Previously, we only exported the Survey tables. This was not enough, as the Apiary surveys could not be connected to the User surveys, since the user_id was never attached to the Apiary surveys.
By exporting the Apiary table along with the results, we give the entire set of collected data to the exporting user, which will give them the flexibility to connect and slice it in many different ways.
Furthermore, the user_id column is also added to the Survey table export, which can help make the connection without an extra step of connecting with an Apiary first.
Connects #505
Demo
Testing Instructions
Check out this branch and beekeepers start
Log in with an admin account
Export all data in zip file. Extract that file.
[x] Ensure it contains an apiary_TIMESTAMP.csv file with all data from the apiary table, including the scores, properly quoted
[x] Ensure it contains a survey_TIMESTAMP.csv file which includes a user_id column
Overview
Previously, we only exported the Survey tables. This was not enough, as the Apiary surveys could not be connected to the User surveys, since the user_id was never attached to the Apiary surveys.
By exporting the Apiary table along with the results, we give the entire set of collected data to the exporting user, which will give them the flexibility to connect and slice it in many different ways.
Furthermore, the user_id column is also added to the Survey table export, which can help make the connection without an extra step of connecting with an Apiary first.
Connects #505
Demo
Testing Instructions
beekeepers startapiary_TIMESTAMP.csvfile with all data from the apiary table, including the scores, properly quotedsurvey_TIMESTAMP.csvfile which includes auser_idcolumn