1134830 - Script to export map data our of source and into JSON structure

Status: RESOLVED FIXED

(Websites :: Shape of the Web, defect)

Description

[Cory Price [:ckprice] (bugmail disabled, NI me!)]

This bug is to investigate how to export data out of the source sheets and into a JSON structure usable by SoTW. This would allow us to avoid manual entry of data.

Current JSON: https://github.com/mozilla/bedrock/blob/master/bedrock/shapeoftheweb/templates/shapeoftheweb/country-data.json

Source map data: https://docs.google.com/spreadsheets/d/1jN7RGMeA3-fofx5IGu1KWodRLRVl324kQj9r_7Kc6yg/edit#gid=0

It's possible that the agency provided such a script as well.

Comment 1

[Cory Price [:ckprice] (bugmail disabled, NI me!)]

Provided by the agency to convert data:

World Map Data Conversion Instructions

1. Select and copy all the data (including the header row) from the google doc
2. Visit 'Mr Data Convertor' - http://shancarter.github.io/mr-data-converter/
3. Paste into input CSV space
4. Ensure out put is set to 'JSON Properties'
5. Paste content of JSON Properties into development environment.

Comment 2

[Schalk Neethling [:espressive]]

Could we add the above to the README of the repo?

Comment 3

[[github robot]]

Commits pushed to master at https://github.com/mozilla/lorax

https://github.com/mozilla/lorax/commit/88d8acb4c7dc983ebac39e6310d6f21bcc40b88f
[bug 1134830] Update README
- Add Map Data source to README
- Add notes from original agency README (https://github.com/chrisjames-work/lorax)

https://github.com/mozilla/lorax/commit/199364ac6804778a23f6e65430116c4248f4f2a4
Merge pull request #18 from ckprice/bug-1134830-update-readme

[bug 1134830] Update README