JPH10283415A - Mapping device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To facilitate generating operation for a data conversion rule table by allowing enterprise to automatically generate its easy-to-handle data conversion rule table in standard format of the industry. SOLUTION: This device consists of an industry standard data file 11, an industry standard format file 12, a mapping device main body part 13, a data conversion rule table 14, a translator 15, and a user characteristic file 16. A mapping device main body part 13 receives industry standard data sent from the enterprise having transaction relation and relates the enterprise characteristic data format of the sending enterprise with the industry standard format of the industry standard format data file 12 to automatically generate a data conversion rule for converting the received industry standard data into data matching the purpose of use by the enterprise itself, thus structuring the data conversion rule table 14.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a mapping apparatus used in a data conversion system for electronic transaction data handled when performing electronic transactions between companies.

[0002]

2. Description of the Related Art In recent years, a data conversion system for electronic transaction data has become one of the companies involved in a business relationship (finished product manufacturing company).
In order to make it easier to electronically receive and order transaction data such as parts between the company and the other company (parts manufacturing company), the parts name, Publish an industry standard format for electronic transactions that unifies the types, sizes and other necessary items,
For example, when a component manufacturer receives industry standard data from a finished product manufacturer according to an industry standard format, the component manufacturer uses the data for the component manufacturer, for example, on a manufacturing line or other purposes while referring to the component manufacturer specific data and the industry standard format. A possible form, for example, a form for ordering parts, a form for requesting parts manufacture, etc., has been created.

[0003] The above description of the data conversion system has been made from the viewpoint of the ordering company of the parts. However, even from the viewpoint of the ordering company of the parts, the relationship is completely opposite, that is, the finished product manufacturing company is not involved. The same applies when the industry standard data is transmitted in accordance with the industry standard format, and the component manufacturer receives the industry standard data and prepares a part order slip.

FIG. 10 is a block diagram for explaining a conventional electronic transaction data data conversion system that converts data into a data usable by itself under an industry standard format and industry standard data.

That is, this data conversion system includes an industry standard data file 1 created according to an industry standard format pattern and transmitted from, for example, a part ordering company, and an industry standard format and an industry standard data file which are manually input in advance. A data conversion rule table 2 storing company-specific data necessary for converting the file 1 into slip data that can be used by the ordering company itself, and the industry standard data file 1 and the data conversion rule table 2 are used. A translator 3 that converts the data into slip data or the like suitable for the purpose of use of the ordering company;
The translator 3 includes a user-specific file 4 for storing the slip data converted by the translator 3, and reads out the stored data from the user-specific file 4 when necessary to create and output a slip 5 that can be used by the company.

[0006]

However, in the data conversion system for electronic transaction data as described above, in order to create the data conversion rule table 2, it is necessary to manually set an industry standard format. It takes a lot of time to create company-specific data for converting standard data into slip data suitable for the use purpose of the ordering company itself, and the data conversion rule table 2 is updated every time the industry standard format is revised. The setting must be reset from the beginning, and the setting operation is very troublesome and complicated.

The present invention has been made in view of the above circumstances, and has as its object to provide a mapping apparatus that can quickly and easily create a data conversion rule table that can be easily handled by a company. It is another object of the present invention to provide a mapping apparatus which can easily create a data conversion rule table even when an industry standard format is revised.

[0008]

SUMMARY OF THE INVENTION In order to solve the above-mentioned problems, the present invention is set up on one side of a company having a business relationship and has the business relationship according to an industry standard format of an industry standard electronic transaction data issuer. A mapping device for receiving an industry standard data sent from the other company and creating a data conversion rule table, wherein the data conversion rule table having an item name area, a company-specific data format area and an industry standard format area; When a pattern of industry standard data received from a company is present in the pattern of the industry standard format, a conversion table name is given, and data including an item name defined in the pattern of the industry standard format is imported. Data conversion rule table item area and industry standard format Table determination means for registering in the mat area and determining the data conversion rule table; and determining whether the received industry standard data item name exists in the item name registered in the table. Means for selectively registering the data and various data related to the corresponding item names of the company-specific data format in the company-specific data format area and the industry standard format area of the data conversion rule table. This is a mapping device that creates a data conversion rule table for converting data into usable data.

