JPH0224742A - File processor - Google Patents

Abstract

(57) [Summary] This bulletin contains application data before electronic filing, so abstract data is not recorded.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a file processing device that creates an update record corresponding to a file based on an input record and updates the corresponding file with this update record.

[Conventional technology]

2. Description of the Related Art Conventionally, when issuing charge-up slips for various sales products, office processing devices such as business personal computers, office computers, general-purpose combination computers, and computer processing machines have been generally used. By using these office processing devices, office processing is simplified, and various sales management reports associated with the issuance of sales slips, such as sales details by item and sales reports by customer, are made easier. Obtainable. The above various information is stored and managed by file name (for example, "sales details file", "customer file", "sales total file", etc.) by files connected to the office processing device.

[Problem that the invention seeks to solve]

By the way, in order to store and manage information using a plurality of files as described above in the office processing device, a system engineer must design a file management system corresponding to each file in advance. In designing these systems, one of the bottlenecks for conventional office processing devices is the design of update programs for files. That is, the record structure of a normal file is different for each file, and the types of words and the positions of words that determine the record structure are different for each file. Therefore, if you want to update the Word contents for individual files, you must design the update program in one-to-one correspondence with each file, and the number of files you want to use is very large. If there are many cases, it takes a lot of time to design the program.

In addition, the desired input type 3-Pt for the file in the office processing device, the desired update type, for example "addition"
, "Aggregation", "Delete", and other update types, each time a record corresponding to the file is input, specify one of the update types above and perform the update. Must be done. Therefore, when designing a program for updating the files mentioned above, it is necessary to create a program that inputs update data according to each type of update, and a program that updates files using the update data input for each type of update. Program design required a great deal of effort as it had to be designed to accommodate each type of update.

In addition, when updating a desired file among multiple files in the office processing device using a desired input record, each time a record corresponding to each file is input, each corresponding file is updated. is being carried out.

Therefore, when designing a program for updating the files mentioned above, it is necessary to create a program for inputting update data for the specified file, a program for updating the corresponding file with the input update data, and a program for each individual file. It took a lot of effort to design the program. Furthermore, even if a part of the processing content is changed during actual use, the program itself must be modified, which is difficult for the general public to do, and requires relying on a specialized system engineer, which is very time consuming. Very inconvenient.

An object of the present invention is to simplify the design of a file management system for each file and to significantly reduce the effort required for the design.

[Means to solve the problem]

The first invention is the "sales detail file."

Master 7 that has various files such as "customer file"
file format definition means that defines the record structure corresponding to each file in this master file by a word name, and an update file specification that specifies the name of the file to be updated in the master file, the update word name, and the update type name. means for creating an update record by matching the input word with the update word name of the update file specifying means and the word position defined in the corresponding file format definition means; and updating means for updating a master file having a file name specified by the update file specifying means according to the record, as indicated by the update type name.

The second invention is a means for creating an update record including an arbitrarily specified update type code such as aggregation, addition, correction, etc. from an input record including an update word, and an update record created by this means. A memory that stores multiple
The update means sequentially reads the update records in the memory in response to an update command, and updates the corresponding file in the master file with the update type included in each record.

The third invention provides a means for creating an update record containing the file name of an update file such as a sales file arbitrarily specified from an input record r containing an update word, and an update record created by this means. a memory for sequentially storing records in the memory, a file specifying means for sequentially reading records in the memory according to an update command, and specifying a file based on a file name included in the read record; On the other hand, it is equipped with updating means for updating based on the read record.

[Effect]

The operation of the means of the first invention is as follows.

First, various files necessary for office processing, such as "sales details file" and "customer file", are set in the master 7 file that stores various record data, and the record structure corresponding to each file is formatted into a file format. Before inputting the word data corresponding to the word salt, which is defined by the word 9 people using the definition means,
The name of the file to be updated in the master file (e.g. "sales details file"), the update word (e.g. "quantity", "
amount”, etc.) and update type basis (e.g. “aggregation”, “addition”)
etc.) using the update file specification method.

