Utility to generate a JSON object from a tabulated file
ClosedPublic
Actions

Authored by dereckson on Jun 28 2016, 14:52.

Details

Reviewers

Commits

rDWD228dfd4986f3: Utility to generate a JSON object from a tabulated file

Summary

This allows to copy/paste from Excel, LibreCalc, FramaCalc, etc.
into a temporary file, then convert this key\tvalue file into a
proper JSON object representation.

Sample input:

fr\tprénom
en\tgiven name

Sample output:

{
    "fr": "prénom",
    "en": "given name"
}

Test Plan

Use jsonlint to validate JSON is well formed.

Diff Detail

Lint

No Lint Coverage

Unit

No Test Coverage

Branch

D433

Build Status

Buildable 605
Build 721: arc lint + arc unit

Event Timeline

dereckson updated this revision to Diff 1051.Jun 28 2016, 14:52

dereckson retitled this revision from to Utility to generate a JSON object from a tabulated file.

dereckson updated this object.

dereckson edited the test plan for this revision. (Show Details)

dereckson added a reviewer: • Ash-Crow.

Let's add alphabetical sort, see first diff on D434 for difficulties to see where a language code is in the list.

Suggestion for alphabetical sort:

Insert at the top : import collection
Insert above the current line 21 : sorted_translations = collections.OrderedDict(sorted(translations.items()))

dereckson updated this object.Jun 28 2016, 15:33

dereckson edited edge metadata.

flake8, alphabetical sorting, some comments

This revision is now accepted and ready to land.Jun 28 2016, 15:55

Merged as 228dfd4986.

Revision Contents
Changeset List

Path

Size

tools/

spreadsheet2json

36 lines

Diff 1053

View Options

Utility to generate a JSON object from a tabulated fileClosedPublicActions