search

ESDet / esdportal_profile

drupal install profile for portal.excellentschoolsdetroit.org
0 stars 4 forks source link

2017 data #59

Open bnchdrff opened 7 years ago

bnchdrff commented 7 years ago

cleaned up a little bit past what @anderoy gave me:

2017 scorecard ready for import.zip

bnchdrff commented 7 years ago

added table schemata for three new tables in https://github.com/ESDet/esdportal_profile/tree/scorecard2017

loaded data locally after fixing random errors in the CSVs.

steps to deploy:

# load data from local
mysqldump -uroot portal count_2017 esd_k8_2017 k12_supplemental_2017 | platform ssh 'cd public; drush sqlc'
bnchdrff commented 7 years ago

up on development server: https://2016-july-updates-3mhev6qb5ihtc.us.platform.sh/api/1.0/schools/2120.json?includes=count_2017

@anderoy @alectower

bnchdrff commented 7 years ago

@anderoy let me know if any special queries should be updated for 2017

anderoy commented 7 years ago

@bnchdrff looks good. I don't think at this point we need to add any special queries. If we do, we will tackle those early March.

If you think everything is good to go, go ahead and update the live portal, thanks!

bnchdrff commented 7 years ago

it's up on production @alectower @anderoy