JP2002108665A - Electronic data distribution system and data base/tag format data conversion interface and tag name/cell name conversion interface and cell data writing interface and electronic data distribution method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To distribute necessary data in a data base from the server device 2 side of a center by converting the data into a tag format data file common to each client device according to a fixed conversion system so that the data can be converted into data corresponding to a slip in a unique format, and written at each client device side. SOLUTION: In this system in which plural client devices 4 are connected through a data transmission line 3 to a server device 2, data in a data base are converted into a common tag format data file, and distributed from the server device side to each client device, and the necessary data are written in the pertinent cell address of a slip in a unique format prepared by each client device in a drag-and-drop system from the tag format data file.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to an electronic data distribution system, a database / tag format data conversion interface, a tag name / cell name conversion interface, a cell data writing interface, and an electronic data distribution method.

[0002]

2. Description of the Related Art Conventionally, a server device converts customer information, product information, company organization information, etc., stored in a database device of a data center into a data file of a predetermined format and utilizes a dedicated line or a public line. The data is transmitted to the client device at each branch, and the client device picks up necessary data from the received data file,
2. Description of the Related Art There is known an electronic slip creation system which automatically writes a slip of a predetermined format in a predetermined cell of a slip and creates a slip or a slip.

[0003]

However, in the case of such a conventional electronic voucher creation system, the data file converted on the server device side is a voucher or a voucher of a predetermined format already created by the spreadsheet application. However, since the data specifies the cell address of the write destination in advance so that the cell address is written to the determined cell address, it is not possible to create a slip or a report in a different format for each branch.
Conversely, when a slip or a report in a different format is created for each branch office, the data written therein cannot be easily collected in the database device of the data center.

[0004] However, there are many requests to change slips and forms into unique formats suited to the regional characteristics of each branch office, and when many related companies use a common database, there is a need for each company. There are many requests to use original slips and forms, but the conventional electronic slip creation system could not flexibly respond to such requests. Therefore, if there is a request to create a slip or form in a unique format, the center will create a slip or form in a format that reflects the request, pass it to the requester, and perform data conversion corresponding to that format. In addition, the data conversion interface must be created for each different format on the server device side, and there is a problem that an excessive burden is imposed on the system administrator.

The present invention has been made in view of such a conventional problem. Even if each client creates a slip or form in a unique format, it is required from the server device at the center. By distributing data to each client device in accordance with a certain conversion method, each client device can convert the data into data in a unique format of slips and forms and automatically write it. Even if each client device writes data using a unique form or form, the center server device collects data from each client device in a unified format and automatically registers it in the database device. Electronic data distribution system, database / tag format data conversion interface, tag name / cell name conversion interface,
It is an object to provide a cell data writing interface and an electronic data distribution method.

[0006]

According to the present invention, there is provided an electronic data distribution system comprising: a database in which data is registered by designating a database name, a record number, and a field number; A database tag format data conversion interface that converts registered data into data associated with a unique tag name that can also identify the record number to which the field belongs and the name of the database; a unique cell name and cell address; A spreadsheet application that creates a report in a predetermined format, and a unique function that can also identify the record number and database name for each data generated by the database / tag format data conversion interface. Data associated with various tag names A tag name / cell name conversion interface for converting a data file into a data file associated with a unique cell name of the spreadsheet application for each data, and a unique data for each data generated by the tag name / cell name conversion interface. A cell data writing interface having a function of selecting and writing data corresponding to each specified cell address of a form created in advance by the spreadsheet application from a data file associated with a unique cell name. It is provided.

In the electronic data distribution system according to the first aspect of the present invention, the data registered in each field in the database is identified by the database / tag format data conversion interface by the record number to which the field belongs and the name of the database. Convert to data that is associated with a unique tag name. The data file associated with a unique tag name that can also identify the record number and database name for each data by the tag name / cell name conversion interface is associated with the unique cell name of the spreadsheet application for each data To a data file. Then, from the data file associated with the unique cell name for each data, the cell data writing interface selects and inputs data corresponding to each specified cell address of the form prepared in advance by the spreadsheet application. Thus, the form is created according to a predetermined format.

[0008] Thus, the user can obtain a cell data writing interface as an application and create a report in a unique format using the interface. The database / tag format data conversion interface and the tag name / cell name can be obtained. The conversion interface part can use the data common to all users, and distribute the common data, but can also use the data for a report in a unique format different for each user.

