JP2014115806A - System and method for supporting work automation - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a tool for automating routine work.SOLUTION: The work automation support system includes: a PC 101 having a browser operation recording agent for recording a browser process definition file and an operation screen in a file server 102 and an operation recording agent for recording a spreadsheet process definition file and a spreadsheet file of operation of a spreadsheet software in the file server 102; and a management server 103 which generates a pop-up screen for registering a logic expression designating an operation object as an identical tag or cell when an object tag or cell is always identical and a logical expression designating the operation object as a tag or cell corresponding to an operation object condition when the object tag or cell is different according to the condition, for each processing step of a processing flowchart generated from the browser process definition file, etc., and generates an input file for a work automation tool.

Description

  The present invention relates to a work automation support system and a work automation support method capable of recording routine work using browser software, spreadsheet software, and the like and automating a work process based on the work record, and particularly automated work. This invention relates to a work automation support system and a work automation support method capable of visualizing the work flow and determining the work automation effect.

  In recent years, enterprises have used browser software to access arbitrary websites to acquire necessary data, and then input the acquired data into predetermined spreadsheet software to perform tabulation. Has been done by. For example, in the work of contracting a number of employees with mobile phones and smartphones of different carriers according to the purpose and counting the charges based on the call performance of each person, the worker accesses the homepage of each carrier and uses it The work of checking the amount and inputting it into a spreadsheet software for tabulation prepared in advance is being performed.

  In this work, the worker confirms the actual amount of the corresponding month from the usage actual amount table on the homepage that has a different format for each carrier, and enters the actual amount in the corresponding person / month of the spreadsheet software for aggregation. Is repeated for each of a large number of employees.

  In general, when considering the automation of work within a company, the current work process is visualized and the effect of introducing the corresponding automation method is examined. In this process visualization, consultants and system engineers are considered. In general, a process flow diagram is manually created during or after a hearing by using a BPM (Business Process Management) tool in order to grasp a customer's business.

  In addition, the following patent document is mentioned as a document describing the technology related to the technology for visualizing the business work according to the prior art, and in Patent Document 1, the processing time acquisition unit is used in the business system from the execution history. Processing time, which is the time required to complete the processing, for each processing name that identifies the processing, for each resource identifier that identifies the resource used to execute the processing, and for a time zone in units specified in advance A processing time setting file describing the processing time is created, and when the order management unit generates an order according to the order generation time described in the order generation time list and performs a business simulation, the processing time setting file By acquiring the processing name and resource identifier of the order and the processing time that matches the current time, the system reflects the actual work. Patent Document 2 discloses a procedure for causing the business assignment support device to input a business requirement, a procedure for inputting names for identifying a plurality of systems, and importance of evaluation items and evaluation items. The procedure for inputting the evaluation item weight, the procedure for inputting the evaluation value of the evaluation item, and the output in a predetermined function that receives the evaluation value of the evaluation item and the weight of the evaluation item for each system of a plurality of systems. The procedure for calculating the value, the procedure for determining the system in charge of a given business task by comparing the output value for each system, and the correspondence information between the business task and the determined system A technique for supporting the design of a business system that uses a plurality of systems by executing the process including the procedure to be output as a result of the above is described.

JP 2008-299496 A JP-A-2004-213281

  The method of manually visualizing the process according to the above-mentioned prior art requires knowledge and experience about the process notation and the granularity of each step, and requires work time for creating a process flow diagram. There is a problem that it is difficult to improve the work by the person in charge, and the method of automatically visualizing the process from the log etc. described in the patent document can visualize the process of the business system, but the work that does not handle the business system There is a problem that the process cannot be visualized, and the technology that calculates the effect of automation cannot calculate the exact work time by manual calculation, and it takes time to measure the correct value, so it takes time. The task automation suggestion system uses multiple business systems. Work, there is a problem that can not cope with the tasks that do not use the business system.

  An object of the present invention is to solve the above-described problems of the prior art, and work automation support that can support creation of a work automation tool that performs routine software work using a browser and spreadsheet software. A system and a work automation support method are provided.

