JP2011043930A - System, server device, apparatus and method for processing business form, and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To solve the problem that it is not possible for a user to easily operate the template information of a business form in a conventional business form processing system. <P>SOLUTION: A business form processing server device 10 includes: a data-for-arrangement detection part 104 for acquiring the data for arrangement of received acquisition condition information from a data storage part 102; a business form data creation part 105 for duplicating template information corresponding to received template identification information, and for replacing the data designation information of the duplicated template information with data for arrangement designated by data designation information among the data for arrangement obtained by the data-for-arrangement detection part 104 to create business form data; and a server side transmission part 106 for transmitting the business form data to a business form output client device 20. The business form output client device 20 includes an output part 205 for outputting the business form data received by a client side reception part 203. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a form processing system that creates and outputs a form.

  Conventionally, a form processing apparatus that acquires data based on a form template set including data acquisition conditions for generating form data and generates form data has been known. (For example, refer to Patent Document 1).

JP 2007-283646 A (first page, FIG. 1 etc.)

  However, in the conventional form processing system, the form template is information in a form unique to the form processing system, which is different from the form that is finally output to the user or the like. In order to edit or edit a template, knowledge of the template description format is required, so that only engineers can create and edit templates. There is a problem that the user who is trying to output cannot easily create or change a template, and is unusable.

  The form processing system of the present invention is a form processing system provided with a form processing server device and a form output client device, and the form processing server device is information indicating a template of the form, and data arranged in the template Template information storage unit that can store the template information that is the information having the data specifying information that is the information for specifying the template information and the template identification information that is the information for identifying the template information, and the template indicated by the template information Server side that receives data storage unit that can store placement data, which can be placed, and template identification information and acquisition condition information that is a condition for acquiring placement data from the form output client device From the data stored in the receiver and the data storage unit, The template data corresponding to the template identification information received by the server-side receiving unit and the placement data detecting unit that acquires the placement data that meets the conditions indicated by the acquisition condition information received by the server-side receiving unit are copied and copied. A form data creation unit that creates form data by replacing the data designation information included in the template information with the placement data designated by the data designation information from the placement data acquired by the placement data detection unit, and a form A server-side transmission unit that transmits the form data created by the data creation unit to the form output client device. The form output client device accepts the template identification information and the acquisition condition information; A client-side transmission unit that transmits the template identification information and the acquisition condition information to the form processing server device, and a form And a client side receiving section for receiving form data transmitted from the management server, a form processing system comprising an output unit that outputs the form data which the client-side receiving unit receives.

  With this configuration, by creating form data using a copy of the template information, the template information used for creating the form and the form data created using the template information are in the same file format, so the user can create the form data. The template information can be easily manipulated.

  In the form processing system of the present invention, in the form processing system, the template information further includes an arithmetic expression or an execution module that uses arrangement data designated by the data designation information, and the form data creation unit includes: Replaces the data specification information corresponding to the arithmetic expression or the execution module with the placement data specified by the data specification information from the placement data acquired by the placement data detection unit, creates form data, and outputs the form The client device executes the arithmetic processing or execution module using the arithmetic expression included in the form data received by the client-side receiving unit, using the placement data in which the data designation information corresponding to the arithmetic expression or the execution module is replaced. The execution unit further includes an execution unit, and the output unit executes the execution unit on the form data received by the client side reception unit. It is a form processing system for outputting the document data obtained by adding the information of the results.

  With such a configuration, it is possible to automatically execute calculations and modules using data arranged in the form using the calculation formulas and execution modules specified in the template information.

  In the form processing system of the present invention, in the form processing system, the template information is information on a spreadsheet having one or more sheets, and the data designation information is arranged in a cell of the spreadsheet. The creation unit duplicates the template information corresponding to the template identification information received by the server side reception unit, and the placement data detection unit displays the data designation information placed in each spreadsheet cell indicated by the duplicated template information. This is a form processing system that creates form data having a plurality of sheets by replacing the obtained placement data with the placement data designated by the data designation information.

  With this configuration, form data composed of a plurality of spreadsheets can be created using template information composed of a plurality of spreadsheets.

  In the form processing system of the present invention, in the form processing system, the template information is information having a plurality of pages, and the form data creation unit is template information corresponding to the template identification information received by the server-side receiving unit. And the data specification information placed on each page indicated by the duplicated template information is replaced with the placement data specified by the data specification information from the placement data acquired by the placement data detection unit. This is a form processing system for creating form data having a plurality of pages.

  With this configuration, it is possible to create form data of a plurality of pages using a plurality of pages of template information.

  In the form processing system according to the present invention, in the form processing system, the template information has two or more pieces of the same data designation information in one sheet or page, and the form data creation unit has two or more pieces of common data. When the different layout data specified by the specified information is replaced with the common data specification information and all of the different layout data cannot be placed, the single sheet or page is duplicated, and the duplicated sheet or page data This is a form processing system that arranges the remaining arrangement data that could not be arranged with different arrangement data in place of the designation information.

  With this configuration, it is possible to create form data by adding form pages and sheets according to the number of arrangement data. As a result, for example, a single form can be appropriately created by appropriately increasing pages and sheets according to the number of data.

  In the form processing system of the present invention, in the form processing system, the template information specifies data designation information to be replaced with a plurality of pieces of placement data when there are a plurality of pieces of one or more pieces of placement data to be designated. Repeat designation information that is information to be performed, and single designation information that is information that designates data designation information that is replaced once with the designated placement data, and the form data creation unit includes the single designation information. For the data specification information specified by, the data specification information specified by the repeat specification information replaces the data specification information with the placement data specified by the data specification information from the placement data acquired by the placement data detection unit. Is one or more pieces of placement data designated by the data designation information in the placement data acquired by the placement data detection unit, It is a form processing system for creating form data by replacing over data specifying information.

  With this configuration, the form data can be created by increasing the area where the placement data is placed so that the placement data is placed according to the number of placement data. As a result, for example, a continuous form can be appropriately created by adding an area where data is arranged according to the number of data.

  In the form processing system according to the present invention, in the form processing system, the template information is replaced with a plurality of pieces of arrangement data when one or more pieces of arrangement data specified in one sheet or page are plural. Further comprising: repeat designation information for designating designated data designation information; and single designation information for designating data designation information to be replaced and arranged only once in one sheet or page with designated layout data. The data creation unit replaces the data designation information designated by the single designation information with the arrangement data designated by the data designation information among the arrangement data acquired by the arrangement data detection unit, and the data designated by the repeat designation information One or more pieces of placement data designated by the data designation information in the placement data acquired by the placement data detection unit. If the placement data specified by the data specification information specified by the repeat specification information exceeds a predetermined number, one sheet or page is duplicated, and with the placement data exceeding the predetermined number, the duplicated sheet or page This is a form processing system that replaces data designation information designated by repeat designation information.

  With this configuration, it is possible to appropriately increase the number of pages and sheets of a form when arranging a predetermined number or more of arrangement data. Thereby, for example, when creating a continuous slip form, if the data does not fit in one spreadsheet or page, a spreadsheet or page can be added as appropriate.

  In the form processing system of the present invention, in the form processing system, the template information includes exclusion information that is information for designating sheets or pages that are not to be replaced by the placement data, and the form data creation unit Is a form processing system that does not perform replacement by arrangement data of sheets or pages specified by exclusion information.

  With this configuration, a portion of the template information that does not need to be replaced with the placement data can be designated in units of pages or spreadsheets, and can be prevented from being replaced with the placement data.

  Also, the form processing server device of the present invention identifies template information and template information that is information indicating a template of the form and is information having data designation information that is information for designating data arranged in the template. A template information storage unit that can be stored in association with template identification information that is information, a data storage unit that can store placement data that can be placed in a template indicated by the template information, and a form output client device The server-side receiving unit receives the template identification information and the acquisition condition information that is information indicating the conditions for acquiring the placement data, and the server-side receiving unit receives the data stored in the data storage unit. An arrangement data detection unit that acquires arrangement data that meets the conditions indicated by the acquired acquisition condition information; The template information corresponding to the template identification information received by the server-side receiving unit is duplicated, and the data designation information of the arrangement data acquired by the arrangement data detection unit is designated by the data designation information included in the duplicated template information. Form processing server device comprising: a form data creation unit that creates form data by replacing with placement data to be created; and a server-side transmission unit that sends the form data created by the form data creation unit to the form output client device It is.

  With this configuration, by creating form data using a copy of the template information, the template information used for creating the form and the form data created using the template information are in the same file format, so the user can create the form data. The template information can be easily manipulated.

  In addition, the form processing apparatus of the present invention is information indicating a template of a form, and is information for identifying template information, which is information having data designation information that is information for designating data arranged in the template, and information for identifying the template information A template information storage unit that can be stored in association with the template identification information, a data storage unit that can store placement data that is data that can be placed in the template indicated by the template information, template identification information, placement A receiving unit that receives acquisition condition information that is information indicating a condition for acquiring data for use, and arrangement data that matches the conditions indicated by the acquisition condition information received by the receiving unit among the data stored in the data storage unit Corresponding to the template identification information received by the placement data detecting unit and the receiving unit. Duplicate template information and create form data by replacing the data specification information contained in the duplicated template information with the placement data specified by the data specification information from the placement data acquired by the placement data detector. The form processing apparatus includes a form data creation unit that performs and an output unit that outputs the form data created by the form data creation unit.

  With this configuration, by creating form data using a copy of the template information, the template information used for creating the form and the form data created using the template information are in the same file format, so the user can create the form data. The template information can be easily manipulated.

  According to the form processing system and the like according to the present invention, a user can easily operate form template information.

