Playing with native.db

[matiu]

Never hear about KitchenSync, but I will try it!

I have been busy upgrading to 680i ! Nice! It look much better!

I made a small C program to read de native.db I will test it with the 680i now, and then I will send it to the forum.

I love this phone!!

[mudassar]

Regarding SMS:
Does this mean if an SMS is deleted from native.db it will be deleted from the phone ? i would love to have that control !!!

Also, does anyone know if it is possible to intercept SMS messages from Java ? any suggestions ? cos i want to make a program that would block all non-wanted SMS... awesome ryt ?

keep it up ppl !!
lets develop for Linux and make it the most dominant one ...!!!

-MAQ

[rpconnect]

The E680 appz store the data in
/ezxlocal/sysDatabase/native.db

which is a Berkeley DB file (Btree, version 9, native byte-order). To play with it, we need the db-utils package (simple 'db' in gentoo).

How did you figure this out? I'm wondering because I can use db_dump on the native.db file okay, but when I try it on a MIDLet RMS record (also a .db file) I get "unexpected file type"..

[pascal]

.db means not .db
think its no registerd file name extension

[matiu]

Hi All!

Here is a small C program to export all your contacts from your E680i phone to a standard CSV file, importable from most email clients (I have successfully use it with Thunderbird).

Still uses db_dump tool, I couldn't figured out yet how to get the data using Berkeley DB's API directly.

Works in Linux, and (maybe) under cygwin.


* Usage:
* 1) Compile this program (gcc -o get_contacts get_contacts.c)
* 2) Install Berkeley DB utils ('db-utils' package in many distros) ('db' in gentoo)
* 3) Grab from your phone /ezxlocal/sysDatabase/native.db
* 4) run: db_dump /path/to/native.db > native.raw
* 5) run: /path/to/get_contacts native.raw > contacts.csv
* Done! Your phone's contacts should be in contacts.csv file.

[matiu]

The E680 appz store the data in
/ezxlocal/sysDatabase/native.db

which is a Berkeley DB file (Btree, version 9, native byte-order). To play with it, we need the db-utils package (simple 'db' in gentoo).

How did you figure this out? I'm wondering because I can use db_dump on the native.db file okay, but when I try it on a MIDLet RMS record (also a .db file) I get "unexpected file type"..

UNIX's file utility:

$ file native.db
native.db: Berkeley DB (Btree, version 9, native byte-order)
$file --version
file-4.12

The file is 'dumpeable' with
$ db4.2_dump -V
Sleepycat Software: Berkeley DB 4.2.52: (December 3, 2003)

which says:
$db4.2_dump native.db |head
VERSION=3
format=bytevalue
[starts data]

[rpconnect]

@maitu
Thanks for the help, doing "file rms.db" says that it is simply a data file, at least I know now.

[matiu]

Dear all,

Here is a c program to export e680i contacts to .vcf, .txt or .csv files. It uses the Berlekey DB API directly, no need to run other programs. Works in Linux. It shoud handle UNICODE ok. See Changelog for details.

I have use it to export vcf and csv files to thunderbird and 'rolo'.

The program will soon accept synchronization features to/from:
.csv files
E680i's native db file
.ical
.vcf (vCard)
.txt
.mab (thunderbird)

And not so soon, it will be able to handle emails and SMS to/from .mbox format.

I try program it using a modular design, so it shouldn't be so difficult to add support of other formats. I will be working in: .db synchro filter, and .mab (Thunderbird's) synchro filter.

Any comments/feedback is welcome!

Enjoy!

matías

PS: The download will be soon removed, and added to the "download section"...

[maxx_730]

Cool, thanks! Wanna add it to the download section? I can do it too, but that way you wont be able to edit it if you release a new version

[matiu]

ok, I will add it wright now! thanks!
matías