In order to achieve the above object, the present invention provides a computer for recording work processes to be automated for browsers and spreadsheet software, and a file server for storing work processes and log files recording files used in the work processes. A work automation support system that connects a management server that manages work processes stored in the file server and a database that manages information used by the management server,
A browser operation record agent for storing a browser process definition file and operation execution screen in a file server, and a spreadsheet process definition file and a spreadsheet file as information on operation of spreadsheet software. An operation recording agent stored in a file server,
A process in which the management server represents a flow of a plurality of processing steps for operating procedures of the browser and the spreadsheet software based on the browser process definition file and the operation execution screen and the spreadsheet process definition file and the spreadsheet file recorded in the file server. A flow display function unit created as a flowchart, and a flow conversion registration function unit that converts the browser process definition file and the spreadsheet process definition file into an input file of a work automation tool and registers them,
A first step in which the flow display function unit creates a processing flowchart based on the browser process definition file, the operation execution screen, a spreadsheet process definition file, and a spreadsheet file;
A first feature is that the flow conversion registration function unit executes a second step of generating an input file of a work automation tool based on a logical expression registered using a pop-up screen.

  Further, the present invention provides the work automation support system according to the first feature, wherein the pop-up screen is a target small item window for displaying a column position and a row position of a tag or a cell to be operated, and an operation target of the target A small item window for displaying an operation content of any of input, deletion, copying, pasting, or pressing that is operated on, and a value for displaying a numerical value operated on the operation target with respect to the target A second feature is that the logical expression is registered by editing display contents of the target small item window, the action small item window, and the value small item window. To do.

  In addition, the present invention is a work automation support system according to any one of the above features, and registers a logical expression for registering a repetition condition of a processing flowchart according to an operation procedure of a browser and a spreadsheet software created in the first step. The third feature is to generate a pop-up screen to be displayed.

  Further, the present invention is the work automation support system according to any one of the above features, wherein the operation recording agent and the operation recording agent have a time recording function for recording a real time when the browser and the spreadsheet software are operated. The fourth feature is that the operation actual time recorded by the time recording function and the trial execution time in which the work automation tool based on the input file generated in the second step is trially executed are compared and displayed. To do.

Furthermore, the present invention provides a computer that records a work process to be automated for a browser and spreadsheet software, a file server that stores a work process and a log file that records a file used in the work process, and the file A work automation support method in a computer system in which a management server for managing a work process stored in a server and a database for managing information used by the management server are connected,
In the computer, a browser operation record agent for storing a browser process definition file which is information for operating a browser and an operation execution screen in a file server, and a spreadsheet process definition file and a spreadsheet file which are information for operating spreadsheet software An operation recording agent for storing in a file server;
A process that represents the flow of a plurality of processing steps for operating procedures of the browser and the spreadsheet software based on the browser process definition file and the operation execution screen and the spreadsheet process definition file and the spreadsheet file recorded in the file server in the management server A flow display function part to be created as a flowchart, and a flow conversion registration function part for converting the browser process definition file and the spreadsheet process definition file into an input file of a work automation tool and registering them,
Causing the flow display function unit to execute a first step of creating a processing flowchart based on the browser process definition file, the operation execution screen, a spreadsheet process definition file, and a spreadsheet file;
A fifth feature is that the flow conversion registration function unit is caused to execute a second step of generating an input file of a work automation tool based on a logical expression registered using a pop-up screen.

  The present invention is the work automation support method according to the fifth feature, wherein the pop-up screen is a target small item window for displaying the column position and the row position of the tag or cell to be operated, and the target A small item window for an action that displays input, deletion, copying, pasting, or pressing operation contents operated on the operation target, and a numerical value operated on the operation target for the target are displayed. A sixth feature is that a logical item is registered by editing display contents of the target small item window, the action small item window, and the value small item window.

  The present invention is also a work automation support method according to any one of the above features, wherein a logical expression for registering a repetition condition of a processing flowchart according to an operation procedure of the browser and the spreadsheet software created in the first step is registered. A seventh feature is that a pop-up screen to be generated is generated.

  Further, the present invention is a work automation support method according to any one of the above features, wherein the operation recording agent and the operation recording agent are provided with a time recording function for recording a real time when the browser and the spreadsheet software are operated, The eighth feature is that the operation actual time recorded by the time recording function and the trial execution time in which the work automation tool based on the input file generated in the second step is trially executed are compared and displayed. .

  The work automation support system and the work automation support method according to the present invention include a first step in which a flow display function unit creates a process flowchart based on a browser process definition file, an operation execution screen, a spreadsheet process definition file, and a spreadsheet file. The flow conversion registration function unit executes a second step of generating an input file of the work automation tool based on the logical expression registered using the pop-up screen, thereby performing a routine using a browser and spreadsheet software. It is possible to support creation of a work automation tool for performing various software operations.