Now, when word data is input corresponding to the word salt, the record creation means is started, and this record creation means uses the input word data in the file format definition means corresponding to the update word name of the update file specification means. Create an update record according to the defined word position. When the update record is created, the update means is activated, and the created update record is updated to the master file having the file name specified by the update file specifying means as indicated by the update type basis.

Therefore, even if you do not know the record structure of the file you want to update, you can simply specify the file name to be updated, the update word name, and the update type base using the update file specifying means, and the desired word of the desired file can be created using the input word data. It is possible to update the desired update type.

The operation of the means of the second invention is as follows.

(by inputting all records including update words), update records including update type codes such as aggregation, correction, etc. arbitrarily designated in advance are created and stored in memory sequentially.

A plurality of update records are sequentially stored in this memory. Then, the records in the memory are sequentially read out according to an update command given at any time, and the corresponding file in the master file is updated with the update type included in each record.

Therefore, update processing using different update types such as addition and correction can be performed for each record at any time.

The operation of the means of the third invention is as follows.

By inputting a record containing an update word, an update record containing the file name of an arbitrarily specified update file is created and sequentially stored in memory. Update records for a plurality of files are sequentially stored in this memory. Then, the records in the memory are sequentially read by an update command given at any time, a file in the master file is specified based on the file name included in the read record, and the file name specified for this rule code is specified. On the other hand, update processing is performed using the read record.

Therefore, update processing for different files for each record can be performed at any time.

〔Example〕

One embodiment will be described below with reference to FIGS. 1 to 5.

FIG. 1 is a complete system configuration diagram of the file processing device. In the figure, reference numeral 11 denotes an input device, which includes, for example, a numeric keypad, function designation keys for designating various types of processing, function designation keys, and keys.

The processing type designation data and edit data inputted from the input device 1 are sent to the edit processing device 1.
2, and the PS file 13 is accessed by this edit processing device 12.

This PS file 13 includes definition data (hereinafter referred to as AN) for defining the file name to be read from the master file, the word name to be input, and the word content.
Definition data (hereinafter referred to as 0 table) for defining the file name, keyword salt, update type, and update word salt when performing another rt on the master file, the word name to be displayed, and its display Definition data for defining the format (hereinafter referred to as D table) and definition data for defining the word to be printed and its printing format (hereinafter referred to as E table) are used to store the processing contents of various office processes, e.g. It is set for each processing content, such as sales slip issuing processing, honorable mention slip issuing processing, and form output processing. Note that tables A to E defined for each process type are collectively referred to as definition document ps, and the ps file 13 contains multiple definitions #PS (Psi
, PS2°...) are set.

Thus, the edit processing device 12 has the input device 1
Fisif 1-Matt creation based on instructions from 1;
This is used to set data to the PS file 13 and read out the PS. When reading PS from the PS file 13, the A table is input into the word memory 14, the 0 table is stored in the file word memory 16, and the D phonetic display is performed. The E table is loaded into the word memory 17 and the print word memory 18, and then a start command is given to the input processing bag fR20. The A table loaded into the input word memory 14 is sent to the input processing device 20, the 0 table loaded into the file word memory 16 is sent to the file creation device 21, and the D table loaded into the display word memory 17 is sent to the display processing device. 22, the E table loaded into the print word memory 18 is read out to the print processing device (jli 23).The input device 11 is connected to the input processing device 20, and the index table memory 24,
RAMs such as a file format memory 25 and a work memory 26 are connected. The index table memory 24 stores, for example, the current date and a slip (slip number) that is automatically updated each time a slip is issued, as well as product codes, product names, and unit prices for various board products. It is set. Further, a file format is preset in the file format memory 25 via the input device 11 and the edit processing device 12. This file format defines the format of each file stored in the master file 29. For example, as shown in FIG. File names such as "Sales details file" and "Customer file" are stored in the second area 25b.
"Product name 2nd date".

