JP2012123559A - File management device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a mechanism for collectively updating cell values only for spreadsheet files stored in a folder selected by a user, by incorporating a mechanism for storing definition files in the folder unit.SOLUTION: A cell value which is associated with a cell name contained in a spreadsheet file stored in conjunction with a definition file is updated to another cell value uniquely associated with a cell name contained in a definition file that corresponds to definition file information associated with the folder information that is retrieved.

Description

  The present invention relates to a file management apparatus, a control method, and a program.

In the conventional document management system, the cell value set (input) in the EXCEL file (registered trademark) having a file format such as xls created by Microsoft's EXCEL (registered trademark) has a date, An EXCEL file in which a name, company name, etc. are input is managed by a document management system, but a file in which a common cell value (date, name, company name, etc.) is input across multiple spreadsheet files In the company's business, for example, when the person in charge or customer is changed, the names of common cell values are corrected across multiple spreadsheet files, and all the names of persons in charge and customers are corrected. Work may occur.

  In Patent Document 1, there is a commercial solution for creating an electronic form / WEB form on the conventional server side. If you create a form that is not garbled even if you output a character string that contains mixed output of multilingual characters and the data items to be output to the form are determined, data management is performed on the server side, and the layout of the form is user A technology for a form creation system that can be customized to the user's preference is disclosed.

JP 2010-039590 A

However, in the form creation system described in Patent Document 1, the common item value is reflected in all the files, and it is not possible to cope with the case where it is desired to change the common item value for each divided file.
Furthermore, even if the common item value reflected once is changed manually, there is a problem that it is overwritten by the second processing.

In addition, when common cell values (date, name, company name, etc.) are entered in multiple spreadsheet files, the new cell value (date, name) , Company name, etc.), the modification work is very troublesome.
The above prior art has a problem that the cell values set (input) in the spreadsheet file cannot be updated at once by a simple method.

  The applicant sets the cell name associated with the cell value to be updated in the spreadsheet file in advance, so that the cell values having the same cell name in the spreadsheet file are extracted in batch and updated to the new cell value in batch. Devised a mechanism.

  However, in this method, when the user has the authority to operate file registration (save) only in a specific folder, the user wants to update only the cell value of the spreadsheet file stored in the desired folder. A new problem arises that the cell values of the spreadsheet files stored in the folder cannot be updated in a batch unit.

  Therefore, the present invention incorporates a mechanism for storing definition files in units of folders in addition to the previously devised mechanism, so that only the spreadsheet file stored in the folder selected by the user can have the cell value of the spreadsheet file. The purpose is to provide a mechanism that can be updated all at once.

  The present invention is a file management apparatus that stores and manages a spreadsheet file including cell information in which cell names and cell values are associated with each other, and includes cell information in which cell names and cell values are uniquely associated with each other. Definition file storage means for storing a definition file in the folder together with the spreadsheet file, definition file information assigned to the definition file stored in the definition file storage means so as to be identifiable, and a definition corresponding to the definition file information Folder information storage means for uniquely storing folder information storing files inside folders, folder information selection means for selecting folder information from folder information stored in the folder information storage means, Search the folder information storage means for folder information that matches the selected folder information, and A table in which the cell name is read from the cell information included in the definition file corresponding to the definition file information associated with the searched folder information and stored together with the definition file corresponding to the definition file information associated with the searched folder information. The definition file cell name reading unit that reads the cell name from the cell information included in the calculation file matches the cell name included in the definition file read by the definition file cell name reading unit and the cell name that is the cell information included in the spreadsheet file. A cell associated with a cell name included in a spreadsheet file stored together with the corresponding definition file when it is determined that the definition file cell name determination means and the definition file cell name determination means match. A value corresponding to the definition file information associated with the searched folder information is defined. Characterized in that and a spreadsheet file cell value updating means for updating the unique cell value associated with the cell name including file.

  In addition, an update log file storage unit that stores an update log file including cell information in which cell names and cell values are associated with each other in the folder together with the spreadsheet file, and when the spreadsheet file cell value update unit updates And an update log file that is stored together with the spreadsheet file updated by the spreadsheet file cell value updating means and is written in association with the updated cell name and cell value updated by the spreadsheet file cell value updating means. And a log writing means.

The folder information storage means stores update log file information assigned to the update log file stored in the update log file storage means so that the update log file can be identified, and an update log file corresponding to the update log file information in the folder. The folder information uniquely associated with the selected folder information, the folder information matching the selected folder information is retrieved from the folder information storage means, and the updated log file information associated with the retrieved folder information The cell name is read from the cell information included in the update log file corresponding to the cell name from the cell information included in the spreadsheet file stored together with the update log file corresponding to the update log file information associated with the searched folder information. Update log file cell name reading means for reading the update log file and the update log file Update log file cell name determination means for determining whether the cell name included in the update log file read by the cell name reading means matches the cell name that is the cell information included in the spreadsheet file, and update log file cell name determination means The cell value associated with the cell name included in the corresponding update log file matches the cell value associated with the cell name included in the spreadsheet file stored with the update log file. If the update log file cell value determination means for determining whether to update and the spreadsheet file cell value update means determine that the update log file cell value determination means do not match, the update log file cell value determination means is stored together with the corresponding definition file. The cell value associated with the cell name included in the spreadsheet file is not updated.
The cell value is preset with a cell name associated with the cell value.

  Further, it further comprises definition file information determination means for determining whether or not there is definition file information associated with the folder information selected by the folder information selection means, and the definition file cell name reading means includes the definition file information determination When it is determined that there is no means, the folder information storage means is not searched for folder information that matches the selected folder information.

  According to the present invention, it is possible to provide a mechanism capable of collectively updating cell values of a spreadsheet file only for a spreadsheet file stored in a folder selected by a user.

