KR102428652B1 - Character information processing system using Microsoft Excel - Google Patents

Abstract

Using Microsoft Excel, it recognizes and stores the API (Application Programming Interface) path of text and KakaoTalk text information system, and uses it to implement text system even if the server of text information company is down. A text information processing system, wherein a personal computer includes a central processing unit including an interface module in charge of overall control of text services, a memory including an interface module for storing text information, a text service program, and a plurality of document programs The hard disk including the interface module, the text service unit that performs text service functions through interworking with the central processing unit, traces, creates, and stores the private interface path between the central processing unit and the memory and hard disk during text service. , implements a text information processing system using Microsoft Excel, including an Excel text application processor that executes text services using the private interface path information stored during text service.

Description

Character information processing system using Microsoft Excel

The present invention relates to a text information processing system using Microsoft Excel, and in particular, by using Microsoft Excel to recognize and store the API (Application Programming Interface) path of text and KakaoTalk text information system, and use this to create a text system. It relates to a text information processing system using Microsoft Excel that can be implemented.

A service in which a user sends a text message to multiple or a single counterpart by providing a short/long text message service (SMS/MMS) using a personal computer (PC) or providing a text message using an SNS such as KakaoTalk is being done

In order to perform text service (KakaoTalk, text program) using a personal computer, text information is processed using a programming language (command) while passing through the interfaces of the central processing unit (CPU), memory, and hard disk in the personal computer. .

For example, when looking at text (text, KakaoTalk) transmission, it goes through the interfaces of the central processing unit, memory, and hard disk, and then through the dialog database (DB), messaging server, API (Application Programming Interface) server, and scrap server. sent to the other party. Here, the counterpart may be a personal computer or a mobile device such as a smartphone.

Text sent by the other party also goes through the interface of the central processing unit, memory, and hard disk of the other party's personal computer, and after passing through the conversation database, messaging server, API server, and scrap server, the receiving personal computer's central processing unit, memory, It is temporarily stored in memory after passing through the hard disk interface.

For such a text message service, a text system can be implemented only in an environment in which the text information company's server is normally operated, and a separate cost is incurred when texting is sent.

A text service technology using a personal computer that has been previously proposed in <Patent Document 1> is disclosed.

The prior art disclosed in <Patent Document 1> includes a cloud server that provides a cloud service to support an application related to a message service performed on a user's mobile terminal in a user's PC according to a user's request. The cloud server transfers the received message received by the mobile terminal to the PC, and transfers the transmitted message inputted on the PC by the user to the mobile terminal.

Even in this prior art, in order to perform a text service using a personal computer, a text system can be implemented only in an environment in which a server of a text information company (communication company) is normally operated, and a separate cost is incurred when texting is transmitted.

In addition, the prior art as described above has a disadvantage in that it cannot provide technology for the KakaoTalk text service using a personal computer.

Republic of Korea Patent Publication No. 10-2012-0072113 (published on Jul. 3, 2012) (System and method for providing message service using a cloud service-based PC)

Therefore, the present invention has been proposed to solve the problems that occur when implementing a text message service using a general personal computer as described above and various problems that occur in the prior art, and text and KakaoTalk text information using Microsoft Excel The purpose of the present invention is to provide a text information processing system using Microsoft Excel that recognizes and stores the API (Application Programming Interface) path of the system and uses it to implement a text system.

In order to achieve the above object, "text information processing system using Microsoft Excel" according to the present invention,

Kakao Talk program and text program for text service are built-in, and a conversation database that implements text service during text service, a messaging server, an API (Application Programming Interface) server, and a personal computer that implements text services in conjunction with a scrap server are included. do,

The personal computer is

a central processing unit including an interface module responsible for overall control of the text service;

a memory including an interface module for storing text information;

a hard disk storing a text service program and a plurality of document programs, the hard disk including an interface module;

a text service unit performing a text service function through interworking with the central processing unit;

An Excel text application that creates and stores a new interface path between the central processing unit, the memory, and the hard disk when a text service is performed by the text service unit, and executes a text service using the stored new interface route information during text service It is characterized in that it includes a processing unit.

The personal computer is characterized in that it is a personal computer capable of sending or receiving text messages and KakaoTalk.

