Question

Photo of Jeremy Turgeon

0

Blank Data in Group Toolbox - Excavator

1

We've recently begun setting up lay leaders with access to congregants in their area using the Group Toolbox. One use that's come up is that many of our congregant's records show no phone numbers even though the (mobile), (home), and (work) displays. Eventually tracked down the common denominator between each record experiencing this problem to be the thousands of people imported using Excavator when first implementing Rock.

If I manually delete and re-add someone's phone numbers, the problem disappears but that just isn't a solution for the thousands of records we need to display correctly. Has anyone found a solution to this?

  • Photo of Jeremy Turgeon

    0

    There's a SQL command that I used to update all records to the correct format.

    UPDATE [PhoneNumber]  
SET NumberFormatted = '(' + SUBSTRING( Number, 1, 3) + ')' + ' ' +  
    SUBSTRING(Number, 4, 3) + '-' +
    SUBSTRING(Number, 7, 4)

    You can see the full set of instructions on the Shoulder the Boulder article here.