#!/usr/bin/python import json datafile = open('fabricademy_data.json','r') data = json.load(datafile) projects_list = data['library']['projects'] projects = [] for key in projects_list.keys(): p = projects_list[key] for k in p.keys(): print('%s = %s' % (k, p[k])) print('---') project = { "id": key, "category": p['category'], "name": p['name'], "created": p['created'], "downloaded": p.get('downloaded'), "description": p['description'], 'thumbnail': p['thumbnail'], 'userAvatar': p['userAvatar'], 'username': p.get('username',''), 'userId': p['userId'], 'downloadsCount': p.get('downloadsCount', 0), 'commentsCount': p.get('commentsCount',0) , 'tags': p.get('tags',{}).values() , 'photos': p.get('photos',{}).values(), 'files': p.get('files',{}).values(), 'comments': p.get('comments',{}).values() } projects.append(project) json.dump(projects, open('out_projects.json','w')) category_list = data['library']['categories'] categories = [] for key in category_list.keys(): c = category_list[key] categories.append({ "id": c['_id'], "label": c['label'] }) json.dump(categories, open('out_categories.json','w'))