JP2008102858A - Information processor and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To make information written on a document etc. into data and easily manage the information. <P>SOLUTION: An information processor comprises: a definition information creation means for creating definition information related to acquisition of data about a cell of spreadsheet software, based on user operation information acquired through an input device; a table creation means for creating a table related to the data, based on the definition information created by the definition information creation means; a data acquisition means for acquiring data entered into the cell, based on the definition information created by the definition information creation means; and a substitution means for substituting the data acquired by the data acquisition means to the table created by the table creation means. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to an information processing apparatus and a program.

  Conventionally, when data written in submitted paper documents is converted into data, staff members manually enter data. In addition, when a document was submitted as data, the data was stored as it was on a recording medium or a hard disk of a personal computer.

JP 05-298479 A

However, in the method of manually inputting data, there are problems that it takes time for data input and labor costs for data input. Moreover, since it is manual, an input error may occur. In addition, there is a problem that it takes time and labor cost to check whether there is an input error. There is also a problem that the input data cannot be managed easily.
On the other hand, even when a document is submitted with data, for example, since the data in the file format is saved as it is, it is not easy to do when searching for information (data) described in the file It was. That is, there is a problem that data cannot be managed easily.

  The present invention has been made in view of such problems, and an object thereof is to convert information described in documents and the like into data and easily manage the information.

  Therefore, the present invention is created by definition information creating means for creating definition information related to acquisition of data related to a cell of spreadsheet software based on user operation information obtained through the input device, and the definition information creating means. A table creating unit for creating a table related to the data based on the definition information; a data obtaining unit for obtaining data input to the cell based on the definition information created by the definition information creating unit; And substituting means for substituting the data obtained by the data obtaining means into the table created by the table creating means.

  With this configuration, the definition information related to the acquisition of the data related to the cell is created, the data input to the specified cell of the spreadsheet software is acquired based on the definition information, and the definition information is created based on the definition information Since the information is stored in the table, the information described in the document or the like can be converted into data and easily managed.

  Further, the present invention provides a definition information creating means for creating definition information related to code information conversion of data related to a cell of spreadsheet software based on user operation information acquired via an input device, and the definition information creating means Based on the created definition information, table creation means for creating a table relating to the data, data output means for reading code information relating to data input to the cell, and outputting data, and the data output means, And substituting means for substituting the output data into the table created by the table creating means.

  By making such a configuration, creating definition information related to code information conversion of data related to cells, creating a table based on this definition information, and substituting the data related to the read code information into the created table, Information described in documents can be converted into data and managed easily.

  Further, the present invention provides definition information creating means for creating definition information related to a data input screen based on user operation information acquired via an input device and a form data file of a spreadsheet software, and the definition information Based on the definition information created by the creation means, data input based on the table creation means for creating the table relating to the data, the form data file, and the definition information created by the definition information creation means Data input screen form creation means for creating a screen form, data output means for reading code information relating to data input via the data input screen and outputting data, and data output by the data output means And substituting means for substituting into the table created by the table creating means. The features.

  With this configuration, definition information related to the data entry screen is created, a table is created based on this definition information, and the definition information and the data entry screen created based on the form data file of the spreadsheet software are used. Since the data that has been input and converted into code information is read and substituted into the created table, the information described in the document or the like can be converted into data and easily managed.

  The present invention may be a program.

  According to the present invention, information described in a document or the like can be converted into data and easily managed.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings.

