JP4096319B2 - Electronic form management system, management method, and program therefor - Google Patents

Description

  The present invention relates to an electronic form created by a personal computer or the like (hereinafter referred to as a PC), and more particularly, a person who searches and browses the electronic form and uses the data described in the electronic form (hereinafter referred to as the electronic form). In particular, the present invention relates to a form management system and management method for facilitating the work of searching, browsing, and collating contents with respect to a large amount of electronic forms, and a program therefor.

  Various conventional form creation techniques have been proposed. For example, Japanese Patent Laid-Open No. 2003-141439 (Patent Document 1) describes a form creation method capable of searching a database based on a form output instruction and customizing a form output form for each user. .

  More specifically, Patent Document 1 aims to eliminate the need to develop and modify a form output application program for each user when customizing the form output form for each user. Register the form layout definition file that records the output item name corresponding to the display location of the output item on the form, search the database based on the form output instruction, and the output item name of the form instructed to output , Output an intermediate file recorded in association with the data related to the output item, read the output item name recorded in the intermediate file, and for each output item name read out, a corresponding output item name A search is made as to whether or not the form layout definition file is recorded, and when it is recorded, data corresponding to the output item name is stored in the intermediate file. Form generation techniques to create the form by recording the corresponding display positions of al reads the form layout definition is disclosed.

JP 2003-141439 A

  The inventor of the present application has found that there are the following problems when using an electronic form created by a conventional method.

  As a first problem, when a user of a form searches and browses an electronic form created in large quantities by the conventional method, it knows in advance the file registration location of the electronic form. It is necessary to spend a lot of labor for management for that.

  As a second problem, when a user of a form searches and browses any page in the electronic form with respect to an electronic form of a large number of pages created by the same layout definition by a conventional method, the electronic form It is necessary to know the page configuration in advance, and a great deal of labor is taken for management.

  As a third problem, when a form user wants to collate data described on an electronic form created by a conventional method based on a certain relationship, the form user first searches for the form to be collated and Browsing, searching and browsing the next form page to be verified, and finally the location information of the data described in the page (especially regarding electronic forms created with spreadsheet software, the data is described) The data is extracted by designating the cell position information), and the matching is applied to the relevance. The file registration information, the form page configuration information, and the form of the electronic form related to the series of operations are collated. For example, a great deal of labor is required to manage the data description position information in the page.

  Here, the electronic form collation mentioned in the third problem will be described more specifically.

  FIG. 18 is a diagram for explaining an example of collating data described on an electronic form based on a certain relevance in an electronic form created by spreadsheet software.

  In the example of FIG. 18, a list of annual sales status by product type / region is handled as “List_A”, and page 1 to page 48 are product types “books”, and page 49 and later are product location “beverages”. 1 page is the region “Hokkaido”, 2 pages is the region “Aomori”, ... 47 pages is the region “Okinawa”, 48 pages is the national total, each page is each company (Company A, Company B, Company C) , Company D) shows sales in the first half and second half of 2004, and total sales in 2004.

  In addition, FIG. 18 shows an example of the relationship 1 “in each row of each page, the sum of the value described in the“ 2004 upper ”column and the value described in the“ 2004 lower ”column matches the value described in the“ 2004 total ”column. As an example of relevance 2, “For each product type, the sum of the values listed in each cell from the“ Region: Hokkaido ”page to the“ Region: Okinawa ”page is the“ Region: National total ”page. It corresponds to the value of the same-position cell.

  The relevance 1 shown in FIG. 18 exists between the data described in the electronic form “List_A”, and the relevance of the data described in the actual electronic form “List_A” by the form user. Consider the case of matching based on 1.

  The form user first obtains information on the file registration location of the electronic form “List_A”, then obtains information on the page configuration of “List_A”, and browses a page to be collated in “List_A”.

  Thereafter, based on the relevance 1, data extracted by designating position information of data to be collated is applied to relevance 1 and collated.

  Specifically, taking the electronic form of FIG. 18 as an example, in the first row of one page, the value “100” described in the “2004 top” column and the value “150” described in the “2004 bottom” column are extracted. Also, “250” in the “2004 total” column on the same page is extracted, and the calculation result “100 + 150” is collated with “250”. Similarly, the second line of one page, the third line of one page, the fourth line of one page, the first line of two pages, .. and relevance 1 are continued, and all the collation patterns are requested. It can be concluded that the matching result is “correct” if the conditions being met are satisfied. (Refer to “Verification 1” in FIG. 18)

  Similarly, considering the case of matching based on the relevance 2 shown in FIG. 18, the range of the matching page is first limited from 1 page representing “product type: book” to 48 pages, and the value described in each cell is changed. The total value from “Region: Hokkaido (page 1)” to “Region: Okinawa (page 47)” is compared with the value described in the cell at the same position in “Region: National total (page 48)”. It will be.

  Next, the collation page range is limited to pages representing “product type: beverage” (pages 49 to 96) and collation for each cell is performed in the same manner as described above, and the conditions required for all the collation patterns are satisfied. If it is determined, it can be concluded that the collation result is “correct” (see the description of “collation 2” in FIG. 18).

  The present invention is for solving the above-described problems, and has the following objects. In the following, in addition to those who search and browse electronic forms, those who create electronic forms (to be described later), those who register electronic forms in the specified registration directory, and those who collate data written in electronic forms are also distinguished. First, it shall be described as a form user.

  The first object of the present invention is that when the electronic form creation means searches the database based on the form output instruction and registers the electronic form created according to the form layout definition in the electronic form registration apparatus, the electronic form registration means By recording the file registration location of the electronic form in the electronic form registration information, when the form user searches and browses any electronic form registered in the electronic form registration device, the electronic form file It is to enable easy searching and browsing using registered form search items set in advance without being aware of the detailed contents of the registration location.

  The second object of the present invention relates to the page structure of the electronic form when the electronic form creation means searches the database based on the form output instruction and outputs the electronic form over a plurality of pages according to the form layout definition. By recording information in the electronic form page configuration information, when searching and browsing any page in the electronic form searched and browsed by the form user, the user is aware of the detailed contents of the page form of the electronic form. The electronic form page configuration information can be easily searched and browsed without the need to do so.

  The third object of the present invention is that when a form user searches and browses an arbitrary electronic form and collates data described in the electronic form based on a certain relationship, the electronic form registration information In addition to form page configuration information, based on collation page combination information, collation calculation formulas and collation relational expressions that can be arbitrarily set by the form user, data in the electronic form is automatically extracted and collated by applying this relationship. It is to be able to output the result.

  The present invention employs the following configuration in order to achieve the above object.

  FIG. 1 is an explanatory diagram of the principle of the present invention. Although each means with which this invention is provided is not limited to FIG. 1, in order to assist an understanding, it demonstrates below, referring the structure of FIG.

<First means> (equivalent to the electronic form creation apparatus 1000 in FIG. 1)
The first means inputs electronic form creation information 1010 and electronic form creation form layout definition 1020 in accordance with a form user's electronic form creation instruction 100, and forms electronic form 1040, form layout definition 1050, and electronic form page configuration information. An electronic form creation means 1030 for outputting 1060 sets together is provided.

<Second Means> (equivalent to the electronic form registration apparatus 2000 in FIG. 1)
The second means searches the electronic form registration directory 2030 for the electronic form 1040 output by the first means in accordance with the electronic form registration instruction information 2010 that is arbitrarily preset within a range that can be set by the form user. Each item is classified and registered, and the registration status (file registration location, registration date, registrant, etc.) of the registered electronic form 2040 is recorded as electronic form registration information 2060, and the form layout is also output by the first means. An electronic form registration unit 2020 that manages the electronic form search information group 2050 together with the combination of the definition 1050 and the electronic form page configuration information 1060 is provided.

<Third Means> (equivalent to the electronic form search device 3000 in FIG. 1)
A third means is that an electronic form issued when a form user refers to the electronic form search information group 2050 and arbitrarily inputs a form search condition regarding the electronic form registration information 2060 within a settable range. In accordance with the search instruction 300, an electronic form registration information acquisition unit 3010 that outputs electronic form registration information 2060 related to the registered electronic form 2040 that matches the form search condition as an electronic form search result 3020, and the form user outputs the electronic form search result Search within designated electronic form issued by inputting page narrowing condition regarding electronic form page configuration information 2080 of electronic form search information group 2050 arbitrarily within a settable range for the electronic form listed in 3020 In accordance with the instruction 350, the electronic form search information group 2050 and the electronic form registration directory 20 The designated registered electronic form 2040 within 0 is input, and the designated registered electronic form 2040 is narrowed down to pages that match the page narrowing condition to output the page-restricted electronic form 3040, and the designated An electronic form page narrowing unit 3030 that manages a combination of the form layout definition 2060 and electronic form page configuration information 2070 relating to the form as an electronic form matching information group 3050 is provided.

<Fourth Means> (equivalent to the electronic form collating device 4000 in FIG. 1)
The fourth means is that the form user refers to the electronic form collation information group 3050, and the electronic form description data collation setting for the electronic form 3040 that has been narrowed down arbitrarily within the settable range (the data used for collation). In accordance with the electronic form collation instruction 400 issued by inputting the position, the calculation formula of the value used for collation, the relational operator used for the collation judgment condition, the combination of pages to be collated, etc., the page narrowed electronic form 3040 And the case where the collation result matches the collation judgment condition of the electronic form description data collation setting (hereinafter referred to as the collation result [true ], And the collation result is denoted as collation result [true]) electronic form collation result [true] general information 4050 and electronic book Collation result [true] detailed information 4060 (electronic form collation result [true] general information 4050 and electronic form collation result [true] detailed information 4060 are combined into an electronic form collation result [true] information group 4040), the collation A case where the result does not match the collation judgment condition of the data collation setting in the electronic form description (hereinafter, the case is referred to as a collation result [false] and the collation result is referred to as a collation result [false]). Electronic form matching result [false] general information 4080 and electronic form matching result [false] detailed information 4090 (electronic form matching result [false] general information 4080 and electronic form matching result [false] detailed information 4090 In combination with [false] information group 4070), an electronic form collating means 4010 for outputting as an electronic form collating result 4020 is provided.

  According to the present invention, as shown in FIG. 1, an electronic form creation apparatus 1000 provided with an electronic form creation means 1030, an electronic form registration apparatus 2000 provided with an electronic form registration means 2020, and an electronic form registration information acquisition means 3010. The following effects can be obtained by providing the electronic form search device 3000 provided with the electronic form page narrowing means 3030 and the electronic form check device 4000 provided with the electronic form check means 4010.

  For the first purpose, the electronic form creation means 1030 obtains electronic form data from the electronic form creation information 1010 based on the form output instruction, and the electronic form 1040 created according to the electronic form creation form layout definition 1020 is electronically stored. When registering in the form registration apparatus 2000, the electronic form registration unit 2020 records the file registration location of the electronic form 1040 in the electronic form registration information 2060 and manages it as a member of the electronic form search information group 2050. When a person searches for an arbitrary electronic form registered in the electronic form registration apparatus 2000 by the electronic form search instruction 300, the user is not aware of the detailed location of the electronic form registration directory 2030 in which the electronic form is registered. , Form search conditions included in electronic form search instruction 300 and registered forms registered in advance It is possible to easily perform the search using the search item. As a result, browsing the retrieved electronic form is also included in the natural application.

  For the second purpose, the electronic form creation means 1030 acquires electronic form data from the electronic form creation information 1010 based on the form output instruction, and the electronic form is spread over a plurality of pages in accordance with the electronic form creation form layout definition 1020. When the information is output, information related to the page configuration of the electronic form 1040 is recorded in the electronic form page configuration information 2080 and managed as a member of the electronic form search information group 2050. When an arbitrary page in the searched electronic form is searched by the specified electronic form search instruction 350, the pages included in the specified electronic form search instruction 350 without being aware of the detailed contents of the page configuration of the electronic form. A search can be easily performed using the narrow-down conditions and the electronic form page configuration information 2080. . As a result, viewing the obtained electronic document 3040 with page narrowing is also included in the natural application.

  For the third purpose, the form user has narrowed down the page from any registered electronic form 2040 of the electronic form registration apparatus 2000 via the electronic form search apparatus 3000 by the electronic form search instruction 300 and the specified electronic form search instruction 350. When the electronic form 3040 is acquired, the position information of the data described in the page-restricted electronic form 3040 and the information related to the page configuration are recorded in the form layout definition 3060 and the electronic form page configuration information 3070, respectively. In order to manage as a member of the form collation information group 3050, when the form user collates the data described in the narrowed-down electronic form 3040 based on a certain relevance by the electronic form collation instruction 400, the electronic form An electronic book whose collation means 4010 is included in the electronic form collation instruction 400 Using description data collation setting (setting of data position used for collation, calculation formula of value used for collation, relational operator used for collation judgment condition, combination of pages to be collated, etc.) and information group 3050 for electronic form collation By automatically extracting the data of the electronic document 3040 that has been narrowed down and applying it to the collation determination condition corresponding to the relevance, the electronic form collation result comprehensive information 4030, the electronic form collation result [true] general information 4050, An electronic form collation result 4020 including a form collation result [true] detailed information 4060, an electronic form collation result [false] general information 4080, and an electronic form collation result [false] detailed information 4090 can be acquired. .

  Hereinafter, specific embodiments of the present invention will be described in detail with reference to the drawings.

