Playing with native.db

[matiu]

Dear all! Congratulation to everyone, the forum's contents are great!

I'm am trying to sync my E680 to my gentoo linux box. I don't want to use OTA, and I couldn't get any app to work with USB, so I am trying to do it by the hard way...

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).

One particulary interesting program in that package is db_dump. Here is a small script which extracts the contacts (name, tels, etc) from the database. Phone are displayed in reverse order, I will fix that these days. The goals is the get some format understood by thunderbird/evolution, to get at least a one-way synchronization tool. Since both (native.db, and thunderbird db) are stored in modified time order, It would be posible also to get a two-way synchronization tool.

Hope it helps someone!

matías
---------------
#!/bin/sh
db4.2_dump -p native.db | awk '
{ if ($1=="DATA=END")
f=0;
if (f==1)
print $0 ;
if (f==2)
if ($1="HEADER=END")
f=1;
if ($1=="database=contact_table")
f=2 ; } ' > kk

for i in 's/\\\00//g' 's/\\\02//g' 's/\\.\{2\}/ /g'
do
echo $i
cat kk | sed "$i" > kk.tmp
mv kk.tmp kk
done

cat kk | sort -f -d

[admin]

cool! another great guy!

[pascal]

cool! another great guy!

think so too

perhaps there is a way to do the same with sms?

[cytux]

Hope it helps someone!

Shure - this is great news! Many many thanks and welcome aboard! Another Gentooer.

[admin]

wads a gentooer?

couldn't find the meaning on google. lol

[pascal]

i am a gentooer too

cytux shorted it a little bit

gentooer = gentoo user

[irinoxx]

Hope it helps someone!

Yes, this is great.
Thank you!

[matiu]

perhaps there is a way to do the same with sms?

Yes! It is possible. The question is: What to do with the data? I am using thunderbird. Will work next days in a C program to read from native.db and get usefull information in a .csv format (contacts, sms, mails, calentar info, todo items),
which can be later importable (manually) from thunderbird/evolution/kmail.

The cool thing to do, however, would be a two-way synchro tool, but in this case we should limite us to only one mail/calentar app. What you think? Which is the mail/calendar app that you use most in your Linux?

Here is a script to get the sms, the messages are a little mess up, but it is a beginning

matías

----------------- get_sms.sh

#!/bin/sh

# get data in kk file
db4.2_dump -p native.db | awk '
/DATA=END/ { f=0; }
/HEADER=END/ { if (f==2) f=1; }
/database=ems_table_in_flash/ { f=1 }
/.*/ { if (f==1) print $0 ; } ' > kk

# filters some chars
for i in 's/\\\00//g' 's/\\\02//g' 's/\\.\{2\}/ /g'
do
echo $i
cat kk | sed "$i" > kk.tmp
mv kk.tmp kk
done

# print and filter first 14 chars
cat kk | awk '{ print substr($0,14)}'
rm -f kk
#-----------------------------------

[pascal]

Yes! It is possible. The question is: What to do with the data?

I want to backup my sms - have a lot of them - before i flash to e680i, and then insert them back on e680i

i am using at home kmail and at work evoulution (cause ximians exchange plugin), never tried thunderbird

[buhzi]

@matiu
nice to here from one using linux wanting to use the phone for what it is ment to be: not for gaming but for PDA functions

syncing is one of my long time hunting for the e680(i).
I want to see syncing of
- calendar
- phonebook
- notes

The backup of SMS/MMS could be also a nice feature.

I prefer the KitchenSync way because i use kde with Kontact.

May be i can help getting this on the road