<Embodiment 1>
FIG. 1 is a hardware configuration diagram of an example of an information processing apparatus 1 on the administrative side.
As shown in FIG. 1, the information processing apparatus 1 includes, as a hardware configuration, an input device 11, a display device 12, a recording medium drive device 13, a ROM (Read Only Memory) 15, and a RAM (Random Access Memory). ) 16, CPU (Central Processing Unit) 17, interface device 18, and HD (Hard Disk) 19.

  The input device 11 includes a keyboard and a mouse that are operated by an operator (or user) of the information processing apparatus 1, and is used to input various operation information and the like to the information processing apparatus 1. The display device 12 includes a display used by an operator of the information processing device 1 and is used to display various types of information (or screens). The interface device 18 is an interface that connects the information processing device 1 to a network or the like.

  A program relating to functions and the like of the information processing apparatus 1 to be described later is provided to the information processing apparatus 1 by a recording medium 14 such as a CD-ROM, or downloaded through a network or the like. The recording medium 14 is set in the recording medium drive device 13, and the program is installed from the recording medium 14 to the HD 19 via the recording medium drive device 13. Note that the program may be installed in the HD 19 or the like from the beginning.

  The ROM 15 records a program that is read first when the information processing apparatus 1 is powered on. The RAM 16 is a main memory of the information processing apparatus 1. The CPU 17 reads out a program from the HD 19 as necessary, stores it in the RAM 16, and executes the program to provide all or part of the functions described below. In addition to the program, the HD 19 stores, for example, a DB (DataBase) described later.

  The information processing apparatus on the applicant side is different in installed programs, but the hardware configuration is as shown in FIG.

  Hereinafter, an example of a functional configuration of the information processing apparatus 1 including the CPU 17, the RAM 16, the HD 19, a program, and the like is illustrated in FIG. FIG. 2 is a functional configuration diagram of an example of the information processing apparatus 1. As illustrated in FIG. 2, the information processing apparatus 1 includes a definition file creation unit 21, a table creation unit 22, a data acquisition unit 23, and an assignment unit 24 as functional configurations.

The definition file creation unit 21 creates definition information (definition file) related to acquisition of data related to cells of spreadsheet software based on user operation information using the input device 11 or the like. More specifically, first, the definition file creation unit 21 reads form data (form data file) of a document created by spreadsheet software as shown in FIG. FIG. 3 is a diagram illustrating an example of form data.
While viewing the form data as shown in FIG. 3 displayed on the display device 12, the user selects a cell related to data acquisition, and data attribute information (for example, item name, data type, number of digits, etc.) To decide. The definition file creation unit 21 acquires the position information of the selected cell and the determined attribute information, creates a definition file, and stores it in the HD 19 together with information for identifying form data.

  The table creation unit 22 creates a table for substituting data based on the definition file created by the definition file creation unit 21. More specifically, the table creation unit 22 stores data input to the cell based on attribute information (for example, item name, data type, number of digits) described in the definition file. Is created dynamically.

  Here, the administrative side records the form data (application form data) for which the definition file has been created as described above on the recording medium 14 and passes it to the applicant side or stores it in the HD 19 etc. Download from the information processing device on the user side.

  The applicant reads the acquired application form data with spreadsheet software, and writes necessary information (for example, the applicant, a delegation destination, and a contact address) as shown in FIG. FIG. 4 is a diagram illustrating an example in which necessary information is input to the application form data.

  The applicant inputs necessary information as shown in FIG. 4, for example, saves it in a recording medium or the like in a file format, and submits the saved data (application data) to the administration side.

  Returning to the description of FIG. 2 again, when the data acquisition unit 23 receives the application form data in which the information as shown in FIG. 4 is input, it identifies the form data (application form data) related to the application form data. Based on the information, the definition file created by the definition file creation unit 21 is acquired from the HD 19 or the like. And the data acquisition part 23 acquires the data input into the corresponding cell from application form data based on the positional information on the cell described in the acquired definition file. That is, the data acquisition unit 23 acquires information such as the applicant, the delegation destination, and the contact address from the application form data.

  The assigning unit 24 assigns the data acquired by the data acquiring unit 23 to the table created by the table creating unit 22.

  As described above, according to the present embodiment, the administrative side does not need to manually input data related to the document applied for by the applicant. Further, the information processing apparatus 1 automatically creates a table for storing data, and automatically substitutes data relating to the document in this table. Therefore, the administrative side can easily manage the data related to the applied documents.