The figure which shows the whole structure of the work automation assistance system by embodiment of this invention. The figure which shows the functional structure of the computer by this embodiment. The figure which shows the functional structure of the management server by this embodiment. The figure which shows the processing flow which the system administrator by this embodiment registers a process conversion method. The figure which shows the processing flow which performs the recording of operation by this embodiment. The figure which shows the processing flow of the content confirmation of the work automation proposal by this embodiment. The figure which shows an example of the operation definition in the conversion registration function of the process management part by this embodiment. The figure which shows an example of the definition management table which matches and manages the operation definition by this embodiment, and the operation definition of an automation tool, and its data. FIG. 6 is a diagram illustrating an example of a status table for managing an operation record status and a log output destination for each PC according to the present embodiment, and data thereof. The figure which shows an example of the log image by this embodiment. The figure which shows an example of the folder image by which the operation log and capture by this embodiment were preserve | saved. The figure for demonstrating the detailed operation | movement of work automation by this embodiment.

Hereinafter, an embodiment of a work automation support system to which a work automation support method and a program according to the present invention are applied will be described in detail with reference to the drawings.
[Constitution]
As shown in FIG. 1, the work automation support system according to the present embodiment includes a computer (PC) 101 that records a work process to be automated according to the present embodiment, a file used in the work process, a log file that records the work, and the like. A file server 102 to be stored; a management server 103 that manages work processes recorded in the file server 102; a database (DB) 104 that manages information used in the management server 103; the computer 101 and the file server 102; A network 105 such as a LAN connecting the management server 103 and the database 104 is provided. In FIG. 1, only one computer 101 is illustrated, but when there are a plurality of workers, it is assumed that a computer for each worker is connected to the network 105.

[Computer 101]
As shown in FIG. 2, the computer 101 has a functional configuration for viewing an operation record management unit 201 that records a work process to be automated and an HTML document published on the web via the Internet. Browser software 204 and spreadsheet software 211 for performing tabulation and the like, and the hardware configuration is a storage means such as a CPU, a memory, a magnetic disk device, etc. as in a general computer The display unit, input / output devices such as a keyboard, various interface devices, basic software (OS), and software for realizing the operation record management unit 20, the add-on 205, and the macro 212 are included.

  The browser software 204 is installed with an add-on 205 (commercially available or free business flowchart simple drawing support tool) that is an extended function added to the application software. An operation determination function unit 207 that determines an inquiry to the operation recording system at the time of activation, and an operation record that records operation information (input, deletion, copy, paste, click, etc.) on the browser of the operator for the software A function unit 208; an operation log output function unit 209 that outputs the operation information recorded by the operation recording function unit 208 as a log to the shared folder of the file server 102; and a capture output function unit 210 that outputs a screen for performing the operation. The relevant Browser operation record agent 206 is operative to store in the shared folder of the file server 102 the screen when a user operation log and each operation as HTML. The agent used in the present application means a function and software for executing a plurality of functions for installed software.

  The spreadsheet software 211 is installed with a macro 212 (commercially available or free business flowchart simple drawing support tool) that is an extension function added to the application software, and the macro 212 is used as a spreadsheet operation recording agent 213. An operation determination function unit 214 that inquires the operation recording system to determine whether an operation should be recorded when the spreadsheet software is started, and an operation recording function that records operation information (input / delete / copy / paste / click, etc.) of the operator for the software. Unit 215, an operation log output function unit 216 that outputs the operation information recorded by the operation recording function unit 215 as a log to the shared folder of the file server 102, and a spreadsheet that converts the spreadsheet file at the time of each operation to HTML Capture output function unit that outputs to And a 17, the spreadsheet operation recording agent 213 is operative to output a spreadsheet file converted to the user's operation log and HTML files in a shared folder on the file server 102.

  The operation record management unit 201 includes an agent cooperation function unit 202 that exchanges information with the browser operation record agent 206 of the browser software 204 and the spreadsheet operation record agent 213 of the spreadsheet software 211, and a process of the management server 103 described later. The server cooperation function part 203 which exchanges information with the management part 302 is provided, the information sent from the process management part 302 mentioned later, the information delivered to it, and the information delivered to the browser operation recording agent 206 and the spreadsheet operation recording agent 213 And it operates to manage the information generated there.

