JP6442962B2 - Form generation program and form generation apparatus - Google Patents

Description

  The present invention relates to a form generation program, a form generation method, and a form generation apparatus.

  Conventionally, there is a technique in which a user selects a data item to be included in form data, and a computer generates form data suitable for the user's purpose based on source data of the selected data item.

  As related prior art, for example, information that specifies a form and a user who can output the form are stored in association with each other, and a list of forms that the user can output is displayed on the terminal device of the user. There is a technology to display.

JP 2012-118677 A

  However, with the conventional technology, it may be difficult to generate form data that meets the purpose of the user. For example, the user may take a long time to select an appropriate data item or may not be able to find an appropriate data item. For this reason, it may be difficult to generate form data suitable for the purpose of the user.

  In one aspect, an object of the present invention is to provide a form generation program, a form generation method, and a form generation apparatus that can support generation of form data suitable for a user's purpose.

  According to one aspect of the present invention, when the group information to which the user belongs is acquired from the login information of the user and the specification of the keyword corresponding to the data item to be included in the form data is received, the data corresponding to the specified keyword Of the source data having items, the source data referred to by the users belonging to the group indicated by the acquired group information based on the reference record information of the source data when generating the form data stored in the storage unit A form generation program, a form generation method, and a form generation apparatus for generating form data based on the specified source data are proposed.

  According to one aspect of the present invention, there is an effect that it is possible to support generation of form data suitable for a user's purpose.

FIG. 1 is an explanatory diagram of an example of the form generation apparatus 101 according to the embodiment. FIG. 2 is a block diagram of a hardware configuration example of the form generation apparatus 101 according to the embodiment. FIG. 3 is an explanatory diagram of an example of the keyword link table 301 according to the embodiment. FIG. 4 is an explanatory diagram of an example of the partial code link table 401 according to the embodiment. FIG. 5 is an explanatory diagram of an example of the table link table 501 according to the embodiment. FIG. 6 is an explanatory diagram of an example of the counter table 601 according to the embodiment. FIG. 7 is an explanatory diagram of an example of the sales table A701 according to the embodiment. FIG. 8 is an explanatory diagram of an example of a sales table B801 according to the embodiment. FIG. 9 is an explanatory diagram illustrating an example of a guide selection screen 901 of the form generation device 101 according to the embodiment. FIG. 10 is an explanatory diagram illustrating an example of a guide screen 1001 of the form generation device 101 according to the embodiment. FIG. 11 is an explanatory diagram illustrating an example of a form screen 1101 of the form generation apparatus 101 according to the embodiment. FIG. 12 is an explanatory diagram illustrating an example of the item selection screen 1201 of the form generation device 101 according to the embodiment. FIG. 13 is an explanatory diagram illustrating an example of a form screen 1301 of the form generation apparatus 101 according to the embodiment. FIG. 14 is a block diagram of a functional configuration example of the form generation device 101 according to the embodiment. FIG. 15 is a flowchart (part 1) illustrating an example of a form generation processing procedure of the form generation apparatus 101 according to the embodiment. FIG. 16 is a flowchart (part 2) illustrating an example of a form generation processing procedure of the form generation apparatus 101 according to the embodiment.

  Hereinafter, embodiments of a form generation program, a form generation method, and a form generation apparatus according to the present invention will be described in detail with reference to the drawings.

