JP2007011910A - Questionnaire device and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a questionnaire device and a program, in which a result can be outputted in a form easy to further process, display or the like in tabulation of an answer result described in characters, patterns or the like to a fixed document such as a questionnaire sheet. <P>SOLUTION: A difference between an original questionnaire sheet before entry of answers which is inputted from a document input part 102 and a questionnaire sheet with entry of answers is detected by a document difference detection part 107, and stored in an accumulated document storage part 121 through an accumulated document management part 110. A questionnaire work processing part 108 generates, based on the detected difference, a tabulation file of csv format and a comment file of text format, and links the respective files with a predetermined area of the original questionnaire sheet. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a questionnaire apparatus and a program, and more particularly to a technique that appropriately copes with the case where the answer results described in characters, graphics, and the like are tabulated in a standard document such as a questionnaire sheet.

  Questionnaire automatic counting device that receives questionnaire answer sheets sent by facsimile from respondents and automatically recognizes and aggregates the contents when answering in a standard document with characters, graphics, etc., like a questionnaire sheet Is disclosed in Patent Document 1.

Japanese Patent Laid-Open No. 5-189407

Japanese Patent Laid-Open No. 2003-115039

  In the above conventional questionnaire automatic counting device, the questionnaire results are automatically totaled, but the results are transmitted by facsimile or the like, so that there is a problem that the result data is not suitable for further processing. In addition, it is not suitable for a case where the user wants to refer to the results on the way before all the answers to the questionnaire are collected.

  The present invention has been made in view of such problems, and in the case where the answer results described in characters, figures, etc. are tabulated in a standard document such as a questionnaire sheet, further processing, display, etc. An object of the present invention is to provide a questionnaire apparatus and a program that can output results in a format that is easy to do.

  In order to solve the above problems, a questionnaire device according to the present invention includes an original questionnaire sheet storage unit that stores data of a questionnaire sheet before an answer is entered, a questionnaire sheet in which an answer is entered, and the original Difference detection means for detecting a difference from the questionnaire sheet, result file generation means for generating a predetermined type of file containing the result of the questionnaire based on the detected difference, and the result in a predetermined area of the original questionnaire sheet The file generation means includes link generation means for linking the generated files.

  In the configuration of the present invention, based on the detected difference, the result file generating means generates a file including the result of the questionnaire, and the link generating means is generated in a predetermined area of the original questionnaire sheet before the result is entered. Linked files. Since a predetermined type of file containing the results of the questionnaire is generated, it is suitable for processing the results. For example, when a predetermined area of the original questionnaire sheet displayed on the screen is clicked, the results are easily displayed. Therefore, user convenience is also good. The “predetermined area” includes not only a certain area on the screen but also a case where the file name is explicitly described and linked.

  The result file generation means counts the result indicated by the difference when the description of the answer to the area requiring the aggregation is detected as a difference, and the result of the aggregation as the predetermined type of file. Generates a type of file that can be handled by software having a spreadsheet function, and generates a type of file that can be handled by software having a text creation function for answers written in text. can do. As a type of file that can be handled by software having a spreadsheet function, for example, a csv format file can be generated, and as a type of file that can be handled by software having a sentence creation function, for example, a txt format file Of course, the file can be generated, but the present invention is not limited to this.

  If the result file generation means is configured to be able to perform the process of counting the results and the file generation process when an instruction from the user is given, even before all the questionnaire responses are collected, The progress can be easily referred to.

  It is preferable that the questionnaire device includes a determining unit that determines a file type generated by the result file generating unit from the format of a questionnaire sheet. For example, if the configuration is such that the respondent detects a check box and automatically generates a csv format file, the usability of the user is further improved. Of course, the user may manually set the area where the difference should be detected and the type of file to be generated.

  If the questionnaire device is configured to include a keyword input receiving unit that receives a keyword input from a user, and a search unit that searches for a questionnaire sheet that includes the input keyword in an answer described in the questionnaire, for example, Potential events can be easily extracted when planning events such as comfort trips.

  The program according to the present invention includes a difference detection process for detecting a difference between a questionnaire sheet in which an answer is entered and a questionnaire sheet before the answer is entered, and a predetermined result including a questionnaire result based on the detected difference. Causing the processor to execute a result file generation process for generating a file of a type and a link generation process for linking the file generated in the result file generation process to a predetermined area of the questionnaire sheet before the answer is entered It is characterized by. In the following embodiments, the case where the present invention is applied to an MFP (multifunction peripheral) will be described. For example, the present invention can also be installed by installing the program of the present invention in an information processing apparatus such as a personal computer. Can be realized.

  According to the questionnaire device or the like according to the present invention, it is possible to output the results in a format that facilitates further processing and display of the questionnaire results.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.