[Management Server 103]
As shown in FIG. 3, the management server 103, as a process management unit 302 for creating, displaying, and editing work processes, is an automation in which a company information system administrator selects a process definition file generated when an operation is recorded. Flow conversion registration function unit 303 for defining a method for conversion as an input file of the tool, a flow display function unit 304 for displaying the recorded process flow diagram to the user, and start and end when the user records the operation A recording start point / end point reporting function unit 305 for notifying the system realized in the present embodiment of the timing, a flow conversion function unit 306 for converting a process definition file generated by operation recording into a definition file according to the definition method, Create a process from the operation log and capture sent from the operation record management unit 201 A flow calculation function unit 307 that edits the process definition file according to the editing contents of the user, an operation record management unit cooperation function unit 308 that exchanges information with the operation record management unit, and data management that exchanges data with the database 104 And a functional unit 309.

  The data recorded in the database 104 is arranged in a status table storing operation records for each computer shown in FIG. 9, a spreadsheet log and browser operation log shown in FIG. 10, and a log storage folder shown in FIG. The status table of FIG. 9 includes a machine name of the computer, a status (ON / OFF) indicating an operation state, and each item information of a storage location of the operation log. The operation log 10 includes item information of an operation date / time, an operation target cell or tag, an operation type (input, copy, click), and an operation value, and is arranged in a log storage folder illustrated in FIG. Log and capture are the log name of browser operation or spreadsheet operation, the HTML name of browser, and the contents of log or capture contents It is composed of a broadcast.

[Operation]
Next, the operation of the work automation support system according to this embodiment will be described.
[Initial setting operation]
First, the work automation support system according to the present embodiment registers the definition of an input file for causing the automation tool to perform a specific operation as advance preparation for performing work automation, as shown in FIG. A step 401 that the system administrator accesses from the browser using the flow conversion registration function unit 303 of the process management unit 302 of the management server 103, and an automated tool process that represents processing such as data input, data deletion, data extraction, and loop Step 402 of registering the description method is executed.

  Registration of the process description method of the automated tool in the step 402 is expressed as a tag shown on the left side of FIG. 7 in the case of an operation of inputting a character string “original string” in the third row and third column of the table on the browser. As shown on the right side of FIG. 7, the operation definition of the automation tool corresponding to the input operation can be expressed. In the example shown on the right side of FIG. 7, the character string starting with “@” represents a variable that can be used in this embodiment conversion registration, and is configured so that the value of the specific tag shown in the left figure can be inserted at an arbitrary location.

  For example, when the target variable is “@ 1234567.operation.location.left [1]”, one character from the left of the character string described in the “location” tag in the “operation” tag in the step where id is 1234567 If the target variable is “@ 1234567.operation.value”, the value described in the “location” tag in the “operation” tag of the same step is acquired and substituted. It means that. The registered information is registered in the definition management table of the database 104 through the data management function unit 309 of the process management unit 302. The definition management table of the database 104 is a process on the left side in the figure as shown in FIG. It is expressed as a flow and a conversion flow on the right side in the figure.

  In addition, software that automates browser operations based on the above-described operation definitions described in XML and calls specified macros to automate operations with spreadsheet software is already available on the market. Is premised on selecting software with such a mechanism in advance.

