JPH10187672A - Data processor - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily generate an output document in different format which uses the same data. SOLUTION: A totalization definition table which defines a method for totalizing data from a data file stored in data file storage part 20C is stored previously in a totlization definition table storage part 20A and print format definition tables defining printing-out methods for the totalized data are stored in a print formed definition table storage part 20B. A CPU 10 lists the said print format definition tables on a display device 14 and prompts a user to make a choice on an input device 12, extracts data from the said data file according to the said totalization definition table and totalizes them, and prints the totalized data out by printer 16 according to the print format definition table that the use has selected.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a data processing apparatus for processing record data from an accounting file, a personnel file, and the like in an office computer, a personal computer, or the like.

[0002]

2. Description of the Related Art Conventionally, in an office processing device such as an office computer or a general-purpose computer, an accounting file,
Various types of files such as personnel files, sales slip files, and inventory files are stored and managed, but the record structure that constitutes each file is different for each file.
Each file is stored and managed as a separate file for each record of the same form (records in which each item of the record matches). Here, when an arbitrary item is specified and a record including the item is read out from the file and classified and totaled, even if a data in the item is first classified and classified so that it is easy to classify and total, the time elapses. As a result, the classification does not match the reality, and the classification and totaling cannot be performed as it is at present. Therefore, conventionally, as a countermeasure, a code conversion table for classifying and totaling is provided, and a method of classifying and totaling by converting the code system into an optimal code system for classifying and totaling using the code conversion table has been widely adopted at present.

However, in the method using a code conversion table, a system engineer, who is an expert, has to create a code system (conversion table) for classification and aggregation. In other words, creating a classification code system in response to various business needs requires extremely specialized and advanced knowledge, and it is extremely difficult for a general user's business staff to create it. At present, it was necessary to ask a system engineer to create it.

[0004] In addition, the business person in charge of a general user can understand the name of the slip used daily and the name of the slip item.
In order to know what files are stored and managed in office computers, how the record structure is structured, what items are present in which files, etc., you must refer to the system design document. From this point of view, it has been extremely difficult for business staff to obtain a desired form.

Accordingly, the applicant of the present invention proposes that even if a business person or the like directly specifies the item contents to be extracted as an output record in accordance with the output image of a form or the like by using the slip name and the slip item contents, the specified contents Invented a data processing device capable of reading data from a predetermined file and outputting a form or the like according to Japanese Patent Application No. 5-112352.
No. has been filed.

[0006] The data processing apparatus of the present application provides a summary definition table (A) that defines the record name of the summary record and the item contents to be drawn as the summary record in accordance with the summary level.
Table), and the item names to be extracted as the data items of the aggregation record and the aggregation item to be extracted as the data item corresponding to the item name, or the format defining the form when printing the form and the extraction conditions of the aggregation item, etc. It has a format definition table (Table B), extracts records from the file based on the total definition table, and prints out the records according to the print format definition table.

[0007]

As described above, in the data processing apparatus of the above-mentioned application, a total definition table and a print format designation table exist in a one-to-one relationship. As a result, even when using the same data, when creating an output form in a different format, there is a problem that a combination of a different summary definition table and a print format specification table must be created each time. .

Conversely, when an output form in the same format is created using different data, another combination of a total definition table and a print format designation table must be created each time.

An object of the present invention is to make it possible to easily create output forms of different formats using the same data. Another object of the present invention is to make it possible to easily create an output form in the same format using different data.

[0010]

The means of the present invention are as follows. The tallying definition table storage means stores a tallying definition table that defines a tallying method of data from the data file. The tallying means extracts data from the data file based on the data tallying definition table stored in the tallying definition table storage means and totals the data. The print format definition table storage unit stores a plurality of print format definition tables that define a print output method of the aggregated data. The selection unit selects one of the plurality of print format definition tables stored in the print format definition table storage unit. The printout unit prints out the tabulated data tabulated by the tabulation unit based on the print format definition table selected by the selection unit.

The operation of the means of the present invention is as follows. Create a data summary definition table that defines the method of summarizing data from the data file in advance, or read it from the outside, store it in the summary definition table storage means, and define the printout method of the aggregated data. A plurality of print format definition tables are created or read from outside, and stored in the print format definition table storage unit. Then, when performing data tabulation based on the data tabulation table and printing out the tabulated data based on the print format definition table, the tabulation means uses a data file based on the data tabulation definition table stored in the tabulation definition table storage section. Extract and aggregate data from
The selection means selects one of the plurality of print format definition tables stored in the print format definition table storage means, and, based on the selected print format definition table, tabulates the data by the printout means by the aggregation means. Print out the aggregated data. Accordingly, output forms using the same data and having different formats can be easily created.