It is a figure which shows the system configuration | structure of the file management system of this invention. It is a figure which shows the hardware block diagram of the file management apparatus of this invention, and a client terminal. It is a figure which shows the various files currently saved in the folder which the file management apparatus of this invention manages, and a folder. It is a flowchart which shows the automatic input process to each item of a form (spreadsheet file) from the definition file of embodiment of this invention. It is a figure which shows the detailed processing flow of the automatic input process of embodiment of this invention. It is a figure which shows the image of the flow of the form (spreadsheet file) cell information registration at the time of the first time by this invention. It is a figure which shows the image of the flow of the form (spreadsheet file) cell information update after the 2nd time by this invention. It is a figure which shows the automatic input definition file of embodiment of this invention. It is a figure which shows the log file of embodiment of this invention. It is a flowchart which shows the process which registers the automatic input definition file of embodiment of this invention. It is a figure which shows an example of the screen which the file management apparatus of this invention instruct | indicates display on a client terminal. It is a figure which shows an example of the data table which the file management apparatus of this invention memorize | stores.

  Referring to FIG.

FIG. 1 is a system configuration diagram of a file management system in which a client terminal 200 and a file management apparatus 100 are communicably connected via a communication line (LAN) 300.
FIG. 2 will be described.
FIG. 2 is a diagram illustrating a hardware configuration of the file management apparatus 100, the client terminal 200, and the client terminal 201.

  In FIG. 2, 401 is a CPU that comprehensively controls each device and controller connected to the system bus 404. Further, the ROM 402 or the external memory 411 is necessary to realize a BIOS (Basic Input / Output System) or an operating system program (hereinafter referred to as an OS) that is a control program of the CPU 401, or a function executed by each server or each PC. Various programs to be described later are stored.

  Reference numeral 403 denotes a RAM which functions as a main memory, work area, and the like for the CPU 401. The CPU 401 implements various operations by loading a program necessary for execution of processing from the ROM 402 or the external memory 411 into the RAM 403 and executing the loaded program.

  An input controller 405 controls input from a keyboard (KB) 409 or a pointing device such as a mouse (not shown). A video controller 406 controls display on the display unit 410. Note that the display unit 410 is not limited to a CRT, but may be another display such as a liquid crystal display. These are used by the administrator as needed. Further, the display unit may include a touch panel function in which the user specifies a target position in the display screen with a finger, a pen, or the like.

  Reference numeral 407 denotes a memory controller, which is connected via an adapter to a hard disk (HD), flexible disk (FD), or PCMCIA card slot for storing a boot program, various applications, font data, user files, editing files, various data, and the like. Controls access to an external memory 411 such as a compact flash (registered trademark) memory.

  Reference numeral 408 denotes a communication I / F controller that is connected to and communicates with an external device via the network (communication line) 300, and executes communication control processing in the network. For example, communication using TCP / IP is possible.

  Note that the CPU 401 enables display on the CRT by executing, for example, outline font rasterization processing on the display information area in the RAM 403. In addition, the CPU 401 enables a user instruction with a mouse cursor (not shown) on the CRT.

Various programs to be described later for realizing the present invention are recorded in the external memory 411 of the file management apparatus 100, and are executed by the CPU 401 by being loaded into the RAM 403 as necessary. Further, data files, data tables, and the like used when executing the program are also stored in the external memory 411 or the storage means of the file management apparatus 100, and detailed descriptions thereof will be described later.
FIG. 3 will be described.

  FIG. 3 shows the hierarchy of folders stored in the external memory 411 of the file management apparatus 100, definition files stored (saved) in the folders, log files (update log files), and automatic input target files (spreadsheet files). FIG.

  That is, the file management apparatus 100 stores a definition file including cell information in which cell names and cell values are uniquely associated with each other in a folder together with a spreadsheet file (definition file storage unit).

That is, the file management apparatus 100 stores an update log file including cell information in which cell names and cell values are associated with each other along with the spreadsheet file in each folder (update log file storage unit).
That is, the file management apparatus 100 stores and manages a spreadsheet file including cell information in which cell names and cell values are associated with each other in each folder.
Furthermore, the cell name associated with the cell value is set in advance by the user in the cell value of the spreadsheet file.

  The spreadsheet file to be processed in the present invention means an EXCEL file (registered trademark) having a file format with an extension of xls or the like, created by Microsoft Excel CEL (registered trademark) or the like.

The definition file processed in the present invention means an EXCEL file (registered trademark) created by Microsoft Excel CEL (registered trademark) or the like and having a file format with an extension of xls or the like. Further, it may be a text file having a file format such as txt, which is created with a Microsoft memo pad.
The update log file processed in the present invention means a text file having a file format with an extension of txt or the like, which is created with a memo pad of Microsoft Corporation.
FIG. 4 will be described.
FIG. 4 is a process flowchart for performing automatic input processing and automatic update processing on all project information stored in the file management apparatus according to the embodiment of the present invention.
FIG. 4 shows processing executed under the control of the CPU 401 of the file management apparatus 100.

In step 401, the file management apparatus 100 refers to the project information database 1201 in FIG. 12, obtains project IDs in ascending order of ASCII codes of project IDs, and uses them to obtain the obtained project ID and value. A table of project processing results that are all input as unprocessed is created as a project processing information table 1203 in FIG. 12, stored in the work area of the RAM 403, and the process proceeds to step 402.
Note that the value of the project processing result is updated as processed in step 418 with respect to the project processing result of the processed project ID.

  In step 402, the file management apparatus 100 refers to the project processing result in the project processing information table stored in the RAM 403, determines whether there is one that matches the unprocessed state, and if there is one, Go to 403. If no project exists, it is determined that all projects have been processed, and the process proceeds to step 420.

  In step 403, the file management apparatus 100 refers to the project processing result in the project processing information table stored in the RAM 403, extracts project IDs that match unprocessed in ascending order of ASCII code, sets them in an array, and sets them in an array. The first project ID is stored as processing project information 1204 in FIG. 12 in the work area of the RAM 403, and the process proceeds to step 404.