(1) Overall Configuration of Questionnaire System FIG. 1 is a diagram showing an example of the overall configuration of the questionnaire system AS of the present embodiment. The questionnaire system shown in the figure is an MFP (multi-function peripheral), personal computer that can acquire image data by reading an original questionnaire sheet or a questionnaire sheet that contains answers, and print questionnaire sheets. A computer (PC) or the like is connected via the communication line 4.

  Although the number of MFPs and PCs is arbitrary, in this embodiment, the user who conducts the questionnaire registers and distributes the questionnaire sheet using the MFP 1 and receives the questionnaire sheet (hereinafter referred to as “respondent user”). )) Will be described assuming that the PC 31A, the PC 31B, etc. receive the notification mail to that effect and reply using the MFP 1. Hereinafter, unless there is a particular need to distinguish, the MFP may be collectively referred to as “MFP1”, and the PC may be collectively referred to as “PC31”.

  Computer names such as “PC001”, “PC002”,... Are assigned to the MFP 1 and each PC 31 as identification information in order to identify them. An IP address may be used as identification information instead of such a computer name.

  The MFP 1 and each PC 31 can be connected to each other via the communication line 4. As the communication line 4, a LAN, the Internet, a dedicated line, a public line, or the like is used. As the communication protocol or communication standard, for example, TCP / IP, FTP, POP3, SMTP, IPP (Internet Printing Protocol), IEEE802.3 which is a standard of wired LAN, IEEE802.11 which is a standard of wireless LAN, or the like is used. .

  The implementation user using the questionnaire system AS registers the image data obtained by reading the standard questionnaire sheet with the scanner unit 13 (see FIG. 3) of the MFP 1 so that it can be referred to from each PC 31, and notifies that effect. Notify each respondent user by email. The respondent user who has received the mail prints a questionnaire sheet, writes a character such as a check, a comment, and a figure by handwriting or using application software installed on the PC 31A, PC 31B, etc., and answers. The original questionnaire sheet and the questionnaire sheet on which the answer is described are stored in the hard disk 23H of the MFP 1 (see FIG. 3). A workstation, PDA (Personal Digital Assistant) or the like can be used instead of the PC 31 or the like.

