JP3143909B2 - File processing device - Google Patents

Description

Description: TECHNICAL FIELD The present invention relates to a file processing device.

[Prior Art] Conventionally, in a file processing apparatus using an office computer or the like, when a plurality of files are merged in a general-purpose language such as COBOL and output as one form, the format and record of the form to be obtained are obtained. In addition to the above order, the design and coding are performed in consideration of whether or not each input file needs to be sorted, that is, whether or not each file has a required record order.

[Problems to be Solved by the Invention] As described above, in the conventional file processing apparatus, when performing file merging, it is necessary to set merging in consideration of the physical structure of the file. Was troublesome.

SUMMARY OF THE INVENTION An object of the present invention is to provide a file processing device that can perform file merging with a simple definition without being aware of the physical structure of the file when merging the files.

[Means for Solving the Problems] The means of the present invention are as follows.

(1) Setting means for setting the correspondence between the file name of a file to be merged among a plurality of files and the word name of a common word in each file.

 For example, the file merger memory 16.

(2) Processing means for processing the record of the file corresponding to the file name set by the setting means into the record of the set common word.

For example, the CPU 11 processes a record of a specified file in accordance with the contents set in the file merger memory 16.

(3) Merging means for merging the files based on the records processed by the processing means.

For example, the CPU 11 merges files processed based on the settings in the file merger memory 16.

[Operation] The operation of the means of the present invention is as follows.

When performing file merging, first, the correspondence between the file name of the file to be merged and the word name of the common word in each file is set in the file merger, and is described in the file merger memory. When the file merger is set, all records of each designated file are processed into records of a common word based on the set contents. After that, a plurality of files processed into the record of this common word
Merged into two files.

By defining the correspondence between the file to be merged and the common word in each file as described above, each file is merged based on that definition, so simple definitions can be made without being aware of the physical structure of the file Can be used to merge files.

Embodiment An embodiment will be described below with reference to FIGS. 1 to 6.

FIG. 1 is a block diagram showing the overall configuration. In the figure, reference numeral 11 denotes a CPU for controlling the entire circuit, which can perform variable length processing. The CPU 11 has an input unit 13, a display unit 14, a key definition document memory 15, a file merged document memory 16, an output definition document memory 17, a form creation unit via a bus line 12.
18, a sort flag memory 20, a file-specific record structure memory 21, a source file group 22, a processed file 23, a sorted file group 24, and a merge file 25 are connected. Also,
A form output unit 19 is connected to the form creation unit 18.

The key definition document memory 15 stores a key definition document for each source file shown in FIG. 2, and a source file name and a keyword are set in each key definition document. The settings in the key definition document memory 15 are referred to when determining whether or not sorting is necessary.

The file merger memory 16 is used to set the correspondence between the file name to be merged and the word name of the common word in each file when merging the files. As shown in FIG. , Word N
o. Instruction data relating to file merging such as processing word names, file word names, etc. are stored and set. In FIG. 3, a portion indicated by hatching is an item name storage column in which a predetermined item name is written in advance.

The output definition document memory 17 stores an output definition document. In each output definition document, a word name to be output and an output x coordinate indicating an output position are set. This output definition document memory
The setting contents of 17 are referred to by the form creation unit 18. That is, the form creation unit 18 stores the output definition document memory 17 at the time of form creation.
Refer to the setting contents of, and create the form data
Output to 19 and print out.

The sort flag is set in the sort flag memory 20 when it is determined that sorting is necessary when determining whether or not sorting is necessary.

The file-specific record structure memory 21 stores the record structure of each file in the source file group 22. As the data, a file name, a keyword, a word number, a word name, and the like are set. Source files 22
Stores records sorted, for example, in ascending order based on the keywords.

