Download data from SQL

Once you’ve selected the environment for production, you’ll need to update crepe data store with the latest data from SQL database. At crepe interface, type option 2 to enter the download interface:

LA CREPE SQL INTERFACE
=======================================

You are currently set to work with the following environment:
     - product: spr
Please select your options:
     1. Download all data: XL, funder-level, and custom+subgroup
     2. Download just response set (XL)
     3. Download funder-level meta data only, e.g., OBR, rounds, funders, etc.
     4. Download custom+subgroup data for all funders in /clients
     5. Select a funder, then download custom+subgroup data for just that funder
     6. Return to main LA CREPE interface

Enter your options here:

You’ll need to download two types of data:

• Respondent data: This large file contains all survey data since the inception of this report type. Select option 2 here to download the data. It’ll be saved under *pr/sql/xl.csv (*pr represents one of the four report types: gpr, dpr, spr, apr). Colloquially we call this option 2-2 (since you have to type 2 to enter SQL download, and then 2 to get the response data set)
• Funder-level meta data: This is a collection of tables storing information such as the full name of the foundation, the survey round dates, and other data collected about the foundation through the Data Collection Sheet. Select option 3 here to download the data. The files will be saved under *pr/sql. This option is also known as 2-3.