JP2012098878A - Business form creation processing system and business form creation processing method and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To enable even a user who does not have the specialized knowledge of a system to easily create a business form by observing a fixed procedure.SOLUTION: A computer device includes a business form definition processing part 104 and a business form issue processing part 105 in order to create a business form for service of an ASP server 101. A preliminarily created business form template 108 and definition information 109 in which respective data in the database of the ASP server to be output to respective items in the business form template 108 are associated with each other are stored in a storage device by the business form definition processing part 104, and the definition information 109 stored by the business form definition processing means 104 is analyzed in response to the input of the creation instruction of a business form by the business form issue processing part, and the respective data in a database 107 installed in the ASP server to be output to the respective items in the business form are extracted, and output so as to be associated with the respective items in the business form, and a business form whose creation has been instructed is created.

Description

  The present invention relates to a technology for creating a form to be used in an electronic procurement system by computer processing. In particular, in an ASP (Application Service Provider) type system using the Internet environment, there is a request specific to each user. The present invention relates to a technique suitable for efficiently creating a form having a layout corresponding to the above.

  In the case of an electronic procurement system, the form has various layouts depending on the user, and there are many requests for customization. For this reason, many customizations have occurred compared to the system standard provided forms.

  As a technique for creating and issuing such a form that requires customization by a user by computer processing, for example, there are those described in Patent Document 1 and Patent Document 2.

  Patent Document 1 specifies the problems of the prior art, that is, the range that can be customized in the past, as a technique for outputting a suitable form that can be applied to various kinds of work such as business management such as personnel management and salary calculation. Because it is restricted by the information of the product and is not considered for changes due to version upgrade of package software, it solves the problem that customization work requires a lot of time and effort, and the work burden of users related to form customization A technique is described that aims to provide a form creation system that can significantly reduce the above, can customize any function and information, and can follow the version upgrade.

  Specifically, in the form creation system using the package software for form creation, the customization information for the output form is held as difference information for the package software, and the customization information thus held is stored in the package software. This is a technology for reflecting a change to package software after the change and outputting a customized form in which the change by the customization information is reflected when the package software is changed.

  According to this technology, it is possible to realize a form creation system that can be customized for any function and information by reducing the user's workload related to form customization and can follow up on version upgrades. In addition, since there is no need to customize the form at the time of version upgrade, the customized form program can be used without any additional work in response to changes due to revisions of laws and systems, or to the enhancement of functions by upgrading the package software. It becomes possible. In addition, by outputting the applied customization information or customization information that failed to be applied to the log, even if it is desired to change the customization content due to version upgrade, the current customization content can be easily confirmed. Furthermore, it is not necessary to be aware of the contents of customization when upgrading the form, and it is possible to confirm whether or not the customization has been correctly applied based on the output log when the form is created, when the form is printed, or the like.

  Japanese Patent Application Laid-Open No. 2004-228561 describes a technology that allows business data to be managed by a server in a form creation system, and the form layout can be customized according to the user's preference.

  Specifically, the client terminal is configured to access a Web (Web; World Wide Web) server apparatus via the Internet, and the client terminal is created with Excel (registered trademark) which is an existing table creation software. A program is installed, and a plurality of form template Excel files and a form layout position information file associated with the form file are stored. In addition, the Web server device includes a Web server that performs Web services and a database, the Web server is provided with a form data download function, a business database is provided as a database, and the client terminal can be accessed via the Internet. For example, the form data download function extracts form target data and sends it to the client terminal, which downloads and stores it in the recording device. Note that the form template Excel file and the form layout position information file stored in the recording device of the client terminal can be customized for the form with the data items to be displayed.

  In such a form creation system, the form creation program is started on the client terminal, the form type is selected, the form data file downloaded from the Web server is selected, and the form creation is performed. Copy the stored form template file to the form output Excel file, repeat as many times as the number of forms in the form data file, copy and create the form template sheet, and store it in the client's recording device By embedding each item of the form data file at the position of each data item designated by the form layout position information file, forms of the same layout are created for the number of downloaded data.

  According to this technology, business data processing and business data management are performed by the server, but the layout of the form can be customized by the table creation software according to the user's preference. For example, CJK Kanji (Chinese Kanji, Japanese Kanji, Korean It is possible to create a form that does not become garbled even if Kanji characters are mixed.

  Furthermore, in recent years, for example, Patent Documents 3 to 5 disclose techniques for creating various forms by using a system using ASP, which is an Internet network service.

  In Patent Document 3, by using a system using ASP, a home support establishment, a designated care service provision establishment, a service user, and an attending physician who are involved in a service by care insurance can obtain documents by ID (identification information) or PW (Password) is shared under the management, and the technology that makes it easy to exchange information on the web, and the technology that makes a receipt document from the same document and makes it a document that is correct Yes.

  Traditionally, care insurance services are based on the cooperation of home care support establishments, designated care service establishments, service users (its family members), physicians, and governments. However, the technology described in the above-mentioned Patent Document 3 has a problem that the documents and information are owned and provided only when necessary by telephone or fax, and the receipt documents do not match. Then, since the web is used, each information agency can immediately check necessary information.

  Patent Document 4 saves time and effort for claiming insurance claims, and even documents that require high security such as insurance contracts can be easily exchanged via a network. Issuance technology that exchanges forms among ASP service company systems, insurance company systems, and insurance contractor terminals connected to each other via a network for the purpose of enabling easy form issuance, that is, ASP services In the company system, at least the policyholder information for identifying the policyholder and the signature data of the ASP service company are embedded in the policyholder terminal with the form data embedded in a substitute expression that cannot be read by a third party. The insurance policyholder terminal prints the form data, writes the prescribed items, and insures To the company system, and the insurance company system reads the form on which the prescribed items are written, sends it to the ASP service company system, and verifies the signature data and detects the policyholder information in the ASP service company system. A technique for transmitting the verification result and the detection result to the insurance company system is described.

  Further, in Patent Document 5, as a technology related to a computer system that realizes an inter-company electronic commerce, only the data that can be captured digitally by the core system of a small and medium-sized company is captured. A technology that makes it possible to respond to various EDI specifications of buyer companies by printing out specified forms, that is, buyer-transmitted EDI documents transmitted from buyer company ASP connection terminals are converted into ASP-translated XML-EDI documents using an EDI conversion dictionary. Converted, re-converted into supplier-delivered XML-EDI document under the conditions specified by the supplier company, distributed to the supplier company ASP connection terminal, and the buyer in the specified form format style sheet of the buyer company managed by the specified form printing ASP Outputs form print file crowded difference the signal EDI document, a technology for printing on a printer connected to the supplier company ASP connection terminal is described.

  In this way, the electronic procurement system is currently being adapted to the ASP type. However, in an ASP-type electronic procurement system, it is desired to respond more efficiently to individual user requests for forms.

