I was a little behind when the Astrid website was closed down because I only used the Android app and not the web app. I saw that the devs provided an export functionality to the web app, but I cannot find it in the Android app, and I could not find any clue on the web on how to do that.

Is there a way to extract my Astrid tasks now that the web app is closed?


I have looked on the whole web and could not find any way. So I tried to use the same method that I have recently seen applied to a similar problem: assume that the database is stored in a common format (like SQL) and is accessible in the data/data folder of the root partition (equivalent of Windows's Program Files).

This is what I did, and it worked. Here are the steps:

1- Use a rooted explorer like Total Commander for Android and explore in the root partition the folder /data/data/com.timsu.astrid/databases.

2- Open your rooted explorer and copy the file database (there's no extension) to your SD card so that we can extract it and copy to the computer.

3- Copy via USB or your BlueStacks emulator the databases file onto your computer, and open it using a SQLite browser like this one.

4- Now you should be able to see the tables structures and contents. The interesting stuff are in the tasks and metadata tables (the latter contains tags and notes).

5- Execute the following SQL statement to neatly format the pertinent data:

SELECT date(t.created / 1000,'unixepoch') as date_created,date(t.modified / 1000,'unixepoch') as date_modified,m2.value as tags, t.title as title,m.value as comment
FROM tasks as t
LEFT OUTER JOIN (SELECT task, GROUP_CONCAT(value,' ;; ') as value FROM metadata WHERE key = 'note' GROUP BY task ORDER BY created) as m ON t._id = m.task
LEFT OUTER JOIN (SELECT task, GROUP_CONCAT(value, ';') as value FROM metadata WHERE key = 'tags-tag' GROUP BY task) as m2 ON t._id = m2.task
GROUP BY t._id ORDER BY t._id

6- Export the result into the file format you want, like .csv.

It's interesting to note that this method is quite generic and may also work for other Android apps.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.