Appointment/Database query/export tool ? - Windows Mobile Development and Hacking General

Hi,
i'm desperatly looking for a tool to query the appoinments database, or export it to a Tab- delimited file.
I need to seach in the database for appoinments with location, and manipulate the data of that record with MortScript.
Mortsscript can do quite some tricks, but it can't read the database...
If there is a scripttool that can, i'm interested to know, now, ik have no way to 'read' the appoinment data. There's a opensource POOM Wrapper, but it's not compiled to export the agenda, only contacts
Btw, i'm running WM2003.

Related

Backing up databases

Hi! Does anyone know if there's a program that will work on the Universal that allows me to back up my databases (either ALL or selectively)?
I previously used DBExplorer
http://www.phatware.com/hpcdbex.html
which was excellent but the author doesn't have any plans to develop a version for WM5
Thanks
Database access seems to be quite a problem, i'm still looking for a tool that can "querry" the agenda, or beter, export appintments of day dd/mm/yyyy...
Can't help ypu with a WM2005 DB viewer, but will keep my eyes open during my search for a export tool
Thanks!

Pocket Outlook Location

Im trying to set a softkey to point to my Pocket Outlook Contacts.
Anybody know the location??
can't quite remember the format and not 100% sure this will do the trick...
try either windows\poutlook.exe -contacts or Windows\poutlook.exe contacts (without the dash)
Hope this helps.
nope didnt work.
The properties in the link should be
''poutlook.exe'' contacts
Works on my device - will post the link if you still have problems
am i missing something here? (yes this is my first PPC device) i have the cingular branded 8125 with 2.25.. and when i click on poutlook.exe i get nothing that comes up? is there a pocket version like pocket excel/powerpoint, etc?
PocketOutook Contacts Recovery and Keymap after Goodlink!!!!
NOTE: I have included a reg file that can be imported via your favorite pocket registry editor that will assign your voice command key to pocket outlook contacts!
If you navigate in the registry to
HKLM\SOFTWARE\Microsoft\Shell\Keys\
you can modify the string of one of the hardware keys to
"\Windows\poutlook.exe" contacts
That will launch Pocket Outlook Contacts. I have used my voice command key because i never use voice command.
Alternatively, you could create a shortcut that passes the argument -contacts when it executes poutlook.exe.
I hope that helps!
Regards,
Zak Deutsch
[email protected]

Exporting Call log on windows mobile 5?

