200924496 九、發明說明: 【發明所屬之技術領域】 本發明係有關於一種資料整合系統,尤其是指一種不 僅具有一般來電顯示功能,且可利用來電資料整合企業本 身現有的資訊系統,以在來電時能立即顯示出該來電客戶 的各項相關資料,同時能達到數用戶端界面同時顯示之功 效,令接電話的人員能立即得知該來電資料與進行各項資 料操作,而在其整體施行使用上更增實用便利價值性之資 料整合系統創新設計者。 【先前技術】 按,於繁忙的現代社會中,凡事皆講求迅速、確實, 方能贏在起跑點上,尤其是以服務至上的各項服務業、客 服人員等,更是希望能在客戶來訪、來電時,能迅速立即 調出存在公司内部的客戶各項相關資料,以對客戶提供更 為完善的服務,讓客戶獲得更佳的服務品質。 一般於客戶來電時,皆能經由電信系統所提供的服務 及搭配電話系統,於電話主機上顯示出來電號碼,讓接聽 電話的人員能經由所顯示出的來電號碼辨識出來電的客 戶,再予以調出該來電客戶的資料;然而,現階段的系統 雖可達到顯示出來電號碼,讓接聽電話的人員能經由所顯 示的號碼辨識出來電的客戶之預期功效,但於實際施行使 用上卻發現,其由於僅能顯示出來電號碼,仍需由接聽電 話之人員另行調出該來電客戶的相關資料,不僅顯得極為 不便,且亦造成時效上之延遲,無法立即獲得客戶相關資 料、提供客戶最佳的服務,而導致在其整體系統設計使用 上仍存有改進之空間。 5 200924496 .緣是,發明人有鑑於此,秉持多年該相關行業之豐富 設計開發及實際製作經驗,針對現有之結構及缺失再予以 研究改良,提供一種資料整合系統,以期達到更佳實用價 值性之目的者。 【發明内容】 本發明之資料整合系統,其主要係令電話系統連接來 電精靈程式,且該來電精靈程式分別連接有内部資料庫及 企業資訊系統資料庫,使得於客戶來電時,該來電精靈程 式能利用來電號碼由企業資訊系統資料庫中搜尋客戶資 料,並將所搜尋到之客戶相關資料暫存於内部資料庫中, 且經由網路伺服器能同時於數用戶端界面同時顯示相關資 料;藉此,以可讓接聽電話之人員能於接聽電話之同時立 即得知來電客戶的各項相關資料,提供客戶最佳的服務, 而在其整體施行使用上更增實用便利價值性者。 【實施方式】 為令本發明所運用之技術内容、發明目的及其達成之 功效有更完整且清楚的揭露,茲於下詳細說明之,並請一 併參閱所揭之圖式及圖號: 首先,請參閱第一圖本發明之系統架構示意圖所示, 本發明主要係令電話糸統(1)連接有來電精靈程式(2) ’且 於該來電精靈程式(2)分別連接内部資料庫(21)及企業資 訊系統資料庫(3),該内部資料庫(21)及企業資訊系統資料 庫(3)並皆連接至網路伺服器(4),而該網路伺服器(4)則同 時連接有數用戶端界面(5);其中: 該來電精靈程式(2)包含有伺服主程式、内部資料庫 (21)及於用戶端界面(5)顯示界面工具晝面;該伺服主程式 44V0 是接收來電的主程式,主功能3 部之企業資訊系統資料庫(3)中疋=收到來電後依設定到外 回〔如:客戶資料等〕,為了減低寺和該電話相關的資料取 料庫(3)的依存和負擔以及安全]日後對原企業資訊系統資 料會存入内部資料庫(21),生上的考量,這些取回的資 該内部資料庫(21)存玫所有來戶端界面(5)讀取顯示; 包含和外部之企業資訊系統;=、己錄,及一些設定參數, DatabaSeC〇rmectivity,開』式連結的 0DBC〔0pen200924496 IX. Description of the Invention: [Technical Field] The present invention relates to a data integration system, and more particularly to an information system that not only has a general caller ID function, but also can integrate incoming information of the enterprise by using incoming call data to make an incoming call. It can immediately display the relevant information of the calling customer, and at the same time, it can achieve the effect of simultaneous display of several user interfaces, so that the person answering the call can immediately know the incoming call data and carry out various data operations, and in its overall implementation Incorporate system innovation designers with more practical and convenient value data. [Prior Art] According to the busy modern society, everything is fast and sure, and it can win at the starting point, especially the service-oriented service industry, customer service personnel, etc., but also hope to visit customers. When you call, you can quickly and immediately transfer the relevant information of the customers within the company to provide better services to customers and enable them to obtain better service quality. Generally, when a customer calls, the service can be displayed on the telephone host through the service provided by the telecommunication system and the telephone system, so that the person answering the call can identify the customer via the displayed caller number, and then The data of the incoming caller is called up; however, the current system can display the outgoing number, so that the person answering the call can recognize the expected effect of the customer through the displayed number, but found in actual use. Since it can only display the electric number, it is still necessary for the person answering the call to separately transfer the relevant information of the calling customer, which is not only extremely inconvenient, but also causes delay in timeliness, and cannot immediately obtain relevant information of the customer and provide the most customers. Good service, and there is still room for improvement in the design and use of its overall system. 5 200924496 . The reason is that the inventor, in view of this, upholds the rich experience in design and development and actual production of the relevant industry for many years, and provides research and improvement on the existing structure and defects, and provides a data integration system to achieve better practical value. The purpose of the person. SUMMARY OF THE INVENTION The data integration system of the present invention mainly connects a telephone system to a caller elf program, and the call elf program is respectively connected with an internal database and an enterprise information system database, so that when the customer calls, the call elf program The customer information can be searched by the enterprise information system database by using the caller ID, and the searched customer related data is temporarily stored in the internal database, and the related information can be simultaneously displayed on the user interface through the network server; In this way, the person who can answer the call can immediately know the relevant information of the calling customer while receiving the call, provide the best service of the customer, and increase the practical convenience value in the overall implementation. [Embodiment] For a more complete and clear disclosure of the technical content, the purpose of the invention and the effects thereof achieved by the present invention, the following is a detailed description, and please refer to the drawings and drawings: First, please refer to the first diagram of the system architecture diagram of the present invention. The present invention mainly connects the telephone system (1) with the incoming caller program (2)' and connects the internal data library to the incoming caller program (2). (21) and the enterprise information system database (3), the internal database (21) and the enterprise information system database (3) are both connected to the network server (4), and the network server (4) At the same time, a number of client interfaces (5) are connected; wherein: the caller wizard (2) includes a server main program, an internal database (21), and a user interface (5) display interface tool; the server main program 44V0 is the main program for receiving incoming calls, the main function of the 3rd part of the enterprise information system database (3) 疋 = after receiving the call, according to the setting to the external return (such as: customer information, etc.), in order to reduce the temple and the phone related information Dependence and negative of the reclaiming library (3) The burden and security] in the future, the original enterprise information system data will be stored in the internal database (21), the consideration of the birth, the retrieved funds of the internal database (21) memory all the user interface (5) read Display; include and external enterprise information system; =, recorded, and some set parameters, DatabaSeC〇rmectivity, open-style link 0DBC [0pen
Database Connectivity]或亩 單建結〕或 JDBC[ Java 來電時比對的搁位和顯示的搁彳立μ '、、、、為料庫的相關設定、 面,用戶端界面(5)的部份是以5寺% ;該界面工具顯示晝 向網路伺服器(4)取=乂姐面工具的方式呈現,透過 Language,可擴展標記語今〕、 〔Extensible Markup 界面工具、AP、網頁的方式呈現別即^...等的方式,用 關資料,多分機系統時,所右右寺頭不目前來電的相 電腦都可以看見來電的資料,“工具的用戶端界面⑸ 度詢問來電者的資料。 田δ轉接過來時,不需再 =來%精重程式⑵與企業資 的方式有採用ODBC、TnRr笙此μ τ、兄貝枓庫(3)連線Database Connectivity] or JDBC [Java] Java calls to compare the position and display of the stand-up μ ',,,, the relevant settings of the library, the face, the user interface (5) part It is 5% of the temple; the interface tool displays the way to the web server (4) to take the 乂 乂 面 工具 tool, through the Language, expand the markup language], [Extensible Markup interface tool, AP, web page way When you use the data, multi-extension system, the computer on the right and right of the temple can not see the data of the caller. "The user interface of the tool (5) asks the caller. Data. When the field δ is transferred, there is no need to use the ODBC, TnRr, μ, 兄, 兄, 枓, ( (3) connection.
Access ^ DB2 M Qm 荨外邛聯結方式,聯結包含 s DB2 MySQL、MS_SQL、F〇xPr〇、仙咖、£就卜 ,員h擇其所需求的連結方式,而 剔,〇、0咖等方式連結該類型資料庫直接、擇使用 气料^該^精靈程式⑵可單獨運作並與企業資訊系統 =八紫i作正合’亦可直接將來電精靈程式⑵直接整合 業貝讯錢資料庫⑶中〔請—併參閱第二圖本創作之 200924496 另一實施例系統架構示意圖所示〕。 而於該網路伺服器(4)將資料輸出至用戶端界面(5)顯 示的格式,則可分別利用XML、CSV、HTML、TXT、資料加 密編碼等格式。 至於該網路伺服器(4)所使用的網路平台,則可採用 php、asp、jsp、. net、java、perl 等網路平台。 如此一來,請再一併參閱第三圖本發明之動作流程示 意圖所示,使得當電話系統(1)有電話撥入時,該來電精靈 程式(2)即會取得來電號碼,此時來電精靈程式(2)會進入 該企業貧訊糸統貧料庫(3)中去嘗試取得該電話號碼的相 關資料,且將所有來電相關資料含來電號碼、時間都存入 該内部資料庫(21)中,用戶端界面(5)會定期向該網路伺服 器(4)請求最新來電資料,而網路伺服器(4)上的資料輸出 程式會向該内部資料庫(21)取得資料並封裝,使得用戶端 界面(5)會由該網路伺服器(4)取得來電資料並加以解析, 而能顯示出該來電客戶的各項相關資料訊息,且同時該用 戶端界面(5)亦會定期向該網路伺服器(4)請求最新該來電 電話號碼的相關資料,而網路伺服器(4)上的資料輸出程式 則會向該企業資訊系統資料庫(3)取得資料並封裝,使得用 戶端界面(5)同樣會由該網路伺服器(4)取得來電電話號碼 的相關資料並加以解析。 以上所述之各實施例的揭示均係為利於說明本發明之 技術手段,並非限制本發明之架構組成,故舉凡數值的變 更或等效結構的簡單替換仍屬本發明之設計範疇。 經由以上的實施說明,可知本發明與現有系統相較之 下,本發明確具有下列優點: 200924496 1. 本發明來電精靈程式係為單獨運作的方式,可透過來電 精靈程式與企業資訊系統資料庫中的客戶資料作比對, 不必修改企業系統程式。 2. 本發明採用網路伺服器的資料輸出方式,可讓各種的用 戶端界面連結顯示來電資料及進一步的相關資訊,例 如:PC、NB、手機、資訊站等。 3. 本發明於使用上可於第一時間知道來電者身分,並帶出 基本的來電者資料,以利客戶關係管理(CRM),並加速企 業内部系統流程。 4. 本發明來電精靈程式相容於多種資料庫及各種來電顯示 硬體,可讓客戶輕鬆的安裝使用。 綜上所述,本發明實施例確能達到所預期之使用功 效,又其所揭露之具體構造,不僅未曾見諸於同類產品中, 亦未曾公開於申請前,誠已完全符合專利法之規定與要 求,爰依法提出發明專利之申請,懇請惠予審查,並賜准 專利,則實感德便。 200924496 【圖式簡單說明】 第一圖:本發明之系統架構示意圖Access ^ DB2 M Qm 荨 邛 邛 , , , , , DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB DB Link this type of database directly, choose to use the material ^ The ^ Elf program (2) can be operated separately and with the enterprise information system = eight purple i for the right 'can also directly call the elf program (2) directly integrate the industry Baixun money database (3) [Please - and refer to the second diagram of the creation of 200924496 another embodiment of the system architecture diagram]. In the format displayed by the web server (4) to output the data to the user interface (5), XML, CSV, HTML, TXT, data encryption encoding, and the like can be respectively used. As for the network platform used by the web server (4), php, asp, jsp, .net, java, perl and other network platforms can be used. In this way, please refer to the third diagram of the present invention as shown in the schematic diagram of the action flow, so that when the telephone system (1) has a telephone dial-in, the caller elf program (2) will obtain the caller number, and the caller will be called at this time. The Elf program (2) will enter the enterprise's poor information system (3) to try to obtain the relevant information of the phone number, and store all incoming call related information including the caller ID and time into the internal database (21 In the user interface (5), the latest server data is periodically requested from the network server (4), and the data output program on the network server (4) obtains the data from the internal database (21). Encapsulation, so that the user interface (5) will obtain the call data from the network server (4) and parse it, and can display various related information messages of the incoming call client, and at the same time, the user interface (5) The network server (4) is periodically requested to obtain the latest information about the incoming call number, and the data output program on the web server (4) obtains data from the enterprise information system database (3) and packages it. To make the client Surface (5) will be the same phone number to call to obtain the relevant information from the web server (4) and be resolved. The disclosures of the various embodiments described above are intended to illustrate the technical means of the present invention and do not limit the architectural composition of the present invention. Therefore, any numerical changes or simple replacement of equivalent structures are still within the scope of the present invention. Through the above implementation description, it can be seen that the present invention has the following advantages compared with the prior system: 200924496 1. The present invention is a separate operation mode, which can be accessed through the caller elf program and the enterprise information system database. The customer data in the comparison is made, and it is not necessary to modify the enterprise system program. 2. The invention adopts the data output mode of the network server, and allows various user interface interfaces to display the incoming call data and further related information, such as: PC, NB, mobile phone, information station, and the like. 3. The invention can be used to know the identity of the caller in the first time, and bring out the basic caller information to facilitate customer relationship management (CRM) and accelerate the internal system flow of the enterprise. 4. The invention is compatible with a variety of databases and various caller ID hardware, which allows customers to easily install and use. In summary, the embodiments of the present invention can achieve the expected use efficiency, and the specific structure disclosed therein has not been seen in similar products, nor has it been disclosed before the application, and has completely complied with the provisions of the Patent Law. And the request, the application for the invention of a patent in accordance with the law, please forgive the review, and grant the patent, it is really sensible. 200924496 [Simple description of the diagram] First diagram: Schematic diagram of the system architecture of the present invention
之另一實施例系統架構示意 弟二圖·本發明之動作流程示意圖 【主要元件符號說明】 (1) 電話系統 (21) 内部資料庫 (4) 網路伺服器 (2) 來電精靈程式 (3) 企業資訊系統資料庫 (5)用戶端界面Another embodiment of the system architecture is shown in the second diagram. The flow chart of the present invention [main component symbol description] (1) telephone system (21) internal database (4) network server (2) caller wizard program (3) ) Enterprise Information System Database (5) User Interface