JPH08194636A - Data format conversion processing method - Google Patents

Abstract

PURPOSE: To enable the addition or change of format conversion rules by editing input data by retrieving the format conversion rules matched with a providing destination identification code when the data, to which this code is added, are inputted. CONSTITUTION: A conversion information file 5 describing the format conversion rules peculiar for each of plural providing destinations is stored in an external storage device 6 by providing destination identification codes. A CPU 3 extracts input data 1 from an external storage device 2 according to a common program 4 and stores result processing data 7 in an external storage device 8 while referring to the conversion information file 5 stored in the external storage device 7. In this case, when data 1 to which the providing destination identification code for identifying the plural providing destinations are inputted, the format conversion rules matched with this code are retrieved out of the conversion information file 5 and the input data 1 are edited based on the retrieved format conversion rules. Therefore, when adding or changing the format conversion rules, it is enough only to change the contents of the conversion information file.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data format conversion processing method, and more particularly, to a data format conversion processing method for editing data of a specific format distributed to a plurality of distribution destinations according to a format conversion rule unique to the distribution destinations. It is a thing.

[0002]

2. Description of the Related Art Conventionally, a data format conversion process for editing data of a specific format distributed to a plurality of destinations according to a format conversion rule unique to each destination is created corresponding to each conversion rule. It was implemented by individual programs.

[0003]

However, according to the above-mentioned conventional method, when a format conversion rule is added or changed, a new individual program must be created or an existing program must be modified. There is a problem.

For example, in the non-life insurance group contract premium salary deduction data providing system, it is possible to add a data providing organization (generally a company) or change the format conversion rule due to the clerical processing of the data providing organization. It happens frequently. Therefore, individual programs are frequently created and modified due to the characteristics of the non-life insurance group contract insurance premium deduction data providing system. As a result, there is a problem that the development cost and personnel of the program increase.

An object of the present invention is to provide a data format conversion processing method capable of easily adding or changing a format conversion rule even when the format conversion rule is added or changed. .

[0006]

In order to achieve the above object, the present invention stores a conversion information file in which format conversion rules unique to a service provider are described for each service provider identification code and stores the service provider identification code. At the time of inputting the added data, the format conversion rule that matches the provider identification code is searched from the conversion information file, and the input data is edited based on the searched format conversion rule. It is a thing.

[0007]

According to the above-mentioned means, the format conversion rule is retrieved from the conversion information file stored for each provider identification code when the data to which the provider identification code for identifying a plurality of providers is added. The input data is edited according to a predetermined format conversion rule corresponding to the provider identification code of the input data.

As a result, even if the format conversion rule is added or changed, the contents of the conversion information file need only be changed, and the format conversion rule can be easily added or modified.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below in detail with reference to the drawings.

FIG. 1 is a system configuration diagram showing an embodiment of an insurance premium deduction data creation system to which the data format conversion processing method of the present invention is applied.

In FIG. 1, reference numeral 1 is input data, and 2 is an external storage device for storing the input data 1. Reference numeral 3 denotes a central processing unit (hereinafter referred to as CPU) that performs various kinds of processing, and 4 denotes a common program that performs a series of processing according to the present invention.
Reference numeral 5 is a conversion information file, 6 is an external storage device for storing the conversion information file 5, 7 is processing result data, and 8 is an external storage device for storing the processing result data 7.

In FIG. 1, the CPU 3 executes a process of creating the process result data 7, takes out the input data 1 from the external storage device 2 according to the common program 4, and stores the conversion information file stored in the external storage device 6. 5, the result processing data 7 is stored in the external storage device 8.

FIG. 2 is a diagram showing the structure of the format conversion rule described in the conversion information file 5.

In FIG. 2, the format conversion rule described in the conversion information file 5 is a company code 2 which is a provider identification code for identifying the provider of the input data 1.
0, processing result data 7 from items that make up input data 1
Process classification 21 that represents the distinction of the editing process that creates, the cut-out information such as the start position 221 that represents the in-data position of the items that form the process result data 7, the digit 222, and the attribute 223 that indicates whether to correct the item content. Output field information 22, which is composed of input field information 23, cutout information such as a starting position 231 that represents the position in the data of the items that make up the input data 1 and columns 232, and input field information 23 that is an attribute 233 that indicates whether or not to correct the item content. When applied to an actual system, the standard edit pattern 24 that represents the correspondence with the process on the program that realizes some standard edit patterns performed in the applicable system, and the items that form the result process data 7 are set. And a constant value 25 used in the conditional expression for transferring the input value or extracting the input data 1.