Next, the operation of creating a form by merging files in the above embodiment will be described with reference to the flowcharts of FIGS. For example, as shown in FIG. 6, for files A, B, and C, description will be made assuming that data of “charge code”, “district code”, and “sales record” are merged in “charge code order”. In this case, in file A, "affiliation-responsibility C", "district C", and "sales" are set as file word names, and "affiliation-responsibility C" is sorted as a keyword. This "affiliation-assignment C" is composed of a 2-digit assignment code and a 6-digit assignment code. In the file B, “person in charge CODE”, “district CODE”, and “sales” are set as file word names, and “person in charge CO
DE "as a keyword. File C
, "Employee CD", "Common CD", "District CD",
A file word name of "Achievement" is set, and "Employee CD" is sorted as a keyword.

4 is executed under the control of the CPU 11 by inputting an instruction to create a form by merging files from the input unit 13. The processing shown in this flowchart is executed under the control of the CPU 11. First, the CPU 11 displays the key definition document setting screen shown in FIG. 2 on the display unit 14, and guides data input relating to the definition key. On this input screen, the user defines a keyword (step A1). As shown in the example of FIG. 6, when a table of sales results is created in the order of the code of the person in charge, "person code" is defined as a keyword.
In the case of this file merger, it is not necessary to define a file name. The above key definition document is key definition document memory
Stored in 15.

When the setting of the key definition document is completed, the flow advances to step A2 to display a file merged document setting screen shown in FIG.
To be displayed. That is, the item names "process", "file name", "process word name", and "file word name" indicated by hatching in FIG. 3 are displayed to guide the data input.
As described above, for files A, B, and C, when the data of “charge code”, “district code”, and “sales record” are merged in “order of charge code”, Enter "File Merge" and enter the file name of "A", "B", "C" for the item of "File name",
In the item of “processing word name”, “charge code”, “district code”, and “sales record” which are common word names are input.

Then, for the item of “file word name”, the above “charge code”, “district code”, and “sales record” are set for each of the files A to C. That is, file A
In the above, since the two-digit belonging code and the six-digit assigned code are combined, the assigned code and the assigned code are divided as a file word for the "assigned code" of the file A, and the six digits from the third most significant digit are divided. Set to take out the charge code for minutes. In addition, a file word name is set so that data of “district C” as a district code and “sales” as a sales result of the file A are extracted.

Similarly, as the file word name of the file B, “person in charge”, “district code”, and “sales” are set. Further, as the file word names of the file C, "common charge CD", "district CD", and "actual" are set. In addition,
The file C contains "employee CD", but this data is unnecessary for creating a form, and is not taken out. The correspondence between the file name of the file to be merged and the word name of the common word in each of the files A to C is set as described above. This file merger is stored in the file merger memory 16.

When the setting of the file merger is completed, the output definition is set. In this output definition document, the name of the word to be output, for example, "charge in charge", "area code", "sales record"
Is set, and the output x coordinate is set. This output x
The coordinates specify the position of the print start digit of the output data, and are set with reference to, for example, an x-coordinate guide displayed on the screen. This output definition document is stored and set in the output definition document memory 17.

Next, the file merge processing shown in step A4 is executed according to the definition contents set in steps A1 and A2. The details of the file merging process will be described later.

Then, when the above file merge processing is completed, the form creation unit 18 operates, creates a form from the result of the file merge processing according to the definition contents of the output definition document memory 17,
The data is output to the form output unit 19 and printed out.

Next, details of the file merging process in step A4 will be described with reference to the flowchart of FIG. First,
The first file, that is, file A is designated by referring to the setting contents of the file merger memory 16 (step B).
1). Then, the current keyword in the designated file A is read from the file-specific record structure memory 21 and the keyword newly defined by the key definition book memory 15 is read (steps B2 and B3). It is determined whether or not it is (step B4).
The necessity of the specified file is determined by the processing of steps B2 to B4. If the two do not match, it is determined that sorting is necessary, and a sort flag is set in the sort flag memory 20 (step B5). If so, it is determined that sorting is unnecessary, and the sorting flag is reset (step B6). The keyword of the file A is “affiliation-assignment code”, the newly defined keyword is “assignment code”, the two keywords do not match, and the sort flag is set.

