Database Users

Import contacts

Hi to all,
I've a set of contact (with address, phone number, etc..) extracted from my previous phone (Siemens SL45), saved in XML and CSV format.
Does anyone knows some way or some tool to import it in the Windows Mobile contact automatically?
Thank you

umm.. look for contacts backup on here ..it will allow u to import csv files

thank you, I've tried the dotfred's PPCBckpContacts, is a good tool, but don't worked for me, because the file I've saved from my previous Siemens are in csv format, but with different fields.
The head of my csv is precisely:
No;Name;Phone;Company;Street;City;Zip;Country;Work;Cell;Fax;E-mail;Url;Categories;Other
that is quite different from the format saved of the PPCBckpContacts, so when I try to restore it the program says that is in an unrecognized format.
There's some way to make them compatible without editing by hand all my csv file?
Thank you

no thats the wrong program man.. look for "contacts backup"..

unsuccessful PIM transfer

I made a critical error by not having a PIM backup for all my non-SIM contacts. What I did do was make a copy of the PIM file before hard resetting my device, and this file has 584 kB. I don't know in terms of PIM files whether 584 kB is a sizable or a small file, but I do know that my contact list was not small.
When I tried to install this PIM backup on to my Advantage 7501 it didn't seem to do much of anything. It appears that all I have on my contact list are contacts that I happened to write to SIM.
Does anyone have any ideas? Is there an application which can read what are apparently Outlook contacts which were stored in the PIM file? I do not own Outlook.
Many thanks,
bagua

Try opening the file with wordpad but create a copy of it fist, just in case....If you can create a csv file of it, I think most PIM software ought to import it.

Unsuccessful PIM transfer
I did make several copies of the file, but when I opened it up in WordPad, although I could see some numbers, along with lots of scrawl, it doesn't appear that all of my numbers are there!
Occasionally people do stupid things, and this was one of my occasions!
bagua

[Q] .pib to .csv file conversion

hi all,
I had a SE Xperia X1 running on WM 6.5 and i backed up all my contacts using PIM backup for windows mobile. the back up file is saved on my storage card as a .pib format. I have however been understood that the only way i can transfer these contacts and texts to my new motorola milestone 2 running Android 2.2 is by the means of a .csv file.
Is there any way that i can convert this .pib file format to a .csv file format? i would appreciate any help out there as i am new to the Android OS.
Thank you

Rename PIB to ZIP. Open it and unpack file. That file (CSV) would be import to Google Contact (GMail). After that you may to synchronize your mobile with GMail and all your contact will be shown in Android phone.

FileFixer said:
Rename PIB to ZIP. Open it and unpack file. That file (CSV) would be import to Google Contact (GMail). After that you may to synchronize your mobile with GMail and all your contact will be shown in Android phone.
Click to expand...
Click to collapse
thanks so much. juz a small doubt....when u say import to google contact, how about do i do it. and will my text messages be backed up as well?
thanks very much

You must to login on Gmail from your computer (www.gmail.com) and go to your contact tab. In this contact tab you have a option for import CSV file. Import it to your Gmail account, edit contact if you wish then logout from Gmail.
Then synchronize contacts from your mobile phone with Gmail. After that, all your contact will be see on your mobile phone.
Only contacts will be backup. SMS is not possible for backup.
Hint:
In PIM Backup you must set backup only Contacts without any Binary or Compressed option.

Copy contacts from WinMob to Android?

I just installed Android Gingerbread (SD-card) and now I want to copy all my contacts from Windows Mobile 6.5 to Android. Is there an easy way to do this )if any)?
Hope you understand my question and thanks for answering!

If you use Outlook you can extract the contacts data base as I think a. Vcf and then load it into your gmail account then sync your phone with gmail
Sent from my HTC HD2 using Tapatalk

If you have your contacts in out look try this http://sourceforge.net/projects/googlesyncmod/files/
Sent from my HTC HD2 using Tapatalk

many ways to accomplish this...
first, back up your contacts (and anything else you fancy) using "pimbackup" on windows mobile. if any of the following options goes wrong, simply restore using the back up you just made with pimbackup.
now, ONE of the following options should work:
1. on windows mobile, set up an activesync with google's servers. once the activesync is established, your contacts SHOULD automatically upload to google's servers. this is useful because you are migrating to android, which is tightly integrated with your google account. when you will finish setting up your android with your google account, your contacts will download automatically in a few minutes...and you're done!
2. on windows mobile, use "sprite migrate". this nifty little tool will extract your contacts and sms messages into a file on your sd card. then, transfer the file to your desktop/laptop. on the PC, install the PC component of sprite migrate and feed it the file you just threw from your sd card. tell it to prepare a file for android. this will spit out another file which you can copy back on to your sd card. inside android, install the android component of sprite migrate and import the file you created on your PC. done!
3. use the outlook related options as suggested by others above if you are already integrated with outlook!

