JPH0245217B2 - - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a table repetition control method for data processing in a data processing device having a card image processing function, and in specifying the range of table repetition processing, The present invention relates to a table repetition control system for card processing in which it is possible to specify the last row or column in which data has been entered.

[Conventional technology]

Conventionally, in general office processing, it has been widely adopted to store information in the form of cards and use this information. It is desirable to be able to do this. However, when trying to manage card data using a regular Japanese word processor, etc., the format information of the card, including ruled lines and fixed characters, and the card data, which differs for each individual card, are not distinguished. Since the information is stored in an integrated form, not only is the storage area wasted, but it is also impossible to perform various processes such as search processing and calculation processing regarding the entry fields of the card. Therefore, the present inventors have developed a data processing device that manages common form data and individual card data separately and has card image processing functions such as document processing functions, table creation functions, calculation processing functions, and procedure registration functions. is proposed.

In the data processing device having the above-mentioned card image processing function, a format consisting of fixed information common to cards is first defined by creating a format image of the card on the screen using character keys, etc., and subsequent card creation In this case, data of a predefined format image is called up, and variation data for each card is entered in fields defined by this format to create individual cards. Calculation, search, and other processing procedures are registered in advance for the contents of the fields, and the registered processing procedures can be called up and executed at any time.

[Problem that the invention seeks to solve]

Many of the data handled by the above-mentioned cards have common attributes in the row or column direction in the arrangement of fields, and these can be handled as a so-called "table". However, according to the conventional method, when instructing repetition of processing on a table, it was only possible to specify a repetition range for the entire table. However, in general, the size of the table is often made larger to allow for some margin, and there are often fields in the table with no data entered. As a result, there are problems in table repetition in which unnecessary processing is performed for fields in which no data has been entered, and in that it is not possible to set the repetition processing target in a table to a row in which no data has been entered.

[Means for Solving the Problems] The present invention aims to solve the above-mentioned problems, and provides a table repetition function that enables specification of the last row or last column in which data has been entered when specifying the table repetition range in card processing. In order to provide this service, it is characterized by the following means: That is, the table repetition control system for card processing of the present invention includes a display, a format information storage section that stores card format information including ruled lines or fixed characters, and a field definition information storage section that stores definition information regarding fields to be filled in on the card. and a card data storage section for storing the contents entered in the entry fields of each card, and displays the contents of the form information storage section and the card data storage section on the display screen in the field. A card that generates and displays a card image in a format buffer by merging based on the contents of a definition information storage unit, and also instructs each field on the card image to give a processing mode and processes the card contents. A table repetition control method for card processing in a data processing device having an image processing function, which includes a procedure registration control unit that controls the registration of processing procedures for the card contents, and an attribute in the arrangement of fields that is common in the row direction or column direction. A table repetition instruction that repeats the process row by row or column by column in the above processing procedure for the rows or columns included in the table to be processed, and also allows input of at least the final position where data has been filled in for the position of the repetition range. a procedure storage section that stores the processing procedure; a procedure execution control section that controls the execution of the processing procedure stored in the procedure storage section; and a procedure execution control section that executes table repetition instructed by the table repetition instruction section. and a table repetition execution unit having means for searching for a position where data has been written in response to the designation of the final data-filled position. Hereinafter, embodiments will be described with reference to the drawings.

〔Example〕

FIG. 1 is a block diagram of the essential parts of an embodiment of the present invention, FIGS. 2 and 3 are diagrams for explaining the concept of card images and boxes related to the present invention, and FIGS. 4 and 5 are FIG. 6 is a diagram for explaining processing aspects related to the present invention. FIG. 6 is an overall outline diagram of an embodiment to which the present invention is applied. FIG. 7 is an explanatory diagram of information stored in the field definition information storage unit. Figure 8 is a diagram for explaining the correspondence between the format buffer and the screen code buffer, Figures 9 and 10 are diagrams for explaining the aspect of specifying the table repetition range according to the present invention, and Figure 11 is a diagram for explaining the mode of specifying the table repetition range according to the present invention. 1 is a diagram illustrating a processing overview of an embodiment of the present invention.