Another means of the present invention is as follows. The tally definition table storage means stores a plurality of tally definition tables that define a method of tallying data from the data file. The selection means selects one of the plurality of data tally definition tables stored in the tally definition table storage means. The tallying means extracts data from the data file based on the data tallying definition table selected by the selecting means and totals the data. The print format definition table storage unit stores a print format definition table that defines a print output method of the aggregated data. The print output unit prints out the tabulated data tabulated by the tabulation unit based on the print format definition table stored in the print format definition table storage unit.

The operation of another means of the present invention is as follows. In advance, a plurality of data aggregation definition tables that define the aggregation method of data from the data file are created, or read from the outside, stored in the aggregation definition table storage unit, and the printout method of the aggregated data is defined. Create a print format definition table to define or read from outside,
It is stored in the print format definition table storage means. When performing data tabulation based on the data tabulation table and printing out the tabulated data based on the print format definition table, the selection unit selects one of the plurality of data tabulation definition tables stored in the tabulation definition table storage unit. , And based on the selected data totaling definition table, data is extracted from the data file by the totalizing means and totalized, and the totalized data is stored in the print format definition table storing means by the printout means. Print out based on the print format definition table stored in the. Therefore, an output form in the same format can be easily created using different data.

[0014]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to FIGS. FIG. 1 is a diagram showing a configuration of a personal computer to which a data processing device according to an embodiment of the present invention is applied. In FIG. 1, reference numeral 10 denotes a CPU for controlling the whole. Reference numeral 12 denotes an input device such as a keyboard and a mouse, 14 denotes a display device such as a CRT, and 16 denotes a printing device such as a page printer.

Reference numeral 18 denotes an operating system (O
S), a first external storage device such as a hard disk for storing programs such as input control, file control, data processing control, and other information, and 20 is a tally definition table storage unit 20A that stores a tally definition table. A second external storage device such as a hard disk including a print format definition table storage unit 20B that stores a print format definition table and a data file storage unit 20C that stores various data files such as an accounting file and a personnel file. Here, in the present embodiment, it is assumed that at least one of the total definition table storage unit 20A and the print format definition table storage unit 20B stores a plurality of definition tables.

Reference numeral 22 denotes a RAM used as a work memory when the CPU 10 executes the program stored in the first external storage device 18. The RAM 22 is used to expand the program and other information and to execute the program. Necessary registers are temporarily configured.

The program stored in the first external storage device 18 and the data stored in the data file 20C of the second external storage device 20 may be stored in advance, or may be stored on a floppy disk or optical disk. A medium stored in a portable storage medium 24 such as a (magnetic) disk is read out by a medium driving device 26 or a network 28
May be fetched via the network connection device 30 and stored in the external storage devices 18 and 20.

In addition to the program stored in the first external storage device 18, the CPU 10
4 or a program provided via the network 28 may be directly loaded into the RAM 22 and directly executed.

FIG. 2 shows a tabulation defined in the tabulation definition table storage unit 20A of the second external storage device 20, which defines the record name of the tabulation record and the item contents to be drawn as the tabulation record corresponding to the tabulation level. Definition table (Table A) 20A1
FIG. The A table 20A1 is created by a user arbitrarily inputting parameters such as a record name for a predetermined basic format (ruled line data and the like) displayed on the display device 14. The details are described in Japanese Patent Application No. 5-112352 filed by the present applicant, and the description thereof is omitted here.

FIG. 3 also shows an item name to be extracted as a data item of a total record and a data item corresponding to the item name stored in the print format definition table storage unit 20B of the second external storage device 20. FIG. 13 is a diagram showing a print format definition table (Table B) 20B1 that defines the tabulation target items to be extracted, the format at the time of printing the form, the extraction conditions of the tabulation target items, and the like. This B table 20B1 is also similar to the above A table 20A1,
The user arbitrarily inputs a parameter such as a record name for a predetermined basic format (ruled line data or the like) displayed on the display device 14 and generates the data. Since it is described in detail in JP-A-112352, the description is omitted here.

In the present embodiment, at least one of the table A and the table B is prepared in a plural number and stored in the second external storage device 20. For example, as shown in FIG. 3, a plurality of B tables 20B1, 20B2,... Are stored in the print format definition table storage unit 20B of the second external storage device 20.

