steps start here:
install android studio
IMPORTANT! : allow usb debugging on phone
go to the sdk/platform-tools folder
C:\Users\User\AppData\Local\Android\Sdk\platform-tools
run cmd inside it (click the path, type “cmd” and hit enter)
run command “
adb devices -l” there (inside cmd)
see your device
inside cmd inside the platform-tools folder. Example output:
adb devices -l
List of devices attached
29c5d264 device product:BEST_PRODUCT model:FBEST_MODEL device:BEST_DEVICE transport_id:1
run in cmd:
adb backup -noapk com.socialnmobile.dictapps.notepad.color.note
on your phone the message asking about backup and the password for it, appeared. do not set password, to not have problems, just push “backup” button
got the backup.ab file appeared in the directory of platform-tools
install git for windows on the pc
open git bash inside platform-tools folder
run this command
dd if=backup.ab bs=24 skip=1|openssl zlib -d > backup.tar
backup.tar appeared inside “…/platform-tools” folder
install 7zip
extract backup.tar to the folder C:\Users\NameOfUser\Desktop\backup\
got colornote.db file inside here C:\Users\NameOfUser\Desktop\backup\apps\com.socialnmobile.dictapps.notepad.color.note\db\
install sqlitebrowser
switched to the 'Browse Data' tab, and changed the table to "notes"
see your notes,
go to “execute sql” tab
enter following:
CREATE TABLE new_table AS select datetime(created_date/1000,'unixepoch', 'localtime'),datetime(modified_date/1000,'unixepoch', 'localtime'),note from notes order by _id
run it
switched to the 'Browse Data' tab, and changed the table to "new_table"
notes are there, but if you export it to csv (from file menu) it does not display Unicode chars
for it to display Unicode properly you need to:
open it in notepad, see abracadabra, select “save as”, and in the saving menu choose “UTF-8 with BOM” instead of whatever you have there.
Voila, you can read your Unicode notes
Thanks goes to
http://blog.nobytes.com/2012/03/android-colornote-notes-recovery.html
https://developer.android.com/studio/command-line/adb
https://developer.android.com/studio/releases/platform-tools
https://stackoverflow.com/questions...ta-folder-in-android-device/17876731#17876731
https://stackoverflow.com/questions...recognized-as-an-internal-or-external-command
https://primarytext.jp/blog/1275#CSVUTF-8Shift_JIS
https://excel.tips.net/T008441_Hash_Marks_Displayed_Instead_of_Cell_Contents.html
https://www.techonthenet.com/sqlite/tables/create_table_as.php
https://stackoverflow.com/questions/14629347/how-to-convert-unix-epoch-time-in-sqlite
https://android.stackexchange.com/questions/35207/import-data-from-colornote-app/92756#92756
