Database Users

Voice Speed Dial, backup

Des anyone knows where and which information/files to backup, in order to keep 'Voice Speed Dial' voice tags across hardresets?

Conchas said:
Des anyone knows where and which information/files to backup, in order to keep 'Voice Speed Dial' voice tags across hardresets?
Click to expand...
Click to collapse
VoiceTags are stored in "\windows\commandmodel1.bin".
Putting this back after hard-resets does work, but the VoiceTags will only appear once you re-sync your contacts again.
Don't yet know where the SpeedDial entries are held.
Many thanks to the person that told me about it.

Thans for the info.
Concerning SpeedDial, my experience with hardresets on WM2003 was that all entries were broken even after contacts re-sync.
This after restoring backup files from xBackup or Activesync.
Don't know yet about the behaviour with WM2005, since no backup applications were availble till recently.

Conchas said:
Concerning SpeedDial, my experience with hardresets on WM2003 was that all entries were broken even after contacts re-sync.
This after restoring backup files from xBackup or Activesync.
Don't know yet about the behaviour with WM2005, since no backup applications were availble till recently.
Click to expand...
Click to collapse
Yeh, from my experience with an older HP Jornada 928 (PPC-2002) I'm somewhat doubtful that the SpeedDial numbers are recoverable. I think they used a GUID or similar that was never identical even after a soft-reset of the device. At least the Exec/Univeral's SpeedDials remain after a soft-reset - which is one step forward. I tried looking for modified file dates after changes, but couldn't find any.
Just checked a full registry dump for changes after modifying Speed Dial entries - nothing visible.

CSV Import Calendar and Contacts

Yes, i've seen similar questions asked but Windows Mobile 2005 in usual Microsoft Stupidity doesnt seem to have any import functions. My contacts and calendar items are all stored on google contacts and my mac. Since I cant use activesync I need someway of importing these items. Now im not sure there is any method to do this. Has anyone tried CSV importing using 3rd party software at all?

Oni said:
Yes, i've seen similar questions asked but Windows Mobile 2005 in usual Microsoft Stupidity doesnt seem to have any import functions. My contacts and calendar items are all stored on google contacts and my mac. Since I cant use activesync I need someway of importing these items. Now im not sure there is any method to do this. Has anyone tried CSV importing using 3rd party software at all?
Click to expand...
Click to collapse
I made a tool to do backup/restore of outlook contacts, you can find it on http://buzzdev.net in the download section.
Here is the link of the download (you need to be registered):
http://buzzdev.net/component/option,com_remository/Itemid,109/func,fileinfo/id,215/
Here is the link of the screenshots and some info about the prog.:
http://buzzdev.net/component/option,com_simpleboard/Itemid,59/func,view/id,10234/catid,33/
I wasn't interested in appointments, so I didn't do any development on that, sorry.
Cheers,
.Fred
ps.: the layout of the csv file is well defined. I suggest you to do a backup of your wm2005 contacts, then edit the csv file produced and do a restore.
pps.: if you need more infos, don't hesitate to ask.

Thanks for the reply. Such a program was pretty much what i wanted. However, Im afraid to say that it doesnt actually support proper CSV. For starters, your file uses semi-colons. The CSV file im using is produced by GoogleMAil so its standard is beyond reproach. Still, it seems to work for backing up purposes. I suspect this is another slight variation from Microsoft again.

Oni said:
Thanks for the reply. Such a program was pretty much what i wanted. However, Im afraid to say that it doesnt actually support proper CSV. For starters, your file uses semi-colons. The CSV file im using is produced by GoogleMAil so its standard is beyond reproach. Still, it seems to work for backing up purposes. I suspect this is another slight variation from Microsoft again.
Click to expand...
Click to collapse
Sorry for that, maybe in a future version I will add a version where the delimiter could be chosen by the user.
Cheers,
.Fred

Well i tried changing the delimeter to semi colon and it still complained that the file wasnt genuine. Is this an encoding isue do you think?

Actually i tried re-encoding the file but with no luck. Stupid microsoft. Of course an import function is needed! Grrrrr :x

Oni said:
Well i tried changing the delimeter to semi colon and it still complained that the file wasnt genuine. Is this an encoding isue do you think?
Click to expand...
Click to collapse
Are you sure you respect every field defined in the first record, which is the header?

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

Automated purge of ActiveSync email?

My back is against the wall, and I'm hoping someone has a creative idea on how to do this...
I am looking for a way to purge the ActiveSync email from a Windows Mobile 5/6 device through a combination of registry or file system settings, or perhaps some application, ie. something I could do with MortScript. Deleting the PIM data (calendar, contacts, tasks) is trivial...rename the pim.vol file, force a reboot, and have another Mortscript file waiting in \Windows\StartUp to then delete the old file. Email, on the other hand, is really, really hard. You can delete the email bodies and attachments in \Windows\Messaging, but the index remains in cemail.vol. I've read about one technique to outright delete cemail.vol, but this database also houses SMS messages, making this a bad idea.
Then I found the Registry value ClientReset, located in HKCU\Software\Microsoft\ActiveSync\Partners\{GUID}, which does exactly what I want...except that it doesn't have an effect when the program that stored the email was written instead by a third party, and just borrowing the ActiveSync message store. I can set up an ActiveSync connection, wait until it starts to sync, cancel it, then make sure ClientReset=1, and re-sync...but the purpose of the project is to automate the process. It seems ActiveSync is looking in one of the *.vol files for its cue to obey ClientReset, but even if I could find the value, folder, whatever, I know of no way to change the databases through scripting.
Has anybody been able to do this, or does anyone have ideas?
Many thanks for your suggestions!
Todd