Block diagram of a form processing system according to an embodiment of the present invention The flowchart explaining operation | movement of the form processing server apparatus of the form processing system A flowchart for explaining the operation of the form output client device of the form processing system Conceptual diagram of the form processing system The figure which shows the template information management table for demonstrating operation | movement of the form processing system The figure which shows the table management table which manages the data for arrangement | positioning for demonstrating operation | movement of the form processing system The figure which shows the specific content of the table which manages the data for arrangement | positioning for demonstrating operation | movement of the form processing system The figure which shows the management table which manages the record which the arrangement | positioning data detection part 104 for demonstrating operation | movement of the form processing system The figure which shows the specific content of template information for demonstrating operation | movement of the form processing system Diagram showing the form data in spreadsheet format for explaining the operation of the form processing system The figure which shows the example of form data for demonstrating operation | movement of the form processing system The figure which shows an example of template information for demonstrating operation | movement of the form processing system The figure which shows the output example of the form data of the form processing system The figure which shows the specific example of the template information for demonstrating operation | movement of the form processing system The figure which shows the output example of the form data of the form processing system The figure which shows the example of a display of the form data of the form processing system Block diagram of the form processing device The figure which shows an example of the external appearance of the computer system in the embodiment The figure which shows an example of a structure of the computer system in the embodiment

  Hereinafter, embodiments of a form processing system and the like will be described with reference to the drawings. In addition, since the component which attached | subjected the same code | symbol in embodiment performs the same operation | movement, description may be abbreviate | omitted again.