FIG. 2 is a schematic diagram showing an embodiment for carrying out the present invention.
In FIG. 2, reference numeral 5000 denotes a client PC, which is an electronic form creation screen 5010 used by a form user to create an electronic form, and an electronic form search screen 5020 used to search a registered electronic form and narrow down pages. And an electronic form collation screen 5030 for performing collation setting on the electronic form on which the page is narrowed down and acquiring a collation result.

  Reference numeral 6000 denotes a server PC which includes a database management system 6500 and includes the following five application programs.

  The first program is the electronic form creation database 6510 of the database management system 6500 registered in advance when the form user issues an electronic form creation request 5011 on the electronic form creation screen 5010, and the electronic form. The creation form layout definition 6020 and the electronic form registration instruction information 6030 are input, the electronic form creation database 6510 is searched in accordance with the output instruction of the electronic form creation form layout definition 6020, and the electronic form is created. The electronic form creation form layout definition 6020 is assigned to the electronic form and registered in the electronic form registration directory 6040 sorted according to the electronic form registration instruction information 6030 according to the electronic form registration instruction information, and the page configuration information and the database management system 6500 are registered. Electronic form registration information database 6520 It is an electronic form creation processing and registration processing program 6010 to register the information.

  The second program searches the page configuration information database and the electronic form registration information 6520 when the form user issues an electronic form search request 5021 specifying the registered form search item on the electronic form search screen 5020. This is an electronic form search processing program 6050 that outputs a list of registered electronic forms 6041 with form layout definition that matches the conditions of the electronic form search request 5021 as an electronic form search result 5022.

  The third program is a specification in which a form user designates a narrowed page for the electronic form listed in the electronic form search result 5022 by using the page configuration information acquired by the electronic form search processing program 6050. When an electronic form page narrowing request 5023 is issued, an electronic form search result is obtained from the electronic form registration directory 6040 sorted for each of the registered form search items according to the electronic form registration information acquired by the electronic form search processing program 6050. The registered electronic form 6041 with the form layout definition designated in 5022 is acquired, narrowed down to only pages that meet the conditions of the designated electronic form page narrowing request 5023, and the form layout definition and page configuration are included in the page narrowed down electronic form. Form layout definition and page structure with information The pre-electronic form 6071 narrowing down information with a page, which is an electronic document page narrowing processing program 6060 to be output to the pre-electronic form output directory 6070 narrowing page.

  In the fourth program, the collation data is compared with the form layout definition and the page narrowed down electronic form 6071 with the page configuration information acquired by the form user in the electronic form collation processing program 6060 on the electronic form collation screen 5030. When an electronic form collation request 5031 specifying a range, collation calculation formula, collation judgment condition, collation page correspondence, etc. is issued, the page narrowed electronic form 6071 is input from the page narrowed electronic form output directory 6070, and the electronic Data collation is performed using data described in the electronic form in accordance with the setting of the form collation request 5031. The electronic form collation result general information 6091, the electronic form collation result [true] general information 60921, and the electronic form collation result [true] Detailed information 60922 and electronic form collation result [false] general information 6093 When an electronic document verification processing program 6080 electronic forms collation result by combining the False] General information 60932 is output as an electronic document verification result 6090.

  The fifth program uses an electronic form verification result acquisition request 5032 to transfer the electronic form verification result 6090 acquired by the electronic form verification processing program 6080 to the client PC 5000 on the electronic form verification screen 5030 by the form user. When issued, the electronic form collation result acquisition program 6100 transfers the electronic form collation result 6090 to the client PC 5000.

  Hereinafter, the present invention will be described together with examples. This embodiment will be described with reference to the schematic diagram shown in FIG. 2 and FIGS.

  The electronic form in this embodiment is assumed to be created by spreadsheet software. However, if the electronic form creation method, registration method, and information acquisition method in the electronic form are the same as in this embodiment, For this reason, the above assumption regarding the electronic form does not limit the scope of application of the present invention.

  For example, even when an electronic form is created as a text data file in which items in the form are separated by blank characters and each line and page is separated by a line feed symbol, it is created according to the form layout definition. The present invention can be applied if information such as the item column position of the electronic form and the number of page configuration lines can be acquired and a value can be acquired for each single item.

  FIG. 3 is a diagram showing an example of a processing block diagram of the electronic form creation processing and registration processing program 6010 that is started in response to the electronic form creation request 5011 of FIG.

  The electronic form creation processing and registration processing program 6010 in FIG. 3 first reads the electronic form creation layout definition sheet 6020 related to the electronic form to be created according to the contents of the electronic form creation request 5011 in the form layout definition read processing step 60101. .