Easiest way is to just save your address book to your SIM card then import in Android

Easiest way is enable Google Sync on WinMo 6.5, google for instructions on how to...
It will copy contacts automatically to your google account and sync them back as soon as you link your google account with Android..

Mafioso said:
Easiest way is enable Google Sync on WinMo 6.5, google for instructions on how to...
It will copy contacts automatically to your google account and sync them back as soon as you link your google account with Android..
Click to expand...
Click to collapse
I agree, this is the easiest way.
Just synchronize with google account.

w/o Gmail
If you no matter what do not want to rely on Google/Gmail services (for obvious privacy reasons):
Several users mentioned sprite migrate, but unfortunately the software's been discontinued since Oct/2011.
OTOH you can export your contacts:
using the built-in Outlook export. It gets quickly tedious I'm told because you have to process them individually (bleh). This creates a vCard file for each contact.
export using PIMbackup. The procedure is documented about everywhere on the forums, just use search. Important is to UNCHECK compression (and of course, check the "contacts" box earlier on). The resulting pib file is actually a renamed ZIP archive, you can open it with 7-zip regardless of its extension.
I'll assume you know how to transfer files in and out from your SD card.
Now within the pib/zip file, there's a .csc file, which is a comma-separated value "spreadsheet". Extract it from the archive.
You will now export (demux) this .csc into multiple .vcf (vCard) files.
The tool I found is http://homebrew.binaervarianz.de/in...ts-and-SMS-from-WindowsMobile-to-Android.html
Extract "PIM2vcard.pl" from the "PIM2vcard.tar.gz" archive into the same directory as before.
It uses Perl (a general-purpose scripting language) to achieve this. I recommend using Strawberry Perl for its simplicty of installation.
Fire it up using the "portableshell.bat" shortcut.
Then, enter the commands (replace with your own values):
Code:
CD /D "C:\EXTRACT\htc"
notepad contacts_20120418.csc
In notepad, click "File > Save As...". In the dialog, leave the default filename (contacts_20120418.csc.txt) and navigate to your working directory using the treeview on the left. In the Encoding drop-down box, select "UTF-8". Click Save, then quit Notepad.
Back to the Perl command prompt, enter these commands:
Code:
MKDIR vcf
perl PIM2vcard.pl contacts_20120418.csc.txt
When the script ends, you shall find the resulting files in the vcf subdirectory.
Copy them into your SD card / internal storage.
Finally, use the Contacts applet in Android to import the vcf files.
There are known issues:
1. Problems if you have contacts with non Latin chars [use encode_qp?]
2. Problems with multiline fields (such as home address) [fix CSV beforehand]
Note: Maybe some benevolent soul can whip up an excel macro or a website to perform all steps automatically?
Another alternative is importing the csv (*.csm.txt) into Windows Live Mail (mapping fields, which is a boring task) and then export to .vcf.
These features are available from the Import/Export ribbon toolbar buttons.
Also, the import process sometimes silently chokes, so it's not such a reliable solution either.
For migrating your SMS messages, I recommend the dedicated PimBackup SMS Importer to Android application by -emandt-.
An interesting alternative is http://piemaster.net/tools/winmo-android-sms-converter/ (Python 2.x, open-source). It seems to take the .pib in and churn out a fat .xml containing SMS's and importable into SMS Backup & Restore. However, I haven't tested it.
Edit: checked it out, it doesn't seem to process contacts.

ActiveSync with Gmail
GregoRA0 said:
I agree, this is the easiest way.
Just synchronize with google account.
Click to expand...
Click to collapse
What to do if you already have an activesync connection with Outlook? It says you have to disengage that connection first and then sync this new (google) account. Problem is, once you uncheck it, it says it's gonna remove all contacts imported from Outlook!

Have a look at second program "Contact Backup CSV Import" HERE
Also do a search for PIM Backup as has some info in that thread on transferring contacts & sms ...

[GUIDE] Extract and Restore Contacts, SMS, Call logs from nandroid backups(TWRP)

