Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #31279
    clinicoffice_user
    Participant

    I imported our client list into the system but have found that a huge number of the mobile telephone numbers have imported without the initial 0 in the number. Is there a quick way of just adding a 0 to the numbers without having to edit each client record inidividually?

    thanks,

    Sally

    #32941
    Support
    Keymaster

    Hi Sally,

    This is often a problem if you use EXCEL as it likes to strip out the leading ‘0’ characters from numbers.
    ( 💡 To avoid this, you can should set the CELL FORMAT in EXCEL to Text instead of General for cells which hold telephone numbers.)

    To correct all telephone numbers which don’t start with ‘0’, please follow these steps :-

    [1] Make sure you are logged on to ClinicOffice as an administrator
    [2] Click TOOLS | Advanced DB Operation
    [3] Copy and paste the following SQL code :-

    update per set mobile='0' || mobile where mobile like '1%';
    update per set mobile='0' || mobile where mobile like '2%';
    update per set mobile='0' || mobile where mobile like '7%';

    update per set telephone='0' || telephone where telephone like '1%';
    update per set telephone='0' || telephone where telephone like '2%';
    update per set telephone='0' || telephone where telephone like '7%';

    update per set worktel='0' || worktel where worktel like '1%';
    update per set worktel='0' || worktel where worktel like '2%';
    update per set worktel='0' || worktel where worktel like '7%';

    [4] Click the EXECUTE button

    Please let us know how you get on with this.

    #32942

    Brilliant – worked within seconds. Thank you very much.

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.