1. Are you ready for the Galaxy S20? Here is everything we know so far!

Import contacts has added dashes?

Discussion in 'Android Devices' started by nemo1966, Aug 4, 2010.

  1. nemo1966

    nemo1966 Newbie
    Thread Starter

    Saved my contacts before a reset (don't ask) :mad:

    Anyway when I imported them back into the phone it added dashes to the numbers:

    From: 07999333666 to 079-993-33666

    Ok so whats the problem? I hear you saying, well in the UK nation code are usually 4 digits (sometimes 5). This makes reading the numbers really ANNOYING.

    Any know how to get rid of them - without having to go through every number?


    1. Download the Forums for Android™ app!


  2. Mine did the same, but it doesn't affect calls or text messages, I think the desire just ignores the "-".
    I'm not sure if it did it when I sync'ed from google also, which means that when you change them, if you have to reset your phone the problem will just re-appear.
    I am sure that if there isn't a way to do it yet the kind android developers of the world will write a app which does it for you, but I guess that takes time.
  3. JohnnyBravo1000

    JohnnyBravo1000 Android Expert

  4. andybog

    andybog Guest

    wicked! thanks for the app pointer, was annoying me. After a htc sync my contacts some how dissappered!
  5. SiHa

    SiHa Android Enthusiast

    Thanks for that!

    Bloody annoying, the way the yanks just assume that everyone else in the world want to format stuff the same as their arse-about-face ways.
  6. SUroot

    SUroot Extreme Android User

    bit more long winded, but if you're with the bank santander and get charged .89 for the app and 1.25 for the overseas transaction fee, simply on your PC, export all your gmail contacts to csv and do a find and replace on "-" then import them back. deleting all gmail and clearing cache on contacts storage. Yes it takes 2 1/2 minutes, but if you have already paid god knows what for Microsoft office (Excel) why pay more for an app to do what you've already paid for 100 times over?

    Or Sun Open Office for free has the same functionality as Excel.

    Normally I like to support apps, but 3 of this guys 5 posts are selling this app. I just want all to know you can do this yourself for free with a sli9ght bit of effort. But pay for an app if you want to, it will be quicker and easier.
  7. SUroot

    SUroot Extreme Android User

    Im not talking about vcards. csv (i.e comma separated values), on your computer.
  8. Kelmar

    Kelmar Done by choice

    Legit or not, the guy pushing the app had multiple accounts on the forum all with the sole purpose of pushing the sale of that app.

    Proceed with caution... he will not be back to the site.
    SiHa, Howard Hopkinson and SUroot like this.
  9. Howard Hopkinson

    Howard Hopkinson Android Enthusiast

    Perhaps you could delete the quote in post #3 with the link?
  10. andybog

    andybog Guest

    There is a free version of the app which i tried and it didn't work!

    All my contacts are stored under 'phone'. how can i get them to 'gmail' in order to export and edit on pc?
  11. SUroot

    SUroot Extreme Android User

    You can export to SD via the people / contacts app. When you import them back, you can add them as google contacts. Then you can export in gmail on the PC, once sync'd up.
  12. SiHa

    SiHa Android Enthusiast

    Well, I only got the free version, which just parses the files on the SD. I too would go the Excel route otherwise.
  13. andybog

    andybog Guest

    I have tried the excel version and that didnt seem to work for me. I even tried exporting to sd card (backup), attaching phone to pc in mass storage and editing the contacts backup file using notepad with replace.

    When i then import the newly edited file all the '-' are put back in. :mad:

    Should i have cleared data from contacts storage or was it ok to just delete all contacts prior to importing?
  14. SUroot

    SUroot Extreme Android User

    The SD card method doesnt work as it puts them back.

    You need to export to excel from gmail
    delete the contacts in gmail
    clear contacts storage
    reimport to gmail once edited

    What exactly didnt work in excel?
  15. andybog

    andybog Guest

    I was able to find and replace the '-'. As all numbers in UK start with a zero, when i did remove all the '-' the leading zero in the number disapperared so i set cell format to 'text' in order to have the leading zero again.

    When i selected save in excel it said something about certain features may not be saved. I saved anyway and reimported to google contacts via pc and then synced on phone but the dashes reapeared....i will just add that i didnt clear contacts storage data before the re-import, i just deleted contacts from phone.
  16. SUroot

    SUroot Extreme Android User

    Its probably just the contacts storage then. Check they're not present in gmail itself. Then if not, clear the storage and resync.
  17. andybog

    andybog Guest

    Thanks SUroot. Got it all sorted now.

    I exported my contacts from 'phone' to sd card then imported them under 'google'. Synced my phone in order to have them in the online service.

    Via google contacts service on pc i exported them in gogole csv format and edited them in excel 2010. I had to change the phone number column format to 'text' in order to get the leading zero in the number to stay put. then saved this file.

    Deleted contacts from from google serive on pc and cleared contacts storage on phone.

    Imported csv file into google contacts on pc. Re-synced phone and hey presto all is good!

    Going to save the edited csv file as a backup.
  18. 1981

    1981 Android Enthusiast

    while exporting contacts to sd card the first time, which all are exported. only the ticked category in the 'view' contact or all the contacts including the sim,phone,google and fb ones??
    thn after exporting it to sd card, connect phone to pc and save the file thr. thn delete the entire 'contact storage' in 'settings'?? the entire contacts in phone memory, gmail and fb will be deleted? or just the ticked category?? the sim contacts wont be deleted at all, rite??
  19. SUroot

    SUroot Extreme Android User

    Were not talking about export to sd in case you think we are
  20. 1981

    1981 Android Enthusiast

    exported gmail and phone contacts to sd and then imported it to my gmail account. and tidied up the account contacts. then synced it with the phone. one thing which dint work out are the calender entries. it showed lots of duplicates. so i cleared the data in 'calender storage' in 'settings' which erased all the calender entries. but when i synced the calender after that, only very few entires are synced. dont understand wat occured in between.

    2) also, wat happens if 'dialer storage' data is cleared. my whole inbox got cleared. i thought it deletes the phones call records, but that stayed intact. strange.

    3) is there any way to backup the FB contacts similarly, to phone or PC and then sync it with gmail?

HTC Desire Forum

Features and specs are not yet known.

Release Date
Similar Threads - Import contacts has
  1. Oldschool297
  2. ghostanime2001
  3. hussanhijazi
  4. tiho_bg
  5. unet
  6. DonaldDuck313
  7. Yaron21
  8. Motorhomer14
  9. mawallace
  10. raywood

Share This Page