[User operation recording operation]
Next, the work automation support system according to the present embodiment performs an operation of recording an operation by a user who is considering the automation of the work, and the operation record management unit 201 / browser described above is stored in the computer 101 for user work. It is assumed that the operation recording agent 206 and the spreadsheet operation recording agent 213 are installed in advance.

  In addition, the work applied to the present embodiment is that the user accesses the homepages of a plurality of mobile carrier companies, for example, while using the work automation support system shown in FIG. The work automation support system according to the present embodiment performs the following in the confirmation and input work for each employee as follows: Operate.

  As shown in FIG. 5, the user operation recording operation by the work automation support system according to the present embodiment is performed by a user starting browser software 204 from an arbitrary computer 101 and recording start / end points of the process management unit 302 in the management server 103. By executing step 501 for accessing the reporting function unit 305 and step 502 for inputting the computer name to be operated in the text box displayed on the browser of the site accessed in step 501 and clicking the start button, The process management unit 302 passes the computer name information to the flow calculation function unit 307, and the flow calculation function unit 307 to which the computer name information is transferred stores the status related to the operation record and the log of the operation record through the data management function unit 309. Fo If the status of the corresponding server is OFF, it is set to ON, and a browser and spreadsheet log output destination folder are created, and the operation record management unit linkage function unit 308 The output destination is delivered, and the operation record management unit cooperation function unit 308 delivers this information to the server cooperation function unit 203 in the operation record management unit 201 of the computer 101 designated by the user and notifies the start of the operation record processing. To work.

  Next, in the user operation recording operation by the work automation support system, preparation for recording the operation is completed by the operation up to the step 502, and the message indicating that the preparation is completed is stopped on the web screen where the user presses the start button. A button is displayed, step 503 for starting work using the computer 101 designated by the user, and when the user's work is finished, the user clicks the record end button of the browser accessed in step 501 It operates to execute step 504 that terminates the process.

  In step 503, when the user activates the browser in order to obtain a mobile use record from, for example, a mobile carrier company, the work automation support system according to the present embodiment performs the operation determination function unit 207 of the browser operation recording agent 206. The agent cooperation function unit 202 of the operation record management unit 201 is inquired about the necessity of operation record. Since the operation record management unit 201 receives a start instruction from the process management unit 302 together with the output destination information of the log file, the browser operation record agent A log file output destination information and an operation recording start instruction are returned to 206.

  In response to this, the browser operation recording agent 206 starts recording the operation, and the operation recording function unit 208 that has started the operation recording caches the screen at the time of loading as HTML and the log specified through the capture output function unit 210. The operation record on the screen is output to the folder, and the operation record function unit 208 of the added-on agent operates so that the operation of the mouse and the keyboard when pointed to the screen display unit of the browser is managed based on the HTML tag. When the user's operation is completed and the user closes the browser, the log information recorded by the operation record function unit 208 is transferred to the operation log output function unit 209 and designated by the operation record management unit 201. Log with operation time, operation target HTML tag, operation contents, and input / output data in the log storage location It operates to output a Airu (Figure 10).

  In the step 503, when the spreadsheet software is started in order to collect the mobile use results referred to by the user using the browser, the work automation support system according to the present embodiment is the same as the case of the browser described above. In addition, the operation determination function unit 214 of the spreadsheet operation recording agent 213 confirms the necessity of the operation recording, the operation recording function unit 215 starts the operation recording, and the operation recording function unit 215 performs the spreadsheet before the operation starts. The file is converted into HTML, output to the log output destination specified by the operation record management unit 201 via the capture output function unit 217, and then input based on the operation cell performed using spreadsheet software. Operations such as copying are managed, and when the user finishes the operation and stops the spreadsheet software, the operation record recorded by the operation record function unit 215 is stored. Is transferred to the operation log output function unit 216 and outputs a log file (FIG. 10) in which the operation time, operation target cell, operation content, and input / output data are written in the log storage location designated by the operation record management unit 201. To work.