In step 404, the file management apparatus 100 refers to the project ID in the project information database (1201 in FIG. 12) using the project ID of the processing project information stored in the RAM 403 in step 403 as a key, and the folder ID with the matching project ID. A folder processing result table in which “unprocessed” is input as all the values is created as a folder processing information table (1205 in FIG. 12), stored in the work area of the RAM 403, and the process proceeds to step 405.
Note that the value of the folder processing result is updated as processed in step 416 with respect to the folder processing result of the processed folder ID.

  In step 405, the file management apparatus 100 refers to the folder processing result in the folder processing information table (1205 in FIG. 12) stored in the RAM 403 to determine whether there is at least one that matches the unprocessed one. If yes, go to Step 406. If no folder exists, it is determined that all folders have been processed, and the process proceeds to step 418.

In step 406, the file management apparatus 100 refers to the folder processing result in the folder processing information table (1205 in FIG. 12) stored in the RAM 403, extracts the folder IDs that match the unprocessed items in ascending order of the ASCII codes, and stores them in the array. The first folder ID set in the array is stored in the work area of the RAM 403 as processing folder information, and the process proceeds to step 407. Specify any folder information.
That is, the folder information is selected from the folder information (folder ID) stored in the folder information storage means (folder information selection means).

  In step 407, the file management apparatus 100 refers to the folder ID of the project information database (1201 in FIG. 12) using the folder ID of the processing folder information stored in the RAM 403 in step 406 as a key, and matches the folder ID. The definition file ID is acquired, stored in the RAM 403, and the process proceeds to step 408. Determine whether there is a definition file.

That is, it is determined whether or not the definition file information (definition file ID) associated with the folder information (folder ID) selected by the folder information selection unit in step 406 is in the folder information storage unit (definition file information determination unit). ).
If the definition file ID is blank, it is determined that no definition file exists and the process proceeds to step 416.

  In step 408, the file management apparatus 100 acquires from the external memory 411 a definition file that matches the definition file ID stored in the RAM 403 in step 407, opens the file, and displays a list of defined cell names and cell values. The names are acquired in ascending order of ASCII codes, a table is created as automatic input definition file information, stored in the RAM 403, and the process proceeds to step 409.

  That is, the folder information (folder ID) that matches the folder information (folder ID) selected in step 406 is searched from the folder information storage means, and the definition file information (definition file) associated with the searched folder information (folder ID). The cell name is read from the cell information included in the definition file corresponding to (ID) (definition file cell name reading means).

  If the definition file cell name reading unit determines that there is no definition file information determination unit in step 408, the folder information (folder ID) that matches the folder information (folder ID) selected in step 406 is used. The search is not performed from the folder information storage means, and the update process in the following steps cannot proceed.

In step 409, the file management apparatus 100 refers to the folder ID of the project information database (1201 in FIG. 12) using the folder ID of the processing folder information (1206 in FIG. 12) stored in the RAM 403 in step 406 as a key. The log file ID of the line that matches the folder ID is acquired, stored in the RAM 403 as automatic input log file information, and the process proceeds to step 410.
If it cannot be obtained, the automatic input log file information is stored in the RAM 403 as a blank, and the process proceeds to step 410.

In step 410, using the folder ID of the processing folder information (1206 in FIG. 12) stored in the RAM 403 in step 406 as a key, the folder ID and file type of the document information database (1202 in FIG. 12) are referred to, and the folder ID and The document ID of the line that matches and the file type is Excel is acquired in the ascending order of the ASCII code, and the document processing result table in which all the acquired document ID and value are input as unprocessed is used as the document. A processing information table (1207 in FIG. 12) is created and stored in the work area of the RAM 403, and the process proceeds to step 411.
Note that the value of the document processing result is updated to “processed” in step 414 with respect to the processing result of the processed document ID.

  In step 411, the document processing result of the document processing information table (1207 in FIG. 12) stored in the RAM 403 is referred to determine whether there is at least one that matches the unprocessed state. Proceed to 412. If there is no document, all documents have been processed, and the process proceeds to step 416.

  In step 412, referring to the document processing result of the document processing information table (1207 in FIG. 12) stored in the RAM 403, the document IDs matching unprocessed are extracted in ascending order of ASCII codes, set in an array, and set in an array. The first document ID thus stored is stored in the work area of the RAM 403 as processed document information (1208 in FIG. 12), and the process proceeds to step 413.

  In step 413, using the definition file (definition file ID) specified in step 408, cell values are automatically input for each item (cell) in the spreadsheet file (document ID) specified in step 412; This is an automatic update process. A detailed flowchart of the process for automatically inputting and automatically updating each spreadsheet file will be described with reference to FIG.

In step 414, the document ID of the document processing information table (1207 in FIG. 12) stored in the RAM 403 is referred to using the document ID of the processing document information (1208 in FIG. 12) stored in the RAM 403 in step 412 as a key. The value of the document processing result (1207 in FIG. 12) of the document ID line to be updated is updated from unprocessed to processed, stored in the work area of the RAM 403, and the process proceeds to step 415.
In step 415, the process proceeds to step 411.

  That is, this is a loop in which the processing from step 411 to step 415 is repeated until there is no spreadsheet processing document (document ID) whose document processing result is unprocessed from the document processing information table (1207 in FIG. 12).

In step 416, the folder ID of the folder processing information table (1205 in FIG. 12) stored in the RAM is referred to using the folder ID of the processing folder information (1206 in FIG. 12) stored in the RAM 403 in step 406 as a key. The value of the folder processing result (1205 in FIG. 12) in the row of the folder ID to be updated is updated from unprocessed to processed, stored in the work area of the RAM 403, and the process proceeds to step 417.
In step 417, the process proceeds to step 405.

  That is, this is a loop in which the processing from step 405 to step 417 is repeated until there is no folder information (folder ID) whose folder processing result is unprocessed from the folder processing information table (1205 in FIG. 12).