Therefore, according to the above-described means, upon receiving the industry standard data from the other company in the business relationship, one of the companies can read the industry standard data and the industry standard format previously acquired and stored. Data conversion for registering necessary data in the item name area, company-specific data format area and industry standard format area of the data conversion rule table while corresponding to Since the rule table is created, the data conversion rule table can be created automatically and quickly based on the received industry standard data, and the table creation operation can be simplified.

[0010] Further, when there is a repeated item in an item name of the industry standard data received from the other company,
A repetition work table for adding and registering the number of repetitions for each repetition of a certain item name in the above-described mapping device, and a repetition work table for the data conversion rule table corresponding to a certain item name in the company-specific data format area. If an item repetition processing means for storing the number of times is added, even when the same item name is delivered at a different delivery date and time, a different number of parts can be effectively used.

Further, when there is a revision in the industry standard format, the mapping device described above newly sets the correspondence between the item names of the pre-revision data conversion rule table and the revised item names of the industry standard format. According to the prescribed new / old item correspondence table and the corresponding item name of the new / old item correspondence table, the data of the above-mentioned industry standard format is registered in the industry standard format area of the before-revision data conversion rule table to convert the data after revision. By adding a revision table creating means for creating a rule table, a revised data conversion rule table can be automatically created when an industry standard format is revised.

[0012]

FIG. 1 is a block diagram showing one embodiment of a mapping device in a data conversion system according to the present invention. In the figure, reference numeral 11 denotes an industry standard data file installed at one of the companies having a business relationship, for example, a parts manufacturer, and the industry standard data A stored in the file 11 is an industry standard data as shown in FIG. In accordance with the standard format B, for example, the data array includes an item name (data tag), an item length (length tag), and actual data (variable length data element).

Reference numeral 12 denotes an industry standard for storing, for example, EIJA, ie, an industry standard format B for dealing with transaction information, which is created and issued by an association or other organization (an industry standard electronic transaction data issuer) organized by a specific industry group. As for the industry standard format B of the file 12, an item name, an item type, an item length and the like are defined for each format pattern as shown in FIG.
It is transmitted through the transmission line from the association or other organizations, or is sold on a storage medium such as a single floppy, so it can be received through the transmission line, or by purchasing the storage medium, the company belonging to the industry itself And the industry standard format data file 12 can be easily provided.

Reference numeral 13 denotes a mapping device main body installed at the other company in the business relationship, for example, a finished product manufacturing company, and the like. The mapping device main body 13 is sent from one company in the business relationship. Received industry standard data A, and receives the industry standard format data file 12
Under the industry standard format B of the other company, for example, by associating the industry-specific format with the company-specific data format of the other company such as a finished product manufacturing company, the received industry standard data A matches the purpose of use by the company itself. A data conversion rule C for automatically converting data into such data is automatically created, and a data conversion rule table 1 as shown in FIG.
4 has the ability to build.

The mapping apparatus main unit 13 finds the corresponding industry standard format pattern from the industry standard format B based on the pattern of the industry standard data A, and sets the corresponding industry standard format pattern together with the created conversion table name. A table determining means 13a for determining the table 14;
3a, various data setting means 13b for determining and sequentially setting various data in the data conversion rule table 14 determined by 3a, and starting as a start address for each item name defined in the company-specific data format in the data conversion rule table 14. A start position calculating means 13c for calculating a position;
A consistency check unit 13d for checking the consistency between the company-specific data format in the data conversion rule table 14 and the industry standard format is provided.

The electronic transaction data conversion system includes:
In addition to the above components, as in the conventional case, as shown by the dotted line in the drawing, a slip or the like suitable for the company's own use purpose is obtained from the received industry standard data using the automatically created data conversion rule table 14. And a user-specific file 16 for storing data such as a slip converted by the translator 15. Note that, in addition to item names, actual data of, for example, industry standard data is described in a slip or the like created from the user-specific file 16.