In the case of a data processing device having a card image processing function related to the present invention, a card image having a predetermined card format is displayed on a display and processing is executed. That is, for each card image, format data as shown in FIG. 2, for example, and field contents (card data) given corresponding to fields (items) such as "product name" on the format image are separated. The data of both are stored in the data and the data of both are merged and displayed on the display as necessary. And it is considered to represent one card.

The fields on the card image include a character field and a numeric field. Then, on the form data, "..." is given to indicate the character insertion point corresponding to the character field,
``〓〓〓, 〓〓〓 are given corresponding to the numeric fields to indicate where to insert the numeric value.

For example, as shown in Figure 2, if fields such as "Product Name", "Quantity", "Unit Price", and "Amount" are consecutive, specify only the first field group and have the same attributes. For the field sequence part, you only need to specify the repetition of the first field group. Such a repetition of a group of fields, as opposed to a single independent field, is called a "table". Of course, procedures such as entering, editing, calculating, and searching data in fields included in a table can be performed in the same way as for independent fields, but for fields with common attributes in a table, Table repetition makes it possible to perform batch processing.

Since there are generally many cards that share the format data shown in Figure 2, the card images corresponding to these cards are collected and managed by introducing the concept of "box" as shown in Figure 3. . Reference numeral 1 represents a card image, and reference numeral 2 represents a box. In order to manage boxes as a single processing unit, the following information (or storage unit) is prepared corresponding to each box. That is, (i) Box management information (storage unit): profile information such as box number and box name.

(ii) Format data (storage unit)...Data corresponding to the card format (blank card) as shown in Figure 2.

(iii) Field definition information (storage part)...Field start coordinates and attributes (number of digits, number of lines, etc.) for each field.

(iv) Card data (storage unit): Contents of each field corresponding to each card image belonging to the same box, each associated with a page.

FIG. 4 shows an example of the manner in which processing is performed in this embodiment, and it may be considered that the display as shown in the figure is displayed on the display and the processing begins. The screen on the display can simultaneously display a card image in the first frame, a card image in the second frame, and an input image when inputting a processing procedure or the like.

In the case shown in Figure 4, all or part 3 of the card image addressed to Mr. Fujitsu Taro on the 7th page belonging to the box ``Membership Fee Bill'' is placed in the first frame, and the card image 3 belonging to the box ``Membership Fee Deposit Slip'' is placed in the first frame. All or part 4 of the card image of Mr. "Taro Fujitsu" on the 7th page is displayed together in the second frame (split display). Then, input image 5 is displayed,
Instructs to transfer the contents of the second line of the "Billed Amount" field, which is a field on the card image in the second frame, to "Current Billed Amount", which is a field on the card image in the first frame. . As this input image, a calculation procedure regarding the field can be given. For example, after giving a calculation instruction to card image 1 of the "deposit slip" shown in Figure 3, press the "x", "=", and "execute" keys. By placing the cursor on each field and pressing a key, it is also possible to display a processing procedure for entering the result of "unit price x quantity" in the "total" column and execute the calculation.

FIG. 5 shows a mode in which the same process is performed for multiple fields on multiple cards. In this example, the process "Quantity x Unit Price = Amount" is executed for the 1st page to 30th page of the card, from the 1st line to the 10th line of the product name, and the instruction is to calculate the total for each. . These processing procedures can be registered and stored, and can be called up and executed at any time. In addition, searching, sorting, card verification, etc. are also possible.

FIG. 6 shows a schematic configuration of an embodiment of a data processing device having a card image processing function related to the present invention.

In the figure, reference numeral 8 is a keyboard, 9 is a keyboard control section, and 10 is a card image processing section, which inputs information about the card, displays the card image on the display screen, and processes the contents of the fields on the card image. 11 is a form creation management section that inputs and manages the card image format corresponding to each box; 12 is a form analysis section that inputs fixed information, item attributes, etc. when creating a form. 13 is a card creation management unit that inputs and manages individual card data;
Reference numeral 14 is a data entry control unit which inputs card data, field names, etc. using a so-called kana-kanji conversion function, and 15 is a list control unit which controls display of a list of specific fields of the card. , 16 is a procedure registration control unit that performs control to register a processing procedure such as the input image shown in FIG. 5, 17 is a procedure storage unit that stores the registration processing procedure, and 18 is a procedure An execution control section 19 controls the execution of specified processing procedures, and a calculation control section 19 controls execution of calculations specified for numerical fields.