(Embodiment)
FIG. 1 is a block diagram of a form processing system 1 in the present embodiment.
The form processing system 1 includes a form processing server apparatus 10 and a form output client apparatus 20.

  The form processing server apparatus 10 includes a template information storage unit 101, a data storage unit 102, a server side receiving unit 103, an arrangement data detecting unit 104, a form data creating unit 105, a server side transmitting unit 106, and a template receiving unit 107. .

  The form output client device 20 includes a reception unit 201, a client side transmission unit 202, a client side reception unit 203, an execution unit 204, an output unit 205, an editing operation reception unit 206, a template editing unit 207, and a template transmission unit 208.

  The form processing server device 10 and the form output client device 20 are connected so that information can be transmitted and received via a communication line, a network, and the like. The network is, for example, a network such as the Internet or a wireless or wired LAN. However, the connection method between each apparatus is not ask | required. The information transmission / reception means may be a communication means or a broadcasting means. Moreover, the protocol used for communication is not ask | required. A plurality of form output client devices 20 may be connected to one form processing server device 10.

  The form processing server apparatus 10 is a server apparatus that creates a form according to information transmitted from the form output client apparatus 20 and transmits the created form to the form output client apparatus 20. The form processing server device 10 is a server device capable of transmitting form information to the form output client device 20 via, for example, a network. The form processing server device 10 is, for example, a data server or a WEB server.

  The form output client device 20 can be connected to a network, for example, and sends information specifying a template of the form to the form processing server device 10 or is sent from the form processing server device 10. It is a device that can receive the information. The form output client device 20 is, for example, a computer, a mobile phone, or a PDA. In FIG. 1, for convenience of explanation, the case where there is one form output client device 20 is described, but there may be a plurality of form output client devices 20.

  The template information storage unit 101 is information indicating a template of a form, and is information for identifying template information and template information that is information having data specification information that is information for specifying data arranged in the template. Template identification information can be stored in association with each other.

  The form is, for example, a book or a slip. The form described here may be printed on paper or the like, or may be an electronic form displayed on a monitor screen or the like. An input form or the like for inputting form data may be considered as a form. Specifically, the book is a table in which necessary information regarding transactions and the like is entered, for example, the movement of money, deposits, goods, and the like. The slip is filled with information for notifying the contents of the transaction or the like. Usually, the book has a fixed format according to the intended use and the destination. The form may be interpreted as a data group having a predetermined layout.

  A template is a so-called template. The template information may be considered as template information. Here, a so-called style file may be considered as template information. The template information described here may be specifically interpreted as a template information file. The template information may have a plurality of pages and a plurality of sheets. The sheet described here means a spreadsheet sheet or the like to be described later. The form template information is information including data designation information that is information for designating data to be arranged in the form, and information that designates the size of the form, the appearance of the form, and the like. The information that specifies the appearance of the form is, for example, the area where the data to be placed on the form is placed, the placement position of coordinates, cells, etc., the format information that specifies the format of the placed data, such as color and size, etc. It is information including. The template information includes information such as ruled lines, figures, and character strings prepared in advance, and these ruled lines, figures, and character strings may be arranged on the template. In the present embodiment, the data format of the template information does not matter. In the present embodiment, as will be described later, form data is created by replacing a part of the copy of the template information, so that the form information is the form output client device 20 like spreadsheet data. In this case, it is preferable that the data can be operated by the user who outputs the form data. The template information is information that can specify the position of data arranged in the template, such as a spreadsheet, and the specification of the position is easy data for the user of the form output client device 20. preferable. A spreadsheet is data composed of one or more sheets in which a plurality of data arrangement areas called cells in which information can be arranged are arranged on a matrix. In a spreadsheet, a table or the like can be created efficiently, and convenience is high in a form that frequently uses a table or the like. In addition, since it is possible to perform a calculation specified in advance using data arranged in a cell of a spreadsheet, it is possible to execute a calculation on a form. Furthermore, it is possible to display a graph or the like as appropriate in a form by operating a pre-designated execution module or the like using data arranged in a spreadsheet cell. For this reason, in this embodiment, a case where the template information is a so-called spreadsheet will be described as an example.

  The template identification information may be any information as long as the information can identify the template. The template identification information is, for example, a template name, a template information file name, an identification symbol assigned to the template information, or the like. The template identification information may be a combination of a template creation date or an update date, a template creator, an updater name, an identification number, or the like. The template identification information may be information such as an address where template information such as a URL is stored.

  In the template information storage unit 101, the template information and the template identification information may be stored in direct association with each other, or may be stored in association with each other indirectly. Indirect association is, for example, that identification information corresponding to each is associated, for example, that identification information corresponding to each is associated, or one information And the identification information of the other information are associated with each other. Further, the template information and the template identification information may be physically stored in the same storage medium. However, when the template information storage unit 101 is configured by physically different storage media, the template information and the template identification information are stored in the respective storage media. Template information and template identification information may be stored separately. In addition, for example, template information and template identification information are management information that manages a set of template information and template identification information associated with the template information as a plurality of items of one record. It may be managed. This management information may be stored in, for example, the template information storage unit 101 or a storage unit (not shown). This also applies to two or more pieces of information stored in association with each other in other storage units.

  The template information has one or more data designation information that designates data arranged in the template indicated by the template information. The data designation information included in one template information is data that can designate data that can be arranged in the template, such as data stored in the data storage unit 102, for example. Data that can be arranged in a template is referred to herein as arrangement data. The data designation information may be data that can designate data other than data stored in the data storage unit 102. For example, it may be information that specifies information such as search character strings included in information that is specified in advance or a query that is used to search for placement data. The data designation information may be information that can designate data arranged in the template. For example, it may be information that specifies identification information associated with data to be arranged. In addition, when the data is information managed in units of records by a database or the like, the data may be information specifying data attributes, data items, and the like arranged in the template. When the data that can be arranged in the template is data with a tag, it may be information that specifies the tag of the data arranged in the template. Moreover, the information which designates the keyword etc. which the data arrange | positioned at a template have may be sufficient. The data designation information may be considered as a search key, a search condition, or the like. The data designation information may be a combination of the data attribute and the record number of the data table or view. One data designation information is not necessarily data that can designate only one data, and may be data that can designate a plurality of data. The template information may include a search condition such as a search keyword for designating the placement data separately from the data designation information. In this case, for example, the placement data detection unit 104 described later, The form data creation unit 105 or the like may use this search condition to narrow down by searching the layout data.

  The data designation information is arranged at a position where data designated by the data designation information is arranged, such as a template page or a spreadsheet indicated by the template information. For example, when the template indicated by the template information is a spreadsheet template, the data designation information is arranged in a cell in which data designated by the data designation information is arranged. In this case, this cell is a position where data designated by the data designation information is arranged. For example, the form data creation unit 105 described later replaces the data designation information arranged on the template indicated by the template information with the data designated by the data designation information, so that the data designated by the data designation information is changed to the user It is possible to generate a form arranged at a desired position designated by, for example. Note that the data designation information is information that designates an item of arrangement data included in the arrangement data record acquired by the arrangement data detection unit 104, which will be described later, by using acquisition condition information such as a query. May be.

  The template information may further include an arithmetic expression or an execution module that uses the placement data specified by the data specification information included in the template information. For example, in order to designate arrangement data used as a parameter, an arithmetic expression using data designation information may be provided. In this case, at the time of creating or outputting a form, the execution unit 204, which will be described later, performs calculation of an arithmetic expression using the placement data acquired using the data designation information. In addition, in order to designate the placement data used in the execution module, an execution module using the data designation information may be provided. In this case, when the form is created or output, the execution module 204 is executed by the execution unit 204, which will be described later, using the placement data acquired using the data designation information. The arithmetic expression described here is, for example, an arithmetic expression obtained by combining four arithmetic operations using numerical arrangement data as parameters. For example, an arithmetic expression for calculating the sum of predetermined numerical values included in the form data. The execution module is, for example, an execution module that creates a graph using arrangement data that is a numerical value, or performs processing that uses arrangement data that is a character string as the title or legend of the graph. . For example, when the template information is a spreadsheet, the designation of data designation information for designating arrangement data used for an arithmetic expression or an execution module is performed in units of cells where the data designation information is arranged. When the template information is a spreadsheet, the above arithmetic expression may be an arithmetic expression specified for a spreadsheet cell. When the template information is a spreadsheet, the execution module may be considered as an execution module that creates a graph or the like using data of one or more cells of the spreadsheet.

  The template information may include exclusion information that is information for designating sheets or pages that are not to be replaced by the placement data. For example, this exclusion information is specified in advance, for example, in a predetermined character string assigned to the sheet name of the sheet indicated by the template information, or in a page header or page name indicated by the template information. A predetermined character string or the like. Alternatively, the exclusion information may be data such as a predetermined character string specified in advance included in the sheet or page indicated by the template information.

  The process in which the template information is stored in the template information storage unit 101 does not matter. For example, template information may be stored in the template information storage unit 101 via a recording medium, and template information transmitted from the form output client device 20 or the like via a communication line or the like is stored in the template information storage unit 101. Alternatively, template information input via the input device may be accumulated in the template information storage unit 101. The template information storage unit 101 is preferably a non-volatile recording medium, but can also be realized by a volatile recording medium.

  The data storage unit 102 can store placement data, which is data that can be placed in the template indicated by the template information. The arrangement data may be image data such as a moving image or a still image or character string data as long as it can be arranged in the template, and the format of the arranged data is not limited. The placement data may be managed by a plurality of databases, a plurality of tables, files, and the like. When arrangement data is managed in a database, table, file, or the like, for example, identification information such as a table name, a file name, or a URL may be associated with the database, table, file, or the like. preferable. The placement data is, for example, information stored in association with information indicating the attributes of the placement data or information indicating the items of the placement data. The arrangement data is information to which a tag is attached, for example. The arrangement data is information associated with data identification information that is information for identifying the arrangement data, for example. The placement data is stored in the data storage unit 102 in association with these pieces of information, for example. The process of storing the placement data in the data storage unit 102 does not matter. The data storage unit 102 is preferably a non-volatile recording medium, but can also be realized by a volatile recording medium.

  The server-side receiving unit 103 receives template identification information and acquisition condition information, which is information indicating a condition for acquiring arrangement data, transmitted from the form output client device 20 via a communication line or the like. As described above, the template identification information is usually the same as any of the template identification information stored in the template information storage unit 101 in association with the template information. The template identification information received here may be considered as information for specifying the template information. The acquisition condition information is, for example, a search condition. The acquisition condition information may be information capable of detecting a plurality of data. The acquisition condition information is information specifying a query or a query stored in advance in a storage unit (not shown), for example. The acquisition condition information may be, for example, information indicating one or more conditions that can narrow down the arrangement data that is candidates for acquisition from the arrangement data stored in the data storage unit 102. For example, the acquisition condition information is information that specifies a database, a table, a file, or the like in which arrangement data to be acquired is managed. Specifically, the information to be specified is identification information such as a database, a table, or a file. Further, the acquisition condition information may be information for designating attributes and items of the placement data. Further, it may be one or more search conditions for searching the contents of the placement data, for example, a search character string. The server-side receiving unit 103 also receives information such as an IP address and a MAC address that can normally identify the source form output client device 20. The server-side receiving unit 103 is usually realized by a wireless or wired communication means, but may be realized by a means for receiving a broadcast.

  The arrangement data detection unit 104 detects and acquires one or more arrangement data that matches the condition indicated by the acquisition condition information received by the server-side receiving unit 103 from the data stored in the data storage unit 102. . For example, when the acquisition condition information is information specifying a query or a query stored in a storage medium (not shown), the placement data detection unit 104 extracts the placement data corresponding to the query, that is, the query. Get the placement data. For example, when the placement data is managed in units of records by a database or the like, the placement data detection unit 104 may acquire one or more records corresponding to the query. In addition, for example, when the acquisition condition information is identification information that specifies a database, table, file, or the like in which arrangement data to be acquired is managed, an arrangement associated with identification information that matches the identification information Get data database, table, file etc. Further, when the acquisition condition information is information for designating the attribute or item of the placement data, the placement data associated with the attribute or item is detected and obtained. Further, when the acquisition condition information is one or more search conditions for searching the contents of the arrangement data, for example, a search character string, the arrangement data that matches the search conditions is acquired. The match here may be a complete match or a partial match. The placement data detection unit 104 may read the detected one or more placement data and temporarily store it in a storage medium such as a memory or a hard disk.

  The arrangement data detection unit 104 can be usually realized by an MPU, a memory, or the like. The processing procedure of the arrangement data detection unit 104 is usually realized by software, and the software is recorded in a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The form data creation unit 105 duplicates the template information corresponding to the template identification information received by the server side receiving unit 103, and the placement data detection unit 104 acquires the data designation information included in the duplicated template information. Of these, the data is replaced with the arrangement data specified by the data specification information, and form data is created.

  Specifically, the form data creation unit 105 first duplicates template information corresponding to the template identification information. This duplication may be a duplication to a non-illustrated non-volatile storage medium such as a hard disk or a duplication to a volatile storage medium such as a memory (not shown). In the case of copying to a non-volatile storage medium, it is preferable to rewrite the file name of the template information according to a rule or the like specified in advance at the time of copying. The predesignated rule is, for example, a rule that replaces with a predesignated file name, adds a predesignated character string or the like before or after the file name, or deletes it. The character string designated in advance may be changed according to a rule designated in advance depending on a situation to be created, a situation of template information, or the like, such as a date. The form data creation unit 105 opens, for example, a template arranged in the duplicated template information, sequentially acquires data designation information arranged in the duplicated template, and arrangement data designated by the data designation information Is acquired from the arrangement data acquired by the arrangement data detection unit 104. There is no limitation on the order or the like when acquiring sequentially, but the order is usually acquired from the top. For example, the form data creation unit 105 designates the placement data having the attribute designated by the data designation information or the data designation information from one or more records including the placement data acquired by the placement data detection unit 104. Get the placement data belonging to the item. Or you may acquire the data designation | designated information with the tag corresponding to the tag which data designation | designated information shows. Further, arrangement data including a keyword designated by the data designation information may be acquired. Then, the form data creation unit 105 replaces the data designation information arranged in the copied template information with the arrangement data acquired using the data designation information. If the above-mentioned hard disk copy is a copy to a volatile storage medium, the copy of the template information on the storage medium in which the data designation information is replaced with the placement data is performed according to the same rules as described above. The file name may be rewritten and stored in a non-illustrated nonvolatile storage medium such as a hard disk. The copy of the template information created by being replaced with the placement data in this way is data in the same format as the template information as a result. A copy of the template information replaced in this way is referred to herein as form data.

  The details of the replacement process using the placement data performed on the data specification information for copying the template information may differ depending on the template information, for example. A specific example of the replacement of the placement data will be described later.

  In addition, after acquiring all the arrangement data corresponding to all the data designation information of the duplicated template information, all the data designation information of the duplicated template information may be replaced with the obtained arrangement data. Each time the placement data corresponding to one piece of data designation information is acquired, this one piece of data designation information may be replaced with the obtained placement data. Note that the replacement described here may be a process in which the data designation information is eventually replaced with the placement data. For example, the existing data designation information may be overwritten with the placement data. Alternatively, after deleting the existing data designation information, it may be arranged at the position where the arrangement data is deleted.

  Note that the form data creation unit 105 also designates the data designation information corresponding to the arithmetic expression or the execution module by the data designation information in the placement data acquired by the placement data detection unit 104 as described above. Replace with placement data.

  For example, when the template information corresponding to the template identification information received by the server-side receiving unit 103 is the template information of a spreadsheet composed of a plurality of sheets, the form data creation unit 105 performs the above processing on a plurality of items. Execute for each sheet. Specifically, the form data creation unit 105 duplicates the template information, and the placement data detection unit 104 acquires the data designation information placed in each spreadsheet cell indicated by the duplicated template information. By replacing the layout data with the layout data specified by the data specification information, the form data having a plurality of sheets is created.

  Further, for example, when the template information corresponding to the template identification information received by the server-side receiving unit 103 is template information composed of a plurality of pages, the form data creation unit 105 performs the above processing for a plurality of pages. Run each one. Specifically, the form data creation unit 105 duplicates the template information, and the data designation information arranged on each page indicated by the duplicated template information is used for the placement data acquired by the placement data detection unit 104. Of these, it replaces with the arrangement data designated by the data designation information, and forms data having a plurality of pages is created.

  However, the form data creation unit 105 detects whether or not the exclusion information is included in the sheet or page in the template information copy when replacing the template information copy, and the exclusion information is included in the sheet or page. If it is included, the replacement by the layout data of the sheet or page specified by the exclusion information is not performed. That is, the template information sheet or page indicated by the exclusion information may be excluded from the replacement process target and simply copied.

  The form data creation unit 105 can usually be realized by an MPU, a memory, or the like. The processing procedure of the form data creation unit 105 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The server-side transmitting unit 106 transmits the form data created by the form data creating unit 105 to the form output client device 20. When there are a plurality of form output client devices 20, for example, the created form data is transmitted to the form output client device 20 that is the transmission source of the template identification information and the acquisition condition information received by the server-side receiving unit 103. . The source form output client device 20 of the transmission source can be specified by using an IP address, a MAC address, or the like for identifying the transmission source received by the server side receiving unit 103. The server-side transmitting unit 106 is usually realized by a wireless or wired communication unit, but may be realized by a broadcasting unit.

  The template receiving unit 107 receives the template information associated with the template identification information transmitted from the form output client device 20. The template receiving unit 107 stores the received template information and template identification information in the template information storage unit 101 in association with each other. The template receiving unit 107 is usually realized by a wireless or wired communication means, but may be realized by a means for receiving a broadcast.

  The reception unit 201 receives template identification information and acquisition condition information input from a user or the like. The input means for inputting the template identification information and the acquisition condition information may be anything such as a numeric keypad, a keyboard, a mouse, or a menu screen. The accepting unit 201 can be realized by a device driver for input means such as a numeric keypad or a keyboard, control software for a menu screen, and the like.

  The client side transmission unit 202 transmits the template identification information received by the reception unit 201 and the acquisition condition information to the form processing server device 10. The client-side transmitting unit 202 is usually realized by a wireless or wired communication unit, but may be realized by a broadcasting unit.

  The client side reception unit 203 receives form data transmitted from the form processing server. The received form data may be stored in a storage medium (not shown), for example. The client-side receiving unit 203 is usually realized by a wireless or wired communication means, but may be realized by a means for receiving a broadcast.

  The execution unit 204 opens the form data with application software that can handle the form data, and the arithmetic processing or execution module using the arithmetic expression included in the form data received by the client-side receiving unit 203 is changed to the arithmetic expression included in the form data. Alternatively, it is executed using the placement data in which the data designation information corresponding to the execution module is replaced. For example, the calculation is performed using the placement data that is the calculation target of the calculation formula in the form data. Then, the calculation result is acquired. Specifically, assuming that the form data is a spreadsheet, use the placement data placed in the cell specified as the calculation target of the calculation formula to perform the calculation indicated by the calculation formula and obtain the calculation result. To do. Alternatively, when the execution module is a module for creating a graph, a graph is created using data in a predesignated range in the form data. Specifically, assuming that the form data is a spreadsheet, a graph is created using arrangement data arranged in a cell designated in advance. The application software is stored in advance in a storage medium (not shown).

  The execution unit 204 can usually be realized by an MPU, a memory, or the like. The processing procedure of the execution unit 204 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The output unit 205 outputs the form data received by the client side receiving unit 203. For example, the output unit 205 outputs the received form data as it is. Further, the output unit 205 may open the form data using application software or the like that can handle the form data, and output the information of the opened form data. Note that the execution unit 204 may perform processing for opening the form data with application software. When the form data is a spreadsheet, application software that can handle the form data is, for example, so-called spreadsheet software. The information on the opened form data is, for example, form image data created using the form data. The output unit 205 outputs form data obtained by adding the execution result information of the execution unit 204 to the form data received by the client side reception unit 203. For example, the result of the arithmetic expression of the form data executed by the execution unit 204 may be configured and output as image data arranged in a predetermined position of the form data, such as a cell. Further, the execution result of the execution module included in the form data executed by the execution unit 204 may be configured and output as image data arranged in a predetermined position of the form data, for example, a cell. Specifically, image data in which a graph created by executing an execution module is arranged may be configured and output. The output described here refers to display on a display, projection using a projector, printing on a printer, sound output, transmission to an external device, storage on a recording medium, and output to other processing devices or other programs. It is a concept including delivery of processing results. The output unit 205 may or may not include an output device such as a display or a printer. The output unit 205 can be realized by output device driver software, or output device driver software and an output device.

  The editing operation reception unit 206 receives an operation instruction that is an operation instruction for the template information. The operation instruction is specifically an instruction to edit the template information. The editing described here is a concept that includes creating new template information. The operation instruction input means may be anything such as a numeric keypad, a keyboard, a mouse, or a menu screen. The editing operation accepting unit 206 can be realized by a device driver for input means such as a numeric keypad and a keyboard, control software for a menu screen, and the like.

  The template editing unit 207 edits the template information according to the operation instruction received by the editing operation receiving unit 206. For example, when the operation instruction is an instruction to newly create template information, the template information is newly created. When the operation instruction is an instruction to edit template information, editing according to the instruction, for example, rewriting is performed on existing template information or newly created template information. For example, when editing, the template editing unit 207 appropriately executes application software capable of handling template information. Template information to be edited and template information that has been edited or newly created is stored in a storage medium (not shown) such as a memory or a hard disk that is designated in advance.

  The template editing unit 207 can be usually realized by an MPU, a memory, or the like. The processing procedure of the template editing unit 207 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The template transmission unit 208 transmits the template information edited by the template editing unit 207 to the form processing server device 10. For example, the template information edited by the template editing unit 207 specified by the user or the like according to an instruction received by the receiving unit (not shown) or the editing operation receiving unit 206 is transmitted to the form processing server device 10. The template transmission unit 208 is usually realized by a wireless or wired communication unit, but may be realized by a broadcasting unit.

  Next, the operation of the form processing server apparatus 10 of the form processing system 1 will be described with reference to the flowchart of FIG.

  (Step S201) The server side receiving unit 103 determines whether or not the template identification information and the acquisition condition information transmitted from the form output client device 20 are received. If received, the process proceeds to step S206. If not received, the process proceeds to step S206.

  (Step S202) The placement data detection unit 104 acquires placement data corresponding to the acquisition condition information received in step S201 from the placement data stored in the data storage unit 102. For example, a record in which one or more pieces of placement data specified by the acquisition condition information are managed is detected and acquired in a database or management table that manages the placement data stored in the data storage unit 102.

  (Step S203) The form data creation unit 105 searches the template information stored in the template information storage unit 101 for template information associated with the template designation information that matches the template designation information received in step S201. To do. Then, the detected template information is duplicated. When duplicating, the file name of the template information may be renamed.

  (Step S204) The form data creation unit 105 obtains the placement data designated by the data designation information included in the template information copied in Step S203 from the placement data obtained in Step S202. For example, data for arrangement of items and attributes specified by the data specification information is acquired from the record acquired in step S202. Then, form data is created by replacing the data designation information designating the arrangement data with the obtained arrangement data. If there is finally data designation information that has not been replaced with the placement data, this data designation information is deleted from the template information copy.

  (Step S205) The server-side transmitting unit 106 transmits the form data created in step S204 to the form output client device 20. Then, the process returns to step S201.

  (Step S206) The template receiving unit 107 determines whether template information has been received from the form output client device 20. If received, the process proceeds to step S207. If not received, the process returns to step S201.

  (Step S207) The template receiving unit 107 accumulates the template information received in step S206 in the template information storage unit 101. Then, the process returns to step S201.

  In the flowchart of FIG. 2, the process is terminated by powering off or a process termination interrupt.

  Next, the operation of the form output client device 20 of the form processing system 1 will be described with reference to the flowchart of FIG.

  (Step S301) The receiving unit 201 determines whether template identification information and acquisition condition information have been received. If accepted, the process proceeds to step S302. If not accepted, the process proceeds to step S303.

  (Step S302) The client side transmission unit 202 transmits the template identification information and the acquisition condition information received in step S301 to the form processing server apparatus 10. Then, the process returns to step S301.

  (Step S303) The client side receiving unit 203 determines whether or not form data has been received. If received, the process proceeds to step S304. If not received, the process proceeds to step S309.

  (Step S304) The execution unit 204 opens the form data received in Step S303 with application software corresponding to the form data, and determines whether the form data includes an arithmetic expression. If included, the process proceeds to step S305. If not included, the process proceeds to step S306.

  (Step S305) The execution unit 204 executes a calculation using the calculation formula included in the form data, using the placement data in the form data specified by the calculation formula. The calculation result is temporarily stored in, for example, a storage medium (not shown).

  (Step S306) The execution unit 204 determines whether or not an execution module is included in the form data opened in step S304. If included, the process proceeds to step S307, and if not included, the process proceeds to step S308.

  (Step S307) The execution unit 204 executes the execution module included in the form data, using the placement data included in the form data. The execution result of the execution module is temporarily stored in, for example, a storage medium (not shown).

  (Step S308) The output unit 205 outputs the form data received in step S303. For example, the form data received in step S303 is opened using application software corresponding to the form data, and the image information of the form in which the calculation results and execution results obtained in steps S305 and S307 are arranged in the opened form data. The configured image information is displayed on a monitor (not shown) or printed from a printer (not shown). Then, the process returns to step S301.

  (Step S309) The editing operation reception unit 206 determines whether an editing operation for the template information has been received. The editing operation includes, for example, information specifying template information to be edited and information indicating editing contents. The editing operation may be considered to include an operation for creating new template information, for example. The editing operation may be considered as a process for outputting a command or the like according to the operation.

  (Step S310) The template editing unit 207 edits the template information in accordance with the editing operation accepted in step S309. The edited template information is stored in a storage medium (not shown). Then, the process returns to step S301.

  (Step S311) The template transmission unit 208 determines whether the editing operation reception unit 206 or the like has received an instruction to transmit template information stored in a storage medium (not shown) or the like. If accepted, the process proceeds to step S312. If not accepted, the process returns to step S301.

  (Step S312) The template transmission unit 208 transmits the template information designated by the instruction received in Step S311 to the form processing server device 10. Then, the process returns to step S301.

  In the flowchart of FIG. 3, the process ends when the power is turned off or the process is terminated.

  Hereinafter, a specific operation of the form processing system 1 in the present embodiment will be described. A conceptual diagram of the form processing system 1 is shown in FIG.