FIG. 4 is a diagram illustrating an example of an electronic form creation layout definition sheet 6020 that is read in the form layout definition reading processing step 60101.
In this example, the layout definition sheet 6020 for creating an electronic form is managed in the form of a spreadsheet used in spreadsheet software. Here, the symbols “A”, “B”... “G” described in the upper part of the layout definition sheet 6020 for creating electronic forms represent column numbers for identifying the columns in the sheet, and are similarly displayed on the left side. The symbols “1” “2”... “10” described here represent row numbers for identifying the rows in the sheet.

  The position information representing each cell in the sheet combines the column number and the row number. For example, the upper left cell in the sheet of FIG. 4 is “A1”, and the lower right cell in the sheet of FIG. It shall be expressed as “G10”. In this example, the form layout definition sheet is represented by one page. However, the form layout definition sheet may be divided and managed in a plurality of pages by a page break instruction of spreadsheet software.

  In each cell of the electronic form creation layout definition sheet 6020 in FIG. 4, the following three types of character string transfer information can be described. FIG. 4 also shows correspondence between three types of character string transfer information and cells.

  (1) The first character string transfer information is “fixed character string transfer information” for transferring the character string described on the layout definition sheet as it is to the electronic form. The fixed character string transfer information can be used by describing a normal character string not including a data replacement special character string, which will be described later, on the layout definition sheet.

  (2) The second character string transfer information includes information necessary for the electronic form creation processing step 60102 in FIG. 3 to acquire data from the electronic form creation request 5011 and the electronic form creation database 6510 in FIG. This is the “variable character string transcription information” described.

  The variable character string transfer information can be used by describing the following data replacement special character string on the layout definition sheet.

  FIG. 5 is a diagram showing examples of various tables stored in the electronic form creation database 6510. Here, “Null” in various tables indicates that no value is set.

  The special character string for data replacement basically has an item name (here, the column name of the form data table 6513 in FIG. 5) “[[[] in the cell“ C3 ”in the sheet of FIG. It is described in a format sandwiched between "and"]] ".

  The electronic form creation processing step 60102 in FIG. 3 detects this “[[” and “]]” when reading the electronic form creation layout definition sheet 6020 including the cell describing the character string. It is interpreted that variable character string transfer information is described in the cell in which the column is described, and the electronic form creation request 5011 and the electronic form creation database 6510 in FIG. 2 (in the example of the cell “C3”, the form data table 6513) and is written in the electronic form.

  Of course, the use of the symbols “[[” and “]]” defining the special character string for data replacement in FIG. 4 is an example, and the symbol defining the special character string for data replacement is used as an example. Although not limited, it is desirable to adopt a character string that is difficult to input as fixed character string transfer information as much as possible in consideration of the contents described in the electronic form. It is also desirable to prepare a method (such as introduction of an escape character string that cancels the effect of the special character string) in which a symbol defining the special character string for data replacement is input as fixed character string transfer information.

  (3) The third character string transcription information is “fixed / variable mixed character string transcription information” in which the fixed character string transcription information and the variable character string transcription information are mixed. The electronic form creation processing step 60102 in FIG. 3 identifies the special character string portion for data replacement and the other portions by reading the fixed / variable mixed character string transfer information, and the former includes the variable character string transfer information and Similarly, it is replaced with data obtained from the electronic form creation request 5011 or the electronic form creation database 6510 shown in FIG. 2, and the latter is treated as a character string to be directly transferred to the electronic form in the same manner as the fixed character string transfer information. Then, after combining the two, write them on the electronic form.

  Next, based on the setting of the form layout definition sheet, details of the electronic form creation processing step 60102 in FIG. 3 will be specifically described below.

  First, in the electronic form creation processing step 60102, the form management information of the creation target form (in this example, the electronic form “List_A”) is acquired from the form management table 6511 in FIG. The form management information includes a code indicating a major classification of page classification, row classification, and column classification. The major classification code indicates the names of page classification, row classification, and column classification used for the electronic form. 5 shows major classifications of key codes for searching from the page / row / column classification table 6512 of FIG.

  For example, in the row “List_A” of the form management table 6511, “001” is set in the page major category 1 and “003” is set in the page major category 2, which means that “List_A” is the page major category 1. “Product type” (category name obtained by combining “001000” in the page / row / column classification table 6512 with the fixed code “000” representing the major classification combined with the page major classification “001”) Indicates that the page major category 2 has “region” (a category name obtained in correspondence with “003000”).

  Accordingly, when the electronic form creation processing step 60102 in FIG. 3 creates “List_A”, according to the page major classification, the minor classification of the page classification (in this embodiment, in the page / row / column classification table 6512). , All the codes that are not fixed code “000” in which the first three digits of the classification code match the major page classification and the latter three digits represent the major classification) are sequentially acquired on one page of the electronic form. A combination of page classifications and the start page number are associated with each other such as “Type: Book”, “Region: Hokkaido”, and “Commodity Type: Book” and “Region: Aomori”.

  Next, an electronic form creation processing step 60102 creates each page sheet of the creation target form in accordance with the order of the combination of page classifications.

  At this time, in the electronic form creation processing step 60102, the special character string for data replacement included in the variable character string transfer information and the fixed / variable mixed character string transfer information is generated as shown in FIG. The data is replaced with data acquired from the request 5011, the electronic form creation database 6510, or the like. Here, it is assumed that the electronic form creation request 5011 includes a form ID, a processing year, and a processing year / month, which are key items of the form data table 6513.

  For example, for the fixed / variable mixed character string posting information “Product type / regional yearly sales status ([[processing year]]”) shown in cell “A1” in FIG. Sales situation for the year ("is used as a fixed character string as it is, and the central part" [[Processing year]] "is replaced with the processing year" 2004 "included in the electronic form creation request 5011 in Fig. 2, and the rear part" FY "is fixed. It is used as a character string as it is, and the three character strings are combined to transfer the character string “Sales status by year of product type / region (2004)” to cell “A1”.

  In addition, for the variable character string transfer information “[[line classification 1 (001)]]” described in the cell “B6” in the same figure, “line classification 1 (001)” can be acquired from the form management table 6511 “ It is obtained by combining line size classification 1 code “010” of “List_A” and “001” sandwiched between parentheses in the replacement special character string and corresponding to “010001” of page / row / column classification table 6512 The character string “Class A” is transferred to the cell “B6”.

  The variable character string transfer information “[[value 1 (001, Null)]]” shown in the cell “C6” in the figure is different from the above two character string transfer examples, and the form shown in FIG. A replacement character string (value item) that varies depending on the creation target page is acquired from the data table 6513.

  When the combination of page classifications corresponding to the creation target page is “page classification 1: 001001” and “page classification 2: 003001” (“product type: book” “region: Hokkaido”, that is, the first page), the variable When searching for a character string to be replaced for the character string transfer information “[[value 1 (001, Null)]]” from the form data table 6513, “form ID: List_A included in the electronic form creation request 5011 as a search key” is used. "Processing year: 2004", "Processing date: 200503", a combination of page classifications corresponding to the creation target page "Page classification 1: 000001", "Page classification 2: 003001", and the variable character string transfer information "[ [Value 1 (001, Null)]] ”by using“ 001 ”sandwiched between parentheses in combination with“ Row classification 1: 010001 ”obtained by combining“ Row size classification 1: 010 ” , The replacement character string “100” is obtained from the “value 1” column.

  In the variable character string transfer information “[[value 1 (001, Null)]]”, the portion of “001” before the parenthesis “,” (comma symbol) is the first argument, and “Null” after the same If the part is called the second argument, the first argument designates the contents used as the row classification designation key of the value item search key for the form data table 6513, and the second argument serves as the column classification designation key of the search key. Specify what to use.

  Specifically, the first argument is a character string (in this embodiment, page, line, etc.) that is combined with each line large classification code for the line large classification set in the form management table 6511 other than “Null”. In the column classification table 6512, a character string of the last three digits of the classification code is combined and set.

  The second argument is set in the same manner (in this embodiment, “Null” is set for all column major categories of the electronic form “List_A”, so “Null” is set for the second argument).

  When there are a plurality of row major categories or column major categories, for example, in the form management table 6511, the row major category is set to other than “Null” from the row major category 1 to the row major category 3, and the column major category is the column major category. For forms set from 1 to column major category 5 other than “Null”, a character string obtained by combining three and five character strings to be combined with each row major category code and column major category code (this book) In the embodiment, a character string of 9 digits and 15 digits is set, and when the processing step searches for a value item from the form data table 6513, the character string is decomposed to generate a key code. To use.

  Similarly, for the variable character string transcription information “[[page number]]” described in the cell “F2” in the same figure, a replacement character string (page number) that differs depending on the creation target page is acquired. In this case, the page number of the creation target page of the creation target electronic form recorded and managed in the electronic form creation and registration processing program 6010 is transcribed.

  In this way, by managing the electronic form creation layout definition sheet 6020 in which the three types of character string transfer information are described, the layout of the creation target electronic form can be easily changed without modifying the electronic form creation program. can do.

  Subsequently, in the electronic form page configuration information storage processing step 60103 in FIG. 3, when the electronic form creation processing step 60102 creates the electronic form as described above, the page corresponding to the combination of the page classification and the start page number is created. The configuration information is stored in the page configuration information database 6521. FIG. 6 shows an example of the page configuration information table 65210.

  After the electronic form page configuration information storage processing step 60103 registers the electronic form page configuration information in the page configuration information database 6521, the electronic form temporary registration processing step 60104 adds the electronic form to the electronic form created by the electronic form creation processing step 60102. The form layout definition sheet 6020 used for creation is added and registered in the electronic form temporary registration area 601040. The provided form layout definition sheet 6020 is used by a form user to specify collation conditions and the like on an electronic form collation screen 5030 described later.

  In the electronic form registration instruction information reading processing step 60105, electronic form registration instruction information 6030 is read. FIG. 7 shows an example of electronic form registration instruction information 6030.

  The electronic form registration instruction information 6030 includes one line (“form”) that defines a large classification of registered form search items used by the electronic form search processing program 6050 in FIG. 2 to search the registered electronic form 6041 with form layout. ID: a special line recorded at the top of “search item label”) and a plurality of lines defining details of the registered form search item for each registered form following the line.

  In the electronic form main registration processing step 60106, when the registered electronic form 6041 with the form layout is registered, the electronic form registration location is classified according to the electronic form registration instruction information 6030 according to the electronic form registration instruction information 6030. The registered electronic form 6041 with the form layout is registered while managing like the form registration directory 6040 and adding a directory as necessary.

  In response to the electronic form registration information generated by the electronic form main registration processing step 60106, the subsequent electronic form registration information storage processing step 60107 stores the electronic form registration information in the electronic form registration information table 65220 of the electronic form registration information database 6522. .

  Next, the electronic form search processing program 6050 and the electronic form page narrowing process 6060 in FIG. 2 will be described.

  FIG. 8 is a screen configuration example of the electronic form search screen 5020 of FIG.

  In the electronic form search condition setting field 50201 of the electronic form search screen 5020 in FIG. 8, the search item label and details of the registered form search item are displayed based on the information set in the electronic form registration instruction information 6030. .

  The form user can specify the search condition for the registered electronic form by arbitrarily selecting the details of the search item in the electronic form search condition setting field 50201. The form user can issue an electronic form search request 5021 specifying the registered form search item in FIG. 2 to the electronic form search processing program 6050 by pressing the “start form search” button in the same column.

  FIG. 9 shows an example of a block diagram of an electronic form search processing program 6050 that is started in response to an electronic form search request 5021 specifying the registered form search item of FIG.

  Upon receiving the electronic form search request 5021, the electronic form search processing program 6050 starts the electronic form search processing step 60501 in FIG. 9, and in accordance with the contents of the electronic form search request 5021 specifying the registered form search item, the electronic form registration information The registration information of the registered electronic form that matches the search condition is acquired from the database 6522.

  At this time, the page configuration information of the registered electronic form is also acquired from the page configuration information database 6521. The acquired registration information of the registered electronic form is displayed in the electronic form search result display field 50202 of the electronic form search screen 5020.

  When the form user designates a registered electronic form that matches the search conditions displayed in the electronic form search result display field 50202, the electronic form page narrowing setting field 50203 is set according to the page configuration information of the registered electronic form acquired above. The page major category name and page category name of the registered electronic form are displayed in the page category selection field. The page classification name is displayed with a check box attached.

  A form user directly designates a narrowed page number (specifies by entering a page number in the narrowed page number input field) in order to narrow down the registered electronic form pages designated in the electronic form search result display field 50202; , Two types of methods can be used: a method for specifying the page classification name (specifying by inputting a check symbol in a check box in the page classification selection field). Hereinafter, the former method is referred to as “page number designation method”, and the latter method is referred to as “page classification designation method”.

  When the page number designation method is adopted, the designated electronic form page narrowing request 5023 designating the narrowed page in FIG. 2 includes the page number information input in the narrowed page number input field.

  When the page classification designation method is adopted, the page narrowing request 5023 includes page classification code information for identifying a page classification item for which a check symbol is input in the page classification selection field.

  In either case, the same page narrowing request 5023 includes the acquired registration information such as the processing year, processing date, and registration location in common.

  FIG. 10 shows an example of a block diagram of an electronic form page narrowing processing program 6060 that is started in response to a designated electronic form page narrowing request 5023 specifying the narrowing page in FIG.

  Upon receiving the page narrowing request 5023, the electronic form page narrowing processing program 6060 starts the designated electronic form reading processing step 60601 in FIG. 10, and the designated electronic form page narrowing request 5023 in which the narrowing page is designated is included in the designated electronic form page narrowing request 5023. The registered electronic form sheet 6041 with the specified form layout definition sheet is acquired from the electronic form registration directory 6040 sorted for each registered form search item according to the registration information related to the registered form.

  In the subsequent electronic form page narrowing processing step 60602, the electronic form sheet obtained in the previous step is subjected to page narrowing as follows according to the contents of the page narrowing specification of the page narrowing request 5023.

  When the narrowing page designation method of the page narrowing request is the page number designation method, the page narrowing processing step 60602 selects only pages that match the designated page number. For example, when the form user inputs “10, 20” in the narrowed page number input field of the electronic form search screen 5020, the tenth and twentieth pages of the obtained electronic form sheet are selected. Similarly, when “10:20” is entered in the narrowed-down page number input field, the 10th to 20th pages of the obtained electronic form sheet are selected.

  When the narrowing page designation method of the page narrowing request is the page classification designation method, the page narrowing processing step 60602 is based on the designated page classification code, and the page matches the page classification designation condition from the acquired page configuration information. The starting page number in the combination of classification is acquired, and the narrowed down pages are selected according to the page number.

  For example, in the page classification selection field of the electronic form search screen 5020, the form user selects check boxes for “product category: book”, “product category: beverage”, “region: Hokkaido”, “region: Aomori”, and “region: Akita”. When a check symbol is input and designated, first, from the acquired page configuration information regarding the electronic form sheet, a start page number “matching the conditions of“ page classification code 1: 001001 ”and“ page classification code 2: 003001 ” 1 ”is acquired.

  The number of selected pages from the start page number is usually based on the number of pages of the form layout definition sheet. When the number of selected pages is different from the number of pages of the form layout definition sheet, it can be flexibly dealt with by individually adding page number information.

  Next, for the combination of page classifications, a start page number that matches the conditions of “page classification code 1: 001001” and “page classification code 2: 003002”, “page classification code 1: 001001” and “page classification code 2: 003003 ”is sequentially acquired, and the start page numbers are acquired for all the specified page classification combination patterns (in this example, 2 × 3 = 6 patterns). The pages of the acquired electronic form sheet are selected.

  Finally, the page narrowing processing step 60602 transfers the acquired page configuration information related to the electronic form sheet to a new spreadsheet, and in the page selection for the page configuration information record described for each page classification combination. A character string indicating the sorting status is assigned. The character string indicating the selection status differs as follows depending on the page designation method.

  When pages are selected by the page number specifying method, a selection status code of “ALL” is assigned to a page configuration information record indicating a certain page classification combination when all pages corresponding to the combination are selected.

  Conversely, when no corresponding page is selected, a selection status code of “NOTHING” is assigned. If the form layout definition sheet covers a plurality of pages and does not correspond to the above two situations, the page numbers on the form layout definition sheet corresponding to the selected pages are listed by separating them with “,” (comma symbol). .

  When the pages are sorted by the page classification designation method, the sorting status code “ALL” is assigned to the page configuration information record that matches the page classification narrowing condition by the check symbol input. The sorting status code “NOTHING” is assigned to the other page configuration information records.

  As described above, the page configuration information sheet in which the selection status is recorded is added to the page-restricted electronic form sheet with the form layout definition sheet, and is output to the page-restricted electronic form output directory 6070. The given page configuration information sheet is used by a form user to specify a collation page on an electronic form collation screen 5030 described later.

  Next, the electronic form collation processing program 6080 shown in FIG. 2 will be described.

  11 and 12 are screen configuration examples of the electronic form collation screen 5030 in FIG. In this example, the electronic form collation screen 5030 is composed of a collation content setting screen 50301 in FIG. 11 and a collation page correspondence setting screen 50302 in FIG. 12, and the form user corresponds to the collation content setting screen 50301 and the collation page correspondence. On the setting screen 50302, an electronic form collation request 5031 specifying the collation data range, collation calculation formula, collation judgment condition, collation page correspondence, etc. in FIG. 2 is issued to the electronic form collation processing program 6080.

  First, the form user sets a collation target electronic form 1 setting tab 503012 in order to set collation contents of one electronic form to be collated in the collation calculation formula group setting field 503011 of the collation content setting screen 50301 in FIG. select. The collation target electronic form 2 setting tab 503013 selected by the form user for setting the collation contents of another electronic form to be collated also has screen elements equivalent to the inside of the collation target electronic form 1 setting tab 503012. Yes, the operations described below are performed in the same manner.

  In the selected collation target electronic form 1 setting tab 503012 (or collation target electronic form 2 setting tab 503013), the form user calculates the electronic form to be collated, the cell range in which the data to be collated is described, and the value to be collated. Set the expression and the judgment condition you want to match. Hereinafter, the flow and operation contents of four typical operation steps will be described.

  In the first operation step, in the collation target electronic form selection field 503014, an electronic document to be collated is selected from a set of the form layout definition sheet and the page structure information sheet with page structure information sheet 6070 output by the electronic form page narrowing processing program 6060. Select one form.

  By this operation, the collation content setting screen 50301 reads the selected electronic form sheet, and displays the form layout definition sheet attached to the electronic form sheet in the form layout definition preview 503015.

  In the second operation step, the contents of the form layout definition sheet of the electronic document to be verified are confirmed in the form layout definition preview 503015, and a character string (hereinafter, cell range) indicating the cell range containing the data to be used for verification. The cell range is designated by directly inputting (designated character string) into the collation formula input field of the collation formula setting field 503016. Here, it is assumed that the cell range designation character string conforms to a certain description rule.

  Regarding the cell range designation method, this screen configuration example is equipped with a cell range designation support interface capable of inputting a cell range designation character string by the following operation. The form user presses an “open form layout definition” button at the bottom of the form layout definition preview 503015 to open the form layout definition sheet with spreadsheet software.

  On the software, by selecting a cell range including data to be used for collation and pressing the “range setting” button on the collation target electronic form 1 setting tab 503012, the collation content setting screen 50301 is displayed as spreadsheet software. Is received in accordance with the description rules of the cell range designation character string, and the cell range designation character string is input in the collation formula input field of the collation formula setting field 503016 on the same tab. To do.

  A specific example of specifying the cell range is given below. Here, the electronic form that the form user wants to collate is an electronic form “List_A” having the form layout definition shown in FIG. 4, and the form user wants to collate based on the relevance in FIG. 18.

  When collating based on the relationship 1 in FIG. 18, four pages of “A company” row, “B company” row, “C company” row and “D company” row on each page, “2004 top” column and It is necessary to obtain the values described in the four rows and two columns (eight cells) intersecting with the two columns of the “2004 lower” column.

  For this purpose, the form user confirms the contents of the form layout definition sheet of the electronic form “List_A” in the form layout preview 503015, and the cell range on the form layout definition sheet corresponding to the cell of 4 rows and 2 columns, that is, “C6”. Determine the rectangular cell range with the cell at the top left and the “D9” cell at the bottom right, and directly enter the cell range specification character string “(C6: D9)” in the collation formula input field of the collation formula setting field 503016 Enter using the cell range designation support interface.

  The input cell range designation character string “(C6: D9)” in the present embodiment complies with the following description rule.

  The parentheses given to the beginning and the end of the cell range designation character string serve to keep the cell range character string distinguishable from other character strings even in the collation calculation processing step described later. is there. In the part between the parentheses, the character “:” indicates a rectangular cell range with “C6” and “D9” sandwiching the character, and “C6” is the upper leftmost cell of the rectangular cell range. “D9” is a character string indicating the lower rightmost cell in the same range. In particular, a rectangular cell range of one row and one column composed of a single cell can be simply expressed by a character string representing the single cell.

  When a plurality of rectangular cell ranges that do not overlap with each other are specified, they can be specified by listing character strings indicating the plurality of rectangular cell ranges in parentheses, delimited by “,”. The rectangular cell ranges that can be specified here may have different numbers of rows and columns as long as they do not overlap each other. “(C6: D9, F2)” is an example of a cell range designating character string indicating a plurality of rectangular cell ranges including a rectangular cell range of 4 rows and 2 columns and a rectangular cell range composed of a single cell.

  In the third operation step, for the cell range designation character string input in the collation formula input field, using a collation formula processing interface group arranged below the collation formula input field, The cell range designation character string is processed. (Hereafter, in the collation formula input field, the input or processed character string is referred to as the collation formula without distinction.)

  In the fourth operation step, the collation calculation formula processed in the third operation step is displayed as a list of collation calculation formulas by pressing the “Set collation formula” button located on the right side of the collation formula input field. Register in the 503017. The registration target collation formula is given a collation formula number such as “Formula 001”, and when the collation formula represents a cell range, the number of rows and columns of the cell range is “4 × 1”. A character string such as "" is assigned and displayed in one line in the collation formula list 503017. The character string representing the number of rows and the number of columns is expressed in consideration of “the number of rows and the number of columns recognized by the electronic form collation processing program 6080” described later. After pressing the “Set collation formula” button, the collation formula input field is empty.

  Here, the collation calculation processing interface group used in the third operation step and “the number of rows and columns recognized by the electronic form collation processing program 6080” (hereinafter, the number of rows and columns are collectively referred to as collation). A specific explanation will be given for the matrix type).

  In the present embodiment, the following four interfaces are provided for the collation calculation processing interface group used in the third operation step (in the description of each interface, four lines are set as a processing target cell range designation character string). Cell range specification character string “(C6: D9)” indicating a rectangular cell range of two columns, and cell range specification character string “(C6: D9, F2) indicating a plurality of rectangular cell ranges of four rows and two columns and one row and one column” ) "As an example).

  The “range division designation” interface that is the first interface tells the electronic form collation processing program 6080 how to divide the cell range indicated by the cell range designation character string input in the collation formula input field. It is an interface that specifies whether the sum of values is used for collation processing.

  The “range division designation” interface provided in the present embodiment is four buttons of “no division”, “row division”, “column division”, and “cell division”.

  The “no division” button is used to cause the electronic form collation processing program 6080 to recognize each rectangular cell range indicated by the cell range designation character string as one cell. When the form user presses the “No division” button, for example, the cell range specification character string “(C6: D9)” is converted to “Σ (C6: D9)” (hereinafter, the converted character string is also distinguished) The form user is conscious of taking the sum of the values described in the cells in the cell range by using the first character “Σ” (the Greek letter “sigma”). be able to.

  The electronic form collation processing program 6080 that has received the electronic form collation request 5031 including the cell range designation character string includes the values described in the cells included in the rectangular cell range in each rectangular cell range indicated by the cell range designation character string. Are added together and recognized as if it were a value of one cell, and collation processing is performed.

  A part of the collation processing on one page in FIG. 18 will be described as an example. The electronic form collation processing program 6080 detects the first character “Σ” of the cell range designation character string “Σ (C6: D9)” included in the electronic form collation request 5031, and sets each rectangular cell range as one cell as described above. 8 in the rectangular cell range of 4 rows and 2 columns (matrix type is “4 × 2”) corresponding to “(C6: D9)” in the form layout definition sheet. Take the sum of the values “100”, “150”, “200”, “200”, “300”, “500”, “400”, “300” written in the cell, and have the value “2150” in one row The cell range is recognized as a single cell range (that is, the matrix type of the cell range designation character string “Σ (C6: D9)” is “1 × 1”). Thereafter, the value is used for the collation process.

  When the cell range character string “(C6: D9, F2)” (matrix type is “4 × 2, 1 × 1”) indicating a plurality of rectangular cell ranges is converted with the “no division” button, “Σ (C6: D9, F2) ". Since the values described in all cells are added in each rectangular cell range, the cell range designation character string “Σ (C6: D9, F2)” has a cell range of one row and one column (ie, a single cell). It is recognized as if there are two (therefore, the matrix type of the cell range designation character string “Σ (C6: D9, F2)” is “1 × 1,1 × 1”).

  If you want to add together the values of the two cell ranges and recognize them as one cell range as a whole, that is, if you want to set the matrix type to “1 × 1” as a whole, once again the “No division” Press the button, change the cell range specification string “Σ (C6: D9, F2)” to “Σ (C6: D9 + F2)” (the rectangular cell range separator “,” distinguishes multiple rectangular cell ranges) Converted to the character “+” meaning to add together). The two characters “,” and “+” are converted into each other by pressing the “no division” button.

  The “divide line” button is used for the electronic form collation processing program 6080 to divide each rectangular cell range indicated by the cell range designation character string in the row direction and recognize it as a cell range of one column. When the form user presses the “divide line” button, for example, the cell range designation character string “(C6: D9)” is converted to “RΣ (C6: D9)”, and the form user selects the first two characters “ It is possible to recognize that the sum of values described in the cells included in the cell range is summed in the row direction by “RΣ”.

  The electronic form collation processing program 6080 that has received the electronic form collation request 5031 including the cell range designation character string includes the values described in the cells included in the rectangular cell range in each rectangular cell range indicated by the cell range designation character string. Are all added in the row direction, and the values are recognized as if they were values in the cell range of one column, and collation processing is performed.