(Embodiment)
FIG. 1 is an explanatory diagram of an example of the form generation apparatus 101 according to the embodiment. In FIG. 1, a form generation apparatus 101 is a computer that generates form data upon receiving the specification of a keyword corresponding to a data item to be included in form data.

  Here, the form data is data of a book, a book, and a slip that are used for cash balance, goods coming and going, and other paperwork. Specifically, for example, the form data is a table in which data is arranged in order in rows and columns. The data item is the name of the classified data when the data is classified according to a certain standard. Specifically, for example, when the data used when generating the form data is a table, the data item is a column name of the table. A keyword is a word or symbol that serves as an index for extracting data. Specifically, for example, the keyword is a character included in the data item.

  As described above, the user may take time to select an appropriate data item or may not be able to find an appropriate data item.

  In addition to this, some data items may be data items with different contents even though they have similar names. For example, the data item “sales amount” used in the sales system and the data item “sales record” used in the accounting system are data items that have different names but different contents. In this case, a user who is not accustomed to generating form data does not know which data item to select. As described above, the user may not be able to select an appropriate data item to be used for the form data. For this reason, it may be difficult for the prior art to generate form data suitable for the purpose of the user.

  Therefore, in the embodiment, the form generation device 101 is based on source data referred to by other users in the group to which the user belongs, among source data having data items corresponding to the keyword specified by the user. Generate form data. As described above, since the data item used by another user who is accustomed to generating the form data belonging to the same group is likely to be a data item that the user should use, the form generation device 101 is Form data suitable for the user's purpose can be easily generated. Hereinafter, the form generation of the form generation apparatus 101 will be described.

  (1) The form generation device 101 acquires group information to which the user belongs from the login information of the user. For example, the form generation apparatus 101 may acquire a user ID (Identity Document) from the user login information, and acquire the user group information from a table in which the user ID and the group information are associated with each other. it can.

  Here, the group information is an identifier for specifying a group. For example, when the group is a part, it is an identifier for specifying the part. The login information is information indicating that the user has the right to use the form generation device 101. For example, the login information includes a user ID and a password. The user ID is a code used to indicate the identity and legal qualification of the user.

  In the example of FIG. 1, the form generation device 101 acquires the group information “sales system” to which the user belongs from the login information of the user.

  (2) The form generation device 101 accepts designation of a keyword corresponding to a data item to be included in form data. For example, the form generation device 101 can accept a keyword specification by displaying a keyword on a display device such as a display and selecting a keyword displayed by the user. Here, the form generation device 101 can make the keyword easy-to-understand characters. For example, the form generation device 101 can set the keyword as a character included in the corresponding data item.

  In the example of FIG. 1, the form generation device 101 accepts designation of the keyword “sales”. Here, the keyword “sales” is a keyword corresponding to the data items “sales amount” and “sales record”.

  (3) The form generation device 101 identifies source data having a data item corresponding to the designated keyword. For example, the form generation apparatus 101 can specify source data from the table 111 that associates a keyword with source data having a data item corresponding to the keyword. Here, the source data is data used when generating form data. For example, the source data is a table including data items to be included in the form data.

  In the example of FIG. 1, the form generation device 101 specifies source data “sales table A” and “sales table B” from a table 111 that associates a keyword with source data having a data item corresponding to the keyword. . Here, the sales table A is a table having a data item “sales amount” corresponding to the keyword “sales”, and the sales table B is a table having a data item “sales record” corresponding to the keyword “sales”. .

  (4) Based on the reference record information 112, the form generation device 101 identifies source data referred to by users belonging to the group indicated by the group information. Here, the reference record information 112 is information that is stored in the storage unit of the form generation device 101 and indicates source data referred to by a user belonging to the group indicated by the group information when generating the form data. For example, the reference performance information 112 is information in which group information is associated with source data referred to by a user belonging to the group indicated by the group information.

  In the example of FIG. 1, the form generation apparatus 101 has source data “sales table A” and “business negotiation information” that are referred to by users belonging to the group indicated by the group information “sales” based on the reference record information 112. And “customer table”.

  (5) The form generation device 101 generates form data from source data referred to by users belonging to the group indicated by the group information among the source data having data items corresponding to the designated keyword.

  In the example of FIG. 1, source data having data items corresponding to the designated keyword are “sales table A” and “sales table B”. The source data referred to by users belonging to the group indicated by the group information “sales system” are “sales table A”, “business negotiation information”, and “customer table”. Therefore, the form generation device 101 generates form data from the source data “sales table A”.

  As described above, the form generation device 101 acquires group information to which the user belongs from the login information of the user, and accepts designation of keywords corresponding to data items to be included in the form data. The form generation device 101 identifies the source data referred to by the users belonging to the group indicated by the group information, based on the reference record information 112, among the source data having data items corresponding to the specified keyword. The form generation device 101 generates form data based on the identified source data.

  Thereby, the form generation device 101 can generate form data without causing the user to select a data item. Therefore, the form generation device 101 can easily generate form data suitable for the user's purpose.

(Hardware configuration example of the form generation device 101)
FIG. 2 is a block diagram of a hardware configuration example of the form generation apparatus 101 according to the embodiment. In FIG. 2, the form generation apparatus 101 includes a CPU (Central Processing Unit) 201, a memory 202, an I / F (Interface) 203, a disk drive 204, a disk 205, and a display 206. Each component is connected by a bus 200.

  Here, the CPU 201 governs overall control of the form generation device 101. The memory 202 includes, for example, a ROM (Read Only Memory), a RAM (Random Access Memory), and a flash ROM. Specifically, for example, a flash ROM or ROM stores various programs, and the RAM is used as a work area of the CPU 201 as a storage unit. The program stored in the memory 202 is loaded on the CPU 201 to cause the CPU 201 to execute the coded process.

  The I / F 203 is connected to a network 207 such as a LAN (Local Area Network), a WAN (Wide Area Network), and the Internet through a communication line, and is connected to another computer via the network 207. The I / F 203 controls an internal interface with the network 207 and controls input / output of data from other computers. For example, a modem or a LAN adapter may be employed as the I / F 203.

  The disk drive 204 controls reading / writing of data with respect to the disk 205 according to the control of the CPU 201. The disk 205 stores data written under the control of the disk drive 204. Examples of the disk 205 include a magnetic disk and an optical disk.

  A display 206 displays data such as a document, an image, and function information as well as a cursor, an icon, or a tool box. As the display 206, for example, a CRT, a TFT liquid crystal display, a plasma display, or the like can be adopted. The display 206 may be an input device that includes a touch panel and operates the device by pressing an icon or the like on the display 206.

  The form generation apparatus 101 may include, for example, an SSD (Solid State Drive), a keyboard, a mouse, and a printer in addition to the above-described components.

(Example of keyword link table 301)
FIG. 3 is an explanatory diagram of an example of the keyword link table 301 according to the embodiment. In FIG. 3, the keyword link table 301 of the form generation device 101 is created and updated by, for example, the form generation device 101 and stored in the memory 202 or the disk 205 of the form generation device 101. The keyword link table 301 corresponds to the table 111 that associates the keyword shown in FIG. 1 with source data having data items corresponding to the keyword.

  The keyword link table 301 has items of keyword, item name, and table name. The keyword link table 301 stores keyword link information (for example, keyword link information 301-1 to 301-4) as a record by setting information for each item.

  Here, the keyword is a word or symbol that becomes an index when data is extracted. Keywords can be registered with characters that are easy for the user to understand. The item name is an identifier for uniquely identifying an item included in the table, and the item name corresponding to the keyword is registered. The table name is an identifier for uniquely identifying the table, and a table name having an item name corresponding to the keyword is registered. Here, the table corresponds to the source data shown in FIG.

  In the example of FIG. 3, the record 301-1 indicates that the table name of the table having the item name “sales amount” corresponding to the keyword “sales” is “sales table A”.

