JP2002328877A - Input data registration method, system and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To smoothly transmit and receive data without taking a procedure for synchronization on a transmission side and on a reception side even when communication is interrupted in the middle of transmission and reception. SOLUTION: Electronic mail including input data is received from a mail server and the input data are extracted and registered to a database.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method, a system, and a program for receiving an electronic mail including input data from a mail server, extracting the input data, and registering the input data in a database.

[0002]

2. Description of the Related Art Conventionally, when data input at a remote office or the like is transmitted to a head office computer system via a communication line such as a telephone line and registered in a database, the data is transmitted to a transmitting side (an office side). It was necessary to synchronize with the receiving side (the head office system side) for data transmission and reception. For example, before sending data, the sales office staff calls the head office in advance and informs them that the data will be sent, and in response the head office staff activates an information terminal such as a personal computer. Thus, data was prepared for reception.

[0003] However, in this method, the transmitting side and the receiving side are in one-to-one communication, and the procedure for synchronization is not only complicated. In some cases, a procedure for synchronization is required, making it difficult to transmit and receive data smoothly. This problem becomes more remarkable as the number of offices on the transmitting side increases.

[0004]

SUMMARY OF THE INVENTION An object of the present invention is to eliminate the need for a synchronization procedure between a transmitting side and a receiving side, and to smoothly transmit and receive data even if communication is interrupted during transmission and reception. To do.

[0005]

According to the present invention, there is provided an input data registration method, comprising the steps of: receiving an electronic mail including input data from a mail server, extracting the input data, and storing the input data in a database. It is configured to register.

According to the present invention, even if the communication is interrupted while receiving the e-mail including the input data, the e-mail can be received by accessing the mail server again. Thus, data can be transmitted and received smoothly without performing a synchronization procedure, and even if communication is interrupted during transmission and reception. In addition, existing infrastructure can be used as it is.

[0007] The input data is, for example, data relating to sales entered at each business office, and the database is, for example, a database for centrally managing data relating to sales at each business office.
If the reception of the e-mail fails, it is desirable to access the mail server again to receive the e-mail. This can be realized by using a mailer function. This makes it possible to acquire input data without human intervention until the e-mail can be received.

According to another aspect of the present invention, there is provided an input data registration system including an input unit, and transmitting an electronic mail including data input from the input unit to a mail server. A first information terminal;
A second information terminal for receiving an e-mail including input data from the mail server, extracting the input data, and registering the data in the database;

According to the present invention, even if communication is interrupted during reception of an e-mail including input data, the e-mail can be received by accessing the mail server again. Thus, data can be transmitted and received smoothly without performing a synchronization procedure, and even if communication is interrupted during transmission and reception. In addition, existing infrastructure can be used as it is.

[0010] The input data is, for example, data relating to sales entered at each business office, and the database is, for example, a database for centrally managing data relating to sales at each business office.
If the reception of the e-mail fails, it is desirable to access the mail server again to receive the e-mail. This can be realized by using a mailer function. This makes it possible to acquire input data without human intervention until the e-mail can be received.

[0011]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, an input data registration system according to an embodiment of the present invention will be described with reference to the drawings. FIG. 1 is a diagram for explaining a schematic system configuration of the input data registration system.

In this embodiment, a sales office is a store for new or used automobile parts, and stores information on sales (including information on customers) on its own information terminal 100.
Enter in, for example. The head office is the head office of each sales office, and collects input data (such as information on sales) from each sales office and registers it in its own database.

The system includes a first information terminal 100 (and information terminals 200 and 300) installed in a remote office.
..) And a second terminal 400 installed at the head office. Both are connected to a network such as the Internet, and can mutually send and receive e-mail via a mail server 500 connected to the network. Although there may be a plurality of mail servers 500, FIG. 1 shows one case.

A business office terminal 100 as a first information terminal
(The same applies to the office terminals 200, 300...) Are information terminals such as personal computers, a computer main body, a storage device such as a hard disk device built in the computer main body, input means such as a keyboard and a mouse, In addition, an image display device such as a CRT display and a liquid crystal display is provided.

The storage device includes Windows (registered trademark).
And a predetermined operating system such as Mac OS and UNIX (registered trademark), and a mailer (software for creating and sending / receiving e-mail texts) executed on the operating system. A business application program for inputting information (customer name, address, telephone number, order information, etc.) and generating a file in which the information is described is installed.

A head office terminal 400 as a second information terminal
Is also an information terminal such as a personal computer, such as a computer main body, a storage device such as a hard disk device built in the computer main body, input means such as a keyboard and a mouse, and an image display device such as a CRT display and a liquid crystal display. It has.

The storage device includes Windows and Mac OS
A predetermined operating system such as Linux or UNIX is installed, and a mailer (software for creating and sending / receiving an e-mail text) executed on the operating system is installed. In addition, the storage device stores a database in which data on sales is collected from terminals of individual business offices and registered for each business office, so that data on sales of individual business offices can be centrally managed. ing.
As the mail server 500, an existing mail server is used.