In step 418, the project ID of the project processing information table (1203 in FIG. 12) stored in the RAM is referenced and matched using the project ID of the processing project information (1204 in FIG. 12) stored in the RAM 403 in step 403 as a key. The value of the project processing result (1203 in FIG. 12) in the row of the project ID to be updated is updated from unprocessed to processed, stored in the work area of the RAM 403, and the process proceeds to step 419.
In step 419, the process proceeds to step 402.

That is, this is a loop in which the processing from step 402 to step 419 is repeated until there is no project information (project ID) whose project processing result is unprocessed from the project processing information table (1203 in FIG. 12).
In step 420, the automatic update processing is completed (completed) for all project information stored in the file management apparatus.
FIG. 5 will be described.

  FIG. 5 is a processing flowchart for performing an automatic input process and an automatic update process for each item (cell) for each form (spreadsheet file) using a definition file according to the embodiment of the present invention.

  In step 501, the file management apparatus 100 acquires a spreadsheet file that matches the document ID of the processed document information (1208 in FIG. 12) stored in the RAM 403 in step 412 in FIG. 4 from the external memory 411, opens the file, The cell name / cell value combination value is acquired in ascending order of the cell name ASCII, a table is created as the contents list information of the automatic input target file, stored in the work area of the RAM 403, and the process proceeds to step 502.

  That is, the folder information (folder ID) that matches the folder information (folder ID) selected in step 406 is searched from the folder information storage means, and the definition file information (definition file) associated with the searched folder information (folder ID). The cell name is read from the cell information included in the spreadsheet file stored together with the definition file corresponding to (ID) (definition file cell name reading means).

  That is, the folder information (folder ID) that matches the folder information selected in step 406 is searched from the folder information storage means, and the updated log file information (log file ID) associated with the searched folder information (folder ID). The cell name is read from the cell information included in the spreadsheet file stored together with the relevant update log file (update log file cell name reading means).

  In step 502, the file management apparatus 100 acquires a file that matches the log file ID of the automatic input log file information stored in the RAM 403 in step 409 of FIG. 4 from the external memory 411, opens the file, updates the file ID, cell A table is created by using the name and update contents of the corresponding cell as log information, stored in the work area of the RAM 403, and the process proceeds to step 503.

  That is, the folder information selected in step 406 (folder information matching the folder ID (folder ID is searched from the folder information storage means, and the searched folder information (update log file information (log file ID) associated with the folder ID) is searched. The cell name is read from the cell information included in the update log file corresponding to (update log file cell name reading means).

In step 503, the file management apparatus 100 has processed up to the last line of the automatic input definition file information stored in the work area of the RAM 403 in step 408 of FIG. 4 (update all cell names described in the definition file). If the processing has not been completed up to the last line, the process proceeds to step 504.
If the process has been completed up to the last line, the process proceeds to step 515.

  In step 504, the file management apparatus 100 stores the current processing target cell name and cell value of the setting item list stored in the work area of the RAM 403 in step 408 as input definition cell information in the work area of the RAM 403. , The process proceeds to step 505.

  In step 505, the file management apparatus 100 sets the combination of the (same) cell name and cell value in the automatic input target file stored in the work area of the RAM 403 in step 501 as processing targets in order from the top. Step 513 is repeated, and if not all the processing has been completed, the process proceeds to step 506. If all have been processed, the process proceeds to step 514.

  In step 506, the file management apparatus 100 sets the cell name and cell value to be processed currently among the cell name and cell value combination values stored in the work area of the RAM 403 in step 501. The input target cell information is stored in the work area of the RAM 403 and the process proceeds to step 507.

  In step 507, the file management apparatus 100 compares whether the cell name of the input definition cell information stored in step 504 matches the automatic input definition file and the input target cell information stored in step 506.

That is, it is determined whether the cell name included in the definition file read by the definition file cell name reading unit in step 408 and step 501 matches the cell name that is the cell information included in the spreadsheet file (definition file cell name determination unit). ).
If they match, the process proceeds to step 508. If not, the process proceeds to step 513.

  In step 508, the file management apparatus 100 determines whether the updated file ID of the log information stored in the work area of the RAM 403 in step 502 includes information that matches the document ID stored in the work area of the RAM 403 in step 412. . If there is matching information, the process proceeds to step 509. If not, go to Step 511.

  In step 509, the file management apparatus 100 matches the log information update file ID stored in the work area of the RAM 403 in step 502 with the document ID stored in the work area of the RAM 403 in step 412. In step 506, it is determined whether or not there is a line in which the cell name of the log information stored in the work area matches the cell name stored in the work area of the RAM 403.

That is, it is determined whether the cell name included in the update log file read by the update log file cell name reading unit in step 501 and step 502 matches the cell name that is the cell information included in the spreadsheet file (update log file cell). Name determination means).
If there is matching information, the process proceeds to step 510. If not, go to Step 514.

  In step 510, the file management apparatus 100 matches the cell value of the automatic input definition file stored in the work area of the RAM 403 in step 504 with the cell value of the automatic input target file stored in the work area of the RAM 403 in step 506. Determine whether.

That is, if it is determined in step 509 that the update log file cell name determination means match, the cell value associated with the cell name included in the update log file corresponding in step 502 and the update log file corresponding in step 502 It is determined whether or not the cell value associated with the cell name included in the spreadsheet file stored together matches (update log file cell value determination means).
If they match, the process proceeds to step 511. If not, the process proceeds to step 514.

  In step 511, the file management apparatus 100 acquires a file that matches the document ID of the processed document information stored in the RAM 403 in step 412 in FIG. 4 from the external memory 411, opens the file, and in step 504 stores the file in the work area of the RAM 403. The cell value stored in the work area of the RAM 403 in step 504 is input to the cell value that matches the stored cell name, and the process proceeds to step 512.

  That is, if it is determined in step 507 that the definition file cell name determination means match, the cell value associated with the cell name included in the spreadsheet file stored together with the corresponding definition file in step 408 is determined in step 408. To update the cell value uniquely associated with the cell name included in the definition file corresponding to the definition file information (definition file ID) associated with the folder information (folder ID) retrieved in (Spreadsheet file cell value update means) ).

  If the update log file cell value determination unit determines that the update log file cell value determination unit does not match in step 510, the spreadsheet file cell value update unit includes the cell included in the spreadsheet file stored together with the corresponding definition file in step 408. Do not update the cell value associated with the name.

  In step 512, the file management apparatus 100 automatically inputs the document ID stored in the work area of the RAM 403 in step 412 and the cell name and cell value stored in the work area of the RAM 403 in step 506 as an input history (update history). A temporary log file is created, stored in the work area of the RAM 403, and the process proceeds to step 514.