(An example of the section code link table 401)
FIG. 4 is an explanatory diagram of an example of the partial code link table 401 according to the embodiment. In FIG. 4, the section code link table 401 of the form generation apparatus 101 is created and updated by, for example, the form generation apparatus 101 and stored in the memory 202 or the disk 205 of the form generation apparatus 101. The part code link table 401 and a table link table 501 described later correspond to the reference record information 112 shown in FIG.

  The part code link table 401 has items of a part code and a table type. The part code link table 401 stores part code link information (for example, part code link information 401-1 to 401-2) as a record by setting information in each item.

  Here, the department code is an identifier for uniquely identifying the group to which the user belongs, for example, the department. The table type is an identifier for uniquely specifying a set of tables distinguished by type and item. In the section code link table 401, the table type is an identifier for uniquely identifying a set of tables including tables referred to by users belonging to the group identified by the section code. For example, the sales system can be associated with the department code of the department that promotes sales, and the accounting system can be associated with the department code of the department that performs the management.

  Here, when the table type to which the table referred to by the user belonging to the group specified by the department code belongs is changed, the form generation device 101 can change the table type of the department code link table 401. For example, the form generation device 101 can change the table type of the partial code link table 401 based on the number of selections of a counter table 601 described later. The change of the table type of the partial code link table 401 will be described in detail with reference to FIG.

  In the example of FIG. 4, the record 401-1 includes a table referred to by a user belonging to the group specified by the department code “1111” in the set of tables specified by the table type “business type”. Indicates.

(An example of the table link table 501)
FIG. 5 is an explanatory diagram of an example of the table link table 501 according to the embodiment. In FIG. 5, the table link table 501 of the form generation device 101 is created and updated by, for example, the form generation device 101 and stored in the memory 202 or the disk 205 of the form generation device 101.

  The table link table 501 has items of table type and table name. The table link table 501 stores table link information (for example, table link information 501-1 to 501-n + 3) as a record by setting information in each item.

  Here, the table type is an identifier for uniquely specifying a set of tables distinguished by type and item. The table name is an identifier for uniquely specifying a table included in the set of tables specified by the table type.

  In the example of FIG. 5, the record 501-1 indicates that the set of tables specified by the table type “sales system” includes a table specified by the table name “sales table A”.

(An example of the counter table 601)
FIG. 6 is an explanatory diagram of an example of the counter table 601 according to the embodiment. In FIG. 6, the counter table 601 of the form generation device 101 is created and updated by, for example, the form generation device 101 and stored in the memory 202 or the disk 205 of the form generation device 101.

  The counter table 601 has items of table type, copy code, and number of selections. The counter table 601 stores counter information (for example, counter information 601-1 to 601-2) as a record by setting information for each item.

  Here, the table type is an identifier for uniquely specifying a set of tables distinguished by type and item. The department code is an identifier for uniquely identifying a group to which the user belongs, for example, a department. The number of times of selection is the number of times a user belonging to the group specified by the department code has selected a table item included in the set of tables specified by the table type. The selection of table items by the user will be described in detail on the item selection screen 1201 in FIG.

  Further, an initial value can be set for the number of selections based on the group specified by the copy code. For example, when the group specified by the department code is sales-related, the initial value of the selection count corresponding to the table type “sales-related” can be made larger than the initial value of the selection count corresponding to other table types. . In this case, for example, by making the initial value of the number of selections of the table type “sales system” maximum for the part code “1111”, the form generation apparatus 101 sets the table type of the part code link table 401 to the sales type. It can be made into a system. Therefore, the form generation device 101 can generate form data based on the items in the sales system table for the users belonging to the sales system group.

  In the example of FIG. 6, the record 601-1 includes ten times from the user who belongs to the group specified by the department code “1111” when the table item included in the set of tables specified by the table type “Accounting”. Indicates that it has been selected.

(Example of sales table A701)
FIG. 7 is an explanatory diagram of an example of the sales table A701 according to the embodiment. In FIG. 7, the sales table A 701 of the form generation device 101 is created and updated by, for example, the form generation device 101 and stored in the memory 202 or the disk 205 of the form generation device 101.

  The sales table A701 is an example of a table for generating form data, and is one of the tables belonging to the table type “sales system”. The sales table A701 has items of the fiscal year, order, and sales amount. The sales table A701 stores sales amount information (for example, sales amount information 701-1 to 701-3) as a record by setting information in each item.

  Here, the fiscal year indicates the fiscal year of sales. The order indicates the name of the system sold. The sales amount indicates the amount of sales. In the example of FIG. 7, record 701-1 indicates that sales of xxx were made in the A system in FY2014.