(2) Configuration of MFP 1 The configuration of MFP 1 used as a questionnaire device in the present embodiment will be described below. FIG. 2 is a diagram illustrating an example of the appearance of the MFP 1 according to the present embodiment. The MFP 1 is an image forming apparatus that integrates functions such as copying, network printing, scanner, FAX, or document server. Sometimes called a multifunction device.

  FIG. 3 is a diagram illustrating an example of a hardware configuration in MFP 1 according to the present embodiment. The MFP 1 includes an operation unit 11, a display unit 12, a scanner unit 13, a printer unit 14, a communication interface 16, a document feeder 17, a paper feeder 18, a tray 19 (see FIG. 2), a CPU 20, a RAM 21, a ROM 22, and a data storage unit. 23 or the like.

  The operation unit 11 includes a plurality of keys for inputting numbers, characters, symbols, and the like, a sensor for recognizing the pressed key, and a transmission circuit for transmitting a signal indicating the recognized key to the CPU 20. .

  The display unit 12 displays a screen for giving a message or an instruction to the user, a screen for the user to input settings and processing contents, a screen showing a result processed by the MFP 1, and the like. In the present embodiment, a touch panel is used as the display unit 12. Therefore, the display unit 12 has a function of detecting a position on the touch panel touched by the user with a finger and transmitting a signal indicating the detection result to the CPU 20.

  As described above, the operation unit 11 and the display unit 12 serve as a user interface for the user to operate the MFP 1. Note that application programs and drivers for giving commands to the MFP 1 are installed in the PC 31. Therefore, the user can also operate the MFP 1 remotely using the PC 31.

  The scanner unit 13 photoelectrically reads an image such as a photograph, a character, a picture, or a chart drawn on a document, and generates digital image data (here, density data representing RGB or black density). In the present embodiment, an original questionnaire sheet before an answer is written or a questionnaire sheet on which an answer is written is read by the scanner unit 13 to obtain image data. The questionnaire sheet can be printed by the printer unit 14. The document feeder 17 is provided in the upper part of the main body of the MFP 1 and is used to sequentially send one or more originals to the scanner unit 13.

  The printer unit 14 prints an image read by the scanner unit 13, an image of image data transmitted from the PC 31, and the like on a recording sheet such as recording paper or film. The paper feeding device 18 is provided in the lower part of the MFP 1 main body, and supplies a recording sheet suitable for an image to be printed to the printer unit 14. The recording sheet on which the image is printed by the printer unit 14 is discharged to the tray 19.

  The communication interface 16 is configured by a reception unit 161, a transmission unit 162, and the like, and is a device for exchanging data with an external device such as the PC 31. As the communication interface 16, for example, a NIC (network interface card), a modem, a TA (terminal adapter), or the like is used.

  The data storage unit 23 includes a hard disk 23H, a card reader / writer 23R, and the like. The card reader / writer 23R can read data from a memory card 91 such as a compact flash (registered trademark) or smart media, or can write data to the memory card 91.

(3) Processing Contents Next, specific processing contents of the MFP 1 when the present invention is applied to the MFP 1 as a questionnaire device will be described. FIG. 4 is a block diagram illustrating a functional configuration of the MFP 1. Hereinafter, in each control block, details of the processing contents after the execution user who logs in to the MFP 1 and requests the respondent user to browse and answer the questionnaire sheet, the processing contents when handling the questionnaire sheet in which the answers are described, and the like are described in detail. explain.

  When the user logs in, the user inputs a user ID and password from the operation unit 11 as the login input unit 103. The login authentication management unit 104 checks the input user ID and password against those registered in the user information database 124, and performs authentication based on whether or not they match. Login is permitted when the user ID and password entered by the user match those registered. In addition to providing the user information database 124 inside the MFP 1, an external authentication server can also be used.