Next, all records of the designated file are processed in the file merger memory 16 based on the set contents, and written into the processed file 23 (step B7). At this time, for the file A in the source file group 22, as shown in FIG. 6, the "code in charge" is separated and taken out from the "affiliation-charge C", and the "district C" and "sales" are read out. Processing file 23
Are respectively written as "charge code", "district code", and "sales record". That is, each record of the file A is processed into a record of a common word and written into the processed file 23.

Next, the presence or absence of a sort flag is checked from the stored contents of the sort flag memory 20 (step B8). File A
Since the flag is set for, step B9
Then, the file A stored in the processed file 23 is sorted by the newly defined keyword “charge code” and stored as the file A ′ in the sorted file group 24.

Subsequently, it is determined whether or not another file is designated by the file merger memory 16 (step B11). If another file is designated, the next file, in this case file B, is designated (step B11). B12). Thereafter, the process returns to step B2, where the current keyword “charge code” in the file B is read, and the keyword “charge code” defined by the key definition document memory 15 is read and compared (steps B3 and B4). In this case, since both keywords match, the flag in the sort flag memory 20 is reset (step B6), and all records of the file B are processed based on the file merger memory 16 (step B7). Write to file 23.

Next, the presence / absence of a sort flag for file B is checked from the contents stored in the sort flag memory 20 (step B8). Since the flag is not set for the file B, the process proceeds to step B10, and the file B stored in the processed file 23 is transferred to the sorted file group 24 as a file B 'without sorting.

Subsequently, the process proceeds to step B12 via step B11, specifies the next file C, and returns to step B2. This file C
Since the current keyword is different from the newly defined keyword, the sort flag is set in the sort flag memory 20, all records are processed based on the file merger memory 16, and the sort processing is performed. group
24 is stored as file C '.

As described above, the process for all the files set in the file merger memory 16 is completed, and the process proceeds to step B13 via step B11. In this step B13, as shown in FIG. 6, the files A ', B', C 'stored in the sort file group 24 are merged based on the keyword "charge code" defined in the key definition memory 15. And writes it to the merge file 25. As a result, files A ', B', C '
Are sorted in the order of “assigned code”, collected into one file, and stored in the merge file 25.

Thus, the file merge processing in step A4 is completed, and the process proceeds to step A5 in FIG. In step A5, the form creation unit 18 creates a form from the storage data of the merge file 25 in accordance with the definition contents of the output definition memory 17, and outputs the form
Output to 19 and print out.

As mentioned above, multiple files are stored in the file merger memory
The merging process is performed according to the 16 setting contents, the files are combined into one file, and a form is created according to this file.

[Effects of the Invention] As described in detail above, according to the present invention, the correspondence between the file name of the file to be merged and the word name of the common word in each file is defined, and the files are merged based on this definition. Therefore, the file can be merged with a simple definition without being aware of the physical structure of the file.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a circuit configuration of a file processing device according to an embodiment of the present invention, FIG. 2 is a diagram showing a setting example of a key definition document, FIG.
FIG. 4 is a flowchart showing the overall processing operation of form creation, FIG. 5 is a flowchart showing details of the file merging process, and FIG. 6 is a diagram showing a specific example of file merging. 11 ... CPU, 12 ... bus line, 13 ... input section, 14 ...
Display unit, 15: Key definition memory, 16: File merger memory, 17: Output definition memory, 18: Form creation unit, 19: Form output unit, 20: Sort flag memory, 22
... source files, 23 ... processed files, 24 ... sorted files, 25 ... merged files.

Claims (2)

(57) [Claims] 1. A setting means for setting a correspondence between a file name of a file to be merged among a plurality of files and a word name of a common word in each file, and a record of a file corresponding to the file name set by the setting means. A file processing apparatus comprising: processing means for processing into a record of a set common word; and merging means for merging each file based on the record processed by the processing means. 2. A display device for designating a correspondence between a file name to be merged among a plurality of files and a word name of a common word in each file on a display screen, wherein the setting means is specified by the display means. 2. The file processing apparatus according to claim 1, wherein a correspondence between the file name and a word name of a common word in each file is set.