Further, 20 is a box management unit that selects a box to be processed for the time being and manages its data, 21 is a storage control unit that controls writing to the data storage device, and 22 is a call control unit. 23 is a page switching section that switches from one card's worth of data to the next card data; 25 is a section for controlling data such as a floppy disk device; Storage device, 26 is a box management information storage unit, 27 is a form data storage unit, 28
29 is a field definition information storage section, and 29 is a card data storage section. Box management information storage section 26
The form data storage section 27, field definition information storage section 28, etc. are stored and managed for each box.

31 is a format buffer from which the contents of the format data storage section 27 are read and card data is embedded thereon to generate a card image; 32 is a record buffer from which card data is read; 33 is a field definition. information battle,
34 is a list format buffer that corresponds to the format buffer 31 for the list; 35 is a list record buffer that corresponds to the record buffer 32 for the list; 36 is a list field definition. Represents information buffer.

Further, 40 is a window control unit that controls cutting out data from format buffers 31, 31', etc. according to predetermined display frame (window) information, and 41 is a screen code buffer that stores code information to be displayed on the display. what is done, 4
2 is a display control unit that controls displaying the contents of the screen code buffer 41 on the display; 43 is a display such as a CRT;
Reference numeral 44 represents a print control unit that controls outputting information regarding the card to a printer, and 45 represents a printer.

As explained in connection with Figure 3, the box is
It consists of an entire series of card images having common format data, and includes at least format data, field definition information, and individual card data. The format of each box is determined by the operator using the data entry control section 14 on the screen of the display 43.
It is created according to the results of entering characters etc. using the kana-kanji conversion function in . Form creation management department 1
1, the format analysis section 12 determines definition information and field names for each field, and the box management section 20 stores the results in the format data storage section 2.
7. Store in the field definition information storage unit 28 or the like.

The form data storage section 27 stores, for example, a form as shown in FIG. The field definition information storage unit 28 stores information 50 as shown in FIG. 7, for example.
have. That is, the field includes an independent item 50A and a table item 50B, and the number of items and each item attribute are stored as independent items. Further, as table items, vertical attributes (number of rows, each Y coordinate) and horizontal attributes (number of items, each item attribute) are stored.
Each of the item attributes described above includes information such as the record buffer address, the starting coordinates of the item within the card, the number of digits and lines, and the type of character field/numeric field.

The card creation management unit 13 stores the data entered in the form image determined by the form data and field definition information in the card data storage unit 29.
be stored and managed. For example, when calling a box to display a card image, the contents of the form data storage section 27 are loaded into the form buffer 31, the contents of the field definition information storage section 28 are read into the field definition information buffer 33, and then the The contents of the card data storage section 29 read into the buffer 32 are merged on the format buffer 31 according to the contents of the field definition information buffer 33, and this is transferred to the screen code buffer 41.

As explained in connection with FIG. 4, a plurality of display frames can be provided on the display screen to display parts of a plurality of card images. That is,
As shown in FIG. 8, the window control unit 40 extracts data 51 and 51' that are requested to be displayed from the plural format buffers 31 and 31', respectively, according to the contents of the window control table 52, and stores them in the screen code buffer 41. Controls posting. Therefore, the window control table 52 holds information such as addresses and sizes of data 51 and the like in the format buffer 31 and the like.

The present invention mainly relates to table repetition control in the above-mentioned card image processing.

FIG. 9 shows an example of positions that can be specified in specifying the position of the table repetition range according to the present invention. In the figure, numerals 55 and 55' represent table marks, and 56 represents a cursor.

For example, in table repetition in conventional procedure registration, processing is performed from the first row to the last row of the table, but in the present invention, in order to use the table meaningfully, the range of table repetition in procedure registration is ,
It is now possible to specify the start and end positions of repetition as follows.

(1) First of the table (2) Last of the table (3) Last filled in (before blank or unfilled) (4) Next to the last filled in (5) Current cursor position (specified cursor position) However, , the end position cannot be specified before the start position.

