Phone # format in Reports

Options
Adam Eggert
Adam Eggert
Eighth Anniversary 10 Comments 5 Likes Loyalty Badge
in Blackbaud Raiser's Edge NXT®: General Discussion
I currently have all my phone number in the "(555) 555-5555" fomat.  When I pull reports some of the phone numbers show us as 5555555555.  Any idea why it's not putting in the right format in reports, but shows fine in their records?
Tagged:

Comments

  • Aaron Rothberg
    Aaron Rothberg
    Eighth Anniversary 500 Likes 100 Comments Name Dropper
    Hi Adam-


    That's a Phone Type Format in Config. If you were to choose the Format <NONE> you would not see the parentheses nor dashes in Raiser's Edge. See the screenshot below. In other databases I've seen this referred to as a Field Mask.

    80e99cba54fa707d77fa1a586ea4e01b-huge-ph

     
  • Ryan Hyde
    Ryan Hyde
    Tenth Anniversary 1,000 Likes 500 Comments Name Dropper
    There was an issue after 7.95/96 where phone numbers that were entered originally with formatting that was incorrect (maybe they were entered as 555123-4567) would show up in the record correctly because of the config format Aaron pointed out but would export with the incorrect information. One way to fix this would be to export all phone numbers (along with the import ID for each number), find all the messed up ones, remove all formatting, and import them as updates. This will allow the RE formatting rules to work on them as you'd expect.


    Or if there aren't that many, you can just change them by hand over time and slowly fix the problem.

Categories