(Example of sales table B801)
FIG. 8 is an explanatory diagram of an example of a sales table B801 according to the embodiment. In FIG. 8, the sales table B801 of the form generation apparatus 101 is created and updated by the form generation apparatus 101 and stored in the memory 202 or the disk 205 of the form generation apparatus 101, for example.

  The sales table B801 is an example of a table for generating form data, and is one of the tables belonging to the table type “accounting system”. The sales table B801 has items of a fiscal year, an order, and a sales record. The sales table B801 stores sales performance information (for example, sales performance information 801-1 to 801-3) as records by setting information in each item.

  Here, the fiscal year indicates the fiscal year of sales. The order indicates the name of the system sold. The sales record indicates the actual sales amount. In the example of FIG. 8, the record 801-1 indicates that the sales result of XXX was in the A system in the 2014 fiscal year.

(Example of guide selection screen 901)
FIG. 9 is an explanatory diagram illustrating an example of a guide selection screen 901 of the form generation device 101 according to the embodiment. 9, a guide selection screen 901 of the form generation apparatus 101 is a screen that allows the user to select display of a guide screen 1001 (see FIG. 10) or an item selection screen 1201 (see FIG. 12). The guide selection screen 901 of the form generation apparatus 101 is created by the form generation apparatus 101 and displayed on the display 206 of the form generation apparatus 101, for example.

  The guide selection screen 901 has a guide screen button 911 and an item selection screen button 912. Here, the guide screen button 911 is a button for displaying a guide screen 1001 for generating form data without causing the user to select a data item. The guide screen button 911 is a button used when a user who is not used to generating form data, for example, generates form data. The item selection screen button 912 displays an item selection screen 1201 for generating form data on the basis of a table having data items selected by the form generation apparatus 101 by the user selecting data items to be included in the form data. It is a button for. The item selection screen button 912 is a button used when a user who is accustomed to generating form data, for example, can select necessary items by himself, when generating form data.

  For example, the form generation device 101 displays the guide screen 1001 when the guide screen button 911 is clicked with the mouse or when the guide screen button 911 is touched. Further, the form generation apparatus 101 displays an item selection screen 1201 when the item selection screen button 912 is clicked with the mouse or when the item selection screen button 912 is touched.

(An example of the guide screen 1001)
FIG. 10 is an explanatory diagram illustrating an example of a guide screen 1001 of the form generation device 101 according to the embodiment. In FIG. 10, a guide screen 1001 of the form generation device 101 is a screen that allows the user to select a keyword or the like. The guide screen 1001 of the form generation apparatus 101 is created by the form generation apparatus 101 and displayed on the display 206 of the form generation apparatus 101, for example.

  The guide screen 1001 has input items of a time item 1011, a department item 1012, and a keyword item 1013. A guide screen 1001 is a screen that realizes a guide function for generating form data without causing the user to select a data item. The input items are items for the user to input characters and character strings using a keyboard or the like. The guide screen 1001 includes a keyword list 1014 and an OK button 1015.

  Here, the time item 1011 is an item for designating a condition for specifying the table by, for example, the date and time when the table is generated and updated. The department item 1012 is an item for designating a condition for specifying the table by, for example, the department that generated and updated the table.

  The keyword item 1013 is an item for designating a condition for specifying a table by a keyword corresponding to the item of the table, for example. The keyword item 1013 can specify a plurality of keywords. For example, the form generation device 101 can cause a keyword to be input to the keyword item 1013 by dragging a keyword displayed on the keyword list 1014 and dropping it on the keyword item 1013. Further, it is possible to specify a condition only by the keyword item 1013 without specifying a condition for the time item 1011 and the department item 1012.

  The keyword list 1014 is an area for displaying keywords for inputting to the keyword item 1013. An OK button 1015 is a button for causing the form generation device 101 to acquire the input contents of the time item 1011, the department item 1012, and the keyword item 1013. For example, when the OK button 1015 is clicked or touched, the form generation device 101 specifies a table based on the input content, generates form data based on the specified table item, and includes the generated form data. A screen 1101 (see FIG. 11) is displayed on the display 206.

  In the example of FIG. 10, the guide screen 1001 indicates that “sales” and “cost” are displayed as keywords in the keyword list 1014, and the keyword “sales” is input to the keyword item 1013.

(An example of the form screen 1101)
FIG. 11 is an explanatory diagram illustrating an example of a form screen 1101 of the form generation apparatus 101 according to the embodiment. In FIG. 11, a form screen 1101 of the form generation apparatus 101 is a screen that displays the form data generated by the form generation apparatus 101. The form screen 1101 of the form generation apparatus 101 is created by the form generation apparatus 101 and displayed on the display 206 of the form generation apparatus 101, for example.

  The form screen 1101 displays form data generated based on the items in the table specified by the keyword input on the guide screen 1001.

  In the example of FIG. 11, the form screen 1101 is generated based on the item name “sales amount” of the table “sales table A701” specified by the keyword “sales” input to the guide screen 1001. Is displayed.