An electronic data distribution system according to a second aspect of the present invention comprises a database device, a server device connected to the database device, and a client device connected to the server device via a data transmission line. Has a database in which data is registered by specifying a database name, a record number, and a field number, and the server device accesses the database in the database device and is registered in each field in the database. The client device includes a database tag format data conversion interface for converting data into data associated with a unique tag name that can also identify a record number to which the field belongs and a database name, and transmitting the data to the client device. A unique cell A spreadsheet application that has a function of linking a form and a cell address on a form, and creates a form in a predetermined format; and a record number and a database for each of the data downloaded by the database / tag format data conversion interface. A tag name / cell name conversion interface for converting a data file associated with a unique tag name that can also identify a name into a data file associated with a unique cell name of the spreadsheet application for each data; From the data file generated by the tag name / cell name conversion interface and associated with a unique cell name for each data, data corresponding to each specified cell address of the form prepared in advance by the spreadsheet application Select and write It is obtained by a data write interface.

In the electronic data distribution system according to the second aspect of the present invention, a plurality of client devices are connected to the server device via a data transmission line. , Data can be written in a unique form created for each client device.

According to a third aspect of the present invention, in the electronic data distribution system according to the first or second aspect, each of the interfaces performs bidirectional conversion. Even if data is input using a form, the database device can receive data in a common format from all users and register it in the corresponding field of the database.

According to a fourth aspect of the present invention, there is provided a database / tag format data conversion interface which converts data registered in each field in a database into a unique tag name capable of identifying a record number to which the field belongs and a database name. It has a function of converting the data into the associated data.

The database / tag format data conversion interface according to the fourth aspect of the present invention can convert data of an arbitrary field of an arbitrary database into tag format data corresponding to a unique tag name.

According to a fifth aspect of the present invention, there is provided a tag name / cell name conversion interface, for each data registered in each field in a database, a unique tag name capable of identifying a record number to which the field belongs and a database name. A function is provided for converting a data file associated with a data file into a data file associated with a unique cell name of a spreadsheet application for each data.

In the tag name / cell name conversion interface according to the fifth aspect of the present invention, a data file associated with a unique tag name that can also identify a record number to which the field belongs and a database name is stored for each data.
Each data can be converted into a data file associated with a unique cell name of a spreadsheet application.

The cell data writing interface according to the present invention selects data corresponding to each specified cell address of a previously created form from a data file associated with a unique cell name for each data. It has the function of writing.

According to the cell data writing interface of the present invention, even if the format of the created form is not fixed, it is created in advance by a spreadsheet application from a data file associated with a unique cell name for each data. The user can select and write data corresponding to each of the designated cell addresses of the completed form.

According to a seventh aspect of the present invention, there is provided an electronic data distribution method comprising:
A unique tag name that identifies the data registered in each field in the database where the data is registered by specifying the database name, record number, and field number, as well as the record number to which the field belongs and the database name And converting the data file generated in the step, which is associated with a unique tag name that can also identify a record number and a database name for each data, into a spreadsheet application for each data. The step of converting into a data file associated with a unique cell name handled in, and the data file associated with a unique cell name for each data generated in the step, previously created by the spreadsheet application Cell address specified in the form It is made of a step of writing by selecting the data corresponding to Les.

According to the electronic data distribution method of the present invention, the user only has to create a form in a unique format using the cell data writing interface. The cell name conversion interface can use a common data file for all users, and can accurately write data to a report in a unique format that differs for each user.

According to an eighth aspect of the present invention, in the electronic data distribution method of the seventh aspect, data written in each predetermined cell address of a form created in advance by the spreadsheet application is unique to each data. Converting the data group into a data group associated with the cell name; and converting the data group converted in the step into a data group associated with a unique tag name that can also identify a record number and a database name for each data. Converting, and converting the data group converted in the step into a data group registered in each field in the database in which data is registered by designating a database name, a record number, and a field number for each data. Converting, and converting the data group converted in the step into a database corresponding to each data. It is obtained by a step of re-register in the appropriate field in the fine corresponding record.

According to the electronic data distribution method of the present invention, even if data is input using a form in a unique format for each user, the database device receives data in a common format from all users and stores the data in the database. It can be registered in the corresponding field.

