JP5336065B2 - Data conversion apparatus, data conversion system, and data conversion method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To achieve a function of converting transfer data that corresponds to a certain format of an accounting system or the like used by a user into transfer data that corresponds to a fixed format for processing transfers, such as an All-Banks format, using a method that reduces load on a financial institution's server, without providing a terminal with a program exclusive for the function. <P>SOLUTION: As a preparation process prior to conversion, a data conversion server is accessed from a user terminal to create external master data in which rules for converting the format of an accounting system into an All-Banks format are set. The external master data is stored in a user terminal. During a conversion process, the external master data and transfer data corresponding to a certain format fetched from the accounting system are sent to the data conversion server. At the data conversion server, a process for converting into the All-Banks format is performed according to the external master data, and the user terminal receives the transfer data converted. Once the process is complete, the external master data and the transfer data are deleted from the data conversion server. <P>COPYRIGHT: (C)2009,JPO&amp;INPIT

Description

  The present invention relates to a transfer data conversion apparatus and transfer data for converting transfer data corresponding to an arbitrary format such as an accounting system used by a user into transfer data corresponding to a standard format for transfer processing such as a Zengin format. The present invention relates to a conversion system and a transfer data conversion method.

  Internet banking services for corporations that allow bank transactions such as transfers using office PCs when companies settle payments are widely provided. Data relating to payments to be transferred is generally output from an accounting system or the like, but transfer data created by an accounting system or the like is usually based on an arbitrary format.

  On the other hand, transfer requests using internet banking require the creation of transfer data corresponding to the Zengin format, which is a standard format used for transfers between banks. It becomes necessary to perform operations such as inputting the transfer data output from the system etc. to the input screen of Internet banking.

  In order to avoid such input work, it is necessary to automatically convert transfer data corresponding to an arbitrary format output from an accounting system or the like into transfer data corresponding to the Zengin format. As such an automatic conversion function, a method provided on either the terminal (PC) side operated by the user or the server side of a financial institution that provides Internet banking can be considered.

  In the method that has an automatic conversion function on the terminal side operated by the user, the transfer data imported from the accounting system etc. is automatically converted to the Zengin format at the terminal, and the converted transfer data is sent to a financial institution server that provides Internet banking Transmit (for example, refer to Patent Document 1). In the method of providing an automatic conversion function on the server side of a financial institution that provides Internet banking, the transfer data based on an arbitrary format imported from an accounting system or the like is directly transmitted to the server or the like of the financial institution that provides Internet banking. The transfer data automatically converted into the Zengin format is transferred to a bank transfer processing system (for example, see Patent Document 2).

JP 2005-293157 A JP 2003-006443 A

  If a system with an automatic conversion function is adopted on the terminal side operated by the user, a conversion program for automatic conversion or an arbitrary format that varies depending on the user is changed to the Zengin format on the server of the financial institution that provides Internet banking. Since it becomes unnecessary to provide mapping definition information for conversion, there is a merit that the burden on system investment on the financial institution side and the system load on conversion processing are reduced. However, the terminal on the user side must be provided with a dedicated program, which places a load on installation and update on the user side.

  On the other hand, if a method of providing an automatic conversion function on the server side of a financial institution that provides Internet banking can be avoided, the burden on the user side as described above can be avoided. In addition to a system load such as data conversion processing, the financial institution is burdened with managing individual information such as mapping definition information for each user.

  In other words, the function of automatically converting transfer data based on an arbitrary format imported from an accounting system into transfer data compatible with the Zengin format, without having a dedicated program on the terminal side, loads on the server side of financial institutions It is desirable to realize by a method that suppresses the above.

  The present invention has been made to solve such a problem, and transfer data corresponding to an arbitrary format such as an accounting system used by a user corresponds to a fixed format for transfer processing such as a Zengin format. It is an object of the present invention to provide a transfer data conversion device, a transfer data conversion system, and a transfer data conversion method for converting into transfer data.

The present invention that solves such a problem, when converting the first data based on an arbitrary format into the second data based on a predetermined format for transfer from the terminal to the data processing device, from the terminal, Definition information receiving means for receiving mapping definition information for defining a correspondence between an item in the arbitrary format and an item in the predetermined format; and the second data from the mapping definition information. Creating external master data in which a rule for converting the data to the external data is set and transmitting the external master data to the terminal; and receiving the first data and the external master data from the terminal means, in accordance with the external master data, the data conversion hand for converting said first data to said second data If, on the terminal, a data conversion apparatus and a data transmitting means for transmitting the second data. Further comprising an external master data storage means for temporarily storing the external master data received from the terminal, the data conversion means in accordance with temporarily stored outside the master data to the external master data storage unit, the first data Can be converted into the second data. The first data is first fund transfer data corresponding to an arbitrary format used by a user, and the second data is second fund transfer data corresponding to a fixed format for fund transfer processing, The mapping definition information received by the definition information receiving means includes company master information including information related to an account used by the user for funds transfer, and the external master data transmitting means is created using the company master information. The external master data may be transmitted to the terminal .

  According to the present invention, in order to perform the creation of external master data necessary for conversion of transfer data and the transfer data conversion using the external master data in the transfer data conversion apparatus, a dedicated program for executing these processes is provided on the terminal side. It becomes unnecessary. Also, the external master data created by the transfer data conversion device is sent to the terminal and received from the terminal when converting the transfer data, so that the external master data created for each user on the transfer data conversion device side Is not required, and authentication processing for using the external master data that is required when the user's external master data is stored on the transfer data conversion apparatus side can be avoided.

  In the present invention, the first transfer data generally corresponds to the format used in the user's accounting system and the like, and the second transfer data generally corresponds to the Zengin format. It is not limited to the format. Further, the second transfer data includes data for automatic account transfer accompanied by a transfer process for transferring the amount deducted from the account to a predetermined account in addition to normal transfer and general transfer.