In other words, when the spreadsheet file cell value updating means is updated, the update updated by the spreadsheet file cell value updating means is stored in the update log file stored together with the spreadsheet file updated by the spreadsheet file cell value updating means. The cell name and the cell value are written in a uniquely associated manner (update log writing means).
In step 513, the file management apparatus 100 returns to step 505.
In step 514, the file management apparatus 100 returns to step 503.

In step 515, the file management apparatus 100 stores the automatic input log temporary file stored in step 512 in the external memory 411 as an automatic input log file, proceeds to step 516, and ends the flowchart of FIG.
FIG. 6 will be described.
FIG. 6 is a diagram in which the first input is performed on the automatic input target file.

Since the automatic input log file does not exist for the first update, if the cell names match between the automatic input file and the automatic input target file, the file management apparatus 100 updates the automatic input target file and automatically Create an input log file.
601 is a diagram illustrating a flow when cell information in an automatic input definition file is input for the first time.
Reference numeral 611 denotes a cell name of an automatic input target file (spreadsheet file), which is set in advance.

  Reference numeral 612 denotes a cell value of the automatic input target file (spreadsheet file), which is a case where the flow of the initial input is described, and is blank (not input). The cell name 611 is set in advance so as to be uniquely associated with the cell value 612.

Reference numeral 613 denotes a cell value of the automatic input target file (spreadsheet file), which is a case where the flow of the initial input is described, and is blank (not input). The cell name 611 is set in advance so as to be uniquely associated with the cell value 613.
Reference numeral 614 denotes a cell name of an automatic input definition file (definition file), which is set in advance.
Reference numeral 615 denotes a cell value of the automatic input definition file (definition file), which is set in advance.

The cell name 614 is set in advance so as to be uniquely associated with the cell value 615. This automatic input definition file (definition file) cell value is input to the cell value of the automatic input target file (spreadsheet file) according to the process of the present invention.
Reference numeral 616 denotes a cell value of the automatic input definition file (definition file), which is set in advance.

The cell name 614 is set in advance so as to be uniquely associated with the cell value 616. This automatic input definition file (definition file) cell value is input to the cell value of the automatic input target file (spreadsheet file) according to the process of the present invention.

  Reference numeral 617 denotes the cell name of the automatic input log file (update log file), which is blank (not set) before the cell value of the automatic input target file (spreadsheet file) is input in accordance with the processing of the present invention.

Reference numeral 618 denotes a cell value of the automatic input log file (update log file), which is blank (not set) before the cell value of the automatic input target file (spreadsheet file) is input according to the processing of the present invention.
In (1), as in step 507, it is confirmed that the cell name of the automatic input definition file matches the cell name of the automatic input target file.
In step (2), as in step 511, the cell value of the automatic input definition file (definition file) is input to the cell value of the automatic input target file (spreadsheet file).
(3) As in step 512, an automatic input log temporary file (update log file) is created and registered using the input cell name and cell value as the input history.

If it is not the last cell of the automatic input definition file as in step 503 in (4), the process proceeds to the next cell. Here, since four types of cell names are described in the definition file (automatic input definition file), the processes (1) to (4) are executed for all the four types of cell names.
FIG. 7 will be described.
FIG. 7 is a diagram in which the automatic input target file is updated after the second time. There are two cases of the case of 701 in FIG. 7 and the case of 702 in FIG.

  701 is a diagram in which the cell names of the automatic input file and the automatic input target file match, and the cell names and cell values of the automatic input file and the automatic input log file do not match.

From the second time onward, if the cell names of the automatic input file and the automatic input target file match and the cell names and cell values of the automatic input file and the automatic input log file do not match, the file management apparatus 100 automatically Do not update the input target file.
In (1), as in step 507, it is confirmed that the cell name of the automatic input definition file matches the cell name of the automatic input target file.
In (2), as in step 509, it is confirmed that the cell name of the automatic input target file (spreadsheet file) matches the cell name of the automatic input log file.

  In step (3), as in step 510, it is confirmed that the cell value of the automatic input target file (spreadsheet file) does not match the cell value of the automatic input log file, and the cell value of the automatic input target file is not updated. . In other words, this is not the update process of the present invention, but the user manually changes the cell value of the automatic input target file (spreadsheet file).

  (4) If it is not the last cell of the automatic input definition file as in step 503, the process proceeds to the next cell. Here, since four types of cell names are described in the definition file (automatic input definition file), the processes (1) to (4) are executed for all the four types of cell names.

  702 is a diagram in which the cell names of the automatic input file and the automatic input target file match, and the cell names and cell values of the automatic input file and the automatic input log file match.

  Since the automatic input log file exists after the second time, the cell names in the automatic input file and the automatic input target file match, and the cell names and cell values in the automatic input file and the automatic input log file match. Then, the file management apparatus 100 updates the automatic input target file and creates an automatic input log file.

  In (1), as in step 507, it is confirmed that the cell name of the automatic input definition file (definition file) matches the cell name of the automatic input target file (spreadsheet file).

  In (2), as in step 509, it is confirmed that the cell name of the automatic input log file (update log file) matches the cell name of the automatic input target file (spreadsheet file).