FIGS. 4A and 4B are diagrams showing respective record contents of the plan file and the accounting file stored in the data file storage unit 20C of the second external storage device 20.

Next, the operation in such a configuration will be described. FIG. 5 is a flowchart of a form output process executed by the CPU 10. First, a plurality of summary definition tables (table A) stored in the summary definition table storage unit 20A of the second external storage device 20 are displayed on the display device 14. The list is displayed (step S10), and the user is allowed to select a total definition table (step S12). Of course, in this case, the total definition table storage unit 2
If only one total definition expression is stored in 0A, these steps can be omitted.

Next, it is determined whether or not a plurality of print format definition tables are stored in the print format definition table storage unit 20B of the second external storage device 20 (step S14). If only one print format definition table is stored, it is selected. (Step S16), and when a plurality are stored, they are displayed in a list on the display device 14 (step S18), and the user makes a selection (step S20).

Then, a tabulation process based on the selected tabulation definition table is performed (step S22), and a form based on the selected print format definition table is printed out by the printing device 16 (step S24). In addition, these totaling processing and form print output processing are described in Japanese Patent Application No. Hei.
No. 12352, the description of which is omitted here.

As described above, since it is possible to define a plurality of print format definition tables (Table B), it is possible to output a form in a plurality of formats from the same data. In addition, since it is possible to define a plurality of total definition tables (Table A), it is possible to create forms in the same format while changing the extracted data.

[0027]

According to the present invention, it is possible to easily create output forms having different formats using the same data. Further, according to the present invention, an output form in the same format can be easily created using different data.

[Brief description of the drawings]

FIG. 1 is a block diagram of a personal computer to which a data processing device according to an embodiment of the present invention is applied.

FIG. 2 is a diagram showing a summary definition table (Table A).

FIG. 3 is a diagram showing a print format definition table (Table B).

FIGS. 4A and 4B are diagrams showing respective record contents of a plan file and an accounting file.

FIG. 5 is a flowchart of a form output process for explaining the operation of the embodiment.

[Explanation of symbols]

 Reference Signs List 10 CPU 12 Input device 14 Display device 16 Printing device 18 First external storage device 20 Second external storage device 20A Total definition table storage unit 20A1 Total definition table (Table A) 20B Print format definition table storage unit 20B1, 20B2 Print format definition Table (Table B) 20C Data file storage unit 22 RAM 24 Portable storage medium 26 Medium drive device 28 Network 30 Network connection device

Claims (5)

[Claims] 1. A totaling definition table storage means for storing a data totaling definition table defining a method of totalizing data from a data file, and a data totaling definition table stored in the totaling definition table storage means. Tabulation means for extracting and totaling data; print format definition table storage means for storing a plurality of print format definition tables for defining a print output method of the totalized data; and a plurality of print format definition table storage means for storing the print format definition table storage means. Selecting means for selecting one of the print format definition tables, and a print output means for printing out the total data calculated by the totaling means based on the print format definition table selected by the selecting means, A data processing device comprising: 2. The aggregation definition table storage means stores a plurality of data aggregation definition tables, and selects an aggregation definition table for selecting one of the plurality of data aggregation definition tables stored in the aggregation definition table storage means. 2. The data processing device according to claim 1, further comprising a unit. 3. A totaling definition table storage means for storing a plurality of data totaling definition tables defining a method of totalizing data from a data file, and one of the plurality of data totaling definition tables stored in said totaling definition table storage means. Selecting means for selecting the data, a totaling means for extracting and totaling data from the data file based on the data totaling definition table selected by the selecting means, and a print format for defining a printout method of the totalized data. A print format definition table storage unit that stores the definition table; and a print output unit that prints out the aggregation data aggregated by the aggregation unit based on the print format definition table stored in the print format definition table storage unit. A data processing device comprising: 4. A process for storing a data totaling definition table defining a method of totalizing data from a data file when performing data totaling based on a data totaling table and printing output of the totaling data based on a print format definition table. A process of storing a plurality of print format definition tables that define a print output method of the aggregated data; a process of extracting and totaling data from a data file based on the stored data aggregate definition table; A process for selecting one of the plurality of print format definition tables, and a process for printing out the tabulated total data based on the selected print format definition table. A computer-readable recording medium that stores 5. The process of storing the data summary definition table and the process of storing a plurality of print format definition tables include the process of creating and storing the data summary definition table and the print format definition table, or the process of storing and storing the data summary definition table and the print format definition table. 5. The recording medium according to claim 4, further comprising any one of processing for reading and storing a format definition table from outside.