Further, according to the present invention, when the data transmitting unit transmits the second data, the first data and the external master data received by the data receiving unit and the second data converted by the data converting unit are both It may be deleted from a storage device provided in the data converter. When the external master data transmission means transmits the external master data, both the mapping definition information received by the definition information reception means and the external master data created by the external master data transmission means are provided in the data converter. it that will be deleted from the storage device may also be characterized was.

  If configured in this way, external master data created for each user, transfer data that may contain important user information, etc. will be deleted from the transfer data conversion device. Management burden can be avoided.

Further, according to the present invention, when the data receiving means receives the first data, if the received first data meets a predetermined condition, the terminal receives an e-mail address for use in user authentication. Authentication information requesting means for requesting input of a password, authentication information receiving means for receiving an e-mail address and password input in accordance with the request from the terminal, a first address obtained by converting the e-mail address and password, and the first data. Authentication information storage means for temporarily storing the address information of the storage area allocated for authentication for receiving the second data, and when the data conversion means completes the conversion to the second data, the authentication information Conversion complete to send a notification specifying the address information associated with the email address to the email address stored in the storage means A knowledge transmitting unit, to the address terminal which receives an access to the designated storage area in the information, and the password request means for requesting a password from the terminal, when receiving the password input in accordance with the request, the and password collating means for collating the password and the authentication information storage means to the address information in association with the stored password, further wherein the data transmitting means, a match of the password is verified by the password collation means, The second data may be transmitted to the terminal.

  In this way, the email address specified by the user when the conversion is complete when the transfer data to be converted is huge due to the transfer data related to general transfer or salary transfer, etc., when the predetermined conditions are met. By configuring so that the notification is transmitted to the communication, it is possible to disconnect the communication once during the conversion process. Note that by configuring the mail address to be registered at every conversion, the management burden of individual information for each user can be avoided. In addition, by accessing an address such as an individually assigned URL and verifying a password registered in advance, the user is authenticated and the safety is improved.

Further, according to the present invention, when the data receiving means receives the first data, if the received first data meets a predetermined condition, the terminal receives an e-mail address for use in user authentication. Authentication information requesting means for requesting input of a password, authentication information receiving means for receiving an e-mail address and password input according to the request from the terminal, and the e-mail address and password as the first data or the external master Authentication information storage means temporarily associated with data, and when the data conversion means completes the conversion to the second data, a notification of completion of data conversion is sent to the mail address stored in the authentication information storage means Receiving the e-mail address and password input to the terminal from the conversion completion notification transmitting means for receiving the notification and the terminal receiving the notification. Password receiving means for a password collating means for collating the stored password the password in association with the mail address in the authentication information storage unit, further wherein the data transmission means, the password in the password collation means When the match is confirmed, the second data may be transmitted to the terminal.

  In this way, when the amount of data to be converted is huge due to transfer data related to general transfer or salary transfer, etc., when the predetermined conditions are met, notification is sent to the email address specified by the user when the conversion is completed In such a case, the communication can be temporarily disconnected during the conversion process. Note that by configuring the mail address to be registered at every conversion, the management burden of individual information for each user can be avoided. In addition, by configuring a password registered in advance to be verified, user authentication is performed to improve safety.

Further, according to the present invention, when the data transmission unit transmits the second data , the mail address and password temporarily stored in the authentication information storage unit are deleted from the storage device provided in the data conversion device. May be a feature.

  When configured in this way, external master data created for each user, transfer data that may contain important user information, e-mail addresses and passwords registered for personal authentication are deleted from the transfer data converter Therefore, the burden of managing individual information for each user can be avoided.

The present invention can also be configured as a data conversion system including the data conversion apparatus according to the present invention and a terminal operated by a user connected to the data conversion apparatus through a network.

Data conversion system according to the present invention includes: a data converter, a data conversion system comprising a terminal connected via the data conversion apparatus and a data processing device and the network, the data conversion apparatus, the based on any format When converting the data of 1 into the second data based on a predetermined format for transferring from the terminal to the data processing device, between the item in the arbitrary format and the item in the predetermined format from the terminal A definition information receiving means for receiving mapping definition information for defining a correspondence relationship between the first data and external master data in which a rule for converting the first data into the second data is set from the mapping definition information and an external master data transmission means for transmitting to said terminal, from the terminal, A serial first data and the data receiving means for receiving said external master data, in accordance with the external master data, and a data converting means for converting the first data into the second data, to the terminal, the first Data transmission means for transmitting the data of 2; and the terminal includes definition information transmission means for transmitting the mapping definition information to the data conversion apparatus; and an external master for receiving the external master data from the data conversion apparatus data receiving means, and a data transmitting means for transmitting the first data and the external master data to the data conversion device, from the data conversion apparatus, a data receiving means for receiving the second data, the first And a data transfer unit for transferring the second data to the data processing device . The data conversion device further includes external master data storage means for temporarily storing the external master data received from the terminal, and the data conversion means stores the external master data temporarily stored in the external master data storage means. according to the defined criteria, the converted first data to said second data, said terminal further comprising an external master data storage means for storing the external master data the external master data receiving means receives, The data transmission means may transmit the external master data read from the external master data storage means. In the data conversion apparatus, the first data is first fund transfer data corresponding to an arbitrary format used by a user, and the second data is a second fund transfer data corresponding to a fixed format for fund transfer processing. The mapping definition information received by the definition information receiving means is movement master data including company master information including information relating to an account used by the user for funds transfer, and the external master data transmission means is the company master information. External master data created using information may be transmitted to the terminal .

In the data conversion system according to the present invention, in the data conversion apparatus, when the data transmission unit transmits the second data, the first data and the external master data received by the data reception unit , the data conversion unit Any of the second data converted by can be deleted from the storage device provided in the data conversion device. When the external master data transmission means transmits the external master data, both the mapping definition information received by the definition information reception means and the external master data created by the external master data transmission means are provided in the data converter. it that will be deleted from the storage device may also be characterized was.