So yesterday My phone, Sony Xperia S, decided to go into bootloop and not boot at all, no matter what I did. Tried flashing stock PRF, stock firmware, some stock based firmware, but it would get stuck in bootloop. The reason for this being I was not formatting the data partition, which I needed to preserve since it had all My sms, contacts, call logs and other app data. Luckily, I had a working recovery(TWRP) and was able to take a backup. Then using that I was able to recover My contacts, sms, call logs and app data. After a lot of Google searches, I was finally able to work it out. The process is as follows:
Needed software:
Code:
yaffs-mmssmsdb-calls-extractor.zip from [URL="http://forum.xda-developers.com/showthread.php?t=1585957"]here[/URL].
Firefox Browser
Firefox addon of SQLite manager : [URL="https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager"]link[/URL].
Excel macro to convert .db contacts to .csv : [URL="http://thydzik.com/downloads/convert-contacts2.db-data-to-vcard-vcf.xlsm"]link[/URL].
Software for csv to vcard conversion (Windows) : [URL="http://www.csvtovcard.com/"]link[/URL].
CSV to vcard conversion (online) : [URL="http://labs.brotherli.ch/vcfconvert/"]link[/URL].
SMS Backup & Restore android app : [URL="https://play.google.com/store/apps/details?id=com.riteshsahu.SMSBackupRestore"]link[/URL].
Call Log Backup and Restore app : [URL="https://play.google.com/store/apps/details?id=com.riteshsahu.CallLogBackupRestore"]link[/URL].
The procedure is a lot crude as of yet, I would update as more universal and convenient options are found.
I know there is Titanium backup app which can restore contact, sms etc from nandroid backups, but You need a paid version of the app.
First we need to extract the data partition of nandroid
Rename the data.ext4.win to data.ext4.tar.gz . If Your files are like data.ext4.win000, data.ext4.win001, then rename each of them to data.ext4.tar.gz in separate folders.
On windows, now You can directly extract them using WinRaR or 7zip application, although You don’t need to extract it entirely.
On linux, You can do so using the following command. It is recommended to store the file in a separate folder as the file gets extracted directly.
Code:
tar –xf data.ext4.tar.gz
Now we need to find two files contacts2.db and mmssms.db . The contacts2.db files is for contacts as well as the call logs and the mmssms.db is for messages. The contacts2.db is constant across most ROM’s and OEM firmware apps. The mmssms.db file may vary as per app and ROM’s. So what You need to do is look for a .db file inside the SMS app You have been using with the firmware/ROM.
We will restore the SMS and Call logs first.
Currently it is limited to Windows OS only.
Extract the contents of yaffs-mmssmsdb-calls-extractor.zip to a folder.
Copy the mmssms.db file and contacts2.db file to the above folder.
Now open a command prompt at location of the above folder. This can be done by opening the folder, right clicking using shift key pressed in blank space. You get the “Open command window here” option.
In it type:
Code:
extract -s mmssms.db
It will ask You to enter a name for the output .xml file, You can press enter to let it give a default name. This will convert Your sms to a .xml file .
Then type:
Code:
extract –c contacts2.db
It will also ask You to enter a name for the output .xml file, You can press enter to let it give a default name. This will convert Your call logs to a .xml file .
Copy both of these files to Your newly formatted phone and then use the two before mentioned apps (Call Log backup& Restore and SMS Backup & Restore) to restore Your SMS and call logs.
Now retrieving contacts. It is a bit lengthy, but simple process.
Start firefox browser. In it, after You have installed the addon do following to enable the addon
Go to options (3 horizontal lines).
Select “Customize” and drag the “SQLite Manager” to the blue bordered box.
Now open options and select SQLite Manager. In it select Database>Connect Database. In the opened dialog box, select All Files(*.*). Then select Your contacts2.db .
From the left side tree structure in the SQLite Manager window, right click on “data” and select “Export Table”.
Now in right side part of the window, You will get CSV tab and SQL tab. Under CSV tab, simply press OK button without changing any other options.
It will ask You to save Your .csv file. Save it.
Now if You try to open this file directly, You will notice that file is not properly arranged.
To arrange it properly, open the convert-contacts2.db-data-to-vcard-vcf.xlsm file. If You don’t know how to enable Macros, then do the following:
It will show You a warning “Security Warning Macros have been disabled. Options..”
Press the Options button. Select “Enable this content” and press ok.
Now Press the office button present at left top corner. In it select “Excel Options”.
Select Customize tab from left side. Then from “Choose commands from:” drop down menu, select Macros.
Now add convertDatatoContacts and writeContactstovCard to right pane from left pane by selecting them and pressing add. Press OK button.
Now as You can see two white square icons have been added at top right corner next to save undo redo options.
Select the first white square icon. Select “Enable Macros” button. Now select Your .csv file in the opened dialog box.
Now the file must have opened in a separate excel. The format should be 4 rows with they being First Name, Last Name, Phone 1 and Phone 2.
Then select Save As>Excel Workbook>Save Type as CSV(Comma delimited).csv . Press ok and yes on the two warnings generated.
At the left bottom, right click on “contacts” sheet and press delete. Save and close the file.
Run CSV to vCard software and open the above saved .csv file. Here You can save all contacts as single vCard file or separate files.
In the “Properties” section on the window, in front of “Phone 1” and “Phone 2” select “Mobile Phone” from options. Press “Convert” button.
Alternative to above two steps, You can also convert .csv to vcard using the website.
Now a .vcf file will be created where the .csv file was stored.
Now simply copy the .vcf file to phone and import using the phone contacts app!
Done!
Credits and sources:
@abbot2
[TOOL] yaffs extractor, mmssms.db & contacts2.db converter
http://thydzik.com/export-android-contacts-contacts2-db-to-vcard-vcf-on-windows/

