First, you will need to backup your database to your SD Card. To do this, simply press Menu key + Manage DB from the Call Log app. Then press “Backup DB to SD Card.” This will place a backup of your database in the file location/sdcard/CallLog/calllog.db. Copy or email this file to your PC.
The database format that the Android platform uses is based on SQLite so in order to export your data to CSV you will need to download a program such as SQLite2009 Pro Enterprise Manager, which can be downloaded for free from http://osenxpsuite.net/?xp=3. Once installed, launch SQLite2009 Pro from the icon on your Desktop.
Click the down-arrow next to the left-most icon in the tool bar to open the drop-down menu, and select “Open Database.” Navigate to and select the calllog.db file that you copied to your PC earlier.
You should then see your database structure in the left pane.
Now erase the default text in the Query #1 tab and then type in “select * from log” and then press the execute query button on the toolbar (looks like a green play button). You should get a list of results in the lower pane. This step of generating results from the table is nesessary before an export can be performed.
Now, click the down-arrow next to the Export button on the toolbar and select “Export As Csv”, or other desired format.
If you select Export to Excel, Excel will launch automatically containing the log data.










[...] Read the how-to here. [...]
Pingback by How to export your Amateur Radio Call Log database to CSV « APK Labs — 2011/02/05 @ 4:29 pm