Furthermore, in the data conversion system according to the present invention, when the data receiving unit receives the first data, the data conversion device sends a request to the terminal when the received first data meets a predetermined condition. Authentication information requesting means for requesting input of a mail address and password for use in user authentication, authentication information receiving means for receiving a mail address and password input in accordance with the request from the terminal, and the mail address Authentication information storage means for temporarily storing a password in association with the first data or the external master data, and mail stored in the authentication information storage means when the data conversion means completes conversion to the second data A conversion completion notification transmitting means for transmitting a data conversion completion notification to the address, and a terminal receiving the notification from the terminal Further comprising a password receiving means for receiving the input email address and password to the terminal, and password collating means for collating the stored password the password in association with the mail address in the authentication information storage unit, wherein the data The transmission unit may transmit the second data to the terminal when the password verification unit confirms that the password matches.

Furthermore, in the data conversion system according to the present invention, when the data receiving unit receives the first data, the data conversion device sends a request to the terminal when the received first data meets a predetermined condition. Authentication information requesting means for requesting input of a mail address and password for use in user authentication, authentication information receiving means for receiving a mail address and password input in accordance with the request from the terminal, and the mail address Authentication information storage means for temporarily storing a password in association with the first data or the external master data, and mail stored in the authentication information storage means when the data conversion means completes conversion to the second data A conversion completion notification transmitting means for transmitting a data conversion completion notification to the address, and a terminal receiving the notification from the terminal Further comprising a password receiving means for receiving the input email address and password to the terminal, and password collating means for collating the stored password the password in association with the mail address in the authentication information storage unit, wherein the data The transmission unit may transmit the second data to the terminal when the password verification unit confirms that the password matches.

Further, the data conversion system according to the present invention, in the data conversion apparatus, when the data transmitting unit transmits the second data, the authentication information storage unit in the temporary storage mail address and password, the data conversion device It may be deleted from the storage device provided in the.

The present invention can also be specified as a data conversion method executed by the data conversion apparatus or data conversion system according to the present invention.

Data conversion method according to the present invention, the data conversion device, hit to convert the first data based on any format, the second data based on a predetermined format to be transferred to the data processing apparatus from the terminal, the A definition information receiving step for receiving mapping definition information that defines a correspondence between an item in the arbitrary format and an item in the predetermined format from the terminal, and the data conversion device, from the mapping definition information, Creating external master data in which a rule for converting the first data into the second data is set , and transmitting the master data to the terminal; and the data converter from the terminal, a data receiving step of receiving said external master data and the first data, the data conversion Location is in accordance with the external master data, and a data converting step of converting the first data into the second data, the data conversion device, to the terminal, and a data transmission step of transmitting the second data , A data conversion method. The data conversion device further includes an external master data storage step for temporarily storing the external master data received from the terminal in a storage device. In the data conversion step, the storage is performed in the external master data storage step. The first data may be converted into the second data in accordance with external master data temporarily stored in the apparatus. The first data is first fund transfer data corresponding to an arbitrary format used by a user, and the second data is second fund transfer data corresponding to a fixed format for fund transfer processing, The mapping definition information received in the definition information receiving step includes company master information including information related to an account used by the user for funds transfer, and is created using the company master information in the external master data transmitting step. The external master data may be transmitted to the terminal .

A data conversion method according to the present invention provides a data conversion device and a predetermined format for a terminal connected to the data processing device through a network to transfer first data based on an arbitrary format from the terminal to the data processing device. A definition information transmission step of transmitting mapping definition information for defining a correspondence relationship between an item in the arbitrary format and an item in the predetermined format to the second data based on the data conversion device; A definition information receiving step in which the data conversion device receives the mapping definition information from the terminal; and the data conversion device converts the first data into the second data from the mapping definition information. create an external master data set the rules for the transmission to the terminal And external master data transmitting step that, the terminal, and the external master data receiving step of receiving the external master data from the data conversion apparatus, the terminal, the data conversion of the first data and the external master data A data transmission step for transmitting to the device, a data receiving step for the data conversion device to receive the first data and the external master data from the terminal, and the data conversion device according to the external master data, A data conversion step for converting the first data into the second data; a data transmission step for the data conversion device to transmit the second data to the terminal; and the terminal for the data conversion device. from a data receiving step of receiving the second data, the terminal, the said second data data A data transfer step of transferring to the processing unit, a data conversion method having. The terminal further includes an external master data storage step of storing external master data received from the data conversion device in a storage device, and the terminal transmits the data conversion device to the data conversion device from the storage device in the data transmission step. It sends the read external master data, the data conversion apparatus, the further have an external master data storage step of temporarily stored in the storage device the external master data received from the terminal, in the data conversion step, The first data may be converted into the second data according to the external master data temporarily stored in the storage device in the external master data storing step. The first data is first fund transfer data corresponding to an arbitrary format used by a user, and the second data is second fund transfer data corresponding to a fixed format for fund transfer processing, The mapping definition information received in the definition information receiving step includes company master information including information related to an account used by the user for funds transfer, and is created using the company master information in the external master data transmitting step. The external master data may be transmitted to the terminal .

In the data conversion method according to the present invention, when the data conversion device transmits the second data in the data transmission step, the first data received in the data reception step and the external master data , the data conversion step It is also possible to include a step of deleting the second data converted in step (2) from the storage device provided in the data conversion device. When the external master data is transmitted in the external master data transmission step, both the mapping definition information received in the definition information reception step and the external master data transmitted in the external master data transmission step are provided in the data converter. It can also be characterized by having a step of deleting from the storage device.

