Skip to content

Instantly share code, notes, and snippets.

@mgeh
mgeh / jq_trello_exports.md
Last active August 29, 2020 16:46
Use JQ to make a CSVs out of Trello Export output, with additional columns for repeating labels

Un-normalised output:

(reduce .lists[] as $list ({}; .[$list.id] = $list.name)) as $lists | 
.cards[] | 
select(.closed != true) | 
[$lists[.idList], .name, .labels[].name]) | 
@csv

Normalised output: