使用WPS/Excel的SIP電話電話簿編輯指南

本文件引導使用者使用 WPS 或 Excel 編輯電話簿時的重要注意事項。請特別注意中文姓名的聯絡人,處理不當會導致電話簿匯入電話後出現亂碼。

準備工具:

  1. 從 IP 電話匯出的電話簿(CSV 格式)。

  2. 試算表編輯器:WPS 或 Excel。

  3. 記事本(Windows 內建文字編輯器)。

操作步驟:

  1. 登入電話的網頁介面,導航至 電話設定 -- 電話簿,並在電話簿編輯區輸入聯絡人資訊,例如:

    電話簿設定

  2. 填寫聯絡人詳細資訊後,點擊 新增 按鈕以在電話上建立新聯絡人:

    新增聯絡人介面

  3. 匯出聯絡人清單 下,點擊 匯出 CSV 以下載 CSV 格式的聯絡人清單。預設檔名為 contact.csv。使用此檔案作為範本;保持原始格式不變新增聯絡人以確保成功匯入。

  4. 使用試算表工具(WPS 或 Excel)編輯聯絡人。本指南以 WPS 示範。開啟匯出的 contact.csv 檔案並新增聯絡人資訊,如下所示:

    在 WPS 中編輯聯絡人 CSV

    欄位說明:

    • name:聯絡人姓名。

    • work:工作號碼(sip: 之後的數字);@1 表示撥打此號碼使用電話上的線路 1。

    • mobile:聯絡人的手機號碼。

    • ring:為此聯絡人來電指定的鈴聲。

    • groups:聯絡人群組(必須使用電話上已有的群組,例如 friend, work, home)。

    儲存編輯過的檔案。可能會出現相容性提示:

    檔案相容性提示

    點擊 繼續。

  5. 直接匯入修改過的檔案將會出現亂碼,因為 WPS/Excel 會更改檔案編碼。使用記事本修正:用記事本開啟電話簿 CSV。

    在記事本中開啟的電話簿

    前往 檔案 -- 另存新檔。如下圖設定格式:

    另存 CSV 介面

    點擊 儲存(另存為 contact2.csv),然後透過網頁介面將此檔案匯入電話。將不會出現亂碼。

目錄
客服 電話
We use cookie to improve your online experience. By continuing to browse this website, you agree to our use of cookie.

Cookies

This Cookie Policy explains how we use cookies and similar technologies when you access or use our website and related services. Please read this Policy together with our Terms and Conditions and Privacy Policy so that you understand how we collect, use, and protect information.

By continuing to access or use our Services, you acknowledge that cookies and similar technologies may be used as described in this Policy, subject to applicable law and your available choices.

Updates to This Cookie Policy

We may revise this Cookie Policy from time to time to reflect changes in legal requirements, technology, or our business practices. When we make updates, the revised version will be posted on this page and will become effective from the date of publication unless otherwise required by law.

Where required, we will provide additional notice or request your consent before applying material changes that affect your rights or choices.

What Are Cookies?

Cookies are small text files placed on your device when you visit a website or interact with certain online content. They help websites recognize your browser or device, remember your preferences, support essential functionality, and improve the overall user experience.

In this Cookie Policy, the term “cookies” also includes similar technologies such as pixels, tags, web beacons, and other tracking tools that perform comparable functions.

Why We Use Cookies

We use cookies to help our website function properly, remember user preferences, enhance website performance, understand how visitors interact with our pages, and support security, analytics, and marketing activities where permitted by law.

We use cookies to keep our website functional, secure, efficient, and more relevant to your browsing experience.

Categories of Cookies We Use

Strictly Necessary Cookies

These cookies are essential for the operation of the website and cannot be disabled in our systems where they are required to provide the service you request. They are typically set in response to actions such as setting privacy preferences, signing in, or submitting forms.

Without these cookies, certain parts of the website may not function correctly.

Functional Cookies

Functional cookies enable enhanced features and personalization, such as remembering your preferences, language settings, or previously selected options. These cookies may be set by us or by third-party providers whose services are integrated into our website.

If you disable these cookies, some services or features may not work as intended.

Performance and Analytics Cookies

These cookies help us understand how visitors use our website by collecting information such as traffic sources, page visits, navigation behavior, and general interaction patterns. In many cases, this information is aggregated and does not directly identify individual users.

We use this information to improve website performance, usability, and content relevance.

Targeting and Advertising Cookies

These cookies may be placed by our advertising or marketing partners to help deliver more relevant ads and measure the effectiveness of campaigns. They may use information about your browsing activity across different websites and services to build a profile of your interests.

These cookies generally do not store directly identifying personal information, but they may identify your browser or device.

First-Party and Third-Party Cookies

Some cookies are set directly by our website and are referred to as first-party cookies. Other cookies are set by third-party services, such as analytics providers, embedded content providers, or advertising partners, and are referred to as third-party cookies.

Third-party providers may use their own cookies in accordance with their own privacy and cookie policies.

Information Collected Through Cookies

Depending on the type of cookie used, the information collected may include browser type, device type, IP address, referring website, pages viewed, time spent on pages, clickstream behavior, and general usage patterns.

This information helps us maintain the website, improve performance, enhance security, and provide a better user experience.

Your Cookie Choices

You can control or disable cookies through your browser settings and, where available, through our cookie consent or preference management tools. Depending on your location, you may also have the right to accept or reject certain categories of cookies, especially those used for analytics, personalization, or advertising purposes.

Please note that blocking or deleting certain cookies may affect the availability, functionality, or performance of some parts of the website.

Restricting cookies may limit certain features and reduce the quality of your experience on the website.

Cookies in Mobile Applications

Where our mobile applications use cookie-like technologies, they are generally limited to those required for core functionality, security, and service delivery. Disabling these essential technologies may affect the normal operation of the application.

We do not use essential mobile application cookies to store unnecessary personal information.

How to Manage Cookies

Most web browsers allow you to manage cookies through browser settings. You can usually choose to block, delete, or receive alerts before cookies are stored. Because browser controls vary, please refer to your browser provider’s support documentation for details on how to manage cookie settings.

Contact Us

If you have any questions about this Cookie Policy or our use of cookies and similar technologies, please contact us at support@becke.cc .