(An example of the item selection screen 1201)
FIG. 12 is an explanatory diagram illustrating an example of the item selection screen 1201 of the form generation device 101 according to the embodiment. In FIG. 12, an item selection screen 1201 of the form generation device 101 is a screen that allows the user to select an item name. The item selection screen 1201 of the form generation apparatus 101 is created by the form generation apparatus 101 and displayed on the display 206 of the form generation apparatus 101, for example.

  The item selection screen 1201 has an item name selection area 1211 and an OK button 1212. The item name selection area 1211 is an area for displaying the table name and the item name of the table included in the table and allowing the user to select an item name. For example, the user can select an item name by clicking or touching the displayed item name. Further, the form generation device 101 can display that the item name has been selected by checking the item name, for example, by displaying a cross on the left.

  An OK button 1212 is a button that causes the form generation device 101 to acquire the selection content of the item name selection area 1211. For example, when the OK button 1212 is clicked or touched, the form generation device 101 specifies a table having an item with the selected item name, and generates and generates form data based on the item of the specified table. A form screen 1301 (see FIG. 13) including form data is displayed on the display 206.

  In the example of FIG. 12, the item selection screen 1201 displays “sales amount”, “sales record”, “cost”, and “cost record” as item names in the item name selection area 1211, and the item name “sales record” is displayed. Indicates that it has been selected.

(Example of form screen 1301)
FIG. 13 is an explanatory diagram illustrating an example of a form screen 1301 of the form generation apparatus 101 according to the embodiment. In FIG. 13, a form screen 1301 of the form generation apparatus 101 is a screen that displays form data generated by the form generation apparatus 101. The form screen 1301 of the form generation apparatus 101 is created by the form generation apparatus 101 and displayed on the display 206 of the form generation apparatus 101, for example.

  The form screen 1301 displays form data generated based on the items in the table specified by the item name selected on the item selection screen 1201.

  In the example of FIG. 13, the form screen 1301 is generated based on the item name “sales record” of the table “sales table B801” specified by the item name “sales record” selected on the item selection screen 1201. The form data 1311 is displayed.

(Functional configuration example of the form generation device 101)
Next, a functional configuration example of the form generation device 101 illustrated in FIG. 2 will be described. FIG. 14 is a block diagram of a functional configuration example of the form generation device 101 according to the embodiment. In FIG. 14, the form generation apparatus 101 includes a display unit 1401, an acquisition unit 1402, a specification unit 1403, and an update unit 1404. Specifically, the functional unit including the display unit 1401, the acquisition unit 1402, the specifying unit 1403, and the update unit 1404, for example, loads a program stored in a storage device such as the memory 202 illustrated in FIG. This function is realized by executing this function. The processing result of each functional unit is stored in, for example, a storage device such as the memory 202 illustrated in FIG.

  The display unit 1401 has a function of displaying a guide selection screen 901, a guide screen 1001, a form screen 1101, an item selection screen 1201, and a form screen 1301 on the display 206. For example, the display unit 1401 displays a guide selection screen 901 on the display 206 after the user logs in and authentication is successful.

  The display unit 1401 displays the guide screen 1001 when the guide screen button 911 is selected while the guide selection screen 901 is displayed. When the item selection screen button 912 is selected while the guide selection screen 901 is displayed, the display unit 1401 displays the item selection screen 1201. Here, selection means that the mouse is clicked or touched. For example, the selection of the guide screen button 911 means that the guide screen button 911 is clicked with the mouse or the guide screen button 911 is touched.

  In addition, when the OK button 1015 is selected while the guide screen 1001 is displayed, the display unit 1401 notifies the acquisition unit 1402 that the OK button 1015 on the guide screen 1001 is selected. When the OK button 1212 is selected while the item selection screen 1201 is displayed, the display unit 1401 notifies the acquisition unit 1402 of the selection of the OK button 1212 on the item selection screen 1201.

  Also, the display unit 1401 generates form data based on the table name specified by the specifying unit 1403, and displays the form screen 1101 or the form screen 1301 including the generated form data on the display 206.

  Further, the display unit 1401 can display an inquiry screen for setting the layout of the form data to be output, the period for outputting the form data, and the like before generating the form data. In this case, the display unit 1401 generates form data based on the layout, period, and the like input on the inquiry screen.

  Further, when displaying the item selection screen 1201, the display unit 1401 acquires the user's part code from the acquisition unit 1402, and displays the item names of the items included in the table belonging to the table type related to the user's part code. It can be displayed in the selected state.

  The acquisition unit 1402 has a function of acquiring the user part code, the time entered on the guide screen 1001, the department and the keyword, and the item name selected on the item selection screen 1201. For example, the acquisition unit 1402 acquires the user's part code from a table in which the user ID and the part code are associated with each other. The acquisition unit 1402 passes the acquired unit code to the update unit 1404.

  In addition, the acquisition unit 1402 receives the notification of selection of the OK button 1015 on the guide screen 1001 from the display unit 1401, and acquires information input to the time item 1011, the department item 1012, and the keyword item 1013. The acquisition unit 1402 passes the acquired time, department, and keyword information to the specifying unit 1403.

  Also, the acquisition unit 1402 receives a notification of selection of the OK button 1212 on the item selection screen 1201 from the display unit 1401 and acquires the item name selected in the item name selection area 1211. The acquisition unit 1402 passes the acquired item name to the specification unit 1403 and the update unit 1404.

  The specifying unit 1403 has a function of specifying an item name in the table from the time, department, keyword, and item name acquired by the acquiring unit 1402.

  The identification unit 1403 identifies the item name of the table from the time, the department, and the keyword acquired by the acquisition unit 1402 as follows. When the keyword acquired by the acquisition unit 1402 exists in the keyword link table 301, the specifying unit 1403 acquires a table name and an item name corresponding to the keyword. The identifying unit 1403 acquires the table type of the unit code acquired by the acquiring unit 1402 from the unit code link table 401. The specifying unit 1403 acquires a table name belonging to the acquired table type from the table link table 501.

  The specifying unit 1403 specifies a table name belonging to the acquired table type among the table names corresponding to the keywords acquired by the acquiring unit 1402. The identifying unit 1403 passes the item name of the identified table name to the display unit 1401.

  Here, the specifying unit 1403 can also determine whether or not the table with the specified table name satisfies the conditions of the acquired time and department. In this case, the specifying unit 1403 passes the item name of the table having the table name that satisfies the conditions of the acquired time and department to the display unit 1401.

  Further, the specifying unit 1403 specifies a table having the item name acquired by the acquiring unit 1402 and passes the item name of the specified table to the display unit 1401. Further, when the table name of the table having the item name acquired by the acquisition unit 1402 exists in the table link table 501, the specifying unit 1403 acquires the table type corresponding to the table name of the table having the acquired item name, It is passed to the update unit 1404.

  The update unit 1404 has a function of updating the unit code link table 401 and the counter table 601 based on the unit code acquired by the acquisition unit 1402 and the table type acquired by the specifying unit 1403. When the update unit 1404 updates the copy code link table 401, the specifying unit 1403 can specify the table type most frequently referenced by the users belonging to the unit.

  The update unit 1404 increases the number of selections of the counter table 601 corresponding to the unit code acquired by the acquisition unit 1402 and the table type acquired by the specifying unit 1403. For example, the update unit 1404 can increase the number of selections by one.

  The update unit 1404 updates the copy code link table 401 based on the number of times the counter table 601 is selected. For example, the update unit 1404 updates the unit code link table 401 when the increased number of selections reaches the maximum value among the number of selections corresponding to the unit code acquired by the acquisition unit 1402. In this case, the update unit 1404 changes the table type corresponding to the corresponding part code in the part code link table 401 to the table type of the number of selections that has reached the maximum value.