According to a ninth aspect of the present invention, in the electronic data distribution method of the seventh or eighth aspect, a data file associated with a unique tag name that can identify a record number and a database name for each data is transmitted. The method includes a step of transmitting and receiving data via a line, and enables data distribution using a data transmission line such as the Internet, a dedicated line, or a public line.

[0023]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 shows a system configuration according to an embodiment of the present invention. An electronic data distribution system according to the present embodiment includes a database device 1 installed in a data center, reads data from the database device 1 and performs predetermined data conversion, and conversely converts data received from outside into a database device 1. A server device 2 that converts data into a format of a general database and performs data transmission / reception processing with a client device described later, a data transmission line 3 for data transmission such as the Internet, a dedicated line or a public line, Are composed of client devices 4A, 4B, 4C,...

As shown in FIG. 2, the database device 1
Registers and manages databases 100 each having a database name. This database 10
The content of 0 is, for example, as shown in FIG.

That is, as shown in the general format of FIG. 8A, a database (DB) name for identifying each database, a record name for identifying each record (usually, for identifying a record, Uses a line number), and fields 1 to n for registering data for each record (n is an arbitrary integer defined by the size of the database, the designation of the user, the capacity of the storage device, etc.) A field name for identifying is set.

More specifically, as shown in FIGS. 2B and 2C, the sales company database has a database name of “seller database” (seller database) and the record name has each record. Each "Sales company first line",
"Second line of sales company", ... is attached. In addition, "Company code" is given as the name of field 1, "Company name" is given as the name of field 2, "Postal code" is given as the name of field 3, and so on.

Similarly, the purchasing company database has a database name "purchasing company database" (purchasing company D).
B), the record name includes “purchase company's first line”, “purchase company's second line”,... For each record, and further includes “company code”, “zip code” ”,“ Location ”, and so on.

FIGS. 9A and 9B show the database device 1.
2 shows a data structure of a delivery destination database and a product database in the table. As shown in FIG.
The data structure of the delivery destination database is shown in Fig. 8 (b) and (c).
Are the same as the sales company database and the purchaser database shown in Table 1. The database name is “delivery database” (delivery DB), the record names are “first line of delivery destination”, “second line of delivery destination”, , And “company code”, “company name”,... Are used as field names.

As shown in FIG. 9B, in the case of a product database, the database name is "product database" (product DB), and the record names are "product first line", "product .. Are added, and as the names of the fields 1 to n of each record, “product code”, “product name”, “model number”,.

The server device 2 accesses various databases 100 in the database device 1 and stores the data registered in each field with a unique tag name that can also identify the record number to which the field belongs and the name of the database. The tag format data file 200A is converted to the associated tag format data, and the tag format data file 200A composed of the set is transmitted to the client devices 4A, 4B,.
It has a database / tag format data conversion interface 201 for reversely converting OA into a data file in a database format. However, this interface function is realized by software. The tag format used is preferably an XML format.

Each of the client devices 4A, 4B,... Is connected to the server device 2 by the data transmission line 3 and has a predetermined form, for example, a form 401A, 401.
B, 401C, and 401D are provided with spreadsheet application software 402.

The spreadsheet application software 402 of the client devices 4A, 4B,... Stores the tag format data file 200A downloaded from the server device 2 through the data transmission line 3 with the unique cell name of the form for each data. A tag name / cell name conversion interface 404 (implemented by a macro program) for obtaining a cell-named data file 403 by converting the data into cell-named data as shown in FIGS. Out of the cell-named data file 403, which is a set of cell-named data associated with a unique cell name, corresponds to each of the designated cell addresses 400 of the form 401 created in advance by the spreadsheet application 402. Cell to select and write data Over data write interface 405
(This is realized by a macro program. The cell name / cell address correspondence data file 406 indicating the correspondence between the cell name and the cell address is as shown in FIGS. 15 and 16.) It has a conversion function.

Next, the operation of the above electronic data distribution system will be described. The database device 1 shown in FIG. 1 and FIG. 2 has seller information as shown in FIG. 8 and FIG.
Purchasing company information, delivery destination information, and product information
It is registered as a sales company database, a purchasing company database, a delivery destination database, and a product database.

The database / tag format data conversion interface 201 of the server device 2 accesses each of the databases 100 in the database device 1 and executes necessary databases (here, the sales company database and the purchase company shown in FIGS. 8 and 9). Database, delivery destination database, and product database), and reads out data in a necessary range from the database, and converts the data from a database format data file into a tag format data file 200A as shown in FIG.