In FIG. 2, if the processing category 21 is "A", "simple transfer" for transferring the item of the input data 1 indicated by the input field information 23 to the item of the process result data 7 indicated by the output field information 22 is performed. "B" represents "constant value transfer" in which the constant value 25 is transferred to the item of the processing result data 7 indicated by the output field information 22.

If "C", the result of editing the item of the input data 1 indicated by the input field information 23 by the process on the common program 4 corresponding to the standard edit pattern 24 is the item of the process result data 7 indicated by the output field information 22. "Standard edit pattern edit" to be transferred to the item, if "D", the item of the input data 1 indicated by the input field information 23 is transferred to the item for rearrangement of the processing result data 7 indicated by the output field information 22. "Edit".

"E" indicates that the extraction condition is that the processing result data 7 is stored in the external storage device 8 only when the item of the input data 1 indicated by the input field information 23 is equal to the constant value 25.

The attribute 223 of the output field information 22 is
If it is "Z", the previous zero space correction (correction "0" before right adjustment to space) is corrected, if it is "9", numerical correction (correct the space before right adjustment to "0"), and if it is "," comma correction ( Right-justified every three digits are filled with ","), indicating that no correction is made if nothing is entered.

FIG. 3 is a flow chart showing the processing procedure of the common program 4. In addition, this common program 4
Shall be started when a certain quantity of input data 1 is created.

In FIG. 3, first, one input data 1 is read from the external storage device 2 (step 31). Then, it is determined whether or not the data exists (step 3
2) If there is no data, the process ends. Step 3
In step 2, if the data exists (step 32:
Yes), company code 2 of this read input data 1
The conversion information file 5 matching 0 is read from the external storage device B6 (step 33). And company code 20
It is determined whether or not the conversion information file 5 matching with (step 34) exists, and if it does not exist (step 3).
4: No), preset error processing is performed (step 36), and the process returns to step 31.

When the conversion information file 5 matching the company code 20 exists (step 34: Yes), the item is edited from the input data 1 according to the described format conversion rule to create the processing result data 7. (Step 35). Then, the processing result data 7 is stored in the external storage device 8 (step 37), and the next input data 1
The process returns to step 31 to perform the process of.

FIG. 4 is a flow chart showing a detailed procedure of processing result data editing (step 35) in FIG.

In FIG. 4, first, the conversion information file 5
One piece of conversion information data read from is extracted (step 41). Then, it is determined whether or not there is data (step 42), and if there is no data, the process ends.

If the data exists in step 42 (step 42: Yes), it is determined what the processing division 21 of the extracted conversion information data is (step 43). If the processing category 21 is "A" (step 43: "A"), simple transfer is performed (step 44).

If the processing category 21 is "B" (step 43: "B"), constant value transfer is performed (step 45),
If the processing category 21 is "C" (step 43:
"C"), edit according to the standard edit pattern (step 46), and if the process classification 21 is "D" (step 43: "D"), the rearrangement item is edited (step 47). , If the processing classification 21 is “E” (step 4)
3: "E"), and a determination is made according to the extraction conditions (step 48).

Then, the process returns to step 41 to process the next conversion information data.

FIG. 5 is a diagram showing a processing result of the input data 1 according to this embodiment. In FIG. 5, (A) shows the input data 1, and (B) is the processing result data 7 obtained by processing the input data 1 according to the format conversion rule of FIG.

1 of processing result data 7 in FIG.
The edit process of the configuration item of item is explained.

First, in FIG. 2, the first processing section 21
Is a simple transfer of "A", the item indicated by the input field 23 (company code 301 of the input data 1) is set to the item indicated by the output field information 22 (company code 307 of the processing result data 7).

Since the second processing division 21 is the constant value transfer of "B", the constant values "XX to X" 251 are shown in the output field information 22 (the company name 3 of the processing result data 7).
08).