In (3), as in step 510, it is confirmed that the cell value of the automatic input log file (update log file) matches the cell value of the automatic input target file (spreadsheet file).
In step (4), as in step 511, the cell value of the automatic input target file (spreadsheet file) is updated to the cell value of the automatic input definition file (definition file).
(5) As in step 512, the updated cell name and cell value are registered in the automatic input log temporary file (update log file) as an update history.

(6) If it is not the last cell of the automatic input definition file as in step 503, the process proceeds to the next cell. Here, since four types of cell names are described in the definition file (automatic input definition file), the processes of (1) to (6) are repeatedly executed for all the four types of cell names.
FIG. 8 will be described.
FIG. 8 is a diagram showing the contents of an automatic input definition file (definition file) according to the embodiment of the present invention.
Reference numeral 811 denotes a cell name of the automatic input definition file (definition file), which is set in advance.
Reference numeral 812 denotes a cell value of the automatic input definition file (definition file), which is set in advance.
The file format of the automatic input definition file (definition file) may thus be a text file format.
Values to be input to the input target file are input based on this automatic input definition file.
An automatic input definition file is registered (stored) for each folder.
In the automatic input definition file, the cell name = cell combination is described as many as the number of rows to be defined.
FIG. 9 will be described.
FIG. 9 is a diagram showing the contents of the automatic input log file (update log file) according to the embodiment of the present invention.
Created to determine whether to input from the automatic input definition file to the input target file.
One automatic input file is created, the inside is divided for each input target file, and the cell name and cell value are described.
Automatic input files are created (stored) for each folder.
FIG. 10 will be described.
FIG. 10 is a flowchart showing a process of transmitting the automatic input definition file of the embodiment of the present invention from the client terminal and registering it in the file management apparatus.

In step 1001, the client terminal 200 displays a user login screen (not shown) that is displayed using the screen information received from the file management apparatus 100, and a login including a user ID (user information) and a password input by the user. Information is transmitted to the file management apparatus 100.
The process proceeds to step 1021.

  In step 1021, the file management apparatus 100 stores the received login information in the work area of the RAM 403, and authenticates the user whether the user ID and password match.

If the user ID and the password do not match, the file management apparatus 100 transmits an error message to the client terminal 200. If the user ID and the password do not match, the client terminal 200 receives the login permission message and displays the error message. Is transmitted to the file management apparatus 100.
When the user ID and the password match, the file management apparatus 100 transmits a login permission message (not shown) to the client terminal 200.
After the transmission, the process proceeds to step 1002.
In step 1002, the client terminal 200 receives a login permission message.
After reception, go to step 1003.

In step 1003, the file management apparatus 100 permitted to log in refers to the project information database, extracts project information to be displayed in the list, instructs the client terminal 200 to display a project list display screen, and transmits the screen information.
The client terminal 200 displays a project list display screen that is displayed using the screen information received from the file management apparatus 100.

In step 1004, a desired project is clicked from the project list and a desired project is selected from the list. The selected project information is transmitted to the file management apparatus 100.
After the transmission, the process proceeds to step 1022.

In step 1022, the file management apparatus 100 receives the selected project information from the client terminal 200. The file management apparatus 100 refers to the project information database from the received project information, extracts folder information to be displayed in the list, instructs the client terminal 200 to display a folder list display screen, and transmits the screen information.
After the transmission, the process proceeds to step 1005.
In step 1005, the client terminal 200 displays a folder list display screen that is displayed using the screen information received from the file management apparatus 100.

In step 1006, a desired folder is clicked from the folder list and a desired folder is selected from the list. The selected folder information is transmitted to the file management apparatus 100.
After transmission, the process proceeds to step 1023.

In step 1023, the file management apparatus 100 receives the selected folder information from the client terminal 200. The file management apparatus 100 refers to the document information database from the received folder information, extracts the document information to be displayed in the list, instructs the client terminal 200 to display the document list display screen, and transmits the screen information.
After the transmission, the process proceeds to step 1007.
In step 1007, the client terminal 200 displays a document list display screen that is displayed using the screen information received from the file management apparatus 100.
Here, reference numeral 1101 in FIG. 11 denotes a button capable of instructing the file management apparatus 100 to proceed with a new automatic definition file creation process.
In step 1008, the client terminal 200 presses an add document button (1101 in FIG. 11).

When the client terminal 200 determines that the document addition button (1101 in FIG. 11) has been pressed, the client terminal 200 transmits a document creation request instruction to the file management apparatus 100.
After the transmission, the process proceeds to step 1024.
In step 1024, the file management apparatus 100 transmits display information of the document addition screen (1002 in FIG. 11) to the client terminal 200.
After the transmission, the process proceeds to step 1009.
In step 1009, a document addition screen displayed using the screen information received from the file management apparatus 100 is displayed.

  In step 1010, the client terminal 200 designates the file and the automatic definition category, and the add button (1103 in FIG. 11) is pressed. The client terminal 200 transmits a definition file (automatic definition file) to be added to the file management apparatus 100.

In step 1025, the file management apparatus 100 registers the automatic definition file received from the client terminal 200 in the project information database, creates document information to be displayed in a list, and instructs the client terminal 200 to display a document list display screen. , Send screen information. At that time, the definition file storage means stores the definition file received in the folder, automatically assigns the definition file information (definition file ID) so that the stored definition file can be identified, and automatically stores it in the project information database. Register the assigned definition file information (definition file information registration means).
The client terminal 200 displays a document list display screen (1104 in FIG. 11) displayed using the screen information received from the file management apparatus 100.
FIG. 11 will be described.
Reference numeral 1101 in FIG. 11 denotes a document addition button.
Reference numeral 1102 in FIG. 11 denotes a document addition screen.
Reference numeral 1103 in FIG. 11 denotes an add button.
Reference numeral 1104 in FIG. 11 denotes a document list display screen.
FIG. 12 will be described.
FIG. 12 is a data table stored in the storage unit (external memory 411 and RAM 403) of the file management apparatus 100.
Reference numeral 1201 denotes a project information database, which is stored in the external memory 411.
Manages projects, folders included in projects, definition files for each folder, and log files.

  In other words, the project information database stores the definition file information (definition file ID) given so that the definition file stored in the definition file storage means can be identified and the definition file corresponding to the definition file information in the folder. Stored folder information (folder ID) is uniquely associated (folder information storage means).