Furthermore, the data conversion method according to the present invention is such that, when the data converter receives the first data in the data receiving step, the received data is matched with the terminal if the received first data meets a predetermined condition. An authentication information requesting step for requesting input of an e-mail address and a password to be used for authentication of the user, and reception of authentication information from which the data converter receives an e-mail address and a password input in accordance with the request from the terminal The data conversion device temporarily associates the mail address, the password, and the address information of the storage area allocated for authentication to receive the second data converted from the first data, into the storage device. An authentication information storage step for storing, and the data conversion device converts the second data into the data conversion step. Upon completion of the conversion, to the email address stored in the storage device, a conversion completion notification transmission step of transmitting a notification specifying the address information the associated email address, the data conversion device, designated in the address information A password requesting step for requesting the terminal that has received access to the stored storage area to input a password; and when the data converter receives a password input in accordance with the request from the terminal, the password is stored in the memory A password verification step for verifying a password stored in association with the address information in the device, and in the data transmission step, the data conversion device confirms that the password matches in the password verification step; Transmitting the second data to the terminal; It may be characterized.

Furthermore, the data conversion method according to the present invention is such that, when the data converter receives the first data in the data receiving step, the received data is matched with the terminal if the received first data meets a predetermined condition. An authentication information requesting step for requesting input of an e-mail address and a password to be used for authentication of the user, and reception of authentication information from which the data converter receives an e-mail address and a password input in accordance with the request from the terminal An authentication information storage step in which the data conversion device temporarily stores the mail address and password in a storage device in association with the first data or the external master data; and the data conversion device performs the data conversion step. When the conversion to the second data is completed, the mail address stored in the storage device A conversion completion notification transmission step for transmitting a notification of completion of data conversion; a password reception step for receiving an e-mail address and a password input to the terminal from the terminal where the data conversion device has received the notification; The data conversion device further includes a password verification step of verifying the password with a password stored in association with the mail address in the storage device, and in the data transmission step, the data conversion device includes the password verification step When the password match is confirmed, the second data may be transmitted to the terminal.