(Example of form generation processing procedure)
15 and 16 are flowcharts illustrating an example of a form generation processing procedure of the form generation apparatus 101 according to the embodiment. In FIG. 15, first, the form generation apparatus 101 acquires a copy code from the user ID (step S1501). For example, the form generation device 101 acquires the user's part code from a table in which the user ID and the part code are associated with each other. The form generation device 101 holds the acquired copy code in a storage device such as the memory 202 or the disk 205. Specifically, the form generation device 101 acquires the copy code “1111” from the user ID.

  The form generation device 101 displays the guide selection screen 901 on the display 206 (step S1502). The form generation device 101 determines whether the guide screen button 911 on the guide selection screen 901 has been selected (step S1503).

  When the guide screen button 911 on the guide selection screen 901 is selected (step S1503: Yes), the form creation device 101 displays the guide screen 1001 on the display 206 (step S1504).

  The form generation device 101 acquires the keyword input in the keyword item 1013 of the guide screen 1001 (step S1505). In the example of FIG. 10, the keyword “sales” described in the keyword list 1014 is dragged and dropped on the keyword item 1013, and then the OK button 1015 is clicked with the mouse. "Sales" is acquired.

  The form generation device 101 acquires a table name and an item name corresponding to the acquired keyword from the keyword link table 301 (step S1506). In the example of FIG. 3, the form generation apparatus 101 has a table name “sales table A” and an item name “sales amount” corresponding to the acquired keyword “sales”, and a table name “sales table B” and an item name “sales record”. Is obtained.

  The form generation device 101 determines whether or not the acquired table name exists in the table link table 501 (step S1507). When the acquired table name does not exist in the table link table 501 (step S1507: No), the process of the form generation device 101 proceeds to step S1511.

  When the acquired table name exists in the table link table 501 (step S1507: Yes), the form generation device 101 acquires the table type of the acquired part code from the part code link table 401 (step S1508).

  In the example of FIG. 5, the acquired table names “sales table A” and “sales table B” exist in the table link table 501. In the example of FIG. 4, the form generation apparatus 101 acquires the table type “business system” of the acquired part code “1111” from the part code link table 401.

  The form generation device 101 acquires a table name belonging to the acquired table type from the table link table 501 (step S1509). In the example of FIG. 5, the form generation apparatus 101 obtains from the table link table 501 the table name “sales table A”, table name “business negotiation information”, and table name “customer table” belonging to the acquired table type “sales system”. get.

  The form generation device 101 identifies a table name belonging to the acquired table type among the table names corresponding to the acquired keyword (step S1510). In the example of FIGS. 3 and 5, the form generation apparatus 101 has the table name “sales” belonging to the table type “sales” among the table names “sales table A” and “sales table B” corresponding to the keyword “sales”. Identify table A ".

  The form generation device 101 generates form data based on the item name item of the identified table name, and displays the generated form data on the display 206 (step S1511). Here, when the process proceeds from step S1603, step S1606, or step S1607 to step S1511, the item name item of the identified table name is the item name item selected on the item selection screen 1201. When the process proceeds from step S1507 to step S1511, the item name item in the table having the specified table name is the item name item acquired in step S1506.

  In the example of FIG. 11, the form generation device 101 generates form data based on the item name “sales amount” in the table of the specified table name “sales table A”, and the generated form data is displayed on the display 206. indicate. In the example of FIG. 13, the form generation device 101 generates form data based on the item with the selected item name “sales record” and displays the generated form data on the display 206.

  When the guide screen button 911 on the guide selection screen 901 is not selected (step S1503: No), the form creation device 101 displays the item selection screen 1201 on the display 206 (step S1601). For example, when the item selection screen button 912 on the guide selection screen 901 is clicked or touched with the mouse, the form generation apparatus 101 determines that the guide screen button 911 on the guide selection screen 901 has not been selected.

  The form generation device 101 acquires the item name selected from the item selection screen 1201 (step S1602). For example, the form generation device 101 is selected by clicking or touching the OK button 1212 with the mouse after the item name in the item name selection area 1211 on the item selection screen 1201 is selected by clicking or touching the mouse. Get the item. In the example of FIG. 12, the form generation device 101 acquires the selected item name “sales record” among the item names in the item name selection area 1211 of the item selection screen 1201.

  The form generation device 101 determines whether the table name of the table having the acquired item name exists in the table link table 501 (step S1603). If the table name of the table having the acquired item name does not exist in the table link table 501 (step S1603: No), the processing of the form generation device 101 proceeds to step S1511.

  When the table name of the table having the acquired item name exists in the table link table 501 (step S1603: Yes), the form generation device 101 corresponds to the table name of the table having the item name acquired from the table link table 501. The table type to be acquired is acquired (step S1604).

  In the example of FIG. 5, the table name “sales table B” of the table having the acquired item name “sales record” exists in the table link table 501. In the example of FIG. 5, the form generation device 101 acquires the table type “accounting system” corresponding to the table name “sales table B” of the table having the acquired item name “sales record”.

  The form generation device 101 increments the selection count of the counter table 601 corresponding to the acquired part code and the acquired table type by 1 (step S1605). In the example of FIG. 6, the form generation apparatus 101 increments the selection count “10” of the counter table 601 corresponding to the acquired department code “1111” and the acquired table type “accounting system” by 1 to “11”. To do.

  The form generation device 101 determines whether or not the increased selection count has reached the maximum value among the selection counts corresponding to the acquired copy code (step S1606). When the increased number of selections is not the maximum value among the number of selections corresponding to the acquired copy (step S1606: No), the process of the form generation device 101 proceeds to step S1511.

  When the increased number of selections reaches the maximum value among the number of selections corresponding to the acquired part code (step S1606: Yes), the form generation apparatus 101 corresponds to the acquired part code in the part code link table 401. The table type is changed to the table type with the maximum number of selections (step S1607), and the process proceeds to step S1511. In the example of FIG. 6, the increased selection count “11” is the maximum value among the selection counts corresponding to the acquired part code. Further, in the example of FIG. 4, the form generation apparatus 101 changes the table type of the part code “1111” acquired from the part code link table 401 to the table type “accounting system” of the number of selection times that is the maximum value.

  Thereby, a series of processing in this flowchart is completed. By executing this flowchart, the user can automatically select a target form item by selecting a keyword.

  As described above, the form generation device 101 acquires the copy code to which the user belongs from the login information of the user, and accepts designation of a keyword corresponding to an item to be included in the form data. The form generation device 101 is referred to by a user belonging to the part indicated by the part code based on the reference record information of the table when generating the form data among the tables having items corresponding to the designated keywords. Identify the table. The form generation device 101 generates form data based on the identified table items.

  Thereby, the form generation device 101 can generate form data without causing the user using the guide function to select an item. For this reason, the form data suitable for the purpose of the user can be easily generated, and the load on the form data generation of the user is reduced. In addition, since the user selects an incorrect item and regenerates the form data, the load on the form generation apparatus 101 is reduced.

  In addition, by allowing the form generation device 101 to select an item that is likely to be used by the user using a keyword, the user can generate target form data. Further, the form generation device 101 makes the keyword easy to understand, so that the user can select an appropriate item.

  Further, the form generation apparatus 101 can include a part code link table 401 that associates a part code with a table type to which the table belongs, and a table link table 501 that indicates a table that belongs to the table type. In this case, the form generation apparatus 101 can specify a table belonging to the table type related to the department code of the part to which the user belongs, among the tables having items corresponding to the designated keyword.

  As a result, the form generation device 101 can manage the tables referred to by the sections belonging to the same business by the table type. For example, a table referred to by the sales department can be managed by the table type “sales”.

  Further, the form generation apparatus 101 includes a counter table 601 that associates the table type to which the table belongs, the part code to which the user belongs, and the number of times the table is referenced by the user belonging to the part indicated by the part code. Can be remembered. In this case, when the form generation apparatus 101 receives designation of an item to be included in the form data, the form generation apparatus 101 can increase the number of times corresponding to the table type to which the table including the item belongs and the acquired copy code. The form generation device 101 can update the table type associated with the part code link of the part code link table 401 based on the increased number of times.

  As a result, the form generation device 101 can generate form data from the items in the table that are frequently referenced from the part to which the user belongs. For this reason, the form generation device 101 can generate form data suitable for the purpose of the user.

  The form generation method described in the present embodiment can be realized by executing a program prepared in advance on a computer such as a personal computer or a workstation. The form generation program is recorded on a computer-readable recording medium such as a hard disk, a flexible disk, a CD-ROM, an MO, and a DVD, and is executed by being read from the recording medium by the computer. The form generation program may be distributed through a network such as the Internet.

  The following additional notes are disclosed with respect to the embodiment described above.

