Archiver for RealMac Software's Clear

USE AT YOUR OWN RISK

This is untested software.

DISCLAIMER: THIS SOFTWARE IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED. ALL EXPRESS OR IMPLIED REPRESENTATIONS, CONDITIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE, ARE DISCLAIMED, EXCEPT TO THE EXTENT THAT SUCH DISCLAIMERS ARE DETERMINED TO BE ILLEGAL.

No affiliation with RealMac Software. This is a bootstrapped Go program that:

Reads the Clear database from $HOME/Library/Containers/com.realmacsoftware.clear.mac/Data/Library/Application Support/com.realmacsoftware.clear.mac/LocalTasks.sqlite
Saves data from the tasks and completed_tasks to CSV files.

Caveat Emptor

clear-archiver runs READ-only queries on your Clear database. It never writes to it.

That being said, interacting directly with a database should always be done carefully. Make a backup of your Clear database before running this application.

The program is unfinished, and meant as a quick n' dirty way to get some personal tasks done (i.e. saving my Clear todo list in a text file) and as a small demo project to show how easy it is to work with the Go programming language.

Requirements

This Go application is built with:

Go 1.11.2 darwin/amd64
A laptop running macOS 10.14.2

Usage

To use, download the binary from https://github.com/zeddee/clear-archiver/releases and run it in the terminal:

./clear-archiver

Notes

Clear uses an embedded sqlite3 database that's usually saved in:

$HOME/Library/Containers/com.realmacsoftware.clear.mac/Data/Library/Application Support/com.realmacsoftware.clear.mac/LocalTasks.sqlite

It contains the following tables:

tasks: All current tasks in Clear.
completed_tasks: All tasks marked as "complete" in Clear.
lists: All lists of tasks in Clear.
modelmeta_int: ?
task_reminders: Presumably, information on tasks that have reminders set.
version: ? Presumably metadata related to task versioning.

TODO

Allow user to select location of Clear database.
Allow user to save entries from lists database.
Allow user to set output files for extracted data.
Allow user to set destination of log output.

License

zeddee/clear-archiver

ErrorLooks like something went wrong!

About

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Languages

Error
Looks like something went wrong!

Packages