Keywords such as "customer name, product name" are set in the third area 25c, and update words such as "unit price, quantity, amount" are set in the third area 25c. Then, the input processing device 20 performs calculations based on the A table read from the input word memory 14, data from the input device 11 or the mask file 29, etc.
Various input calculation processes such as searches are performed, and each processed data is stored in the work memory 26 in association with each word name defined in Table A, and is also stored in the file creation device 2 according to the data processing. , the display processing device 22, and the print processing device 23 are activated. The file creation device 2 includes a file format memory 25. Maintenance file 27 is connected.

The file creation device 21 starts all processing operations in response to a startup command from the input processing bag [20], and generates maintenance record data (this record data corresponds to (in which word data is arranged to match the record structure of the file) is created and persistently registered in the maintenance file 27. This maintenance file 27
Multiple maintenance record data are registered in
Based on a command from the input device 1 or the input processing device 20, the data is sent to the file update device 28, and updated and registered for the corresponding file in the master file 29. Also,
This master file 29 is readably connected to the input processing device 20.

The display processing device 22 starts processing operation in response to a startup command from the input processing device 20, reads word data in the work file 26 based on the D table stored in the display word memory 17, and creates display data. and displays it on the display device t30. When the print processing bag R23 receives a start command from the input processing device 20, the print processing bag R23 starts printing in the print word memory 1.
Based on the word data read from the work memory 26 based on the E table stored in 8, the slip data of the designated foot mat is created, and the printing device 31 is driven to print out the slip.

Next, the PS to be set in the PS file 13 above.

For example, the PSI for issuing slips and file update processing is configured as a table in A-. Figure 3 is PSI
This shows a specific example of the structure of Table A and Table 0 in . As shown in Figure 3(a), the A table for creating the word data necessary for file updating from the input data consists of two items, AI and A2, and A1 has "Date,
"Customer name, product name" are the heading words, and A2 is "Quantity, unit price.

Each word of ``amount (quantity x unit price)'' is set as the word of the item. Each word of the above "date, unit price" is a word condition indicating that the word data in the index table memory 24 is to be searched, "customer name, product name, quantity".
Each word salt indicates the input word condition, and the word word "amount (quantity x unit price)" indicates the word condition for the calculation where the calculation formula is written in the word name.

Also, the table 0 for creating maintenance records for file updates is shown in Figure 3 (b) and (e), for example.
0 to update the “sales detail file” as shown in
Table (1) and table 0 (2) for updating the "customer file" are prepared. 0 table (1) is C1, C2, C3
, C4 items, and C1 contains "sales details file"
is the file name to be updated, and C2 is "Product name.

The word "date" is set as a keyword, the code indicating "additional tally" is set as an update type in C3, and the word "quantity, amount, unit price" is set as an update word in C4. Table 0 (2), like Table 0 (1), has CI, C2, C
3. There is no item in C4, C1 is "Customer File"
is the file name to be updated, C2 has "Customer name,
The word "Product Name" is used as the keyword, C3 has the "Additional tally" code as the update type, and C4 has "Quantity, Amount."

The word "unit price" is set as the update word.

Table D is for creating a display format for displaying the created slip on the display device 30, and Table E is for printing format f! j
The purpose is to create a print format for printing out a receipt using L31, and its details will be omitted.

Also, in the same manner as PS1, other PS2°P83.
. . , A-E tables are independently set for each processing content and in accordance with the user's input/output slip form.

Next, the operation of the above embodiment will be explained. When issuing a slip, when PSl'i is specified from the input device 1, the edit processing device 12 reads PSl's A to E from the PS file 13.
Read table, input table A into word memory 14, table 0 into file word memory 16, display table D into word memory 1
At step 7, the E table is loaded into the print word memory 18, and after the loading is completed, a start command is given to the input processing device '#t;to. As a result, the input processing device 20 is activated and operates based on the A table loaded into the input word memory 14.
The sales slip data input from the input device 11 is input and processed. That is, the input processing device 20 first starts the display processing device 1L22, reads out the slip format from the display word memory 17, displays it on the display device 30, and guides data input. When the operator inputs data according to this ID, the input processing device 20 processes the data, associates this data with each word salt defined in Table A, and stores it in the work memory as word data.
6. After the input processing device #20 performs word processing for one slip, it starts the file creation device 21 to create a maintenance record, and also starts the print processing device fit 23f to glint out the slip.

The creation of maintenance records by the file creation device 2 is performed according to the 0 table as shown in FIG. First, the file creation device 21 starts with Stella'f in FIG.
As shown in A1, the first record of the word data stored in the work memory 26, for example, all word data related to "general calculator b" created based on table A are read out and set in its own internal register. do. Next, the first 0 table from the file word memory 16, that is, the third
0 table (1
) is read out and set in the internal register of the file creation device 2 (step A2), and the code MRi is prepared for maintenance in this internal register (step A3).
First, write the file name "Sales details file" and the update type code "Additional tally". Next, the word data "General Calculator b J, r 870907 J" specified by the keyword name "Product Name" and "Date" in Table 0 (1) is read from the above internal register, and the data in Table A of Table 0 (1) is read out. Word data r 10 J , r 10000 ”, rl specified by word name “Quantity”, “Amount”, “Unit Price”
oooJ is read from the internal register. Next, the contents of the maintenance record MR are registered in the maintenance file 27 (step A6), and then a full judgment is made as to whether processing has been completed for all 0 tables (step A7).
and if it is not finished, file word memory 1
0 table from 6, i.e. 0 for "Customer File"
Table (2) All data are read out, filed, and set in the internal register of the creation device 21 (step A8). After that, STETSU 7
Returning to A3, a maintenance record for the "customer file" is created and registered in the maintenance file 27 by the same process as above. As described above, maintenance records for the "sales details file" and "customer file" related to "general calculator b" are created and registered in the maintenance file 27.

Then, when the processing for all 0 tables is completed, step A
7, the program proceeds to Stella 7'A9, where it is determined whether or not processing of all records in the work memory 26 has been completed, and if the processing has not been completed, the program advances to Stella 7'A10. In this step AIO, all word data regarding the next record, for example "film calculator a", is read from the work memory 26 and set in the internal register of the file creation device 21. After that, return to Steve 2 and repeat the above operations to create a maintenance record for the ``sales details file'' and ``customer file'' of the ``film a'' following the ``general calculator b'', and perform maintenance. Register in file 27.

When the processing for all records stored in the work memory 26 is completed, the Stella 7'A9
Based on this judgment, the maintenance record creation process ends.

As described above, a plurality of maintenance records for various files are created and set in the maintenance file 27, but for example, a start command at the end of maintenance record creation processing from the file creation device fj121 or a shift file update from the input device @II A file update command is given to the file update device 28 when, for example, an instruction is given.

When a file update command is given, the file update device 28 updates 1 "sales statement file" and "customer file" in the master file 29 according to the file name of the maintenance record stored in the maintenance file 27, as shown in FIG. "File" and "Aggregation", "Add", "Delete" depending on the "Update Type" of the maintenance record.
Perform update processing such as In this case, master file 29
For the file stored in the maintenance file 2, the "
If there is a record corresponding to "file name" and "keyword name" in the master file 29, the read maintenance records are accumulated in this record, and if there is no corresponding record in the master file 27, additional processing is performed. Thereafter, update processing to the mask file 29 is sequentially performed for all maintenance records registered in the maintenance file 27 in the same manner.

A set in PS file 13 as described above
- A slip is issued based on the table E, and a maintenance record is created for this issued slip, and the master file 29 is "summed up".

Update processing such as "addition" and "deletion" is performed.

In the above embodiment, the file name to be updated and the update training name are also stored in the maintenance record, but this is not necessarily necessary in the first invention. For example, when the file update device 28 updates the file, The update may be performed based on the file name and update type defined in the six tables in the word memory 16. At this time, the file update processing device R2B may be configured to execute the update process every time the above-mentioned maintenance record is created.

In addition, in the second invention, it is not necessary to store the file name in the maintenance record, and after creating a maintenance record regarding the same file in the maintenance file 27, when the file update process 28 is instructed to start updating, the file creation bag ft27 The file name may be input from the input device 11 or from the input device 11.

Furthermore, in the third invention, it is not necessary to store the update type in the maintenance record; for example, after a maintenance record with the same update type is created in the maintenance file 27, an instruction to start the update to the file update device 28 is issued. File creation device 27
The type of update may be input from the input device 1 or from the input device 1.

〔Effect of the invention〕

According to the first invention, since the record structure of the city file is defined in advance in each file using a word name,
By inputting data in association with word salts, this input data is arranged to match the record structure of each file to be updated, and the update records created by arranging in this way are used to create files to be updated. Now, when designing a file for file updating, there is no need to design an update program that matches the record structure of each file, and the record structure of each file (word You only need to specify the file name to be updated, the update word name, and the update type base without having to be aware of the file order (sort order, etc.), and the specified update type will be updated for the specified word in the specified file using the input word data. be able to.

According to the second invention, a plurality of update records each including an arbitrarily specified update type code are stored in the memory, so that each record is updated based on the contents of the update records in the memory. Supported files can be updated at any time using different update types. Further, the process of creating an update record based on an input record and the process of updating a file based on the update record at the time of an update command are independent tasks, making the process very simple. Therefore, the definition settings for the devices that perform the above-mentioned processes are greatly simplified, the system design is simple, and the effort required for the design can be significantly reduced. Furthermore, changes in processing content can be made by simply changing word definitions without having to completely modify the program itself.

In addition, the update type to be used to update each update record stored in memory can be identified from the update type code included in each record. For example, each update record can be reliably updated with the corresponding update type at any time.

Further, according to the third invention, since a plurality of update records each including an arbitrarily specified update file name are stored in the memory, each record has a different update record based on the contents of the update records in the memory. A file is specified, and this specified file can be updated at any time. In addition, the process of creating an update record based on an input record and the process of updating a file based on the update record that is issued when an update command is issued are independent tasks, making the process extremely simple. Therefore, the definition settings for the devices that perform the above-mentioned processes are greatly simplified, the system design is simple, and the effort required for the design can be significantly reduced. Also,
Changing the processing content can be done by simply changing the word definition without having to modify the program itself. However, since you can identify which file to update each update record stored in memory from the file name included in each update record, you can store update records in memory sequentially. It is possible to reliably update the corresponding file using each update record at any given time.

[Brief explanation of the drawing]

The drawings show an embodiment of the present invention. Fig. 1 is a system configuration diagram of a file processing device, Fig. 2 is a diagram showing an example of a file format configuration, and Fig. 3 is an A table and an 0 table in a PS file. 4 is a flowchart showing the maintenance record creation process, and FIG. 5 is a diagram illustrating the update operation of each file based on the maintenance record stored in the maintenance file. 1 No. Input device, 12 Edit processing device,
13...PS file, 14...Input word memory, 16...File word memory, 17...Display word memory, 18...Print word memory, 20...
Input processing device, 21...File creation device, 22...
・Display processing device, 23...Print processing device, 24...
Index table memory, 25...File format memory, 26...Work memory, 27...Maintenance file, 28...File update device t, 29
... Master craft, 30... Display device, 31...
・Printing device.

Claims (3)

[Claims] (1) A master file, a file format definition means for defining the record structure of this master file using a word name, and a file name to be updated in the master file;
Create an update record by aligning the input word with the update file specifying means for specifying the update word name and update type name and the file format definition means that corresponds to the update word name of the update file specifying means. and update means for updating the master file with the file name specified by the update file specifying means using the update record created as indicated by the update type name. file processing device. (2) means for creating an update record containing an arbitrarily specified update type code from an input record containing an update word; a memory for storing a plurality of update records created by this means; and a memory for storing a plurality of update records created by this means; 1. A file processing device comprising: updating means for sequentially reading records in the file and updating the file according to the update type included in each individual record. (3) A means for creating an update record including the file name of an arbitrarily specified update file from an input record including an update word, a memory for sequentially storing update records created by this means, and an update command. A file specifying means for sequentially reading the records in the memory and specifying a file based on a file name included in the read record, and updating the file specified by the means using the read record. What is claimed is: 1. A file processing device comprising: update means.