Since the third processing section 21 is the standard pattern editing of "C", the item (name code 302 of the input data 1) indicated by the input field 23 corresponds to the standard editing pattern "YY" 241 of the common program 4 It is edited in the above processing, and the result is set in the item (name code 309 of the processing result data 7) indicated by the output field information 22.
Here, the result when the standard edit pattern “YY” 241 is processed to remove “0” from the designated item is shown.

The fourth processing division 21 is a simple transfer of "A", but since the attribute 223 of the output field information 22 is "Z" 224, the item indicated by the input field information 23 (the insurance premium of the input data 1). "000000600
"0" 303) is corrected to the space before "0" and right-justified, and the result is set in the item (insurance premium "6000" 310 of the processing result data 7) indicated by the output field information 22.

Since the fifth processing category 21 is the extraction condition of "E", the item (the insurance type "ZZ" 304 of the input data 1) indicated by the input field information 23 is a constant value "Z".
Z ”252 is determined. In this case, since they are equal, it is determined that they are output targets. Input data 1
The second record No. is not determined as an output target because the insurance type “WW” 306 is not equal to the constant value “ZZ” 252, and is not output to the processing result data 7.

Since the sixth processing section 21 is a simple transfer of "A", the item shown in the input field 23 (the insurance type 304 of the input data 1) is changed to the item shown in the output field information 22 (the processing result data 7). Set to insurance type 311).

Since the seventh processing category 21 is the item editing for rearranging "D", the item indicated by the input field 23 (contract date 305 of the input data 1) is indicated by the item indicated by the output field information 22 (process result data). Sorting item 3 of 7
12).

As described above, according to this embodiment, with respect to the input data 1, the format conversion rule described in the conversion information file 5 stored in the external storage device B6 is referred to, and the item content Even if the format conversion rule is added or modified by cutting out, assembling, and performing format conversion, it is only necessary to change the format conversion rule in the conversion information file 5, and an individual format conversion program can be added. No need to fix.

In the embodiments, the example in which the present invention is applied to the process of creating insurance premium deduction data has been described, but the present invention is not limited to this, and various data are output to It can be applied when converting to a format required by a provider or the like.

[0038]

As described above, according to the present invention,
A conversion information file that describes a predetermined format conversion rule corresponding to each of a plurality of formats is stored for each provider identification code, and when the data with the provider identification code is input, this provider identification code and The format conversion rule that matches is searched from the conversion information file, and the input data is edited based on the searched format conversion rule. The format conversion rule described in the conversion information file may be changed, and additions and corrections can be easily performed.

Further, by describing in the conversion information file extraction conditions and rearrangement items unique to the provider identification code, it is possible to easily perform extraction and setting of rearrangement items during format conversion. There is.

Therefore, when the data format conversion processing method according to the present invention is applied to, for example, a non-life insurance group contract insurance premium deduction data providing system, a program for assembling item contents and format conversion processing is added. There is an effect that the format conversion rule can be added or modified very easily without the need for modification.

[Brief description of drawings]

FIG. 1 is a block diagram of an embodiment of the present invention.

FIG. 2 is a diagram showing a configuration of a conversion information file according to an embodiment.

FIG. 3 is a flowchart showing a processing procedure of an embodiment.

FIG. 4 is a flowchart showing an editing processing procedure of the embodiment.

FIG. 5 is an explanatory diagram for explaining a processing result of the embodiment.

[Explanation of symbols]

1 ... Input data, 2 ... External storage device, 3 ... Central processing unit (CPU), 4 ... Common program, 5 ... Conversion information file, 6 ... External storage device, 7 ... Processing result data, 8 ... External storage device.

Claims (2)

[Claims] 1. A data format conversion processing method for editing data of a specific format distributed to a plurality of providers according to a unique format conversion rule for each provider, wherein the unique format conversion rule is described. A conversion information file is stored for each recipient identification code, and when the data with the recipient identification code added is input, the input data is edited based on the format conversion rule that matches the recipient identification code. A data format conversion processing method comprising: 2. A data extraction condition and a rearrangement order unique to each destination are described in the conversion information file, and data extraction and rearrangement order are set at the time of format conversion. 1. The data format conversion processing method described in 1.