Further, the data conversion method according to the present invention, the data conversion device, sending second data in the data transmission step, the temporarily stored email address and password in the storage device, provided in the data conversion device A step of deleting from the stored storage device.

  According to the present invention, a function for converting transfer data corresponding to an arbitrary format such as an accounting system used by a user into transfer data corresponding to a standard format for transfer processing such as a Zengin format is provided on the terminal side. Therefore, it is possible to provide a transfer data conversion method that is highly convenient and secure.

  The best mode for carrying out the present invention will be described below in detail with reference to the drawings. In addition, the following description illustrates embodiment of this invention, Comprising: This invention is not limited to this embodiment.

  FIG. 1 is a diagram showing an embodiment of a transfer data conversion system according to the present invention. FIG. 2 is a block diagram showing the configuration of the transfer data conversion system according to the present invention. 3 and 4 are first and second diagrams, respectively, showing the flow of external master data creation by the transfer data conversion system according to the present invention. FIGS. 5-7 is the 1st-3rd figure which respectively shows the flow in 1st Embodiment of the transfer data conversion by the transfer data conversion system concerning this invention. FIGS. 8-11 is the 1st-4th figure which respectively shows the flow in 2nd Embodiment of the transfer data conversion by the transfer data conversion system concerning this invention. FIG. 12 is a diagram showing an example of company master information used in the transfer data conversion system according to the present invention. FIG. 13 is a diagram showing an example of mapping definition information used in the transfer data conversion system according to the present invention. FIG. 14 is a diagram showing an example of transfer data corresponding to the Zengin format used in the transfer data conversion system according to the present invention. FIG. 15 is a diagram showing an example of external master data used in the transfer data conversion system according to the present invention.

  The configuration of the transfer data conversion system and the transfer data conversion procedure according to the present invention will be described with reference to FIG. The user's accounting system manages data related to business-related expenditures, salary and tax payments, etc. In order to make payments by bank transfer (including automatic account transfers) before the due date arrives, Create transfer data corresponding to any format adopted by the system. A user terminal such as a personal computer that can be connected to the Internet takes in these transfer data from the accounting system. The function of the accounting system may be provided in the user terminal.

  Transfer data for making payments must be sent to a bank server, which is a Web server for providing Internet banking services. Transfer data accepted by a bank host computer is in a common format between banks. Since it is necessary to support a certain Zengin format, transfer data corresponding to an arbitrary format taken in from the accounting system cannot be transmitted as it is. Therefore, before sending the transfer data to the bank server, the transfer data corresponding to an arbitrary format taken from the accounting system is sent to the data conversion server, and the transfer data converted into the Zengin format is received. By configuring the data conversion server to perform conversion to the Zengin format, a dedicated program for data conversion or the like is not required in the user terminal.

  The data conversion server is a Web server accessible via the Internet. As a preparation step for performing data conversion, the user accesses the data conversion server and creates external master data in which a rule for converting the format of the accounting system to the Zengin format is set. By transmitting the created external master data to the user terminal, storing it on the user terminal side, and configuring the data conversion server not to store the external master data set for each user, the data conversion server side It becomes unnecessary to manage data set for each user.

  When accessing the data conversion server to convert the transfer data from the user terminal, send the external master data created in advance to the data conversion server together with the transfer data corresponding to any format imported from the accounting system To do. The data conversion server converts the transfer data based on the rules set in the external master data, and transmits the transfer data corresponding to the converted Zengin format to the user terminal. By deleting the external master data used for conversion and the transfer data before and after conversion from the data conversion server, the data conversion server does not need to manage data used for each user. The user terminal that has received the transfer data corresponding to the Zengin format transmits the transfer data corresponding to the Zengin format to the bank server using Internet banking.

  In FIG. 2, the transfer data conversion system according to the present invention includes a user terminal 10 such as a personal computer connectable to the Internet and a data conversion server 30 connected to the Internet. The user who wants to make a transfer request to the bank converts the transfer data corresponding to an arbitrary format acquired from the accounting system 20 into the transfer data corresponding to the Zengin format by accessing the data conversion server 30 from the user terminal 10, The converted transfer data is transmitted from the user terminal 10 to the bank server 40 using Internet banking.

  The user terminal 10 is a computer including at least a CPU, a main memory, and an HDD, and includes a web browser 11, an external master data storage unit 12, and a transfer data capture unit 13. The Web browser 11 is stored in the HDD, and is read out when accessing the Web server by connecting to the Internet, and necessary processing is executed by performing arithmetic processing with the CPU while the main memory or the like functions as a working area. Is done. The external master data storage unit 12 corresponds to a storage area of the HDD for storing the external master data created by the data conversion server 30. The transfer data fetching unit 13 is functionally specified, and reads the application program stored in the HDD and performs the arithmetic processing by the CPU while causing the main memory or the like to function as a working area. Is realized.

  The configuration of the accounting system 20 is not particularly limited. However, in the case where the accounting system 20 is configured by a computer different from the user terminal 10, the accounting system 20 is connected to the user terminal 10 through a network such as a LAN and is created in the accounting system 20. The transfer data corresponding to the format is taken into the user terminal 10 by the function of the transfer data take-in unit 13 and transmitted to the data conversion server 30 for conversion processing.

  Alternatively, the accounting system 20 may be configured as a partial function of the user terminal 10. In that case, the HDD of the user terminal 10 stores a program corresponding to the accounting system and transfer data corresponding to an arbitrary format created by the program, and when the transfer data capturing unit 13 is activated, the transfer data Is read into the main memory or the like and transmitted to the data conversion server 30 for conversion processing.

  The data conversion server 30 is a computer that functions as a Web server including at least a CPU, a main memory, and an HDD. The data conversion server 30 may be functionally included in the same computer as the bank server 40, which is a Web server that provides Internet banking services, but operates in a configuration that does not need to retain user information or the like. To do this, it is preferable to use computers with different domains.

  The external master data creation unit 31, the external master data reception unit 32, the transfer data creation unit 34, and the authentication control unit 35 included in the data conversion server 30 are all functionally specified. Operations related to creation and reception, creation of transfer data, and user authentication processing are performed by the CPU while reading the application program corresponding to each stored in the HDD and causing the main memory or the like to function as a working area. Is executed by. A predetermined storage area of the HDD is allocated to the external master data storage unit 33.

  The bank server 40 is a computer that functions as a Web server including at least a CPU, a main memory, and an HDD. The bank server 40 is a Web server for providing Internet banking services, but the transfer data reception unit 41 is functionally specified and receives transfer data corresponding to the Zengin format from the user terminal 10. The operation for this is executed by reading out an application program corresponding to each stored in the HDD and performing arithmetic processing by the CPU while causing the main memory or the like to function as a working area. The transfer data received by the bank server 40 is delivered to a bank host computer that executes the transfer process.

  A flow for creating external master data by the transfer data conversion system according to the present invention will be described with reference to FIGS. External master data is master data that sets rules for converting transfer data corresponding to any format of the accounting system used by the user into transfer data compatible with the Zengin format. It is created for each accounting system format. For example, if the transfer data created by a user's accounting system has four types of formats: general transfer, salary / bonus transfer, special collection local tax, and automatic account transfer, there are four external formats corresponding to each. Master data is created.

  As advance preparation for making a transfer request, as shown in FIG. 3, the user activates the Web browser 11 on the user terminal 10, presses a link or the like pasted on the Internet banking screen, and passes through the Internet. Then, the data conversion server 30 is accessed (1-1). The data conversion server 30 includes company master information including information related to a withdrawal account used by the company serving as the transfer requester to withdraw the transfer amount, and transfer data corresponding to an arbitrary format of the accounting system used by the user. An HTML file or the like that displays a screen for registering mapping definition information that defines the correspondence of items included in each transfer data corresponding to the Zengin format is transmitted, and a registration screen is displayed on the user terminal 10 (1-2).

  Subsequently, as shown in FIG. 4, the user operates the user terminal 10, and the user inputs the company master information and the mapping definition information from the form displayed on the registration screen of the company master information and the mapping definition information. . The input company master information and mapping definition information are uploaded to the data conversion server 30 (1-3).

  FIG. 12 shows an example of the company master information, but the contract No. that can identify the user is shown. And information related to the withdrawal account that the user uses to withdraw the transfer amount.

  FIG. 13 shows an example of mapping definition information. Each item included in the transfer data corresponding to the Zengin format corresponds to an arbitrary format created by the accounting system used by the user. Which part of the transfer data corresponds to, for example, if the transfer data is created in text, if the number of bytes of the data position that is the start point and end point of each item is created in the CSV file The number of items separated by commas is specified. These designations require the user to input from the mapping definition information registration screen, but the user terminal may be equipped with a program that automatically reads from the accounting system definition file to automatically create the mapping definition information. Good.

  In the data conversion server 30 that has received the company master information and the mapping definition information input to the user terminal 10, the external master data creation unit 31 is activated, and the accounting used by the user from the company master information and the mapping definition information. External master data in which a rule for converting transfer data corresponding to an arbitrary format of the system into transfer data corresponding to the Zengin format is created (1-4).

  FIG. 14 shows an example of transfer data corresponding to the Zengin format. In order to convert transfer data corresponding to an arbitrary format into such a format, for example, as shown in FIG. External master data is created. In the example of FIG. 15, among the necessary items in the Zengin format, fixed information such as the transfer requester's account number and name is acquired from the company master information, and information on the transfer destination and transfer amount depending on the transfer data is as follows: The position of data in which the corresponding item is specified in an arbitrary format is acquired from the mapping definition information and specified.

  The external master data created in this way is downloaded to the user terminal 10 (1-5) and stored in the external master data storage unit 12 provided in the HDD of the user terminal 10 (1-6). Here, when creating external master data corresponding to a plurality of formats such as general transfer, salary / bonus transfer, etc., an identifier for identifying each external master data is added and stored. The external master data stored in the external master data storage unit 12 is reused every time a transfer data conversion process is requested unless the accounting system or the Zengin format is changed.

  On the other hand, in the data conversion server 30 that has transmitted the external master data, the company master information and mapping definition information received from the user terminal 10 and the external master data created from these data are processed by the external master data creation unit 31. Delete from the memory area used as a working area. In this way, by configuring the external master data necessary for conversion of transfer data to be stored on the user terminal 10 side, it is not necessary to manage user-specific information on the data conversion server 30 side.

  The flow in the first embodiment of transfer data conversion by the transfer data conversion system according to the present invention will be described with reference to FIGS. In the first embodiment, transfer data is transferred while maintaining the connection between the user terminal 10 and the data conversion server 30 in the same session, which is suitable when the number of transfer data to be converted is relatively small.

  As shown in FIG. 5, a user who wants to make a transfer request by Internet banking or the like starts up the Web browser 11 on the user terminal 10 and presses a link or the like pasted on the Internet banking screen, via the Internet. Then, the data conversion server 30 is accessed (2-1). The data conversion server 30 transmits an HTML file or the like that displays a screen requesting the user to upload the external master data used for the transfer data conversion, and causes the user terminal 10 to display an external master data reception screen ( 2-2).

  Subsequently, as shown in FIG. 6, the user terminal 10 reads external master data corresponding to the type of transfer (general transfer, salary / bonus transfer, etc.) from the external master data storage unit 12 of the HDD (2- 3) Upload to the data conversion server 30 (2-4). Here, the method of reading the external master data is not particularly limited, and the user may select a corresponding file and designate it on the reception screen for the external master data, or may be determined by a program for searching for the corresponding file. You may comprise so that it may be designated automatically.

  The data conversion server 30 that has received the external master data activates the external master data reception unit 32 and temporarily stores the external master data in the external master data storage unit 33 that is a predetermined area of the memory of the data conversion server 30 ( 2-5). Further, an HTML file or the like that displays a screen requesting upload of transfer data corresponding to an arbitrary format created by the user's accounting system or the like is transmitted, and a transfer data reception screen is displayed on the user terminal 10 (2- 6).

  Subsequently, as shown in FIG. 7, the user terminal 10 reads transfer data corresponding to an arbitrary format previously fetched from the user's accounting system or the like from the HDD and uploads it to the data conversion server 30 (2- 7). Here, the method of reading the transfer data is not particularly limited, and the user may select a corresponding file and specify it on the transfer data reception screen, or automatically by a program for searching for the corresponding file. You may comprise so that it may be designated.

  In the data conversion server 30 that has received the transfer data corresponding to an arbitrary format, the transfer data creation unit 34 is activated to capture all the transfer data uploaded from the user terminal 10 (2-8), and to an arbitrary format. The corresponding transfer data is converted according to the rules set in the external master data temporarily stored in the external master data storage unit 33 (2-9), and transfer data corresponding to the Zengin format is created (2-10). ).

  The transfer data corresponding to the Zengin format created in this way is downloaded from the data conversion server 30 to the user terminal 10 (2-11), stored in the HDD of the user terminal 10 and stored (2-12). ). In the user terminal 10, the transfer data corresponding to the Zengin format can be used as it is for a transfer request in Internet banking or the like. However, the transfer of the transfer request to the bank server 40 is other than the user terminal 10 that has transferred the data. It may be performed from another terminal.

  On the other hand, in the data conversion server 30 that transmitted the transfer data corresponding to the Zengin format, the transfer data corresponding to an arbitrary format received from the user terminal 10, the external master data temporarily stored in the external master data storage unit 33, the conversion The transfer data corresponding to the Zengin format created in this way is deleted from the memory area (main memory or virtualized memory area of the HDD) used as a working area for the arithmetic processing by the transfer data creation unit 34. As described above, when the conversion of the transfer data is completed, the data used for the conversion is deleted, so that it is not necessary to manage user-specific information on the data conversion server 30 side.

  The flow in the second embodiment of transfer data conversion by the transfer data conversion system according to the present invention will be described with reference to FIGS. In the second embodiment, after uploading the transfer data from the user terminal 10 to the data conversion server 30, the session is temporarily disconnected, the transfer of the transfer data is notified by notifying that the conversion of the transfer data has been completed, This is suitable when the number of transfer data to be converted is relatively large.

  Also in the second embodiment, the data conversion server 30 is accessed, external master data is transmitted from the user terminal 10, the external master data is temporarily stored in the external master data storage unit 33, and the transfer of the transfer data to the user terminal 10 is accepted. Operations until the screen is displayed (FIGS. 5 to 6) are the same as those in the first embodiment.

  Subsequently, as shown in FIG. 8, in the user terminal 10, as in the first embodiment (FIG. 7), the transfer data corresponding to an arbitrary format is read from the HDD and uploaded to the data conversion server 30. (3-7). Further, in the data conversion server 30 that has received the transfer data corresponding to an arbitrary format, the transfer data creation unit 34 is activated, and all the transfer data uploaded from the user terminal 10 is acquired and the number of transfer data is confirmed ( 3-8). If the transfer data exceeds a certain number, the registration screen for the email address and authentication password for notifying the completion of the conversion process is displayed on the user terminal 10, and the email address and password specified by the user are registered. (3-9).

  Note that if the transfer data does not exceed a certain number, the conversion process may take a relatively short time. Therefore, as with the first embodiment, request registration of an email address and password. Instead, the conversion process proceeds while the connection with the user terminal 10 is continued.

  For the mail address and password received from the user terminal 10, a unique URL on the data conversion server 30 for access when the converted transfer data is received is assigned by the operation of the authentication processing unit 35, and these are set as conversion targets. Memory areas such as transfer data and external master data to be referred to at the time of conversion, which are temporarily stored in association with memory information that can identify the unit of work of the conversion process (3-10) . In addition, about the password used for personal authentication here, it is good also as notifying the user terminal 10 of the password issued at random by the authentication process part 35. FIG.

  As shown in FIG. 9, the transfer data corresponding to the imported arbitrary format is converted according to the rules set in the external master data temporarily stored in the external master data storage unit 33 by the operation of the transfer data creation unit 34. (3-11), transfer data corresponding to the Zengin format is created (3-12). When the creation of the transfer data corresponding to the Zengin format is completed, a conversion processing completion notice is sent by e-mail to the mail address associated with the memory information of the completed conversion processing (3-13). In this completion notification, a URL stored in association with the mail address is designated.

  Note that the user terminal 10 that receives the completion notification is normally the same terminal as the user terminal 10 that uploaded the transfer data, but the completion notification is for sending the transfer data to a different bank server 40. It may be received by the terminal.

  Subsequently, as illustrated in FIG. 10, the user terminal 10 that has received the notification of the completion of the conversion process accesses the data conversion server 30 by pressing the URL link specified in the e-mail. When the URL is accessed, a password input screen is displayed on the user terminal 10, and the user inputs and transmits the password specified at the time of e-mail address registration (3-14). The data conversion server 30 that has received the password authenticates the user by comparing with the password temporarily stored in association with the accessed URL by the operation of the authentication processing unit 35 (3-15).

  If the two match, as shown in FIG. 11, the transfer data corresponding to the Zengin format for which the conversion process corresponding to the memory information associated with the accessed URL (or the input password) has been completed is specified, and the user It is downloaded to the terminal 10 (3-16), and stored and saved in the HDD of the user terminal 10 (3-17). In the user terminal 10, the transfer data corresponding to the Zengin format can be used as it is for a transfer request in Internet banking or the like. However, the transfer of the transfer request to the bank server 40 is other than the user terminal 10 that has transferred the data. Similar to the first embodiment, it may be performed from another terminal.

  In the second embodiment described above, the converted transfer data is accessed and received by a unique URL assigned for each conversion process. However, a common URL may be designated as the accessed URL. In this case, a common URL is specified in the completion notification, and when the URL is accessed, an e-mail address and password input screen is displayed. The data conversion server that has received the input mail address and password confirms whether there is a combination of the mail address and password stored in the memory area and authenticates the user.

  In the data conversion server 30 that has transmitted the transfer data corresponding to the Zengin format, the transfer data corresponding to an arbitrary format received from the user terminal 10, the external master data temporarily stored in the external master data storage unit 33, the conversion The transfer data corresponding to the Zengin format created in this way is deleted from the memory area used as a working area for the arithmetic processing by the transfer data creation unit 34, as in the first embodiment. In the second embodiment, the e-mail address and password are also deleted. As described above, when the conversion of the transfer data is completed, the data used for the conversion is deleted, so that it is not necessary to manage user-specific information on the data conversion server 30 side. Note that the assigned URLs may be stored for a certain period in order to avoid duplicating assignments.

  According to the above configuration, the user terminal 10 does not need to be provided with a dedicated program for conversion processing, and the data conversion server 30 supports any format while avoiding managing user-specific information. The transferred data can be converted into transfer data corresponding to the Zengin format.

