Q & a display system and program for q & a display system

Abstract

To provide a Q & A display system for enabling a manager to easily manage Q & A information to be published on a Q & A site by file data in a cell display format.SOLUTION: A Q & A display system 100 includes a manager-use terminal 110, a server 120, and a user terminal 130, wherein Q & A information TP is set in file data EX in a cell display format displayed on the manager-use terminal 110, the server 120 issues URL information corresponding to the file data EX in the cell display format based on a deployment operation by a manager, and when the user terminal 130 accesses the server 120 based on the URL information, a browser 131 of the user terminal 130 displays a Q & A site 132 related to the Q & A information TP based on the file data EX in the cell display format and a script set in advance in association with the file data in the cell display format.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a Q&A display system that includes an administrator terminal, a server, and a user terminal, and that displays Q&A information set in the administrator terminal via the server in response to a request from the user terminal, and a program for the system. [Background technology]

[0002] BACKGROUND ART Conventionally, a Q&A system including a management server, a questioner terminal, and an answerer terminal is known (for example, Patent Document 1). [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Patent No. 4961537 Summary of the Invention [Problem to be solved by the invention]

[0004] However, the conventional Q&A system described above was configured so that frequently asked questions and answers were grouped together and each set was registered as content data in the database of the management server. This required the administrator to register each question and answer set and set up links, which resulted in the problem that managing Q&A information was a time-consuming and cumbersome process.

[0005] Therefore, the present invention solves the problems of the prior art as described above. In other words, the object of the present invention is to provide a Q&A display system and a program therefor that allow an administrator to easily manage Q&A information posted on a Q&A site using file data in cell display format. [Means for solving the problem]

[0006] The invention of claim 1 is a Q&A display system comprising an administrator terminal, a server, and a user terminal, which displays Q&A information set on the administrator terminal via the server at the request of the user terminal, wherein the Q&A information is set in cell-format file data displayed on the administrator terminal, and based on a deploy operation by the administrator, the server issues URL information corresponding to the cell-format file data, and when the user terminal accesses the server based on the URL information, the browser of the user terminal displays a Q&A site related to the Q&A information based on the cell-format file data and a script that is pre-set in association with the cell-format file data, thereby solving the above-mentioned problem.

[0007] The invention of claim 2 further solves the above-mentioned problem by configuring the Q&A display system as described in claim 1, in addition to the configuration of the Q&A display system described in claim 1, in which the number of times an item of Q&A information has been displayed when the user terminal accesses a server based on the URL information and the browser of the user terminal displays the item of Q&A information on the Q&A site is reflected for each item of Q&A information in the file data in cell display format, and the Q&A information items that have been displayed more frequently are displayed higher on the Q&A site than the Q&A information items that have been displayed less frequently.

[0008] The invention of claim 3 further solves the above-mentioned problem by configuring the Q&A display system as described in claim 2, in addition to the configuration of the Q&A display system, in which the Q&A site has a rating button for each Q&A information item, and when a rating button is operated on the Q&A site displayed on the browser of the user terminal, rating information corresponding to the rating button is reflected for each Q&A information item in the file data in cell display format, a score value is calculated by multiplying the rating information by display count information, and on the Q&A site, Q&A information items with high score values ​​are displayed higher than Q&A information items with low score values.

[0009] The invention of claim 4 further solves the above-mentioned problem by configuring the Q&A display system as described in claim 3, in addition to the configuration of the Q&A display system, in which related Q&A information is set for each item of Q&A information in the file data in cell display format, and when the Q&A site displays each item of Q&A information, it also displays the related Q&A information based on the file data in cell display format.

[0010] The invention of claim 5 further solves the above-mentioned problem by configuring the Q&A display system according to any one of claims 1 to 4, in addition to the configuration of the Q&A display system, in which keyword information is set for each item of Q&A information in the file data in cell display format, the Q&A site has a search input field, and when text is entered into the search input field, the server searches for question information, answer information, and keyword information in the Q&A information based on the entered text content, and displays question information of Q&A information that is determined to be relevant as a suggestion in the search input field or near the search input field.

[0011] The invention of claim 6 further solves the above-mentioned problem by configuring the Q&A display system as described in claim 5, in addition to the configuration of the Q&A display system, in which reference URL information is set for each item of Q&A information in the file data in cell display format, and when the Q&A site displays each item of Q&A information, the reference URL information is also displayed based on the file data in cell display format.

[0012] The invention of claim 7 further solves the above-mentioned problem by being configured such that, in addition to the configuration of the Q&A display system described in claim 6, when the referral URL information is operated on the Q&A site displayed on the browser of the user terminal and the browser displays a site page based on the referral URL information, the referral URL site view count information is reflected for each item of Q&A information in the file data in cell display format, a score value is calculated by multiplying the evaluation information, the view count information, and the referral URL site view count information, and on the Q&A site, Q&A information items with higher score values ​​are displayed higher than Q&A information items with lower score values.

[0013] The invention of claim 8 further solves the above-mentioned problem by configuring the Q&A display system according to any one of claims 1 to 4, in which publication period information is set for each item of Q&A information in the file data in cell display format, and the Q&A site displays Q&A information items that satisfy the conditions set by the publication period information based on the current date and time information and the publication period information set for each item of Q&A information in the file data in cell display format, and does not display Q&A information items that do not satisfy the conditions set by the publication period information.

[0014] The invention of claim 9 is a program for a Q&A display system that displays Q&A information set on an administrator terminal via a server in response to a request from a user terminal, and solves the above-mentioned problem by having a computer execute the following steps: a Q&A information setting step of saving Q&A information input and set in cell-format file data displayed on the administrator terminal; a URL issuing step of the server issuing URL information corresponding to the cell-format file data based on a deploy operation by the administrator; and a Q&A site display step of, when the user terminal accesses the server based on the URL information, displaying a Q&A site related to the Q&A information on the basis of the cell-format file data and a script previously set in association with the cell-format file data. [Effects of the Invention]

[0015] The Q&A display system of the present invention is equipped with an administrator terminal, a server, and a user terminal, and is therefore not only able to display Q&A information set on the administrator terminal via the server at the request of the user terminal, but also has the following unique effects:

[0016] According to the Q&A display system of the invention of claim 1, a Q&A site can be constructed simply by setting Q&A information in file data in cell display format, so that administrators can easily manage the Q&A information to be posted on the Q&A site using file data in cell display format. Furthermore, since the Q&A site is displayed in association with the file data in cell display format, administrators can change or update the display content of the Q&A site simply by changing or updating the Q&A information in the file data in cell display format.

[0017] According to the Q&A display system of the invention of claim 2, in addition to the effect achieved by the invention of claim 1, the number of times each Q&A information item is displayed on the user's terminal is reflected in file data in cell display format, and based on this, when the Q&A site is displayed from the next time onwards, the Q&A information items that have been displayed more frequently are displayed preferentially at the top, so that Q&A information items that are considered useful can be displayed in a location that is easy for the user to see.

[0018] According to the Q&A display system of the invention of claim 3, in addition to the effect achieved by the invention of claim 2, user evaluation information for each Q&A information item is reflected in file data in cell display format, and a score value is calculated based on the evaluation information and display count information.Based on this, when the Q&A site is displayed next time or thereafter, Q&A information items with higher score values ​​are preferentially displayed at the top, so that Q&A information items that are likely to be useful can be displayed in a location that is easily visible to the user.

[0019] According to the Q&A display system of the invention of claim 4, in addition to the effect achieved by the invention of claim 3, not only the Q&A information items but also related Q&A information related to them are displayed, so that the information that the user wants can be provided more reliably. In other words, not only the selected Q&A information item but also related Q&A information related to it is displayed, thereby increasing the likelihood that the user will obtain the information they want.

[0020] According to the Q&A display system of the invention of claim 5, in addition to the effect achieved by the invention of any one of claims 1 to 4, when a user enters text in a search input field, a so-called suggestion is displayed, thereby increasing the possibility that the user will obtain the desired Q&A information item. Furthermore, when a user enters text in the search input field, the search targets not only the question and answer information in the Q&A information, but also keyword information, so depending on how the administrator sets the keyword information, the likelihood that the user will obtain the desired Q&A information item can be increased.

[0021] According to the Q&A display system of the invention of claim 6, in addition to the effect achieved by the invention of claim 5, when the amount of information is too large to fit into the answer information of the Q&A information, by setting reference URL information, the reference URL information will be displayed together with the Q&A information when the browser on the user's terminal displays that Q&A information item, so that if the user desires further information, they can obtain further information based on the reference URL information.

[0022] According to the Q&A display system of the invention of claim 7, in addition to the effect achieved by the invention of claim 6, the information on the number of times a user has viewed a reference URL site for each item of Q&A information is reflected in file data in a cell display format, and a score value is calculated based on the evaluation information, the number of views information, and the number of views information of a reference URL site.Based on this, when the Q&A site is displayed next time or thereafter, the Q&A information items with higher score values ​​are preferentially displayed at the top, so that Q&A information items that are likely to be useful can be displayed more accurately and reliably in a location that is easily visible to the user.

[0023] According to the Q&A display system of the invention of claim 8, in addition to the effect achieved by the invention of any one of claims 1 to 4, it is possible to freely set whether to display or not each item of Q&A information according to the time conditions, so that the administrator can easily switch the information content of each item of Q&A information, start displaying, and end displaying it depending on the time when the user accesses it.

[0024] According to the program for the Q&A display system of the invention of claim 9, similar to the effect achieved by the invention of claim 1, a Q&A site can be constructed simply by setting Q&A information in file data in cell display format, so that the administrator can easily manage the Q&A information to be posted on the Q&A site using file data in cell display format. Furthermore, since the Q&A site is displayed in association with the file data in cell display format, administrators can change or update the display content of the Q&A site simply by changing or updating the Q&A information in the file data in cell display format. [Brief explanation of the drawings]

[0025] [Figure 1] 1 is a diagram showing the concept of a Q&A display system according to an embodiment of the present invention. [Figure 2] 1 is a chart showing an example of the operation of a Q&A display system according to an embodiment of the present invention. [Figure 3]1A and 1B are diagrams showing examples of question information, summary answer information, and detailed answer information as Q&A information entered into a Q&A list sheet in cell display format file data of a Q&A display system that is an embodiment of the present invention, as well as diagrams showing examples of keyword information, reference URL information, related Q&A information, and publication period information as Q&A information. [Figure 4] (A) and (B) are diagrams showing examples of Q&A information such as display count information, reference URL display count information, evaluation information, and score values ​​entered into a Q&A list sheet in cell display format file data of a Q&A display system that is an embodiment of the present invention, as well as diagrams showing an example of a deployment operation and diagrams showing how URL information is issued in an example of a deployment operation. [Figure 5] FIG. 2 is a diagram showing an example of the top screen of a Q&A site displayed on a browser of a user terminal of the Q&A display system according to an embodiment of the present invention. [Figure 6] FIG. 10 is a diagram showing an example in which details of an item of Q&A information on a Q&A site are displayed on a browser of a user terminal of the Q&A display system according to an embodiment of the present invention. [Figure 7] FIG. 7 is a diagram showing an example in which details of items of Q&A information related to the related Q&A information in FIG. 6 are displayed. [Figure 8] (A) and (B) are figures showing an example of category information entered into a QA category sheet in cell-display format file data of a Q&A display system which is an embodiment of the present invention, and a figure showing an example of log history information entered into a QA usage log sheet in cell-display format file data. DETAILED DESCRIPTION OF THE INVENTION

[0026] The Q&A display system of the present invention comprises an administrator terminal, a server, and a user terminal, and Q&A information is set in cell-display format file data displayed on the administrator terminal, and based on a deployment operation by the administrator, the server issues URL information corresponding to the cell-display format file data, and when the user terminal accesses the server based on the URL information, the browser on the user terminal displays a Q&A site related to the Q&A information based on the cell-display format file data and a script that is pre-set in association with the cell-display format file data.As long as this allows the administrator to easily manage the Q&A information to be posted on the Q&A site using cell-display format file data, any specific implementation is acceptable. Furthermore, the program for the Q&A display system of the present invention may be implemented in any specific manner as long as it causes a computer to execute the following steps: a Q&A information setting step for saving Q&A information entered and set in cell-format file data displayed on an administrator terminal; a URL issuing step for a server to issue URL information corresponding to the cell-format file data based on a deploy operation by the administrator; and a Q&A site display step for, when a user terminal accesses the server based on the URL information, the browser of the user terminal displays a Q&A site related to the Q&A information based on the cell-format file data and a script previously set in association with the cell-format file data, thereby allowing the administrator to easily manage the Q&A information to be posted on the Q&A site using cell-format file data.

[0027] For example, the administrator terminal and user terminal may be any device that displays data on a screen in a browser on the display unit of the user terminal, such as a desktop personal computer terminal, a notebook personal computer terminal, a smartphone terminal, a tablet terminal, a wristwatch terminal, or an eyeglass terminal, and that can connect to a server via a communication network including a wide area network (the so-called Internet), a local network, or a telephone line to send and receive data. Furthermore, the server may be a cloud server created in a cloud environment, and the number of physical servers that make up the server may be one or more. Furthermore, in this case, a "cell display format file" is also called a spreadsheet file, and refers to a so-called matrix cell (mass) format in which the input cell is specified by the matrix number and symbol. A feature of "cell display format files" is that the width and height of the cells can be freely changed on a row-by-row basis. Furthermore, the layout of characters and numbers within a cell can be freely set for each cell. A "cell display format file" is not limited to a sheet, which is a collection of cells, but may also be a file containing multiple sheets. Furthermore, "a script that is pre-set in association with file data in cell display format" refers to a script (command, program) that displays the contents of file data in cell display format in the browser of a user terminal when the user terminal accesses a server based on URL information, and refers to a so-called container-bound script that is pre-set in association with file data in cell display format. Specifically, it allows you to specify which cell's information in the cell-display format file data should be displayed where on the Q&A site, and reflects the displayed action in the specified cell in the cell-display format file data. The "script pre-set in association with file data in cell display format" may be set and saved in association with the file data in cell display format, and may be saved either together with the file data in cell display format itself or separately. [Example]

[0028] A Q&A display system 100 according to an embodiment of the present invention will be described below with reference to FIGS. 1 to 8(B). 1 is a diagram illustrating the concept of a Q&A display system 100 according to an embodiment of the present invention; FIG. 2 is a chart illustrating an example of the operation of the Q&A display system 100 according to an embodiment of the present invention; FIG. 3(A) is a diagram illustrating an example of question information TP1, summarized answer information TP2, and detailed answer information TP3 as Q&A information TP inputted into a Q&A list sheet in file data EX in a cell display format of the Q&A display system 100 according to an embodiment of the present invention; FIG. 3(B) is a diagram illustrating an example of keyword information TP4, referred URL information TP5, related Q&A information TP6, and publication period information TP7 as Q&A information TP; and FIG. 4(A) is a diagram illustrating an example of view count information TP8, referred URL site view count information TP9, evaluation information TP10, and score value TP11 as Q&A information TP inputted into a Q&A list sheet in file data EX in a cell display format of the Q&A display system 100 according to an embodiment of the present invention, and also illustrates a deployment operation. 4(A) is a diagram showing an example of a Q&A site 132 displayed in a browser 131 of a user terminal 130 of a Q&A display system 100 according to an embodiment of the present invention; FIG. 5 is a diagram showing an example of the top screen of the Q&A site 132 displayed in a browser 131 of a user terminal 130 of a Q&A display system 100 according to an embodiment of the present invention; FIG. 6 is a diagram showing an example of details of an item of Q&A information TP of the Q&A site 132 displayed in a browser 131 of a user terminal 130 of a Q&A display system 100 according to an embodiment of the present invention; FIG. 7 is a diagram showing an example of details of an item of Q&A information TP related to related Q&A information TP6 in FIG. 6; FIG. 8(A) is a diagram showing an example of category information entered in a QA category sheet in file data EX in cell display format of a Q&A display system 100 according to an embodiment of the present invention; and FIG. 8(B) is a diagram showing an example of log history information entered in a QA usage log sheet in file data EX in cell display format.

[0029] As shown in FIG. 1, a Q&A display system 100 according to an embodiment of the present invention includes an administrator terminal 110, a server 120, and a user terminal . The Q&A display system 100 is configured to display the Q&A information TP set by the administrator terminal 110 via the server 120 in response to a request from the user terminal 130 .

[0030] More specifically, first, the Q&A information TP is set in file data EX in a cell display format displayed on the administrator terminal 110. Here, the file data EX in the cell display format may be stored in the server 120 or in the administrator terminal 110. When file data EX in the cell display format is stored in the server 120, the administrator terminal 110 accesses the server 120 and displays the file data EX in the cell display format.

[0031] Then, based on a deploy operation by the administrator, the server 120 issues URL information EX1 corresponding to the file data EX in the cell display format. Next, when the user terminal 130 accesses the server 120 based on the URL information EX1, the browser 131 of the user terminal 130 is configured to display a Q&A site 132 related to the Q&A information TP based on the file data EX in cell display format and a script SP (see Figure 4(B)) that is pre-set in association with the file data EX in cell display format.

[0032] In this way, the Q&A site 132 can be constructed simply by setting the Q&A information TP in the file data EX in the cell display format. As a result, the administrator can easily manage the Q&A information TP posted on the Q&A site 132 in file data EX in a cell display format. Furthermore, a Q&A site 132 is displayed in association with the file data EX in the cell display format. As a result, the administrator can change or update the display contents of the Q&A site 132 simply by changing or updating the Q&A information TP in the file data EX in the cell display format.

[0033] Next, an example of the operation of the Q&A display system 100 will be described in more detail. As shown in FIG. 2, in step S1, as a step for determining whether or not Q&A information is set (Q&A information setting step), the Q&A information TP input and set in the cell display format file data EX displayed on the administrator terminal 110 is saved. If you are happy with the Q&A information TP that has already been entered, you can leave it as is. If data is entered and a save operation is performed, the data is saved. Then, the browser 111 of the administrator terminal 110 determines whether or not Q&A information TP has been set and saved in the file data EX in the cell display format. If it is determined that the Q&A information TP has been set and saved, the process proceeds to step S2, and if it is determined that the Q&A information TP has not yet been set and saved, step S1 is repeated.

[0034] For example, as shown in FIGS. 3(A) to 4(A), the browser 111 of the administrator terminal 110 displays file data EX in a cell display format based on an operation by the administrator. Q&A information TP is set in the file data EX in cell display format based on the operation by the administrator. For example, the "QA List" sheet of the cell-displayed file data EX has the following items in the Q&A information TP: "No.", "Q&A category," "Question," "Answer," "(Answer) details," "Keywords," "Priority," "Reference URL," "Related Q&A," "Publication period from," "Publication period to," "Number of views," "Number of reference URL views," "Number of resolved ratings," "Number of unresolved ratings," and "Administrator score."

[0035] Q&A information TP is set in the "Q&A list" sheet of the file data EX in cell display format. In the "Question" field, question information TP1 is set. Additionally, in the "Answer Text" field, summary answer information TP2 is set. Furthermore, detailed answer information TP3 is set in the "(Answer) Details" section. Then, the administrator inputs information into each item, and the input information is saved and set by a save operation.

[0036] In step S2, as a deploy operation presence / absence determination step (URL issuing step), the browser 111 of the administrator terminal 110 determines whether or not a deploy operation has been performed by the administrator. More specifically, as shown in FIG. 4(A), when the browser 111 of the administrator terminal 110 is displaying file data EX in cell display format with Q&A information TP set, as an example of a deployment operation, the "Function Extension" button in the menu of the browser 111 is operated as the deployment operation button 112, and the "Apps Script" button is operated as the deployment operation button 112.

[0037] Then, as shown in FIG. 4(B), the browser 111 of the administrator terminal 110 displays an Apps Script screen 113. The Apps Script screen 113 displays a script SP that has been set in advance in association with file data EX in a cell display format. Here, the script SP that is pre-set in association with the file data EX in cell display format is a script SP (command, program) for displaying the contents of the file data EX in cell display format on the browser 131 of the user terminal 130 when the user terminal 130 accesses the server 120 based on the URL information EX1. This script SP is a so-called container-bound script SP that is set in association with file data EX in cell display format. Specifically, this script SP specifies which cell information in the cell-display format file data EX is to be displayed where on the Q&A site 132, and reflects the displayed action in the specified cell in the cell-display format file data EX.

[0038] As an example of a deployment operation, on the Apps Script screen 113, it is assumed that the "Deploy" button as the deployment operation button 112 is operated, and further, a "New Deploy" button (not shown) as the deployment operation button 112 is operated. In this way, if it is determined that a deploy operation has been performed, the process proceeds to step S3, and if it is determined that a deploy operation has not been performed yet, step S2 is repeated. Although the deployment operation has been described as an example of a button operation on the browser 111 of the administrator terminal 110, it may also be an operation of selecting an item button by right-clicking or a shortcut key operation on the keyboard.

[0039] Here, "deploy" means "to unfold, to place, etc." In the IT field, "deployment" refers to the process of arranging and expanding application functions and services on the server 120 and making them available during the system development process of a web application or the like. When the browser 111 of the administrator terminal 110 is displaying file data EX in cell display format with Q&A information TP set, by operating the "Apps Script" button (a part of the deployment operation), a script SP (a so-called container-bound script) that operates in association with the file data EX in cell display format with Q&A information TP set is displayed on the browser 111 (Apps Script screen 113) and can be freely edited. If a container bind script SP has been set in advance, the set container bind script SP is displayed in an editable manner.

[0040] In step S3, as a URL issuing step, the server 120 issues URL information EX1 corresponding to the file data EX in the cell display format based on a deploy operation by the administrator. More specifically, as shown in FIG. 4(B), the browser 111 of the administrator terminal 110 displays a deployment window 114. The deployment window 114 displays deployment ID information and URL information EX1 issued by the server 120 as a web application. That is, based on the operation of step S2, the server 120 issues URL information EX1 associated with the file data EX in cell display format, and based on this information, the browser 111 of the administrator terminal 110 displays the deployment window 114.

[0041] In step S4, as a user access determination step (Q&A site display step), server 120 determines whether or not there has been access to server 120 from user terminal 130 based on the issued URL information EX1. If it is determined that there has been access, the process proceeds to step S5, and if it is determined that there has not been access, step S4 is repeated.

[0042] In step S5, as shown in FIG. 5, as a Q&A site display step, the browser 131 of the user terminal 130 displays the Q&A site 132 related to the Q&A information TP based on the file data EX in cell display format and the script SP (see FIG. 4(B)) that has been previously set in association with the file data EX in cell display format. The top screen of the Q&A site 132 includes, for example, a search input field 133, a display area for frequently asked questions, and a display area for major and medium category items.

[0043] The frequently asked questions display area is provided so that question information TP1 and summarized answer information TP2 of the Q&A information TP are displayed as a set. The category display area is also provided so that medium category items are displayed for each major category item of the Q&A information TP. To obtain the desired Q&A information TP, the user can search by entering keywords in the search input field 133, or by searching in the frequently asked questions display area, or by searching in the category display area.

[0044] When the user selects an arbitrary item of the Q&A information TP by clicking or the like, an HTTP response is sent from the user terminal 130 to the server 120, and an HTTP response is returned from the server 120 to the user terminal 130, for example. Then, as shown in Figure 6, question information TP1, summarized answer information TP2, and detailed answer information TP3 of the Q&A information TP are displayed on the Q&A site 132 of the browser 131 of the user terminal 130 based on the file data EX in cell display format.

[0045] As a result, as described above, the Q&A site 132 can be constructed simply by setting the Q&A information TP in the file data EX in the cell display format. As a result, the administrator can easily manage the Q&A information TP posted on the Q&A site 132 in file data EX in a cell display format. Furthermore, a Q&A site 132 is displayed in association with the file data EX in the cell display format. As a result, the administrator can change or update the display contents of the Q&A site 132 simply by changing or updating the Q&A information TP in the file data EX in the cell display format.

[0046] Furthermore, in this embodiment, the user terminal 130 accesses the server 120 based on the URL information EX1, and the browser 131 of the user terminal 130 displays the question information TP1, the summarized answer information TP2, and the detailed answer information TP3 as items of the Q&A information TP on the Q&A site 132, as shown in FIG. 6. Then, as shown in FIG. 4(A), the number of times the item of the Q&A information TP is displayed at this time is reflected for each item of the Q&A information TP in the file data EX in the cell display format. In other words, when an item of the Q&A information TP is displayed, the container binding script SP is set so that the number of times that item of the Q&A information TP is displayed increases by one in the file data EX in cell display format.

[0047] Then, as shown in FIG. 5, when the user terminal 130 again accesses the server 120 based on the URL information EX1 and the browser 131 of the user terminal 130 displays the top screen of the Q&A site 132, the items of Q&A information TP that have been displayed more frequently are displayed higher in the display area for frequently asked questions on the Q&A site 132 than the items of Q&A information TP that have been displayed less frequently. That is, as an example, the container binding script SP is configured to display items of Q&A information TP that are displayed more frequently on the Q&A site 132 higher than items of Q&A information TP that are displayed less frequently, based on the display count information TP8 in the file data EX in cell display format.

[0048] As a result, the display count information TP8 for each item of the Q&A information TP in the user terminal 130 is reflected in the file data EX in a cell display format, and based on this, when the Q&A site 132 is displayed from the next time onwards, the items of the Q&A information TP that have been displayed the most frequently are preferentially displayed at the top. For example, when Q&A information TP is displayed in a frequently asked questions display area, when Q&A information TP is displayed in a category display area, or when Q&A information TP is displayed as a suggestion in the search input field 133 or near the search input field 133, items of Q&A information TP that have been displayed more frequently are preferentially displayed at the top. As a result, it is possible to display items of Q&A information TP that are deemed useful in a location that is easily visible to the user.

[0049] In addition, when items of Q&A information TP that have been displayed frequently are displayed at the top of the list, in order to make it easier for users to understand, keyword information TP4 or any of the major category items, medium category items, or small category items of Q&A information TP may be displayed together. As shown in FIG. 5, the Q&A site 132 has a "See more" button just below the frequently asked questions display area. When this "See more" button is operated, the display area of ​​frequently asked questions on the Q&A site 132 is expanded downward, and the number of sets of question information TP1 and summarized answer information TP2 in the displayed Q&A information TP increases.

[0050] In this embodiment, as shown in FIG. 6, the Q&A site 132 has a rating button 134 for each item of the Q&A information TP. More specifically, as an example of the evaluation buttons 134, there are provided a "Yes" button and a "No" button in response to the question "Was this information useful?". As shown in Figure 4(A), when the rating button 134 is operated on the Q&A site 132 displayed on the browser 131 of the user terminal 130, the rating information TP10 corresponding to the rating button 134 is reflected for each item of the Q&A information TP in the file data EX in cell display format.

[0051] More specifically, in response to the operation of the "Yes" button, the container bind script SP increases the value of the "Number of Solution Evaluations" item in the "QA List" sheet in the cell display format file data EX by one. On the other hand, when the "No" button is pressed, the container bind script SP increases the value of the "Number of unresolved evaluations" item in the "QA list" sheet in the cell display format file data EX by one. Then, the score value TP11 of the "Administrator Score" is calculated by multiplying the numerical information obtained by subtracting the numerical value of the "Number of Unresolved Evaluations" item from the numerical value of the "Number of Resolved Evaluations" item as evaluation information TP10 by the number of times of display information TP8. Furthermore, as an example, the container binding script SP is configured to display items of Q&A information TP with a high score value TP11 higher than items of Q&A information TP with a low score value TP11 in the frequently asked questions display area on the top screen, the category display area, the search input field 133, or in the vicinity thereof, as an example of the Q&A site 132.

[0052] As a result, the user's evaluation information TP10 for each item of the Q&A information TP is reflected in the file data EX in the cell display format. Then, a score value TP11 is calculated from the numerical information obtained by subtracting the value in the "number of unresolved evaluations" field from the value in the "number of resolved evaluations" field of the evaluation information TP10 and the display count information TP8. Furthermore, based on this, when the Q&A site 132 is displayed next time or thereafter, for example, in the frequently asked questions display area on the top screen of the Q&A site 132, the display area by category, the search input field 133, or in the vicinity thereof, items of Q&A information TP with a high score value TP11 are preferentially displayed at the top. As a result, it is possible to display items of Q&A information TP that are likely to be useful in a place that is easily visible to the user.

[0053] Furthermore, in this embodiment, as shown in FIG. 3(B), related Q&A information TP6 is set for each item of Q&A information TP in file data EX in cell display format. As shown in FIG. 6, when the Q&A site 132 displays question information TP1, summary answer information TP2, and detailed answer information TP3 for each item of Q&A information TP, it is configured to also display related Q&A information TP6 based on file data EX in cell display format.

[0054] More specifically, as shown in Figure 3(B), the number entered or set in the "Related Q&A" field identifies the item in the Q&A information TP that corresponds to the number in the "No." field shown in Figure 3(A). As an example, the container binding script SP displays only the question information TP1 of the identified item as the related Q&A information TP6, with a link, as a related Q&A related to the Q&A information TP displayed in Figure 6, as an example of the item of the identified Q&A information TP.

[0055] As a result, as shown in FIG. 7, not only the items of the Q&A information TP but also related Q&A information TP6 related to the items are displayed. More specifically, when the linked related Q&A information TP6 is clicked, the items of the Q&A information TP as the related Q&A information TP6, namely, question information TP1, summary answer information TP2, and detailed answer information TP3, are displayed, as shown in Figure 7. As a result, it is possible to provide the user with the information he or she desires more reliably. That is, not only the item of the selected Q&A information TP but also the related Q&A information TP6 related to it are displayed. As a result, the likelihood that the user will obtain the information they want can be increased.

[0056] In this embodiment, as shown in FIG. 3(B), keyword information TP4 is set for each item of Q&A information TP in file data EX in cell display format. The top screen of the Q&A site 132 has a search input field 133 . Furthermore, when text is entered into the search input field 133 , the text information is transmitted from the user terminal 130 to the server 120 . Based on the input text content, the server 120 then searches the question information TP1, summary answer information TP2, detailed answer information TP3, and keyword information TP4 of the Q&A information TP in the cell display format file data EX. Then, the server 120 transmits to the user terminal 130 the Q&A information TP found in the search, that is, the question information TP1 of the Q&A information TP determined to be relevant.

[0057] Then, as shown in Figure 5, the container binding script SP is configured to display question information TP1 of the Q&A information TP that has been determined to be relevant as a suggestion in the search input field 133 or in the vicinity of the search input field 133. Here, with regard to "displaying as a suggestion in search input field 133 or near search input field 133," the display position is not limited to within search input field 133, but may be outside the field, and any configuration is acceptable as long as, in relation to search input field 133, when something displayed as a suggestion is selected, it is entered into search input field 133.

[0058] This allows a so-called suggestion display when the user inputs text into the search input field 133. Then, when a selection operation is performed on question information TP1 of the Q&A information TP displayed as a suggestion, the question information TP1 of the Q&A information TP corresponding to the selected question information TP1 of the Q&A information TP, summary answer information TP2, detailed answer information TP3, etc. are displayed on the Q&A site 132 of the browser 131 of the user terminal 130, as shown in Figure 6. As a result, the possibility that the user will obtain the desired Q&A information TP item can be increased. When the question information TP1 of the Q&A information TP is displayed as a suggestion, it may be configured to display keyword information TP4 or one of the major category items, medium category items, or minor category items of the Q&A information TP together in order to make it easier for the user to understand.

[0059] Furthermore, when the user inputs text into the search input field 133, the search targets not only the question information TP1 and answer information TP2 of the Q&A information TP, but also the keyword information TP4. As a result, the possibility that the user will obtain the desired Q&A information TP item can be increased depending on the keyword information TP4 set by the administrator. As shown in Figure 6, when the contents of the items of Q&A information TP, such as question information TP1, summary answer information TP2, and detailed answer information TP3, are displayed on the Q&A site 132 of the browser 131 of the user terminal 130, keyword information TP4 is also displayed, as an example.

[0060] Furthermore, in this embodiment, as shown in FIG. 3(B), reference URL information TP5 is set for each item of Q&A information TP in file data EX in cell display format. As shown in FIG. 6, when the Q&A site 132 displays each item of Q&A information TP, it is configured to also display reference URL information TP5 based on the cell-format file data EX, for example, using the setting content information of the "Layout Information" sheet of the cell-format file data EX and the container binding script SP.

[0061] In this way, when the amount of information is too large to fit into the answer information TP2 of the Q&A information TP, by setting the reference URL information TP5, when the browser 131 of the user terminal 130 displays the item of the Q&A information TP, the reference URL information TP5 is displayed together with the Q&A information TP. As a result, if the user desires further information, the user can obtain the further information based on the reference URL information TP5.

[0062] In this embodiment, it is assumed that an operation is performed on the location of reference URL information TP5 on the Q&A site 132 displayed on the browser 131 of the user terminal 130. Then, the browser 131 of the user terminal 130 displays the site page based on the reference URL information TP5. Then, as shown in Figure 4(A), when the browser 131 of the user terminal 130 displays a site page based on the reference URL information TP5, the container binding script SP reflects the reference URL site display count information TP9, which is the number of times the site page based on the reference URL information TP5 has been displayed, for each item of the Q&A information TP in the file data EX in cell display format.

[0063] Furthermore, the score value TP11 is calculated by multiplying the score value TP11, which is score information, by the display count information TP8, which is the number of times an item in the Q&A information TP as shown in FIG. 6, and the reference URL site display count information TP9. Then, for example, in the frequently asked questions display area on the top screen of the Q&A site 132, the category display area, the search input field 133 or nearby areas, items of Q&A information TP with a high score value TP11 are displayed higher than items of Q&A information TP with a low score value TP11, using the setting content information of the "Settings" sheet of the file data EX in cell display format and the container binding script SP.

[0064] As a result, the information TP9 on the number of times a user has viewed a reference URL site for each item of the Q&A information TP is reflected in the file data EX in a cell display format, and a score value TP11 is calculated based on the evaluation information TP10, the number of views information TP8, and the information TP9 on the number of times a user has viewed a reference URL site. Based on this, when the Q&A site 132 is displayed next time onwards, the items of the Q&A information TP with the higher score value TP11 are preferentially displayed at the top. As a result, it is possible to display items of Q&A information TP that are likely to be useful with greater accuracy in a place that is easily visible to the user.

[0065] Furthermore, in this embodiment, as shown in FIG. 3(B), disclosure period information TP7 is set for each item of Q&A information TP in file data EX in cell display format. More specifically, the publication period start date information as the publication period information TP7 is set in the "publication period From" field, and the publication period end date information as the publication period information TP7 is set in the "publication period To" field. In addition, based on the current date and time information and the publication period information TP7 set for each item of the Q&A information TP in the file data EX in cell display format, the container binding script SP determines which items of the Q&A information TP satisfy the conditions set by the publication period information TP7 of the server 120.

[0066] The container binding script SP is configured so that the Q&A site 132 displays items of Q&A information TP that satisfy the conditions set by the publication period information TP7, and does not display items of Q&A information TP that do not satisfy the conditions set by the publication period information TP7. That is, the script SP is configured so that only the items of Q&A information TP that satisfy the conditions of the publication period information TP7 are displayed on the Q&A site 132.

[0067] This allows you to freely set whether or not to display each item in the Q&A information TP according to time conditions. As a result, the administrator can easily switch the information content of the Q&A information TP items, start displaying them, and end displaying them depending on the time when the user accesses the TP.

[0068] Furthermore, as shown in Figure 8(A), the "QA Category" sheet in the cell display format file data EX allows category ID information, major category information (items) which are major classifications, medium category information (items) which are medium classifications, and small category information (items) which are small classifications to be freely set for each item of Q&A information TP. Based on this setting, the items of the Q&A information TP are displayed in a category-specific display area on the top screen of the Q&A site 132, and can be freely switched between expanded and unexpanded.

[0069] Furthermore, as shown in Figure 8(B), the "QA Usage Log" sheet in the cell display format file data EX has items such as "User," "Search Character," "Search Keyword within the System," "IP," and "Date and Time." In the "user" field, the name information of the user of the user terminal 130 is entered each time the Q&A site 132 is used. In the "search string" field, information on the text entered in the search input field 133 on the user terminal 130 is entered each time the Q&A site 132 is used.

[0070] In the "system search keyword" field, keyword information TP4 used when the server 120 searches each time the Q&A site 132 is used is entered. In the "IP" field, the IP information of the user terminal 130 is entered each time the Q&A site 132 is used. In the "date and time" field, the date and time information when the user terminal 130 displays an item on the Q&A site 132 is entered each time the Q&A site 132 is used.

[0071] The "Layout Information" sheet in the cell display format file data EX contains layout information for the top screen of the Q&A site 132 as shown in FIG. 5, and layout information for displaying question information TP1, summary answer information TP2, detailed answer information TP3, and the like as items of the Q&A information TP of the Q&A site 132 as shown in FIG. 6. Furthermore, the "Settings" sheet in the cell-display format file data EX has an input field for setting IP address information for which access from the user terminal 130 is permitted, and an input field for setting IP address information for which access is not permitted. When access permission and access denial overlap, permission is given priority.

[0072] In addition, the "Settings" sheet in the file data EX in cell display format allows the user to freely select whether to sort the search results in the order in which they are displayed, in the frequently asked questions display area, and in the category display area by selecting either the numerical information for "Priority" in the "QA List" sheet in the file data EX in cell display format shown in Figure 3(B) or the score value TP11 for "Administrator Score" in the "QA List" sheet in the file data EX in cell display format shown in Figure 4(A), and to sort in ascending order of the numerical information for "Priority" or in descending order of the score value TP11 for "Administrator Score."

[0073] The Q&A display system 100, an embodiment of the present invention obtained in this way, comprises an administrator terminal 110, a server 120, and a user terminal 130, and is configured such that Q&A information TP is set in cell-format file data EX displayed on the administrator terminal 110, and based on a deploy operation by the administrator, the server 120 issues URL information EX1 corresponding to the cell-format file data EX, and when the user terminal 130 accesses the server 120 based on the URL information EX1, the browser 131 of the user terminal 130 displays a Q&A site 132 related to the Q&A information TP based on the cell-format file data EX and a script SP that is pre-set in association with the cell-format file data EX. This allows the administrator to easily manage the Q&A information TP to be posted on the Q&A site 132 using the cell-format file data EX, and the administrator can change or update the display content of the Q&A site 132 simply by changing or updating the Q&A information TP in the cell-format file data EX.

[0074] Furthermore, when the user terminal 130 accesses the server 120 based on the URL information EX1 and the browser 131 of the user terminal 130 displays the items of the Q&A information TP on the Q&A site 132, the number of times the items of the Q&A information TP are displayed is reflected for each item of the Q&A information TP in the file data EX in cell display format, and on the Q&A site 132, items of the Q&A information TP that are displayed more frequently are displayed higher than items of the Q&A information TP that are displayed less frequently, so that items of the Q&A information TP that are deemed useful can be displayed in a location that is easily visible to the user.

[0075] Furthermore, the Q&A site 132 has a rating button 134 for each item of the Q&A information TP, and when the rating button 134 is operated on the Q&A site 132 displayed on the browser 131 of the user terminal 130, the rating information TP10 corresponding to the rating button 134 is reflected for each item of the Q&A information TP in the file data EX in cell display format, and a score value TP11 is calculated by multiplying the rating information TP10 by the display count information TP8. On the Q&A site 132, items of the Q&A information TP with a high score value TP11 are displayed higher than items of the Q&A information TP with a low score value TP11, so that items of the Q&A information TP that are deemed useful can be displayed in a location that is easily visible to the user.

[0076] Furthermore, related Q&A information TP6 is set for each item of Q&A information TP in the cell-display format file data EX, and when the Q&A site 132 displays each item of Q&A information TP, the related Q&A information TP6 is also displayed based on the cell-display format file data EX. This makes it possible to more reliably provide the information that users want to obtain, thereby increasing the likelihood that users will obtain the information they want.

[0077] Furthermore, keyword information TP4 is set for each item of Q&A information TP in file data EX in cell display format, and Q&A site 132 has a search input field 133. When text is entered into search input field 133, server 120 searches for question information TP1, answer information TP2, and keyword information TP4 of Q&A information TP based on the entered text, and displays question information TP1 of Q&A information TP determined to be relevant as a suggestion in search input field 133 or near search input field 133. This increases the likelihood that a user will obtain the desired item of Q&A information TP, and further increases the likelihood that a user will obtain the desired item of Q&A information TP depending on how keyword information TP4 is set by the administrator.

[0078] Furthermore, reference URL information TP5 is set for each item of Q&A information TP in the cell display format file data EX, and when the Q&A site 132 displays each item of Q&A information TP, the reference URL information TP5 is also displayed based on the cell display format file data EX, so that if a user desires further information, they can obtain further information based on the reference URL information TP5.

[0079] Furthermore, on Q&A site 132 displayed on browser 131 of user terminal 130, when reference URL information TP5 is operated and browser 131 displays a site page based on reference URL information TP5, reference URL site view count information TP9 is reflected for each item of Q&A information TP in file data EX in cell display format, and score value TP11 is calculated by multiplying evaluation information TP10, view count information TP8, and reference URL site view count information TP9, and on Q&A site 132, items of Q&A information TP with higher score values ​​TP11 are displayed higher than items of Q&A information TP with lower score values ​​TP11, so that items of Q&A information TP that are deemed useful can be displayed more accurately and reliably in a location that is easily visible to the user.

[0080] Furthermore, publication period information TP7 is set for each item of Q&A information TP in file data EX in cell display format, and based on the current date and time information and the publication period information TP7 set for each item of Q&A information TP in file data EX in cell display format, the Q&A site 132 displays items of Q&A information TP that satisfy the conditions set by the publication period information TP7, and does not display items of Q&A information TP that do not satisfy the conditions set by the publication period information TP7.This allows the administrator to easily switch the information content, start displaying, and end displaying items of Q&A information TP depending on the time of user access.

[0081] Furthermore, the program of the Q&A display system 100, which is an embodiment of the present invention, causes a computer to execute the following steps: a Q&A information setting step S1 for saving the Q&A information TP input and set in the cell-format file data EX displayed on the administrator terminal 110; URL issuing steps S2 and S3 for the server 120 to issue URL information EX1 corresponding to the cell-format file data EX based on a deploy operation by the administrator; and Q&A site display steps S4 and S5 for, when the user terminal 130 accesses the server 120 based on the URL information EX1, the browser 131 of the user terminal 130 displays a Q&A site 132 related to the Q&A information TP based on the cell-format file data EX and a script SP previously set in association with the cell-format file data EX. This has enormous advantages, such as allowing the administrator to easily manage the Q&A information TP to be posted on the Q&A site 132 using the cell-format file data EX, and allowing the administrator to change and update the display content of the Q&A site 132 simply by changing and updating the Q&A information TP in the cell-format file data EX. [Explanation of symbols]

[0082] 100 ··· Q&A display system 110 ··· Administrator terminal 111 ··· (Administrator's terminal) browser 112 Deploy operation button 113 ... Apps Script screen 114 ··· Deploy window 120 Server 130 ··· (Q&A site) user device 131 ··· (User device) browser 132 ··· Q&A site 133 ··· Search field 134 ··· Rating button EX: Cell display format file data EX1: URL information (corresponding to file data in cell display format) SP Script (Container Binding Script) TP...Q&A information TP1 ··· Question information TP2... (Abridged) Answer Information TP3 More information (of the answer) TP4 ··· Keyword Information TP5 ··· Reference URL information TP6 Related Q&A information TP7 ··· Release period information TP8 ··· (Q&A information item) View count information TP9 ··· Referral URL site view count information TP10··· Evaluation Information TP11 Score value (score information)

Claims

1. A Q&A display system that includes an administrator terminal, a server, and a user terminal, and displays Q&A information set in the administrator terminal via the server in response to a request from the user terminal, the Q&A information is set in file data in a cell display format displayed on the administrator terminal, The server issues URL information corresponding to the file data in the cell display format based on a deploy operation by an administrator; A Q&A display system characterized in that, when the user terminal accesses a server based on the URL information, the browser of the user terminal displays a Q&A site related to Q&A information based on the cell display format file data and a script that is pre-set in association with the cell display format file data.

2. the user terminal accesses a server based on the URL information, and the browser of the user terminal displays the Q&A information items on the Q&A site; the number of times the Q&A information items are displayed is reflected for each Q&A information item in the file data in cell display format; 2. The Q&A display system according to claim 1, wherein the Q&A site is configured to display items of Q&A information that are displayed more frequently than items of Q&A information that are displayed less frequently.

3. the Q&A site has a rating button for each item of Q&A information, 3. The Q&A display system according to claim 2, wherein when a rating button is operated on a Q&A site displayed on a browser of the user terminal, rating information corresponding to the rating button is reflected for each item of Q&A information in the file data in cell display format, a score value is calculated by multiplying the rating information by display count information, and on the Q&A site, items of Q&A information with high score values ​​are displayed higher than items of Q&A information with low score values.

4. The Q&A display system according to claim 3, characterized in that related Q&A information is set for each item of Q&A information in the file data in cell display format, and when the Q&A site displays each item of Q&A information, it also displays related Q&A information based on the file data in cell display format.

5. 5. The Q&A display system according to claim 1, wherein keyword information is set for each item of Q&A information in the file data in cell display format, the Q&A site has a search input field, and when text is entered into the search input field, the server searches for question information, answer information, and keyword information in the Q&A information based on the content of the entered text, and displays question information of Q&A information that is determined to be relevant as a suggestion in the search input field or near the search input field.

6. The Q&A display system described in claim 5, characterized in that reference URL information is set for each item of Q&A information in the cell display format file data, and when the Q&A site displays each item of Q&A information, the reference URL information is also displayed based on the cell display format file data.

7. The Q&A display system of claim 6, characterized in that, on a Q&A site displayed on a browser of the user terminal, when reference URL information is operated and the browser displays a site page based on the reference URL information, reference URL site display count information is reflected for each item of Q&A information in file data in cell display format, a score value is calculated by multiplying the evaluation information, display count information, and reference URL site display count information, and on the Q&A site, items of Q&A information with high score values ​​are displayed higher than items of Q&A information with low score values.

8. A Q&A display system as described in any one of claims 1 to 4, characterized in that publication period information is set for each item of Q&A information in the file data in cell display format, and based on current date and time information and the publication period information set for each item of Q&A information in the file data in cell display format, the Q&A site displays items of Q&A information that meet the conditions set by the publication period information, and does not display items of Q&A information that do not meet the conditions set by the publication period information.

9. A program for a Q&A display system that displays Q&A information set in an administrator terminal via a server in response to a request from a user terminal, a Q&A information setting step for saving Q&A information input and set in the file data in a cell display format displayed on the administrator terminal; a URL issuing step in which the server issues URL information corresponding to the file data in cell display format based on a deploy operation by an administrator; and a Q&A site display step in which, when the user terminal accesses a server based on the URL information, the browser of the user terminal displays a Q&A site related to Q&A information based on the file data in cell display format and a script that is pre-set in association with the file data in cell display format.

Images