A part of the collation processing on one page in FIG. 18 will be described as an example.
The electronic form collation processing program 6080 detects the first two characters “RΣ” of the cell range designation character string “RΣ (C6: D9)” included in the electronic form collation request 5031, and sets each rectangular cell range as one column as described above. In order to recognize it as a cell range, a rectangular cell range of 4 rows and 2 columns (matrix type is “4 × 2”) corresponding to “(C6: D9)” in the form layout definition sheet is included in the rectangular cell range. The values “100”, “150”, “200”, “200”, “300”, “500”, “400”, “300” described in the eight cells are summed in the row direction in each row, Recognized as a 4-row, 1-column cell range having values of “250”, “400”, “800”, “700” (therefore, the matrix type of the cell range designation character string “RΣ (C6: D9)” is “4 × 1”). Thereafter, the value is used for the collation process. The set of values in this example exactly matches the set of values acquired on the one hand on each page when collating based on relevance 1 in FIG. 18 (collation 1).

  When the cell range character string “(C6: D9, F2)” (matrix type is “4 × 2, 1 × 1”) indicating a plurality of rectangular cell ranges is converted with the “row division” button, “RΣ (C6: D9, F2) ". Since the values described in all the cells are added in the row direction in each rectangular cell range, the cell range designation character string “RΣ (C6: D9, F2)” is 2 in 4 rows and 1 column and 1 row and 1 column. It is recognized as if there were two cell ranges (therefore, the matrix type of the cell range designation character string “RΣ (C6: D9, F2)” is “4 × 1,1 × 1”).

  In the case of “RΣ (C6: D9, F2)”, since the number of rows of the two cell ranges is different (4 rows and 1 row), it is impossible to add the values of the two cell ranges. However, if the two cell ranges have the same number of rows, the values of the two cell ranges can be added together to be recognized as a cell range of one column as a whole.

  For this purpose, the form user presses the “divide line” button once more, and the character “,” which means that the rectangle cell range delimiter character “,” in the cell range designation character string is added without distinguishing a plurality of rectangular cell ranges. + ". The two characters “,” and “+” are converted into each other by pressing the “divide line” button.