It is a figure which shows embodiment of the transfer data conversion system concerning this invention. It is a block diagram which shows the structure of the transfer data conversion system concerning this invention. It is a 1st figure which shows the flow of external master data creation by the transfer data conversion system concerning this invention. It is a 2nd figure which shows the flow of external master data creation by the transfer data conversion system concerning this invention. It is a 1st figure which shows the flow in 1st Embodiment of the transfer data conversion by the transfer data conversion system concerning this invention. It is a 2nd figure which shows the flow in 1st Embodiment of the transfer data conversion by the transfer data conversion system concerning this invention. It is a 3rd figure which shows the flow in 1st Embodiment of the transfer data conversion by the transfer data conversion system concerning this invention. It is a 1st figure which shows the flow in 2nd Embodiment of the transfer data conversion by the transfer data conversion system concerning this invention. It is a 2nd figure which shows the flow in 2nd Embodiment of the transfer data conversion by the transfer data conversion system concerning this invention. It is a 3rd figure which shows the flow in 2nd Embodiment of the transfer data conversion by the transfer data conversion system concerning this invention. It is a 4th figure which shows the flow in 2nd Embodiment of the transfer data conversion by the transfer data conversion system concerning this invention. It is a figure which shows an example of the company master information used in the transfer data conversion system concerning this invention. It is a figure which shows an example of the mapping definition information used in the transfer data conversion system concerning this invention. It is a figure which shows an example of the transfer data corresponding to the all silver format used in the transfer data conversion system concerning this invention. It is a figure which shows an example of the external master data used in the transfer data conversion system concerning this invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 User terminal 11 Web browser 12 External master data storage part 13 Transfer data acquisition part 20 Accounting system 30 Data conversion server 31 External master data creation part 32 External master data reception part 33 External master data storage part 34 Transfer data creation part 35 Authentication Control unit 40 Bank server 41 Transfer data reception unit