In the above, the Excel text application processing unit is activated when the text service function is executed by the text service unit, and generates and stores text service path information using a new API path when the text service is executed.

In the above, the Excel text application processing unit is inserted into the Microsoft Excel program in the form of a module.

In the above, the Excel text application processing unit includes: an Excel file execution unit that executes an Excel file when the text service unit provides a text service; an interface access API function execution unit that executes an API function for accessing a text service-related interface module when the Excel file is executed; and an interface path tracking unit for generating a new interface path between the central processing unit, the memory, and the hard disk by using the interface access API function executed by the interface access API function execution unit.

In addition, the interface path tracking unit is characterized in that it creates a new interface path except for the open API of KakaoTalk or a text program among APIs for text service.

The Excel text application processing unit is characterized in that it includes an interface path generator for generating the new interface path generated by the interface path tracking unit as a private text interface path.

In the above, the Excel text application processing unit includes: an interface path storage unit for storing the text private interface path information generated by the interface path generation unit; and a text service performing unit that performs a text service separately from the text service unit by using the text private interface path information stored in the interface path storage unit and the open text interface path information during text service.

According to the present invention, there is an effect of creating a new API (Application Programming Interface) path of the text and KakaoTalk text information system using Microsoft Excel, and continuously implementing the text system using this.

In addition, according to the present invention, it is possible to implement a text system (text, KakaoTalk) using Microsoft Excel, which has the advantage of reducing the cost of transmitting text messages in bulk.

1 is an overall configuration diagram of a text information processing system using Microsoft Excel according to the present invention;
FIG. 2 is a block diagram of an embodiment for implementing the text service function of the personal computer of FIG. 1 .

Hereinafter, a text information processing system using Microsoft Excel according to a preferred embodiment of the present invention will be described in detail with reference to the accompanying drawings.

The terms or words used in the present invention described below should not be construed as being limited to conventional or dictionary meanings, and the inventor may appropriately define the concept of terms in order to best describe his invention. It should be interpreted as meaning and concept consistent with the technical idea of the present invention based on the principle that it can be.

Therefore, the embodiments described in this specification and the configurations shown in the drawings are only preferred embodiments of the present invention, and do not represent all of the technical spirit of the present invention, so various equivalents and It should be understood that there may be variations.

1 is an overall configuration diagram of a text information processing system using Microsoft Excel according to a preferred embodiment of the present invention. ), a messaging server 320 , an API server 330 , a scrap server 340 , and the like.

The conversation database 310 is a database that creates a table for texts so that text services can be easily applied in text applications or servers and inputs information into the table when text is transmitted.

Messaging server 320 provides data for brokers to establish communication channels with clients, perform authentication and authorization, route messages correctly, ensure reliable delivery, and monitor system performance when performing message delivery. serves to provide The message server 320 allows a message queue client to interact with a broker using HTTP protocol instead of a direct TCP connection through HTTP/HTTPS support.

The API (Application Programming Interface) server 330 serves to manage traffic in order to prevent a large amount of text traffic from reaching and affecting text services.

The scrap server 340 serves to provide the participating content received from users and/or the SNS content obtained from the SNS to the user terminal. This enables two-way communication between the text relay system and the user.

A personal computer (PC) (100) (200) has a built-in KakaoTalk program and a text program for text service, a conversation database 310 that implements a text service during text service, a messaging server 320, and an API (Application Programming) Interface) refers to a user terminal that implements a text service in conjunction with the server 330 and the scrap server 340 .

Here, the personal computers 100 and 200 are personal computers that transmit or receive text messages, and both text transmission and reception are possible. When the personal computer 100 plays a role of transmitting text (text, KakaoTalk), the personal computer 200 plays a role of receiving a text, and when the personal computer 200 plays a role of transmitting text, the personal computer 100 ) is used to receive text messages.

Since the configuration and operation of the personal computers 100 and 200 are the same, only one personal computer 100 will be described below.

As shown in FIG. 2 , the personal computer 100 includes a central processing unit (CPU) 110 including an interface module responsible for overall control of text services, and a memory including an interface module for storing text information. 120, a text service program and a text service unit 140 that stores a text service program and a plurality of document programs, and performs a text service function by interworking with the hard disk 130 including an interface module and the central processing unit 110 , the text service unit 140 creates and stores a new interface path between the central processing unit 110 , the memory 120 , and the hard disk 130 as a private interface path when a text service is performed, and stores the new interface path when a text service is performed and an Excel text application processing unit 150 that executes a text service by using one private interface path information.

