Import contacts has added dashes?

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

  1. nemo1966

    nemo1966 Active Member
    16

    Jul 16, 2010
    44
    4
    16
    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?

    thanks
     

    Advertisement

  2. justinbrett1975

    justinbrett1975 Active Member
    16

    Apr 29, 2010
    32
    1
    16
    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 Well-Known Member
    78

    Jun 3, 2010
    929
    56
    78
    Luton
  4. andybog

    andybog Well-Known Member
    58

    May 29, 2011
    114
    19
    58
    Male
    wicked! thanks for the app pointer, was annoying me. After a htc sync my contacts some how dissappered!
     
  5. SiHa

    SiHa Well-Known Member
    78

    Oct 29, 2010
    624
    81
    78
    Southampton, UK.
    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 Well-Known Member
    1,123

    May 25, 2010
    23,925
    5,304
    1,123
    UK Technical Lead; Desktop Support
    Riddlesden, West Yorkshire, UK
    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 Well-Known Member
    1,123

    May 25, 2010
    23,925
    5,304
    1,123
    UK Technical Lead; Desktop Support
    Riddlesden, West Yorkshire, UK
    Im not talking about vcards. csv (i.e comma separated values), on your computer.
     
  8. Kelmar

    Kelmar Done by choice
    VIP Member
    823

    Nov 28, 2009
    11,820
    4,751
    823
    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 Well-Known Member
    113

    Oct 12, 2010
    617
    200
    113
    Perhaps you could delete the quote in post #3 with the link?
     
  10. andybog

    andybog Well-Known Member
    58

    May 29, 2011
    114
    19
    58
    Male
    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 Well-Known Member
    1,123

    May 25, 2010
    23,925
    5,304
    1,123
    UK Technical Lead; Desktop Support
    Riddlesden, West Yorkshire, UK
    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 Well-Known Member
    78

    Oct 29, 2010
    624
    81
    78
    Southampton, UK.

    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 Well-Known Member
    58

    May 29, 2011
    114
    19
    58
    Male
    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 Well-Known Member
    1,123

    May 25, 2010
    23,925
    5,304
    1,123
    UK Technical Lead; Desktop Support
    Riddlesden, West Yorkshire, UK
    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
    sync

    What exactly didnt work in excel?
     
  15. andybog

    andybog Well-Known Member
    58

    May 29, 2011
    114
    19
    58
    Male
    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 Well-Known Member
    1,123

    May 25, 2010
    23,925
    5,304
    1,123
    UK Technical Lead; Desktop Support
    Riddlesden, West Yorkshire, UK
    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 Well-Known Member
    58

    May 29, 2011
    114
    19
    58
    Male
    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 Well-Known Member
    36

    Apr 17, 2010
    308
    9
    36

    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??
    thanks.
     
  19. SUroot

    SUroot Well-Known Member
    1,123

    May 25, 2010
    23,925
    5,304
    1,123
    UK Technical Lead; Desktop Support
    Riddlesden, West Yorkshire, UK
    Were not talking about export to sd in case you think we are
     
  20. 1981

    1981 Well-Known Member
    36

    Apr 17, 2010
    308
    9
    36
    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?
     
Tags:

Share This Page

Loading...