<Registration of original questionnaire sheet>
First, the implementing user browses a questionnaire sheet (hereinafter, a questionnaire sheet before an answer is described is referred to as an “original questionnaire sheet”, and a questionnaire sheet in which an answer is described is referred to as an “answered questionnaire sheet”). Processing contents when requesting the respondent will be described. FIG. 5 is a flowchart for explaining the contents of the questionnaire sheet registration process.

  The implementation user selects and inputs an answerer user via the operation unit 11 or the display unit 12 as the work process input unit 101 (S101). When the respondent user is selected, for example, a screen as shown in FIG. 6 is displayed on the display unit 12. Here, when the “specify” button 211 is pressed, the screen shifts to an answerer selection screen as shown in FIG.

  In the example of FIG. 7, as respondent users of the questionnaire, “Jiro Ishikawa” (not shown in the figure, user ID = “IJ”), “Goro Ono” (user ID = “OG”), “Kume” Three names of “Kozo” (user ID = “KK”) are selected. When the respondent user is selected on this respondent selection screen and the “OK” button 213 is pressed, the screen returns to the screen of FIG. In order to redo the selection of the respondent user, the “Cancel” button 214 is pressed.

  When the “start” button 212 is input on the screen of FIG. 6, it is assumed that there is a “questionnaire start instruction” (S102: YES), the original questionnaire sheet is input from the scanner unit 13 as the document input unit 102, It is read (S103). Note that the document input unit 102 shown in FIG. 4 includes not only image data read by the scanner unit 13, but also, for example, data in a PDL (page description language) format transmitted from the PC 31, another PC 31, or the like. It is also possible to input data attached to the transmitted e-mail, image data transmitted by FAX, and the like.

  In response to the “questionnaire start instruction” from the work processing input unit 101, the work information management unit 105 issues a work ID having a unique value (S104). The work ID is used for managing and managing a series of questionnaire sheet data such as an original questionnaire sheet and a answered questionnaire sheet, a difference between the original questionnaire sheet and the answered questionnaire sheet, a total result of the questionnaire, and the like. At this time, the work information management unit 105 creates a “respondent user list” based on the selected respondent user information and stores it in a memory such as the RAM 22 (S105).

  FIG. 8 is a diagram illustrating an example of the contents of the “respondent user list”. In the example of the figure, the work ID of the questionnaire to be implemented is “1”, and it is stored that the above three names are selected as the respondent list. In the example shown in the figure, not only the respondent but also “final processing” holds that information is sent to the designated email address and information about the answer description area (area 1 and area 2) of the questionnaire sheet. Has been.

  With regard to “final processing” and “answer description area”, a screen such as an example shown in FIG. However, the e-mail address may be set by acquiring the e-mail address of the implementing user from the user information database 124. The information related to the answer description area is used for automatic tabulation of answered questionnaire sheets, summary of results, and the like.

  In the screen of FIG. 9, the user can press the box 221 to display a pull-down menu and select a final process (for example, FAX transmission) other than “mail transmission”. The answer description area can be specified by inputting the coordinates (unit: mm) of the upper left and lower right positions of the answer description area with reference to the upper left of the questionnaire sheet. The designation of “C” in the box 222a indicates that the results are aggregated into a csv file, and the designation of “T” in the box 222b indicates that the results are collected into a txt file. “□” in the box 223 specifies the shape of the check box.

  FIG. 10 is a diagram showing an example of the contents of the original questionnaire sheet. When the respondent user puts a check in the check boxes 231a to 231d (area 1), these are aggregated to generate a csv format file, and the comment described by the respondent user in the comment description box 232 is in the txt format. Are compiled into a file.

  Returning to the flowchart of FIG. 5, when there is a “questionnaire start instruction”, the work information management unit 105 activates the questionnaire work processing unit 108 and notifies the survey work processing unit 108 of the work ID (S106). After that, the started questionnaire work processing unit 108 proceeds with the process notified by the event notified from the status management unit 109.

  When there is a “questionnaire start instruction”, the work information management unit 105 sends the work ID and the input original questionnaire sheet data to the document difference detection unit 107. The document difference detection unit 107 inquires of the accumulated document management unit 110 whether or not an original questionnaire sheet corresponding to the received work ID already exists. At the timing of this inquiry, since the original questionnaire sheet has not yet been stored in the accumulated document storage unit 121, the accumulated document management unit 110 returns a response indicating that “original questionnaire sheet is not stored” to the document difference detection unit 107. .

  Note that the accumulated document management unit 110 manages document files stored in the accumulated document storage unit 121. The accumulated document storage unit 121 is provided in the hard disk 23H in the present embodiment. The document difference detection unit 107 sends the work ID and the original questionnaire sheet data to the stored document management unit 110. The accumulated document management unit 110. The received data is stored in the original questionnaire sheet storage area associated with the received work ID (S107).

  Here, the contents of the accumulated document storage unit 121 will be described. FIG. 11 is a diagram illustrating an example of the contents of the accumulated document storage unit 121. The work document area 1211 stores data obtained by reading an original questionnaire sheet by the scanner unit 13, data of a questionnaire sheet that has been answered by a respondent user, and the like.

  The check box total file (check.csv) 1212 is a file including the result of totaling the number of checked check boxes (area 1) 231a to 231d (see FIG. 10) of the questionnaire sheet. At the time of aggregation, a check box difference file (check.txt) 1213 is referred to. The check box difference file 1213 is a file that holds which of the check boxes 213a to 213d is checked.

  The area 2 comment file (comment.txt) 1214 is a text file in which comments described in the area 2 are collected. The original document file 1215 is data of the original questionnaire sheet in the HTML format. By linking the check box total file (check.csv) and the area 2 comment file (comment.txt) to the answer description area of the original questionnaire sheet in HTML format, it is possible to refer to both of them integrally. .

  In response to the activation of the questionnaire work processing unit 108, the status management unit 109 creates a status list from the work ID and the respondent user list (S108 in FIG. 5). FIG. 12 is a diagram illustrating an example of the contents of the status list. As shown in the figure, the status list holds the latest status for each work ID and each respondent.

  The status management unit 109 first sets the statuses corresponding to all user IDs held in the created status list to “browsing” (S109). Then, a “status change notification” is notified to the questionnaire work processing unit 108. Upon receipt of the “status change notification”, the questionnaire work processing unit 108 notifies the mail transmission unit 111 to notify all the respondent users who are subjects of the questionnaire of “viewable”. The mail transmission unit 111 transmits “readable mail” to the mail address of each user (S110). The mail address is stored in the user information database 124. This completes the registration of the original questionnaire sheet and the notification to the user (request for browsing).

