Import dataset from CSV to ETlocal

To import/update a dataset from excel into your local ETlocal-database, do the following steps:

1. Clone the ETlocal branch on your local machine
2. Create a new database in Sequel Pro and call it etlocal_development. Search for the latest ETlocal database on Dropbox (folder: "Development > Databases") and import that in Sequel Pro.
3. Add an .env file in the main folder your ETlocal-branch and include there the MAPBOX_API_KEY and an EXPORT_ROOT (either your local server (localhost:3000) or beta (beta-local.energytransitionmodel.com.))
4. Run bundle exec rails generate data_migration <name> . With this you create a new folder in the folder "db > migrate" with the name you filled in. In this folder two automatically generated files appear (data.csv and commits.yml). You can throw these away, since you are going to generate new ones!
5. Create two files in excel and add these in the new folder:

• one with the names of the variables that you want to update on the first row and the municipalities that you want to update in the first column. The values in this matrix you can copy from the excel ETLocal_default_datasets_2016_step2_estimating_blanks and then paste it with 'values & number formatting'. Save this file as data.csv (comma separated values).
• one file with the commit messages you want to include with the values, which you should save as commits.yml.

6. Then migrate the new values in your local database with: rake db:migrate