Next, the operation of the input data registration system having the above configuration will be described with reference to FIG. FIG.
5 is a flowchart for explaining the operation of the input data registration system. The following processing is mainly realized by a predetermined program installed in the first and second information terminals.

An employee of a business office who wants to input data on business, for example, information on a customer such as a customer name, starts a business application program on the business office terminal 100 and opens a file. The customer name, address, telephone number, order information, and the like are input as data relating to the customer (S100). Input of such data is performed through input means.

The office terminal 100 (mainly a business application program) saves the contents of the file when these inputs are completed. The business office terminal 100 describes each item (customer name, address, telephone number, order information, etc.) constituting data relating to a customer as input data in a predetermined format so that the receiving side can extract the information by computer processing. I do. For example,

[Information about the customer] is described, followed by (without line breaks) the customer name, address, telephone number, order information, etc., separated by "," and the like.

As described above, by recording the input data in a predetermined format, the head office terminal 400 that has received the attached file describing the input data can read the customer name, address, telephone number, order information, etc. Items can be extracted by computer processing.

When the saving of the file describing the input data is completed, the employee of the sales office activates the mailer at the sales office terminal 100, inputs the e-mail address of the head office, and attaches the file describing the input data. Specify it as a file and click the submit button. As a result, the electronic mail with the file describing the input data and the attached file is transmitted to the mail server 500 (S101).

In the title input field of the e-mail, an identifier (for example, an identifier such as

[Customer information file]) is input. It is preferable that the file describing the input data is encrypted to be an attached file. In the case of encryption, the data is encrypted using the code, date, password, etc. assigned to the business office.

In the head office terminal 400, a mailer is started, the mail server 500 is accessed at a preset time, and an electronic mail addressed to itself is read into the head office terminal 400 (S102). Head office terminal 400
Is the identifier (

From the attached file of the e-mail that describes [Information file about customer])

The customer name, address, telephone number, order information, etc. described after [information about customer] are extracted. In addition,
If the attached file is encrypted, it is first decoded.

As described above, the head office terminal 400 does not directly transmit and receive the input data to and from the business office terminal 100 (the business office terminals 200, 300...) (Including e-mails included as attachments). Therefore,
Even if the communication is interrupted during the reception of the e-mail to which the input data is attached, it is possible to receive the input data without any trouble by accessing the mail server 500 again. In addition, even when the communication is interrupted during the transmission of the e-mail attached with the input data, the sales office terminal 100 transmits the e-mail to the mail server 500 again to transmit the input data without any trouble. Is possible.

In particular, if a mailer is set so that reception or transmission of an e-mail fails when transmission or reception fails, communication between transmission and reception can be performed without any trouble of the sender / receiver. Even if the communication is interrupted, the input data can be transmitted and received smoothly.

The head office terminal 400 registers the customer name, address, telephone number, order information, etc. extracted from the attached file in which the input data is described in its own database.

In the above example, the file in which the input data is described has been described to be manually transmitted by the employee of the office, but the mailer is started at the office terminal 100, and at a preset time, A file in which the input data is described may be transmitted to the electronic mail address of the head office as an attached file.

[0029]

As described above, according to the present invention,
It is possible to transmit and receive data smoothly without performing a procedure for synchronization between the transmitting side and the receiving side, and even if communication is interrupted during transmission and reception.

[Brief description of the drawings]

FIG. 1 is a diagram showing a schematic system configuration of an input data registration system for explaining an embodiment of the present invention.

FIG. 2 is a diagram for explaining the operation of the input data registration system.

[Explanation of symbols]

 100 Office terminal 400 Head office terminal 500 Mail server

Claims (7)

[Claims] 1. An input data registration method for receiving an electronic mail including input data from a mail server, extracting the input data, and registering the input data in a database. 2. The database according to claim 1, wherein the input data is data relating to sales input at each sales office, and the database is a database for centrally managing data regarding sales at each sales office. Input data registration method. 3. The input data registration method according to claim 1, wherein when the reception of the electronic mail has failed, the mail server is accessed again to receive the electronic mail. 4. A first information terminal, comprising: input means for transmitting an e-mail including data input from the input means to a mail server; and a database comprising: a database, the electronic information including input data from the mail server. A second information terminal that receives the mail, extracts the input data, and registers the input data in the database. 5. The first information terminal is provided for each business office, the input data is data relating to business input at each business office, and the database is an individual business office. 5. The input data registration system according to claim 4, wherein the database is a database that centrally manages data related to sales of the business. 6. The input data registration system according to claim 4, wherein the second information terminal accesses the mail server again and receives the electronic mail when the reception of the electronic mail has failed. 7. A program for receiving an electronic mail including input data from a mail server, extracting the input data and registering the input data in a database, and causing a computer to execute the program.