In other words, the project information database includes the update log file information (log file ID) assigned so that the update log file stored in the update log file storage means can be identified, and the update log file corresponding to the update log file information. Folder information (folder ID) stored inside the folder is stored in a uniquely associated manner (folder information storage means).
A document information database 1202 is stored in the external memory 411.
Manage the files contained in each folder of the project.
Reference numeral 1203 denotes a project processing information table.
In performing the update process, it manages the progress information of which project has been updated.
Reference numeral 1204 denotes processing project information.
The process project ID for performing the update process is managed.
Reference numeral 1205 denotes a folder processing information table.
When performing the update process, it manages the progress information of which folder has been updated.
Reference numeral 1206 denotes processing folder information.
The process folder ID for performing the update process is managed.
Reference numeral 1207 denotes a document processing information table.
When performing the update process, it manages progress information indicating to what document the update has been completed.
Reference numeral 1208 denotes processing folder information.
The process document ID to be updated is managed.

The program according to the present invention is a program that allows a computer to execute the processing methods of the flowcharts shown in FIGS. 4, 5, and 10, and the storage medium according to the present invention uses the processing methods of FIGS. The program is stored in the external memory 411 of the file management apparatus 100 as a computer-executable program.

As described above, a recording medium that records a program that implements the functions of the above-described embodiments is supplied to a system or apparatus, and a computer (or CPU or MPU) of the system or apparatus stores the program stored in the recording medium. It goes without saying that the object of the present invention can also be achieved by executing the reading.

In this case, the program itself read from the recording medium realizes the novel function of the present invention, and the recording medium storing the program constitutes the present invention.

As a recording medium for supplying the program, for example, a flexible disk, hard disk, optical disk, magneto-optical disk, CD-ROM, CD-R, DVD-ROM, magnetic tape, nonvolatile memory card, ROM, EEPROM, silicon A disk or the like can be used.

Further, by executing the program read by the computer, not only the functions of the above-described embodiments are realized, but also an OS (operating system) operating on the computer based on an instruction of the program is actually It goes without saying that a case where the function of the above-described embodiment is realized by performing part or all of the processing and the processing is included.

Furthermore, after the program read from the recording medium is written to the memory provided in the function expansion board inserted into the computer or the function expansion unit connected to the computer, the function expansion board is based on the instructions of the program code. It goes without saying that the case where the CPU or the like provided in the function expansion unit performs part or all of the actual processing and the functions of the above-described embodiments are realized by the processing.

Further, the present invention may be applied to a system composed of a plurality of devices or an apparatus composed of a single device. Needless to say, the present invention can be applied to a case where the present invention is achieved by supplying a program to a system or apparatus. In this case, by reading a recording medium storing a program for achieving the present invention into the system or apparatus, the system or apparatus can enjoy the effects of the present invention.

Furthermore, by downloading and reading a program for achieving the present invention from a server, database, etc. on a network by a communication program, the system or apparatus can enjoy the effects of the present invention.
In addition, all the structures which combined each embodiment mentioned above and its modification are also included in this invention.

100 File management apparatus 200 Client terminal 401 CPU
402 ROM
403 RAM (storage unit)
411 External memory (storage unit)

Accordingly, the present invention is User chromatography The only spreadsheet files stored inside the folder to be selected, and an object thereof is to provide a mechanism capable of collectively updating the cell values of the spreadsheet file.

Present invention, the definition file and cell information associated cell names and cell values are defined, a spreadsheet file cell information associated cell names and cell values are set in the file management apparatus for managing Te, a full O Le da select the associated with the selected folder, reads a cell name from the cell information for each folder is defined in specific the definition file stored in the further the selected folder cell name from the cell information is set to spreadsheet file and the reading and Rousset filename reading means, before the cell name for the Ki読 seen took definition file is defined, in the read spreadsheet file and determining to Rousset filename determining means for determining a cell name match that is set, when it is determined that the previous xenon filename determining means matches the cell the cell names match with the cell name determining means in the name The cell value response association was spreadsheet file, characterized in that it comprises a cell value updating means for updating the cell values of the definition file are correlated associated with the selected folder.

Further, the file management apparatus, the update log file for writing cell information that associates the updated cell name and the cell values further management, if the previous xenon Le value updating means has updated the selected folder associated, the unique the update log file per folder, and update log writing means for pre-xenon Le value updating means write the cell value and the cell name corresponding to the cell values of the spreadsheet file updating, the It is further provided with the feature.

Also, if you select the previous SL folder, and updates b favorite phrase filename reading means that reading the cell name from the cell information written in specific the update log file for each of the folders, the update b favorite phrase filename reading a cell name means being written to update the log file read by the and determining updated b favorite phrase filename determining means for determining a cell name set in the read spreadsheet file match, updating b favorite phrase Le If it is determined that the name determining means are identical, the update Roguseru name respectively to the matched cell name associated with determining means, whether the cell value of the cell value and the spreadsheet file update log file further matches and determining updated b favorite phrase le value determining means, further comprising a pre-xenon Le value updating unit, when the update b favorite phrase le value determination means determines that no match, the cell name determination hand Not to renew the cell values of the spreadsheet file associated with the cell name of the cell name matches with characterized.
Further, the cell information of the spreadsheet file is preset by a user .

Further, characterized in that said before cell name reading means reads the cell name, further Ru comprising a definition file-size constant means for determining whether there is a relevant association was defined file before hexene-option folder And

Claims (7)