JP 2007-122670 A JP 2010-039590 A JP 2003-108669 A JP 2004-178424 A JP 2010-129071 A

  The problem to be solved is that in the conventional technology, an ASP-type electronic procurement system cannot sufficiently efficiently create a form with a layout corresponding to each user's request.

  An object of the present invention is to solve these problems of the prior art and enable a user without system expertise to easily create a form by following a certain procedure.

  In order to achieve the above object, according to the present invention, as a function for executing a computer process programmed in a computer device in order to create a form used when using a service provided by an ASP server via the Internet. The form definition processing unit and the form issue processing unit are provided, and the form definition processing unit associates the form template created in advance with each data in the database of the ASP server that outputs to each item in the form template. Information is stored in the storage device, and the form issuing processing unit analyzes the definition information stored in the form definition processing unit in response to the input of the form creation instruction and outputs it to each item in the form Each data in the database to be extracted and associated with each item of the form. And, characterized in that to create a form that has been instructed created.

  According to the present invention, even a user who does not have expertise in a system can easily create a form by following a certain procedure. In addition, the user (user) can specify output items and output formats, and the output can be as high as a system standard provided form.

It is a block diagram which shows the structural example of the form creation apparatus of the electronic procurement system which concerns on this invention. It is a flowchart which shows the processing operation example of the form definition process part in FIG. It is a flowchart which shows the processing operation example of the form issue process part in FIG. It is explanatory drawing which shows the example of a screen structure which the form preparation apparatus in FIG. 1 displays. It is explanatory drawing which shows the function structural example of the form definition process part in FIG. It is explanatory drawing which shows the process structural example of the form issue process part in FIG. It is explanatory drawing which shows the content item example of the edit process which the form preparation apparatus in FIG. 1 performs. It is explanatory drawing which shows the structural example of definition information DB in FIG.

  Hereinafter, embodiments for carrying out the present invention will be described with reference to the drawings. In FIG. 1, 101 is an electronic procurement ASP server, 103a and 103b are orderer user terminals, each of which includes a CPU (Central Processing Unit), a main memory, a display device, an input device, an external storage device, etc. After installing a program and data recorded in a storage medium such as a CD-ROM via an optical disk drive or the like into the external storage device, the program and data from the external storage device are stored in the main memory. Each process related to the form creation processing system of the present invention is executed by processing by the reading CPU.

  The electronic procurement ASP server 101 includes an EUC form system 102 and an electronic procurement ASP system 106 as functions for executing programmed computer processing. The EUC form system 102 includes a form definition processing unit 104 and a form issue processing unit. 105 and a definition information DB 109, and the form template 108 is stored and managed using a storage device.

  The electronic procurement ASP system 106 stores and manages the case information 107a, the vendor information 107b, the bid book information 107c, and the bid opening result information 107d using a database device (described as “DB” in the figure) 107.

  The orderer use terminals 103a and 103b access the electronic procurement ASP server 101 via the Internet 111, and create an output form 110 using the EUC form system 102 and the electronic procurement ASP system 106 in the electronic procurement ASP server 101. I do.

  With such a configuration, in the form creation processing system according to the present invention, by operating the orderer use terminals 103a and 103b, even a user who does not have system expertise can easily follow certain procedures. In addition, a user-specific form can be created.

  That is, in the form creation processing system of this example, the users of the orderer use terminals 103a and 103b are used when using the service provided by the electronic procurement ASP system 106 in the electronic procurement ASP server 101 via the Internet 111. In order to create a form (output form 110), the electronic procurement ASP server 101 as a computer apparatus is provided with a form definition processing unit 104 and a form issue processing unit 105 as functions for executing programmed computer processing. The definition processing unit 104 includes a form template 108 created in advance by the operator at the orderer using terminals 103a and 103b, and an electronic procurement ASP system 106 in the electronic procurement ASP server 101 that outputs to each item in the form template 108. Database Definition information (definition information DB 109) associated with each data (107a to 107d) in the storage 107 is stored in the storage device, and the form issuance processing unit 105 uses the form (output form 110) from the orderer use terminals 103a and 103b. In response to the input of the creation instruction, the definition information in the definition information DB 109 stored in the form definition processing unit 104 is analyzed, and each data (107a to 107d) in the database 107 is output to each item in the form (output form 110). ) Are extracted and output in association with each item of the form (output form 110) to create a form instructed to create.

  Thereby, even in an ASP type system, it is possible to easily realize a form output corresponding to individual needs for each user / user without SE (). In addition, since each of the business application and the form tool is in an independent form via the definition file, it is versatile.

  Hereinafter, the form creation processing system having such a configuration will be described more specifically.

  In the form creation processing system shown in FIG. 1, the orderer use terminals 103a and 103b operated by the orderer are connected to the electronic procurement ASP server 101 via the Internet 111, and the orderer and the user are the orderer. The electronic procurement ASP system 106 is used by operating the use terminals 103a and 103b.

  Since the output form provided as a standard of the electronic procurement ASP system 106 cannot cope with individual requirements of the ordering party, the electronic procurement ASP server 101 is provided with an EUC type form system 102, and the functions of this EUC type form system 102 are provided. Using it, the orderer defines and issues a form.

  The EUC form system 102 is composed of two subsystems, a form definition processing unit 104 and a form issue processing unit 105.

  The form definition processing unit 104 adds which item in the DB 107 of the electronic procurement ASP system 106 to the output tag information of the form template 108 created by the orderer using software such as Excel (registered trademark) in the orderer use terminals 103a and 103b. Is executed to define the information for associating whether to output and the editing contents of each item. Information defined by the orderer use terminals 103a and 193b, which is the processing execution result of the form definition processing unit 104, is stored in the definition information DB 109.

  When the form issuance processing unit 105 receives a form issuance request from the orderer use terminals 103 a and 103 b based on the orderer's operation, the form issuance processing unit 105 analyzes the contents of the definition information DB 109 and necessary items from the DB 107 of the electronic procurement ASP system 106. , The designated data is set at the output tag position of the form template 108 to generate an output form, and the output form 110 is provided by transmitting to the orderer using terminals 103a and 103b via the Internet 111.

  Hereinafter, the contents of the form definition process of the form definition processing unit 104 will be described with reference to FIG.

  As advance preparation, for example, the layout and definition information of the form created by the orderer in the orderer using terminal 103a are received via the Internet 111 and registered as the form template 108 and the definition information DB 109 (step 201).

  The user uses Excel (registered trademark) or other software to specify a basic layout, heading, fixed wording, ruled line, font, font size, etc., create a form template, and output data as definition information For setting the position, software such as “ExCella Reports” is used.

  This "ExCella Reports" is open source software provided by Being System Co., Ltd., which can operate Excel (registered trademark) from Java (registered trademark), and specify the association between form data and output tags. Replace with the tag position defined by Excel (registered trademark).

  In addition, in the definition information DB 109, each information such as the form ID, form name, Excel template file name, storage location, etc. designated in the orderer using terminals 103a and 130b is used as form management information of item number 6 shown in FIG. Store.

  In this state, the form definition processing unit 104 first reads the system configuration information of item number 1 in the definition information DB shown in FIG. 8 (step 202), and item number 2 in the definition information DB shown in FIG. 8 of the corresponding system. The DB configuration information is read (step 203).

  Next, the form template of item number 5 shown in FIG. 8 is read, and the output tag information is acquired (step 204).

  The table name of the DB configuration information acquired in this way, the items that can be used in the table, and the information of the output tag of the form template are transmitted to the orderer use terminal 103a and displayed on the screen of the orderer use terminal 103a. (Step 205), the orderer who operates the orderer use terminal 103a is caused to specify which item is to be output to the output tag (Step 206). If necessary, the editing contents of the output items shown in FIG. 7 are also specified (step 207).

  The items set in the orderer use terminal 103a are output to the form definition information of item number 2 shown in FIG. 8 in the definition information DB 109 (step 208).

  FIG. 4 shows an example of a screen configuration (form output item definition screen) displayed on the screen of the orderer using terminal 103a by such processing, and FIG. 5 shows a functional hierarchy diagram of the form definition processing unit 104.

  The form output item definition screen in FIG. 4 includes a form ID field for inputting form identification information, a form name field for inputting a form name, and a table field for specifically inputting a database table in which data used for creating the form is registered. A list of items that can be used in the selected table showing a list of items that can be used in the table selected in this table column, each item in the item column that can be used in this selected table, and a form template displayed in an overlapping manner The output definition field for inputting each item selected from (Excel (registered trademark) template), and the operator (orderer) of the orderer using terminal 103a can select / select using the form output item definition screen. By performing the input operation, the database for each item in the form template (Excel (registered trademark) template) is stored. We can associate with the data in.

  As shown in FIG. 5, the form definition processing unit 104 has a standard form definition function and an atypical form definition function, and has an Excel (registered trademark) template registration function and an output definition function as the standard form definition function. It has an output item selection function as an atypical form definition function, and the output definition function in the standard form definition function has an output item selection function, an output position mapping function, and an output editing function. Excel (registered trademark) template The registration function generates and registers form management information and Excel (registered trademark) templates, and forms definition information is generated by the output definition function and the non-standard form definition function.

  Further, as shown in FIG. 7, the editing content information of the output item is managed as an editing item configuration, and has a table configuration including item number, editing pattern, and editing content items. Is registered with respect to the editing pattern “change the output contents according to the classification”, “change the heading item of the form or the fixed wording according to the classification”. By using such editing item configuration information, it is possible to perform editing processing such as adding an edited character string before and after the item, changing the name of the code, date / time Japanese calendar conversion, and linking a plurality of items.

  Next, the processing operation of the form issue processing unit 105 will be described with reference to FIG.

  For example, when the form issue operation is selected in the orderer using terminal 103a, the form issue processing unit 105 is activated, and the form issue processing unit 105 performs a preparation process from the definition information DB 109 to the system configuration in item number 1 in FIG. Reading information (step 301), reading DB configuration information in item number 2 in FIG. 8 (step 302), reading form output screen configuration information in item number 3 in FIG. 8 (step 303), item number in FIG. Each of the reading of the form template in step 5 (step 304) and the reading of the form definition information in item number 4 in FIG. 8 (step 305) are sequentially performed to sequentially acquire basic information necessary for issuing.

  When the acquisition of basic information is completed in this way, the form issuance processing unit 105 generates a form output condition designation screen based on the form output screen configuration information in item number 3 in FIG. The information is displayed on the terminal 103a and the orderer is made to input the output conditions (step 305).

  The conditions input in this way are passed to the output data acquisition process in the next step 306, and the following process is performed in this output data acquisition process.

  First, the form issuance processing unit 105 generates a search sentence for extraction. The necessary items in the form are analyzed from the form definition information in item number 4 in FIG. In order to obtain necessary items, a base SQL sentence is selected from the DB configuration information in item number 2 in FIG. 8, and a search sentence is generated in combination with the output condition created in step 306.

  Next, the form issuance processing unit 105 refers to the DB configuration information in item number 2 in FIG. 8, connects to the database based on the connection information to the defined database, executes a search statement, and acquires data. (Step 307).

  If the data acquisition is completed by the processing in step 307, the form issuance processing unit 105 adds the acquired data to the form template read in step 304 in the form definition information in item number 4 in FIG. Is set in the book table template in accordance with the mapping rule indicated by the mapping definition information (step 308). For this mapping, open source software compatible with Excel (registered trademark) tag output is used.

  If the item definition is specified in the form definition information in item number 4 in FIG. 8 during the set process in step 308, the form issuance processing unit 105 performs edit output according to the editing content.

  Thereafter, the form issue processing unit 105 transmits the completed form table to the orderer using terminal 103a via the Internet 111 (step 309).

  FIG. 6 shows an image of the processing function of the book table issuance processing unit 105. As shown in FIG. 6, the form issuance processing unit 105 has a fixed form output function and a non-standard form output function, and the fixed form input from the orderer using terminals (103a, 103b) by the fixed form output function. In accordance with the output instruction and the search condition, by using the function of ExCella Reports, the DB configuration information, the form output instruction screen configuration information, the form definition information, the form template, and the database 107 provided in the electronic procurement ASP system 106 A form is created from each of the data, and the DB configuration information, form output instruction screen according to the atypical form output instruction and the search condition input from the orderer using terminal (103a, 103b) by the atypical form output function Configuration information, form definition information, and each in the database 107 provided in the electronic procurement ASP system 106 From over data, to create a form.

  As described above with reference to FIGS. 1 to 8, the EUC form system 102 as the form issue processing system of this example is that the orderer using terminals (client terminals) 103 a and 103 b are electronically procured via the Internet 111. A form used to use a service provided by the electronic procurement ASP system 106 installed in the ASP server 101 is created by a programmed computer process, and a form definition is provided as a function for executing the programmed computer process. The form definition processing unit 104 includes a processing unit 104 and a form issuance processing unit 105. The form definition processing unit 104 includes a form template 108 created in advance in the orderer using terminals (client terminals) 103a and 103b, and items in the form template 108. Electronic procurement ASP system to output 106, the definition information DB 109 in which each data (the case information 107a, the trader information 107b, the bid book information 107c, and the bid opening result information 107d) in the database 107 is received via the Internet and stored in the storage device. When the form issuance processing unit 105 receives an instruction to create a form via the orderer using terminals (client terminals) 103a and 103b via the Internet 111, it analyzes each information in the definition information DB 109 stored in the form definition processing unit 104. Then, each data (item information 107a, trader information 107b, bid book information 107c, bid opening result information 107d) in the database 107 to be output to each item in the instructed form is extracted and associated with each item in the form. To create a form instructed to create.

  Note that the form template 108 is created by the manual operation of the orderer using terminals 103a and 103b using Excel (registered trademark), and the information in the definition information DB 109 is the manual orderer using terminal 103a using ExCella Reports. , 103b, the position of each tag defined on each item of the form template 108 and each data in the database 107 (case information 107a, supplier information 107b, bid information 107c, bid opening result information 107d) It is associated.

  The definition information in the definition information DB 109 is used to specify the system including the name of a system (service system) that provides each service created in advance on the electronic procurement ASP system 106 executed by the electronic procurement ASP server 101. DB configuration information including system configuration information to be used, connection information to the database used in each service system, table name to be provided to the user, SQL sentence used in the database, and item name to be provided to the user, Form output screen configuration information including screen definition for each service system, item definition of search condition, definition of association between search condition and DB, and definition of parameter information delivered to form output program used in each service system, and The creator of the form template 108, that is, the orderer use Form definition information including output item designation definition information, mapping definition information to output position, and parameter information definition information delivered to the form output program for each form, created for each form, and each form Form template information including form format definition information and tag setting information to the data output position, form identification information, form name definition information, form template file name, and form template storage location for each service system It consists of form management information including information.

  Then, the form definition processing unit 104 reads the system configuration information, identifies the service system that uses the form to be created, reads the DB configuration information of the identified service system, and the form template of the form to be created. The table name and the items that can be used in the table, and the output tag information of the form template, and the output table information and the items that can be used in the table and the information of the output tag of the form template are used for each output tag. On the other hand, screen information for causing the user (orderer use terminals 103a and 103b) to set items to be output is generated and displayed, and each information in the definition information DB 109 is registered based on the setting result by the user.

  Further, the form issue processing unit 105 starts from the definition information of the definition information DB 109 at the start of issue of the form based on the instruction from the orderer using terminals 103a and 103b, and the system configuration information, DB configuration information, and form output screen configuration information. The form template and the form definition information are read, and based on the read form output screen configuration information, a screen for allowing the form user to input an output condition for each item of the form is generated and the orderer using terminal 103a, When the output condition is input to the orderer using terminals 103a and 103b via this screen, the necessary items are specified by referring to the read form definition information and specifying the necessary items. A search sentence necessary for acquiring an item is generated by combining a base SQL sentence selected from the read DB configuration information and an output condition, and read. Based on the connection information to the database defined in the database configuration information, the database is connected to the database, the generated search statement is executed to acquire the data, and the acquired data is mapped to the mapping definition information in the form definition information. Is set in the read form template (108) in accordance with the mapping rule indicated by.

  Further, the form definition information shown in FIG. 8 defines the output contents of the data of each item created by the creator of the form template 108 using the screens of the orderer use terminals 103a and 103b. The form definition processing unit 104 stores the form definition information in which the output item edit definition information is registered in the storage device (definition information DB 109), and the form issuance processing unit 105 obtains the information. If the output item edit definition information is specified in the form definition information for the set item of the data set, the data is edited according to the specified contents of the output item edit definition information and then set in the form template.

  As a result, according to the form creation processing system of this example, even a user who does not have specialized knowledge regarding the electronic procurement ASP system 106 can easily create a form by following certain procedures. In addition, the user (user) can specify output items and output formats, and the output can be as high as a system standard provided form. Further, it is possible to easily add new forms and change existing forms. Further, it can be implemented without installing a separate program in the client terminal (orderer use terminal 103a, 103b) that uses the service. Further, independence between the business application (electronic procurement ASP system 106) and the form tool (EUC form system 102) is ensured. In addition, if connection information to the database (definition information DB 109) is changed, there is a certain degree of versatility so that it can be applied to other systems.

  In addition, this invention is not limited to the example demonstrated using FIGS. 1-8, In the range which does not deviate from the summary, various changes are possible. For example, in this example, the EUC form system 102 that executes the processing according to the present invention is configured to be mounted on the electronic procurement ASP server 101 in which the electronic procurement ASP system 106 is installed. It is good also as a structure mounted in the computer apparatus different from the electronic procurement ASP server 101 in which the electronic procurement ASP system 106 was mounted.

  The computer configuration of this example may be a computer configuration without a keyboard or optical disk drive. In this example, an optical disk is used as a recording medium. However, an FD (Flexible Disk) or the like may be used as a recording medium. As for the program installation, the program may be downloaded and installed via a network via a communication device.

  101: Electronic procurement ASP server, 102: EUC form system, 103a, 103b: Ordering user terminal, 104: Form definition processing unit, 105: Form issue processing unit, 106: Electronic procurement ASP system, 107: Database (DB) 107a: case information, 107b: vendor information, 107c: bid information, 107d: bid opening result information, 108: form template, 109: definition information DB, 110: output form, 111: Internet.