(Specific example 1)
In this specific example, a case will be described as an example where the template information has two or more pieces of the same data designation information on one sheet or page of the template indicated by the template information. The same data designation information described here may be information that can designate data having substantially the same attribute, item, and the same tag, and the data designation information may not completely match. For example, when only a part of the data specification information is used as a part that specifies data to be substantially arranged, if this part matches, the other part does not match. Then, it can be considered as the same data designation information. For example, if information such as a serial number is added to the end of the data specification information, such as the serial number, and this part is not used as a part that specifies data, the part excluding information such as the serial number matches Data designation information to be performed may be considered as the same data designation information. Note that the same data designation information is obtained by using the acquisition condition information such as a query for the arrangement data of the same item respectively included in one or more records of the arrangement data acquired by the arrangement data detection unit 104. It can be considered as information that can be specified for each record.

  FIG. 5 is a template information management table for managing template information stored in the template information storage unit 101 in association with template identification information. The template information management table has items of “template information” and “file name”. “Template information” is template information. “File name” is the file name of the template information file. Other template identification information may be used instead of the file name.

  FIG. 6 is a table management table for managing a table for managing the placement data stored in the data storage unit 102. The table management table has items of “table name” and “table”. “Table name” is a table name. Other table identification information may be used instead of the table name. The “table” is data of a table that manages the placement data.

  First, in order to create a form for the user to pay for the July expenses used by the user, the form output client device 20 operates the menu screen, the keyboard, etc., and acquires the template designation information. Assume that condition information is input. For example, assume that the template information file name “expense settlement application form template” is input as the template information. In addition, as the acquisition condition information, “expense table” that is a table name in which data for which a form is to be created is managed, “J3001” that is user identification information, and a month for which expense is to be settled are designated. Suppose that the information “July” is input. These acquisition condition information may be considered as a query, for example. The user identification information is, for example, the employee number of the user. As the user identification information, a user ID or the like when logging in to the form output client device 20 may be used.

  The receiving unit 201 receives the above-described template designation information and acquisition condition information input by the user. Then, the client side transmission unit 202 transmits the template identification information and the acquisition condition information received by the reception unit 201 to the form processing server apparatus 10.

  The server side receiving unit 103 of the form processing server apparatus 10 receives the template identification information and the acquisition condition information transmitted from the user. The received information is temporarily stored in a storage medium such as a memory (not shown).

  The placement data detection unit 104 acquires the placement information satisfying the condition indicated by the acquisition condition information received by the server side receiving unit 103 from the placement data stored in the data storage unit 102. Here, the received acquisition condition information is information specifying a table name “expense table”, user identification information “J3001”, and a month “July”. For this reason, the arrangement data detecting unit 104 detects a table of records whose “table name” item value is “expense table” from the table management table as shown in FIG. The record having the user identification information “J3001” and the information specifying the month “July” is detected and acquired from the arrangement data records.

  FIG. 7 is a diagram illustrating specific contents of a table associated with the table name “expense table”. The expense table includes “ID”, “user ID”, “date”, “expense classification”, “expense details”, “payee”, “description”, “main amount”, “consumption tax amount”, “settlement amount”. , “Approval status” is included. “ID” is identification information for managing records. “User ID” is identification information of a user who uses the expense. “Date” is the date the expense was incurred. “Cost classification” is an expense classification of expenses. “Expense Details” is information indicating specific contents of expenses. “Payment destination” is information indicating a payment destination of expenses. “Summary” is information indicating the main breakdown of expenses. The “main body amount” is the amount of expenses, the “consumption tax amount” is the consumption tax amount with respect to the main body amount, and the “settlement amount” is the amount to be settled. “Approval status” is information indicating whether the expense has been approved by the company.

  The placement data detection unit 104 detects and acquires a record indicated by other acquisition condition information from the table “expense table” shown in FIG. 7 indicated by the acquisition condition information. Specifically, from the “expense table”, the value of the “user ID” item matches “J3001” which is the value of the user identification information indicated by the acquisition condition information, and the value of the “date” item is the acquisition condition. A record having a value in the range indicated by “July”, which is the value of the month indicated by the information, that is, a value in the range from July 1st to July 31st is detected. For example, records with “ID” from “10006” to “10010” are detected as records satisfying the condition. The arrangement data detection unit 104 reads the value of the detected record and temporarily stores it in, for example, a storage medium (not shown).

  FIG. 8 is a diagram illustrating a management table for managing records acquired by the placement data detection unit 104. In the figure, the items in the table are the same as those in FIG.

  Next, the form data creation unit 105 matches the value of the “file name” item with the template identification information “expense settlement statement template” received by the server side reception unit 103 from the template management table shown in FIG. Detect the record and duplicate the template information of the detected record. When duplicating, the file name (template identification information) is read from the duplicated template information or the original template information, the character string “template” is deleted from this file name, and the date of duplication is entered. A new file name is created, and the file name of the template information copy is rewritten with this file name.

  FIG. 9 is a diagram showing the specific contents of the template information whose file name is “Expense Report Statement Template”. The template information is assumed to be a spreadsheet template as an example. Assume that template information is configured in one spreadsheet. The template information duplicated by the form data creation unit 105 is information having the same configuration as the template information shown in FIG. This template information includes “<% user identification information%>”, “<% month%>”, “<% accounted department%>”, “<% date%>”, “<% expense classification%>”, It has data designation information such as “<% Summary%>”, “<% Body Amount%>”, and “<% Settlement Amount%>”. Here, data delimited by “<%” and “%>” is defined in the data designation information here. In the data designation information, the data designation information such as “<% date # 1%>”, “<% date # 2%>”, etc., that ends with “# number” and the other parts match is the same. It is assumed that the data designation information for designating data, specifically, data designation information for designating data of the same item in different records. In such data designation information that designates the same item, for example, the data of the same item of each record of the plurality of arrangement data acquired by the arrangement data detection unit 104 is sequentially arranged in the order of the acquired records, for example. . In this case, a number such as “# number” may be considered as a number that identifies the acquired record. For example, this number may be considered as a detection order of acquired records, an ID order number, or the like. For example, the data designation information here may be considered as a combination of data attributes and data table or view record numbers. If the number of placement data included in the acquired record is larger than the number of data specification information, only one piece of data in that record is placed here, and no other data is placed here. To. It is assumed that “<% user identification information%>” and “<% month%>” are data specification information for specifying user identification information included in the acquisition condition information and information for specifying the month. The other information is information for designating arrangement data for the same item in the records acquired by the arrangement data detection unit 104. For example, “<% expense classification%>” is information for designating arrangement data of the item “cost classification” in the records acquired by the arrangement data detection unit 104. Here, each data designation information is assumed to be arranged in each cell of the template information.

  Further, this template information specifies an arithmetic expression that sums the values of the cells in the F column 27th row (hereinafter referred to as F27) from the F column 8th row (hereinafter referred to as F8) in FIG. It is assumed that the calculation result is specified in advance in the cell indicated by the F column 28th line (hereinafter referred to as F28) in the figure.

  In addition, an execution module for creating a bar graph using information on cells F8 to F27 is arranged in the template information, and the execution result of the execution module is designated in advance in the area 90 shown in FIG. Has been.

  The form data creation unit 105 sequentially reads out the data designation information included in the copy of the template information shown in FIG. 9, and places the placement data of the same items as the items designated by the read data designation information into the placement data detection unit 104. Is acquired from the record of the arrangement data shown in FIG. 8 acquired, the income condition information received by the server-side receiving unit 103, and the like, and is replaced with the data designation information.

  For example, “J3001”, which is user identification information included in the acquisition condition information, is acquired as the arrangement data specified by the data specification information “<% user identification information%>”, and the acquired data “J3001” The data designation information “<% user identification information%>” is replaced. As a result, information “J3001” is arranged in the cell where “<% user identification information%>” is arranged.

  Also, create a character string that excludes the character strings “<%” and “%>” from the data specification information <% booked department%>, and place an item that matches this character string “Accounted department” A search is performed from the arrangement data management table shown in FIG. Then, the “accounting department” which is the value of the detected item “accounting department” is acquired from one record (here, the first record as an example) of the arrangement data management table shown in FIG. In the acquired data “Accounting Department”, the data designation information “<% accountee department%>” is replaced. As a result, the information “Accounting Department” is arranged in the cell in which “<% booked department%>” is arranged.

  In particular, the form data creation unit 105 replaces two or more pieces of common data designation information with the different pieces of arrangement data for different pieces of arrangement data designated by two or more pieces of common data designation information. To do. For example, two or more common data designation information to which “#number” such as “<% date # 1%>”, “<% date # 2%>”, “<% date # 3%>”, etc. is assigned. Creates a character string excluding the character strings “<%”, “%>”, and “# number”, and the arrangement data detection unit 104 acquires items that match the character string “date”, respectively. Search is made from the items in the management table of the arrangement data shown in FIG. From the record of the arrangement data shown in FIG. 8 acquired by the arrangement data detection unit 104, the value of the item “date” acquired from the record in the order indicated by the number “# number” is designated as data. Each is acquired as arrangement data specified by the information “<% date # number%>”. For example, “2009/7/2” is set as arrangement data designated by “<% date # 1%>”, and “2009/7/5” is arranged as arrangement data designated by “<% date # 6%>”. get. Then, the data designation information represented by “<% date # number%>” is replaced with the acquired value. Similar processing is performed for other two or more common data designation information to which “#number” is assigned, for example, “<% expense classification # 1%>”, “<% description # 1%>”, and the like.

  It should be noted that the processing for replacing different arrangement data designated by two or more pieces of common data designation information with two or more pieces of common data designation information results in such replacement. It may be realized by processing other than the above.

  For example, for the data designation information having the same “# number” such as “<% date # 1%>”, “<% cost classification # 1%>”, “<% description # 1%>”, etc., “<% ”,“%> ”, And“ # 1 ”are excluded, and character strings such as“ date ”,“ cost classification ”, and“ summary ”are created. Then, the values of items that match these character strings are recorded in the order indicated by the numbers “# 1” in the arrangement data records shown in FIG. Then, it acquires from the record in which the order detected by the arrangement data detection unit 104 is first. For example, “2009/7/2”, “transportation cost”, and “Shinjuku-Fuchu” are acquired. Then, the data designation information such as “<% date # 1%>”, “<% expense classification # 1%>”, “<% description # 1%>”, etc. is replaced with the acquired value. If there is no corresponding data, data need not be acquired. The same processing is performed for the data designation information to which “#number” after “# 2” is assigned. As a result, the same substitution as described above can be performed.

  If there is no data corresponding to the data designation information, the data need not be acquired. For example, if the number of records of the placement data shown in FIG. 8 is “12”, no placement data corresponding to “<% date # 13%>” or the like exists, so no data is acquired.

  If there is no corresponding data, data need not be acquired. The same processing is performed for the data designation information to which “#number” after “# 2” is assigned. If there is no data corresponding to the data designation information, the data need not be acquired. For example, if the number of records of the placement data shown in FIG. 8 is “12”, no placement data corresponding to “<% date # 13%>” or the like exists, so no data is acquired.

  Form data is generated by performing such processing on all data designation information included in the copy of the template information. Note that it is preferable to delete the data designation information that has not been acquired by the designated data from the copy of the template information.

  FIG. 10 is a diagram showing the form data in the spreadsheet format created as described above. The created form data may be stored and held in a storage medium (not shown) or the like in the form processing server device 10 or may be deleted.

  Here, using the template information as described above, when performing the processing of replacing the different placement data designated by the two or more common data designation information with the common data designation information, the different placement data If the number of data is large, there may be a case where all of different arrangement data cannot be arranged. In such a case, the form data creation unit 105 duplicates one sheet or page of the template information at a predetermined position, for example, at the last position of the existing page, and the data designation information of the duplicated sheet or page Instead, the remaining arrangement data that could not be arranged with different arrangement data is arranged.

  For example, let us consider a case where arrangement data for different records specified by a plurality of the same data designation information cannot be arranged in a duplicate of template information provided in one spreadsheet. Specifically, the number of records of the placement data corresponding to the data designation information to which the “# number” is assigned is the same data designation information to which the “# number” assigned to the duplicate of the template information is assigned. If all the placement data of different records could not be placed in one copy of the template information as in the case where there are more than the number, the form data creation unit 105 duplicates the template information spreadsheet. , Append to the end of the previously duplicated spreadsheet. Then, the data designation information of the added spreadsheet may be replaced with the remaining arrangement data that has not been replaced among the arrangement data of different records designated by a plurality of the same data designation information. As a result, information that cannot fit in one form can be arranged in the added form. For example, when the form is a single form, it is possible to create a form including all necessary data by adding a spreadsheet or a page in this way. Note that the added spreadsheet is preferably added in the same file as the copy of the original template information.

  Although the case of adding a spreadsheet has been described here, a copy of the template information page may be added. For example, in a spreadsheet, multiple pages are provided in one spreadsheet, so a duplicate of the template information should be created on a different page on the same sheet as the spreadsheet that did not contain the layout data. May be.

  For example, if the number of records in the layout data shown in FIG. 8 is “23”, the form data is composed of two spreadsheets.

  FIG. 11 is a diagram illustrating an example of form data when a duplicate of a spreadsheet is added.

  When one template information file has two or more spreadsheets or pages, the form data creation unit 105 may repeat the above replacement process for all the spreadsheets on the pages. . Note that the template information provided in two or more spreadsheets or pages may be template information of different forms or template information of one form.

  As described above, when the template information includes one or more spreadsheets or pages, the form data creation unit 105 does not need to replace the spreadsheet name or the page name of the spreadsheet or page as the exclusion information. For example, a value “N” is assigned. The form data creation unit 105 does not replace the spreadsheet or page with the layout data when the exclusion information “N” is detected in the name of each spreadsheet or page name of the copied template information. . As a result, spreadsheets and pages that do not require replacement can be excluded from replacement targets.

  For example, as shown in the schematic diagram of FIG. 12, when a plurality of spreadsheets 1201 to 1203 that are templates are included in one template information file, the sheet name 1205 of the one spreadsheet 1202 is “ By setting the “settlement statement N for storage” including “N”, the replacement processing for the data designation information arranged in the spreadsheet 1202 is not performed.

  Next, the server-side transmission unit 106 transmits the created form data to the form output client device 20.

  When the client side receiving unit 203 of the form output client device 20 receives the form data, the execution unit 204 opens the received form data using application software (not shown) corresponding to the form data. Then, it is determined whether or not an arithmetic expression is included, and if it is included, an arithmetic operation is performed. Here, as described above, an arithmetic expression is set in the template information that is the basis for creating the form data, so that the calculation is performed. Here, the sum of the values of cells F8 to F27 of the form data shown in FIG. 11 is calculated. Then, the calculated calculation result is arranged in the cell F28.

  Further, the execution unit 204 determines whether or not an execution module is included in the form data, and if included, executes the execution module. Here, as described above, since the template information that is the basis for creating the form data has an execution module, the execution module is executed. Here, as described above, the bar graph is created using the information of the cells F8 to F27. Then, the created graph is arranged at a position corresponding to the area 90 shown in FIG. 9 of the form data.

  The output unit 205 configures image information of form data opened by application software corresponding to the form data. At this time, the image information of the form data in which the above calculation result and the graph as the execution result of the execution module are arranged is configured. The configured image information is displayed on a monitor or the like. Further, the form data received by the client-side receiving unit 203 is stored in a storage medium or the like (not shown) as it is.

  FIG. 13 is a diagram illustrating an output example of the form data in the form output client device 20. In the figure, a cell 1301 is a cell in which a calculation result using the calculation formula set in the template information is arranged. A graph 1302 is a graph created by executing the execution module. For example, a form printed on paper can be obtained by outputting such form data with a printer or the like. It is preferable not to print spreadsheet cells or the like, row or column numbers, or the like during printing.

  When adding new template information or editing existing template information, the form output client device 20 performs an operation of adding or editing template information to the template editing unit 207. Application software capable of processing the template information is executed to create or update the template information by creating or editing the template information. Then, the template information may be transmitted to the form processing server device 10 so that the template information stored in the template information storage unit 101 is newly accumulated or updated.

  Although not shown, the template output stored in the template information storage unit 101 of the form processing server device 10 can be received by the form output client device 20 via a network or the like, and the received template information is It may be modified so that it can be transmitted to the form processing server device 10 again.