<Embodiment 2>
FIG. 5 is a hardware configuration diagram of an example of the information processing apparatus 2 on the administrative side.
As illustrated in FIG. 5, the information processing apparatus 2 according to the present embodiment further includes a QR code reader 20 in addition to the hardware configuration of the information processing apparatus 1 illustrated in FIG. 1 according to the first embodiment. .

  As shown in FIG. 7 to be described later, the QR code reader 20 is added to a printed application form in which necessary information (for example, an applicant, a delegation destination, and a contact address) is written. Read the QR code. In the present embodiment, the description is given on the assumption that a QR code is added to the printed application form. However, the QR code may be printed out on paper different from the application form. Then, the QR code reading device 20 may read the QR code printed out on this separate sheet.

  The information processing apparatus on the applicant side in the present embodiment is different in installed programs, but the hardware configuration is as shown in FIG. 1 of the first embodiment. However, it is assumed that the information processing apparatus on the applicant side in this embodiment is connected to a printing apparatus such as a printer via a network or the like.

  Hereinafter, an example of a functional configuration of the information processing apparatus 2 including the CPU 17, the RAM 16, the HD 19, the QR code reading device 20, a program, and the like is illustrated in FIG. FIG. 6 is a functional configuration diagram of an example of the information processing apparatus 2 according to the second embodiment. As illustrated in FIG. 6, the information processing apparatus 2 includes a definition file creation unit 31, a table creation unit 32, a data output unit 33, and an assignment unit 34 as functional configurations.

  The definition file creating unit 31 creates definition information (definition file) related to code information conversion of data related to cells of the spreadsheet software based on user operation information using the input device 11 or the like. More specifically, first, the definition file creation unit 31 reads form data of a document created by spreadsheet software as shown in FIG. 3 of the first embodiment.

  While viewing the form data as shown in FIG. 3 displayed on the display device 12, the user selects a cell related to data acquisition, and data attribute information (for example, item name, data type, number of digits, etc.) To decide. The definition file creation unit 21 acquires the position information of the selected cell and the determined attribute information, creates a definition file, and stores it in the HD 19 together with information for identifying form data.

  The table creation unit 32 creates a table for substituting data based on the definition file created by the definition file creation unit 31. More specifically, the table creation unit 32 stores a data to be input to the cell based on attribute information (for example, item name, data type, number of digits) described in the definition file. Is created dynamically.

  Here, the administrative side records the form data (application form data) for which the definition file has been created as described above and the definition file, for example, as one data (or file) on the recording medium 14 for application. The information is transferred to the applicant side or stored in the HD 19 or the like so that it can be downloaded from the information processing apparatus on the applicant side. Note that the information processing apparatus 2 does not form the form data and the definition file as one data (or file), but the form data and the cell location information related to the code information conversion included in the definition file. One data (or file) may be used.

  In the following description, for the sake of simplification of description, the administration side provides form data and cell location information related to code information as one data to the applicant side. In the present embodiment, hereinafter, the form data and the cell position information related to the code information conversion are referred to as application data.

  The applicant reads the acquired application form data with software, and writes necessary information (for example, the applicant, a delegation destination, and a contact address) as shown in FIG. 4 of the first embodiment.

As shown in FIG. 4 of the first embodiment, the applicant inputs necessary information and prints out the application form on a printing device such as a printer connected to the information processing device on the applicant side via the network. Let At this time, the software of the information processing apparatus on the applicant side prints and outputs the information input to the cell as a QR code according to the position information of the cell related to the code information included in the application form data. Control the printing device.
FIG. 7 is a diagram illustrating an example of an application form printed out by the printing apparatus. The applicant submits an application form as shown in FIG.

  Returning to the description of FIG. 6 again, the data output unit 33 acquires the information of the read QR code, that is, the information input to the designated cell, from the QR code reader 20, and outputs it.

  The assigning unit 34 assigns the data output from the data output unit 33 to the table created by the table creating unit 32.

As described above, according to the present embodiment, the administrative side does not need to manually input data related to the document applied for by the applicant. In addition, the information processing apparatus 2 automatically creates a table for storing data, and acquires data related to a document by reading a QR code, and automatically substitutes the created table. Therefore, the administrative side can easily manage the data related to the applied documents.
Further, in the present embodiment, since the data relating to the document is converted into a QR code and submitted from the applicant side to the administrative side, there is no concern about virus infection associated with the spreadsheet software, for example.
In the present embodiment, the QR code is used as an example of the code information. However, other codes (for example, PDF417, Data Matrix, Maxi Code, etc.) may be used. The same applies to the following embodiments.