Next, the operation of the above mapping apparatus will be described with reference to FIG. (1) The mapping device main unit 13 executes the table determination unit 13a. This table determination means 13a
It is determined whether or not the industry standard data A shown in FIG. 2 has been sent from one company in a business relationship, that is, whether or not the industry standard data A has been received (ST1). When the industry standard data A is received, it is determined whether an industry standard format pattern corresponding to the industry standard format pattern in the received industry standard data A exists in the industry standard format B of the industry standard format file 12. Judgment is made (ST2), and if it exists, the industry standard format pattern is selected, and if it does not exist, the process is terminated.

When an industry standard format pattern is selected in step ST2, when the operator inputs the name of the current conversion table from outside, the conversion table name and the industry standard format pattern, for example, A1, are set, and the data conversion rule table 14 is determined. Yes (ST
3). The setting of the industry standard format pattern A1 is performed by selecting the industry standard format pattern A1 from the industry standard format B, and setting the item name, item type, item length, etc. to which the industry standard format pattern A1 belongs in the data conversion rule table 14. Set the item name and type and length area in the industry standard format. (2) Subsequently, the mapping device main unit 13 executes various data setting means 13b.

The various data setting means 13b checks whether or not the item name of the received industry standard data A exists in the data conversion rule C (ST4), and if there is, proceeds to the next step ST5. When the item length of the industry standard data A is longer than the item length of the data conversion rule C (ST
5), the item length of A is set to the item length of the company-specific data format of the data conversion rule C (ST6). Furthermore, the actual data of the industry standard data A, for example, E11 is the item type C11 (=
If it matches E11) (ST7), the item type C
11 is set as the item type of the company-specific data format (ST8). If they do not match, an item type of an industry standard format corresponding to the item type E11 is set (ST9).

If the item name of the industry standard data A received in step ST4 does not exist in the data conversion rule C, the process proceeds to step ST10, and various data are set in the data conversion rule C. That is, an item name of the industry standard format B corresponding to the item name of the industry standard data A is searched, the item name is set in the data conversion rule C, and the type and item corresponding to the item name of the industry standard format B are searched. The length is set to the data conversion rule C industry standard format. Further, the item length of the industry standard data A is set to the item length of the company-specific data format of the data conversion rule C. (3) Subsequently, it is determined whether or not all the item names of the industry standard data A have been processed (ST11). If the item names still remain, the process returns to step ST4, and the same process is repeated. When all the item names have been processed, the process proceeds to the next step ST12, and the start position of the company-specific data format of the data conversion rule C is calculated. This start position means a start address for each item name, and is obtained by adding the item length corresponding to the item name to the start position of the previous item name in the company-specific data format. (4) Further, the consistency between the item type and the item length between the company-specific data format of the data conversion rule C and the industry standard format is checked (ST13). In this consistency check, for example, if both item types are described in kanji or numbers, or if the item length of the industry standard format is longer than the item length of the company-specific data format, it is determined that there is consistency.

Therefore, according to the above-described embodiment, when the industry standard data is received, the data conversion rule table is determined by taking in the pattern of the industry standard format based on the industry standard format pattern of the industry standard data. Then, the data conversion rule table is created by extracting the industry standard data and various data in the industry standard format into the necessary area of the data conversion rule table, so that the data conversion rule table can be automatically and quickly created. The creation work can be simplified, and a data conversion rule table that can be easily handled by the own company can be easily created. Can be planned.

FIG. 6 is a block diagram showing another embodiment of the mapping device in the data conversion system according to the present invention. This mapping device is provided with an industry standard data file 21, an industry standard format file 22, a mapping device main body 23, a data conversion rule table 24, and a new repetitive work table 25 having functions substantially similar to those of FIG. I have.

The industry standard data file 21, like the industry standard data file 11 of FIG. 1, has a data array such as item names, item lengths, and actual data under an industry standard format pattern. The difference from the item 1 is that a repeated item is described in the item name as necessary. These repeated items include one-dimensional, two-dimensional,
There are repeated items of ... In FIG. 6, B2 and B3 are one-dimensional repeated items, and B5 is a two-dimensional repeated item. Here, for example, B2 is the product name, B3 is the number,
Assuming that B5 is the delivery condition, in FIG.
With the delivery conditions of Y31 pieces, Y51 and Y52, and product Y
22 is the delivery condition of Y32 pieces, Y53, Y54 and Y55. "