<Processing of the user who receives “readable mail”: Printout of questionnaire sheet>
Next, the process of the respondent user who received the viewable mail will be described as an example in which a reply is made using the MFP 1 and the PC 31A. Each respondent user who has received the viewable mail is described in the user ID and password and the viewable mail in the Web server unit 112 of the MFP 1 via the Web browser installed on each PC (PC 31A in this case). Enter the work ID. The Web server unit 112 notifies the login authentication management unit 104 of the input user ID and password.

  The login authentication management unit 104 checks the user ID and password, and notifies the Web server unit 112 of an authentication result as to whether or not they match. When the login is permitted, the work information management unit 105 is notified of the user ID and work ID of the respondent user and that the input means is “Web input”.

  The work information management unit 105 notifies the stored document management unit 110 of the user ID and the work ID, and requests access to the original questionnaire sheet. The accumulated document management unit 110 refers to the respondent user list and returns information regarding the storage area of the original questionnaire sheet associated with the work ID when the user ID matches that registered in the respondent user list. .

  In this case, since “Web input” is notified as the input means as described above, the work information management unit 105 notifies the Web server unit 112 of the storage area information of the notified original questionnaire sheet. When the authentication result is access permission and there is a response to the storage area information, the Web server unit 112 transitions the screen displayed on the browser of the PC 31A to the access request page of the original questionnaire sheet. FIG. 13 is a diagram showing an example of such an access request page.

  The access request page shown as an example in the figure includes an area 311 where a work ID and a user ID are displayed, and an area 312 where a questionnaire sheet storage area is displayed. When the respondent user presses the print key 313 displayed on the access request page, a “questionnaire sheet print request” is notified to the Web server unit 112 of the MFP 1. Upon receiving the “questionnaire sheet print request”, the Web server unit 112 notifies the stored document management unit 110 of an “original questionnaire sheet print request”. Note that the cancel key 314 is used when the respondent user re-specifies the document (for example, when the work ID is different).

  When the accumulated document management unit 110 receives the “original questionnaire sheet print request”, the stored document management unit 110 sends the data (document data) of the original questionnaire sheet to the printer unit 14 and also sends the user ID, work ID, and “printed status” to the status management unit. 109 is notified. The printer unit 14 prints a questionnaire sheet on paper using the received document data. Upon receiving “printed status”, the status management unit 109 changes the status corresponding to the user ID in the status list to “printed”, and notifies the questionnaire work processing unit 108 of “status change notification”.

  Upon receiving the “status change notification”, the questionnaire work processing unit 108 refers to the status list. In this case, since the status of the user ID “IJ” is “printed”, the status management unit 109 is notified to change the status of the user whose status has changed to “under reply”. The status management unit 109 changes the status of the designated user ID to “responding”. The original questionnaire sheet can be printed by the MFP 31A.