Claims (12)

In converting the first data based on an arbitrary format into the second data based on a predetermined format for transfer from the terminal to the data processing apparatus, the terminal and the item in the arbitrary format and the predetermined format are converted from the terminal. Definition information receiving means for receiving mapping definition information that defines the correspondence between items in
External master data transmitting means for creating external master data in which a rule for converting the first data into the second data is set from the mapping definition information, and transmitting to the terminal;
Data receiving means for receiving the first data and the external master data from the terminal;
Data conversion means for converting the first data into the second data according to the external master data ;
Data transmitting means for transmitting the second data to the terminal;
A data conversion device comprising: Further comprising an external master data storage means for temporarily storing the external master data received from the terminal,
The data conversion device according to claim 1, wherein the data conversion means converts the first data into the second data in accordance with external master data temporarily stored in the external master data storage means. The first data is first fund transfer data corresponding to an arbitrary format used by a user, and the second data is second fund transfer data corresponding to a fixed format for fund transfer processing,
The mapping definition information received by the definition information receiving means includes company master information including information on an account used by the user for funds transfer,
The data conversion device according to claim 1 or 2, wherein the external master data transmission means transmits external master data created using the company master information to the terminal . When the data transmitting means transmits the second data, the first data and the external master data received by the data receiving means, and the second data converted by the data converting means are all provided in the data conversion apparatus. 4. The data conversion device according to claim 1, wherein the data conversion device is deleted from the stored storage device. When the external master data transmission means transmits the external master data, both the mapping definition information received by the definition information reception means and the external master data created by the external master data transmission means are provided in the data converter. data conversion apparatus according to any one of claims 1 to 4 Ru is removed from the storage apparatus. When the data receiving means receives the first data, if the received first data meets a predetermined condition, the terminal is requested to input an e-mail address and a password used for user authentication. An authentication information requesting means;
Authentication information receiving means for receiving an e-mail address and password input according to the request from the terminal;
Authentication information storage means for temporarily storing the mail address and password in association with address information of a storage area allocated for authentication to receive second data obtained by converting the first data;
When the data conversion means completes the conversion to the second data, a conversion completion notice transmission means for sending a notification designating the address information associated with the mail address to the mail address stored in the authentication information storage means When,
Password request means for requesting input of a password to a terminal that has received access to the storage area specified in the address information ;
When receiving a password input according to the request from the terminal, a password verification unit that verifies the password against a password stored in association with the address information in the authentication information storage unit;
Further comprising
6. The data conversion apparatus according to claim 1, wherein the data transmission unit transmits the second data to the terminal when the password matching unit confirms the password match. When the data receiving means receives the first data, if the received first data meets a predetermined condition, the terminal is requested to input an e-mail address and a password used for user authentication. An authentication information requesting means;
Authentication information receiving means for receiving an e-mail address and password input according to the request from the terminal;
Authentication information storage means for temporarily storing the email address and password in association with the first data or the external master data;
When the data conversion unit completes the conversion to the second data, a conversion completion notification transmission unit that transmits a data conversion completion notification to the mail address stored in the authentication information storage unit;
Password receiving means for receiving an e-mail address and password input to the terminal from the terminal that has received the notification;
Password verification means for verifying the password against the password stored in association with the email address in the authentication information storage means;
Further comprising
6. The data conversion apparatus according to claim 1, wherein the data transmission unit transmits the second data to the terminal when the password matching unit confirms the password match.   The email address and password temporarily stored in the authentication information storage unit are deleted from a storage device provided in the data conversion device when the data transmission unit transmits the second data. Data conversion device. A data converter, a data conversion system comprising a terminal connected via the data conversion apparatus and a data processing device and the network,
The data converter is
In converting the first data based on an arbitrary format into the second data based on a predetermined format for transfer from the terminal to the data processing device, the terminal and the items in the arbitrary format and the predetermined data Definition information receiving means for receiving mapping definition information that defines the correspondence between items in the format ;
External master data transmitting means for creating external master data in which a rule for converting the first data into the second data is set from the mapping definition information, and transmitting to the terminal;
Data receiving means for receiving the first data and the external master data from the terminal;
Data conversion means for converting the first data into the second data according to the external master data ;
Data transmitting means for transmitting the second data to the terminal;
With
The terminal
Definition information transmitting means for transmitting the mapping definition information to the data converter;
External master data receiving means for receiving the external master data from the data converter;
Data transmission means for transmitting the first data and the external master data to the data converter;
Data receiving means for receiving the second data from the data converter;
Data transfer means for transferring the second data to the data processing device;
A data conversion system comprising: The data converter is
Further comprising an external master data storage means for temporarily storing the external master data received from the terminal,
The data conversion means converts the first data into the second data according to a condition defined in the external master data temporarily stored in the external master data storage means,
The terminal
Further comprising an external master data storage means for storing the external master data the external master data receiving means receives,
The data conversion system according to claim 9 , wherein the data transmission unit transmits external master data read from the external master data storage unit. When the data conversion apparatus converts the first data based on an arbitrary format into the second data based on a predetermined format for transfer from the terminal to the data processing apparatus, the terminal converts the item in the arbitrary format from the terminal. A definition information receiving step for receiving mapping definition information that defines a correspondence relationship between an item and an item in the predetermined format ;
An external master data transmission step in which the data conversion device creates external master data in which a rule for converting the first data into the second data is set from the mapping definition information, and transmits the external master data to the terminal ; ,
A data receiving step in which the data converter receives the first data and the external master data from the terminal;
A data conversion step in which the data converter converts the first data into the second data according to the external master data ;
A data transmission step in which the data converter transmits the second data to the terminal;
A data conversion method. A terminal connected to the data conversion device and the data processing device through a network converts first data based on an arbitrary format into second data based on a predetermined format for transferring from the terminal to the data processing device. A definition information transmission step for transmitting mapping definition information that defines the correspondence between the item in the arbitrary format and the item in the predetermined format to the data conversion device;
A definition information receiving step in which the data conversion device receives the mapping definition information from the terminal;
An external master data transmission step in which the data conversion device creates external master data in which a rule for converting the first data into the second data is set from the mapping definition information, and transmits the external master data to the terminal ; ,
An external master data receiving step in which the terminal receives the external master data from the data converter;
A data transmission step in which the terminal transmits the first data and the external master data to the data converter;
A data receiving step in which the data converter receives the first data and the external master data from the terminal;
A data conversion step in which the data converter converts the first data into the second data according to the external master data ;
A data transmission step in which the data converter transmits the second data to the terminal;
A data receiving step in which the terminal receives the second data from the data converter;
A data transfer step in which the terminal transfers the second data to the data processing device;
A data conversion method.