The “column division” button is used for the electronic form collation processing program 6080 to divide each rectangular cell range indicated by the cell range designation character string in the column direction and recognize it as a cell range of one row. When the form user presses the “divide column” button, for example, the cell range designation character string “(C6: D9)” is converted to “CΣ (C6: D9)”, and the form user selects the first two characters “ It can be recognized that the values described in the cells included in the cell range are summed in the column direction by “CΣ”.

  The electronic form collation processing program 6080 that has received the electronic form collation request 5031 including the cell range designation character string includes the values described in the cells included in the rectangular cell range in each rectangular cell range indicated by the cell range designation character string. Are all added in the column direction, and the values are recognized as if the cell range of one row has a matching process.

  A part of the collation processing on one page in FIG. 18 will be described as an example. The electronic form collation processing program 6080 detects the first two characters “CΣ” of the cell range designation character string “CΣ (C6: D9)” included in the electronic form collation request 5031, and makes one line for each rectangular cell range as described above. In order to recognize it as a cell range, a rectangular cell range of 4 rows and 2 columns (matrix type is “4 × 2”) corresponding to “(C6: D9)” in the form layout definition sheet is included in the rectangular cell range. Take the sum of the values “100”, “150”, “200”, “200”, “300”, “500”, “400”, “300” in each column in the column direction, Recognized as a cell range of 1 row and 2 columns each having a value of “1000” and “1150” (therefore, the matrix type of the cell range designation character string “CΣ (C6: D9)” is “1 × 2”) ). Thereafter, the value is used for the collation process.

  When the cell range character string “(C6: D9, F2)” (matrix type is “4 × 2, 1 × 1”) indicating a plurality of rectangular cell ranges is converted with the “column division” button, “CΣ (C6: D9, F2) ". Since the values described in all cells in each rectangular cell range are added in the column direction, the cell range designation character string “CΣ (C6: D9, F2)” is 2 in 1 row and 2 columns and 1 row and 1 column. It is recognized as if there were two cell ranges (therefore, the matrix type of the cell range designation character string “CΣ (C6: D9, F2)” is “1 × 2, 1 × 1”).

  In the case of “CΣ (C6: D9, F2)”, the number of columns of the two cell ranges is different (in two columns and one column), so it is impossible to add the values of the two cell ranges. However, if the two cell ranges have the same number of columns, the values of the two cell ranges can be added together to be recognized as a cell range of one row as a whole. For this purpose, the form user presses the “column division” button once more, and the character “+” in the meaning of adding the delimiter “,” of the rectangular cell range in the cell range designation character string without distinguishing the plurality of rectangular cell ranges. Can be converted. The two characters “,” and “+” are converted into each other by pressing the “column division” button.

  The “cell division” button is used to cause the electronic form collation processing program 6080 to individually recognize each cell included in each rectangular cell range indicated by the cell range designation character string. When the form user presses the “divide cell” button, for example, the cell range designation character string “(C6: D9)” is kept in the same format as “(C6: D9)”, and the form user keeps the cell range. (Matrix type is “4 × 2”) It can be recognized that the values described in the cells included in each cell are individually verified.

  This format is the first format of the cell range specification character string input through the cell range specification support interface. The electronic form collation processing program 6080 that has received the electronic form collation request 5031 including the cell range designation character string includes the values described in the cells included in the rectangular cell range in each rectangular cell range indicated by the cell range designation character string. Are individually recognized and collated.

  Of the “No split” button, “Row split” button, “Column split” button, and “Cell split” button in the “Range split specification” interface, the character string conversion effect of the last pressed button is displayed in the collation formula input field. It is reflected in the entered cell range specification string.

  The second interface, “default formula selection” interface, inputs a character string representing a registered collation formula in the collation formula list 503017 by pressing the “set collation formula” button, and displays the registered collation formula. It is an interface used when setting another collation calculation formula using the contents.

  For example, it is assumed that the collation formula “RΣ (C6: D9)” (matrix type is “4 × 1”) is registered as “formula 001” in the collation formula list 503017. To obtain a set of values obtained by multiplying each value by “1000” for the 4-row, 1-column value set obtained by the matching calculation formula, the form user first uses the “select default formula” interface. Then, select "Formula 001" from the set of collation formula numbers registered in the collation formula list 503017, and press the "Enter in collation formula entry field" button. By this operation, a character string of the form “(formula 001)” in the collation calculation formula input field (hereinafter, a character string in a format in which the registered collation formula number is sandwiched between parentheses is converted into the registered collation formula. Is written as “default formula”.

  Next, add “X” immediately after the default formula “(Formula 001)” using the “X” button of the “Operator input” interface described later, and enter the string “1000” directly at the end. Then, a character string “(formula 001) × 1000” is input. After that, by pressing the “Set collation formula” button, a new collation formula number and the matrix type of the collation formula (in this example, “4 × 1”, which is the same as “Formula 001”) will be assigned. It is registered in the calculation formula list 503017.

  The third interface, the “operator input” interface, is used to input a collation formula in order to perform an operation between the two collation formulas (in this embodiment, four arithmetic operations of addition, subtraction, multiplication, and division). This is an interface used when an operator (four arithmetic operators “+”, “−”, “×”, “÷” in this embodiment) is entered in the column.

  For example, in the description of the “select default formula” interface, the “×” button performs multiplication between the default formula “(formula 001)” (matrix type is “4 × 1”) and the directly input numeric value “1000”. Therefore, it is used when the multiplication operator “×” is entered in the collation formula input field. As a result, in the set of 4 rows and 1 column values obtained by the default formula “(formula 001)”, each value is multiplied by “1000” to obtain the same 4 row and 1 column value set (therefore, The matrix type of the new collation formula obtained by the multiplication is “4 × 1” as described above).

  The four buttons of the “operator input” interface provided in this embodiment can be used when either of the following two conditions is satisfied.

  The first condition is that the matrix types of the two collation formulas sandwiching the operator are matched with each other for the operator input through the “operator input” interface. Thereby, in the same matrix type value set indicated by the two matching calculation formulas, corresponding values can be calculated by the operation indicated by the operator, and the value set obtainable by the calculation result is Matches the matrix type.

  The second condition is that one of the two collation formulas that sandwiches the operator is “1 × 1” for the operator input through the “operator input” interface. is there. As a result, there is only one value indicated by the collation calculation formula whose matrix type is “1 × 1” (in the collation process, the data content changes depending on the page to be acquired, but there is only one data to be handled at the same time. Value) and each value in the value set indicated by the other collation calculation formula can be calculated by the operation indicated by the operator, and the value set obtainable by the calculation result is the latter collation calculation. Matches the matrix type of the expression.

  It is assumed that a collation formula that does not satisfy either of the two conditions cannot be registered in the collation formula list 503017 by pressing the “set collation formula” button.

  The fourth interface “rounding designation” interface is for instructing the electronic form collation processing program 6080 to round the value acquired according to the collation formula entered in the collation formula input field. , An interface used when assigning a character string to the collation formula.

  The “rounding designation” interface provided in this embodiment includes an “integer” button, a “decimal” button and a rounding target digit selection field for designating a rounding target digit, and “rounding up” indicating the content of rounding processing, There are three buttons, “Truncate” and “Round off”.

  Only one of the “integer” button and the “decimal” button can be selected, and the rounding target digit is determined in combination with the number of digits selected in the rounding target digit selection field. For example, if you select the “integer” button and select “2” in the rounding target digit selection field, the value obtained according to the collation formula is rounded to the tens place (the result is a value that is a multiple of a hundred) Is used for the collation process). If you select the “decimal” button and select “1” in the rounding target digit selection field, the value obtained according to the collation formula is rounded to the first decimal place (the result is an integer value). Is used for the collation process).

  After determining the rounding digit as described above, by pressing one of the buttons "Round up", "Rounding down", or "Rounding off", the content of the rounding process to be applied to the rounding target digit is determined and verified. A character string conversion indicating the rounding content is applied to the collation calculation formula input in the calculation formula input field.

  For example, if the cell range specification column “CΣ (C6: D9, F2)” (matrix type is “1 × 2,1 × 1”) is entered in the collation formula input field, Select the “decimal” button, select “1” in the rounding digit selection field, and press the “round off” button. The collation formula in the collation formula entry field is “↑ CΣ (C6: D9, F2 ),-1 ↓ ".

  By adding the character “↑” at the beginning of the collation calculation formula and the character “↓” at the end, the form user is subjected to the “rounding” process on the collation calculation formula sandwiched between the characters. You can be conscious of that.

  In addition, the form user confirms that the rounding target digit of the rounding process is the first decimal place by the sign and numerical value of the character string “-1” added after the “,” after the cell range character string. I can be conscious. Since the rounding process is performed on each acquired value, the matrix type of the collation formula “↑ CΣ (C6: D9, F2), − 1 ↓” is “1 × 2,1 × 1”. It remains.

  A supplementary explanation will be given for character string conversion indicating the rounding process contents in this embodiment. A pair of characters sandwiching the collation calculation formula is “↑” and “↑” when the rounding processing content is “rounded up” processing, and “↓” and “↓” when the rounding processing content is “rounded down” processing. In addition, in the character string indicating the rounding target digit given after “,” after the cell range character string, there is no sign when the “integer” button is selected, and when the “decimal” button is selected. Negative sign is given.

  In this way, the form user registers the collation calculation formulas according to the contents to be collated in the collation calculation formula list 503017 on the collation target electronic form 1 selection tab 503012, and similarly the collation target electronic form 2 selection tab 503013. After completing the registration of the collation calculation formula in line with the content to be collated, the collation judgment condition setting column 503018 is finally connected with the collation relational operators in the collation judgment condition setting field 503018 to thereby match the collation judgment condition to be collated. Express. Select the registered collation formula of each electronic form in the collation calculation formula selection field of the collation target electronic form 1 and electronic form 2, and collate the relational operator according to the relationship to be collated in the collation relational operator selection field between them. Select.

  The collation relational operators that can be selected in this embodiment include “=” (the value used for collation of the collation target electronic form 1 is equal to the value used for collation of the collation target electronic form 2), “≠” (same, equal No), “≧” (the value used for collation of the collation target electronic form 1 is greater than or equal to the value used for collation of the collation target electronic form 2), “>” (same, larger), “≦” (same, Small or equal) and "<" (same, small).

  In this embodiment, it is assumed that one of the following two conditions must be satisfied between two collation formulas that can be linked by the collation relational operator.

  The first condition is that the matrix types of the two collation formulas connected by the collation relational operator are the same. Thereby, in the same matrix type value set indicated by the two collation calculation formulas, corresponding values can be collated using the collation relational operator.

  The second condition is that one of the two types of collation calculation expressions linked by the collation relational operator is “1 × 1”. As a result, there is only one value indicated by the collation calculation formula whose matrix type is “1 × 1” (in the collation process, the data content changes depending on the page to be acquired, but there is only one data to be handled at the same time. Value) and each value in the set of values indicated by the other collation calculation formula can be collated using the collation relational operator.

  In a combination of two collation formulas that do not satisfy either of the two conditions, a blank is displayed in the “matrix type” field in the collation determination condition setting field, so that the form user can have either of the two conditions. It can make you aware that you are not satisfied. In this case, it is assumed that transition to the collation page correspondence setting screen 503021 in FIG.

  The form user sets the content to be collated in the collation calculation formula group setting field 503011 and the collation determination condition setting 503018 of the collation content setting screen 50301, and then presses the “transition page correspondence setting screen transition” button to display FIG. Transition to the matching page correspondence setting screen 503021.

  In the collation page setting field 503021 of the collation page correspondence setting screen 50302 in FIG. 12, the form user sets which collation contents set on the collation content setting screen 50301 and which page classification group of the collation target electronic form 1 and collation target electronic form 2 It is set which page classification group of which the matching process is applied.

  The form user first selects an electronic form for which collation page setting is to be performed in the collation page setting target electronic form selection field in the collation page setting field 503021, and selects a collation target electronic form 1 button or a collation target electronic form 2 button. specify.

  By selecting the collation page setting target electronic form, the collation page correspondence setting screen 50302 displays the collation page setting target electronic form selection field in accordance with the selection status of the page configuration information sheet possessed by the page narrowed electronic form sheet. Items that can be selected by the form user are determined in the page classification selection column arranged at the bottom.

  The collation page correspondence setting screen 50302 confirms the selection status of the electronic document sheet that has been narrowed down, and a report user cannot select a page classification combination whose selection status is “NOTHING” (or displays a warning message indicating that selection is not possible). Output).

  In addition, when the form layout definition sheet is composed of a plurality of pages, the form layout definition sheet used for the collation content setting on the collation content setting screen 50301 in the same way as the page classification combination of the page-restricted electronic form sheet. Control is performed so that the form user cannot select (or output a warning message indicating that the page cannot be selected) for a combination in which no page corresponding to the page is selected.

  In this embodiment, the collation page correspondence setting screen 50302 includes a special character “*” representing all page classifications that can be selected in the page selection field when setting selectable members in each page classification selection field.

  When the form user selects the special character, the collation page correspondence setting screen 50302 sequentially sets all the page classifications that can be selected in the corresponding page classification selection column when registering the page classification combination described later. A plurality of page classification combinations are continuously set, and a form user is supported to continuously register a plurality of page classification records. The continuous registration will be described later together with a description of registration examples.

  The form user selects the collation page setting target electronic form, and then selects the combination of page classifications to be used for the collation processing in the page classification selection field located below the collation page setting target electronic form selection field (selectable under the above control) A record indicating the selected page classification combination (hereinafter referred to as a page classification record) is selected by pressing the “match page setting” button arranged on the right side of the collation page setting field 503021. It is registered in the collation page correspondence list 503022 arranged at the bottom of the collation page correspondence setting screen 50302.

  After registering the page classification records of collation target electronic forms 1 and 2 in the collation page correspondence list 503022, by pressing the “electronic form collation processing start” button arranged at the bottom of the collation page correspondence setting screen 50302, the electronic form An electronic form collation request 5031 including the collation contents and collation page correspondence setting contents set on the collation content setting screen 50301 and the collation page correspondence setting screen 50302 constituting the collation screen 5030 is issued to the electronic form collation processing program 6080.

  Here, a supplementary explanation is added to the collation group. The role of the collation group is to specify in which page classification range the sum of values obtained according to each collation calculation formula set on the collation content setting screen 50301 is to be used for collation processing. . A collation group is identified by a collation group number.

  For each set of values acquired according to each collation calculation formula, each page classification combination record group (that is, a record group having the same collation group number) belonging to the same collation group is individually created for each member constituting the value pair. The sum is taken over the group of pages shown and used for collation processing.

  Therefore, the set of values after taking the sum has the same matrix type. Further, in the collation page correspondence list 503022, page classification groups to which the same collation group number is assigned between two collation reference electronic forms correspond to page groups for generating values to be matched with each other in collation processing.

  When registering a page classification record in the collation page correspondence list 503022, the line number and collation group number of the registration target page classification record are the collation page correspondence setting position selection column arranged on the right side of the collation page setting column 503021. It can be specified from the line number selection column and the collation group number selection column.