(Supplementary note 1)
Obtaining group information to which the user belongs from the login information of the user;
When the specification of the keyword corresponding to the data item to be included in the form data is received, the source data when generating the form data stored in the storage unit among the source data having the data item corresponding to the specified keyword Based on the reference result information of, identify the source data referred to by the user belonging to the group indicated by the acquired group information,
Generate form data based on the identified source data.
A form generation program characterized by causing processing to be executed.

(Supplementary Note 2) The reference record information includes information that associates the group information with the data type to which the source data belongs, and information that indicates the source data that belongs to the data type,
The process to specify is
When the specification of the keyword corresponding to the data item to be included in the form data is received, the source data belonging to the data type related to the acquired group information is identified from the source data having the data item corresponding to the specified keyword The form generation program according to supplementary note 1, characterized by:

(Supplementary note 3)
The data type to which the source data belongs, the group information to which the user belongs, and the number of times the source data has been referenced by the user belonging to the group indicated by the group information are stored in association with each other,
When the specification of the data item to be included in the form data is accepted, the number of times related to the data type to which the source data including the specified data item belongs and the acquired group information is increased,
Update the data type associated with the group information of the reference performance information based on the increased number of times,
The form generation program according to attachment 2, wherein the form is executed.

(Appendix 4) The update process is as follows:
Of the number of times related to the acquired group information, the data type associated with the group information of the reference performance information has become the maximum value in response to the increased number of times being the maximum value. The form generation program according to appendix 3, wherein the form is updated to a table type related to the number of times.

