JP2008015960A - Business form making system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a business form making system which can easily perform secondary use of business form output data. <P>SOLUTION: An indication file creating means 22 designates a selected template in a plurality of templates stored in a business form layout file storage means 26, and designates selected data in a plurality of data stored in database 24. A business form creating means 28 takes out a template designated by the indication file creating means 22, takes out designated data, creates business form data by embedding them to the file of the template, and outputs the data as sheet data of Excel form. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to a form creation system, and more particularly to a form creation system suitable for creating a form using a network environment.

  2. Description of the Related Art Conventionally, a dedicated system has been used as a form creation system for creating an order form or an estimate (see, for example, Patent Document 1).

JP 2005-190436 A

  However, in the case of using a dedicated system as in the past, the output form data is dedicated to the system, and in order to use it with general application software such as Excel, data conversion software is required. There was a problem of becoming.

  An object of the present invention is to provide a form creation system that can easily make secondary use of form output data.

(1) In order to achieve the above object, the present invention provides a form layout file storage means for storing a plurality of template Excel files, a database in which data is stored, and the form layout file storage means. An instruction file creating means for designating a selected template from among a plurality of models stored in the database, and designating selected data from among a plurality of data stored in the database, and the instruction file Take out the template specified by the creation means from the form layout file storage means, take out the data specified by the instruction file creation means from the database, and create the form data by embedding in the template file, Provide a form creation means to output as Excel sheet data It is intended.
With this configuration, the secondary use of the form output data can be easily performed.

  (2) In the above (1), preferably, the form creation means outputs a plurality of sheet data when the number of data exceeds the number of data that can be embedded in one sheet, and for each sheet, The same title is maintained.

  (3) In the above (1), preferably, the form layout file storage means, the database, the instruction file creation means, and the form creation means are provided in a server PC, from the client PC to the server PC. The selected template can be specified from among a plurality of templates stored in the form layout file storage means, and selected from a plurality of data stored in the database. The data can be specified, and the form creation means embeds the data input from the client PC in the Excel sheet data to be output.

  According to the present invention, secondary use of the form output data can be easily performed.

Hereinafter, the configuration and processing operation of a form creation system according to an embodiment of the present invention will be described with reference to FIGS.
First, the system configuration of the form creation system according to the present embodiment will be described with reference to FIG.
FIG. 1 is a system block diagram showing the configuration of a form creation system according to an embodiment of the present invention.

  The form creation system according to this embodiment includes a client PC 10 and a server PC 20. The client PC 10 can access the server PC 20 using a web browser.

  The server PC 20 includes an instruction file creation unit 22, a database 24, a form layout file storage unit 26, and a form creation unit 28. The database 24 stores data for creating a form. Examples of data are employee data and estimate data. In the form layout file storage means 26, a plurality of form templates (templates) that can be output are prepared in an Excel file format.

  When the user designates a form to be created using the web browser of the client PC 10 and issues a request to designate data to be embedded in the form, the instruction file creating unit 22 creates an instruction file. The instruction file is created in the XML format. More specifically, when the user accesses the server PC 20 using the web browser of the client PC 10, the instruction file creation means 22 can be created using data stored in the form layout file storage means 26. A list of forms is returned to the client PC 10 as an answer screen. The user selects a template of a form to be created from a list of forms that can be created displayed on the web browser.

Here, an example of a template used in the form creation system according to the present embodiment will be described with reference to FIG.
FIG. 2 is an explanatory diagram of templates used in the form creation system according to the embodiment of the present invention.

  The template shown in FIG. 2 is an Excel template, and the sheet name is “employee data”. In this template, a form can be created by embedding data of each item of “name”, “birthplace”, and “age” in each of the columns B, C, and D. The number of data items that can be input is an example in which three items can be input per page because the data input range is from the third column to the fifth column.

  When the user uses the web browser of the client PC 10 to select a template of a form to be created, a screen for selecting data to be embedded in the selected form is displayed on the web browser. What is displayed here is a list of data stored in the database 24. When the data to be embedded is selected, the instruction file creating unit 22 creates an instruction file.

Here, an example of an instruction file created by the form creation system according to the present embodiment will be described with reference to FIG.
FIG. 3 is an explanatory diagram showing an example of an instruction file created by the form creation system according to the embodiment of the present invention.

  The instruction file in FIG. 3 is described in the XML format. The 15th line of the instruction file describes that an Excel file template “employee data.xls” is used as a template. In the eighth line, it is described that data of each item of “name”, “birthplace”, and “age” is selected from the data “employee data” in the database 24. This is because, for example, “employee data” includes data such as “affiliation” and “date of employment” in addition to data such as “name”, “birthplace”, and “age”. Of these items, as shown in FIG. 2, the data to be embedded in the template of “employee data.xls” is three items of “name”, “hometown”, and “age”. Only three items of data are extracted (selected).