What's your FAVORITE way of saving configuration between ROMs

Was wondering how does each one keeps his settings and configuration between changing ROMS. Including keeping the Call history, SMS history etc...
I have tried Sashimi once but was overwhelmed with the settings and learning curve and decided to neglect it. I use my HD2 as a business tool and don't have hours to spend each time on configuring between ROMs.

Well, if you see your HD2 as a "business tool" imo it would be the best solution to decide for one ROM and keep it for a while...
I use a mixture of Sashimi, Outlook, MyPhone and CeRegEditor. With Sashimi I backup my mail-account-setup, with MS MyPhone I backup my SMS and WWW-bookmarks, with Outlook (of course) I "backup" my appointments and contacts, with CeRegEditor I backup my app-registration-info out of the registry that I do not always have to re-activate my apps and type in serials etc.
That does it for me. I don't like full-backup-solutions like Sprite or SPB Backup.
Cheers

spb backup for my mail,contacts and text messages.
And at last sashimi to install al my programs quickly.
And my own created cab with registery entries so I can quickly change everthing.

de Wolfe said:
Well, if you see your HD2 as a "business tool" imo it would be the best solution to decide for one ROM and keep it for a while...
I use a mixture of Sashimi, Outlook, MyPhone and CeRegEditor. With Sashimi I backup my mail-account-setup, with MS MyPhone I backup my SMS and WWW-bookmarks, with Outlook (of course) I "backup" my appointments and contacts, with CeRegEditor I backup my app-registration-info out of the registry that I do not always have to re-activate my apps and type in serials etc.
That does it for me. I don't like full-backup-solutions like Sprite or SPB Backup.
Cheers
Click to expand...
Click to collapse
Pretty much EXACTLY what I do as well...

I dont simple, the only thing i have backed up is my memory card on the pc and contacts, calender in myphone that's it I like to change the settings differently on ROM's

Sashimi for Mail-Config, applications, registry-tweaks
MyPhone for text messages, bookmarks and tasks
Sashimi changed my life

I'm with mischgin regarding sashimi.
It alone can manage most of the things some of you do with 5 different apps
Cab autoinstall, either on internal memory or SD (you chose which goes where), registry key importing (export with total commander, sashimi will reimport back), single file copying (mirroring the root folder structure), XML provisioning for wifi and mail accounts via makisu.
This is what I use, and on top of that I only need pimbackup to restore everything else which is PIM related.
I don't use the EXE and CERT folders of SAHIMI (yet), but I can pretty much restore *everything* automatically.
The only things I don't, is because I don't knows their registry entries in order to export them (for instance, everything you change from under manila settings )

SPB backup without a doubt!

I dont use any kind of backup.
I use a rom that uses the autoinstall folder,
i created a cab of my email settings using makisu (sashimi's little brother),
and a cab of my registry tweaks(including the home quicklinks), which i update as and when i find more tweaks,
and i sync with Outlook on the pc for contacts.
Mail gets restored because my phone doesnt delete it off the server, so its still there next time you send/recieve, (unless the PC has checked them in the meantime, of course, in which case they are on the PC, and subsequently in the outlook email account on teh phone)
I dont back up txt's, i've never understood why anyone keeps them, to me its the same as recording every phone call and keeping the recordings, , why???
From the start of teh hard reset to being completely set up and synched, takes about 20 minutes. (Including teh time for the OS and apps to instal)
EDIT - oh, and lots of apps dont need to be reinstalled if you plan on using them from the sd card.
Just create a link to the executable and many of them still work.
I hard code a quicklink to things like that into my quicklinks reg cab.

I really really really really really really want a quick easy way of restoring my email settings
And as most programs don't really need installing on each ROM change I wish it was easy to tell them to store Application data on the storage card and for Cookie's tab to automatically restore icons by saving them to the Storage card (as in, the actual icon files, not just the standard backup). CorePlayer, TomTom, AiReader and GRemote are examples of programs that don't really need reinstalling.

Demon_man said:
I dont simple, the only thing i have backed up is my memory card on the pc and contacts, calender in myphone that's it I like to change the settings differently on ROM's
Click to expand...
Click to collapse
ditti, currently doing same but if I found something to back up email config, facebook setting and a couple of others, it would be good

what i usually do is auto backup with NRGZ's systems export backup tool and xda uc. Also copy the progam files folder which the apps are installed on the phone and if you wantthe start menu folder in windows which has all the shortcuts etc (saves time doing it one by one).
All you have to do is just copy and past those 2 folders back in the correct places after you flash. Everythings back to how it was. Also use PIM for contacts and sms. Takes no longer than 5-10 mins to get it exactly how i want