<Processing of the user who received “readable mail”: Input of answered questionnaire sheet>
Next, a process performed by the user who receives “readable mail” and inputs a questionnaire response using the MFP 1 will be described. The respondent user first inputs a user ID and password to the login input unit 103 via the operation unit 11 or the display unit 12 of the MFP 1.

  The login input unit 103 notifies the login authentication management unit 104 of the input user ID and password. The login authentication management unit 104 collates the user ID and the password, and permits the login if they match. The login authentication management unit 104 notifies the login input unit 103 of the authentication result of permission or non-permission. When the login is permitted, the work information management unit 105 is notified of the user ID of the login user and the input means is “device input”. Hereinafter, the input process of the answered questionnaire sheet will be described. FIG. 14 is a flowchart for explaining the contents of the answer input process.

  First, the work information management unit 105 displays a work selection screen on the display unit 12 (S201). FIG. 15 is a diagram illustrating an example of a work selection screen. The work information management unit 105 refers to the status list and extracts the work ID of the work selected as the respondent by the logged-in user. In the example of FIG. 15, it is shown that there are two works in which the user (Jiro Ishikawa) with the user ID “IJ” is selected as the respondent, and the respondent inputs the questionnaire sheet for which the work has been answered. Select what to do.

  When a work is selected (S202: YES), the work information management unit 105 notifies the stored document management unit 110 that a user ID, a work ID, and “status confirmation” are requested (S203). The stored document management unit 110 refers to the respondent user list and requests the status management unit 109 for a “status confirmation request” using the user ID and work ID as parameters.

  Upon receiving the “status confirmation request”, the status management unit 109 refers to the status list corresponding to the work ID, and returns the current status corresponding to the designated user ID (in this case, “in response”) as a response. .

  The accumulated document management unit 110 notifies the work information management unit 105 of the “questionnaire document storage location” corresponding to the work ID because the response result is “being answered” (S204: YES). As described above, in this case, since “device input” is notified as the input means, the work information management unit 105 notifies the BOX display unit 113 of the notified “survey document storage location”.

  The BOX display unit 113 changes the display on the display unit 12 of the MFP 1 to a “BOX display screen” (S205). If the status is not “answering” in step S204, error processing is performed as an abnormal answer input request in this embodiment (S206). In this error processing, for example, a message such as status abnormality or answer input impossible can be displayed, but a process of allowing a user who has already input an answer to re-input is also possible.

  FIG. 16 is a diagram illustrating an example of a BOX display screen. On the BOX display screen, the storage area for the answered questionnaire sheet (identifier or folder name of the area 1211 in FIG. 11) is shown. The respondent user sets the answered questionnaire sheet with a handwritten comment at the reading position of the scanner unit 13. When the OK key 213 in FIG. 16 is pressed, the scanner unit 13 reads the answered questionnaire sheet (S208). Data obtained as a result of the reading is input to the document input unit 102.

  The document input unit 102 passes the questionnaire sheet data that has been answered to the work information management unit 105. The work information management unit 105 refers to the respondent user list and sends the user ID of the login user, the work ID, and the data of the answered questionnaire sheet to the document difference detection unit 107.

  The document difference detection unit 107 inquires the accumulated document management unit 110 whether or not the original questionnaire sheet corresponding to the received work ID has already been stored. In this case, since a response indicating that the original questionnaire sheet has already been stored is returned, the answered questionnaire sheet is compared with the original questionnaire sheet, and the described response portion is extracted (S209). Here, the document difference detection unit 107 refers to the respondent user list and performs difference detection (result extraction) for each region to be compared on the questionnaire sheet.

  In the present embodiment, difference detection is performed for two areas, area 1 and area 2. The extracted “area 1 data” (data indicating which part of the check boxes 231a to 231d shown in FIG. 10 is checked) and “area 2 data” (described in the area 232 of FIG. 10). Comment data) is transmitted to the stored document management unit 110 together with the work ID and user ID. The data of the questionnaire sheet that has been answered is also transmitted to the stored document management unit 110 together.

  The accumulated document management unit 110 stores the received questionnaire sheet data, “area 1 data”, and “area 2 data” in a predetermined area of the accumulated document storage unit 211. That is, the answered questionnaire sheet is stored together with the user ID in the area 1211 shown in FIG. The “area 1 data” is first stored in a txt format file (check.txt) shown in the area 1213. The “area 2 data” is added to the text format file (comment.txt) shown in the area 1213 together with the user ID (S210).

  Thereafter, the accumulated document management unit 110 notifies the status management unit 109 of the work ID and the “work document accumulation status”. Upon receiving the “work document storage status”, the status management unit 109 refers to the status list corresponding to the work ID, and changes the status of the user ID of the login user to “document registration”. Then, a “status change notification” is notified to the questionnaire work processing unit 108. Upon receiving the “status change notification”, the questionnaire work processing unit 108 refers to the status list and changes the status of the user ID that has changed in status to “answered”.

  The status management unit 109 changes the status of the designated user ID to the notified status. If all the target users have answered (S211: YES), the survey work processing unit 108 is notified of “end of survey”. When the questionnaire work processing unit 108 receives a questionnaire end notification from the status management unit 109, the questionnaire work processing unit 108 requests the accumulated document management unit 110 for a check box difference file for area 1. The accumulated document management unit 110 transmits the area 1 data difference file (check.txt) to the questionnaire work processing unit 108.

  The questionnaire work processing unit 108 performs aggregation by referring to whether each area 1 data check box is checked (difference is detected), and generates a csv format check box aggregation file. (S212). Then, the generated file is transmitted to the accumulated document management unit 110. The accumulated document management unit 110 saves the received aggregated data as a csv format file (file name “check.csv” in the example of the present embodiment). When the stored document management unit 110 completes the storage, the stored document management unit 110 notifies the questionnaire work processing unit 108 of the storage completion.

  The questionnaire work processing unit 108 requests acquisition of the storage location of the check box total file (check.csv), the storage location of the area 2 comment file (comment.txt), and the original questionnaire sheet data. The accumulated document management unit 110 transmits the data requested from the questionnaire work processing unit 108.

  The questionnaire work processing unit 108 converts the data of the original questionnaire sheet into the HTML format. At this time, referring to the respondent user list and clicking an area defined as area 1, a link is made to the URL of the check box total file (check.csv). In addition, when the area defined in the area 2 is clicked for the area 2, the URL of the area 2 comment file (comment.txt) is linked (S213). FIG. 17 is a diagram illustrating a state in which a file is linked to a predetermined area of an original questionnaire sheet in HTML format. The check box total file (check.csv) is linked to the area 1 area 231R and the area 2 comment file (comment.txt) is linked to the area 2 area 232R.

  The questionnaire work processing unit 108 requests the stored document management unit 110 to save the original questionnaire sheet data converted into the HTML format. When the stored document management unit 110 completes the storage, the stored document management unit 110 notifies the questionnaire work processing unit 108 of the storage completion. The questionnaire work processing unit 108 refers to the circulator user list and performs processing according to the final processing (S214). For example, if the setting is “send mail to survey user,” the mail transmission unit 111 is instructed to send a survey end email to the email address of the user. This completes the questionnaire response process.

