Hi guys,
I noticed that many of my Contacts have the "Notes" section filled with crap while others are nice and clean as you can see in the attached screenshots.
Can you please identify the problem?
Is it possible to mass-clean Contact notes leaving the field empty?
What could be causing this issue?
NOTE: Back in the days of using WM I backed up my contacts with PIMBackup and then used the instructions found in the forum about transferring the backup to Android by unziping the *.pim file generated by PIMBackup.
Thank you in advance,
F
The <htcdata> ones tell sense which are your favs and Facebook links.
The ones with the hex type code I'm not sure, could be the contact image that has been imported / exported into the wrong field somewhere down the line?
i see.. so is this fixable? ..is there a way I can mass-edit the notes field and delete all the crap?
i dont have an automated way, but what id do is use excel.. export the contact list to csv or xls (from outlook, or gmail, most will do it) and open it in <insert generic spreadsheet app here>, again sort by the notes field and you can drag and multi select the affected cells and delete them.
samsamuel said:
i dont have an automated way, but what id do is use excel.. export the contact list to csv or xls (from outlook, or gmail, most will do it) and open it in <insert generic spreadsheet app here>, again sort by the notes field and you can drag and multi select the affected cells and delete them.
Click to expand...
Click to collapse
good idea I will try it!.. do you also have the same problem or you just do this to manage your notes contents?
EDIT: I cannot upload the edited .csv to Gmail... it sais error for some reason..
What I did was to Find and Replace "Notes Ink:*" with "Notes Ink: " since I could not sort the file by the Notes column... then Save csv then Import to Gmail => error...
EDIT2: editing seems to work properly with Google Documents ..lets see if syncing will now solve the problem!
EDIT3: Mr. samsamuel ...YOU ROCK
hehe, third times the charm.
can you tell me step by step how you did that ??
Jarrett76 said:
can you tell me step by step how you did that ??
Click to expand...
Click to collapse
1) Login to your Gmail account.
2) Go to Contacts and find the Export action
3) Choose Google.csv type and download to you laptop
4) Use Google Documents found in your Gmail panel somewhere and open the google.csv you just downloaded
5) Go to the "Notes" column and select the whole column just below the "Notes" header
6) Delete the column data
7) Save
8) Re-download to your PC
9) Go to Gmail contacts and this time Import. Browse to the edited csv file
Done
EDIT: credits to samsamuel
Related
Hi,
I have a Sony K750i and I want to import my contacts into my new phone, VPA 1605/Compact III.
The problem I face is that when I transfer from my contacts on my sim (using the VPA's built in sim manger) it creates the contacts as single entries into my contact list, for all the different classes of contacts. IE Mobile/Home/Office etc etc.
It lists my contacts as:
Mr XYZ/m
Mr XYZ/h
Mr XYZ/o
This is a pain and not much use to me.
I can however beam my contacts one by one using Infrared. It transfers the contact as a .vcf and retains the format. But that's real slow when you have lots of contacts.
I also tried bluetooth and could not transfer contacts from K750i>VPA, but could transfer contacts from VPA>K750i. hmmm? Weird! Is there a problem with bluetooth when transfering contacts?
Surely there must be a way of transfering my contacts into the VPA and keep the correct format?
Does anyone else have this problem?
What about a third party phone manager that sits on a PC and can transfer contacts?
I'm at a loss on this one.
TIA
Try Mobile Master Professional, www.mobile-master.com. It can sync the K750i with Outlook and then you can sync Outlook with your Pocket PC.
i copied all my contacts from k750i as vcf files (using fma phone manager software) then added all contacts into a zip file, sent zip file to tytn, unzipped file on tytn and saved to contacts.
that way you can get all of your contacts across in one go! simple!
hope it helps!
Thank You
Thank you for your help.
I can't find the Contacts folder on the VPA Phone.
Using the inbuilt file manager.
TIA
not sure about your phone, but on the tytn it asks if you want to save to contacts when you unzip...
Database
Hmm I get the picture..now! lol
But how do I get rid of the contacts I don't want that was created by the importing of the sim.
Apart from deleting them one at time.
I have found a couple of database editors, but can't find one for WM5
Grrrrrrrrr
EDIT - SOLUTION! :idea:
delete the pim.vol at the root and soft reset your phone. This creates a blank contacts database file. Pim.vol also stores your Appointments, so if you delete it you will loose those as well.
Hope this helps someone.
Thanks to all that helped. :lol:
bigshape said:
i copied all my contacts from k750i as vcf files (using fma phone manager software) then added all contacts into a zip file, sent zip file to tytn, unzipped file on tytn and saved to contacts.
that way you can get all of your contacts across in one go! simple!
hope it helps!
Click to expand...
Click to collapse
it need to click on every VCF file - in a case of hundrets of contacts this would be inconvenient.
but I have found solution to synchronize W800i / K750i / D750i into Windows Mobile on Pocket PC without using Outlook, little tricky but working:
1. export Phone Book with free software MyPhoneExplorer to one CSV file
2. change header (first line) of CSV from:
Code:
"Title","First name","Last name","Mobile","Home","Work","Fax","Other","Street","Postcode","City","State","Country","Info","E-mail","Web","Company","Birthday"
to
Code:
"Title","First name","Last name","Mobile Phone","Home Phone","Business Phone","Business Fax","Home Phone 2","Home Street","Home Postal Code","Home City","Home State","Home Country","Notes","E-mail Address","Web Page","Company","Birthday"
3. rename changed CSV file to: contacts_20081003.csc (date is unimportant, but you must retain format: contacts_RRRRMMDD.csc)
4. pack it with zero compression to ZIP format
5. change ZIP's extension to *.PIB
6. download free PIM Backup 2.8 http://forum.xda-developers.com/showthread.php?t=299705
7. run this PIM Backup from PDA, select "Restore" and select created *.pib file
8. in CSV import settings set "," as delimiter and additionaly map "Last name" to "Name"
should work
Doesn't work for me!
Hi,
I tried tester2's method on my HTC Touch diamond 2, it seems very logical but the HTC doen't seem to comply with it; I get a lot of posts with no names! So when I open any of the posts it has a phone number etc, but I cant get the name part to work. It seems the mapping doesnt work correctly althought i did map "Name" to "Last Name".
Any ideas?
Thanx, N/
Hi,
Not sure if anyone is having similar problems. So I use my sim card contacts on my tp2. But when it read its, its all under the "last name" in tp2, and nothing in the first name.
So in the sim card, name "michelle lulu" is one of the contacts.
When I plug into the tp2, it will only read "michelle lulu" as last name, and nothing on first name. Is there anything I can do on my end to sort this out ?
Thanks.
aichemist said:
Hi,
Not sure if anyone is having similar problems. So I use my sim card contacts on my tp2. But when it read its, its all under the "last name" in tp2, and nothing in the first name.
So in the sim card, name "michelle lulu" is one of the contacts.
When I plug into the tp2, it will only read "michelle lulu" as last name, and nothing on first name. Is there anything I can do on my end to sort this out ?
Thanks.
Click to expand...
Click to collapse
That happened to me when I first got my T-Mo TP2. I had to edit all of my contacts. It took a while, but it worked! Apparently, it wasn't smart enough to recognize first and last names.
If there's another (easier) solution, that would be great; I'll save that solution so I don't have to go through that crazy process again!
I didn't have this problem, but I thought I'd give my input on a potentially easier solution than manually editing the contacts on the device.
1. Get your contacts (with the messed up name format) saved on your PC Outlook via Activesync.
2. On your PC Outlook, export the contacts to a CSV file.
3. Edit the CSV file accordingly. If you're real hardcore, you can come up with a script to automate this part.
4. Remove all the contacts on your PC Outlook.
5. Import the edited CSV file.
6. Synchronize your with your device.
that sounds like a painful road that lies ahead....
ohyeahar said:
I didn't have this problem, but I thought I'd give my input on a potentially easier solution than manually editing the contacts on the device.
1. Get your contacts (with the messed up name format) saved on your PC Outlook via Activesync.
2. On your PC Outlook, export the contacts to a CSV file.
3. Edit the CSV file accordingly. If you're real hardcore, you can come up with a script to automate this part.
4. Remove all the contacts on your PC Outlook.
5. Import the edited CSV file.
6. Synchronize your with your device.
Click to expand...
Click to collapse
I actually had to do everything on Microsoft MyPhone, so it was easier since I was on a PC.
I don't know, but this seems complicated in some ways yet easy in other ways!
Hi all,
When I choose [people] then [Add favorite], in which map and file(s) does the HD2 put this stuff ? (XannyTech ROM V1.3)
It doesnt put it in a file, it adds meta data to the 'notes' field of that contact.
For example, if you have outlook on your PC, add someone as a favourite, then open their contact card on the PC and in teh notes field you will see something like
<HTCData><!-- Please do not modify -->
<Favorite>actionid:CallWork</Favorite>
</HTCData>
If that person is a favourite and also a facebook contact you will see
<HTCData><!-- Please do not modify -->
<Favorite>actionid:CallWork</Favorite>
<Facebook>id:#########/friendof:#########</Facebook>
</HTCData>
That is why favourites and facebook linked people persist after hard reset, so long as they are synced.
Thanks Sam !
So can I extract and restore this favorite data (incl. photo) from a stored SPB
backup ?
You dont even need to extract that data. So long as you have backed up the contact list, as soon as you restore it you should find the favourite people tabs automatically filled, and as soon as you connect the 'me' contact card with your facebook account, all your contacts that are linked to facebook contacts will get teh facebook contact image and access to the albums and such like.
Oh one thing I missed out, the favourites are added to a contact category of 'HTC favourite'
I'm not sure exactly how it knows which contact to put on which shortcut, but ive flashed new roms four or five times, with another two or three hard resets, and each time as soon as i sync outlook the people favourite shortcuts are there again.
OK fixed with 1 more little step for each favorite ..then all is allright !
Thanks !
i transferd all my contact from Outlok to Gmail and then with WIFI sinc them to my XPERIA X10
now i see them in my phonebook like that : FMILY, NAME
i want it to show them in the good way-like that: Name, Family NAME
how can i do that ??
amir84 said:
i transferd all my contact from Outlok to Gmail and then with WIFI sinc them to my XPERIA X10
now i see them in my phonebook like that : FMILY, NAME
i want it to show them in the good way-like that: Name, Family NAME
how can i do that ??
Click to expand...
Click to collapse
Nothing to do with the phone, its how Outlook managed your contacts. Go to Google contacts online and swap them all round.
What I had to do, needed to sort my contacts out anyway
so i have to fix every name and name??
isnt there anyway to fix it once to all conatcts ?
I guess you can export all contacts from outlook to an csv file, open the csv file in excel or openoffice calc and shift the columns for firstname, and lastname.
how can i do that?
and after ill export to CSV - whats than? im not that good in exel..
I have no idea about excel either but you have two choices most likely:
1. Just drag and drop the column(s) ...
2. Play with cut/paste after you select the entire column
Damn. In fact, I want to do it the other way round.
Fimaly name, then first name.
When I imported my contacts, I got first name before fimaly name
If you are like me, you like using contacts stored locally on the phone.
Also, you don't like your gmail contacts (contacts automatically added to your useless contacts list on your gmail account).
I have 120 contacts on my previous phone, and about 700 useless contacts on my gmail account.
When I started using android, it synced all the contacts and I ended up with 800+ making my life hell, and my phone slow.
So I found a way to get rid of all the damn stupid contacts, Goes like this :
Backup ALL your contacts for your phone to a vcf file
Copy that file to your PC
Open your gmail account, delete ALL the contacts you don't need - I just deleted ALL my contacts.
Open your phone, delete ALL the contacts.
Using the script below, and activestate TCL, clean your script. It will only leave contacts with phone numbers.
Copy the new vcf file to your phone, import, job done.
The script requires :
Copy the pasted code into a file, save it with .tcl extension.
Activestate tcl installed, OR, tclsh tclkit executable in your PATH.
Then, you put the script and your vcf source file renamed as in.vcf in the same folder
Run the script in CMD, "tclsh <scriptName>"
You get a new file named out.vcf
Code:
proc exportContact {} {
global contact fout counter
if {[string match *TEL* $contact]} {
puts $fout BEGIN:VCARD\n$contact\nEND:VCARD
incr counter
puts "Copied"
} else {
puts "Skipped"
}
set contact ""
}
puts "Welcome, Lets get rid of contacts without phone numbers!\n"
if {![file exist in.vcf]} {puts "Error - Cannot find file in.vcf,\nplease put it in the same folder as this script and try again.\n\nPress Enter to exit";gets stdin;exit}
set counter 0
set fout [open out.vcf w+]
set contact ""
set fin [open in.vcf r]
while {![eof $fin]} {
set line [gets $fin]
if {[string match "FN:*" $line]} {puts -nonewline "Inspecting $line...";flush stdout}
if {$line eq "BEGIN:VCARD"} {
continue
}
if {$line eq "END:VCARD"} {
exportContact
continue
}
append contact $line\n
}
close $fout
close $fin
puts "\nCopied $counter contacts with phone numbers to out.vcf,\nimport that file on your android phone.\n\nPress Enter to exit."
gets stdin
Is it so easy???
vCard format is ASCII
None ASCII chars are base64 encoded, so it's stull ASCII which makes this very easy to parse
The script can be written with ANY scripting / programming language it's very very easy, I just like TCL, and is my favorite for scripting.
There's a much easier and cleaner way to achieve what you want:
1. Go to settings/accounts and stop syncing contacts on your main Gmail account (the one you are using for email)
2. Create a second new account on Gmail and import your contacts.vcf
3. Back on your phone add this account and enable syncing contacts
4. Never use this new Gmail account for any email so your contacts list stays clean
Hope this helps
Sent from my GT-I9000 using XDA App
Thanks for the idea,
But still - I'd had to manually add my contacts to this account cause importing the vcf file would add all the junk i was trying to get rid of.
Or you can simply disable the listing of contacts that do not have a phone number associated with them..
Danzig666 said:
Or you can simply disable the listing of contacts that do not have a phone number associated with them..
Click to expand...
Click to collapse
That doesn't solve the speed problem, cause the contacts are still there.
That was the method i used before i found out it slowing down my phone.
Thanks for the guide, was easy to follow and saved me some grief!
All I did was removed all gmail contracts from gmail webbased and re-sync'ed contacts on my phone, phone is now clean
Thanks
invalid command name "tclsh"
Do I miss something? I am using x64 windows and 64bit tclkit.
Contact Display Options.
zhihao said:
invalid command name "tclsh"
Do I miss something? I am using x64 windows and 64bit tclkit.
Click to expand...
Click to collapse
Hi,
Use contacts display option( Click on physical menu buttion after opening contacts app) and customize your view. Just check the contacts folders you want to view.
Create a folder in Gmail contacts page and map all phone contacts to it.
No need to do delete and other stuff, you can manage their very easily.
Regards,
Praveen.
zhihao said:
invalid command name "tclsh"
Do I miss something? I am using x64 windows and 64bit tclkit.
Click to expand...
Click to collapse
Tclkit doesn't contains the executable tclsh, and so you are getting an error.
If you decided to use tclkit, you need to use "tclkit.exe <script-name>"
Praveen_1221 said:
Hi,
Use contacts display option( Click on physical menu buttion after opening contacts app) and customize your view. Just check the contacts folders you want to view.
Create a folder in Gmail contacts page and map all phone contacts to it.
No need to do delete and other stuff, you can manage their very easily.
Regards,
Praveen.
Click to expand...
Click to collapse
When I wrote this I was using Galaxy S,
The option for not showing contacts without numbers didn't help in regards of performance.
This is a great idea..much better than manually deleting 300 contacts from your phone...