FIG. 13 is a diagram illustrating an example of a collation group including a plurality of page classification records.
The collation group example is a part of the page classification record registration example (limited to the page classification of “product type: book”) when collating the electronic form “List_A” based on the relation 2 in FIG. 18 (collation 2). Example).

  The upper part of FIG. 13 is a diagram in which the contents of the collation page setting field are simply expressed within a range in which the setting contents are known, and the lower part of FIG. 13 is a page classification correspondence list registered according to the setting contents. As a pre-setting in this example, the same electronic form “List_A” is set for collation target electronic forms 1 and 2, and the page narrowing setting for the collation target electronic form 1 is “region: It is assumed that all pages excluding "" are acquired, and for the electronic document 2 to be collated, setting is made to acquire only pages that are "Region: Nationwide" by the page classification designation method. Further, in the collation content setting, it is assumed that a cell range designation character string of cell division “(C6: E9)” (matrix type is “4 × 3”) is set as “expression 001”.

  When a form user collates based on relevance 2, first the “Product Type” page classification is fixed to “Book” and the “Region” page classification is set to the special character “*” in the setting of the electronic form 1 to be collated. (Upper left figure of FIG. 13). The special character “*” sequentially sets all the page classifications that can be selected in the “Region” page classification selection column, and supports an operation of continuously registering a plurality of page classification records.

  In this case, since the page narrowing setting of the collation target electronic form 1 is a setting for acquiring all pages except “Region: Nationwide”, the record of the page configuration information given to the electronic form sheet is “Region: A sorting status code of “ALL” is assigned to all page classification combinations that are not “National total”.

  Accordingly, the collation page correspondence setting screen 50302 changes the contents sequentially from “Hokkaido” “Aomori” to “Okinawa” for the “region” page classification in accordance with the setting of the special character “*” (page refinement condition). Accordingly, 47 page classification records are generated and continuously registered in the column of collation target electronic form 1 of collation page correspondence list 503022. All the collation group numbers of the 47 record page classification records are registered as “0001”.

  Next, the form user associates one page classification combination of “product type: book” and “region: nationwide” with “line number” in association with the 47 page classification records in the setting of collation target electronic form 2. : 0001 ”and“ collation group number: 0001 ”.

  As a result, the form user can use 47 pages from “Region: Hokkaido” to “Region: Okinawa” and 1 of “Region: National total” in the “Product category: Book” page group of the same electronic form “List_A”. It is possible to make settings for matching pages in correspondence.

  The electronic form collation processing program 6080 receives an electronic form collation request 5031 including the setting of the collation page correspondence list, so that a part of the collation processing (collation 2) based on the relation 2 in FIG. The matching process corresponding to “page classification limited to“) is executed.

  FIG. 14 is an example of a block diagram of an electronic form collation processing program 6080 that is started in response to an electronic form collation request 5031 in which the collation data range, collation calculation formula, collation determination condition, collation page correspondence, etc. in FIG. 2 are designated. FIG.

  Upon receiving the electronic form collation request 5031, the electronic form collation processing program 6080 starts the electronic form collation processing main loop 60801 of FIG.

  In the electronic form collation processing main loop 60801, first, in the electronic form designation page acquisition processing step 60802, the form layout definition output by the electronic form page narrowing processing program 6060 is output in accordance with the collation target electronic form designation included in the electronic form collation request 5031. An electronic form page sheet group (the electronic form page sheet indicated by the page classification record constituting the collation group) that configures the collation page correspondence specification included in the collation request 5031 is read. Get).

  Next, in electronic form collation calculation processing step 60803, according to the setting contents of each collation group included in the collation request 5031, the electronic form page sheet indicated by the page classification record constituting the collation group is selected from the acquired page sheet group. And get.

  Subsequently, a set of values described in the cell is acquired from the selected page sheet group in accordance with the collation data range specification indicated by each collation calculation formula included in the collation request 5031 and calculated.

  When the collation group is composed of a plurality of page classification records, the sum of the members of the obtained and calculated value sets is summed over the pages indicated by the page classification records.

  Thereafter, in the electronic form collation processing step 60804, corresponding values are collated with the set of values acquired and calculated in the electronic form collation calculation processing step 60803 in accordance with each collation determination condition included in the collation request 5031. The collation processing step 60804 is executed for all pairs of the collation group and the collation judgment condition through the electronic form collation processing main loop 60801.

  As a result of the collation processing step 60804, for the collation group and collation judgment condition pair that matches the collation judgment condition (the pair corresponding to the “matching result [true] case”), the electronic form collation result of the electronic form collation result [True] The collation result information in the case is output to the electronic form collation result [true] general information 60921 constituting the information group 6092, and the electronic form collation result [true] detailed information 60922 is output.

  Similarly, as a result of the collation process, a collation group and collation judgment condition pair that does not match the collation judgment condition (a pair corresponding to the “matching result [false] case”) The collation result information [false] is output to the electronic form collation result [false] general information 60931 constituting the form collation result [false] information group 6093, and the electronic document collation result [false] detailed information 60932 is output.

  FIG. 16 is a diagram showing an output example of the electronic form electronic form collation result [true] general information 60921 in this embodiment, and FIG. 17 shows the electronic form electronic form collation result [true] detailed information 60922 in this embodiment. It is a figure which shows the example of an output.

  The output examples of the electronic form verification result [false] general information 60931 and the electronic form verification result [false] detailed information 60932 are similar to the electronic form verification result [true] general information 60921 and the electronic form verification result [true] detailed information 60922, respectively. Therefore, it is omitted.