The Excel text application processing unit 150 is activated when a text service function is executed by the text service unit 140 , and generates and stores a text service path using an API when the text service is executed.

The Excel text application processing unit 150 may be inserted into a Microsoft Excel program in the form of a module.

The Excel text application processing unit 150 provides an API function for accessing an Excel file execution unit 151 for executing an Excel file when the text service of the text service unit 140 executes the Excel file, and an API function for accessing a text service related interface module when the Excel file is executed. The central processing unit 110, the memory 120, and the hard disk 130 using the interface access API function execution unit 152 to execute, the interface access API function executed by the interface access API function execution unit 152 ) includes an interface path tracking unit 153 that generates a new interface path.

Here, the interface path tracking unit 153 may create a private interface path excluding the open API of Kakao Talk or a character program among APIs for a text service as a new interface path.

In addition, the Excel text application processing unit 150 includes an interface path generation unit 154 that generates the new interface path generated by the interface path tracking unit 153 as text private interface path information, and the interface path generation unit 154 . The text service using the interface path storage unit 155 for storing the text private interface path information generated in A text service performing unit 156 that performs a text service separately from the unit 140 may be included.

The operation of the text information processing system using Microsoft Excel according to a preferred embodiment of the present invention configured as described above will be described in detail as follows.

First, when a user activates the text service unit 140, which is a text system, in order to transmit text (a text program or KakaoTalk) using the personal computer 100, the Excel file execution unit ( 151) is activated.

For example, the Excel text application processing unit 150 generates a new interface path between the central processing unit 110 , the memory 120 , and the hard disk 130 as a private interface path when a text service is performed by the text service unit 140 . It stores and executes the text service using the stored private interface path information during text service.

Here, the Excel text application processing unit 150 is activated when the text service function is executed by the text service unit 140 , and creates a new interface path in the API when the text service is executed and stores it as text service path information.

The Excel file execution unit 151 detects this in the central processing unit 110 and provides the text system operation information to the Excel text application processing unit 150, or when the user wants to use the text system, such as sending a KakaoTalk text message. It is possible to manually request execution of the Excel file, or the Excel text application processing unit 150 may interwork with the text service unit 140 to automatically detect and execute the operation of the text system.

When the text system is operated and execution of the Excel file is requested, the Excel file execution unit 151 executes the Excel file.

In a state in which the Excel file is executed according to the operation of the text system, the text service unit 140 performs text service in the same manner as before, and sends a KakaoTalk text message. Since the KakaoTalk text sending and the short message or MMS service are performed in the same way, only the KakaoTalk text sending will be described below.

Here, during the KakaoTalk text sending service, the KakaoTalk text sending process must pass through the interfaces of the central processing unit 110 , the memory 120 , and the hard disk 130 , and then the conversation database (DB) 310 , It is transmitted to the counterpart via the messaging server 320 , the API (Application Programming Interface) server 330 , the scrap server 340 , and the like. Here, the counterpart may be a personal computer or a mobile device such as a smartphone.

The text sent by the other party must also pass through the interface of the central processing unit, memory, and hard disk of the other party's personal computer, and after passing through the conversation database, messaging server, API server, scrap server, etc., the central processing unit of the receiving personal computer; It is temporarily stored in memory after passing through the interface of memory and hard disk.

Therefore, the present invention recognizes a new API path by using an Excel program in the interface module that must be passed through during the text service function, stores it as a private API path, and uses the recognized private API path even when the character information company is downed in the future. is to do

Here, the API path includes a public API path and a private API path. Public APIs are open for anyone to use, so there is no need to recognize or track them. In a specific texting system such as KakaoTalk, in addition to the public API, important APIs for text sending are kept private, making it impossible to send text messages in the absence of a corresponding server.

Therefore, a new API path is created and stored as a private API path, and even when a problem occurs in the KakaoTalk system, it is possible to send a text message using another text system.

For this, an API function to access a separate interface module is required. In order to access the interface module, an Excel program is used in the present invention.

For example, a separate interface access API function is created in the Excel program, and when the text sending program is executed, the interface access API function execution unit 152 executes the API function for accessing the text service related interface module.

