12-17-2015 11:46 AM
29 12
tools
  1. FBA's Avatar
    I came from BlackBerry and the smart-dial setup on BB's had an option to append digits globally when a number was entered or called up to dial.

    Example - if my address book contact number is 514-XXX-XXXX, it would add the "1" if the area code being dialed was different from the device's phone number area code.

    I have 1100+ contacts in my Address book (Exchange Active Sync). Each time I dial a long distance number from a contact, my carrier announces "the number you are dialing is long distance. Long charges may apply" before it appends and dials. If I had the "1" in there, I wouldn't have to listen to that junk

    Toll free numbers just won't complete at all without a "1", so you must add a "1" before dialing, so I can't dial from my contacts; I have to enter the number manually.

    Android doesn't seem to have the same smart dialing as BB, so I need to basically add the "1" to every contact in my address book, or if I could, all contacts outside my area code and all toll free numbers.

    Is there some way to do this, or some utility in Android for this? I'm using Touchdown for Exchange. Can't do it in Outlook 2010 easily either.
    12-17-2013 03:10 PM
  2. FBA's Avatar
    Never mind - all I had to do was think about it and I fixed it. Exported my address book to excel - added the one using some VB code and imported it back. Took all of 5 minutes. Wow...gee - LOL
    UJ95x likes this.
    12-17-2013 03:34 PM
  3. TheMacs's Avatar
    Sounds like that should be the carrier, not Android. What carrier are you with? I have zero '1's in front of my 10-digit phone #s, many of them out of my local area code. Never heard the voice message your getting.
    12-17-2013 03:42 PM
  4. TheMacs's Avatar
    Sorry, and glad you found a way around it.
    12-17-2013 03:45 PM
  5. Almeuit's Avatar
    None of mine have that issue... Tmobile here. When I was on Sprint the 1 wasn't required either.

    Who are you on?

    Sent from my T-Mobile Note 3 using AC Forums.
    12-17-2013 03:53 PM
  6. Gator352's Avatar
    I'm with Sprint and never have I run into this problem. But glad you got it going FBA.
    12-17-2013 03:55 PM
  7. FBA's Avatar
    On Telus in Canada. In the US, it probably doesn't apply since most carriers consider the entire USA local. I'm on T-mo for my US phone and it's not required. Here in Canada, it is however, but I fixed it in Excel anyway anyway! Thanks for the replies!

    In Canada, we're used to getting ****ed by everyone - LOL
    12-17-2013 03:56 PM
  8. Alain_A's Avatar
    We bought two of them off EBay (Thanks, Mr. Anonymous!) and I had to drive two hours both ways to get them at 1am. Fun times.

    It was a good thing we did it that way, though, because we don't live in a 3G area and they wouldn't have been sold at local stores.
    All you had to do is

    Phone>menu>call settings>additional settings>auto area code

    Sent from my SM-N900W8 using AC Forums mobile app
    12-18-2013 06:19 PM
  9. Alain_A's Avatar
    Wrong quote

    Sent from my SM-N900W8 using AC Forums mobile app
    12-18-2013 06:20 PM
  10. Alain_A's Avatar
    I came from BlackBerry and the smart-dial setup on BB's had an option to append digits globally when a number was entered or called up to dial.

    Example - if my address book contact number is 514-XXX-XXXX, it would add the "1" if the area code being dialed was different from the device's phone number area code.

    I have 1100+ contacts in my Address book (Exchange Active Sync). Each time I dial a long distance number from a contact, my carrier announces "the number you are dialing is long distance. Long charges may apply" before it appends and dials. If I had the "1" in there, I wouldn't have to listen to that junk

    Toll free numbers just won't complete at all without a "1", so you must add a "1" before dialing, so I can't dial from my contacts; I have to enter the number manually.

    Android doesn't seem to have the same smart dialing as BB, so I need to basically add the "1" to every contact in my address book, or if I could, all contacts outside my area code and all toll free numbers.

    Is there some way to do this, or some utility in Android for this? I'm using Touchdown for Exchange. Can't do it in Outlook 2010 easily either.
    All you had to do

    Phone>menu>call settings>additional settings>auto area code

    Sent from my SM-N900W8 using AC Forums mobile app
    12-18-2013 06:21 PM
  11. FBA's Avatar
    Have you tried that? I did days ago and it doesn't do what you think...my solution was simple and will work for every phone - few lines of VB in Excel, export from Outlook to Excel, run the code and export to Outlook. All fixed and 2500+ numbers fixed perfectly!

    Now, all my numbers look like this, 1-XXX-XXX-XXXX and if they have an extension, 1-XXX-XXX-XXXX;XXX
    12-18-2013 10:09 PM
  12. Alain_A's Avatar
    Have you tried that? I did days ago and it does't do what you think...
    Yes I did and it worked for me

    Sent from my SM-N900W8 using AC Forums mobile app
    12-18-2013 10:11 PM
  13. FBA's Avatar
    Didn't for me - all that does is add an area code to a 7-digit number...and that wasn't my problem if you read my post.
    12-18-2013 10:14 PM
  14. Alain_A's Avatar
    Although I am sitting in US with my Telus note 3 with an At&t sim card in it.

    I removed the 1 in front of my wife phone number I had in my phone book then went to those settings and put 1.
    Then I called her in Canada and it worked well.

    Sent from my SM-N900W8 using AC Forums mobile app
    12-18-2013 10:15 PM
  15. Alain_A's Avatar
    Didn't for me - all that does is add an area code to a 7-digit number...and that wasn't my problem if you read my post.
    I don't know how you did that. I understand what you wanted. Just adding the number 1 in front of your phone number.
    It worked the way I explain

    Sent from my SM-N900W8 using AC Forums mobile app
    12-18-2013 10:20 PM
  16. Alain_A's Avatar
    In the auto area code just put 1 nothing else. It will work

    Sent from my SM-N900W8 using AC Forums mobile app
    12-18-2013 10:24 PM
  17. FBA's Avatar
    Ok, so you understand, you probably don't even need the "1" on AT&T. All that function does, is append the digit to the dialling display when you manually dial a number. It does NOT add the digit to contact numbers on the fly. I was hoping it would when I tried it before posting here, but it didn't.

    On my US SIM card (T-Mobile), when I dial outside of my SIM card's area code, I do NOT have to use the "1" either. In Canada, as you well know, you must use the "1" when dialling outside of your local area code. In Canada you can use the "1" for local and long distance, so I added the "1" to every single number in my contact list. If I move to another area code one day, and I will - I will not have to change the numbers again.
    12-18-2013 10:26 PM
  18. Alain_A's Avatar
    Ok you are right for me being in the US. Tomorrow I'm coming back to Canada and I will try again to call her using that method as soon I crossed the border

    Sent from my SM-N900W8 using AC Forums mobile app
    12-18-2013 10:33 PM
  19. FBA's Avatar
    Ok you are right for me being in the US. Tomorrow I'm coming back to Canada and I will try again to call her using that method as soon I crossed the border

    Sent from my SM-N900W8 using AC Forums mobile app
    Even so, the setting you used does not and can not add the digits to numbers in your contact list - so when you try to dial a number from your contact list, it will dial exactly what is in the contact and NOT add the "1". That's the whole problem Alain...

    In Canada, if you don't dial the "1" for long distance, it will still work, but your carrier will give you a long stupid message before it completes the call. Toll free numbers will not complete at all without the "1".

    J'ai bien compris ce que tu m'a expliquer...mais ca marche pas exactement comme je voulais! Mon solution marche est c'est un solution permanent! Merci quand meme!
    12-18-2013 10:45 PM
  20. Unicorn11B's Avatar
    It used to be that way here too. Or was with some carriers at least. Not sure when it changed as I just got onto the habit of putting the 1 in all numbers she pitting them in manually. I noticed that I didn't need it when saving a number if someone called me, but beyond thinking it must have changed, I didn't give it much thought.
    12-19-2013 07:10 AM
  21. TheMacs's Avatar
    Have you tried that? I did days ago and it doesn't do what you think...my solution was simple and will work for every phone - few lines of VB in Excel, export from Outlook to Excel, run the code and export to Outlook. All fixed and 2500+ numbers fixed perfectly!
    Slightly off topic, but did you really need VB code? I think we did this a while back with just a formula (concatenate maybe?).
    12-19-2013 02:10 PM
  22. FBA's Avatar
    It was a few things - but code was the fastest means to the end.

    There were so many different types of entries in the number fields from decades of adding contacts - it was just easier to write some code to prune/ clean and add.

    I had numbers with and without the "1", with and without the area code, with and without extensions, different modifiers for extensions, like "x" or "ext", or "p", or "w", none of which work with Android, which needs a semicolon.

    I could have screwed around with the find and replace feature, or macros...but I used VB and the results were perfect for 1100 contacts with multiple numbers. I had perhaps 10-15 numbers that needed manual editing and that was all.
    12-19-2013 08:57 PM
  23. TheMacs's Avatar
    It was a few things - but code was the fastest means to the end.

    There were so many different types of entries in the number fields from decades of adding contacts - it was just easier to write some code to prune/ clean and add.

    I had numbers with and without the "1", with and without the area code, with and without extensions, different modifiers for extensions, like "x" or "ext", or "p", or "w", none of which work with Android, which needs a semicolon.

    I could have screwed around with the find and replace feature, or macros...but I used VB and the results were perfect for 1100 contacts with multiple numbers. I had perhaps 10-15 numbers that needed manual editing and that was all.
    Gotcha.
    12-20-2013 01:19 PM
  24. JimSmith94's Avatar
    It was a few things - but code was the fastest means to the end.

    There were so many different types of entries in the number fields from decades of adding contacts - it was just easier to write some code to prune/ clean and add.

    I had numbers with and without the "1", with and without the area code, with and without extensions, different modifiers for extensions, like "x" or "ext", or "p", or "w", none of which work with Android, which needs a semicolon.

    I could have screwed around with the find and replace feature, or macros...but I used VB and the results were perfect for 1100 contacts with multiple numbers. I had perhaps 10-15 numbers that needed manual editing and that was all.
    Could you post your VBA code please? A lot of my entries are messed up and I'd like to try your fix.
    12-20-2013 01:22 PM
  25. FBA's Avatar
    You'll have to know what you're doing, but here it is. You'll either have to redefine the column / row numbers to suit your spreadsheet or, move the data to those columns/ rows...so, columns 31-46 are the ones that contain all of my phone number fields and rows 3-975 are all the contact address's (one per line).

    So, either you move your data into those columns/ rows, or make the changes in the VBA code below. The "colorindex=3" was to set the field to red when there was an anomoly in the field and it wasn't a clear cut solution. You will be alerted to numbers that are out of bounds with the code below. You'll see red colored fields where the VBA code burps. I had maybe 3-5 fields like that. My lead developer refined the code -

    Sub reformatPhonNumbers()


    Dim rowsOfNumber As Integer
    Dim colsOfNum As Integer
    Dim tempNum As String





    For colsOfNum = 31 To 46
    For rowsOfNumber = 3 To 975
    tempNum = Cells(rowsOfNumber, colsOfNum)


    If ((Len(tempNum) < 10) And (Len(tempNum) > 1)) Then
    Cells(rowsOfNumber, colsOfNum).Interior.ColorIndex = 3
    End If



    If (Len(tempNum) > 9) Then


    cachedNumber = ""

    For i = 1 To Len(tempNum)


    If (IsNumeric(Mid(tempNum, i, 1))) Then


    If (Not ((Mid(tempNum, i, 1) = 1) And (Len(cachedNumber) = 0))) Then

    If (tenCounter < 10) Then
    cachedNumber = cachedNumber + Mid(tempNum, i, 1)

    End If


    End If


    End If

    Next i



    'MsgBox cachedNumber




    'fix the number to return
    numberToReturn = ""
    If (Len(cachedNumber) = 10) Then
    numberToReturn = "1" + "-" + Mid(cachedNumber, 1, 3) + "-" + Mid(cachedNumber, 4, 3) + "-" + Mid(cachedNumber, 7, 4)
    Cells(rowsOfNumber, colsOfNum) = numberToReturn
    'MsgBox numberToReturn
    End If


    If (Len(cachedNumber) > 10) Then
    numberToReturn = "1" + "-" + Mid(cachedNumber, 1, 3) + "-" + Mid(cachedNumber, 4, 3) + "-" + Mid(cachedNumber, 7, 4) + ";" + Mid(cachedNumber, 11, Len(cachedNumber))
    Cells(rowsOfNumber, colsOfNum) = numberToReturn
    'MsgBox numberToReturn
    End If


    End If
    Next rowsOfNumber
    Next colsOfNum


    End Sub






    Function getCleanNumber(strCell)


    getCleanNumber = strCell


    End Function
    JimSmith94 likes this.
    12-20-2013 05:01 PM
29 12

Similar Threads

  1. HTC ONE X Unrooting to install OTA Update
    By Russ Cruz in forum HTC One X
    Replies: 23
    Last Post: 12-17-2013, 11:59 PM
  2. How to un-root GS3 at&t i747
    By abarzua21 in forum AT&T Galaxy S III Rooting, ROM's, and Hack's
    Replies: 1
    Last Post: 12-17-2013, 07:24 PM
  3. Replies: 4
    Last Post: 12-17-2013, 04:01 PM
  4. How to format and restore to factory settings?
    By Irma Zuhro in forum General Help and How To
    Replies: 1
    Last Post: 12-17-2013, 03:12 PM
  5. Replies: 4
    Last Post: 12-17-2013, 01:32 PM
LINK TO POST COPIED TO CLIPBOARD