Database Users

Call History

Does anyone know if it's possible to look at the call history file so that it could be printed out from the host PC ?
Would be useful when filling out expenses claims to list all calls which were business related.
Thanks

Call history
Im looking for the same thing. A way to printout the call history, does anyone know a way or prehaps the Call history file name?

The file name is clog.db in the databases folder. Unfortunately it doesn't appear that the databases on the XDA can be opened.

here are some options as to which programs on pc may be able to open the file with the db extention
http://filext.com/detaillist.php?extdetail=db&goButton=Go

Thnx al lot crippsa and Rudegar, found the clog.db file and am able to open it with DBView.

Hi boeloe44,
I'm interested to know how you accessed the clog.db file with DBView. Is this the ARANAY DBView program ? (DBView V2) or another PPC application of the same name ?
I've tried the Aranay DBView which runs on the host PC and cannot seem to get it to connect to my XDA to read the DB files.
Any assistance you may be able to give would be appreciated.
Thanks
Alan

why not just copy the file to the pc that should make access a bit easier

crippsa said:
I'm interested to know how you accessed the clog.db file
Click to expand...
Click to collapse
Actualy dbview didn't help as i thought it would. I could only view the clog file with it and nothing else.
I found another program and this one did help me, its dbexlporer.
http://www.phatware.com/hpcdbex.html
Here you can download a trail version
With dbexplorer you can export a database to a comma separated file. This file is accessable and you can copy the file from your ppc to a desktop pc and open it with Microsoft Excel.
This is my way for printing out the call history, hoop it helps you crippsa.
To Rudegar: I was unable to find a way to copy the database to my desktop pc. I think the databases are lock or something.

I use Phone Dashboard for this purpose. It also tracks usage overall with some powerful filters such as free mobile-to-mobile plans, night/weekend, etc.

Thanks boeloe44 - DBExplorer is just the job, exports all the fields including the contact name - just what I'm looking for.
Phone Dashboard is good, but you still cant print the call log on the host PC and also it does not show the contact name. It only shows date, time, number and length. Unless of course the trial edition I'm using has less features that the full copy.
I've noticed that the clog.db only holds 50 entries, does anybody know if this can be expanded ?
Thanks,
Alan

The clog.db file certainly will hold thousands of entries. You can change the deletion settings by going to the phone, then call history, click on the tools menu, call timers...

Thanks Carlos - I've since found that Phone Dashboard can export the log file but it still doesn't contain the contact name, which is a pity as having it saves time by not having to look up the number to see if it was a personal or business call.
Thanks for advising how to adjust the deletion time on the clog database.
Alan

I've passed a comment to Hudson Mobile Technolgies (makers of Phone Dashboard) to include the name field in future releases of Dashboard

That would be a good idea. Another idea I sent him was to include the contact's CATEGORY. Then I'd have "client" in the field and would know to bill it. Right now I simply sort in Excel and search on the known billable numbers. Not as accurate or quick.
Overall though, that product is a very nice one to have on my phone. It has saved me money when I've been close to going over my plan. I don't know how it is in Europe, but US carriers screw you on overage (35-40 cents per minute).

Contact Searcher v4.0 ADDED: NEW SOFTWARE on 19/11/07

Many contacts info is stored in your handset.
When you need to call someone of the contacts , and you should
not remember their name or number clearly.
Your ppcs embedded contacts list software support searching by
their name or number only.
In this software, you can search the contacts by their any
property values, or searching in all of their property
information.
You can find them easily with this software. You can find them by
enter a word or a tip info of the contacts.
In the search by listbox, choose a condition.
If you choose all, the software will fix all of the contacts
property.
if you choose company the software will fix all of the
contacts company name property.
For example, you choose company, and in the is textbox, you
input microsoft or micro,
this software will select the contacts which company name property
is microsoft or micro for you.
For example, you choose all, and in the is textbox, you input
California,
this software will select the contacts which all properties
values have California string.
Not forget, click the button search, it will do searching.
The listbox will appeared the searching results after you click
search.
If want to call or sms someone of them, click it in the listbox
or move the cursor to him and
click the call & sms button.
Credit to SuYoG from ipmart
GET IT HERE
New Sofware: Software Deploy
Much faster
Much more functions
Input any chars of your ppc contacts list, such as their name, Company, address, and other all. It can find them directly and it support you call, sms, or email them.
Get it HERE

