You should now see a list of records below the sql statement, and you can click on the little floppy disk icon on the right to export into CSV, as shown here: SELECT date(created_date / 1000,'unixepoch'),date(modified_date / 1000,'unixepoch'),note FROM notes ORDER BY _id
You should now see something similar to this screen:Ĭlick on the Execute SQL tab (highlighted in red above) and execute the following sql statement:
#COLOR NOTE SYNC GMAIL PORTABLE#
A good open source and portable app for that is sqlitebrowser. Open colornote.db with a SQLite browser of your choice. Transfer the colornote.db file to your computer (either via USB if you're using an Android phone, or by copying the file from the BlueStacks emulator). Inside this folder, copy the file colornote.db to your SD card slot (I don't know how it works inside BlueStacks but you should have the possibility to setup a virtual SD card or send directly to your computer). You need root rights to access /data/data, but in the BlueStacks emulator it should be easy to do. Open Total Commander and browse the root/filesystem partition and then browse to /data/data/.color.note/databases/.
#COLOR NOTE SYNC GMAIL INSTALL#
Install Total Commander for Android on your phone or BlueStacks emulator. Remember that you have to disable cloud syncing in order to show the Restore option as per the ColorNote's FAQ.Ĭheck that your notes are correctly restored inside ColorNote by opening them. Open ColorNote and import your sd card backup file.
Since you don't have an Android phone, you can use BlueStacks to emulate an Android phone on your computer. Here's the walkthrough, inspired greatly by this post by Danyil Bohdan and this one: So we will have to do it in two steps: first reimport the sd card backup into the ColorNote app, then extract the generated colornote.db SQLite file (note that you must have rooted your phone to access the SQLite file, but you can do it on the BlueStacks emulator). Yes you can, but it will be a bit convoluted: ColorNote's notes can only be exported from the SQLite colornote.db file, but it's not available from the sd card backups.
0 kommentar(er)
