WO2020170973A1 - オートメーション方法、オートメーションシステムおよびオートメーションプログラム - Google Patents
オートメーション方法、オートメーションシステムおよびオートメーションプログラム Download PDFInfo
- Publication number
- WO2020170973A1 WO2020170973A1 PCT/JP2020/005827 JP2020005827W WO2020170973A1 WO 2020170973 A1 WO2020170973 A1 WO 2020170973A1 JP 2020005827 W JP2020005827 W JP 2020005827W WO 2020170973 A1 WO2020170973 A1 WO 2020170973A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- macro
- execution
- automation
- unit
- information
- Prior art date
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/30—Arrangements for executing machine instructions, e.g. instruction decode
- G06F9/3017—Runtime instruction translation, e.g. macros
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
Definitions
- the present invention relates to an automation method, an automation system and an automation program.
- Macro recording is known as an automation method that does not depend on the character user interface in conventional spreadsheet software. Although macro recording can provide an intuitive user experience, it is difficult to set branch processing and iteration processing among sequential execution, branch processing, and iteration processing, which are three elements of programming (Non-Patent Document 1). Reference 1).
- a browser operation recording agent that stores a browser process definition file and an operation screen in a file server, and an operation that stores a spreadsheet process definition file and a spreadsheet file of a spreadsheet software operation in a file server
- a PC having a recording agent, and a logical expression for always designating the operation target as the same tag or the same cell for each processing step of the processing flow chart created from the browser process definition file etc.
- a management server that generates a pop-up screen that registers 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, and generates the input file of the work automation tool.
- a work automation support system equipped with it has been reported.
- Patent Document 1 it is not possible to record all the operations based on the intuitive operation for the user such as the graphical user interface.
- the target of the user operation on the pop-up screen is limited to at least a part of the operation content to be automated.
- the character user interface such as programming
- the present invention has been made in view of the above situation, and it is a problem to be solved to realize an automation method that improves the user experience in software operation more simply.
- the present invention is an automation method, wherein an implementation step of registering one or more information processing and a macro including an execution order related to the one or more information processing is provided in a processor of a computer. Let it run.
- one or more fragmented software operations can be defined as a macro.
- an automation method in which macro designation is used as a turning point, one or more information processes are sequentially executed based on an execution order, and at least one designation of one or more information processes is used as a turning point,
- the processor of the computer is further caused to execute the execution step of individually executing at least one of the one or more information processes.
- one or more fragmented software operations included in a macro can be individually executed.
- the implementation steps are based on a graphical user interface.
- each of intention input of sequential execution and individual execution of one or more subdivided software operations can be realized based on an intuitive user interface.
- the implementation step associates one or more information processes with a branch process and/or an iterative process.
- branching processing and iterative processing which have been difficult in the past, can be realized on the same graphical user interface.
- the information processing is spreadsheet processing.
- the macro is associated with a spreadsheet.
- the mounting step stores the macro in a main storage device as a volatile cache area.
- the mounting step stores the macro in an auxiliary storage device as a non-volatile data area.
- the execution step stores the macro in a main storage device as a volatile cache area.
- the executing step stores the macro in an auxiliary storage device as a non-volatile data area.
- the present invention is an automation system, and has implementation means for registering one or more information processes and a macro containing an execution order related to the one or more information processes.
- the present invention is an automation program that causes a computer to function as a mounting unit that registers one or more information processes and a macro including an execution order related to the one or more information processes. ..
- an automation method that improves the user experience in software operation can be provided more simply.
- FIG. 3 is a hardware configuration diagram in the first embodiment. 3 is a functional block diagram in Embodiment 1.
- FIG. 6 is a processing flowchart in the first embodiment. 3 is a schematic diagram of a macro according to the first embodiment.
- FIG. 7 is an example of an implementation screen when a format tab of a process designation unit is designated in the first embodiment. 6 is an example of a mounting screen when the condition specifying of the condition specifying unit is specified in the first embodiment. 7 is an example of an implementation screen when a copy cut tab of the process specifying unit is designated in the first embodiment. 6 is an example of a mounting screen when an input tab of the process specifying unit in the first embodiment is specified. 7 is an example of an implementation screen when a data tab of a process designation unit is designated in the first embodiment.
- FIG. 9 is an example of a mounting screen when another tab of the process specifying unit in the first embodiment is specified.
- 7A and 7B are examples of a sequential execution screen and an individual execution screen in the first embodiment.
- FIG. 6 is a hardware configuration diagram in the second embodiment.
- 7 is a functional block diagram in the second embodiment.
- FIG. 7 is a functional block diagram in Embodiment 3.
- FIG. 13 is a functional block diagram in the fourth embodiment. It is a functional block diagram in Embodiment 5. It is a functional block diagram in Embodiment 6. It is a functional block diagram in Embodiment 7. It is a functional block diagram in Embodiment 8.
- Embodiment 1 of a system according to the present invention will be described with reference to the drawings.
- the program P0 may be stored in a recording medium. If the recording medium is used, as an example, the program P0 can be installed in the computer device 1.
- the recording medium storing the program P0 is, for example, a non-transitory recording medium such as a CD-ROM or a flash memory. Further, even when the program P0 is distributed through an electric line, it is obvious that a recording medium is indispensable as a provider/storage destination of the program P0.
- the program P0 includes a source code or a binary and is appropriately encrypted.
- the system includes a computer device 1.
- the computer device 1 includes a calculation device 11, a main storage device 12, an auxiliary storage device 13, an input device 14, an output device 15, a communication device 16, and a bus interface for interconnection.
- the computer device 1 can be connected to the network NW.
- the hardware resources of the system are used at least to realize the functions of the program P0.
- the arithmetic unit 11 includes a processor core, which is a CPU (Central Processing Unit) as an example.
- a processor core which is a CPU (Central Processing Unit) as an example.
- the main storage device 12 includes a volatile device such as a RAM (Random Access Memory) as an example.
- the auxiliary storage device 13 includes a non-volatile device such as an HDD (Hard Disk Drive) and an SSD (Solid State Drive).
- the auxiliary storage device 13 stores each of the data related to the OS (Operating System) and the program P0.
- the auxiliary storage device 13 may include a primary storage and one or more secondary storages.
- the auxiliary storage device 13 has a database.
- the computer device 1 may include a SoC (System-on-Chip) in which the processor core and ASIC (Application Specific Integrated Circuit) are aggregated.
- the processor including the processor core may be a programmable device.
- the ASIC refers to, for example, a DSP (Digital Signal Processor) such as a hardware encoder/decoder or a ML (Machine Learning) dedicated processor.
- the computer apparatus 1 may include a memory device having a volatile cache area and a non-volatile data area.
- the input device 14 is used for input processing of data related to the system.
- the input device 14 includes at least one of a keyboard, a touch panel, a microphone, and an image sensor. At this time, there is no limitation on the method of the input processing.
- the output device 15 is used for display processing of the system.
- the output device 15 includes a visual display device such as a display device or a projection device such as an LCD (Liquid Crystal Display), and a graphic controller such as a GPU (Graphics Processing Unit).
- the graphic controller may be included in the SoC.
- the output device 15 may be a device that contacts at least a part of the body, such as a head-mounted display.
- the communication device 16 is used for communication processing including data transmission/reception via the network NW.
- the communication device 16 supports wireless communication based on Wi-Fi (registered trademark) and/or wired communication based on Ethernet (registered trademark).
- the communication device 16 includes a transceiver for performing electric communication using radio waves or light waves, and its wavelength band is not limited.
- the communication protocol of the network NW in the system is TCP/IP (Transmission Control Protocol/Internet Protocol) or the like.
- the network NW can use a wired line such as an optical line or a CATV (Community Antenna Television) line, or a wireless line such as an outgoing communication network, an aviation communication network, a satellite communication network, etc. Including.
- a wired line such as an optical line or a CATV (Community Antenna Television) line
- a wireless line such as an outgoing communication network, an aviation communication network, a satellite communication network, etc.
- the computer device 1 takes the form of a data terminal device such as a laptop computer, a workstation, a smartphone and a wearable device. Each of the one or more computer devices 1 may realize the introduction of the program P0 to any of the one or more computer devices 1 by cooperating with the one or more computer devices 1.
- the system has an input unit 101, an output unit 102, a mounting unit 103, and an execution unit 104.
- the function related to the system is realized in cooperation with the function of the spreadsheet.
- the input means 101 is used for input processing of data related to the system.
- the input unit 101 performs data input processing via the input device 14.
- the data includes one or more information processings according to the embodiment of the present invention and an execution instruction of the one or more information processings.
- the input means 101 may perform the input process of the said data via an application programming interface.
- the input processing of the data by the input unit 101 is preferably realized in cooperation with the screen display processing by the output unit 102.
- the output unit 102 uses the output device 15 to display the data related to the system.
- the display process includes provision of a user interface (screen display) for a data input process.
- the output unit 102 may perform the display processing via the application programming interface.
- the output unit 102 is used for displaying the mounting screen W1, the sequential execution screen W2, and the individual execution screen W3. At least a part of each of the mounting screen W1, the sequential execution screen W2, and the individual execution screen W3 may be subjected to display processing so as to be superimposed on the screen related to the spreadsheet. At least a part of each of the mounting screen W1, the sequential execution screen W2, and the individual execution screen W3 receives the input processing via the pull-down format input form.
- the output unit 102 can appropriately set drawing conditions including color designation in the screen display for the purpose of facilitating data input processing in the screen display. The designation of the drawing condition is appropriately saved in the setting file.
- the mounting means 103 registers a macro including one or more information processes and an execution order related to the one or more information processes.
- the information processing refers to, for example, spreadsheet processing including operation processing on spreadsheet software.
- the mounting unit 103 associates one or more information processes with a branch process and/or an iterative process based on the graphical user interface.
- the graphical user interface is based on the screen display by the output means 102.
- the mounting unit 103 makes a decision regarding information processing based on the information specified by the input unit 101 on the mounting screen W1.
- the execution unit 104 uses the macro designation as a turning point to sequentially execute one or more information processing based on the execution order, and uses at least one designation of the one or more information processing as a turning point to perform at least one of the one or more information processing. Individual execution of one The execution means 104 performs the sequential execution or individual execution based on the graphical user interface. The graphical user interface is based on the screen display by the output means 102. The execution means 104 executes information processing based on the information designated by the input means 101 on the sequential execution screen W2 or the individual execution screen W3.
- the execution unit 104 may be configured to store the macro on the main storage device 12 as a volatile cache area.
- the execution unit 104 may be configured to store the macro on the auxiliary storage device 13 as a non-volatile data area. Further, the execution unit 104 may be configured to perform the macro output processing in cooperation with the output unit 102.
- the output processing includes output processing related to the macro itself and output processing related to the execution result of the macro. ..
- Each of the one or more information processing corresponds to the information related to each of the object, the method and the property.
- the object is a processing target, and is a cell range as an example.
- the method is an instruction for operating the object, and for example, clearing the value of the cell.
- the property is a value in the cell range as an example.
- the functions related to the system are implemented on a spreadsheet as an example.
- Spreadsheets are based on multiple layers of data that follow a book, sheet, and cell order. In the spread sheet, cells and books, which are arranged in a grid, correspond to identifiers.
- the spreadsheet is Excel (registered trademark) as an example.
- Information related to macros or steps as well as data on a spreadsheet is stored/referenced on a database. At this time, the information related to the macro or step may be stored/referenced on a different database.
- the macro language for describing the program P0 including the macro associated with the spreadsheet according to the present invention is not limited to Visual Basic (registered trademark) for Applications (VBA), which is a macro language of Excel (registered trademark), and is not limited to VBA. Other macro languages may be used.
- the program P0 may be written based on a programming language such as C++ (registered trademark) or Python (registered trademark). There is no limitation on the programming language for writing the program P0
- step S1 automation setting is started.
- step S2 the output means 102 performs the display process of the sequential execution screen W2.
- step S3 the output unit 102 displays the mounting screen W1.
- step S4 the mounting means 103 specifies an object.
- step S5 the mounting means 103 specifies conditions.
- step S6 the mounting means 103 specifies processing.
- step S9 the process related to sequential execution is started.
- step S10 the output unit 102 sequentially performs the display process of the execution screen W2.
- step S11 the input means 101 designates a macro.
- step S12 the execution unit 104 performs the reading process of the execution order. If there is information processing that has not been executed and the execution order is the highest (step S13, Y (Yes)), the process proceeds to step S14. If there is no information processing that has not been executed and has the highest execution order (step S13, N (No)), the process proceeds to step S20.
- step S14 the execution unit 104 specifies the information processing that has not been executed and that has the highest execution order.
- step S15, Y (Yes) When there is an unprocessed object in the iterative processing range (step S15, Y (Yes)), the process proceeds to step S16.
- step S15, N (No) When there is no unprocessed object in the iterative processing range (step S15, N (No)), the process proceeds to step S19.
- step S16 the execution unit 104 specifies an unprocessed object in the iterative processing range.
- the property of the unprocessed object in the iterative processing range matches the condition of the branching processing included in the information processing (step S17, Y (Yes)
- the process proceeds to step S18.
- step S17, N (No) When the property of the unprocessed object in the iterative processing range does not match the condition of the branching process included in the information processing (step S17, N (No)), the process proceeds to step S15.
- step S18 the execution unit 104 executes the method and the property corresponding to the information processing.
- step S19, Y (Yes) When there is information processing that has not been executed and the execution order is the highest (step S19, Y (Yes)), the process proceeds to step S14. If there is no information processing that has not been executed and has the highest execution order (step S19, N (No)), the process proceeds to step S20.
- step S20 the process related to sequential execution ends.
- step S21 the process related to individual execution is started.
- step S22 the output unit 102 displays the individual execution screen W3.
- step S23 the input means 101 designates a step (information processing).
- step S24, Y the process proceeds to step S25.
- step S24, N no unprocessed object in the iterative processing range
- step S29 the execution means 104 specifies an unprocessed object in the iterative processing range.
- step S26, N (No) When the property of the unprocessed object in the iterative processing range does not match the condition of the branching process included in the information processing (step S26, N (No)), the process proceeds to step S24. In step S27, the execution unit 104 executes the method and property corresponding to the information processing. When there is an unprocessed object in the iterative processing range (step S28, Y (Yes)), the process proceeds to step S25. If there is no unprocessed object in the iterative processing range (step S28, N (No)), the process proceeds to step S29. In step S29, the process related to the individual execution ends.
- each of one or more steps included in the macro corresponds to at least a macro identifier, a sheet identifier, an object, a method, a property, and a condition.
- the macro includes information related to the execution order of the one or more steps.
- the macro identifier takes the form of the program P0 name, for example.
- the sheet identifier takes the form of a sheet name, for example.
- the condition corresponds to the condition value in FIG. Step is synonymous with information processing.
- the mounting screen W1 has an object designation unit W1A, a condition designation unit W1B, and a processing designation unit W1C.
- the object designating section W1A is used for designating an object corresponding to a macro or a step.
- the condition designating section W1B is used for designating a condition corresponding to a macro or a step.
- the process designation unit W1C is used for designating information processing corresponding to a macro or a step.
- the process designation unit W1C has a tab format.
- the output unit 102 performs the display process of the screen mode corresponding to the tab with the tab designation in the process designation unit W1C as a turning point.
- the tab includes any of a format tab, a copy cut tab, an input tab, and a data tab.
- the process designation unit W1C is used for designating methods and properties in information processing.
- the input unit 101 can designate a cell range or an expanded cell range including the cell range as an object in a macro or step.
- the expanded cell range includes a cell group that is discontinuous with the cell range in the row direction and/or the column direction.
- the input unit 101 can designate a part of the cell range in the expanded cell range as the object.
- the input unit 101 can specify the cell range of the last row or the last column in the expanded cell range as the object.
- the input unit 101 can designate one or more cells having a specific value in the expanded cell range as the object.
- the object designating unit W1A has a macro editing end intention input unit for inputting a macro editing end intention by the input means 101.
- the input means 101 can designate the font, the numerical value, and the text layout.
- the setting relating to the font includes at least one setting of bold, fill, ruled line, color designation, and size.
- the setting relating to the numerical value includes at least one setting of switching of percentage display, switching of comma display, and switching of display after the decimal point.
- the setting related to the text arrangement includes at least one setting of alignment, wrapping, and cell merging.
- the output means 102 switches the screen mode of the condition specifying section W1B.
- the input unit 101 can specify information that constitutes a condition corresponding to a macro or a step.
- the condition includes, as an example, a result of a logical operation based on a target cell corresponding to the condition and a cell adjacent to the cell.
- the logical operation may be based on a value of a cell that is not adjacent to the cell.
- the mounting means 103 can preferably specify the migration destination step based on the true/false value of the condition.
- the input unit 101 can specify the cell operation based on the value of the cell corresponding to the macro or step.
- the cell operation is preferably copy and paste of the value.
- the designation relating to the cell other than the target cell to be pasted is realized by the input unit 101 in the process designation unit W1C.
- the input unit 101 can specify the value input to the cell that is the target of the macro or step.
- the value is a numerical value or a character string.
- the processing specifying unit W1C includes an input form for inputting the value, an input value confirmation intention input unit for confirming the value displayed and processed in the input form, and a value displayed and processed in the input form. At least one of an input value cancellation intention input unit for deleting the input value and an input value reference intention input unit for inputting a value included in a cell adjacent to the object cell as the value.
- the input unit 101 is at least one of the sorting process, the filtering process, the graph drawing process, and the pivot table setting process based on the target cell range.
- the sorting process refers to sorting in the cell range.
- the filtering process refers to switching display/non-display of cells based on an arbitrary logical expression.
- the arbitrary logical expression may be a condition in the condition designating unit W1B, or may separately receive input processing relating to different conditions.
- the process designation unit W1C includes a filtering cancellation intention input unit for canceling the filtering process and a filtering result deletion intention input unit for suppressing the display process related to the filtering result or deleting the cell indicating the filtering result.
- the pivot table process includes determining a pivot table based on the cell range.
- the processing designation unit W1C in which another tab is designated is a sheet information change intention input unit for displaying a sheet information change intention input unit or a matrix display/non-display in a spreadsheet for adding a sheet and changing a sheet identifier. It has a matrix information change intention input section for changing the matrix information including switching of the display and size change of the matrix.
- the sequential execution screen W2 has a sequential execution intention input unit for inputting intention of sequential execution.
- the sequential execution screen W2 has a screen dimension change intention input unit for changing the screen dimensions of the sequential execution screen W2, the individual execution screen W3, and the mounting screen W1.
- the sequential execution screen W2 has an individual execution screen W3 display intention input unit for shifting to the individual execution screen W3.
- the sequential execution screen W2 has a macro detailed display intention input unit for displaying each step included in the macro as shown in FIG. 4 on the spreadsheet. When the macro detailed display intention input unit is designated, the output unit 102 displays the information related to each information processing included in the macro as shown in FIG. 4 on the spreadsheet screen.
- the sequential execution screen W2 has a mounting screen W1 display intention input unit for shifting to the mounting screen W1.
- the execution unit 104 sequentially performs one or more steps included in the macro corresponding to the program P0 identifier. Do the execution.
- the input means 101 determines which of one or more steps included in the macro corresponding to the program P0 identifier. Can be specified.
- the individual execution screen W3 has a step specification unit for specifying any of the steps included in the macro corresponding to the program P0 identifier specified in the sequential execution screen W2.
- the individual execution screen W3 has an individual execution intention input unit for inputting an intention of individual execution.
- the execution unit 104 executes the information processing corresponding to the step. At this time, individual execution may be performed with two or more steps included in the macro specified.
- the display process of the mounting screen W1, the sequential execution screen W2, and the individual execution screen W3 by the output unit 102 and the designation by the input unit 101 may be performed based on the perceptual user interface. Specifically, based on the computer device 1 including the image sensor, the user operation by the hand gesture is associated with the designation. Further, the output unit 102 may perform display processing in a three-dimensional space based on a head mounted display that mutually communicates with the computer apparatus 1 or a pseudo hologram that is drawn by the computer apparatus 1.
- the functions related to the system in this embodiment include processing by sending/receiving mail/message.
- the transmission/reception is realized by the application programming interface.
- the processing includes notification processing of information related to the result of sequential execution or individual execution.
- the process includes an input process for setting one or more information processes by the mounting unit 103. Not limited to these, at least a part of the functions related to the system is realized by transmitting/receiving the mail/message.
- the function also includes input/output to/from the web browser screen by the application programming interface.
- the system according to the second embodiment includes two different computer devices 1.
- the node 1A which is one of the two different computer apparatuses 1, has an input unit 101.
- the server 1B which is one of the two different computer apparatuses 1, includes an output unit 102, a mounting unit 103, and an executing unit 104.
- the server 1B transmits to the server 1B a macro including one or more information processings registered by the mounting means 103 and an execution order related to the one or more information processings.
- the input unit 101 performs an input process based on the input device 14 and the network NW including the API and the like.
- the display process by the output unit 102 is realized while the node 1A and the server 1B cooperate with each other.
- the functions of the system according to the second embodiment are implemented in the form of cloud computing. There is no limit to the number of nodes 1A and servers 1B in the system.
- the server 1B does not have to include the input device 14 and the output device 15.
- the system according to the third embodiment includes two different computer devices 1.
- the node 1A which is one of the two different computer apparatuses 1, has an input unit 101, an output unit 102, and an execution unit 104.
- the server 1B which is one of the two different computer apparatuses 1, includes a mounting unit 103. At this time, the server 1B transmits to the node 1A a macro including one or more information processings registered by the mounting means 103 and an execution order related to the one or more information processings. Further, at this time, the server 1B may be configured to communicate one or more information processings registered by the mounting unit 103 and a macro including the execution order of the one or more information processings on the node 1A.
- the macro including the one or more information processings registered by the mounting means 103 and the execution order related to the one or more information processings is displayed on the node 1A through a user operation such as manual pasting. It may be configured to communicate.
- the node 1A transmits the execution result of the one or more information processing by the execution unit 104 to the node 1A.
- the input unit 101 performs input processing based on the input device 14 and the network NW including an API and the like.
- the display process by the output unit 102 is realized while the node 1A and the server 1B cooperate with each other.
- Some of the operations/actions/functions in the third embodiment are realized in the form of cloud computing. There is no limit to the number of nodes 1A and servers 1B.
- the system according to the fourth embodiment includes two different computer devices 1.
- a node 1A which is one of the two different computer apparatuses 1, has an input unit 101, an output unit 102, and a mounting unit 103.
- the server 1B which is one of the two different computer apparatuses 1, includes an execution unit 104.
- the node 1A transmits to the server 1B a macro including one or more information processes registered by the mounting unit 103 and an execution order related to the one or more information processes.
- the server 1B transmits the execution result of the one or more information processing by the execution unit 104 to the node 1A.
- the input unit 101 performs input processing based on the input device 14 and the network NW including an API and the like.
- the display process by the output unit 102 is realized while the node 1A and the server 1B cooperate with each other.
- Some of the operations/actions/functions in the fourth embodiment are realized in the form of cloud computing. There is no limit to the number of nodes 1A and servers 1B.
- the system according to the fifth embodiment includes two different computer devices 1.
- a node 1A which is one of the two different computer apparatuses 1, has an input unit 101 and an output unit 102.
- the server 1B which is one of the two different computer apparatuses 1, includes a mounting unit 103 and an executing unit 104.
- the server 1B transmits to the server 1B a macro including one or more information processings registered by the mounting means 103 and an execution order related to the one or more information processings.
- the server 1B transmits the execution result of the one or more information processing by the execution unit 104 to the node 1A.
- the input unit 101 performs input processing based on the input device 14 and the network NW including an API and the like.
- the display process by the output unit 102 is realized while the node 1A and the server 1B cooperate with each other.
- Some of the operations/actions/functions in the fifth embodiment are realized in the form of cloud computing. There is no limit to the number of nodes 1A and servers 1B.
- the system according to the sixth embodiment includes two different computer devices 1.
- the node 1A which is one of the two different computer apparatuses 1, includes an input unit 101, a mounting unit 103, and an executing unit 104.
- the server 1B which is one of the two different computer apparatuses 1, includes an output unit 102.
- the node 1A transmits to the node 1A a macro including one or more information processes registered by the mounting means 103 and an execution order related to the one or more information processes.
- the node 1A transmits the execution result of the one or more information processing by the execution unit 104 to the server 1B.
- the input unit 101 performs input processing based on the input device 14 and the network NW including an API and the like.
- the display process by the output unit 102 is realized while the node 1A and the server 1B cooperate with each other.
- Some of the operations/actions/functions in the sixth embodiment are realized in the form of cloud computing. There is no limit to the number of nodes 1A and servers 1B.
- Embodiment 7 of the system according to the present invention will be described below.
- the same components as those in Embodiments 1 to 6 are designated by the same reference numerals, and the description thereof will be omitted.
- the system according to the seventh embodiment includes two different computer devices 1.
- a node 1A which is one of the two different computer apparatuses 1, has an input unit 101 and an execution unit 104.
- the server 1B which is one of the two different computer apparatuses 1, includes an output unit 102 and a mounting unit 103.
- the server 1B transmits to the node 1A a macro including one or more information processings registered by the mounting means 103 and an execution order related to the one or more information processings.
- the node 1A transmits the execution result of the one or more information processing by the execution unit 104 to the server 1B.
- the input unit 101 performs input processing based on the input device 14 and the network NW including an API and the like.
- the display process by the output unit 102 is realized while the node 1A and the server 1B cooperate with each other.
- Some of the operations/actions/functions in the seventh embodiment are realized in the form of cloud computing. There is no limit to the number of nodes 1A and servers 1B.
- Embodiment 8 of the system according to the present invention will be described below.
- the same components as those in Embodiments 1 to 7 will be assigned the same reference numerals and explanations thereof will be omitted.
- the system according to the eighth embodiment includes two different computer devices 1.
- the node 1A which is one of the two different computer apparatuses 1, has an input unit 101 and a mounting unit 103.
- the server 1B which is one of the two different computer devices 1, includes an output unit 102 and an execution unit 104.
- the node 1A transmits to the server 1B a macro including one or more information processes registered by the mounting unit 103 and an execution order related to the one or more information processes.
- the server 1B transmits the execution result of the one or more information processing by the execution unit 104 to the server 1B.
- the input unit 101 performs input processing based on the input device 14 and the network NW including an API and the like.
- the display process by the output unit 102 is realized while the node 1A and the server 1B cooperate with each other.
- Some of the operations/actions/functions in the eighth embodiment are realized in the form of cloud computing. There is no limit to the number of nodes 1A and servers 1B.
- the output device 15 in one embodiment may be a conventional printer (printing device) or a data server which is an aspect of a server device.
- the above-mentioned “branch processing condition” in one embodiment may be configured to present a plurality of conditions. Further, the above-mentioned “repeated processing range” may be configured to have a plurality of ranges. That is, the “branch processing condition” and the “iteration processing range” may be configured to have not only a one-to-one correspondence but also an n-to-n (n is a natural number) correspondence.
- the macro associated with the spreadsheet in the description in this specification refers to a macro as an external file or another file that is used from a known or common spreadsheet such as an add-in personal macro. Further, the macro according to the embodiment of the present invention can be understood as a macro associated with a spreadsheet, corresponding to, associated with, or unique as an external file or a separate file.
- the two different computer devices 1 are referred to as “node 1A” and “server 1B”, respectively, as an example. There are no restrictions on the types of clients, servers, etc., and various configurations are possible.
- the two different computer devices may be nodes (terminals) or servers.
- P0 program 1 computer device 11 arithmetic device 12 main storage device 13 auxiliary storage device 14 input device 15 output device 16 communication device 101 input means 102 output means 103 mounting means 104 execution means W1 mounting screen W1A object designation portion W1B condition designation portion W1C processing Designated part W2 Sequential execution screen W3 Individual execution screen 1A Node 1B Server NW network
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- User Interface Of Digital Computer (AREA)
- Stored Programmes (AREA)
Abstract
Description
以下、図面を用いて、本発明に係るシステムの実施形態1について説明する。本実施形態では、システムの構成、動作などについて説明するが、同様の構成の方法、サーバ1B、プログラムP0、記録媒体なども、同様の作用効果を奏する。また、プログラムP0は、記録媒体に記憶させてよい。当該記録媒体を用いれば、一例として、コンピュータ装置1に当該プログラムP0をインストールすることができる。ここで、当該プログラムP0を記憶した記録媒体は、一例として、CD-ROMやフラッシュメモリなどの非一過性の記録媒体である。また、電気回線を通じて当該プログラムP0が頒布される場合においても、当該プログラムP0の提供元/格納先として、記録媒体が必須となることは、自明である。また、当該プログラムP0は、ソースコードまたはバイナリを含み、適宜、暗号化される。
以下、本発明に係るシステムの実施形態2について説明する。なお、実施形態1と同様の構成については、同様の符号を付してその説明を省略する。
以下、本発明に係るシステムの実施形態3について説明する。なお、実施形態1及び2のそれぞれと同様の構成については、同様の符号を付してその説明を省略する。
以下、本発明に係るシステムの実施形態4について説明する。なお、実施形態1~3のそれぞれと同様の構成については、同様の符号を付してその説明を省略する。
以下、本発明に係るシステムの実施形態5について説明する。なお、実施形態1~4のそれぞれと同様の構成については、同様の符号を付してその説明を省略する。
以下、本発明に係るシステムの実施形態6について説明する。なお、実施形態1~5のそれぞれと同様の構成については、同様の符号を付してその説明を省略する。
以下、本発明に係るシステムの実施形態7について説明する。なお、実施形態1~6のそれぞれと同様の構成については、同様の符号を付してその説明を省略する。
以下、本発明に係るシステムの実施形態8について説明する。なお、実施形態1~7のそれぞれと同様の構成については、同様の符号を付してその説明を省略する。
1 コンピュータ装置
11 演算装置
12 主記憶装置
13 補助記憶装置
14 入力装置
15 出力装置
16 通信装置
101 入力手段
102 出力手段
103 実装手段
104 実行手段
W1 実装画面
W1A オブジェクト指定部
W1B 条件指定部
W1C 処理指定部
W2 順次実行画面
W3 個別実行画面
1A ノード
1B サーバ
NW ネットワーク
Claims (12)
- オートメーション方法であって、
1以上の情報処理、および、前記1以上の情報処理に係る実行順を含むマクロを登録する、実装ステップを、
コンピュータのプロセッサに実行させる、
オートメーション方法。 - オートメーション方法であって、
前記マクロの指定を転機として、前記実行順に基づき、前記1以上の情報処理の順次実行を行い、前記1以上の情報処理の少なくとも1つの指定を転機として、当該1以上の情報処理の少なくとも1つに係る個別実行を行う、実行ステップを、
コンピュータのプロセッサにさらに実行させる、
請求項1に記載のオートメーション方法。 - 前記実装ステップは、グラフィカルユーザインターフェースに基づく、
請求項1または2に記載のオートメーション方法。 - 前記実装ステップは、前記1以上の情報処理と、分岐処理および/または反復処理と、の対応付けを、行う、
請求項1~3の何れかに記載のオートメーション方法。 - 前記情報処理は、表計算処理である、
請求項1~4の何れかに記載のオートメーション方法。 - 前記マクロは、スプレッドシートに付随する
請求項1~5の何れかに記載のオートメーション方法。 - 前記実装ステップは、前記マクロを、揮発性を有するキャッシュ領域としての主記憶装置上に格納する
請求項1~6の何れかに記載のオートメーション方法。 - 前記実装ステップは、前記マクロを、不揮発性を有するデータ領域としての補助記憶装置上に格納する
請求項1~7の何れかに記載のオートメーション方法。 - 前記実行ステップは、前記マクロを、揮発性を有するキャッシュ領域としての主記憶装置上に格納する
請求項2に記載のオートメーション方法。 - 前記実行ステップは、前記マクロを、不揮発性を有するデータ領域としての補助記憶装置上に格納する
請求項2に記載のオートメーション方法。 - オートメーションシステムであって、
1以上の情報処理、および、前記1以上の情報処理に係る実行順を含むマクロを登録する、実装手段を、有する、
オートメーションシステム。 - オートメーションプログラムであって、
コンピュータを、
1以上の情報処理、および、前記1以上の情報処理に係る実行順を含むマクロを登録する、実装手段として機能させる、
オートメーションプログラム。
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US17/431,706 US20220137965A1 (en) | 2019-02-21 | 2020-02-14 | Automation method, automation system and automation program |
JP2020524249A JP6853932B2 (ja) | 2019-02-21 | 2020-02-14 | オートメーション方法、オートメーションシステムおよびオートメーションプログラム |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP2019-029642 | 2019-02-21 | ||
JP2019029642 | 2019-02-21 |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2020170973A1 true WO2020170973A1 (ja) | 2020-08-27 |
Family
ID=72144881
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/JP2020/005827 WO2020170973A1 (ja) | 2019-02-21 | 2020-02-14 | オートメーション方法、オートメーションシステムおよびオートメーションプログラム |
Country Status (3)
Country | Link |
---|---|
US (1) | US20220137965A1 (ja) |
JP (1) | JP6853932B2 (ja) |
WO (1) | WO2020170973A1 (ja) |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH09258971A (ja) * | 1996-03-19 | 1997-10-03 | Sharp Corp | アイコンプログラミング装置 |
JPH1115891A (ja) * | 1997-06-26 | 1999-01-22 | Hitachi Ltd | ワークフローシステムとフォームアプリケーションの連携システム |
JP2019192013A (ja) * | 2018-04-26 | 2019-10-31 | 三菱Ufj信託銀行株式会社 | 自動化支援プログラム及び自動化支援装置 |
-
2020
- 2020-02-14 WO PCT/JP2020/005827 patent/WO2020170973A1/ja active Application Filing
- 2020-02-14 JP JP2020524249A patent/JP6853932B2/ja active Active
- 2020-02-14 US US17/431,706 patent/US20220137965A1/en not_active Abandoned
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH09258971A (ja) * | 1996-03-19 | 1997-10-03 | Sharp Corp | アイコンプログラミング装置 |
JPH1115891A (ja) * | 1997-06-26 | 1999-01-22 | Hitachi Ltd | ワークフローシステムとフォームアプリケーションの連携システム |
JP2019192013A (ja) * | 2018-04-26 | 2019-10-31 | 三菱Ufj信託銀行株式会社 | 自動化支援プログラム及び自動化支援装置 |
Also Published As
Publication number | Publication date |
---|---|
US20220137965A1 (en) | 2022-05-05 |
JP6853932B2 (ja) | 2021-04-07 |
JPWO2020170973A1 (ja) | 2021-03-11 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
JP2022525831A (ja) | ページプリレンダリング方法、装置、電子機器、コンピュータプログラム及び記憶媒体 | |
US9141596B2 (en) | System and method for processing markup language templates from partial input data | |
US20180039419A1 (en) | Virtual storage pool | |
CN113722124B (zh) | 一种云手机的内容处理方法、装置、设备及存储介质 | |
WO2020004156A1 (ja) | 表示制御装置、表示制御方法、および表示制御プログラム | |
US10203850B2 (en) | Data editing apparatus, data editing method, and data editing program | |
CN110990345A (zh) | 一种Excel文件在线预览的方法及装置 | |
US20170031889A1 (en) | Creating a communication editable in a browser independent of platform and operating system | |
JP6950408B2 (ja) | 情報処理システム、画像形成装置、および情報処理方法 | |
WO2020170973A1 (ja) | オートメーション方法、オートメーションシステムおよびオートメーションプログラム | |
CN112181346B (zh) | 思维导图的处理方法、装置、服务器、客户端及介质 | |
KR20060029632A (ko) | 정보를 디스플레이하기 위한 방법 및 시스템, 및 장치 | |
US9256481B2 (en) | Dynamic user interface aggregation through smart eventing with non-instantiated content | |
US11126410B2 (en) | Method and apparatus for building pages, apparatus and non-volatile computer storage medium | |
US11487411B2 (en) | Context-driven group pill in a user interface | |
JP2014032676A (ja) | 非システムフォントを有効にする方法、コンピュータ読取り可能な媒体、および装置 | |
CN109344377B (zh) | 数据处理的方法、装置、电子设备及存储介质 | |
JP2022175871A (ja) | コンピュータプログラム、サーバ装置、端末装置及び方法 | |
CN105373524A (zh) | 演示稿的编辑方法和装置 | |
JP6423671B2 (ja) | ウェブページ間複写装置、ウェブページ間の複写方法、およびプログラム | |
JP7106177B1 (ja) | 情報処理システム、情報処理方法及びプログラム | |
KR102560619B1 (ko) | 노코드툴 서비스를 제공하는 전자 장치 및 그 방법 | |
JP7504247B2 (ja) | ノート生成方法及び装置、電子機器、記憶媒体及びコンピュータプログラム | |
KR102605522B1 (ko) | 펑션 보드를 이용한 고객 협동 개발 시스템 및 이에 포함되는 서버 | |
JP7171103B1 (ja) | 情報処理装置、情報処理方法及びプログラム |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
ENP | Entry into the national phase |
Ref document number: 2020524249 Country of ref document: JP Kind code of ref document: A |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 20758682 Country of ref document: EP Kind code of ref document: A1 |
|
NENP | Non-entry into the national phase |
Ref country code: DE |
|
32PN | Ep: public notification in the ep bulletin as address of the adressee cannot be established |
Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 15.12.2021) |
|
122 | Ep: pct application non-entry in european phase |
Ref document number: 20758682 Country of ref document: EP Kind code of ref document: A1 |