Next, the interface path tracking unit 153 uses the executed interface access API function, the central processing unit 110, the memory 120, and the hard disk 130 that are always interfaced in the personal computer when sending a text message. Access the interface module and create a new interface path.

Here, the interface path tracking unit 153 creates a private API path for any one interface that is not used among Windows 64-bit APIs except for the open API of KakaoTalk or a text program among APIs for text service.

Next, the interface path generating unit 154 generates the new interface path generated by the interface path tracking unit 153 as text private interface path information.

delete

Here, the text private interface path information may include not only interface path information but also text information used by a corresponding text company.

In this way, the text private interface path information generated by the interface path generating unit 154 is separately stored in the interface path storage unit 155 .

Thereafter, when a failure occurs in the text information company, that is, the Kakao Talk system, the user activates the text service performing unit 156 of the Excel text application processing unit 150 inserted into the Excel program.

Then, the text service performing unit 156 uses the text message service unit ( 140), a text service is performed separately.

At this time, since the serviced text is transmitted over the Internet using any one of the text service system of each telecommunication company, the Kakao Talk system, and the Kakao Talk company solution, no text service cost is incurred even if a large amount of text is transmitted.

In particular, the text service method as described above has the advantage of being able to implement the text service normally even when a failure of the corresponding text information company occurs.

Although the invention made by the present inventor has been described in detail according to the above embodiment, the present invention is not limited to the above embodiment and it is common knowledge in the art that various changes can be made without departing from the gist of the present invention. self-evident to those who have

100, 200: personal computer
110: central processing unit (CPU)
120: memory 120,
130: hard disk
140: text service department
150: Excel text application processing unit
151: Excel file execution unit
152: Interface access API function execution unit
153: interface path tracer
154: interface path generation unit
155: interface path storage unit
156: text service execution unit
310: conversation database
320: messaging server
330: API server
340: scrap server

Claims (8)

A system for processing character information in a personal computer using Microsoft Excel, comprising:
Kakao Talk program and text program for text service are built-in, and a conversation database that implements text service during text service, a messaging server, an API (Application Programming Interface) server, and a personal computer that implements text services in conjunction with a scrap server are included. do,
The personal computer is
a central processing unit including an interface module responsible for overall control of the text service;
a memory including an interface module for storing text information;
a hard disk storing a text service program and a plurality of document programs, the hard disk including an interface module;
a text service unit performing a text service function through interworking with the central processing unit;
When a text service is performed by the text service unit, a new interface path between the central processing unit, the memory, and the hard disk is created and stored as a private interface path, and when a text service is performed, the text service is executed using the stored private interface path information. The state includes an Excel text application processing unit,
The Excel text application processing unit is activated when the text service function is executed by the text service unit, creates a new API path of the interface module when the text service is executed, generates and stores the text service path information,
The Excel text application processing unit includes: an Excel file execution unit that executes an Excel file when the text service unit provides a text service; an interface access API function execution unit that executes an API function for accessing a text service-related interface module when the Excel file is executed; Characters using Microsoft Excel, characterized in that it includes an interface path tracking unit that creates a new interface path between the central processing unit, the memory, and the hard disk using the interface access API function executed by the interface access API function execution unit. information processing system.
The text information processing system using Microsoft Excel as set forth in claim 1, wherein the personal computer is a personal computer capable of transmitting or receiving text messages and KakaoTalk.
delete The text information processing system using Microsoft Excel as set forth in claim 1 , wherein the Excel text application processing unit is inserted into a Microsoft Excel program in the form of a module.
delete The text information processing system of claim 1 , wherein the interface path tracking unit acquires text information by tracing a new private interface route excluding the open API of KakaoTalk or text program among APIs for text service .
The text information processing system using Microsoft Excel as set forth in claim 1, wherein the Excel text application processing unit includes an interface path generation unit that generates a new interface path tracked by the interface path tracking unit as text private interface path information.
The method according to claim 7, The Excel text application processing unit interface path storage unit for storing the text private interface path information generated by the interface path generation unit; and a text service performing unit that performs a text service separately from the text service unit using any one of the text private interface path information stored in the interface path storage unit and the open text interface path information during text service Text information processing system using Microsoft Excel.

Images