1. import os, json, datetime
2. ​
3. from dataclasses import dataclass
4. from typing import List, Optional
5. ​
6. filepath = os.path.expanduser("~/Downloads/super-productivity-backup.json")
7. ​
8. with open(filepath) as f:
9. data = json.loads(f.read())
10. ​
11. @dataclass
12. class Task:
13. id: str
14. parent: Optional[str]
15. title: str
16. reminder: Optional[int]
17. planned: Optional[int]
18. tags: List[str]
19. children: List[str]
20. done: bool
21. ​
22. # reminder id to timestamp mapping
23. reminders = {
24. reminder["id"]: reminder["remindAt"] for reminder in data["reminders"]
25. }
26. ​
27. # tag id to tag name mapping
28. tags = {
29. id: tag["title"] for id, tag in data["tag"]["entities"].items()
30. }
31. ​
32. projects = {
33. id: project["taskIds"] for id, project in data["project"]["entities"].items()
34. }
35. ​
36. # task id to task object mapping
37. tasks = {
38. id: Task(
39. id = id,
40. parent = task["parentId"],
41. title = task["title"],
42. reminder = reminders[task["reminderId"]] if task["reminderId"] else None,
43. planned = task["plannedAt"],
44. tags = task["tagIds"],
45. children = task["subTaskIds"],
46. done = task["isDone"]
47. ) for id, task in data["task"]["entities"].items()
48. }
49. ​
50. # convert a task to org-mode according to its level
51. def process_task(task: Task, level: int):
52. asterisks = "*" * level
53. ​
54. tags_str = ":".join([tags[tag_id] for tag_id in task.tags])
55. if tags_str:
56. tags_str = f":{tags_str}:"
57. ​
58. status = "DONE" if task.done else "TODO"
59. ​
60. # print headline in a children aware way
61. if task.children:
62. total = len(task.children)
63. done = sum(1 if task.done else 0 for task in (tasks[id] for id in task.children))
64. print(f"{asterisks} {status} [{done}/{total}] {task.title} {tags_str}")
65. else:
66. print(f"{asterisks} {status} {task.title} {tags_str}")
67. ​
68. # print scheduled and deadline (if any)
69. if task.planned:
70. print(f"SCHEDULED: {timestamp_to_org(task.planned / 1000)} ", end="")
71. ​
72. if task.reminder:
73. print(f"DEADLINE: {timestamp_to_org(task.reminder / 1000)}")
74. ​
75. print("")
76. # now recursively handle all sub-tasks
77. for child in task.children:
78. process_task(tasks[child], level = level + 1)
79. ​
80. ​
81. def timestamp_to_org(ts: int) -> str:
82. return datetime.datetime.fromtimestamp(ts).strftime("<%Y-%m-%d %a %H:%M>")
83. ​
84. def main():
85. # We start with iterating top-level tasks that have no parent
86. for task in tasks.values():
87. if task.parent == None:
88. process_task(task, level = 1)
89. ​
90. # However if you prefer to start from Projects as top level headline instead,
91. # Then comment out above part, and uncomment the below
92. # for project, task_ids in projects.items():
93. # print(f"* {project}\n")
94. # for id in task_ids:
95. # process_task(tasks[id], level = 2)
96. ​
97. main()