(Appendix 5) The computer
Obtaining group information to which the user belongs from the login information of the user;
When the specification of the keyword corresponding to the data item to be included in the form data is received, the source data when generating the form data stored in the storage unit among the source data having the data item corresponding to the specified keyword Based on the reference result information of, identify the source data referred to by the user belonging to the group indicated by the acquired group information,
Generate form data based on the identified source data.
A form generation method characterized by executing processing.

(Appendix 6) Obtaining group information to which the user belongs from the login information of the user,
When the specification of the keyword corresponding to the data item to be included in the form data is received, the source data when generating the form data stored in the storage unit among the source data having the data item corresponding to the specified keyword Based on the reference result information of, identify the source data referred to by the user belonging to the group indicated by the acquired group information,
Generate form data based on the identified source data.
A form generation device having a control unit.

(Appendix 7)
Obtaining group information to which the user belongs from the login information of the user;
When the specification of the keyword corresponding to the data item to be included in the form data is received, the source data when generating the form data stored in the storage unit among the source data having the data item corresponding to the specified keyword Based on the reference result information of, identify the source data referred to by the user belonging to the group indicated by the acquired group information,
Generate form data based on the identified source data.
A computer-readable recording medium on which a form generation program for executing processing is recorded.

101 Form generation device 1401 Display unit 1402 Acquisition unit 1403 Identification unit 1404 Update unit

Claims (5)

On the computer,
Obtaining group information to which the user belongs from the login information of the user;
When the specification of the keyword corresponding to the data item to be included in the form data is received, the specification is made from the information that associates the keyword, the item name corresponding to the keyword, and the table name of the table having the item name corresponding to the keyword. The table name and the item name related to the keyword obtained are acquired, and among the acquired table names, based on the reference record information of the table of the table name when generating the form data, the acquired group information Identify the table name referenced by the users belonging to the indicated group,
Based on the item name items included in the specified table name among the specified item names , form data is generated.
A form generation program characterized by causing processing to be executed. On the computer,
Obtaining group information to which the user belongs from the login information of the user;
When the specification of the keyword corresponding to the data item to be included in the form data is received, the source data when generating the form data stored in the storage unit among the source data having the data item corresponding to the specified keyword The group obtained based on the reference performance information, which includes information relating the group information and the data type to which the source data belongs, and information indicating the source data belonging to the data type Identify the source data belonging to the data type related to the information,
Generate form data based on the identified source data.
A form generation program characterized by causing processing to be executed. In the computer,
The data type to which the source data belongs, the group information to which the user belongs, and the number of times the source data has been referenced by the user belonging to the group indicated by the group information are stored in association with each other,
When the specification of the data item to be included in the form data is accepted, the number of times related to the data type to which the source data including the specified data item belongs and the acquired group information is increased,
Update the data type associated with the group information of the reference performance information based on the increased number of times,
The form generation program according to claim 2, wherein processing is executed. The group information used for the person belongs, acquired from the login information of the user,
When the specification of the keyword corresponding to the data item to be included in the form data is received, the specification is made from the information that associates the keyword, the item name corresponding to the keyword, and the table name of the table having the item name corresponding to the keyword. The table name and the item name related to the keyword obtained are acquired, and among the acquired table names, based on the reference record information of the table of the table name when generating the form data, the acquired group information Identify the table name referenced by the users belonging to the indicated group,
Based on the item name items included in the specified table name among the specified item names , form data is generated.
A form generation device having a control unit. Obtaining group information to which the user belongs from the login information of the user;
When the specification of the keyword corresponding to the data item to be included in the form data is received, the source data when generating the form data stored in the storage unit among the source data having the data item corresponding to the specified keyword The group obtained based on the reference performance information, which includes information relating the group information and the data type to which the source data belongs, and information indicating the source data belonging to the data type Identify the source data belonging to the data type related to the information,
Generate form data based on the identified source data.
A form generation device having a control unit.

Images