The industry standard format file 22 is the same as the industry standard format file 12 shown in FIG. 1. However, when there is a repeated item in a certain item name of the industry standard data A in the industry standard data file 21, the industry standard format file 22 is set in advance. In B, the number of repetitions MAX for the item name is set.

The repetition work table 25 has a function of adding and registering the number of repetitions of the item name if the item name of the industry standard data A has a repetition item. The data conversion rule table 24 has a function of recording the number of repetitions stored in the repetition work table 25 in addition to recording the same rules as in FIG.

The mapping device main unit 23 has a function as shown in FIG. 7, that is, a mapping processing function similar to that of FIG. That is, the mapping device main body 2
3 is a table determination unit 13a, various data setting units 1
3b, in addition to the start position calculating means 13c and the consistency checking means 13d, an item repetition processing means 23a for reflecting the repetition processing of a certain item name in the data conversion rule table 24
Is provided.

Next, the operation of the mapping apparatus configured as described above will be described. Since the basic processing of the mapping apparatus is the same as in FIGS. 1 and 5, the basic processing is omitted here, and in particular, the item repetition processing means 2
The operation of 3a will be described.

That is, the mapping device main unit 23
The processing shown in FIG. 5 is sequentially performed for each item name of the received industry standard data A. In particular, the item repetition processing means 23 determines whether the current processing item name in the received industry standard data A is a repetition item. Judge. Here, if the item name is a repetition item, after adding “1” to the repetition work table 25 to the number of repetitions corresponding to the previous item name,
The number of repetitions of the work table 25 is compared with the number of repetitions of the data conversion rule table 24. When the number of repetitions of the work table 25 is large, the number of repetitions is set in the number of repetitions area of the corresponding item name in the data conversion rule table 24. I do.

The processing by the item repetition processing means 23 including the above basic processing is repeatedly executed until there is no more item name. Thereafter, the start position calculating means 13c is executed. The start position calculating means 13c calculates the start position of the previous item name in the company-specific data format by adding the item length corresponding to the item name. Further, the consistency between the item type and the item length between the company-specific data format of the data conversion rule C and the industry standard format is checked.

According to the above-described embodiment, even if a certain item name is a repeated item, a data conversion rule table can be created quickly and easily, and the standardization work can be simplified.

FIG. 8 is a block diagram showing still another embodiment of the mapping device in the data conversion system according to the present invention. This mapping apparatus is to automatically create a revised data conversion rule table based on a data conversion rule table before revision when the industry standard format B is revised.

More specifically, when the industry standard format pattern A1 of the industry standard format B is revised to the industry standard format pattern A2, the revised industry standard format file 31 for taking in and storing the revised industry standard format pattern A2. (12 in FIG. 1, FIG. 6
22) and a pre-revision data conversion rule file 32a (1 in FIG. 1) which defines the pre-revision data conversion rules.
4, corresponding to 24 in FIG. 6), a new / old item correspondence table 33 for defining the correspondence between the old item name and the new item name, and the data conversion rule file 32a before revision are stored in the industry standard format pattern of the industry standard format B. A post-revision data conversion rule file 32b revised along with the revision of A2,
And a mapping device main unit 34 for executing a process of revising the pre-revision data conversion rule file 32a for the revision of the industry standard format B.

Hereinafter, the revision processing operation accompanying the revision of the industry standard format B will be described with reference to FIG. First, the format pattern A1 of the industry standard format
Is revised to A2, the format pattern A
2 is stored in the industry standard format file 31 (ST21). It is determined whether or not there is an instruction as to whether or not the format pattern A2 requires a revision operation in accordance with the revision (ST22). If there is a revision operation instruction with the creation conversion table name K2, the conversion table name K2 and the format pattern A2 are determined. Is determined (ST23), and the correspondence between the old item name of the pre-revision data conversion rule file 32a and the new item name defined in the format pattern A2 is checked. Create item correspondence table 33 (ST2)
4).

Thereafter, the new / old item correspondence table 33
, The contents of the revised industry standard format pattern A2 are sequentially stored in the industry standard format area corresponding to the item name B11 of the revised data conversion rule table 32a.