A file management device that stores and manages a spreadsheet file including cell information in which cell names and cell values are associated with each other,
A definition file storage means for storing a definition file including cell information that uniquely associates a cell name and a cell value together with the spreadsheet file in the folder;
The definition file information assigned so that the definition file stored by the definition file storage means can be identified, and the folder information in which the definition file corresponding to the definition file information is stored in the folder are uniquely associated with each other and stored. Folder information storage means;
Folder information selection means for selecting folder information from the folder information stored in the folder information storage means;
The folder information that matches the selected folder information is searched from the folder information storage means, the cell name is read from the cell information included in the definition file corresponding to the definition file information associated with the searched folder information, and the search is performed. A definition file cell name reading means for reading a cell name from cell information included in a spreadsheet file stored together with a definition file corresponding to the definition file information associated with the defined folder information;
A definition file cell name determination unit that determines whether a cell name included in the definition file read by the definition file cell name reading unit matches a cell name that is cell information included in the spreadsheet file;
When the definition file cell name determination means determines that they match, the cell value associated with the cell name included in the spreadsheet file stored with the corresponding definition file is associated with the searched folder information. A spreadsheet file cell value updating means for updating to a cell value uniquely associated with a cell name included in the definition file corresponding to the definition file information;
A file management apparatus comprising: An update log file storage means for storing an update log file including cell information in which cell names and cell values are associated with each other in the folder together with the spreadsheet file;
When the spreadsheet file cell value update unit is updated, the update file updated by the spreadsheet file cell value update unit is updated in the update log file stored together with the spreadsheet file updated by the spreadsheet file cell value update unit. Update log writing means for uniquely writing a cell name and a cell value in association with each other;
The file management apparatus according to claim 1, further comprising: The folder information storage means stores update log file information assigned to the update log file stored in the update log file storage means so as to be identifiable, and an update log file corresponding to the update log file information in the folder. The folder information is uniquely associated and stored,
Search the folder information storage means for the folder information that matches the selected folder information, and read the cell name from the cell information included in the update log file corresponding to the update log file information associated with the searched folder information, An update log file cell name reading means for reading a cell name from cell information included in a spreadsheet file stored together with an update log file corresponding to the update log file information associated with the searched folder information;
An update log file cell name determination unit that determines whether a cell name included in an update log file read by the update log file cell name reading unit matches a cell name that is cell information included in a spreadsheet file;
When the update log file cell name determination means determines that they match, it corresponds to the cell value associated with the cell name included in the corresponding update log file and the cell name included in the spreadsheet file stored with the update log file Update log file cell value determination means for determining whether or not the assigned cell value matches,
If the spreadsheet file cell value update means determines that the update log file cell value determination means does not match, the cell associated with the cell name included in the spreadsheet file stored with the corresponding definition file The file management apparatus according to claim 2, wherein the value is not updated.   4. The file management apparatus according to claim 1, wherein a cell name associated with the cell value is set in advance in the cell value. 5. A definition file information determination unit for determining whether there is definition file information associated with the folder information selected by the folder information selection unit;
The folder information storage unit does not search for folder information that matches the selected folder information when the definition file cell name reading unit determines that there is no definition file information determination unit. The file management apparatus according to any one of claims 1 to 4. A spreadsheet file including cell information in which cell names and cell values are associated is stored and managed in the folder, and a definition file including cell information in which cell names and cell values are uniquely associated is stored in the folder together with the spreadsheet file. Definition file storage means stored inside, definition file information assigned to the definition file stored in the definition file storage means so as to be identifiable, and a folder storing definition files corresponding to the definition file information inside the folder A folder information storage means for storing information in a uniquely associated manner, and a control method of a file management device comprising:
A folder information selection unit for selecting folder information from the folder information stored in the folder information storage unit;
The definition file cell name reading means of the file management device searches the folder information storage means for folder information that matches the selected folder information, and the definition corresponding to the definition file information associated with the searched folder information A definition file that reads a cell name from cell information included in the file and reads a cell name from cell information included in a spreadsheet file that is stored together with the definition file corresponding to the definition file information associated with the searched folder information. Process,
Definition that the definition file cell name determination means of the file management device determines whether the cell name included in the definition file read by the definition file cell name reading step matches the cell name that is the cell information included in the spreadsheet file. A file cell name determination step;
When the spreadsheet file cell value updating unit of the file management apparatus determines that the definition file cell name determination step matches, the spreadsheet file cell value is associated with the cell name included in the spreadsheet file stored with the corresponding definition file. A spreadsheet file cell value update step for updating a cell value to a cell value uniquely associated with a cell name included in a definition file corresponding to the definition file information associated with the searched folder information;
The control method characterized by including. There is a program that can be read and executed by a file management device that stores and manages spreadsheet files including cell information in which cell names and cell values are associated with each other,
The file management device;
A definition file storage means for storing a definition file including cell information that uniquely associates a cell name and a cell value together with the spreadsheet file in the folder;
The definition file information assigned so that the definition file stored by the definition file storage means can be identified, and the folder information in which the definition file corresponding to the definition file information is stored in the folder are uniquely associated with each other and stored. Folder information storage means;
Folder information selection means for selecting folder information from the folder information stored in the folder information storage means;
The folder information that matches the selected folder information is searched from the folder information storage means, the cell name is read from the cell information included in the definition file corresponding to the definition file information associated with the searched folder information, and the search is performed. A definition file cell name reading means for reading a cell name from cell information included in a spreadsheet file stored together with a definition file corresponding to the definition file information associated with the defined folder information;
A definition file cell name determination unit that determines whether a cell name included in the definition file read by the definition file cell name reading unit matches a cell name that is cell information included in the spreadsheet file;
When the definition file cell name determination means determines that they match, the cell value associated with the cell name included in the spreadsheet file stored with the corresponding definition file is associated with the searched folder information. A spreadsheet file cell value updating means for updating to a cell value uniquely associated with a cell name included in the definition file corresponding to the definition file information;
A program characterized by functioning as

Images