The server device 2 converts the tag format data file 200A obtained by the database / tag format data conversion interface 201 into a data transmission line 3.
The serial data string 200B shown in FIG. 12 is transmitted to the client device 4 (here, the client device 4A is specifically described).

In the client device 4A, the serial data string 200B sent from the server device 2 is converted back to the original tag format data file 200A and held.
Then, the user uses the spreadsheet software 402 to select and input necessary data in a predetermined column of the form in a predetermined format.

The data input processing using the spreadsheet software 402 is as follows. Tag name / cell name conversion interface (I / F) 40 in spreadsheet software 402
4, the tag format data file 200A performs tag name / cell name conversion as shown in FIG.
The data registered in each field belonging to a certain record number in 00 is replaced with each cell name and 1
The data is converted into cell-named data in a format corresponding to one-to-one and registered in the cell-named data file 403.

Then, the user uses the spreadsheet software 402 to enter an order form 401, which is a form in the form shown in FIG.
For A, data is entered in its predetermined fields, for example, the address field of the order form, the orderer field, the delivery location field, and the ordered goods field.

In this case, the user associates the tag format data file 200A displayed on the display device 40 with the slip format 401A as shown in FIG. If the tag name is dragged and dropped (this tag name is actually stored in the spreadsheet software 402 by the tag name / cell name conversion interface 404 as shown in FIG. 13 and FIG. Is treated as named data), and that data is copied to the specified cell address.