The contents of an output example of the electronic form collation result [true] general information 60921 in FIG. 16 will be described.
The general information 60921 in this embodiment is output as a text data file.

  First, at the top of the file, the number of collation groups and the number of collation judgment conditions that are subject to collation processing are output, and the collation result number calculated by multiplication from the number is also output. At the bottom, the number of pairs of matching groups and matching judgment conditions corresponding to the case of matching result [true] by electronic document matching processing step 60804 (hereinafter referred to as the number of matching results [true]) is calculated as the number of matching results. Output as a breakdown.

  In this embodiment, when there is a case where the value used for the collation processing is obtained from the blank cell and collated, the case (hereinafter referred to as blank collation case) is specially counted and the number of cases is counted. An application example is also given in which the number of matching cases (hereinafter referred to as the number of blank matching cases) is output as a breakdown of the number of matching results [true]. The number of blank collation cases is used when an omission of data description in an electronic form is detected, etc. (For that purpose, naturally, it is necessary to implement a function for acquiring and outputting the number of cases in the electronic form collation processing step 60804). .

  Furthermore, in the lower part (the lower part in FIG. 16 that is delimited by a list of “=” (equal symbol)), the collation determination condition is set for each case for the collation result [true] as the collation result detailed information. The details of the values used in the collation target electronic form information, collation group setting, and collation processing are output.

  The details of the values used in the matching process include the matching determination condition of the case and the value acquired by each matching calculation formula in the matching group, the range number indicating the position information along the matrix type of the matching calculation formula, It is configured by assigning and listing three values of a row number and a column number and a detail number indicating a page classification record in the collation group.

  A pair of “collation determination condition: determination 001” and “collation group: 0001” in FIG. 16 will be described as an example (assuming that collation target electronic forms 1 and 2 are both electronic forms “List_A”). When the electronic form collation processing program 6080 performs the first value collation in accordance with the determination condition, first, 47 pieces of collation target electronic forms 1 according to the collation calculation formula (that is, formula 001 “(C6: E9)”) and collation group setting are used. From the page indicated by the page classification record (that is, the prefecture page of “product type: book”), the value (“100”, “300”) in the cell corresponding to the position of the cell “C6” in the form layout definition sheet ,..., 47 values “100”).

  Next, the sum of the 47 values is taken, and the obtained value “10500” is set as a value used for the collation processing. Similarly, the value “10500” described in the cell corresponding to the position of the cell “C6” in the form layout definition sheet is acquired as the collation target electronic form 2 on the “product type: book” “region: nationwide” page.

  By collating the two values according to the collation relation operator “=” of “collation determination condition: determination 001”, the two values are confirmed as satisfying the determination condition. After that, by executing all the corresponding value matching (although changing the column, row, rectangular cell range) according to the matrix type of the matching calculation formula, it is confirmed that all the value matching satisfy the judgment condition. Then, it is recognized that the case is a case of the collation result [true].

  The specification 609211 corresponding to the first value collation includes the following contents. The position information along the matrix type of the values to be collated is represented by “range: 0001”, “row: 0001”, “column: 0001” and is output (the first rectangle in the cell range designation of the form layout definition sheet) Cell corresponding to the first column of the first row in the cell range).

  Next, in order to calculate the value to be collated by summation, a detail number from “detail: 0001” to “detail: 0047” is assigned to the value acquired from the page indicated by each page classification record, Lists values.

  At that time, the range number, row number, column number, detail number pair, and the value to be acquired in each electronic document to be collated are separated from each other by “|” (pipe symbol), and the collation group is composed of multiple page classification records. When configured, a range where “+” (plus sign) is delimited for lines with the item number “0002” or more so that the user of the form can understand the meaning of “take the sum of the values in the collation group” It is given at the beginning of

  Then, the value to be collated is output as a special line of “detail: total” (the delimiter for the two values is changed to “:” (colon symbol) so that it can be easily distinguished from other lines). Finally, in order to distinguish it from the next detail that follows, a line in which “-” (minus sign) is listed is output.

  The contents of an output example of the electronic form collation result [true] detailed information 60922 in FIG. 17 will be described. The detailed information 60922 is a value obtained from which cell in the page indicated by each page classification record constituting the collation group in order to calculate the value used for the collation for each collation result [true] case. Is output so that the user of the form can recognize.

  The detailed information 60922 in this embodiment is output as a sheet group of spreadsheet software. In the collation, the page user indicated by each page classification record constituting the collation group is copied, and the background color of the cell in which the acquired value is described is color-coded so that the form user can distinguish it from other cells. Output to.

  Even if the electronic form is created as a text data file, the item corresponding to the cell is output in some expression that the form user can distinguish from the other items as described above (for example, “→ ("Right arrow symbol" can be output).

  By browsing the detailed information 60922, the form user can acquire the data that is the basis of the matching case in a batch without searching for each of the original electronic forms.

  The description of the electronic form collation result [false] information group 6093 is the same as the explanation of the electronic form collation result [true] information group 6092, and is omitted here.

  When the electronic form collation processing main loop 60801 ends, the program 6080 executes an electronic form collation result comprehensive information registration processing step 60805 which is a final processing step. In this processing step 60805, information relating to the entire collation processing is output to the electronic form collation result comprehensive information 6091.

  FIG. 15 is a diagram illustrating an output example of the electronic form electronic form collation result comprehensive information 6091 in the present embodiment.

  The general information 6091 in this embodiment is output as a text data file. First, the number of collation groups and the number of collation judgment conditions that have been subjected to collation processing are output at the top of the file, and the number of collation results calculated by multiplication from the number is also output.

  At the bottom, the number of matching results [true] and the number of blank matchings that are the breakdown are output, and similarly, the number of matching results [false] and the number of blank matchings that are the breakdown are output.

  In this embodiment, the time when the electronic form collation processing main loop 60801 starts and ends is recorded and output together with the processing time of the main loop 60801 calculated by subtraction from the two times.

  Furthermore, in the lower part (the lower part in FIG. 15 separated by an enumeration of “=” (equal symbol)), various specified information included in the received electronic form collation request 5031 is set as collation target electronic form information and collation content setting. Output as information and setting information corresponding to page classification.

  The form user can reconfirm the contents of various information specified in the electronic form collation request 5031 by browsing the general information 6091.

  Finally, the electronic form collation result acquisition processing program 6100 in FIG. 2 will be described.

  The form user designates the electronic form matching result 6090 to be acquired, issues an electronic form matching result acquisition request 5032 to the electronic form matching result acquisition processing program 6100, and receives the matching result acquisition request 5032. The result acquisition processing program 6100 sorts the designated one out of the electronic form verification results 6090 output from the electronic form verification processing program 6080 and transfers it to the client PC.

  Functions realized by the electronic form creation means 1030, the electronic form registration means 2020, the electronic form lantern information acquisition means 3010, the electronic form page narrowing means 3030, and the electronic form collation means 4010 in FIG. This is realized by executing with the CPU.

  That is, the processing of each program 6010, 6050, 6060, 6080, and 6100 in FIG. 2 (see the flowcharts in FIGS. 3, 9, 10, and 14) is converted into a computer program via a network such as the Internet, or a CD-ROM, The program is recorded on a recording medium such as an FD or DVD and distributed to the customer. The customer installs the program in a storage device of a computer and causes the CPU to execute the program. As a result, the present invention can be widely distributed in the market.

  By applying the present invention, electronic forms can be created, registered, searched, page narrowed down and collated in a series of flows, and analysis work using data described in electronic forms and electronic form output specifications In a task that requires a large amount of data collation, such as a verification task, it is possible to reduce the labor required for the collation operation.

It is a principle explanatory view of the present invention. It is a schematic diagram showing the best mode for carrying out the present invention. It is a block diagram which shows the electronic form creation process and registration process program in an Example. It is an example of the layout definition sheet for electronic form creation in an Example. It is an example of the table of the database for electronic form creation in an Example. It is an example of a table of page configuration information and an electronic form registration information database in an example. It is an example of an electronic form registration directory classified for each electronic form registration instruction information and registered form search item in the embodiment. It is an example of a screen structure of the electronic form search screen in an Example. It is a block diagram which shows the electronic form search process program in an Example. It is a block diagram which shows the electronic form page narrowing-down process program in an Example. It is a screen structural example of the electronic form collation screen (collation content setting screen) in an Example. It is a screen structural example of the electronic form collation screen (collation page corresponding | compatible setting screen) in an Example. It is an example of the collation group comprised by the multiple page classification record in an Example. It is a block diagram which shows the electronic form collation processing program in an Example. It is an example of an output of the electronic form collation result comprehensive information in an Example. It is an output example of the electronic form collation result [true] comprehensive information in the embodiment. It is an output example of the electronic form collation result [true] detailed information in the embodiment. It is a figure for demonstrating the collation example of the description data in the electronic form produced with the spreadsheet software.

Explanation of symbols

100: Electronic form creation instruction 1000: Electronic form creation apparatus 1010: Electronic form creation information 1020: Electronic form creation form layout definition 1030: Electronic form creation means 1040: Electronic form 1050: Form layout definition 1060: Electronic form page configuration information 2000: Electronic form registration device 2010: Electronic form registration instruction information 2020: Electronic form registration means 2030: Electronic form registration directory classified for each registered form search item 2040: Registered electronic form 2050: Electronic form search information group 2060: Electronic form registration information 2070 in the electronic form search information group: Form layout definition 2080 in the electronic form search information group 2080: Electronic form page configuration information in the electronic form search information group 300: Electronic form search instruction 3000: Electronic form Search device 301 : Electronic form registration information acquisition means 3020: Electronic form search result 3030: Electronic form page narrowing means 3040: Page narrowed electronic form 3050: Electronic form matching information group 3060: Form layout definition in electronic form matching information group 3070: Electronic form page configuration information in the electronic form collation information group 350: Search instruction in designated electronic form 400: Electronic form collation instruction 4000: Electronic form collation apparatus 4010: Electronic form collation means 4020: Electronic form collation result 4030: Electronic form collation Electronic form collation result general information 4040 in the result: electronic form collation result [true] information group in the electronic form collation result 4050: Electronic form collation result [true] electronic form collation result in the information group [true] general information 4060: Electronic form verification result [true] Electronic form verification result [true] detailed information in information group 4070: Electronic form collation result [false] information group in electronic form collation result 4080: Electronic form collation result [false] electronic form collation result [false] general information in information group 4090: Electronic form collation result [false] information group Electronic form verification result [false] detailed information 5000: Client PC
5010: Electronic form creation screen 5011: Electronic form creation request 5020: Electronic form search screen 50201: Electronic form search condition setting field 50202: Electronic form search result display field 50203: Electronic form page narrowing setting field 5021: Designated form search item Electronic form search request 5022: electronic form search result 5023: specified electronic form page narrowing request specifying a narrowing page 5030: electronic form collation screen 50301: collation content setting screen 503011: collation formula group setting field 503012: collation target electronic form 1 setting tab 503013: collation target electronic form 2 setting tab 503014: collation target electronic form selection column 503015: form layout definition preview 503016: collation calculation formula setting column 503017: collation calculation formula list 503018: collation judgment Item setting field 503019: “Transition page correspondence setting screen transition” button 50302: Collation page correspondence setting screen 503021: Collation page setting field 503022: Collation page correspondence list 503023: “Start electronic document collation process” button 5031: Collation data range, collation Electronic form collation request specifying calculation formula, collation judgment condition, collation page correspondence, etc. 50311: Collation content setting including collation data range, collation calculation formula, collation judgment condition 50312: Collation page correspondence setting 5032: Electronic form collation result acquisition request 5033: Electronic form verification result 6000: Server PC
6010: Electronic form creation processing and registration processing program 60101: Form layout definition read processing step 60102: Electronic form creation processing step 60103: Electronic form page configuration information storage processing step 60104: Electronic form temporary registration processing step 601040: Electronic form temporary registration area 601041: Electronic form sheet with form layout definition sheet in the electronic form temporary registration area 60105: Electronic form registration instruction information reading processing step 60106: Electronic form main registration processing step 60107: Electronic form registration information storage processing step 6020: For electronic form creation Form layout definition 6030: Electronic form registration instruction information 6040: Electronic form registration directory sorted for each registered form search item 6041: Registered with form layout definition Electronic form 6050: Electronic form search processing program 60501: Electronic form search processing step 6060: Electronic form page narrowing processing program 60601: Designated electronic form reading processing step 60602: Electronic form page narrowing processing step 6070: Page narrowed electronic form output directory 6071 : Electronic form collation processing program 60801: Electronic form collation processing main loop 60802: Electronic form designation page acquisition processing step 60803: Electronic form collation calculation processing step 60804: Electronic form collation processing program 60801: Electronic form collation processing main loop 60802 Collation processing step 60805: Electronic form collation result comprehensive information registration processing step 6090: Electronic form collation result 6091: Electronic form collation result general information 6 092: Electronic form collation result [true] information group in electronic form collation result 60921: Electronic form collation result [true] electronic form collation result [true] general information in information group 609211: Specification example of value collation in embodiment 60922 : Electronic form collation result [true] Electronic form collation result [true] detailed information 6093: electronic form collation result [false] information group in electronic form collation result 60931: electronic form collation result [false] information group Electronic form verification result [false] general information 60932: electronic form verification result [false] electronic form verification result [false] detailed information in information group 6100: electronic form verification result acquisition program 6500: database management system 6510: electronic form creation Database 6511: form management table 6512: page / row / column classification table 6513: form data table 6520: page configuration information and electronic form registration information database 6521: page configuration information database 65210: page configuration information table 6522: electronic form registration information database 65220: electronic form registration information table

Claims (9)

Electronic form creation means for inputting electronic form creation information and electronic form creation form layout definition according to the form user's electronic form creation instruction, and outputting a combination of electronic form, form layout definition, and electronic form page configuration information An electronic form creation device comprising:
According to the electronic form registration instruction information arbitrarily set within the range that can be set by the form user, the electronic form output by the first means is registered separately in the electronic form registration directory for each registered form search item, The registration status of registered electronic forms is recorded as electronic form registration information, and is managed as an electronic form search information group in combination with the form layout definition and electronic form page configuration information output by the electronic form creation device. An electronic form registration device comprising electronic form registration means;
In accordance with an electronic form search instruction issued when a form user refers to the electronic form search information group and arbitrarily inputs a form search condition regarding the electronic form registration information within a settable range, the form search condition An electronic form registration information acquisition unit that outputs electronic form registration information related to a registered electronic form that matches the electronic form as an electronic form search result, and a form user can set the electronic form listed in the electronic form search result The electronic form search information group and the electronic form registration directory in accordance with a designated electronic form search instruction issued by inputting page narrowing conditions related to electronic form page configuration information of the electronic form search information group arbitrarily in a range The designated registered electronic form is input, and the designated registered electronic form is narrowed down to a page that matches the page narrowing condition. The electronic form search is made up of electronic form page narrowing means that combines the form layout definition and electronic form page configuration information related to the specified form and manages it as an electronic form collation information group. Equipment,
According to the electronic form collation instruction issued by the form user referring to the electronic form collation information group and arbitrarily entering the electronic form description data collation setting for the page narrowed electronic form within a configurable range, Cases where the description data of the page-squeezed electronic form is collated, and the electronic form collation result comprehensive information related to the electronic form collation and the collation result match the collation judgment condition of the electronic form description data collation setting (hereinafter, the case Is referred to as the case of the verification result [true], and the verification result is referred to as the verification result [true]) and the electronic form verification result [true] general information and the electronic form verification result [true] detailed information (the electronic document verification result [ True] Comprehensive information and electronic form collation result [true] Detailed information are combined into electronic form collation result [true] information group), and the collation result is data collation setting for electronic form description Electronic form collation result [false] general information and electronic form related to a case that does not meet the collation judgment condition (hereinafter, the case is referred to as a collation result [false] case, and the collation result is referred to as a collation result [false]). The combination of the collation result [false] detailed information (the electronic form collation result [false] general information and the electronic form collation result [false] detailed information are combined into an electronic form collation result [false] information group) An electronic form management system comprising an electronic form collation device comprising electronic form collation means for outputting as a form collation result.   2. The electronic form management system according to claim 1, wherein the registration status includes a file registration location, a registration date, or a registrant.   The electronic form description data collation setting is a setting of a position of data used for collation, a calculation formula of a value used for collation, a relational operator used for collation determination conditions, a combination of pages to be collated, and the like. The electronic form management system according to 1. Electronic form creation step that inputs electronic form creation information and electronic form creation form layout definition according to the form user's electronic form creation instruction, and outputs a combination of electronic form, form layout definition, and electronic form page configuration information When,
According to the electronic form registration instruction information arbitrarily preset within the range that can be set by the form user, the electronic form output by the electronic form creation step is registered separately in the electronic form registration directory for each registered form search item, The registration status of registered electronic forms is recorded as electronic form registration information, and is managed as an electronic form search information group in combination with the form layout definition and electronic form page configuration information output by the electronic form creation device. Electronic form registration step,
In accordance with an electronic form search instruction issued when a form user refers to the electronic form search information group and arbitrarily inputs a form search condition regarding the electronic form registration information within a settable range, the form search condition An electronic form registration information acquisition step for outputting electronic form registration information related to a registered electronic form that matches the electronic form as an electronic form search result, and a form user can set for the electronic form listed in the electronic form search result The electronic form search information group and the electronic form registration directory in accordance with a designated electronic form search instruction issued by inputting page narrowing conditions related to electronic form page configuration information of the electronic form search information group arbitrarily in a range The specified registered electronic form is input, and the specified registered electronic form matches the page filtering condition. A step outputs the already electronic form narrowing page, combined pairs of the form layout definition and electronic form page configuration information relating to the specified form, narrowing the electronic document page is managed as electronic form verification information group by refine,
According to the electronic form collation instruction issued by the form user referring to the electronic form collation information group and arbitrarily entering the electronic form description data collation setting for the page narrowed electronic form within a configurable range, Cases where the description data of the page-squeezed electronic form is collated, and the electronic form collation result comprehensive information related to the electronic form collation and the collation result match the collation judgment condition of the electronic form description data collation setting (hereinafter, the case Is referred to as the case of the verification result [true], and the verification result is referred to as the verification result [true]) and the electronic form verification result [true] general information and the electronic form verification result [true] detailed information (the electronic document verification result [ True] Comprehensive information and electronic form collation result [true] Detailed information are combined into electronic form collation result [true] information group), and the collation result is data collation setting for electronic form description Electronic form collation result [false] general information and electronic form related to a case that does not meet the collation judgment condition (hereinafter, the case is referred to as a collation result [false] case, and the collation result is referred to as a collation result [false]). The combination of the collation result [false] detailed information (the electronic form collation result [false] general information and the electronic form collation result [false] detailed information are combined into an electronic form collation result [false] information group) An electronic form management method comprising: an electronic form collation step for outputting as a form collation result.   5. The electronic form management method according to claim 4, wherein the registration status includes a file registration location, a registration date, or a registrant.   The electronic form description data collation setting is a setting of a position of data used for collation, a calculation formula of a value used for collation, a relational operator used for collation determination conditions, a combination of pages to be collated, and the like. 4. The electronic form management method according to 4. Computer
Electronic form creation means for inputting electronic form creation information and electronic form creation form layout definition according to the form user's electronic form creation instruction, and outputting a combination of electronic form, form layout definition, and electronic form page configuration information When,
According to the electronic form registration instruction information arbitrarily set within the range that can be set by the form user, the electronic form output by the first means is registered separately in the electronic form registration directory for each registered form search item, The registration status of registered electronic forms is recorded as electronic form registration information, and is managed as an electronic form search information group together with the form layout definition and electronic form page configuration information output by the electronic form creation means. Electronic form registration means,
In accordance with an electronic form search instruction issued when a form user refers to the electronic form search information group and arbitrarily inputs a form search condition regarding the electronic form registration information within a settable range, the form search condition An electronic form registration information acquisition unit that outputs electronic form registration information related to a registered electronic form that matches the electronic form as an electronic form search result, and a form user can set the electronic form listed in the electronic form search result The electronic form search information group and the electronic form registration directory in accordance with a designated electronic form search instruction issued by inputting page narrowing conditions related to electronic form page configuration information of the electronic form search information group arbitrarily in a range The designated registered electronic form is input, and the designated registered electronic form is narrowed down to a page that matches the page narrowing condition. Outputs already electronic form narrowing page by writing, together pairs of the form layout definition and electronic form page configuration information relating to the specified form, means narrowing electronic document page is managed as electronic form verification information group,
According to the electronic form collation instruction issued by the form user referring to the electronic form collation information group and arbitrarily entering the electronic form description data collation setting for the page narrowed electronic form within a configurable range, Cases where the description data of the page-squeezed electronic form is collated, and the electronic form collation result comprehensive information related to the electronic form collation and the collation result match the collation judgment condition of the electronic form description data collation setting (hereinafter, the case Is referred to as the case of the verification result [true], and the verification result is referred to as the verification result [true]) and the electronic form verification result [true] general information and the electronic form verification result [true] detailed information (the electronic document verification result [ True] Comprehensive information and electronic form collation result [true] Detailed information are combined into electronic form collation result [true] information group), and the collation result is data collation setting for electronic form description Electronic form collation result [false] general information and electronic form related to a case that does not meet the collation judgment condition (hereinafter, the case is referred to as a collation result [false] case, and the collation result is referred to as a collation result [false]). The combination of the collation result [false] detailed information (the electronic form collation result [false] general information and the electronic form collation result [false] detailed information are combined into an electronic form collation result [false] information group) An electronic form management program for functioning as an electronic form collation means for outputting as a form collation result.   8. The electronic form management program according to claim 7, wherein the registration status includes a file registration location, a registration date, or a registrant.   The electronic form description data collation setting is a setting of a position of data used for collation, a calculation formula of a value used for collation, a relational operator used for collation determination conditions, a combination of pages to be collated, and the like. 7. Electronic form management program according to 7.

Images