<Embodiment 3>
FIG. 8 is a functional configuration diagram of an example of the information processing apparatus 2 on the administrative side according to the third embodiment. The functions of the information processing apparatus 2 are constituted by a CPU 17, a RAM 16, an HD 19, a QR code reading device 20, a program, and the like. Note that the hardware configuration of the information processing apparatus 2 on the administrative side in this embodiment is the same as that in the second embodiment. In addition, the information processing apparatus on the applicant side in the present embodiment is different in installed programs, but the hardware configuration is as shown in FIG. 1 of the first embodiment. The information processing apparatus on the applicant side in this embodiment is also connected to a printing apparatus such as a printer via a network or the like.

  As shown in FIG. 8, the information processing apparatus 2 includes a definition file creation unit 41, a table creation unit 42, a data input screen form creation unit 43, a data output unit 44, and an assignment unit 45 as functional configurations. ,including.

  The definition file creation unit 41 creates definition information (definition file) related to the data input screen based on user operation information using the input device 11 or the like and form data of the spreadsheet software. More specifically, first, the definition file creation unit 41 reads form data of spreadsheet software (in this embodiment, a sheet on which cells are arranged).

  The user uses the input device 11 or the like for the form data displayed on the display device 12, and the items related to the data input screen (for example, in the example of FIG. 9 to be described later, (Category, trader code, trade name or name, reading, representative name, reading, name of delegated person, reading, etc.), and attribute information of each item is defined. Here, the attribute information of each item includes, for example, the data input method (manual input, selection, copy, etc.) for each item, and the type of input data (letter, number, alphanumeric, date ), The number of input characters, the item name, the cell range of the item, the cell position information related to the code information conversion, and the like. In addition, when all the information input to the item is converted into code information, the position information of the cell related to the code information need not be included in the attribute information.

  The definition file creation unit 41 acquires the described items and defined attribute information, creates a definition file, and stores it in the HD 19 together with information for identifying form data in which each item is set.

  The table creation unit 42 creates a table for substituting data based on the definition file created by the definition file creation unit 41. More specifically, the table creation unit 42 stores data input to the cell based on attribute information (for example, item name, data type, number of input characters, etc.) described in the definition file. The table to be created dynamically.

  The data input screen form creation unit 43 creates a data input screen as shown in FIG. 9 to be described later, based on the form data in which each item is set and the definition file created by the definition file creation unit 41. Create the base data entry screen form.

  Here, the administration side records the data input screen form on the recording medium 14 and transfers it to the applicant side or stores it in the HD 19 or the like so that it can be downloaded from the information processing apparatus on the applicant side.

  The applicant reads the acquired data input screen form with software, displays a data input screen as shown in FIG. 9, and inputs (or selects) necessary information using the data input screen. FIG. 9 is a diagram illustrating an example of the data input screen.

The applicant inputs (or selects) necessary information using the data input screen, and prints the application form on a printing apparatus such as a printer connected to the information processing apparatus on the applicant side. At this time, the software of the information processing apparatus on the applicant side prints and outputs the information input to the cell as a QR code according to the position information of the cell related to the code information included in the application form data, Control the printing apparatus.
Then, the applicant submits an application printed out by the printing apparatus to the administrative side.

  Returning to the description of FIG. 8 again, the data output unit 44 acquires and outputs information of the read QR code, that is, information input to the designated cell, from the QR code reader 20.

  The assigning unit 45 assigns the data output from the data output unit 44 to the table created by the table creating unit 42.

As described above, according to the present embodiment, the administrative side does not need to manually input data related to the document applied for by the applicant. In addition, the information processing apparatus 2 automatically creates a table for storing data, and acquires data related to a document by reading a QR code, and automatically substitutes the created table. Therefore, the administrative side can easily manage the data related to the applied documents.
Further, in the present embodiment, since the data relating to the document is converted into a QR code and submitted from the applicant side to the administrative side, there is no concern about virus infection associated with the spreadsheet software, for example.
Further, in the present embodiment, a UI that is easy to understand for the applicant can be provided as shown in FIG. 9 as compared to the UI on the spreadsheet software as shown in FIG. Further, by using a data input screen (and attribute information included in the definition file) as shown in FIG. 9, it is possible to prevent erroneous data from being input.

  For example, the information processing device on the applicant side applies for substitution of a character string when a number or date is entered in an item for which a character string is set based on attribute information included in the definition file. It is possible to prevent a wrong data from being input by displaying a screen for alerting the user.

  In the above-described embodiment, the table creation unit has been described to create a table based on a definition file or the like. However, the table creation unit has a processing request (for example, a query or the like) for substituting data into the table. You may make it create. Then, the assigning unit may substitute the data into the table created by the table creating unit using the processing request created by the table creating unit.

  As described above, according to each of the above-described embodiments, information described in a document or the like (or related to the document or the like) can be converted into data and easily managed.

The preferred embodiments of the present invention have been described in detail above, but the present invention is not limited to such specific embodiments, and various modifications can be made within the scope of the gist of the present invention described in the claims.・ Change is possible.
For example, in the above-described embodiment, the description has been given using the administration side and the applicant side, but the present invention is not limited to this.

It is a hardware block diagram of an example of the information processing apparatus 1 of the administrative side. 2 is a functional configuration diagram of an example of an information processing apparatus 1. FIG. It is a figure which shows an example of form data. It is a figure which shows an example which input the information required for application form data. It is a hardware block diagram of an example of the information processing apparatus 2 of the administrative side. 6 is a functional configuration diagram of an example of an information processing apparatus 2 according to Embodiment 2. FIG. It is a figure which shows an example of the application form printed and output in the printing apparatus. 10 is a functional configuration diagram of an example of an information processing device 2 on the administrative side in Embodiment 3. FIG. It is a figure which shows an example of a data input screen.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Information processing apparatus 2 Information processing apparatus 11 Input apparatus 12 Display apparatus 13 Recording medium drive apparatus 14 Recording medium 15 ROM
16 RAM
17 CPU
18 Interface device 19 HD
20 QR code reader 21 Definition file creation unit 22 Table creation unit 23 Data acquisition unit 24 Assignment unit 31 Definition file creation unit 32 Table creation unit 33 Data output unit 34 Assignment unit 41 Definition file creation unit 42 Table creation unit 43 Data input screen Form creation unit 44 Data output unit 45 Substitution unit

Claims (4)

Definition information creating means for creating definition information related to acquisition of data related to a cell of spreadsheet software, based on user operation information acquired via the input device;
Table creation means for creating a table related to the data based on the definition information created by the definition information creation means;
Based on the definition information created by the definition information creation means, data acquisition means for acquiring data input to the cell;
Substitution means for substituting the data acquired by the data acquisition means into the table created by the table creation means;
An information processing apparatus comprising: Based on user operation information acquired via the input device, definition information creating means for creating definition information related to code information conversion of data related to cells of spreadsheet software,
Table creation means for creating a table related to the data based on the definition information created by the definition information creation means;
Data output means for reading code information relating to data input to the cell and outputting data;
Substitution means for substituting the data output by the data output means into the table created by the table creation means,
An information processing apparatus comprising: Definition information creating means for creating definition information related to the data input screen based on the user operation information acquired via the input device and the form data file of the spreadsheet software;
Table creation means for creating a table related to the data based on the definition information created by the definition information creation means;
A data input screen form creation means for creating a data input screen form based on the form data file and the definition information created by the definition information creation means;
Data output means for reading the code information related to the data input via the data input screen and outputting the data;
Substitution means for substituting the data output by the data output means into the table created by the table creation means,
An information processing apparatus comprising:   The program for functioning a computer as each means of the information processing apparatus of any one of Claims 1 thru | or 3.

Images