For example, if the data “value 1” registered in the tag name A is dragged and dropped to the cell address A1 of the form 401A, the cell name A− {A} 1 (where {} indicates an absolute address) FIG. 1 shows link data of value 1
In addition to the registration in the cell name / cell address correspondence data file 406 shown in FIG. Also, by dragging and dropping the data “value 2” of the tag name B to the cell address B3, the cell name B- {B @ 3-
The link data of value 2 is registered in the cell name / cell address correspondence data file 406, and is written in the cell address B3 of the form 401A.

Conversely, the user enters "value 4" in cell address C1.
Is written, the cell data writing interface 405 of the spreadsheet software 402 assigns a cell name to the cell address C1 according to a predetermined rule, and stores the cell name D- @ C in the cell name / cell address correspondence data file 406. $ 1-Register the link data of value 4, and the tag name / cell name conversion interface 404 registers the cell name D-value 4 in the data file 403 with cell name, and further registers the cell name D-
The value 4 is inversely converted to tag format data of tag name D-value 4 and registered in the tag format data file 200A.

Thus, by dragging and dropping data of necessary items from the tag format data file 200A to the corresponding cell on the form 401A of the display format 1, the data from the database 100 is input and the form 401A is input. When the user inputs new data for the form 401A, the data is also registered in the cell-named data file 403 on the spreadsheet software 402 side, and is sent to the server device 2 side. Ready to upload.

On the other hand, using the same tag format data file 200A received from the server device 2 by the user of the client device 4A or the user of another client device (for example, 4B), the form 401B of another display format 2 is used. When writing data, do as follows.

In the form 401B of the display format 2, the tag name A
Is written in the cell address A1 in the form of the tag 40, and the data “value 1” of the tag name A is dragged and dropped into the form 40 as in the case of the form 401A.
Write to cell address A1 of 1B.

However, in the form 401B, the data “value 2” of the tag name B is written in the cell address B1, so here, the data “value 2” of the tag name B is dragged and dropped into the form. Cell address B of 401B
Write to 1. As a result, the cell name / cell address correspondence data file 406 for the form 401B includes the cell name B-
The link data of {B} 1-value 2 is registered.

In the form 401B, the cell address A3
"Value 5" that the user has entered into the server device 1
If it is necessary to transmit the data to the cell address, the cell data writing interface 405 of the spreadsheet software 402 assigns a cell name to the cell address A3 according to a predetermined rule, and stores the cell name E- ＄ in the cell name / cell address correspondence data file 406. A $ 3
The link data of the value 5 is registered, and the tag name / cell name conversion interface 404 reversely converts the cell name E-value 5 into the tag format data of the tag name E-value 5 and registers.

As a result, for the form 401B of the display format 2 as well, data of necessary items is selected from the common tag format data file 200A sent from the server device 2 and written into the corresponding cell. When the user inputs his / her own data for the form 401B, the user can prepare for uploading it to the server device 2 side.

The procedure for uploading data input by the user using the form 401A on the client device 4A to the server device 2 and for the server device 2 to register new data in the database device 1 is as follows. become.

When the user inputs data to the form 401A using the spreadsheet software 402 on the client device 4A, newly writes necessary data to a cell at a predetermined address of the form 401A, and performs an upload operation, the cell data New data is registered in the cell name / cell address correspondence data file 406 according to a predetermined rule by the write interface 405, and the cell name-tag name is converted by the tag name / cell name conversion interface 404, and the cell name
The data correspondence is converted into a tag name-data correspondence and added to the tag format data file 200A. The tag format data file 200A to which the data has been added
Is uploaded to the server device 2 through the data transmission line 3.

The server device 2 compares the received tag format data file 200A with the tag format data file 200A before downloading, and when addition or change of new data is found, a database / tag format data conversion interface. 201 to convert to a database format file and
To update the data of the corresponding database 100 in the database device 1.

Thus, data is registered in each database 100 of the database device 1 in a general data format, and the tag format data file 200A is created in the server device 2 using the database / tag format data conversion interface 201. Are commonly downloaded to the client devices 4A, 4B, 4C,..., And the tag format data file 2 in a common format is uploaded from the client devices.
00A, the data in the database 100 can be updated.

Therefore, particularly for each client device,
In addition, data files of different formats are created from the database for each form used by the user and downloaded to each user, and there is no need to handle uploaded data using a data file dedicated to each user, which makes database management extremely difficult. Be simplified. vice versa,
In order to avoid diversification of report formats, if the center side strictly specifies the report format and sends the corresponding data file, it can be simplified, but centralized and regionalized However, according to the system of the present embodiment, there is an advantage that the data format handled by the center can be shared while flexibly responding to various requests according to regional characteristics and industries. .

FIG. 3 shows a processing flow of the above embodiment. The record name “the first line of the sales company” in the database 100 of the database name “the sales company database” registered in the database device 1 The flow of data DT1 of "Marunouchi xxx, Chiyoda-ku, Tokyo" registered in the field name "location" to which it belongs is shown.

The data DT1 of this database is stored in the server device 2 in the form of “<tag name = sales company database. Sales company first line. Location> Marunouchi xx, Chiyoda-ku, Tokyo
x </ distributor database. The first line of the sales company. Location>"
, And transmitted to the client device 4 through the data transmission line 3.

In the client device 4, the spreadsheet software 4
02, the tag name-cell name conversion interface 404 converts the tag name to the cell name, and outputs the data with the cell name “(cell name = sales company database. Sales company first line. Location) Marunouchi xxx, Chiyoda-ku, Tokyo”. Converted to 403. However, the cell-named data 403 is hidden by the spreadsheet software 402 and the client device 4
Is displayed as the tag format data 200A.

The user selects the form 401 to which the user wants to input data by the client device 4 and displays the same at the same time as the tag format data 200A. When the user wants to input the data DT1 to the cell address A18,
Click the tag format data 200A data "Marunouchi xxx, Chiyoda-ku, Tokyo", and click the cell address D18 of the form 401.
Drag and drop to

Similarly, an order form 401 shown in FIG.
A, when order forms 401B having different formats shown in FIG. 6 are created, the order forms 401A and 401B are used as shown in FIGS. 5 and 7, respectively, while using the same cell name-added data file 403 as shown in FIG. , The same data is input to different cell addresses. For example, even when ordering the same product “electric washing machine” from the same sales company (ordering party), the order form 401A inputs the “order washing machine” of the ordered product into the cell address C25, but the order form 401B does not. This will be input to the address D20. However, the data related to the same product name “washing machine” input in these different forms of order forms 401A and 401B are common in the cell-named data file 403, and the corresponding tag format data file 2
00A is also common, and a tag format data file 200A common to the server device 2 and the client devices 4A, 4B,.
B is transmitted.

FIGS. 17 and 18 show the correspondence between the order sheet 401C and the purchase application form 401D associated with the order form shown in FIG. 4 or 6 and the data file 403 with cell names, respectively. Also for these, forms of different formats can be created by the same data file 403 with the same cell name as described for the order forms 401A and 401B of different formats.

In the above-described embodiment, the database 100 is a sales company database, a purchaser database,
Although the description has been made using the product database and the delivery destination database, the types of the databases are not limited.
Basically, in the spreadsheet application software used by the client device, a cell name is assigned to each data, and the cell name for each data is made to correspond to a tag name. What is necessary is just to be able to specify which field of which record of the database is the data.

[0060]

As described above, according to the electronic data distribution system of the first aspect of the present invention, the user is made to obtain the cell data writing interface as an application, and to create the original form using the cell data writing interface. The database / tag format data conversion interface and the tag name / cell name conversion interface part use the same data for all users, while distributing common data. The data can be used for.

According to the electronic data distribution system of the second aspect of the present invention, there is provided a system in which a plurality of client devices are connected to a server device through a data transmission line. While distributing the data, it is possible to write the data into the original form created for each client device.

According to the electronic data distribution system of the third aspect of the present invention, in addition to the effects of the first or second aspect of the present invention, each interface performs bidirectional conversion, so that each user has its own unique Even if data is input using a form in a format, the database device can receive data in a common format from all users and register the data in a corresponding field of the database.

According to the database / tag format data conversion interface of the fourth aspect of the present invention, any field data of any database can be converted into tag format data corresponding to a unique tag name. .

According to the tag name / cell name conversion interface of the fifth aspect of the present invention, a data file associated with a unique tag name that can also identify the record number to which the field belongs and the name of the database for each data. Can be converted into a data file associated with a unique cell name of a spreadsheet application for each data.

According to the cell data writing interface of the present invention, even if the form of the created form is not fixed, the spreadsheet application can use the data file associated with the unique cell name for each data. Data corresponding to each specified cell address of a previously created form can be selected and written.

According to the electronic data distribution method of the present invention, the user can create a report in a unique format using the cell data writing interface, and the database / tag format data conversion interface and the tag can be used. The name-to-cell name conversion interface can use a common data file for all users, and can accurately write data to a report in a unique format that differs for each user.

According to the electronic data distribution method of the invention of claim 8, in addition to the effect of the invention of claim 7, even if data is input using a form of a unique format for each user, the database apparatus side can completely input the data. A data file in a common format can be received from a user and registered in a corresponding field of the database.

According to the electronic data distribution method of the ninth aspect of the present invention, in addition to the effects of the seventh or eighth aspect of the present invention, a record number and a database name are associated with a unique tag name for each data. It includes a step of transmitting and receiving the data file, and enables data distribution using a data transmission line such as the Internet, a dedicated line, or a public line.

[Brief description of the drawings]

FIG. 1 is a flowchart showing the configuration of an electronic data distribution system according to one embodiment of the present invention.

FIG. 2 is a block diagram showing a data flow of the portable electronic data distribution system according to the embodiment.

FIG. 3 is an explanatory diagram showing a data conversion correspondence relationship by the electronic data distribution system of the embodiment.

FIG. 4 is an explanatory diagram showing an example of an order form created by spreadsheet software installed in a client device in the embodiment.

FIG. 5 is an explanatory diagram showing the correspondence between data cells of the order form shown in FIG. 4 and data with cell names in a cell name data target file.

FIG. 6 is an explanatory diagram showing another example of an order form created by spreadsheet software installed in a client device in the embodiment.

FIG. 7 is an explanatory diagram showing the correspondence between the data cells of the order form in FIG. 6 and the data with cell names in the cell name data target file.

FIG. 8 is an explanatory diagram of a data format of a database in the database device.

FIG. 9 is an explanatory diagram of a data format of another database in the database device.

FIG. 10 is an explanatory diagram showing contents of a tag format data file by the server device in the embodiment.

FIG. 11 is an explanatory diagram showing the contents of a tag format data file for a dealer database by the server device in the embodiment.

FIG. 12 is an explanatory diagram showing a structure of serial transfer data of a tag format data file with respect to a dealer database by the server device in the above embodiment.

FIG. 13 is an explanatory diagram showing contents of a data file with a cell name by the client device in the embodiment.

FIG. 14 is an explanatory diagram showing contents of a data file with a cell name in a sales company database by the client device in the embodiment.

FIG. 15 is an explanatory diagram showing the contents of a cell name / cell address correspondence data file by the client device in the embodiment.

FIG. 16 is an explanatory diagram showing the contents of a cell name / cell address correspondence data file for a seller database, a purchaser database, and a product database by the client device in the above embodiment.

FIG. 17 is an explanatory diagram showing a correspondence relationship between a data cell position of an arrangement slip created by the client device and data in a cell-named data file in the embodiment.

FIG. 18 is an explanatory diagram showing the correspondence between the data cell position of the purchase application created by the client device and the data in the cell-named data file in the embodiment.

[Explanation of symbols]

1 Database device 2 Server device 3 Data transmission line 4, 4A, 4B, 4C,... Client device 100 Database 200A Tag format data file 200B Serial data sequence 201 Database / tag format data conversion interface 401A Order form 401B Order form 401C Arrangement slip 401D Purchase application form 402 Spreadsheet application software 403 Data file with cell name 404 Tag name / cell name conversion interface 405 Cell data write interface 406 Cell name / cell address correspondence data file

Claims (9)

[Claims] 1. A database in which data is registered by designating a database name, a record number, and a field number, and the data registered in each field in the database are replaced by a record number to which the field belongs and a database number. It has a database / tag format data conversion interface that converts data into data associated with unique tag names that can also identify names, and a function that can link unique cell names and cell addresses. A spreadsheet application to be created, and a data file generated by the database tag format data conversion interface and associated with a unique tag name that can also identify a record number and a database name for each data, Spreadsheet application A tag name / cell name conversion interface for converting to a data file associated with a unique cell name; and a data file generated by the tag name / cell name conversion interface and associated with a unique cell name for each data. And a cell data writing interface having a function of selecting and writing data corresponding to each specified cell address of a form created in advance by the spreadsheet application. 2. A database device, a server device connected to the database device, and a client device connected to the server device via a data transmission line, wherein the database device has a database name, a record number, and a field. A database that registers data by designating a number, the server device accesses a database in the database device, and registers data registered in each field in the database with a record number to which the field belongs. A database tag format data conversion interface for converting the database name into data associated with a unique tag name that can also be identified and transmitting the data to the client device, wherein the client device has a unique cell name and a cell on a form. Function to link with street address And, with a spreadsheet application that creates a form in a predetermined format, and a unique tag name that has been downloaded by the database tag format data conversion interface and that can also identify the record number and database name for each of the data A tag name / cell name conversion interface for converting the associated data file into a data file associated with the unique cell name of the spreadsheet application for each data, and the tag name / cell name conversion interface. A cell data write interface for selecting and writing data corresponding to each specified cell address of a form created in advance by the spreadsheet application from a data file associated with a unique cell name for each data; With Electronic data delivery system that. 3. The electronic data distribution system according to claim 1, wherein each of the interfaces performs bidirectional conversion. 4. A database having a function of converting data registered in each field in a database into data associated with a unique tag name that can also identify a record number to which the field belongs and the name of the database. Tag format data conversion interface. 5. For each data registered in each field in the database, a data file associated with a record number to which the field belongs and a unique tag name that can also identify the name of the database is displayed for each data. Tag name / cell name conversion interface with a function to convert to a data file associated with the unique cell name of the calculation application. 6. Cell data having a function of selecting and writing data corresponding to each specified cell address of a form created in advance from a data file associated with a unique cell name for each data. Write interface. 7. The data registered in each field in the database in which the data is registered by designating the name of the database, the record number, and the field number, and the record number to which the field belongs and the name of the database are also identified. Converting the data file generated in the step, which is associated with a unique tag name that can also identify a record number and a database name for each data, Converting to a data file associated with a unique cell name handled by the spreadsheet application on a per-data basis; and generating the spreadsheet application from the data file generated in the step and associated with a unique cell name for each data. Specified by the form created in advance Electronic data delivery method comprising a step of writing by selecting the data corresponding to the respective cell address. 8. A step of converting data written in each predetermined cell address of a form created in advance by the spreadsheet application into a data file associated with a unique cell name for each data; Converting the data file converted in the step to a data file associated with a unique tag name that can also identify a record number and a database name for each data, the data file converted in the step, A step of specifying a database name, a record number, and a field number for each data, converting the data file registered in each field in the database in which the data is registered, and the data file converted in the step, Applicable database and applicable record for each data The electronic data distribution method according to claim 7, further comprising the step of: re-registering in a corresponding field in the password. 9. The method according to claim 7, further comprising the step of transmitting and receiving a data file associated with a unique tag name that can also identify a record number and a database name for each data through a data transmission line. 9. The electronic data distribution method according to 8.