Database Users

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!

Backup AND RESTORE SMS messages?

Hello,
I've searched the board several times since months and haven't found a solution to my problem yet.
My problem is as follows:
I have my Wizard (O2 Germany, so Xda mini S) since february (in fact it is the third one, O2 support changed it two times because the stylus didn't lock anymore after few weeks of use... have to change it again...).
And few months ago, I tried Sprite Backup, what I am using since then. Although it worked well, one thing is annoying: sometimes after hard reset and restore of only my mail database (cemail.vol, the only thing I really need to be backed up), the Messaging app doesn't show mail accounts anymore, but when I try to create new ones with the same names, it says, that the accounts already exist. So I created new accounts with different names, as many other users did, how I could read here. They co-exist and take memory.
Interesting thing: the Spb Diary messaging program can see the old accounts, and so it is also possible to delete the messages, that are still there in the old accounts. It can take a long time and many clicks (taps), because you can delete only one message at once, but it is better than nothing. One problem persists: Spb Diary can't delete the accounts themselves.
Therefore I am searching for a way to extract only my SMS messages (eMail is not important, I have it all on PC), start with an empty mail database (hard reset) and restore only the SMS messages into that new database.
The only program I have found so far, that really looked well for the first moment, is Jeyo Mobile Extender (or Companion). It backups the SMS Messages to PC, but not all of them. Messages in subfolders are ignored (I have subfolders for delivery notifications, call missed notifications and so on). And the restore doesn't work as expected. The date of the messages gets messed up, long messages (>160 charactes) get cut, and even the sender/receiver of the messages can get flipped.
But it must be possible to write a program, that fits my needs, I think (by the way: what is going on with the developers of WM2005? Backing up messages from mobile device to desktop is ESSENTIAL!!! Why isn't such a feature included?).
And because I am sure that I am not the only one with this problems hoping for a solution, I could imagine that someone already has written such a tool.
So, please, if anyone knows a tool or a different solution (editing mail database, removing everything except SMS messages...), PLEASE, help me!
Thank you very much in advance!

Yeaa im also really looking for a soultion to this, i Recently got a Windows Mobile device and i really wanna just be able to transfer my Series 60 Messages in Text format now.. to my Pocket PC's Messaging.

I can't believe nobody has made an app to backup and restore SMS's despite the growing number of people who need just sucha an app.
Except for Kai's, I don't think there is anything out there that does the job.
I hope SPB includes an option in the future to backup specific accounts only, because it is by far the best messaging backup app I have used till date.

leepriestenator said:
I can't believe nobody has made an app to backup and restore SMS's despite the growing number of people who need just sucha an app.
Except for Kai's, I don't think there is anything out there that does the job.
I hope SPB includes an option in the future to backup specific accounts only, because it is by far the best messaging backup app I have used till date.
Click to expand...
Click to collapse
jeyo has. works fine

jeyo is crappy piece of ****. better than nothing, but doesn't back up all messages, no self-created subfolders, no dupe-check, shows error message on ppc on every connect...
you will find out, when it is most important to you, believe me!

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

Export / Backup of Contacts: HTC P3300

Apart from using ActiveSync, is there any way to export the contacts stored on the phone to a PC? I was thinking if there might be a database file that can just be copied out with help of Windows explorer and back again after the phone has been reinstalled / upgraded.
Since I work as an IT Support for a large firm (that owns tons of these P3300's); it'd be great to do this as simple as possible and not mess up my own Address books...
Thanks a lot for your attention!

Try PPC Pim Backup, you can get it from here and its free.
http://forum.xda-developers.com/showthread.php?t=299705
BTW maybe mobile justice is also an nice app for you, Its some kind of theft protection with GPS support

Soololi, you're my saviour! Thanks a bunch for your help
That PIM Backup was exactly what I was looking for..

software to sync SMS between Android and WM?

Hi all,
My decision to start migrating from WM to Android turned up to be be quite a headache. And here is one of the problems.
For next year I intend to use Hero and HD2 at the same time and I will need to have them synchronized. Main issue is to have synced SMS - I have tried and looked for different options but ended up with nothing.
Ways it could have been implemented:
1. Desktop PC software that allows you to sync both Android and WM devices, including SMS.
2. Something like Sprite Migrate, but software that works both ways.
3. Something like My Phone service by MS but works on all platforms
4. Software that will export txts in some common standard like xml. I tried to export with SMS Backup & Restore and to restore it to WM with Jeyo Mobile Companion but formats are different
5. Others: backing up to SIM, trying to use backup created on Android with Sprite Backup on WM, forwarding sms via bluetooth, etc....
So as you can see, I have tried many options but was was unsuccessful. Any other ideas how to transfer sms from WM to Android?

I think you can save your SMS on your SIM card, but idk if android can read them out of the box.

Sync to IMAP and Gmail
Have you tried syncing to IMAP? I use MobiTnT (SMS Mobile Archiver would also work I think) that syncs to Outlook a folder. This folder can be transferred to G-mail, perhaps even automatically. To synk between Android and Gmail, you have the android sms project: http://code.google.com/p/android-sms/wiki/UserGuide

SMS Migrator
- First, down load http: // wince.nasenbaeren.net / smsimport/ to export SMS from WM then copy it into your SDCARD on Android Phone
- Then go to Android Market to download "SMS Migrator"
See more here: http: // a.baole.org/ sms-migrator
Sorry I can not post URL as I'm a new member
Browncoat said:
Hi all,
My decision to start migrating from WM to Android turned up to be be quite a headache. And here is one of the problems.
For next year I intend to use Hero and HD2 at the same time and I will need to have them synchronized. Main issue is to have synced SMS - I have tried and looked for different options but ended up with nothing.
Ways it could have been implemented:
1. Desktop PC software that allows you to sync both Android and WM devices, including SMS.
2. Something like Sprite Migrate, but software that works both ways.
3. Something like My Phone service by MS but works on all platforms
4. Software that will export txts in some common standard like xml. I tried to export with SMS Backup & Restore and to restore it to WM with Jeyo Mobile Companion but formats are different
5. Others: backing up to SIM, trying to use backup created on Android with Sprite Backup on WM, forwarding sms via bluetooth, etc....
So as you can see, I have tried many options but was was unsuccessful. Any other ideas how to transfer sms from WM to Android?
Click to expand...
Click to collapse

Does SMS migrator, give you the option to merge sms? I got 2k+ on my old WM phone and 300+ on my Eris. I know Sprite Migrate was working on this feature, but I don't think they added it yet.

sorry for the late reply, but i switched from wm to android and transferring sms messages from one platform to another was something i wanted to do also.
*note* ive onlly transferred from wm6.1 to android
1. i went to this site (google "import/export move sms") [i cant post links 'cus im still new] and installed SMS Exporter.
2. exported to mmc/harddrive..
3. installed sms backup and restore from android market
4. moved the exported .xml file to the sms backup app folder
5. imported.
hope this helps.

tbaker077 said:
Does SMS migrator, give you the option to merge sms? I got 2k+ on my old WM phone and 300+ on my Eris. I know Sprite Migrate was working on this feature, but I don't think they added it yet.
Click to expand...
Click to collapse
No, SMS Migrator imports sms and automatically creates sms thread for you.

suggestion: use Google Voice. It's awesome, and would allow you to sync stuff

Well. I just used the SPRITE stuff and it worked. The SMS is a little different cause Android uses threaded SMS. You you think not all of the messages are there, but they are. I didn't see any sorting it in maybe except for the subject.
Migrating contacts worked too. But SPRITE says it will wipe old data, but it doesn't. That means I have double contacts.
The WM app starts going nuts when you view the log. You have to reset the device to continue.But this is after the data is stored in a safe place on your WM device.
It doesn't do appointments. Maybe for that I have to use the .pib of Pimbackup the extract to .cvs and read it.
But the software is in beta. At least I converted it.

Found this topic. But I'm gonna work on something myself. I'm gonna try to extract the SMS to a CSV on WinMo. Write a simpel script to create an XML. And that XML I'm gonna import on Android.

kekkle said:
Found this topic. But I'm gonna work on something myself. I'm gonna try to extract the SMS to a CSV on WinMo. Write a simpel script to create an XML. And that XML I'm gonna import on Android.
Click to expand...
Click to collapse
Did you ever write something? I now have a few SMS on the Android side of my HD2 which I would like to sync with the Windows side.
With more and more Android builds coming out for the HD2 I would think an app to sync between the two would be awesome.

I cannot agree more with the previous user. Any ideas on how to sync sms between android and wm???
mb said:
Did you ever write something? I now have a few SMS on the Android side of my HD2 which I would like to sync with the Windows side.
With more and more Android builds coming out for the HD2 I would think an app to sync between the two would be awesome.
Click to expand...
Click to collapse