Nice effforts.
But it takes as much time as the standard inbuilt "search" program takes. In case we can improve the speed then this program would be worth your efforts..good luck

ADDED: New Software: Software Deploy
Much faster
Much more funtions
input any chars of your ppc contacts list,
such as their name, company,address, and other all.
it can find them directly.
and it support you call, sms, or email them.
Get it in the first post.

Any chance of a screenshot and a zip file?
Social networking sites are barred at my office
Thanks,

Thanks, will try this out.

I dont notice any significant improvement in the speed. Nerthless, good efforts..

Jajah Plugin

I'm a big Jajah user, and one of the things that has been annoying me is the lack of direct support in Windows Mobile.
Therefore, with a little hacking and even less development, I've created a small context menu extension to the Contacts list which allows you to call a contact using Jajah. What this actually does is uses the Jajah API (Web Service).
To use, install the below attached CAB.
You can then run the Jajah Configuration application from your Program Files to set up your User, Password and Number. Note that if you try to dial and one of those isn't set, the configuration application will run instead of dialing.
Note that if you have contacts running, you need to either kill the process (via ControlPanel->System->Memory) or restart the device to have the option appear on your contacts context menu. In other words, if it doesn't work, please reboot and see if it works before leaving messages here.
Additionally, each number dialed should have a prefix (that is, country code).
TESTED ON:
Devices - XPERIA & DEVICE EMULATOR WM6 PROFESSIONAL
Phone #- +1 (xxx) xxx-xxxx
Enjoy - SUGGESTIONS WELCOME!

great job !
thanks for your software !I am a jajah user too .I will testing soon .

[Q] Private Update Server

I have made an application for my fire department where it will send a text message when we get paged out. The only problem right now is that I have to hard code the numbers of the members in until I learn how to do multiple contact selection and code it in.
For right now, myself and 3 other people have the program but I am constantly adding/deleting numbers. How would I go about adding a button that could check a personal server for an application update? I don't want to put this application on the market for the simple fact that it needs to stay private.

Skullmonkey said:
I have made an application for my fire department where it will send a text message when we get paged out. The only problem right now is that I have to hard code the numbers of the members in until I learn how to do multiple contact selection and code it in.
For right now, myself and 3 other people have the program but I am constantly adding/deleting numbers. How would I go about adding a button that could check a personal server for an application update? I don't want to put this application on the market for the simple fact that it needs to stay private.
Click to expand...
Click to collapse
Why not just read the contact info from a web server? Just update it in one place and the clients get it from there.

Skullmonkey said:
I have made an application for my fire department where it will send a text message when we get paged out. The only problem right now is that I have to hard code the numbers of the members in until I learn how to do multiple contact selection and code it in.
For right now, myself and 3 other people have the program but I am constantly adding/deleting numbers. How would I go about adding a button that could check a personal server for an application update? I don't want to put this application on the market for the simple fact that it needs to stay private.
Click to expand...
Click to collapse
I did that on my own app. It downloads the file from my Sourceforge site, takes the MD5 sum of it, and compares it to its own MD5. It's inefficient because it downloads the entire file before deciding if it needs to update, but it works and all I have to do to update it is change the .apk it downloads.
The relevant .java file in my app can be found here and the pertinent method is the update method starting on line 214. It uses the downloadAndInstall() ASyncTask on line 337, as well. Hope it helps!

[Q] simple app using HTTP to send and recieve (NO PHP)

Hello all,
I am new to android programming, I was able to get the suduko program working… by the aid of a hello android book..
Now on to make my own program.. I basically want to be able to have a simple GUI that will give the user the ability to query a website and get a response back. Just as if they were on the website and they had to hit a radial button to check item category being searched then hit sumbit then that would bring them to an other page where they (depending on the radial button clicked) would either enter a serial number in or have to click the drop down box and select a province and then enter the serial number to be queried. The site returns if it is valid or not.
Obviously I would want this to be on a GUI on the phone . But I have no clue where to start in terms of A) how to get the app to send the serial number/letters to the website and return what the query is. B) how to make the app select a radial button and C) how to make the app select dropdown menu of the province on the actual website.
Any help to get started would be very much appreciated.. Again, I am a complete noob. I have read a basic hello android book I have searched google and all I see mainly is HTTP GET or POST but really have no idea how to use them in the context I described, or even if that is what I need for my specific application.
I was hoping not to use PHP or setup a server.. Is this possible?
Thank in advance