Therefore, according to the above embodiment, when the industry standard format is revised, the new / old item correspondence table 33 is created, and the new / old item correspondence table 3 is created.
Since the contents of the industry standard format are automatically stored in the industry standard format area of the data conversion rule table according to the new and old correspondence items of 3, the revised data conversion rule table 32b can be created automatically and quickly, and Of the data conversion rule table 32b can be easily created.

[0036]

As described above, according to the present invention, it is possible to automatically and quickly create a data conversion rule table that can be easily handled by the company under the industry standard format. Simplification can be achieved.

Further, according to the present invention, when there is a repeated item name among the item names of the industry standard data, the number of repetitions is described in a portion corresponding to the item name in the data conversion rule table. When converting into easy data, if the conversion is made so as to make use of the number of repetitions, it is possible to grasp the order status related to the same item name.

Further, according to the present invention, a data conversion rule table can be created automatically and quickly even when an industry standard format is revised, and the task of creating a data conversion rule table is greatly simplified as compared with the related art. Can be

[Brief description of the drawings]

FIG. 1 is a configuration diagram showing an embodiment of a mapping device according to the present invention.

FIG. 2 is a view showing an example of a data array of the industry standard data file shown in FIG. 1;

FIG. 3 is a view showing an example of a data array in the industry standard format shown in FIG. 1;

FIG. 4 is a view showing an example of a data array of a data conversion rule table of FIG. 1;

FIG. 5 is a flowchart for explaining the operation of the mapping apparatus shown in FIG. 1;

FIG. 6 is a configuration diagram showing another embodiment of the mapping device according to the present invention.

FIG. 7 is a functional configuration diagram of the mapping apparatus main body of FIG. 6;

FIG. 8 is a configuration diagram showing still another embodiment of the mapping device according to the present invention.

FIG. 9 is a flowchart for explaining the operation of the mapping apparatus shown in FIG. 8;

FIG. 10 is an overall configuration diagram of a conventional data conversion system for electronic transaction data.

[Explanation of symbols]

 11, 21 ... industry standard data file 12, 22 ... industry standard format file 13, 23, 34 ... mapping device main body 13a ... table determination means 13b ... various data setting means 14, 24 ... data conversion rule table 23a ... item repetition processing Means 25: Repeated work table 31: Revised industry standard format file 32a: Revised data conversion rule table 32b: Revised data conversion rule table 33: New / old item correspondence table

Claims (3)

[Claims] Claims: 1. An industry standard electronic transaction data is installed at one company in a business relationship and receives industry standard data sent from the other company in the business relationship in accordance with an industry standard format of an industry standard electronic transaction data issuer and converts the data. In a mapping apparatus for creating a rule table, the data conversion rule table having an item name area, a company-specific data format area, and an industry standard format area; and the pattern of industry standard data received from the other company is the industry standard format. When it exists in the pattern of, while adding a conversion table name, fetch data including the item name specified in the pattern of the industry standard format, register in the item area of the data conversion rule table and the industry standard format area, Data conversion rule table Means for determining the table, and whether or not the item name of the received industry standard data exists in the item name registered in the table, the corresponding item of the industry standard data and the company-specific data format. Means for selectively registering various data related to the name in the company-specific data format area and the industry standard format area of the data conversion rule table, data for converting the data into data usable by one company. A mapping device for creating a conversion rule table. 2. The mapping apparatus according to claim 1, wherein if there is a repeated item in a certain item name of the industry standard data received from the other company, the number of repetitions for each repetition of the certain item name And a repetition work table for storing the number of repetitions in the company-specific data format area of the data conversion rule table corresponding to a certain item name of the work table. Mapping device. 3. The mapping apparatus according to claim 1, wherein, when the industry standard format is revised, the correspondence between the item name of the data conversion rule table before revision and the revised item name of the industry standard format. In accordance with the new and old item correspondence table, and the corresponding item name of the new and old item correspondence table, the data of the above-mentioned industry standard format is registered in the industry standard format area of the before-revision data conversion rule table, and the data after revision is registered. A mapping apparatus characterized by adding a revision table creating means for creating a conversion rule table.