JP3868331B2 - Database registration apparatus and method - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to an apparatus and method for sending and registering data in a CSV file described in CSV format, for example, data in a table created by a spreadsheet program, from a client device to a database.
[0002]
[Background Art and Problems to be Solved by the Invention]
(Conventional contents)
In a company organization, expenses are managed for each department, and the accounting department collects expenses for all departments and makes payments and accounts.
[0003]
In this case, as shown in FIG. 1, a general-purpose spreadsheet program 11 such as “Lotus” (registered trademark), “Excel” (registered trademark) or the like is installed in the client device 10 provided for each department. Expenses are managed by entering data into a table created by a calculation program. FIG. 2A shows an example of a table 100 created by a spreadsheet program. Further, as shown in FIG. 2B, common items 102 are associated with the files in the table 100. That is, the common item 102 is “2002/05/10” for the “payment date” of each amount “100”, “1000”..., “XX” for the payment, “Summary” indicates “June expense”.
[0004]
On the other hand, as shown in FIG. 1, a database 21 is constructed in the server device 20 on the accounting department side, and data necessary for settlement work is stored in the database 21.
[0005]
The client device 10 and the server device 20 are communicably connected by a communication means 30 such as an in-house LAN.
[0006]
Data and common items 102 in the table 100 created by the spreadsheet program 11 are sent from the client device 10 to the server device 20 via the communication means 30 and registered in the database 21.
[0007]
Here, of the data in the table 100, the data to be registered in the database 21 is limited, and the “subtotal” and “total” data in the table 100 are unnecessary, and FIG. It is necessary to register only the data 101 for 12 cells enclosed in the database 21 in the database 21.
[0008]
For this reason, the table 100 cannot be used as it is, and the registration method to the database 21 is generally as follows.
[0009]
1) Separately from the table 100, a dedicated registration screen for database registration is prepared, and data to be registered is input to the single-cut screen or tabular screen one by one, which is sent to the server device 20 and stored in the database 21. sign up.
[0010]
2) The data 101 to be registered in the table 100 is changed to a data format for database registration (such as text format) and sent to the server device 20 and registered in the database 21 in a batch.
[0011]
However, the method 1) has the following problems.
[0012]
a) Every time an expense is incurred, it is necessary for the user to manually input data one by one. In particular, the same items (“JR” in table 100, “production department”..., Common item 102) must be input every time, and the work is not efficient.
[0013]
The method 2) has the following problems.
[0014]
b) It takes time to prepare for changing data to a predetermined format.
[0015]
c) As shown in FIG. 2 (a), the user needs to recreate the data in a format suitable for input to the database 21 while collecting the data in the table 100 in a format suitable for his / her business. Yes, it takes time and effort.
[0016]
d) When there are items that are not input to the database 21 in the table 100 created by the user (in the case of FIG. 2A, “subtotal”, “total”, etc.), or the table is classified for each data item. In such a case, it is necessary to manually convert this into individual data, which is time consuming and prone to errors. Although it is possible to automatically convert the data format using a macro, if the table format is changed by adding a new item to the table 100, the macro needs to be reorganized. This requires specialized knowledge of the program.
[0017]
(Conventional general technical level)
Japanese Patent Application Laid-Open Nos. 7-296084 and 8-36487 describe a technique for converting registered contents of a database into data for spreadsheet using a macro.
[0018]
However, there is no description about registering spreadsheet data in a database.
[0019]
WO97 / 11434 describes a technique for registering single-sheet data in a database using a dedicated program. However, there is no description about registering the result of totaling the data in a single form in a database. In addition, when a dedicated program is required and items are added, it is necessary to newly modify the program, and specialized knowledge about the program is required.
[0020]
Japanese Patent Application Laid-Open No. 10-133930 describes a technique in which when a user newly adds an item to a table, the database is modified according to the added item.
[0021]
However, every time an item is added to the table, it is necessary to modify the database, and an existing database that has already been constructed cannot be used as it is.
[0022]
The present invention has been made in view of such a situation, and enables data to be registered in the database in a batch with good work efficiency with little effort without taking time and effort, and also when adding items, etc. The problem to be solved is to make it possible to use an existing database as it is without modifying the knowledge of a specialized program.
[0023]
[Means for solving the problems and effects]
The first invention is a database registration device for sending and registering data in a table created by a spreadsheet program from a client device to a database of a server device via a transmission means.
The client device is installed with a spreadsheet program and a database registration program that rearranges the table created by the spreadsheet program into data in a format that can be registered in the database and sends it to the server device,
The client device
When an input operation for starting a spreadsheet program is performed, a process for starting a spreadsheet program;
If an input operation to enter a code is performed while the spreadsheet program is running, according to the input operation, Item specification code that specifies the item in the table to be registered in the database in the corresponding cell in the expanded table outside the table frame on the worksheet created by the spreadsheet program, and in the table to be registered in the database A table with an item code indicating the item and a data specification code that specifies the data in the table to be registered in the database Processing,
When an input operation for starting the database registration program is performed, a process for starting the database registration program according to the input operation;
When an input operation for inputting a registration execution command is performed while the database registration program is being activated, a display is performed based on the item designation code, the item code, and the data designation code according to the input operation. The items and data to be registered in the database are extracted from the table created by the calculation program, and the extracted data are rearranged into data in a format that can be registered in the database in association with the items and transmitted to the server device. Processing and
Processing means to execute and
It is characterized by comprising.
[0024]
According to the first invention, as shown in FIG. 4, the data 101 to be registered in the database 21 (“100”, “1000”, etc. indicated by broken lines) is specified in the CSV file 120 and the item ( A code 111 (@data, “SEISAKU”, “R000”, “JZZ”, etc.) indicated by an alternate long and short dash line) indicating “production department”, “travel expense”, “JR”, etc.) is added.
[0025]
Then, based on the code 111, the data 101 to be registered in the database 21 is extracted from the CSV file 120. As shown in FIG. 5A, the extracted data 101 (for example, “100” indicated by the arrow 131). Are associated with items (for example, “SEISAKU”, “R000”, “JZZZ”) and rearranged into data 130 in a format (“100, SEISAKU, R000, JZZZ”) that can be registered in the database 21.
[0026]
As shown in FIG. 1, the rearranged data 130 is transmitted to the database 21 via the communication unit 30.
[0027]
According to the first invention, the data 101 can be automatically registered in the database 21 in a lump by simply performing a simple operation of adding a simple code 111 to the CSV file 120. For this reason, data can be registered in the database 21 in a lump with a little work and with high work efficiency without taking time and effort.
[0028]
Further, even when the table format is changed by deleting items in the table 100 shown in FIG. 3A (for example, the “subtotal” item portion 109 indicated by hatching in FIG. Deletion), program modification and database 21 modification are unnecessary. This eliminates the need for specialized program knowledge and allows the existing database 21 to be used as it is.
[0030]
According to the first invention, as shown in FIG. 3A, the expanded table 110 is set outside the table 100 created by the spreadsheet program, and should be registered in the database 21 in the expanded table 110 cell. A code 111 (“SEISAKU”) that specifies the data 101 (“100”, “1000”, etc., indicated by a double frame) and indicates the items (“production department”, “travel expenses”, “JR”, etc.) of the data 101 , “R000”, “JZZZ”, etc.).
[0031]
Then, based on the code 111, the data 101 to be registered in the database 21 is extracted from the table 100. As shown in FIG. 5A, the extracted data 101 (for example, “100” indicated by the arrow 131). Are associated with items (for example, “SEISAKU”, “R000”, “JZZZ”) and rearranged into data 130 in a format (“100, SEISAKU, R000, JZZZ”) that can be registered in the database 21.
[0032]
As shown in FIG. 1, the rearranged data 130 is transmitted to the database 21 via the communication unit 30.
[0033]
According to the first aspect of the invention, the data 101 is automatically collected all at once by simply performing a simple operation of adding a simple code 111 to the cells of the expanded table 110 outside the frame of the table 100 created by the spreadsheet program. Can be registered in the database 21. For this reason, data can be registered in the database 21 in a batch with good work efficiency and with little effort without taking time and effort.
[0034]
Further, even when the table format is changed by deleting items in the table 100 shown in FIG. 3A (for example, the “subtotal” item portion 109 indicated by hatching in FIG. Deletion), program modification and database modification are not required. This eliminates the need for specialized program knowledge and allows the existing database 21 to be used as it is.
[0035]
In a second aspect based on the first aspect, the processing means of the client device is:
When an input operation is performed to input a common item to data to be registered in the database, the input common item is combined with the data rearranged in a format that can be registered in the database according to the input operation. And execute processing to send to the server device in a format that can be registered in the database
It is characterized by.
[0036]
According to the second invention, as shown in FIG. 6, items 102 (“2002/05/10”, “XX”, “June expense”) common to the data 101 to be registered in the database 21 are input. Then, the input common item 102 is combined with the rearranged data 130 so as to be registered in the database 21 as indicated by 135 in FIG.
[0037]
According to the second invention, the item 102 common to the data 101 does not need to be added as the code 111, that is, does not need to be coded, so that the work efficiency is further improved.
[0038]
The third invention is a database registration method for registering data in a table created by a spreadsheet program from a client device to a database of a server device via a transmission means,
When an input operation for starting the spreadsheet program is performed, a step of starting the spreadsheet program;
If an input operation to enter a code is performed while the spreadsheet program is running, according to the input operation, Item specification code that specifies the item in the table to be registered in the database in the corresponding cell in the expanded table outside the table frame on the worksheet created by the spreadsheet program, and in the table to be registered in the database A table with an item code indicating the item and a data specification code that specifies the data in the table to be registered in the database Process,
When an input operation for starting the database registration program is performed, a step of starting the database registration program according to the input operation;
When an input operation for inputting a registration execution command is performed while the database registration program is being activated, a display is performed based on the item designation code, the item code, and the data designation code according to the input operation. The items and data to be registered in the database are extracted from the table created by the calculation program, and the extracted data are rearranged into data in a format that can be registered in the database in association with the items and transmitted to the server device. Process and
It is characterized by including.
[0039]
According to a fourth aspect, in the third aspect, when an input operation for inputting an item common to data to be registered in the database is performed, the data is rearranged into a format that can be registered in the database according to the input operation. Execute the process that combines the input common items into a format that can be registered in the database and sends it to the server device
It is characterized by.
[0041]
In the third invention and the fourth invention, the invention of the apparatus of the first invention and the second invention is respectively replaced with the invention of the method.
[0042]
DETAILED DESCRIPTION OF THE INVENTION
Embodiments of the present invention will be described below with reference to the drawings.
[0043]
FIG. 1 shows the overall configuration of the database registration system of the embodiment.
[0044]
In a company organization, expenses are managed for each department, and the accounting department collects expenses for all departments and makes payments and accounts. In this embodiment, expenses are individually managed by the department that supervises the production department, sales department, and general affairs department (hereinafter referred to as the supervisory department), and the accounting department totals the expenses of all departments including this supervising department. Assuming that
[0045]
As shown in FIG. 1, the system according to the present embodiment is roughly divided into a client device 10 provided on the above-mentioned supervising department side (the client apparatus 10 is provided similarly for other departments), and an accounting department. Server apparatus 20 provided on the side, and communication means 30 for connecting these client apparatus 10 and server apparatus 20 so as to communicate with each other. The communication means 30 is an in-house LAN, the Internet, or the like, and any communication path such as a public telephone line, a dedicated line, a satellite communication line can be used.
[0046]
The client device 10 is installed with a general-purpose spreadsheet program 11 such as “Lotus” (registered trademark of Lotus) or “Excel” (registered trademark of Microsoft), and created by the spreadsheet program 11. Expenses are managed by entering data in the table.
[0047]
FIG. 2A shows an example of a table 100 created by a spreadsheet program. Further, as shown in FIG. 2B, common items 102 are associated with the files in the table 100. That is, the common item 102 is “2002/05/10” for the “payment date” of each amount “100”, “1000”..., “XX” for the payment, “Summary” indicates “June expense”.
[0048]
It is assumed that the file name in Table 100 is “c: ¥ keiri.Csv”.
[0049]
The data in Table 100 is stored in a file 120 (hereinafter, CSV file) in a CSV (Comma Separated Values) format.
[0050]
In this specification, “100”, “1000”, etc. in FIG. 2 are referred to as data, “Production Department”, “JR”, etc. associated with the data are referred to as items, and item types are referred to as attributes. And Among the items, “Production Department”, “Sales Department”, “General Affairs Department” are attributes of belonging, “Travel Expenses”, “Miscellaneous Expenses” are attributes of accounts, “JR”, “Corporation”, “Toei” “Company A” has an attribute of a trader.
[0051]
The client device 10 decodes a program 150 (hereinafter referred to as a conversion program 150) for rearranging the CSV file 120 into data in a format that can be registered in the database 21 and data 130 rearranged by the conversion program 150, as will be described later. A program 160 (hereinafter referred to as a communication program 160) that is combined with the common item 102 and transmitted to the server device 20 is installed. The conversion program 150 and the communication program 160 are installed in the client device 10 as an integrated database registration program 13.
[0052]
On the other hand, a database 21 is constructed in the server device 20. The database 21 stores expense data of all departments including the supervising department, that is, data necessary for payment and settlement operations as a company organization.
[0053]
When the database registration program 13 is activated, the data in the table 100 and the common item 102 created by the spreadsheet program 11 are sent from the client device 10 to the server device 20 via the communication means 30, and the database 21. Registered in
[0054]
The operation of the embodiment will be described below.
[0055]
(Normal management work in the head office)
First, a case where the user in the general department performs normal management work will be described.
[0056]
In this case, the user performs an input operation for starting the spreadsheet program 11 on the client device 10 to display the worksheet on the display screen.
[0057]
Then, a table 100 shown in FIG. 2A is created on the worksheet, and data is input to each cell in the table 100. For example, if the production department uses JR to generate a travel expense of 100 yen, data “100” is input to the corresponding 2 × 3 cell in the table 100 as indicated by the arrow 103. If the travel department uses JR to generate a travel expense of 1000 yen, the data “1000” is input to the corresponding 2 × 4 cell in the table 100 as indicated by the arrow 104. As a result, as shown by the arrow 105, data “1100” is input to the corresponding 2 × 5 cell in the table 100 as the “subtotal” of the production department and the sales department. Furthermore, if the general affairs department uses JR to generate a travel expense of 10,000 yen, data “10000” is input to the corresponding 2 × 6 cell in the table 100 as indicated by the arrow 106. As a result, as indicated by an arrow 107, data “11100” is input to the corresponding 2 × 7 cell in the table 100 as the “total” of the production department, the sales department, and the general affairs department. In the same manner, monetary amount data is input to each cell.
[0058]
(Operations to be performed by the user when registering the database)
Here, of the data in the table 100, the data to be registered in the database 21 is limited, and the “subtotal” and “total” data in the table 100 are unnecessary, and FIG. It is necessary to register only the data 101 for 12 cells enclosed in the database 21 in the database 21.
[0059]
Therefore, as shown in FIG. 3A, the user sets a table 110 expanded outside the table 100 created by the spreadsheet program 11. In the present embodiment, the table 100 shown in FIG. 2A is premised on being created on the worksheet, so that the portion outside the frame of the table 100 on the worksheet can be used as it is.
[0060]
Next, the user designates data 101 (“100”, “1000”, etc. indicated by double frame lines) to be registered in the database 21 in the cells of the table 110 and items (“production unit”, “ An input operation for adding a code 111 (“SEISAKU”, “R000”, “JZZ”, etc.) indicating “travel expense”, “JR”, etc.) is performed.
[0061]
Here, the contents of the code 111 will be described.
[0062]
@Head; this is a reference code, and @key and @data are inserted in the row and column cells of this @head.
[0063]
@Data; a data designation code, in which data corresponding to the row and column of this @data is designated to be registered in the database 21.
[0064]
@Key: Item designation code, and an item corresponding to the row and column of this @key is designated as one to be registered in the database 21. A flag is set to identify the @key attribute as described below. In this embodiment, it is assumed that @key (row key) of 2 rows and 1 column of the table 110 is assigned to the flag 1 and the attribute thereof is an affiliation code. Further, it is assumed that @key (column first key) in the first row and the second column of the table 110 is assigned to the flag 2, and the attribute is the account code.
[0065]
Further, it is assumed that @key (column second key) in the first row and the third column of the table 110 is assigned to the flag 3, and the attribute thereof is a supplier code.
[0066]
・ Item code: Item code includes affiliation code, account code, and supplier code according to the attribute. The account code consists of “R000” (travel expenses) and “Z000” (miscellaneous expenses), and the supplier codes are “JZZZ” (JR), “EZZZ” (corporation), “TZZZZ” (Toei), “AZZZ” ( Company A).
[0067]
Under such a standard, each cell of the table 110 includes a reference code @head, a data designation code @data (designation of the amount data 101 surrounded by a double frame), an item designation code @key ("affiliation", " (Designation of item “account”, “trader”), item codes “SEISAKU”, “EIGYOOU”, “SOUMU”, “R000”, “Z000”, “JZZZ”, “EZZZ”, “TZZZ”, “AZZZ”, etc. A code 111 is added.
[0068]
The contents of the table 110 shown in FIG. 3A are expanded into the CSV file 120 shown in FIG. 4 and stored in a predetermined storage device. In FIG. 4, a portion indicated by a broken line is a portion corresponding to the data 101 to be registered in the database 21, and a portion indicated by a one-dot chain line is a portion corresponding to the code 111.
[0069]
Next, the user performs an input operation for starting the database registration program 13 to start the database registration program 13. As a result, the display screen of the client device 10 transitions to the database registration screen 140 shown in FIG. The following processing procedure is shown in FIG. This will be described below with reference to FIG.
[0070]
First, as shown in FIG. 6, in a corresponding place on the database registration screen 140, an item 102 common to the data 101 to be registered in the database 21, that is, a payment date “2002/05/10”, a summary “Expense for June” ", The person in charge" XX "is input. Also, the file name “c: ¥ keiri.Csv” of the CSV file 120 shown in FIG. 4 is input.
[0071]
Next, an item to be registered in the database 21 is input as a flag at a corresponding location on the screen 140. That is, as described above, flag 1 is input to the affiliation code, flag 2 is input to the account code, and flag 3 is input to the contractor code. As a result, the affiliation code corresponding to @key (row key) of 2 rows and 1 column in Table 110 is associated with Flag 1, and @key (column 1 of 1 row and 2 columns of Table 110 is associated with Flag 2). The account code corresponding to the key) is associated with the flag 3, and the trader code corresponding to @key (column second key) in the first row and the third column of the table 110 is associated with the flag 3.
[0072]
The order of the flags 1, 2, and 3 indicates the order in which items are extracted from the CSV file 120 in Table 110, and the order in which items are combined with data, as will be described later.
[0073]
The rule is that the first row of the row key is flag 1, the second row of the row key is flag 2, the third row of the row key is flag 3, the nth row of the row key is flag n, and the column The first column of the key is designated as flag n + 1, the second column of the column key is designated as flag n + 2, the third column of the column key is designated as flag n + 3. In this embodiment, the row key is only the first row and the column key is only the first column and the second column, so the first row of the row key (@key of 2 rows and 1 column of Table 110). Is flag 1, the first column of the column key (@key in the first row and the second column of the table 110) is the flag 2, and the second column of the column key (@key in the first row and the third column of the table 110) is the flag. 3 is specified (step 201 in FIG. 8).
[0074]
Next, the user performs an input operation of “registration execution” on the client device 10.
[0075]
(Registration process execution)
When a “registration execution” command is input, the procedure proceeds to processing 210 in FIG. 8 and processing for registering data in the database 21 is started.
[0076]
First, the CSV file 120 corresponding to the file name “c: ¥ keiri.Csv” designated on the database registration screen 140 is read from the storage device (step 202).
[0077]
Next, the conversion program 150 shown in FIG. 7 is executed, and the CSV file 120 is converted into CSV-format data 130 (FIG. 5A) that is decipherable by the communication program 160 and can be registered in the database 21. (Step 203). FIG. 7 shows an example of a program list written in the language “awk”.
[0078]
The processing procedure of the conversion program 150 is shown in FIG.
[0079]
As shown in FIG. 9, first, the cell of the reference code @head (1 row and 1 column of the table 110) is specified (step 301), and the data designation in the same row as the reference code @head (1 row of the table 110) is specified. A column of code @data (6th column, 7th column, and 9th column in Table 110) is specified, and its column number is set to CDATA (i) (i = 1, 2, 3) (step 302).
[0080]
Next, the row of the data specification code @data (4th row, 5th row, 6th row, and 8th row in Table 110) in the same column (1 column in Table 110) as the reference code @head is specified, and the row number is specified as LDATA. (J) (j = 1, 2, 3, 4) (step 303).
[0081]
Next, the column of the item designation code @key (two columns and three columns in Table 110) in the same row as the reference code @head (one row in Table 110) is specified, and the column number is set to CKEY (k) ( k = 1, 2) (step 304).
[0082]
Next, the row of the item specification code @key (2 rows of Table 110) in the same column (1 column of Table 110) as the reference code @head is specified, and the row number is set to LKEY (l) (l = 1). (Step 305).
[0083]
Here, l = 1 corresponds to flag 1, k = 1 corresponds to flag 2, and k = 2 corresponds to flag 3.
[0084]
Next, after initializing i to 1 and j to 1, the data of the cell specified by CDATA (i) and LDATA (j) is output. When i = 1 and j = 1, the data (“100”) of the cell (4 rows and 6 columns of Table 110) specified by CDATA (1) and LDATA (1) is output (step 306).
[0085]
Next, the item of the cell specified by CDATA (i) and LKEY (l) (l = 1), that is, the item of “affiliation” attribute corresponding to flag 1 is output. When i = 1 and j = 1, the item (“SEISAKU”) of the cell (2 rows and 6 columns of Table 110) specified by CDATA (1) and LKEY (1) is output, and this is output at step 306. Data “100”. As a result, “100, SEISAKU” is obtained (step 307).
[0086]
Next, items of cells specified by CKEY (k) (k = 1, 2) and LDATA (j), that is, items of attributes “Account” and “Trade” corresponding to Flag 2 and Flag 3 are output. When i = 1 and j = 1, an item (“R000” in the cell (4 rows, 2 columns, 4 rows and 3 columns) of the table 110 is specified by CKEY (k) (k = 1, 2) and LDATA (1). , “JZZZZ”) are sequentially output, and are sequentially combined with the data “100, SEISAKU” output in step 307. As a result, as indicated by the arrow 131 in FIG. 5A, the data of the amount “100” is added to the item “SEISAKU” of the flag 1 (affiliation), the item “R000” of the flag 2 (account), and the flag 3 ( One record of data “100, SEISAKU, R000, JZZ”, in which the item “JZZZ” of the trader is sequentially combined, is obtained (step 308).
[0087]
Thereafter, i and j are sequentially incremented until all combinations are completed (step 309), and the same processing of steps 306, 307, and 308 is repeated. As a result, as shown in FIG. 5A, the CSV file 120 is rearranged into 12-record data 130 in units of one record in which the amount, affiliation, account, and merchant are sequentially combined.
[0088]
Next, the converted data 130 is decoded by the communication program 160, and
It is combined with the common item 102 so that it can be registered in the database 21 and database registration data 135 is created (step 204 in FIG. 8).
[0089]
Next, the registration data 135 is transmitted to the server device 20 via the communication means 30 in accordance with a predetermined communication protocol and registered in the database 21 (step 205).
[0090]
Here, one item of each record of the database registration data 135 shown in FIG. 5A is data “money”, two items are items of attribute “affiliation” (flag 1, row key), 3 Since the item is an item with the attribute “Account” (flag 2, column 1 key) and the 4 item is an item with attribute “flag” (flag, column 2 key), the database registration data 135 is: As shown in FIG. 5B, it can be taken out in a tabular form.
[0091]
As described above, according to the present embodiment, the data 101 can be obtained simply by adding a simple code 111 to a cell in the expanded table 110 outside the frame of the table 100 created by the spreadsheet program 11. Can be automatically registered in the database 21. Specifically, since a simple code 111 may be added to a cell on a spreadsheet program worksheet, the work can be advanced without requiring skill. In addition, even if there are comments or items that are not necessary for database registration in the table 100 used in normal business, the work can be continued without modification, and data can be recreated for database registration. There is no need to enter data manually. For this reason, it is possible to register data in the database 21 in a batch with good work efficiency with little effort and without much time and effort.
[0092]
In the embodiment, as shown in FIG. 3A, the code 111 is added to the expanded table 110 cell outside the frame of the table 100 created by the spreadsheet program 11. However, the code 111 is not necessarily added to the table cell. There is no need to add the code 111, as long as the code 111 can be added to the CSV file 120 as shown in FIG. 4.
[0093]
(Change of table format)
Next, the case where the table format is changed by deleting, adding, or changing the items in the table 100 will be described.
[0094]
The table format used by the user on a daily basis is changed in table format by deleting items or the like as appropriate for the convenience of the user.
[0095]
For example, the “subtotal” item portion 109 indicated by hatching in FIG. 2 is deleted. In this case, as shown in FIG. 3A, there is no change in the contents of the code 111 to be added when the database 21 is registered, and the previously used code 111 can be used as it is. Further, it is not necessary to modify the database registration program 13 or modify the database 21.
As described above, according to the present embodiment, even if the items in the table 100 are deleted, program modification and database modification are not required, so that the user is not required to know specialized programs, and the database The existing one can be used as it is.
[0096]
Although the case of deleting the items in the table 100 has been described, the same applies to the case of changing or deleting the items in the table 100.
[0097]
(Change of data to be registered in the database)
Next, description will be made assuming that data to be registered in the database 21 has changed.
[0098]
FIG. 3B shows a case where “subtotal” data is added as data to be registered in the database 21. In this case, codes 111a of “@data” and “SHOKEI” are added to the cells in the first row, the eighth column, and the second row, the eighth column of the table 110, respectively, and the code contents are changed.
[0099]
As described above, according to the present embodiment, “subtotal” data can be additionally registered in the database 21 with a little effort of adding a new code 111 a to the previously used code 111. It is not necessary to change the database registration program 13 by making full use of knowledge of such a program.
[0100]
Although the case where data to be registered in the database 21 is added has been described, the same applies to the case where data to be registered in the database 21 is deleted.
[0101]
In the above-described embodiment, it is assumed that transportation expenses and miscellaneous expenses are managed. However, it is only necessary to be able to manage with a CSV format file, such as communication expenses, equipment, address book (address book), work record, etc. The present invention can also be applied to managing
[0102]
10 and 11 show an embodiment in which the data of the employee work schedule table 400 managed for each department is registered in the database 21 as work results.
[0103]
In a workplace where shift work is performed, such as a factory or a hospital, a work schedule shown in 400 of FIG. 10 is created in advance. On the other hand, the data of the work schedule table 400 is stored in the database 21, and the work status of employees and the like is managed.
[0104]
As shown in FIG. 10, when registering data in the database 21, as in the above-described embodiment, the data 401 (2) to be registered in the database 21 around the work schedule table 400 created in each department. A code 111 indicating “delayed”, “departed”, “early”, “absent” data (working status data) indicated by a heavy frame, and indicating the items of the data 401 (“Tabushi”, “1 day”, etc.) An input operation for adding ("01030", "2002/03/01", etc.) is performed. That is, as in FIG. 3A, the reference code @head, the data designation code @data (designation of data called work status), the item designation code @key (designation of items such as employee number and date), and the item code “01030” , “01040”, “01050”, “01060”, “01070”, “01080”, “01090”, “2002/03/01”, “2002/03/02”, “2002/03/03”, “ 2002/03/04 "," 2002/03/05 "," 2002/03/06 "," 2002/03/07 "," 2002/03/08 "," 2002/03/09 "," 2002 / Code 111 such as “03/10”, “2002/03/11”, “2002/03/12”, “2002/03/13”, “2002/03/14”, “2002/03/15” is added. .
[0105]
As a result, the CSV file in FIG. 10 is rearranged into data 430 in units of one record in which work status, employee number, and date are sequentially combined as shown in FIG.
[0106]
FIG. 12A shows a table 500 created when paying out to the traders A, B, and C with two account items, “office machine rental fee” and “office machine maintenance fee”. ing.
[0107]
When registering the data 501 of the amount indicated by the double border in the table 500 in the database 21, first, as shown in FIG. 12B, item codes corresponding to the data 501 are placed around the table 500. Account item codes “9510” and “9520” are added, and vendor codes “71000”, “72001”, and “73007” are added.
[0108]
Further, as shown in FIG. 12C, a reference code @head, a data designation code @data for designating data 501 and an item designation code @key for designating items such as an account and a trader are added around the table 500. .
[0109]
As a result, as shown in FIG. 12D, the CSV file in FIG. 12C is rearranged into data 530 in units of one record in which the amount, account, and trader are sequentially combined.
[0110]
It is assumed that the table 500 shown in FIG. 12A is changed to a table 600 having the format shown in FIG. In the table 600, the rows and columns of the account and the trader in the table 500 are exchanged, the "C company" of the trader is deleted, "Miscellaneous expenses" is added to the account item, and an item "Affiliation" is added. ing.
[0111]
In this case, as a user, the account code “9510”, “9520”, “9600”, supplier code “71000”, “72001”, reference code @head, data 601 are displayed on the worksheet 610 in which the table 600 is created. Data specification code @data to be specified, item specification code @key for specifying items such as trader, affiliation, and account may be added. Changing the code content is easier and less skillful compared to FIG. Can be done. That is, it is sufficient to add, change, and delete code contents for addition, change, and deletion of a table format, and it is possible to easily and flexibly cope with it. There is no need to modify the program or renovate the existing database 21 by making full use of specialized program knowledge.
[Brief description of the drawings]
FIG. 1 is a diagram illustrating an overall configuration of a system according to an embodiment.
FIG. 2 is a diagram showing a table created by a spreadsheet program.
FIGS. 3A and 3B are diagrams illustrating codes added to the periphery of a table.
FIG. 4 is a diagram showing a CSV file.
FIGS. 5A and 5B are diagrams for explaining data after rearranging CSV file data. FIG.
FIG. 6 is a diagram showing a database registration screen.
7 is a diagram showing an example of a program list of the conversion program in FIG. 7;
FIG. 8 is a flowchart illustrating a processing procedure according to the embodiment.
FIG. 9 is a flowchart illustrating a processing procedure for rearranging data in a CSV file.
FIG. 10 is a diagram for explaining codes added to a work schedule.
FIG. 11 is a diagram illustrating data after the CSV files in FIG. 10 are rearranged.
FIGS. 12A, 12B, 12C, and 12D are diagrams for explaining the order in which codes are added and the data after rearranging the CSV files to which the codes have been added. is there.
FIG. 13 is a diagram showing the code contents added on the worksheet when the table format of FIG. 12A is changed in comparison with FIG. 12C.
[Explanation of symbols]
10 Client device
11 Spreadsheet program
13 Database registration program
21 Database
30 Communication means
100 tables
110 Extended table (worksheet)
111 code
120 CSV file
150 conversion program
160 Communication program

Claims (4)

In the database registration device for sending the data in the table created by the spreadsheet program from the client device to the database of the server device via the transmission means, and registering it,
The client device is installed with a spreadsheet program and a database registration program that rearranges the table created by the spreadsheet program into data in a format that can be registered in the database and sends it to the server device,
The client device
When an input operation for starting a spreadsheet program is performed, a process for starting a spreadsheet program;
If an input operation to enter a code is performed while the spreadsheet program is running, the response in the expanded table outside the table frame on the worksheet created by the spreadsheet program will depend on the input operation In the cell to be specified, an item specification code for specifying an item in the table to be registered in the database, an item code indicating an item in the table to be registered in the database, and data for specifying the data in the table to be registered in the database Processing to generate a table with the specified code added ;
When an input operation for starting the database registration program is performed, a process for starting the database registration program according to the input operation;
When an input operation for inputting a registration execution command is performed while the database registration program is being activated, a display is performed based on the item designation code, the item code, and the data designation code according to the input operation. The items and data to be registered in the database are extracted from the table created by the calculation program, and the extracted data are rearranged into data in a format that can be registered in the database in association with the items and transmitted to the server device. A database registration apparatus comprising processing means for executing processing. The processing means of the client device is
When an input operation is performed to input a common item to data to be registered in the database, the input common item is combined with the data rearranged in a format that can be registered in the database according to the input operation. The database registration apparatus according to claim 1, wherein the database registration apparatus executes a process of transmitting to a server apparatus in a format that can be registered in the database. In a database registration method for sending data in a table created by a spreadsheet program from a client device to a database of a server device via a transmission means, and registering it,
When an input operation for starting the spreadsheet program is performed, a step of starting the spreadsheet program;
If an input operation to enter a code is performed while the spreadsheet program is running, the response in the expanded table outside the table frame on the worksheet created by the spreadsheet program will depend on the input operation In the cell to be specified, an item specification code for specifying an item in the table to be registered in the database, an item code indicating an item in the table to be registered in the database, and data for specifying the data in the table to be registered in the database Generating a table with a specified code ;
When an input operation for starting the database registration program is performed, a step of starting the database registration program according to the input operation;
When an input operation for inputting a registration execution command is performed while the database registration program is being activated, a display is performed based on the item designation code, the item code, and the data designation code according to the input operation. The items and data to be registered in the database are extracted from the table created by the calculation program, and the extracted data are rearranged into data in a format that can be registered in the database in association with the items and transmitted to the server device. A database registration method comprising the steps of: When an input operation is performed to input a common item to data to be registered in the database, the input common item is combined with the data rearranged in a format that can be registered in the database according to the input operation. 4. The database registration method according to claim 3, wherein a process for transmitting to the server device is performed in a format that can be registered in the database.

Images