The table is defined, for example, as shown in FIG. 9, between a table mark 55 indicating the start and a table mark 55' indicating the end. The "top of the table" indicates the row to which the table mark 55 is attached, as shown in the figure. "Final of table"
indicates the position where the table mark 55' is attached. In addition, "Final completed" is "Kukeko..." in this example.
This shows the line in which data has been entered, and the following lines are all blank lines. "Next to the last completed entry" indicates the next line in which "Kukeko..." was entered, and this designation is used, for example, in the case of registering a processing procedure such as adding new card data. “Current cursor position” indicates the line where the cursor 56 exists.

The example shown in Figure 9 is a so-called vertical table, and
This is a case where the arrangement of fields is repeated on a row-by-row basis, but of course the same applies to horizontal tables where the arrangement of fields is repeated on a column-by-column basis.

When registering a procedure, input the work selection key from the keyboard and select "Register procedure". As a result, a procedure frame 57 is set and displayed on the display screen as shown in FIG. 10. In this procedure frame 57, the processing procedure as explained in FIG. 5 can be created. In particular, in the case of table repetition, the start and end positions of the table can be specified as shown in FIG. It is now possible to do so. In this example, "the beginning of the table" is specified as the starting position, and "the last filled in" is specified as the ending position. By specifying like this,
For example, processing procedures such as calculation, copying, and searching between fields on a row-by-row basis can be executed only for portions of the table where data is valid. For example, it is also possible to specify other combinations, such as "next to the last filled in" as the start position and "last in the table" as the end position.

FIG. 1 shows the configuration of main parts for realizing the processing explained in FIGS. 9 and 10.
In the figure, the same symbols as in Fig. 6 correspond to Fig. 6,
Reference numeral 60 represents a calculation instruction section, 61 a search instruction section, 62 a table repetition instruction section, 63 a calculation execution section, 64 a search execution section, 65 a table repetition execution section, and 66 a completed final position search section.

The calculation instruction section 60 and the search instruction section 61 are called by the procedure registration control section 16 to register a processing procedure, and execute processing for parsing the syntax of the calculation instruction and search instruction, respectively, and storing them in the procedure storage section 17. It is something to do. Similarly, the table repetition instruction part 6
2 is called by the procedure registration control unit 16 when table repetition is specified during a processing procedure. In the present invention, the table repetition instruction unit 62 specifies the table repetition range as explained in FIGS. 9 and 10,
In particular, it is configured such that it is possible to input a repetition designation for the last line that has already been filled out. In table repetition, when start and end information is input, a check is made to see if there is any pre-warning such as the front and back being reversed in the combination, and if correct, the information is stored in the procedure storage unit 17. If there is an error, it will be displayed and prompt you to re-enter.

A series of processing procedures that have been given appropriate processing procedure names and registered by the procedure registration control unit 16 are executed at any time upon designation of procedure execution. When procedure execution is selected, the procedure execution control unit 18 is activated. The procedure execution control unit 18 sequentially reads out the designated processing procedure from the procedure storage unit 17 and calls each of the execution units according to the procedure type. The calculation execution unit 63 executes calculation when the procedure indicates calculation. The search execution unit 64 executes a specified card search. For the table repetition procedure, the table repetition execution unit 65 is called.

The table repetition execution unit 65 repeats the series of steps from the start to the end of the specified repetition in units of rows (for vertical tables) or columns (for horizontal tables) by processing described later with reference to FIG. It is something.
When the specification of the table repetition range involves "last entry" or "next to the last entry", the entry end position search unit 66 is called to dynamically determine the repeat range. The completed final position line search unit 66 converts the card data prepared in the record buffer 32 into the field definition information buffer 33.
By referring to the information above, you can find rows (columns) where at least one item is blank or does not have an item mark.
The search process starts from the bottom row of the table (rightmost example).

FIG. 11 shows an outline of the processing performed by the table repetition execution section 65 and the completed final position search section 66 in the embodiment shown in FIG. For example, when there is an instruction to repeat a table in the execution of a processing procedure and the illustrated table repetition execution unit 65 in FIG. 1 is activated,
The table repetition execution unit 65 performs the illustrated processing 70 in FIG.
, it is determined whether the final entry is specified in the specification of the table repetition range. When the final completed position is specified, the final completed position search unit 66 shown in FIG.
Process 75 is executed.

