Kanbanery resource parse

kanbanery_parser.py

# coding: utf-8
import json
from datetime import datetime
from operator import itemgetter
import codecs

tasks = []

with open('arquived.json', 'r') as f:
    tasks.extend(json.load(f))

with open('tasks.json', 'r') as f:
    tasks.extend(json.load(f))

with open('columns.json', 'r') as f:
    columns = {c['id']:c for c in json.load(f)}

ordered_tasks = sorted(tasks, key=itemgetter('moved_at'))

head = u'Título, Criação, Atualização, Status, Referência\n'
message = u'"{title}", "{created_at}", "{moved_at}", "{column_name}", "{id}"\n'

outputFile = codecs.open("historias_output.csv", "w", "UTF-8")
outputFile.write(head)

for i, task in enumerate(ordered_tasks):
    column = columns.get(task['column_id'])
    task['column_name'] = column['name'] if column else None
    task['created_at'] = datetime.strptime(task['created_at'],
        '%Y-%m-%dT%H:%M:%S+00:00').strftime('%Y-%m-%d')
    task['moved_at'] = datetime.strptime(task['moved_at'],
        '%Y-%m-%dT%H:%M:%S+00:00').strftime('%Y-%m-%d')

    task['count'] = i + 1
    task['title'] = task['title'].replace('\"', "'")
    task['description'] = task['description'].replace('\"', "'")
    outputFile.write(message.format(**task))