(Specific example 2)
Next, processing using template information different from the specific example 1 will be described with an example.

  The template information according to this specific example includes repeat designation information for designating data designation information to be replaced with a plurality of pieces of arrangement data when one or more pieces of arrangement data are designated in one sheet or page. And single designation information that designates the data designation information that is replaced and arranged only once in one sheet or page with the designated arrangement data.

  Repeat designation information and single designation information are information for designating data designation information using start tags and end tags similar to tags in markup languages such as HTML, for example. Specifically, repeat designation information and single designation information are arranged in a template indicated by template information. The data designation information arranged between the start tag and the end tag of the repeat designation information is designated as data designation information arranged by being repeatedly replaced with one or more arrangement data. Further, the data designation information arranged between the start tag and the end tag of the single designation information is designated as the data designation information arranged after being replaced once.

  Note that “replacement of a plurality of arrangement data” described here may be performed in any manner as long as replacement is performed as described above. For example, for example, it may be considered as a concept that includes a plurality of pieces of placement data replacing one corresponding data designation information, and each time data designation information is replaced with one placement data. The data designation information may be repeatedly replaced with a plurality of arrangement data using the duplicated data designation information by duplicating it in the next row or column. The data designation information designated by the repeat designation information is, for example, an item designated by the data designation information of one or more records of the arrangement data acquired by the arrangement data detection unit 104 using the acquisition condition information that is a query. Will be arranged.

  The data designation information designated by the repeat designation information is the arrangement data of items included in one or more records of the arrangement data acquired by the arrangement data detection unit 104 using the acquisition condition information such as a query. May be considered as information that can be repeatedly specified for each record, or all the placement data of items included in one or more records of the placement data acquired by the placement data detection unit 104 at a time. It may be considered as information that can be specified.

  Note that data other than the data designation information designated by the repeat designation information may be determined as the data designation information designated by the single designation information. In this case, as a result, it may be considered that the repeat designation information also serves as the single designation information. Conversely, data other than the data designation information designated by the single designation information may be determined as the data designation information designated by the repeat designation information. In this case, as a result, it may be considered that the single designation information also serves as the repeat designation information.

  FIG. 14 is a diagram illustrating a specific example of template information stored in the template information storage unit 101. Here, it is assumed that the template information is a spreadsheet template. In the figure, a header tag, that is, a tag composed of a combination of a start tag “<header>” and an end tag “</ header>” is single designation information. That is, each data designation information sandwiched between the start tag “<header>” and the end tag “</ header>” (hereinafter referred to as data designation information which is an element of the header tag) is in one sheet or page. Is designated as data designation information that is replaced only once with the placement data designated by the data designation information. Similarly, a footer tag, that is, a tag composed of a combination of a start tag “<footer>” and an end tag “</ footer>” is also single designation information. However, in this example, it is assumed that there is no data designation information sandwiched between the start tag “<header>” and the end tag “</ header>”.

  Further, a detail tag, that is, a tag constituted by a combination of a start tag “<detail>” and an end tag “</ detail>” is repeat designation information. That is, each data designation information sandwiched between the start tag “<detail>” and the end tag “</ detail>” (hereinafter referred to as data designation information as an element of the detail tag) is in one sheet or page. In this case, it is designated as data designation information that is repeatedly replaced by one or more pieces of arrangement data designated by the data designation information.

  For example, if the user inputs the template identification information for specifying the template information shown in FIG. 14 and the acquisition condition information similar to the specific example 1 described above, the placement data detection unit 104 is similar to FIG. Get records that manage data for placement

  Next, the form data creation unit 105 duplicates the template information shown in FIG. 14 and sequentially reads the data designation information included in the duplicate, for example, in order from the duplicate of the template information. The arrangement data of the same item as the designated item is obtained from the arrangement data record shown in FIG. 8 obtained by the arrangement data detection unit 104, the income condition information received by the server side reception unit 103, and the like. Instead of the designation information, it is arranged in the cell where the data designation information has been arranged.

  At this time, the form data creation unit 105 uses the placement data designated by the data designation information of the placement data acquired by the placement data detection unit 104 for the data designation information designated by the single designation information only once. Replace. That is, the data designation information of the elements of the header tag and the footer tag is replaced only once with the data designation information designated by these data designation information. For example, even when there are a plurality of pieces of placement data designated by one piece of data designation information, only one piece of placement data is acquired and replaced without replacing with a plurality of pieces of placement data. How to obtain one piece of placement data when there are a plurality of pieces of placement data may be set in advance. For example, only the arrangement data for the first record may be acquired. Alternatively, only one piece of arrangement data processed by the unique process may be acquired.

  For example, the form data creation unit 105 sets a character string “accounting department” excluding character strings “<%” and “%>” for the data designation information <% accounting department%> which is an element of the header tag. And searches the arrangement data management table shown in FIG. 8 acquired by the arrangement data detection unit 104 for items that match the character string “accounting department”. Then, the “accounting department” which is the value of the detected item “accounting department” is acquired from one record (here, the first record as an example) of the arrangement data management table shown in FIG. In the acquired data “Accounting Department”, the data designation information “<% accountee department%>” is replaced. As a result, the data designation information “<% booked department%>” that is an element of the header tag is replaced with one arrangement data “Accounting Department”.

  On the other hand, the form data creation unit 105 uses one or more pieces of arrangement data designated by the data designation information of the arrangement data acquired by the arrangement data detection unit 104 for the data designation information designated by the repeat designation information. Replace. In particular, when there are a plurality of pieces of placement data designated by the data designation information in the placement data acquired by the placement data detection unit 104, the corresponding data designation information is replaced with the plurality of pieces of placement data.

  That is, the data designation information of the element of the detail tag is replaced by using the arrangement data designated by these data designation information, but if there are a plurality of arrangement data designated by one data designation information, Replace the data specification information with the placement data. This replacement process may be a process of acquiring a plurality of placement data designated by one data designation information and replacing the data designation information at a time, or copying one data designation information while copying the data designation information. A process of sequentially acquiring a plurality of pieces of arrangement data designated by the information and replacing the data designation information with the obtained arrangement data.

  For example, the form data creation unit 105 creates a character string “main body amount” excluding the character strings “<%” and “%>” for the data designation information <% body amount%> that is an element of the detail tag. Then, the item matching the character string “main body amount” is searched from the arrangement data management table shown in FIG. 8 acquired by the arrangement data detection unit 104. Then, the acquired value of the item “main body amount” is all acquired from the plurality of records as shown in FIG. 8 acquired by the arrangement data detection unit 104 from the arrangement data management table. Data designation information “<% body amount%>” is replaced with data of a plurality of lines composed of arrangement data. As a result, the data designation information “<% body amount%>”, which is an element of the detail tag, is replaced with the arrangement data of a plurality of lines.

  It should be noted that one record is sequentially read from the plurality of records in the arrangement data management table shown in FIG. 8, and the data of the item indicated by one or more data specification information that is an element of the detail tag included in the read record is read. Are acquired sequentially for each record, and at the time when the placement data is obtained for all of the plurality of records in the placement data management table shown in FIG. Some data designation information may be replaced.

  Alternatively, one or more pieces of data specification information that is an element of the detail tag are duplicated, and the rows and columns are appropriately added and arranged in a spreadsheet or page that is a duplicate of the template information. One record is read from a plurality of records in the data management table, the data of the item indicated by the duplicate of the data designation information created above is obtained from this record, and the duplicate of this data designation information is replaced. By repeating this process for all the records in the arrangement data management table shown in FIG. 8, one or more pieces of data designation information as elements of the detail tag may be replaced with a plurality of arrangement data. good.

  Then, when the replacement of the data specification information that is an element of the detail tag is completed, the replacement of the data specification information of the element of the next footer tag is performed. Since the footer tag is the same single designation information as the header tag described above, the data designation information of the element of the footer tag is also replaced only once with the corresponding arrangement data. However, in this example, since the footer tag does not have data designation information as an element, no replacement is performed.

  By performing such processing, form data in which the data designation information is replaced with arrangement data is created. The repeat designation information and the single designation information may be deleted as appropriate at the time when all the data designation information is replaced, and the lines where these data are arranged may be deleted as appropriate.

  The form data created in this way is transmitted to the form output client device 20 and output, as in the above specific example. In addition, although explanation about the arithmetic expression specified in the template information, the execution module, etc. is omitted here, for example, the cell that is the target of the arithmetic expression is arranged with the data specifying information in the repeat area. Placement data specified by the data specification information in the repeat area obtained from multiple records by setting the cell where the calculation result is placed as the cell in the area sandwiched between footer tags The calculation result performed using is placed in an area sandwiched between footer tags.

  FIG. 15 is a diagram showing an output example of form data created using the template information shown in FIG.

  If the number of data for placement specified by one of the data specification information of the data specification information specified by the repeat specification information of one spreadsheet or page of the template information is greater than or equal to the value specified in advance, form data creation The unit 105 replaces the data designation information designated by the repeat designation information with a predetermined number of arrangement data, and at the same time the spreadsheet or page duplicate to be replaced with the template information. Alternatively, it may be added as a page, and the data designation information designated by the repeat designation information of the duplicate sheet or page may be replaced with arrangement data exceeding a predetermined number. In this case, the copy of the added spreadsheet or page contains the data specification information specified by the single specification information included in the original sheet or page, so the data specified by this single specification information The designation information is also replaced with the corresponding arrangement data in the same manner as the data designation information designated by the normal single designation information.

  For example, the number of records acquired by the placement data detection unit 104 shown in FIG. 8 is 7000, for example, and corresponds to one piece of data specification information of the detail tag element that is repeat specification information in the template information shown in FIG. It is assumed that the number of arrangement data to be performed is 7000. If the number designated in advance by the user or the like is 6000 at this time, the form data creation unit 105 determines that the number of arrangement data designated by the data designation information designated by the repeat designation information is equal to or greater than a predetermined number. . Therefore, the template information spreadsheet shown in FIG. 15 is duplicated and added. Then, the data designation information designated by the repeat designation information of the added spreadsheet is replaced with a portion of the arrangement data that exceeds a predetermined number. Also, the data designation information designated by the single designation information is replaced with the arrangement data designated by the data designation information as usual. In this way, form data composed of a plurality of spreadsheets is created.

  FIG. 16 is a diagram showing a display example of the form data when the spreadsheet is duplicated.

  As described above, since the template information as shown in FIG. 14 can appropriately add information designated by the data designation information designated by the repeat designation information, when creating the form data of the continuous form, Is suitable.

  As described above, according to the present embodiment, since the template information used for creating the form and the form data created using the template information have the same file format, the template information and the form data are processed with the same application software. Operations such as editing and printing are possible. For this reason, it is not necessary to operate a development program to create or edit template information, so advanced knowledge and techniques for the program are not required, and application software used by the user to output forms is used. Thus, template information can be easily added and edited. As a result, the user can output a form in an arbitrary format. In addition, since application software that is already used by the user can be used, the time required to master the technique for editing the template information can be shortened. In addition, the process when the engineer develops the form is facilitated, and the man-hour for the form development can be shortened.

  Needless to say, the template information that can be used in the present invention is not limited to the template information described in the above specific example.

  In addition, by making the template information into spreadsheet format information, it is possible to easily specify the location where the placement data is placed, and set the layout of the form by placing ruled lines and the like.

  In the above embodiment, the case where the template information edited in the form output client apparatus 20 is transmitted to the form processing server apparatus 10 has been described. However, in the present invention, for example, network file sharing that is a known technique is performed. The template information stored in the template information storage unit 101 of the form processing server device 10 can be shared by the form output client device 20 using a mechanism or the like, and directly using application software corresponding to the template information. You may be able to edit it.

  In the above embodiment, the case where the form data is output by the server / client form processing system has been described. However, the present invention can also be realized in a stand-alone form processing apparatus as described below.

  FIG. 17 is a block diagram showing a configuration of a stand-alone form processing apparatus 30. As shown in FIG. In the figure, the same reference numerals as those in FIG. 1 denote the same or corresponding parts.

  The form processing apparatus 30 includes a receiving unit 201 instead of the server-side receiving unit 103, an execution unit 204 and an output unit 205 instead of the server-side transmitting unit 106, and a template receiving unit in the form processing server device 10 shown in FIG. Instead of 107, an editing operation accepting unit 206 and a template editing unit 207 are provided.

  In the form processing apparatus 30, the arrangement data detection unit 104 acquires the arrangement data using the acquisition condition information received by the reception unit 201. Further, the form data creation unit 105 creates a copy of the template information using the template identification information received by the reception unit 201. Further, the execution unit 204 executes the calculation formula and execution module of the form data created by the form data creation unit 105. The output unit 205 outputs the form data created by the form data creation unit 105. Further, the template information received by the editing operation receiving unit 206 and edited by the template editing unit 207 can be stored in the template information storage unit 101.

  Such a stand-alone form processing apparatus 30 also has the same effect as the form processing system 1 described above.

  In the above embodiment, each processing (each function) may be realized by centralized processing by a single device (system), or may be realized by distributed processing by a plurality of devices. May be.

  In the above embodiment, it goes without saying that two or more communication means (such as an information transmission unit) existing in one apparatus may be physically realized by one medium.

  In the above embodiment, information related to processing executed by each component, for example, information received, acquired, selected, generated, transmitted, and received by each component. In addition, information such as threshold values, mathematical formulas, addresses, etc. used by each component in processing is retained temporarily or over a long period of time on a recording medium (not shown) even when not explicitly stated in the above description. It may be. Further, the storage of information in the recording medium (not shown) may be performed by each component or a storage unit (not shown). Further, reading of information from the recording medium (not shown) may be performed by each component or a reading unit (not shown).

  In the above-described embodiment, the case where the form processing system is a stand-alone has been described. However, the form processing system may be a stand-alone apparatus or a server apparatus in a server / client system. In the latter case, the output unit or the reception unit receives an input or outputs a screen via a communication line.

  In the above embodiment, each component may be configured by dedicated hardware, or a component that can be realized by software may be realized by executing a program. For example, each component can be realized by a program execution unit such as a CPU reading and executing a software program recorded on a recording medium such as a hard disk or a semiconductor memory.

  The software that realizes the form processing system in the above embodiment is the following program. That is, this program is a template identification information that is information for identifying a template, which is information indicating a template of a form and having data designation information that is information for designating data arranged in the template. And a server-side receiving unit that receives acquisition condition information that is information indicating conditions for acquiring arrangement data that can be arranged in the template indicated by the template information stored in the data storage unit, and a data storage unit Among the data stored in the server, the placement data detection unit that acquires the placement data that matches the condition indicated by the acquisition condition information received by the server-side receiving unit, and the template information storage unit is associated with the template identification information. Template information received by the server-side receiver from the stored template information The template information corresponding to the identification information is copied, and the data designation information included in the duplicated template information is replaced with the arrangement data specified by the data designation information from the arrangement data acquired by the arrangement data detection unit. The form data creating unit for creating the form data and the program for causing the form data created by the form data creating unit to function as a server-side transmitting unit for transmitting to the form output client device.

  In the program, the functions realized by the program do not include functions that can be realized only by hardware. For example, a function that can be realized only by hardware such as a modem or an interface card in an acquisition unit that acquires information or an output unit that outputs information is not included in the function realized by the program.

  Further, the computer that executes this program may be singular or plural. That is, centralized processing may be performed, or distributed processing may be performed.

  FIG. 18 is a schematic diagram showing an example of the external appearance of a computer that executes the program and realizes the form processing server device 10, the form output client device 20, the form processing device 30, and the like according to the above embodiment. The above-described embodiment can be realized by computer hardware and a computer program executed on the computer hardware.

  18, a computer system 900 includes an optical disk drive 905 such as a CD-RW (Compact Disk Rewritable) drive, a computer 901 including an FD (Floppy (registered trademark) Disk) drive 906, a keyboard 902, a mouse 903, a monitor. 904.

  FIG. 19 is a diagram showing an internal configuration of the computer system 900. In FIG. 19, in addition to the optical disk drive 905 and the FD drive 906, a computer 901 is connected to an MPU (Micro Processing Unit) 911, a ROM 912 for storing a program such as a bootup program, and an MPU 911. A bus 915 that interconnects a RAM (Random Access Memory) 913 that temporarily stores instructions and a temporary storage space, a hard disk 914 that stores application programs, system programs, and data, an MPU 911, a ROM 912, and the like. With. The computer 901 may include a network card (not shown) that provides connection to the LAN.

  Programs that cause the computer system 900 to execute the functions of the form processing server device 10, form output client device 20, form processing device 30, and the like according to the above-described embodiments are CD-ROM, CD-RW, DVD-ROM, DVD It may be stored in the optical disk 921 or FD 922 such as RW, inserted into the optical disk drive 905 or FD drive 906, and transferred to the hard disk 914. Instead, the program may be transmitted to the computer 901 via a network (not shown) and stored in the hard disk 914. The program is loaded into the RAM 913 when executed. The program may be loaded directly from the optical disc 921, the FD 922, or the network.