Claims (11)

A form creation processing system for creating a form to be used when using a service provided by an ASP (Application Service Provider) server via the Internet by programmed computer processing,
As a means of performing programmed computer processing,
A form definition processing means for storing, in a storage device, a pre-created form template and definition information in which each data in the database provided in the ASP server to be output to each item in the form template is associated;
In response to an input of a form creation instruction, the definition information stored by the form definition processing means is analyzed, each data in the database provided in the ASP server that is output to each item in the form is extracted, and the form A form creation processing system comprising: a form issuance processing means for creating a form instructed to output in association with each item. A form creation processing system for creating a form to be used when a client terminal uses a service provided by an ASP (Application Service Provider) server via the Internet by programmed computer processing,
A form template created in advance in the client terminal and definition information that associates each data in the database provided in the ASP server that is output to each item in the form template are received via the Internet and stored. Form definition processing means stored in the device;
When a form creation instruction is received from the client terminal via the Internet,
Analyzing the definition information stored by the form definition processing means, extracting each data in the database provided in the ASP server to be output to each item in the instructed form, and associating it with each item of the form And a form issuing processing means for generating a form instructed to generate a form creation processing system. The form creation processing system according to claim 1 or 2,
The form template is created by manual operation using Excel (registered trademark),
The definition information is a form creation processing system in which the position of each tag defined on each item of the form template is associated with the data in the database by a manual operation using ExCella Reports. . The form creation processing system according to any one of claims 1 to 3,
The above definition information
Created in advance on the ASP server side,
System configuration information used to identify the system including the name of the system that provides each service (service system);
DB configuration information used in each service system, including database connection information, table names provided to users, SQL statements used in the databases, and names of items provided to users;
Form output screen configuration information including screen definition for each service system, item definition of search condition, definition of association between search condition and DB, and definition of parameter information delivered to form output program used in each service system,
Created by the creator of the above form template,
For each form, form definition information including output item designation definition information, mapping definition information to output position, and parameter information definition information delivered to the form output program,
Form template information including form format definition information and tag setting information to the data output position for each form,
It consists of form management information including form identification information, form name definition information, form template file name, form template storage location information for each service system,
The form definition processing means
The system configuration information is read, the service system that uses the form to be created is specified, the DB configuration information of the identified service system and the form template of the form to be created are read, and can be used in the table name and table of the DB configuration information Get output tag information of items and form templates,
Using the acquired table name, the items that can be used in the table, and the output tag information of the form template, the screen information that allows the user to set the items to be output for each output tag is generated and displayed.
Register each information in the form definition information based on the setting result by the user,
The form issuing processing means is
Read the system configuration information, DB configuration information, form output screen configuration information, form template, and form definition information from the above definition information at the start of form issuance.
Based on the read form output screen configuration information, generate and display a screen that allows the user of the form to input the output conditions for each item of the form,
When the output condition is input via the screen, the necessary information in the form is identified with reference to the read form definition information, and the search sentence necessary for acquiring the identified necessary item is Generate a combination of the SQL statement that is the base selected from the read DB configuration information and the output condition,
Based on the connection information to the database defined in the read DB configuration information, connect to the database, execute the generated search statement to acquire data,
A form creation processing system characterized in that the acquired data is set in the read form template in accordance with a mapping rule indicated by mapping definition information in the form definition information. The form creation processing system according to claim 4,
The form definition information includes output item edit definition information that defines the output contents of the data of each item, which is created using the screen on the form template creator side,
The form definition processing means
Storing the form definition information in which the creator of the form template registers the output item edit definition information created using the screen in a storage device;
The form issuing processing means is
If the output item edit definition information is specified in the form definition information for the acquired data set destination item, the data is edited according to the contents of the output item edit definition information, and then the form template is displayed. A form creation processing system characterized by performing a set.   The program for functioning a computer as each means in the form preparation processing system in any one of Claims 1-5. A form creation processing method for creating a form to be used when using a service provided by an ASP (Application Service Provider) server via the Internet by programmed processing by a computer device,
The computer apparatus comprises a form definition processing means and a form issue processing means as means for executing programmed computer processing,
The form definition processing means
A pre-created form template and definition information in which each data in the database provided in the ASP server to be output to each item in the form template is stored in a storage device,
The form issuing processing means is
In response to an input of a form creation instruction, the definition information stored by the form definition processing means is analyzed, each data in the database provided in the ASP server that is output to each item in the form is extracted, and the form A form creation processing method characterized in that a form instructed to be created is output in association with each item. A form creation processing method in which a form used when a client terminal uses a service provided by an ASP (Application Service Provider) server via the Internet is created by programmed processing by a computer device,
The computer apparatus comprises a form definition processing means and a form issue processing means as means for executing programmed computer processing,
The form definition processing means
A form template created in advance in the client terminal and definition information that associates each data in the database provided in the ASP server that is output to each item in the form template are received via the Internet and stored. Stored in the device,
The form issuing processing means is
When a form creation instruction is received from the client terminal via the Internet,
Analyzing the definition information stored by the form definition processing means, extracting each data in the database provided in the ASP server to be output to each item in the instructed form, and associating it with each item of the form The form creation processing method is characterized in that a form instructed for creation is created. A form creation processing method according to claim 7 or claim 8,
The form template is created by manual operation using Excel (registered trademark),
The definition information is a form creation processing method characterized in that the position of each tag defined on each item of the form template and the data in the database are associated with each other by manual operation using ExCella Reports. . A form creation processing method according to any one of claims 7 to 9,
The above definition information
Created in advance on the ASP server side,
System configuration information used to identify the system including the name of the system that provides each service (service system);
DB configuration information used in each service system, including database connection information, table names provided to users, SQL statements used in the databases, and names of items provided to users;
Form output screen configuration information including screen definition for each service system, item definition of search condition, definition of association between search condition and DB, and definition of parameter information delivered to form output program used in each service system,
Created by the creator of the above form template,
For each form, form definition information including output item designation definition information, mapping definition information to output position, and parameter information definition information delivered to the form output program,
Form template information including form format definition information and tag setting information to the data output position for each form,
It consists of form management information including form identification information, form name definition information, form template file name, form template storage location information for each service system,
The form definition processing means
The system configuration information is read, the service system that uses the form to be created is specified, the DB configuration information of the identified service system and the form template of the form to be created are read, and can be used in the table name and table of the DB configuration information Get output tag information of items and form templates,
Using the acquired table name, the items that can be used in the table, and the output tag information of the form template, the screen information that allows the user to set the items to be output for each output tag is generated and displayed.
Register each information in the form definition information based on the setting result by the user,
The form issuing processing means is
Read the system configuration information, DB configuration information, form output screen configuration information, form template, and form definition information from the above definition information at the start of form issuance.
Based on the read form output screen configuration information, generate and display a screen that allows the user of the form to input the output conditions for each item of the form,
When the output condition is input via the screen, the necessary information in the form is identified with reference to the read form definition information, and the search sentence necessary for acquiring the identified necessary item is Generate a combination of the SQL statement that is the base selected from the read DB configuration information and the output condition,
Based on the connection information to the database defined in the read DB configuration information, connect to the database, execute the generated search statement to acquire data,
A form creation processing method, wherein the acquired data is set in the read form template according to a mapping rule indicated by mapping definition information in the form definition information. The form creation processing method according to claim 10,
The form definition information includes output item edit definition information that defines the output contents of the data of each item, which is created using the screen on the form template creator side,
The form definition processing means
Storing the form definition information in which the creator of the form template registers the output item edit definition information created using the screen in a storage device;
The form issuing processing means is
If the output item edit definition information is specified in the form definition information for the acquired data set destination item, the data is edited according to the contents of the output item edit definition information, and then the form template is displayed. A form creation processing method characterized by performing a set.

Images