In process 71, processes 72 to 74 are repeated row by row from the last row to the first row of the table. In process 72, process 73 and process 74
Instructs to repeat as many fields as the table. In process 73, it is determined whether the currently focused field is blank or other than an item mark and has been filled in. If it is detected that the line has been filled in, the process 74 stores that line as the last line that has been filled in. Control then moves to process 76. As a result, the range that was undetermined at the time of procedure registration is determined. In the repetition of process 71 and subsequent steps, process 75 causes
If the last filled line cannot be found, the process ends with an error.

Once the table repetition range has been determined, processing 77 is performed in the range from the start position to the end position.
That is, processes such as calculation and copying specified in the table repetition are also executed repeatedly. The same applies to the case of "next to the last completed entry", and in the case of a horizontal table, the process 71 is repeated from the last column to the first column of the table. In cases other than specifying a range related to the final completed position, the range in which the processing procedure should be repeated is fixed in advance, so there is no need to call the final completed position search unit 66 at the execution stage.

〔Effect of the invention〕

As explained above, according to the present invention, it becomes possible to specify the completed final position, which is undetermined at the procedure registration stage, as the start position or end position in the table repetition range, thereby enabling the table repetition function in card image processing. will be available for use.
In other words, in general, the amount of data on the front of a card often increases gradually, and is undetermined at the time of procedure registration, but since the final position of the completed entry can be specified as the table repetition range, data can be added during table repetition processing. It is now possible to fill out information, etc.
Furthermore, it is no longer necessary to repeat execution of wasteful processing procedures.

[Brief explanation of the drawing]

FIG. 1 is a block diagram of the essential parts of an embodiment of the present invention, FIGS. 2 and 3 are diagrams for explaining the concept of card images and boxes related to the present invention, and FIGS. 4 and 5 are FIG. 6 is a diagram for explaining processing aspects related to the present invention. FIG. 6 is an overall outline diagram of an embodiment to which the present invention is applied. FIG. 7 is an explanatory diagram of information stored in the field definition information storage unit. Figure 8 is a diagram for explaining the correspondence between the format buffer and the screen code buffer, Figures 9 and 10 are diagrams for explaining the aspect of specifying the table repetition range according to the present invention, and Figure 11 is a diagram for explaining the mode of specifying the table repetition range according to the present invention. 1 is a diagram illustrating a processing overview of an embodiment of the present invention. In the figure, 1 is a card image, 2 is a box, and 8
is the keyboard, 10 is the card image processing section, 1
6 is a procedure registration control section, 17 is a procedure storage section, 27 is a form data storage section, 28 is a field definition information storage section, 29 is a card data storage section, 62 is a table repetition instruction section, 65 is a table repetition execution section, 66 represents the filled-in final position search section.

Claims (1)

[Claims] 1. A display, a format information storage unit that stores format information of a card including ruled lines or fixed characters,
The format information storage section includes at least a field definition information storage section that stores definition information regarding the entry fields of the card, and a card data storage section that stores the contents entered in the entry fields of each card. and the contents of the card data storage section are merged based on the contents of the field definition information storage section to generate and display a card image in the format buffer, as well as specify each field on the card image. A table repetition control method for card processing in a data processing device having a card image processing function for processing card contents by giving a processing mode to the card contents, the method comprising: a procedure registration control section for controlling registration of processing procedures for the card contents; , instructs table repetition in which the process is repeated row by row or column by column in the above processing procedure for rows or columns included in a table whose attributes in the field arrangement are common in the row or column direction, and at least the position of the repetition range. a table repetition instruction section in which the final position of completed data can be input; a procedure storage section for storing the processing procedure; a procedure execution control section for controlling the execution of the processing procedure stored in the procedure storage section; The present invention is characterized by comprising a table repetition execution unit having means for executing the table repetition instructed by the table repetition instruction unit and searching for a data-filled position in response to the designation of the data-filled final position. Table repetition control method for card processing.