I've had the most trouble trying to figure this one out.
I have a client who needs to be able to export or record in a sortable format, his call log. Particularly the phone number, contact name, call time and duration, and of course date.
There's several ways to go about it. I've tried the service at www.1800message.com which has given me the most success, but now they seem to be on hold for storage issues.
I've also tried the phone dashboard app that's out there, however, what it exports is really not useful because there is no contact name mapped to the phone numbers, you just see the numbers.
I've also tried another app that did outlook journaling in the windows mobile device, but again its no good for the client since you manually have to select each call to put in the journal.
Finally, the one I really wanted to try was Modaco smart journal, which just was a tray app that synced the call log to outlook (again, journal, but you could get reports from that), however its seemed to completely dissapear from the internet.
So what is out there besides what I've found? I even read somewhere that call log export was a function of WM5, but I've found no supporting evidence since, or even the originating article of such a rumor.
Isn't the log just a hidden database file just like the calendar items and contacts, etc? I've never tried but maybe you can use excel or another program to read it. You could occasionally copy the file to the desktop then compile the databases together and remove duplicate entries.
Nicnatros said:
Isn't the log just a hidden database file just like the calendar items and contacts, etc? I've never tried but maybe you can use excel or another program to read it. You could occasionally copy the file to the desktop then compile the databases together and remove duplicate entries.
Click to expand...
Click to collapse
Any ideas on where to look and or known possible filetypes? I hadn't had time to pick through all phone files, but just curious if anyone can give me direction there.
CaptDistraction said:
Any ideas on where to look and or known possible filetypes? I hadn't had time to pick through all phone files, but just curious if anyone can give me direction there.
Click to expand...
Click to collapse
I'm currently working on this. I intend to extend my PPCBckpContacts application, so SMS, Calls history, Tasks, appointments and Speed dial can be backed up in csv files.
The calls log is in the pim.vol.
Cheers,
.Fred
dotfred said:
I'm currently working on this. I intend to extend my PPCBckpContacts application, so SMS, Calls history, Tasks, appointments and Speed dial can be backed up in csv files.
The calls log is in the pim.vol.
Cheers,
.Fred
Click to expand...
Click to collapse
Is there any way to view the contents? I just bought SKTools, but it doesn't seem to support working with the pim.vol database, even though it gives me record counts for the different tables.
CaptDistraction said:
Is there any way to view the contents? I just bought SKTools, but it doesn't seem to support working with the pim.vol database, even though it gives me record counts for the different tables.
Click to expand...
Click to collapse
The pim.vol contains several databases, so yes you could see the contents by using an hex editor, but it's not easy. The best way is using CEDB/EDB api from windows to access the records of the db.
Cheers,
.Fred
Hmm, so basically I'd have to develop a WM application that utilized that api to read the contents of the pim.vol file and exported it?
I've got a few years of programming under my belt, but I really have 0 windows/windows mobile experience.
If its something simple, I could probably read up and compile an app to do it, but just seems like a daunting task, especially on the cost to benefit side of things with what time it would take for me to get up to speed and figure out creating an application.
Are there any tools out there for the EDB type of database?
CaptDistraction said:
Hmm, so basically I'd have to develop a WM application that utilized that api to read the contents of the pim.vol file and exported it?
I've got a few years of programming under my belt, but I really have 0 windows/windows mobile experience.
If its something simple, I could probably read up and compile an app to do it, but just seems like a daunting task, especially on the cost to benefit side of things with what time it would take for me to get up to speed and figure out creating an application.
Are there any tools out there for the EDB type of database?
Click to expand...
Click to collapse
That's what I did in PPCContactsMgr, in order to get the missed calls in order to add a phone number to an existing contact.
Now I'm working on the backup.
I really don't know, I put my hands in the mud, I made a lot of tests and finally found something reasonable to get the infos.
Cheers,
.Fred
dotfred said:
That's what I did in PPCContactsMgr, in order to get the missed calls in order to add a phone number to an existing contact.
Now I'm working on the backup.
I really don't know, I put my hands in the mud, I made a lot of tests and finally found something reasonable to get the infos.
Cheers,
.Fred
Click to expand...
Click to collapse
well, I'll have to follow your work then, sounds like what you are developing would be just the ticket for what I am trying to do.
CaptDistraction said:
Is there any way to view the contents? I just bought SKTools, but it doesn't seem to support working with the pim.vol database, even though it gives me record counts for the different tables.
Click to expand...
Click to collapse
you try last SKTools version?
this can export clog.db from PIM.vol
import not supported yet
S_K said:
you try last SKTools version?
this can export clog.db from PIM.vol
import not supported yet
Click to expand...
Click to collapse
My foot to my mouth. It does it.
CaptDistraction said:
My foot to my mouth. It does it.
Click to expand...
Click to collapse
My PpcBckpcontacts application does import/export of call logs!
See here:
http://forum.xda-developers.com/showthread.php?t=279925&highlight=last+name+contacts

Contacts to XML

Can anyone help, I am looking for a way to create a small application that allows the WM5 & WM6 Contacts to a .xml file. And Mabey a way to feed it to a server (FTP)
Can anyone help with this?
I am basically trying to find a way to backup massive ammounts of contaccts to a webserver for over 800 users
Just write your own tool for it
For example with .NET it's possible to interact with the contacts-file using the .NETCF classes.
.NETCF also supports XML functionality.
you do the math
Pocket SMS Manager
Hi,
My PocketSMS Manager does this. It may not export enough detail for you though. Have a look at my application (further down this thread).
If you need more fields exporting just let me know as it will only take me a few minutes to drop them in.
Pete
[email protected]

How to enumerate categories

Hello,
I'm developing a small application working with PIM. I can't find a simple way to enumerate PIM categories (or Groups as called in Manila). The only way I found is to go through all appointments, contacts and tasks and read categories from its property Categories. This works, but it is really uneffective way how to do this. Can you please suggest the better solution?
phoenix100 said:
Hello,
I'm developing a small application working with PIM. I can't find a simple way to enumerate PIM categories (or Groups as called in Manila). The only way I found is to go through all appointments, contacts and tasks and read categories from its property Categories. This works, but it is really uneffective way how to do this. Can you please suggest the better solution?
Click to expand...
Click to collapse
Are you coding in c++ or c# or what? I have the code for c++ in the iAgenda program which is open source.
I'm coding in c#, using library WindowsMobile.PocketOutlook.

Categories

Resources