(Modification)
Although the embodiment of the present invention has been described above, the content of the present invention is not limited to the specific examples described in the embodiment, and for example, the following modifications may be implemented. it can.

  (1) In the above embodiment, after the notification of “end of questionnaire” is received, the results of area 1 are aggregated (generation of csv file), and the csv file or the area 2 comment file into the HTML file of the original questionnaire sheet However, these can be performed in response to an instruction from the implementing user without waiting for the end of the questionnaire. By performing aggregation and link processing without waiting for the end of the questionnaire, it is possible to easily refer to the progress in the middle.

  (2) In the above embodiment, for example, the implementation user designates the area that needs to be aggregated on the screen as shown in FIG. 9, but for example, the check box (□) is automatically recognized. Thus, a configuration in which a file format (csv format or the like) is automatically selected for the recognized area is also possible. For example, prepare a screen to specify the check box shape (symbols such as ○, ☆, etc.) and the number of check boxes to be checked, and determine the file format to be automatically generated according to the selection of the user By doing so, the user convenience is further improved.

  (3) Further, a configuration for displaying a screen for receiving an input of a keyword from the implementing user is also possible. For example, it may be possible to use a questionnaire sheet in which the keyword “travel” is included in the comment description area of area 2 for use in planning a comfort trip.

  (4) Although the case where the MFP 1 is used as a questionnaire device has been described in the above embodiment, the questionnaire device according to the present invention can execute, for example, a program for causing a processor such as a CPU to execute a process as described above, a printer, It can also be realized by installing in an information processing apparatus such as a PC to which a scanner or the like is connected. When it is not necessary to write the result of the questionnaire by hand, a printer, a scanner, or the like may not be connected.

  (5) Although the case where the answered questionnaire sheet is input by the MFP 1 has been described in the above embodiment, the answered questionnaire sheet may be input by another device such as the MFP 1A. In that case, for example, the data of the questionnaire sheet that has been answered can be attached to an e-mail including a work ID or the like, FAX, etc., and transmitted to the MFP 1, or data can be transmitted to the MFP 1 using a file transfer function. The MFP 1 may detect the difference by appropriately converting the format of the transmitted data.

  The present invention can be applied to, for example, a questionnaire apparatus.