Next, the operation of the form creation unit 28 of the form creation system according to the present embodiment will be described with reference to FIGS.
FIG. 4 is a flowchart showing the processing contents of the form creation means of the form creation system according to the embodiment of the present invention. FIG. 5 is an explanatory diagram of a DTO file created by the form creation means of the form creation system according to an embodiment of the present invention. FIG. 6 is an explanatory diagram showing an example of a form created by the form creation unit of the form creation system according to the embodiment of the present invention.

  In step S10 of FIG. 4, the form creation unit 28 reads the instruction file (exemplified in FIG. 3) created by the instruction file creation unit 22.

  Next, in step S15, the form creation means 28 determines a template to be used for form creation from the read instruction file, and copies the template file from the form layout file storage means 26. For example, since it is described in the 15th line of the instruction file in FIG. 3 that an Excel file template “employee data.xls” is used, the excel file “employee data.xls” is saved from the form layout file storage means 26. make a copy.

  Next, in step S20, the form creation means 28 confirms the copy contents, and in step S25, determines whether the contents are OK. If so, the process proceeds to step S30.

  If the copy content can be confirmed, the form creation means 28 confirms the content of the instruction file in step S30. In step S35, necessary data is extracted from the database. As a result, in step S40, a DTO (Data Transfer Object) is generated.

  Here, an example of the DTO file will be described with reference to FIG. As described in the 8th line of the instruction file in FIG. 3, “employee data.xls” includes “name”, “hometown”, “age” from the data “employee data” in the database 24. It is necessary to select data for each item. In this way, a file obtained by extracting data to be embedded in the template file is a DTO file. Therefore, as shown in FIG. 5, the DTO file is employee data including item data of “name”, “birthplace”, and “age”. The file name of this DTO file is “employee data” as described in the “title” column.

  Next, in step S45, the form creation means 28 embeds the contents of the DTO file created in step S40 one by one in the template file copied in step 15 one by one.

  In step S50, the form creation means 28 determines whether or not it is an embedding range. If it is an embedding range, the process returns to step S45 to continue the process. If there is data remaining, if there is data remaining, page break processing is executed in step S60, and step S45 is repeated. If there is no remaining data, an Excel file that is a form to be created is generated in step S65. To do.

  Here, the created Excel file will be described with reference to FIG. As described with reference to FIG. 2, the template “employee data” is a style in which three pieces of data can be posted on one page. Therefore, for example, when there are five employee data as in the DTO shown in FIG. 5, the first to third cases are determined as “employee” shown in FIG. It is embedded in the first page of the Excel file called “Data”. Here, the “employee data” written in the cell of the first row and the B column is given by the variable “$ (title)” as shown in FIG. On the other hand, in the DTO file shown in FIG. 5, since “employee data” is given in the “title” column, the title of the created Excel file becomes “employee data”.

  In the fourth and subsequent cases, the page break process is performed in step S60 according to the determination in step S55 of FIG. 4, and the sheet name “employee data_2” is added as shown in FIG. Created as the second page sheet. At this time, in the page break process, as shown in the second line of FIG. 6B, data “title” and “employee data” are copied and created. That is, the form creation means 28 outputs the data as a plurality of sheet data when the number of data exceeds the number of data that can be embedded in one sheet, and maintains the same title for each sheet.

  As described above, the employee data form by the Excel file shown in FIG. 6 is created by the processing of FIG. Therefore, since the created form data is Excel file data, secondary use of the form data can be easily performed.

