I have lost my Android phone but I have backup of my SD-card on which I have backup of my ColorNote app. How can I get all my notes from that backup?
NOTE: I am using iPhone now so don't have a Android device for now.
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. 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). Here's the walkthrough, inspired greatly by this post by Danyil Bohdan and this one:
Install ColorNote on an Android device. Since you don't have an Android phone, you can use BlueStacks to emulate an Android phone on your computer.
Open ColorNote and import your sd card backup file. Remember that you have to disable cloud syncing in order to show the Restore option as per the ColorNote's FAQ.
Check that your notes are correctly restored inside ColorNote by opening them. If they seem ok, continue to next step.
Install Total Commander for Android on your phone or BlueStacks emulator.
Open Total Commander and browse the root/filesystem partition and then browse to
/data/data/com.socialnmobile.dictapps.notepad.color.note/databases/. You need root rights to access /data/data, but in the BlueStacks emulator it should be easy to do. 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).
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).
colornote.db with a SQLite browser of your choice. A good open source and portable app for that is sqlitebrowser. You should now see something similar to this screen:
Click on the
Execute SQL tab (highlighted in red above) and execute the following sql statement:
SELECT date(created_date / 1000,'unixepoch'),date(modified_date / 1000,'unixepoch'),note FROM notes ORDER BY _id
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:
Open the .csv file into a UNIX friendly editor such as Notepad++ (else there won't be any line returns) and check if the content of your notes was correctly exported. They should be stored in chronologically ascending order (from oldest to newest at the bottom).
You can then import your .csv file in most programs or keep it as a readable backup of your notes.
Note that this technic works for most applications, since most Android apps use SQLite to store their databases (exception being some apps like WhatsApp which uses SQLite but encrypted to, of course, avoid leaking your private data to anyone).
You need another Android phone.
You can either:
To restore your notes from SD card which were backed up using ColorNote's Backup to SD card functionality you can try this.
Install ColorNote app and then go to
SD Card Backup. See if your earlier backups from SD card are listed there. If they are, select the one and your notes will be restored.
I have tried this using the same SD card, in your case you have a backup of it so I am not sure but I guess it should work. Let me know how it helps.
It is easy to restore ColorNote backup files from PC:
If your Android has a SD card, you could just plug the card into PC and copy the files. On my Colornote versions, the backup restore deletes previous files.
There is also another solution. If you download the app "Evernote" on your phone. You will then have two note apps; color note and evernote.
Then click on a note you want to keep. On my phone, HTC wildfire, you can press a "menu" button once you've accessed the particular note; And then you can choose "Share" or in my language "Send". You will then be able to send the particular note from "colornote" to "Evernote". "Evernote" is accessible for an iphone and an android phone, and the app enables you to transfer notes from different devices.
Hi I found the answer to lot's of peoples problems on restoring colornote files. Transfering from one mobile to another, I Tried everything but like most people I could see them on the phone's sd card but I could not read the files, this is how I managed. If you have files backed up to an external HDD copy the colornote data folder to the phone's sd card, open colornote go to settings & sign out of online sync (this is the secret), while in settings go to sd card back up and select the first one of your file's when you select the file it gives the option to restore. Hit restore and all your files will then show in colornote. If any files are locked it will require that you enter the password I just used the same as used on my old phone and I could then open and read the files.
I created a tool for decrypting backups when I wanted to export my old notes: https://github.com/olejorgenb/ColorNote-backup-decryptor
Not sure if it works on files created by newer versions of ColorNote. The files I successfully decrypted was 3-4 years old.