[Automated operation]
Next, the work automation support system according to the present embodiment executes an operation in which a user confirms work automation, and an outline of this work automation operation will be described with reference to FIG.

  As shown in FIG. 6, this work automation operation is first displayed on the flow display screen displayed in step 601 in which the user accesses the flow display in the process management unit 302 of the management server 103 using browser software. Step 602 for inputting the name of the PC that has performed the work recording in the text box is executed, and the PC name input by the flow display function unit 304 of the work automation support system of this embodiment is input to the flow calculation function unit 307. The flow calculation function unit 307 refers to the status management table to confirm that the status of the target machine (computer) is OFF, and obtains the log from the log storage location stored in the table. , Arrange operation logs in time series (sort) and define operations in XML file in that order An XML file arranged in order (sorted) is created, the created XML file is transferred to the flow display function unit 304, and the flow display function unit 304 creates a flow diagram that is easy for the user to understand the processes defined in the XML file. Operates to convert and display in browser.

  Next, the work automation operation according to the present embodiment returns to FIG. 6, and executes step 603 in which the user adds a criterion to be processed to the flow displayed on the browser. The addition of the judgment criteria by the user in step 603 determines whether the user always processes the same tag or cell for each step in the flow, or whether the tag or cell to be processed differs depending on the condition. Then, when registering in a cell that realizes work automation, or when specifying a condition, it is performed by inputting a judgment condition for processing based on a captured screen image.

  Next, the work automation operation according to the present embodiment includes a step 604 in which a user inputs a data handling method to be input to or extracted from the processing target after registering the determination of the processing target in step 603 and the step 604. When the input is completed, step 605 for inputting a process repetition process is executed.

  In this work automation operation, when the data handling method is input in the step 604, the calculation method of the input value is input, and when extracting, the processing is performed so that the value is stored in a variable so that the value can be used in the subsequent step. Registration and repetitive registration in step 605 are defined by inserting a step representing a loop between each step and registering a repetitive condition using a pop-up screen (not shown) based on the captured screen image. To work. This repeated registration is defined by inserting a step representing a loop between each step and registering a repeated condition based on the captured screen image. Step 605 for inputting the repetitive processing of the process is not shown in the figure, but based on, for example, the number of repetitions of Step S11, Step S12 and Step S13, or the access target registered in advance in the spreadsheet software for counting. The number of repetitions is set (for example, the telephone number of the employee to be aggregated is registered in the spreadsheet software for aggregation and the cell in which the telephone number is registered by the search is targeted).

  The work automation support system according to the present embodiment transfers the XML file edited by the user in steps 603 to 605 described above to the flow calculation function unit 307 and the flow conversion function unit 306, and the flow calculation function unit 307 performs the editing XML file. An XML file in which the time spent on work (actual work time) is calculated based on log information and repetitive information defined by the user, and the flow conversion function unit 306 refers to the definition management table and defines the process Is converted into a definition recognized by the automation tool, and after the processing of the flow calculation function unit 307 and the flow conversion function unit 306 is completed, the time and the automation tool can be reduced when the user browser is automated. Operates to display a definition file for doing the same work.

  When step 606 of pressing the automation effect calculation button displayed on the browser when the above registration processing is completed is executed, the system defines the actual work time calculated by the flow calculation function unit 307 described above. By automatically accessing the homepage defined using the definition file of the automated tool and working with spreadsheet software, and comparing and displaying the time required for this trial work and the actual work time Step 606 for confirming the displayed automation effect is executed, and when the displayed automation effect is confirmed in a short time, Step 607 for downloading the process definition file of the automation tool is executed and the process is terminated. The definition file downloaded in step 607 is read by the tool. It is possible to realize automation in the.

[Detailed operation of work automation]
Next, details of the work automation operation in steps 603 to 604 will be described with reference to FIG. The flow shown on the left side of FIG. 12 is an example in which a series of operations for inputting the portable use results to the spreadsheet software for aggregation with reference to the plurality of carriers displayed in step 603 is represented vertically, Step S11 representing the process of accessing the homepage and referring to the usage record, and the process of copying the value (¥ 1000000) of the text box in the third row and the third column of the mobile performance fee table of the carrier d company's homepage Step 12 and step S13 representing the process of inputting the usage record (¥ 1000000) copied in step 12 to the cell in column C, line 51 (see FIG. 12B) of the spreadsheet software for tabulation, It is determined whether or not the processing from step S11 to step S13 has been repeated. When it is determined that the processing has been repeated, the step is performed. Carrier a including d company target work 10 for carrier d company consisting of step S14 returning to S11, similarly, step S21 representing use record reference processing, step S22 representing copying processing, and step S24 representing determination processing A company target work 20 for company a, and a company S target work 30 for carrier S including step S31 representing use result reference processing, step S32 representing copy processing, and step S34 representing determination processing, It is expressed as a series of work procedures that the process is completed by performing.

  The browser and spreadsheet calculation target judgment criteria for the displayed flow in step S603 are registered by the flow conversion registration function unit 303 of the process management unit 302 of the management server 103 according to this embodiment. The initial screen 40 including the pop-up screen 70a corresponding to the above and the pop-up screen 70b corresponding to step S13 is displayed.

  This pop-up screen 70a displays the operation of the user in step S12 as “target” as the operation target, “action” as the operation content for the operation target, “value” as the operation target, and “parameter” as the parameter. A small item window consisting of each item information is displayed. In this example, the operation target of the user's browser is the operation target of the mobile service fee table of the carrier d company homepage, and the usage record is “¥ 1000000”. The “target” is displayed as “third row, third column” (3tr, 3td), “action” is “COPY”, “value” is “1000000”, and the parameter is displayed as a blank.

  The pop-up screen 70b displays the operation of the user in step S13 as “target” as the operation target, “action” as the operation content for the operation target, “value” as the operation target, and “parameter” as the parameter. In this example, the operation target cell of the user's spreadsheet software is “C51” (see FIG. 12B), and the copied usage record is “¥ 1000000”. “Target” is displayed as “C51”, “Action” is “input”, “Value” is “1000000”, and the parameter is displayed as blank.

  Here, the user confirms the display content of the initial screen 40, maintains the “target” in the pop-up screen 70a of the processing step 12 for the browser for fixing, changes the “action” to “assign”, The parameter is changed to a pop-up screen 80b in which “aaa”, which is an arbitrary variable, is input, and “look (c50: e50) which is a logical expression for searching for the“ target ”on the pop-up screen 70b in step S13 for spreadsheet software , D company) ”(in this example, the target cell of“ d company ”is exemplified as a logical expression for searching in the range of cells“ c50 to e50 ”and is different from the actual logical expression). , Change to the post-edit screen 41 including the pop-up screen 80b in which the variable “aaa” set for the browser is input in “parameter” And it makes it possible to register the processing target criteria.

  The processing target determination criterion is that, as in the post-edit screen 41, the “value” of the cell in the third row and the third column on the browser screen is assigned to the parameter “aaa” as a target, and is assigned to the parameter “aaa”. “Value” is searched for the C column cell to be input in the range of the 50th column to the 100th column of the C column in the spreadsheet of the spreadsheet software, and the value “10000000” of the parameter “aaa” is searched for the searched C column cell. ", And the flow conversion registration function unit 303 operates so as to register it as a processing target determination criterion and a data handling method.

  The work automation support system according to the present embodiment changes the processing target determination criteria and the data handling method for the carrier a company from the pop-up screen 50 before editing to the pop-up screen 51 after editing, to the carrier S company. Changes the pop-up screen 60 before editing to the pop-up screen 61 after editing, and operates so as to be registered as a processing object judgment standard and a data handling method in the same manner as the carrier d company.