It is a figure which shows an example of the whole structure of questionnaire system AS. 2 is a diagram illustrating an example of an appearance of an MFP 1. FIG. 2 is a diagram illustrating an example of a hardware configuration of an MFP 1. FIG. 2 is a block diagram showing a functional configuration of MFP 1. FIG. It is a flowchart for demonstrating the content of the registration process of a questionnaire sheet | seat. It is a figure which shows an example of the screen for instruct | indicating an answerer selection and a questionnaire start. It is a figure which shows an example of a respondent selection screen. It is a figure which shows an example of the content of a "respondent user list." It is a figure which shows an example of the screen for a "final process" and an "answer description area" setting. It is a figure which shows an example of the content of an original questionnaire sheet. 6 is a diagram illustrating an example of contents of an accumulated document storage unit 121. FIG. It is a figure which shows an example of the content of a status list. It is a figure which shows an example of the access request page of an original questionnaire sheet. It is a flowchart for demonstrating the content of an answer input process. It is a figure which shows an example of a workpiece | work selection screen. It is a figure which shows an example of a BOX display screen. It is a figure which shows a mode that a file is linked to the predetermined area | region of the original questionnaire sheet | seat of an HTML format.

Explanation of symbols

1 MFP
4 communication line 11 operation unit 12 display unit 13 scanner unit 14 printer unit 16 communication interface 161 reception unit 162 transmission unit 17 document feeder 18 paper feeder 19 tray 20 CPU
21 RAM
22 ROM
23 Data storage unit 23H Hard disk drive 23R Card reader / writer 31 Personal computer (PC)
91 Memory card 101 Work processing input unit 102 Document input unit 103 Login input unit 104 Login authentication management unit 105 Work information management unit 107 Document difference detection unit 108 Questionnaire work processing unit 109 Status management unit 110 Accumulated document management unit 111 Mail transmission unit 112 Web server unit 113 BOX display unit 121 Accumulated document storage unit 122 Respondent user list storage unit 123 Status management unit 124 User information database 211 Specify button 212 Start button 213 OK button 214 Cancel button 231a to 231d Check box 232 Comment description box 313 Print button

Claims (6)

An original questionnaire sheet storage means for storing data of a questionnaire sheet before an answer is filled in;
A difference detection means for detecting a difference between the questionnaire sheet in which an answer is written and the original questionnaire sheet;
Based on the detected difference, a result file generating means for generating a predetermined type of file including the result of the questionnaire;
The questionnaire apparatus characterized by including the link production | generation means to link the file produced | generated by the said result file production | generation means to the predetermined area | region of the said original questionnaire sheet | seat. The result file generating means includes:
When the description of the answer to the area that requires aggregation is detected as a difference, the results indicated by the difference are aggregated,
As the predetermined type of file,
For the results of aggregation, generate a file of a type that can be handled by software that has a spreadsheet function.
The questionnaire apparatus according to claim 1, wherein a file of a type that can be handled by software having a sentence creation function is generated for answers written in text. The result file generating means includes:
The questionnaire apparatus according to claim 2, wherein the process of counting the results and the process of generating a file are performed when an instruction from a user is given. The questionnaire device
The questionnaire apparatus according to any one of claims 1 to 3, further comprising a determining unit that determines a file type generated by the result file generating unit from a format of a questionnaire sheet. The questionnaire device
Keyword input accepting means for accepting keyword input from the user;
The questionnaire device according to any one of claims 1 to 4, further comprising search means for searching for a questionnaire sheet in which an input keyword is included in an answer written in a questionnaire. A difference detection process for detecting a difference between a questionnaire sheet in which an answer is filled in and a questionnaire sheet before the answer is filled in;
Based on the detected difference, a result file generation process for generating a predetermined type of file containing the result of the questionnaire,
A program for causing a processor to execute link generation processing for linking a file generated by the result file generation processing to a predetermined area of a questionnaire sheet before the answer is entered.

Images