Mass delete Phone Book entries

BilboBilbo
in Support
Hi i have made a mess of my phone book and wondered is their a way to delete the whole thing so that i can re-import from scratch? At the moment i cant delete any more then 5 at a time.
Many Thanks

Comments

  • nicolasnicolas
    You can use mysql directly. Assuming you use FreePBX, from your server command line:

    mysql -u root -p asterisk -e "delete from visual_phonebook"
  • BilboBilbo
    Ok, Many thanks for that.

    when you import a phone book will it only be for one user? i was under the impression that FOP had a global address book but i can only see it for the user that i installed it from?

    Thanks again
  • nicolasnicolas
    The visual_phonebook table has two fields that control the record scope: owner and private.

    If a record is set with private='yes' only the extension that is set in 'owner' can see that record.

    So, if extension 200 has private records, and 201 some others, then set them like:

    owner='200',private='yes'
    owner='201',private='yes'
Sign In or Register to comment.

© Asternic Corp 2024