Next, a second example of form generation by the form creation system according to the present embodiment will be described with reference to FIGS.
FIG. 7 is an explanatory diagram of a second example of a template used in the form creation system according to an embodiment of the present invention. FIG. 8 is an explanatory diagram of a second example of the instruction file created by the form creation system according to the embodiment of the present invention. FIG. 9 is an explanatory diagram of a second example of the DTO file created by the form creation unit of the form creation system according to the embodiment of the present invention. FIG. 10 is an explanatory diagram of a second example of a form created by the form creation unit of the form creation system according to an embodiment of the present invention.

  FIG. 7 shows a second example of an Excel template, in which the sheet name is “estimate”. In this template, two sheets having a sheet name “estimate (main sheet)” and “estimate (next sheet)” are prepared in advance. In the “estimate (main paper)”, there is a column in the first row and second column that describes the destination of the estimate as “$ (custmer)”, whereas in the “estimate (next paper)” Similarly, the difference is that no column is provided. Further, in this template, a form can be created by embedding data of each item of “item name”, “quantity”, and “subtotal” in each of the B column, the C column, and the D column. The number of data items that can be input is an example in which three items can be input per page because the data input range is from the third column to the fifth column. Further, “$ (custmer)”, which is data embedded in the cell in the first row and B column, is embedded with data input from the web browser.

  Next, an example of the instruction file will be described with reference to FIG. The 15th line of the instruction file describes the use of an Excel file template “estimate.xls” as a template. In the eighth line, it is described that data of each item “item name”, “quantity”, and “subtotal” is selected from the data “fruit and vegetable data” in the database 24.

  FIG. 9 shows an example of the DTO file. As described in the 8th line of the instruction file in FIG. 8, “fruits and vegetables data.xls” includes “product name”, “quantity”, and “subtotal” from the data “fruits and vegetables data” in the database 24. It is necessary to select data for each item, and as shown in FIG. 9, the DTO file is fruit and vegetable data including item data of “item name”, “quantity”, and “subtotal”.

  FIG. 10 shows the created Excel file. As described with reference to FIG. 7, the model “fruit and vegetable data” is a style in which three pieces of data can be posted on one page. Therefore, for example, when there are eight pieces of fruit and vegetable data as in the DTO shown in FIG. 9, from the first to the third case, the “fruits and vegetables” shown in FIG. It is embedded in the first page of the Excel file called “Data”. In the fourth to sixth cases, the page break process is performed in step S60 according to the determination in step S55 of FIG. 4, and as shown in FIG. The The seventh and subsequent cases are created as “fruit and vegetable data next sheet_2” as shown in FIG. That is, the form of the fruit and vegetables data by the Excel file shown in FIG. 10 is created by the process of FIG. Therefore, since the created form data is Excel file data, secondary use of the form data can be easily performed.

Further, since the form data is created with an Excel file, it is possible to embed a mathematical formula in a cell and automatically calculate a grand total obtained by summing up each subtotal and embed it in the cell.

It is a system block diagram which shows the structure of the form creation system by one Embodiment of this invention. It is explanatory drawing of the template used for the form creation system by one Embodiment of this invention. It is explanatory drawing of an example of the instruction | indication file which the form preparation system by one Embodiment of this invention produced. It is a flowchart which shows the processing content of the form creation means of the form creation system by one Embodiment of this invention. It is explanatory drawing of the DTO file created by the form creation means of the form creation system by one Embodiment of this invention. It is explanatory drawing of an example of the form produced by the form production means of the form production system by one Embodiment of this invention. It is explanatory drawing of the 2nd example of the template used for the form creation system by one Embodiment of this invention. It is explanatory drawing of the 2nd example of the instruction | indication file created with the form creation system by one Embodiment of this invention. It is explanatory drawing of the 2nd example of the DTO file produced by the form production means of the form production system by one Embodiment of invention. It is explanatory drawing of the 2nd example of the form produced by the form creation means of the form creation system by one Embodiment of this invention.

Explanation of symbols

10 ... Client PC
20 ... Server PC
22 ... Instruction file creation means 24 ... Database 26 ... Form layout file storage means 28 ... Form creation means

Claims (3)

A form layout file storage means for storing an Excel file of a plurality of templates of the form;
A database where the data is stored,
Creation of an instruction file for designating a selected template from among a plurality of templates stored in the form layout file storage means and designating selected data from among a plurality of data stored in the database Means,
The template designated by the instruction file creation means is taken out from the form layout file storage means, the data designated by the instruction file creation means is taken out from the database, and the form data is embedded by embedding in the template file. A form creation system comprising: a form creation means for creating and outputting as an Excel sheet data. In the form creation system according to claim 1,
When the number of data exceeds the number of data that can be embedded in one sheet, the form creation means outputs the data as a plurality of sheet data and maintains the same title for each sheet. system. In the form creation system according to claim 1,
The form layout file storage means, the database, the instruction file creation means, and the form creation means are provided in a server PC,
A client PC is connected to the server PC, and a selected template can be specified from among a plurality of templates stored in the form layout file storage means, and a plurality of data stored in the database can be specified. Of the selected data can be specified,
The form creation system embeds data input from the client PC in Excel sheet data to be output.

Images