Reserved.

This is complicated, but youre great mate...
Sent from my C6903 using Tapatalk

odie70 said:
This is complicated, but youre great mate...
Sent from my C6903 using Tapatalk
Click to expand...
Click to collapse
Ah yes, it's a lot complicated, but the need of recovering data was a lot important too!

Praise to you for saving me !
And if I may, I'd like to state my experience, which brings a few interesting facts into light:
1/ I was unable to open my tar.gz archives with 7-zip v9.20. It kept displaying an error message. Only the v15.14 version could handle them flawlessly.
2/ as a textra user, I discovered that it stores a duplicate sms database, which IS NOT compatible with yaffs-mmssmsdb-calls-extractor (which screams a message about a "missing sms table" or something) (praise to the author as well)
BUT, the system sms database can be found here, and is fully handled by the extractor tool:
data\data\com.android.providers.telephony\databases\mmssms.db
Now my sms are back and I can resume my thread about the best knitting techniques.
Thanks again

Add this cool service Online converter contacts2.db to vCard

OP - you're a deadset legend.

This is damn useful! :good:
Even if I do not need it right now but it is very good to know that there is a way.

Hello @Mirhawk, I am having this error when running the macro. What could be the issue?
http://i.imgur.com/baUmFci.png

Thanks for this. I wanted to comment to help others using Microsoft Office 2016 & now that Firefox Quantum has made old extensions incompatible. Call logs & SMS are easily imported by Nandroid Manager app (god bless the dev). This a short summary of steps to restore contacts, presuming you have the contacts2.db file extracted:
- Install Firefox 39 from here. Might work with FF 57, but did not want to take chances.
- Download the Excel Macro [which will help us later correctly arrange our data via pre-set changes, aka macros, on the Excel spreadsheet][see link above]
- Install & enable the SQLite extension in Firefox (already linked above by OP)
- Follow OP's steps until you obtain the .csv file
- Open the macro file you had downloaded earlier & click enable the content
- In Excel 2016, you need to add Developer Tab to your top menu: Go to File -> Options -> Customize Ribbon -> Check mark Developer option on the right side column. Click OK.
- Now we need to run the macros: Click on Developer Tab at the top -> Macros -> Run the first macro: convertDatatoContacts
- Select the .csv file & proceed
- Now run the second macro: writeContactstovCard
- Vcard (.vcf) is saved to same folder as your original macro file.
In Nougat, Contacts app can open and import .vcf file or you can use third-party app.

Great tutorial, thank you very much! This saved 6000 SMS when Titanium Backup had messed up. ??

Thank you very much! With your guide I could recover my SMS from a phone with a bootloop (TWRP bootable) but I did a different process:
1. TWRP Backup
2. Transfer it to PC
3. Rename the data.ext4.win to data.ext4.tar.gz . If Your files are like data.ext4.win000, data.ext4.win001, then rename each of them to data.ext4.tar.gz in separate folders.
4. Open each file in BandiZip program and search for mmssms.db
In my case it was in: data/user_de/0/com.android.providers.telephony/databases/
5. Copy this file to the same folder in spare phone / same phone after factory reset.
6. SMS appear now!

mmssms.db not found
I guess since Android 5+ mmssms.db is deprecated, refer https://forum.xda-developers.com/showpost.php?p=74784136&postcount=3 to extract sms to xml file

owzm tutorial
tks for A DETIALED TUTORIAL
try this forum for retrive contacts ,given a easy method by "StefanPutureanu"
https://forums.androidcentral.com/ask-question/459773-how-do-i-retrieve-my-contacts-twrp-backup.html

Thanks for valuable infomation.I'd like to share my experience that I have use Android recovery program to extract and recover sms,contacts,call logs from backup files.It has powerful method and the operation is easy.

my samsung s9+ deleted all my contacts, slowly like 20 a month lol, no idea why, ****ty sammy soft and auto sync deleted em from sammy cloud too...
i had problems even extracting contacts2.db /Failed to extract calls: no such table: calls/
so i found a better way: just convert your contacts2.db right into vcf here: http://gsmrecovery.ru/db2vc/index.php?lang=en
all my contacts are back

Mirhawk said:
Reserved.
Click to expand...
Click to collapse
Any way to get attachments on SMS back ?
Cause i get all my sms back, but no more pics