As described above, the work automation support system according to the present embodiment stores the computer 101 that records the work process to be automated for the browser and the spreadsheet software, the file used in the work process, the log file that records the work, and the like. A file server 102, a management server 103 that manages work processes recorded in the file server 102, and a database 104 that manages information used by the management server 103 are connected via a network 105.
The computer 101 records a browser process definition file that is information on operating a browser and a browser operation recording agent 206 that records an operation execution screen and outputs the operation execution screen to the file server 102; and a spreadsheet process definition file that is information that operates spreadsheets And an operation recording agent 213 that records the spreadsheet file and outputs it to the file server 102,
Based on the browser process definition file and the operation execution screen, the spreadsheet process definition file and the spreadsheet file recorded by the management server 103 in the file server 102, the operation procedure of the browser and spreadsheet software is processed through a plurality of processing steps. A flow display function unit 304 created as a processing flowchart to represent, and a flow conversion registration function unit 303 that converts the browser process definition file and the spreadsheet process definition file into an input file of a work automation tool and registers them.
A first step in which the flow display function unit 304 creates a process flowchart based on the browser process definition file, the operation execution screen, the spreadsheet process definition file, and the spreadsheet file;
Logic that the flow conversion registration function unit 303 designates the operation target as the same tag or the same cell whenever the target tag or cell is always the same for each processing step of the processing flowchart created by the flow display function unit A second step of generating a pop-up screen (70a, 70b) for registering an expression and a logical expression that is designated as a tag or cell according to the operation target condition when the target tag or cell differs depending on the condition;
Creating an input file for a work automation tool based on a logical expression registered using the pop-up screen generated in the second step, and creating a work automation tool for performing routine software work using a browser and spreadsheet software Can help.

  Further, in the present invention, following the first step, when the flow conversion registration function unit always has the same target tag or cell for each processing step of the process flowchart created by the flow display function unit. A pop-up screen for registering a logical expression that specifies an operation target as the same tag or cell and a logical expression that is specified as a tag or cell according to the operation target condition when the target tag or cell differs depending on the condition A second process to be generated and an input file for the work automation tool are generated based on the registered logical expression using the pop-up screen generated by the second process, and a work automation tool is generated based on the generated input file The third step may be executed, and the above steps may be configured by a program.

40 initial screen, 41 post-edit screen, 50-60 pop-up screen,
60-61 pop-up screen, 70a-70b pop-up screen,
101 computer, 102 file server, 104 database,
105 network, 201 operation record management unit,
202 Agent cooperation function part, 203 Server cooperation function part,
204 browser software, 205 add-on 206 browser operation recording agent, 207 operation determination function unit,
208 Operation recording function part, 209 Operation log output function part,
210 capture output function unit, 211 spreadsheet software, 212 macro,
213 spreadsheet operation recording agent, 214 operation determination function unit,
215 operation record function unit, 216 operation log output function unit,
217 capture output function unit, 302 process management unit,
303 flow conversion registration function unit, 304 flow display function unit,
305 Recording start / end point reporting function, 306 Flow conversion function,
307 flow calculation function unit, 308 operation record management unit cooperation function unit,
309 Data management function part