The program does not necessarily include an operating system (OS) or a third-party program that causes the computer 901 to execute the functions of the form processing server apparatus 10, the form output client apparatus 20, the form processing apparatus 30, and the like according to the above-described embodiment. It does not have to be. The program may include only a part of an instruction that calls an appropriate function (module) in a controlled manner and obtains a desired result. How the computer system 900 operates is well known and will not be described in detail.
The present invention is not limited to the above-described embodiments, and various modifications are possible, and it goes without saying that these are also included in the scope of the present invention.

  As described above, the form processing system or the like according to the present invention is suitable as a system for outputting a form, and is particularly useful as a form processing system or the like that can output various forms of forms using templates.

DESCRIPTION OF SYMBOLS 1 Form processing system 10 Form processing server apparatus 20 Form output client apparatus 30 Form processing apparatus 101 Template information storage part 102 Data storage part 103 Server side reception part 104 Arrangement data detection part 105 Form data creation part 106 Server side transmission part 107 Template Reception unit 201 Reception unit 202 Client side transmission unit 203 Client side reception unit 204 Execution unit 205 Output unit 206 Editing operation reception unit 207 Template editing unit 208 Template transmission unit

Claims (12)

A form processing system comprising a form processing server device and a form output client device,
The form processing server device
Template information that is information indicating a template of a form and that has data designation information that is information for designating data arranged in the template, and template identification information that is information for identifying the template information correspond to each other A template information storage unit that can be attached and stored;
A data storage unit capable of storing placement data, which is data that can be placed in the template indicated by the template information;
A server-side receiving unit that receives template identification information and acquisition condition information that is a condition for acquiring the placement data from the form output client device;
An arrangement data detection unit that acquires arrangement data that meets the conditions indicated by the acquisition condition information received by the server side reception unit from the data stored in the data storage unit;
The template information corresponding to the template identification information received by the server-side receiving unit is duplicated, and the data designation information included in the duplicated template information is included in the arrangement data acquired by the arrangement data detection unit. A form data creation unit that creates form data by replacing with the placement data specified by the specified information,
A server-side transmission unit that transmits the form data created by the form data creation unit to the form output client device;
The form output client device
A receiving unit that receives the template identification information and the acquisition condition information;
A client-side transmission unit that transmits the template identification information received by the reception unit and the acquisition condition information to the form processing server device;
A client-side receiving unit that receives form data transmitted from the form processing server;
A form processing system comprising: an output unit that outputs form data received by the client side receiving unit. The template information further includes an arithmetic expression or an execution module that uses the placement data specified by the data specification information,
The form data creation unit replaces the data designation information corresponding to the arithmetic expression or the execution module with the arrangement data specified by the data designation information among the arrangement data acquired by the arrangement data detection unit. Create the form data,
The form output client device
The arithmetic processing using the arithmetic expression included in the form data received by the client side receiving unit or the execution module is executed using the arrangement data in which the data designation information corresponding to the arithmetic expression or the execution module is replaced. An execution unit,
The form processing system according to claim 1, wherein the output unit outputs form data obtained by adding execution result information of the execution unit to the form data received by the client side receiving unit. The template information is information of a spreadsheet having one or more sheets, and the data designation information is arranged in a cell of the spreadsheet,
The form data creation unit duplicates the template information corresponding to the template identification information received by the server-side receiving unit, and the data designation information arranged in each spreadsheet cell indicated by the duplicated template information, The form processing system according to claim 1, wherein the form data having a plurality of sheets is created by replacing the placement data acquired by the placement data detection unit with the placement data designated by the data designation information. The template information is information having a plurality of pages,
The form data creation unit duplicates the template information corresponding to the template identification information received by the server-side receiving unit, and sets the data designation information arranged on each page indicated by the duplicated template information as the placement data The form processing system according to claim 1, wherein the form data having a plurality of pages is created by replacing the placement data acquired by the detection unit with the placement data designated by the data designation information. The template information has two or more pieces of the same data designation information on one sheet or page,
The form data creation unit
When the different arrangement data designated by the two or more common data designation information is replaced with the common data designation information and all the different arrangement data cannot be arranged, the one sheet or page is The form processing system according to claim 1, wherein the form data is duplicated and replaced with the data designation information of the duplicated sheet or page, and the remaining arrangement data that could not be arranged with the different arrangement data is arranged. The template information includes repeat designation information which is information for designating data designation information to be replaced with the plurality of pieces of arrangement data when there is a plurality of pieces of one or more pieces of arrangement data designated. And single designation information that is information that designates data designation information that is replaced and arranged only once with data,
The form data creation unit
For the data designation information designated by the single designation information, the data designation information is replaced with the arrangement data designated by the data designation information among the arrangement data acquired by the arrangement data detection unit,
For the data designation information designated by the repeat designation information, the data designation information is replaced with one or more pieces of arrangement data designated by the data designation information among the arrangement data acquired by the arrangement data detection unit. The form processing system according to claim 1, wherein the form data is created. The template information includes repeat designation information for designating data designation information to be replaced with a plurality of pieces of arrangement data when one or more pieces of arrangement data are designated in one sheet or page. Single designation information for designating data designation information that is replaced and arranged only once in the one sheet or page with the arrangement data to be arranged,
The form data creation unit
Replacing the data designation information designated by the single designation information with the arrangement data designated by the data designation information among the arrangement data acquired by the arrangement data detection unit;
Replacing the data designation information designated by the repeat designation information with one or more arrangement data designated by the data designation information of the arrangement data acquired by the arrangement data detection unit;
When the arrangement data designated by the data designation information designated by the repeat designation information exceeds a predetermined number, the one sheet or page is duplicated, and with the arrangement data exceeding the predetermined number, the duplicated sheet or page The form processing system according to claim 1, wherein the data designation information designated by the repeat designation information is replaced. The template information has exclusion information that is information for designating sheets or pages that are not to be replaced by the placement data,
The form processing system according to claim 1, wherein the form data creation unit does not perform replacement with the sheet or page arrangement data specified by the exclusion information. Template information that is information indicating a template of a form and that has data designation information that is information for designating data arranged in the template, and template identification information that is information for identifying the template information correspond to each other A template information storage unit that can be attached and stored;
A data storage unit capable of storing placement data, which is data that can be placed in the template indicated by the template information;
A server-side receiving unit that receives template identification information and acquisition condition information that is a condition for acquiring the placement data from the form output client device;
An arrangement data detection unit that acquires arrangement data that meets the conditions indicated by the acquisition condition information received by the server side reception unit from the data stored in the data storage unit;
The template information corresponding to the template identification information received by the server-side receiving unit is duplicated, and the data designation information included in the duplicated template information is included in the arrangement data acquired by the arrangement data detection unit. A form data creation unit that creates form data by replacing with the placement data specified by the specified information,
A form processing server device comprising a server-side transmission unit that transmits the form data created by the form data creation unit to the form output client device. Template information that is information indicating a template of a form and that has data designation information that is information for designating data arranged in the template, and template identification information that is information for identifying the template information correspond to each other A template information storage unit that can be attached and stored;
A data storage unit capable of storing placement data, which is data that can be placed in the template indicated by the template information;
A receiving unit that receives template identification information and acquisition condition information that is information indicating a condition for acquiring the placement data;
An arrangement data detection unit that acquires arrangement data that meets the conditions indicated by the acquisition condition information received by the reception unit from the data stored in the data storage unit;
The template information corresponding to the template identification information received by the receiving unit is duplicated, and the data designation information included in the arrangement data acquired by the arrangement data detecting unit is the data designation information included in the duplicated template information. A form data creation unit that creates form data by replacing with the layout data specified by
A form processing apparatus comprising: an output unit that outputs form data created by the form data creation unit. Template information that is information indicating a template of a form and that has data designation information that is information for designating data arranged in the template, and template identification information that is information for identifying the template information correspond to each other A template information storage unit that can be attached and stored; a data storage unit that can store placement data that is data that can be placed in the template indicated by the template information; a server-side reception unit; a placement data detection unit; A form processing method performed using a form data creation unit and a server-side transmission unit,
A server-side receiving step in which the server-side receiving unit receives template identification information and acquisition condition information that is information indicating a condition for acquiring the placement data;
A placement data detection step in which the placement data detection unit acquires placement data that meets the conditions indicated by the acquisition condition information received in the server side reception step from the data stored in the data storage unit; ,
The form data creation unit duplicates the template information corresponding to the template identification information received in the server-side reception step, and the data designation information included in the duplicated template information is acquired in the placement data detection step Of the data, a form data creation step for creating form data by replacing with the placement data designated by the data designation information;
A form processing method, comprising: a server-side transmission step in which the server-side transmission unit transmits the form data created in the form data creation step. Computer
Information indicating a template of the form, and is stored in the data storage unit, template identification information that is information for identifying template information that is information having data specification information that is information for specifying data to be arranged in the template. A server-side receiving unit that receives acquisition condition information that is information indicating a condition for acquiring data for arrangement, which is data that can be arranged in a template indicated by the template information.
An arrangement data detection unit that acquires arrangement data that meets the conditions indicated by the acquisition condition information received by the server side reception unit from the data stored in the data storage unit;
Of the template information stored in association with the template identification information in the template information storage unit, the template information corresponding to the template identification information received by the server-side receiving unit is duplicated, and the duplicated template information Replacing the data designation information included in the data for placement acquired by the placement data detection unit with the placement data designated by the data designation information to create form data,
A program for causing the form data created by the form data creating unit to function as a server-side transmitting unit that transmits to the form output client device.

Images