Claims (8)

Computer for recording work process to be automated for browser and spreadsheet software, file server for storing work process and log file for recording file used in the work process, and work process stored in the file server A work automation support system that connects a management server that manages a database and a database that manages information used by the management server
A browser operation record agent for storing a browser process definition file and operation execution screen in a file server, and a spreadsheet process definition file and a spreadsheet file as information on operation of spreadsheet software. An operation recording agent stored in a file server,
A process in which the management server represents a flow of a plurality of processing steps for operating procedures of the browser and the spreadsheet software based on the browser process definition file and the operation execution screen and the spreadsheet process definition file and the spreadsheet file recorded in the file server. A flow display function unit created as a flowchart, and a flow conversion registration function unit that converts the browser process definition file and the spreadsheet process definition file into an input file of a work automation tool and registers them,
A first step in which the flow display function unit creates a processing flowchart based on the browser process definition file, the operation execution screen, a spreadsheet process definition file, and a spreadsheet file;
A work automation support system, wherein the flow conversion registration function unit executes a second step of generating an input file of a work automation tool based on a logical expression registered using a pop-up screen.   The pop-up screen is a target small item window that displays the column position and row position of the tag or cell that is the operation target, and any of input, deletion, copying, pasting, or pressing operated on the target operation target. An action small item window for displaying the operation content, and a value small item window for displaying a numerical value operated on the operation target with respect to the target, the target small item window and the action small item. 2. The work automation support system according to claim 1, wherein the logical expression is registered by editing display contents of a window and a small value item window.   2. The pop-up screen for registering a logical expression for registering a repetition condition of a processing flowchart according to an operation procedure of a browser and spreadsheet software created in the first step is generated in the second step. Or the work automation support system of 2 description.   The operation recording agent and the operation recording agent have a time recording function for recording the actual time when the browser and the spreadsheet software are operated, and the operation actual time recorded by the time recording function is generated by the second step. 4. The work automation support system according to claim 1, wherein the work automation support system displays a comparison with a trial execution time when the work automation tool based on the input file is executed on a trial basis. Computer for recording work process to be automated for browser and spreadsheet software, file server for storing work process and log file for recording file used in the work process, and work process stored in the file server A work automation support method in a computer system in which a management server for managing a database and a database for managing information used by the management server are connected,
In the computer, a browser operation record agent for storing a browser process definition file which is information for operating a browser and an operation execution screen in a file server, and a spreadsheet process definition file and a spreadsheet file which are information for operating spreadsheet software An operation recording agent for storing in a file server;
A process that represents the flow of a plurality of processing steps for operating procedures of the browser and the spreadsheet software based on the browser process definition file and the operation execution screen and the spreadsheet process definition file and the spreadsheet file recorded in the file server in the management server A flow display function part to be created as a flowchart, and a flow conversion registration function part for converting the browser process definition file and the spreadsheet process definition file into an input file of a work automation tool and registering them,
Causing the flow display function unit to execute a first step of creating a processing flowchart based on the browser process definition file, the operation execution screen, a spreadsheet process definition file, and a spreadsheet file;
The flow conversion registration function unit causes the flow conversion registration function unit to execute a second step of generating an input file of a work automation tool based on a logical expression registered using a pop-up screen. Work automation support method.   The pop-up screen is a target small item window that displays the column position and row position of the tag or cell that is the operation target, and any of input, deletion, copying, pasting, or pressing operated on the target operation target. An action small item window for displaying the operation content, and a value small item window for displaying a numerical value operated on the operation target with respect to the target, the target small item window and the action small item. 6. The work automation support method according to claim 5, wherein the logical expression is registered by editing display contents of a window and a small value item window.   6. The pop-up screen for registering a logical expression for registering a repetition condition of a processing flowchart according to an operation procedure of the browser and spreadsheet software created in the first step is generated in the second step. Or the work automation support method of 6.   The operation recording agent and the operation recording agent are provided with a time recording function for recording the actual time when the browser and the spreadsheet software are operated, and the operation actual time recorded by the time recording function and the input generated by the second step. 8. The work automation support method according to claim 5, further comprising displaying a comparison with a trial execution time when the work automation tool based on a file is executed on a trial basis.

Images