JP2005038404A - Data mapping device, data mapping method and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data mapping device capable of linking a data input/output form and a database by a simple operation. <P>SOLUTION: This data mapping device is provided with an input/output form display means displaying the data input/output form 30 and a field display means displaying information 40 on a plurality of fields of the database. The data input/output form 30 has a data area 32 wherein cells 31 are arranged in a matrix and index areas 32, 33 arranged corresponding to a line or a column. A data mapping device is provided with an assignment means receiving the assignment of the field corresponding to each data area and index area and a mapping means mapping so that the data area and the data of the cell in the index area are stored in a designated field and the data of the cell in the data area and the data of the cell in the index area corresponding to the position of the line or the column of the cell are stored in the same record. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a data mapping device, a data mapping method, and a program for creating a data input / output device that links a data input / output form for inputting or displaying data and a database.

Conventionally, in accounting management software and the like, for example, a system in which a data input / output sheet created by spreadsheet software and a database are linked is known. An example of this system is disclosed in Non-Patent Document 1. In this system, a code is assigned to each cell of the data input / output sheet and is associated with a storage location in the database. Specifically, a sheet having the same design as the data input / output sheet is prepared, and a code is written in each cell on the sheet.
“DLINC Solutions ORDER Input Screen Design Guide” Dentsu International Information Service Co., Ltd. (pages 3 and 4)

  In the above system, the association work is performed for each cell which is a unit of data input / output. Since the number of cells in the data input / output sheet is large, it took time to link the data input / output sheet with the database. In addition, since the method of directly describing the allocation code on the sheet is adopted, it is necessary to allocate the code again when the design of the data input / output form is changed.

  In view of the above-described background, an object of the present invention is to provide a data mapping device, a data mapping method, and a program that can create a data input / output device that links a data input / output form and a database with a simple operation.

  A data mapping apparatus according to the present invention is a data mapping apparatus that creates a data input / output device in which a data input / output form for inputting or displaying data and a database are linked, and includes a plurality of cells in which data can be input or displayed. Means for displaying the data input / output form, means for displaying a plurality of fields of the database, designation of a data area of the data input / output form and a field corresponding to the data area, and a cell in the data area A heading area for displaying information relating to the data of the data, means for accepting designation of the field corresponding to the heading area, data of cells in the data area and the heading area are respectively stored in the designated fields, and Cell data in the data area And means for mapping as with the cell heading area data corresponding to the position of the cell is stored in the same record.

  According to the present invention, the mapping means performs mapping so that the cell data in the designated data area and the cell data in the header area corresponding to the position of the cell are stored in the same record. That is, if a data area and a heading area are designated, cells included in each of the data area and the heading area are associated with each other based on the position information of the cells in the area. Therefore, it is not necessary to individually specify the storage location of the data of each cell in the data area. Mapping can be performed by a simple operation of designating a data area and a heading area and corresponding fields.

  In the present invention, cell data is associated between different areas based on cell position information in each area. Therefore, even if the positional relationship between the data area and the heading area is shifted due to the design change of the data input / output form, the correspondence of the cell data can be maintained.

  The data mapping device of the present invention is a data mapping device for creating a data input / output device in which a data input / output form for inputting or displaying data and a database are linked, and is capable of inputting or displaying data. Means for displaying the data input / output form having cells; means for displaying a plurality of fields of the database; a data area in which the cells are arranged in a matrix; and designation of the field corresponding to the data area; A heading area arranged corresponding to a row or a column of the data area and a means for receiving designation of the field corresponding to the heading area; and data of the cells in the data area and the heading area are designated Stored in the field and in the data area And means for mapping as the Le data and the cell heading area corresponding to the position of the row or column of the cell data is stored in the same record.

  According to the present invention, the mapping means stores the cell data in the designated data area and the cell data in the header area corresponding to the row or column position of the cell in the same record. Map. That is, if a data area and a heading area are designated, cells included in each of the data area and the heading area are associated with each other based on the position information of the cells in the area. Therefore, it is not necessary to individually specify the storage location of the data of each cell in the data area. Mapping can be performed by a simple operation of designating a data area and a heading area and corresponding fields.

  In the present invention, cell data is associated between different areas based on cell position information in each area. Therefore, even if the positional relationship between the data area and the heading area is shifted due to the design change of the data input / output form, the correspondence of the cell data can be maintained.

  The data mapping apparatus determines whether the designation of the heading area and the data area corresponds to the number of cells in the designated heading area and the number of cells in the designated row or column of the data area. The mapping unit may perform mapping according to the determination that the heading area and the data area correspond to each other.

  By providing means for determining whether the designated data area corresponds to the designated heading area, if the data area does not correspond to the designated heading area, for example, the user is notified of an area designation error. it can. Incorrect area designation can be prevented, and a user who creates a data input / output device can be supported.

  The means for accepting the designation may accept selection of whether the data area is an area for inputting data or an area for displaying data when the data area is designated.

  With this configuration, it is possible to set whether the data input to the data area is stored in the database or whether the data stored in the database is displayed in the data area.

  The data mapping device of the present invention according to another aspect is a data mapping device for creating a data input / output device in which a data input / output form for inputting or displaying data and a database are linked. Means for displaying the data input / output form having a plurality of displayable cells; means for displaying a plurality of fields of the database; and an area of the data input / output form is dragged to one of the displayed fields Means for mapping so that data of cells in the area are stored in the field in response to being dropped.

  According to the present invention, the mapping means stores the data in the designated area in the designated field in response to the designated area in the data input / output form being dragged and dropped onto the field. Mapped to Therefore, it is not necessary to individually specify the storage location of each cell in the area, and mapping can be performed by a simple operation of specifying the area and dragging and dropping it into the field. At this time, cells may be associated between different areas based on the position information of the cells in the area. Thereby, the data of the corresponding cell can be stored in the same record.

  A data mapping device according to another aspect of the present invention is a data mapping device that creates a data input / output device in which a data input / output form for inputting or displaying data and a database are linked, and inputs or displays data. Means for displaying a sheet having a plurality of possible cells, means for displaying a plurality of fields of the database, and data stored in each field is data of a heading or data of a value corresponding to the heading Storage means for storing data type information for identifying whether or not, an area including at least one cell in the sheet, a means for receiving designation of the field associated with the area, and field data read from the storage means Corresponds to the field where the heading data is stored based on the type information An area associated with the field in which the value data is stored is a data area, and the cell data in the data area and the cell data in the header area corresponding to the position of the cell And means for mapping so as to constitute the same record.

  Thus, by associating an area including a plurality of cells with a database field, a heading area or a data area is created on the sheet, and a data input / output form can be created. Since the data input / output form heading area and data area are mapped to each field of the database, the created data input / output form can be linked to the database without specifying each cell individually. it can.

  The data mapping apparatus includes area type setting means for setting a data area setting range capable of setting the data area on the sheet and a heading area setting range capable of setting the heading area, and the mapping means includes: When the area associated with the field storing the header data is in the header area settable range, and the area associated with the field storing the value data is in the data area settable range In addition, the mapping may be performed.

  Thus, by setting the heading area settable range and the data area settable range by the area type setting means, the area within the heading area settable range is associated with the field in which the heading data is stored, and the data area It is possible to check whether or not an area within the settable range is associated with a field in which a heading value is stored. Thereby, an erroneous area designation can be prevented and a user who creates a data input / output device can be supported.

  In the data mapping apparatus, the area type setting unit includes a unit that receives selection of one of the cells arranged in a matrix, and the vertical axis and the horizontal axis are based on the cell that has received the selection. One of the four ranges of the partitioned sheet may be set as a data area settable range, and the remaining range may be set as a headline area settable range.

  Thus, by setting one of the four divided ranges as a data area and the remaining as a heading area, the heading area can be set corresponding to the row or column of each cell in the data area. Also, when a row or column is added to the data area, a row or column is added to the corresponding heading area, so that an appropriate relationship between the data area and the heading area can be maintained.

  The data mapping device includes means for accepting an extension setting of the heading area, and displays data read from the database according to data read from a field associated with the heading area for which the extension setting has been made. Then, a data input / output form for expanding the heading area and the data area by adding a row or a column to the matrix-like cell may be created.

  In this way, when the data input / output form is created by accepting the extended setting of the heading area and creating the data input / output form in which the heading area is expanded according to the data read from the database, There is no need to be aware of In addition, it can cope with the case where the data amount of the database fluctuates. If extended settings are made in the row header area corresponding to the data area row, add a row. If extended settings are made in the column header area corresponding to the data area column, add a column. To extend the data input / output form.

  The data mapping device determines whether another heading area exists in the same row as the row heading area when an extension setting is made in a row heading area corresponding to the row of the data area, and the data area Means for determining whether or not another heading area exists in the same column as the column heading area when the extension setting is made in the column heading area corresponding to the column, and the same row or column as the row heading area Means for notifying an inconsistency in area setting in response to determination that another heading area exists in the same column as the heading area may be provided.

  The same row as the heading area with the extended setting and the same column area as the column heading area with the extended setting are expanded together with the heading area at the time of data output, so it is determined whether another heading area is set. When another area is set, it is preferable to notify the inconsistency of the area setting. This prompts the user not to set another heading area in the same row as the extended heading area and in the same column as the extended heading area. Inconsistencies in data input / output forms associated with the expansion of the can be prevented in advance.

  In the data mapping device, the means for determining whether or not the position of the heading area and the data area corresponding to the extended setting by the setting accepting means correspond to the position of the heading area and the data area Means for notifying inconsistencies in the area setting in accordance with the determination that it has not been performed.

  When the position of the data area does not correspond to the position of the headline area, the user is notified of the inconsistency in the area setting, thereby prompting the user to associate the position of the data area and the headline area. As a result, even in the data input / output form expanded at the time of data output, the heading area and the data area correspond to each other, so that an appropriate data input / output form can be displayed.

  A data mapping method of the present invention is a data mapping method for creating a data input / output device in which a data input / output form for inputting or displaying data and a database are linked, and a plurality of cells capable of inputting or displaying data are arranged. Displaying the data input / output form, displaying a plurality of fields of the database, specifying a data area of the data input / output form and the field corresponding to the data area, and in the data area Displaying information related to cell data, receiving the designation of the field corresponding to the area and the heading area, storing data of the cells in the data area and the heading area, respectively, in the designated field; and The data area Comprising of a step of mapping to data and the data of the heading area cell corresponding to the position of the cell are stored in the same record, the.

  According to the present invention, in the mapping step, mapping is performed so that the cell data in the designated data area and the cell data in the header area corresponding to the position of the cell are stored in the same record. That is, if a data area and a heading area are designated, cells included in each of the data area and the heading area are associated with each other based on the position information of the cells in the area. Therefore, it is not necessary to individually specify the storage location of the data of each cell in the data area. Mapping can be performed by a simple operation of designating a data area and a heading area and corresponding fields.

  In the present invention, cell data is associated between different areas based on cell position information in each area. Therefore, even if the positional relationship between the data area and the heading area is shifted due to the design change of the data input / output form, the correspondence of the cell data can be maintained.

  The program of the present invention is a program for linking a data input / output form for inputting or displaying data and a database, and displays the data input / output form having a plurality of cells into which data can be input or displayed. A step of displaying a plurality of fields of the database; a data area of the data input / output form; a designation of the field corresponding to the data area; and a header for displaying information relating to data of cells in the data area Receiving the designation of the field corresponding to the area and the heading area; storing data of the cells in the data area and the heading area in the designated field; and Corresponding to the cell position Wherein the data of the heading area of the cell to perform the step of mapping to be stored in the same record, to the computer.

  By executing the program of the present invention by the computer, the computer stores the cell data in the designated data area and the cell data in the header area corresponding to the cell position in the same record. Map. That is, if a data area and a heading area are designated, cells included in each of the data area and the heading area are associated with each other based on the position information of the cells in the area. Therefore, it is not necessary to individually specify the storage location of the data of each cell in the data area. Mapping can be performed by a simple operation of designating a data area and a heading area and corresponding fields.

  Further, by executing the program of the present invention by a computer, the computer associates cell data between different areas based on the cell position information in each area. Therefore, even if the positional relationship between the data area and the heading area is shifted due to the design change of the data input / output form, the correspondence of the cell data can be maintained.

  The program of the present invention is a program for linking a data input / output form for inputting or displaying data and a database, and displays the data input / output form having a plurality of cells into which data can be input or displayed. Displaying a plurality of fields of the database, a data area in which the cells are arranged in a matrix, designation of the field corresponding to the data area, and a row or column of the data area A step of accepting designation of the arranged heading area and the field corresponding to the heading area, and data of the cells in the data area and the heading area are stored in the designated field, and the cells of the data area Data and the row or And the cell heading area corresponding to the position of the column data to execute a step of mapping to be stored in the same record, to the computer.

  By executing the program of the present invention by the computer, the computer stores the cell data in the designated data area and the cell data in the header area corresponding to the row or column position of the cell in the same record. To be mapped. That is, if a data area and a heading area are designated, cells included in each of the data area and the heading area are associated with each other based on the position information of the cells in the area. Therefore, it is not necessary to individually specify the storage location of the data of each cell in the data area. Mapping can be performed by a simple operation of designating a data area and a heading area and corresponding fields.

  Further, by executing the program of the present invention by a computer, the computer associates cell data between different areas based on the cell position information in each area. Therefore, even if the positional relationship between the data area and the heading area is shifted due to the design change of the data input / output form, the correspondence of the cell data can be maintained.

  The program determines whether or not the heading area and the data area correspond to each other based on the number of cells in the designated heading area and the number of cells in the designated row or column of the data area. The step may be executed by a computer and the mapping may be performed by the computer in response to the determination that the heading area and the data area correspond to each other.

  By causing the computer to execute a step of determining whether the designated data area and the designated heading area correspond to each other, when the data area and the heading area are not designated, for example, an error in area designation is generated. Users can be notified. Incorrect area designation can be prevented, and a user who creates a data input / output device can be supported.

  In the step of accepting the mapping, when mapping the area and the field, selection of whether the area is an area for inputting data or an area for displaying data may be accepted.

  Thereby, it is possible to set whether the data input to the data area is stored in the database or whether the data stored in the database is displayed in the data area.

  By executing the program of the present invention on the computer, the computer can map the data of the cells in the area in response to the specified area in the data input / output form being dragged and dropped into the field. Is mapped so that is stored in the specified field. Therefore, it is not necessary to individually specify the storage location of each cell in the area, and mapping can be performed by a simple operation of specifying the area and dragging and dropping it into the field. At this time, cells may be associated between different areas based on the position information of the cells in the area. Thereby, the data of the corresponding cell can be stored in the same record.

  A program according to another aspect of the present invention is a program that links a data input / output form for inputting or displaying data and a database, and displays a sheet having a plurality of cells into which data can be input or displayed. Displaying a plurality of fields in the database; receiving an area including at least one cell in the sheet; and specifying the field associated with the area; and data stored in each field, Based on the data type information for identifying whether the data is heading data or value data corresponding to the heading from the storage means, and the data type information of the field read from the storage means, Look at the area associated with the stored field. The area associated with the field in which the value data is stored is defined as the data area, and the cell data in the data area and the cell data in the header area corresponding to the position of the cell have the same record. Mapping to configure the computer to execute.

  When the program of the present invention is executed by a computer, a heading area or a data area is created on a sheet by accepting correspondence between an area including a plurality of cells of the sheet and a field, and a data input / output form can be created. . Since the data input / output form heading area and data area are mapped to each field of the database, the created data input / output form can be linked to the database without specifying each cell individually. it can.

  In the above program, the method includes an area type setting step for setting a data area settable range in which the data area can be set in the sheet and a heading area settable range in which the heading area can be set, and the mapping step includes the step of mapping When the area associated with the field storing the heading data is within the heading area settable range and the area associated with the field storing the value data is within the data area settable range, The mapping may be performed.

  By executing the area type setting step in this way and setting the heading area settable range and the data area settable range, the area within the heading area settable range is associated with the field in which the heading data is stored, It is possible to check whether an area within the data area setting range is associated with a field in which the value of the header is stored. Thereby, an erroneous area designation can be prevented and a user who creates a data input / output device can be supported.

  The program includes a step of accepting selection of one of the cells arranged in a matrix, and the area type setting step is partitioned by a vertical axis and a horizontal axis based on the cell that has accepted the selection. One of the four ranges of the sheet may be set as a data area settable range, and the remaining range may be set as a heading area settable range.

  Thus, by setting one of the four divided ranges as a data area and the remaining as a heading area, the heading area can be set corresponding to the row or column of each cell in the data area. Also, when a row or column is added to the data area, a row or column is added to the corresponding heading area, so that an appropriate relationship between the data area and the heading area can be maintained.

  The program causes the computer to execute a step of accepting the extended setting of the header area, and when displaying the data read from the database, the program reads the data read from the field associated with the header area for which the extended setting has been made. Accordingly, a data input / output form for expanding the heading area and the data area by adding a row or a column to the matrix-like cell may be created.

  If the program of the present invention is executed by a computer, it accepts the extension setting of the heading area and creates a data input / output form in which the heading area is expanded according to the data read from the database. When you do, you do not need to be aware of database data. In addition, it can cope with the case where the data amount of the database fluctuates. If extended settings are made in the row header area corresponding to the data area row, add a row. If extended settings are made in the column header area corresponding to the data area column, add a column. To extend the data input / output form.

  The program determines whether or not another heading area exists in the same row as the row heading area when an extension setting is made in a row heading area corresponding to the row of the data area, and the column of the data area When the extended setting is made in the column heading area corresponding to the step of determining whether another heading area exists in the same column as the column heading area, and the same row as the row heading area or the column heading area And a step of notifying the area setting inconsistency in response to the determination that another heading area exists in the same column.

  The same row as the heading area with the extended setting and the same column area as the column heading area with the extended setting are expanded together with the heading area at the time of data output, so it is determined whether another heading area is set. When another area is set, it is preferable to notify the inconsistency of the area setting. This prompts the user not to set another heading area in the same row as the extended heading area and in the same column as the extended heading area. Inconsistencies in data input / output forms associated with the expansion of the can be prevented in advance.

  In the program, the step of determining whether or not the position of the heading area and the data area that have been expanded in the setting receiving step correspond to the position of the heading area and the data area. In response to the determination that there is not, the computer may execute a step of notifying the inconsistency of the area setting.

  When the position of the data area does not correspond to the position of the headline area, the user is notified of the inconsistency of the area setting, thereby prompting the user to associate the position of the data area with the position of the headline area. As a result, even in the data input / output form expanded at the time of data output, the heading area and the data area correspond to each other, so that an appropriate data input / output form can be displayed.

  The recording medium of the present invention records the program described above.

  By causing the computer to read and execute the program recorded on the recording medium, the cells of the data input / output form and the database can be mapped by a simple operation as in the case of the program.

  According to the present invention, the mapping means performs mapping so that the cell data in the designated data area and the cell data in the header area corresponding to the position of the cell are stored in the same record. That is, if a data area and a heading area are designated, cells included in each of the data area and the heading area are associated with each other based on the position information. Therefore, it is not necessary to individually specify the storage location of the data of each cell in the data area, and mapping can be performed by a simple operation of specifying the data area and the header area and the corresponding field. .

  Hereinafter, a data mapping apparatus according to an embodiment of the present invention will be described.

  FIG. 1 is a block diagram showing a configuration of a data mapping apparatus 1 according to the first embodiment of the present invention. The data mapping apparatus 1 of the first embodiment can be configured by a normal personal computer. The data mapping apparatus 1 is realized by storing a program for data mapping in a memory and executing the program by a computer. In the data mapping apparatus 1, a monitor 21, a keyboard 22, a mouse 23, and a hard disk (HDD) 24 are connected to the control unit 10. A database 25 is configured in the HDD 24. The database 25 is controlled by the database control means 16 of the control unit 10. The database 25 here includes a database managed by a dedicated database server, and also includes a file storing data according to a predetermined table format.

  The control unit 10 of the data mapping apparatus 1 includes an input / output form display unit 11 that displays a data input / output form, a field display unit 12 that displays field information, an area of the displayed data input / output form, and the area thereof. A designation unit 13 that designates a corresponding field, a determination unit 14 that determines consistency of a designated area, and a mapping unit 15 that performs mapping based on designation by the designation unit 13 are provided.

  In this data mapping apparatus 1, the data input / output form and field information displayed by the input / output form display unit 11 and the field display unit 12 are specified by the user by the specifying unit 13. The specified area and field are mapped by the mapping means 15. Hereinafter, each component will be described in detail.

  The input / output form display means 11 has a function of displaying on the monitor 21 a data input / output form for inputting / outputting data. The data input / output form is created by spreadsheet software, for example. The data mapping apparatus 1 can display the created data input / output form on the monitor 21 by reading it. It is also possible to edit the displayed data input / output form with the keyboard 22 or the mouse 23.

  The field display unit 12 has a function of displaying information related to fields in the database 25. The database 25 is accessed by the database control means 16. The field display unit 12 is connected to the database control unit 16, acquires information related to the fields of the database 25 from the database control unit 16, and displays the information on the monitor 21.

  FIG. 2 is a diagram illustrating an example of the data input / output form 30 and the field-related information 40 displayed on the monitor 21. The screen display of the monitor 21 is divided into left and right, and a data input / output form 30 is displayed in the left window. The right window is further divided up and down. The mapping list information is displayed in the upper right window. The lower right window is a “mapping setting” window for mapping, and includes information 40 on the fields of the database 25. Each display content will be described below.

  The data input / output form 30 shown in FIG. 2 is a profit and loss statement used in accounting. The data input / output form 30 has a plurality of cells 31 for inputting or displaying data. The data input / output form 30 has a data area 32 in which a plurality of cells 31 are arranged in a matrix. In the following description, the data area 32 is referred to as 1 column and 2 columns from the left to the right, and 1 row, 2 rows,... The data area 32 is a cell for inputting a report numerical value.

  On the left side of the data area 32, a row heading area 33 is arranged. In the row header area 33, the cells 31 are arranged in the column direction of the data area 32. The row header area 33 shows information related to data input to each row. In this example, the row heading area 33 indicates information related to the account item, and for example, the first row of the data area 32 indicates that the information is “sales”.

  A column heading area 34 is arranged above the data area 32. In the column header area 34, the cells 31 are arranged in the row direction of the data area 32. The column heading area 34 shows information regarding data input to each column. In this example, the column heading area 34 indicates information about the company, and for example, the first column of the data area 32 indicates that the information is “Company A”.

  Information 40 relating to the fields of the database 25 is displayed reflecting the information of the table of the database 25. That is, the account item 41, the company 42, and the report numerical value 43 are displayed in FIG. 2 because the table of the database 25 is designed with the account item, the company, and the report numerical value.

  In FIG. 2, items 44, 45, and 46 arranged on the right side of the fields 41, 42, and 43 are information representing the attributes of the areas mapped to the respective fields. The area attribute is information indicating whether the area is an area for inputting data, an area for displaying data, or a row heading area or a column heading area. For example, the attribute of the report numerical value 43 is displayed as “input cell”. This indicates that the area to which the report numerical value 43 is mapped is set as an area for inputting data. That is, data is input to the data area 32 of the data input / output form 30 and stored in the database 25. Conversely, when “output cell” is displayed, the data in the database 25 is read and displayed in the data area 32.

  The mapping list 50 is a display for switching between the data input / output form 30 and the corresponding field information 40. “LIST1” currently displayed is a profit and loss statement mapping list. By selecting the mapping list, another data input / output form 30 can be selected and mapping can be performed.

  With reference to FIG. 1 again, the configuration of the data mapping apparatus 1 will be described. The data mapping apparatus 1 includes a designation unit 13 that designates an area of the displayed data input / output form 30 and a corresponding field, a determination unit 14 that judges consistency of a plurality of areas designated by the designation unit 13, and a designation Mapping means 15 for mapping the designated area and field is provided.

  For example, the designating unit 13 recognizes a range designated by the mouse 23 as an area. Then, by dragging and dropping the designated area onto the field, the field designated as the area mapping destination is recognized.

  FIG. 3 is a diagram for explaining a user interface when the designation unit 13 accepts designation of an area and a field. As shown in FIG. 3, first, an area in the data input / output form 30 is designated. In this example, the data area 32 is designated. Then, the designated data area 32 is dragged and dropped to the field of the report numerical value 43. By this drag-and-drop operation, the designation unit 13 recognizes that the data area 32 and the field of the mapping destination report numerical value 43 are designated. At this time, an item indicating the attribute of the field is pop-up displayed in the “mapping setting” window, and the user is allowed to select whether the attribute of the designated area is “input cell” or “output cell”.

  FIG. 4 is a diagram illustrating a user interface when the designation unit 13 accepts designation of the column heading area 34 and the corresponding company field. As shown in FIG. 4, the column heading area 34 and the company name 42 can be designated by dragging and dropping the column heading area 34 to the “company name” field in the same manner as the data area 32. At this time, it is possible to set so that a choice of company name pops up in the column header area 34 of the data input / output form 30.

  FIG. 5 is a setting screen for popping up company options in the column header area 34. The user is allowed to set information to be popped up in the column header area 34. Here, as shown in FIG. 5, it is set to read out data to be pop-up displayed in the column header area 34 from the company master. With this setting, the contents of the column heading area 34 of the data input / output form 30 can be selected from the company names popped up.

  The determination unit 14 has a function of determining consistency between the designated data area 32 and the designated row heading area 33 or column heading area 34. For example, when the number of rows in the row header area 33 is larger than the number of rows in the designated data area 32, or when the number of columns in the column header area 34 is larger than the number of columns in the data area 32, the data area 32 and the row header area 33 or the column heading area 34 is determined not to match. If it is determined that they do not match, the user is prompted to specify an area again. By providing this determination means 14, the data mapping apparatus 1 can stop the data mapping process when an erroneous area is specified, and avoid the creation of a buggy data input / output apparatus. By providing such user support means, the reliability of the created data input / output device can be improved.

  The mapping unit 15 has a function of mapping the area and field designated by the designation unit 13. The mapping associates the cell of the data input / output form 30 with the data storage location of the cell. At this time, the cells in each area are associated with each other based on the position information of the cells in the data area 32 and the position information of the cells in the row heading area 33 or the column heading area 34. Hereinafter, this point will be described.

  FIG. 6 is a diagram for explaining data mapping. As shown in FIG. 6, each cell has position information in the area. FIG. 6 shows cell position information in the area. A cell in m rows and n columns in the data area 32 has position information D (m, n). The cells in the row heading area 33 also have position information on the number of rows from the top. That is, the cell in the m-th row from the top has position information Rm. The cells in the column heading area 34 also have position information on the number of columns from the left. That is, the cell in the nth column from the left has position information Cn. Based on this position information, the mapping means 15 can grasp the correspondence between the cells in the data area 32 and the cells in the row heading area 33 and the column heading area 34. For example, the data input to D (1,1) in the data area 32 corresponds to the data in the first row in the row header area 33 and the data in the first column in the column header area 34. Based on this information, the mapping means 15 has the same data input to D (1,1) of the data area 32, the first row data of the row header, and the first column data of the column header. It is possible to perform mapping so as to be stored in the record.

  FIG. 7A and FIG. 7B are diagrams for explaining the mapping. FIG. 7A shows an example of displaying a data input / output form using the data input / output device created by the data mapping device 1, and FIG. 7B shows the data input / output of FIG. 7A. It is a figure which shows the example in which the data input into the form were stored in the database. As described above, the cells of the data input / output form 30 are mapped to the fields of the database 25, so that the data of the corresponding cells in the data area 32, the row header area 33, and the column header area 34 are stored in the same record in the database 25. Stored. For example, referring to the first row and the first column of the data input / output form 30, the sales amount of the company A is “10000”. The first row of the row header area 33 is “Sales”, and the first column of the column header area 34 is “Company A”. By storing in the database 25 based on the position information, the data is stored as seen in the first record of the database 25.

  Next, the operation of the data mapping apparatus 1 according to the first embodiment will be described.

  FIG. 8 is a flowchart showing the operation of the data mapping apparatus 1. First, the data mapping apparatus 1 displays the data input / output form 30 (S10). The data input / output form 30 displays the data input / output form 30 by reading the data input / output form 30 created in advance by spreadsheet software. Subsequently, the data mapping apparatus 1 acquires the information of the database 25 by the database control means 16 and displays the field information 40 of the database 25 (S12). Here, the data input / output form 30 and the field information 40 are displayed in order, but the data input / output form 30 and field information may be read in advance and displayed at the same time. In addition, a plurality of data input / output forms 30 and a plurality of field information corresponding thereto may be read in advance. Then, the user may select which data input / output form 30 is to be subjected to data mapping, and information on the selected data input / output form 30 and the corresponding field may be displayed.

  Next, the data mapping apparatus 1 accepts designation of an area (S14). The order of designation of each of the data area 32, the row heading area 33, and the column heading area 34 is arbitrary. In the following description, it is assumed that the data area 32 is started. The data area 32 is designated, the designated data area 32 is dragged and dropped onto the field, and the field to which the data area 32 is mapped is designated (S16).

  Next, the data mapping apparatus 1 accepts attribute selection of the designated area (S18). The selection of whether the attribute of the data area 32 is an input cell or an output cell is accepted. Then, the data mapping apparatus 1 maps the data area 32 and the field of the data input / output form 30 based on the designated data area 32, the designated field, and the selected attribute (S20).

  Next, the data mapping apparatus 1 determines whether or not all areas of the data input / output form 30 have been designated (S22). If all areas have been designated, the process proceeds to step S24 for consistency determination. If there are other areas to be designated, the process proceeds to area designation step S14. In this example, the line header area 33 is mapped after the data area 32.

  The line heading area 33 is designated (S14), the designated line heading area 33 is dragged and dropped onto the corresponding field, and the field for mapping the line heading area 33 is designated (S16). Next, the data mapping apparatus 1 accepts attribute selection of the designated area (S18). Here, the designated area is the line heading area 33, and the attribute of the line heading area 33 is selected. Then, the data mapping apparatus 1 maps the line heading area 33 and the field of the data input / output form 30 based on the designated line heading area 33, the designated field, and the selected attribute (S20).

  Thereafter, the column heading area 34 is similarly mapped to the corresponding field. When it is determined that the mapping has been completed for all the areas by determining whether all the areas have been specified (S22), the data mapping apparatus 1 determines whether the specified areas are consistent (see FIG. S24). The consistency is determined based on the number of rows in the data area 32 and the number of rows in the row header area 33, and the number of columns in the data area 32 and the number of columns in the column header area 34. For example, when the number of lines in the line heading area 33 is larger than the number of lines in the data area 32, it is determined that the designated data area 32 and the designated line heading area 33 are not consistent, and the data mapping device 1 prompts the area designation again (S26).

  When it is determined that consistency is achieved, the data mapping operation by the data mapping apparatus 1 ends. The operation of the data mapping apparatus 1 according to the embodiment has been described above.

  In the data mapping apparatus 1 according to the first embodiment of the present invention, the data input / output form 30 has a data area 32 and a corresponding row header area 33 and column header area 34. Then, the cell in the data area 32 is associated with the cell in the row header area 33 corresponding to the row of the cell, and the cell in the column header area 34 corresponding to the column of cells in the data area 32. The data of the cells in the associated data area 32, row heading area 33, and column heading area 34 are stored in the same record of the database 25. Thereby, it is not necessary to perform mapping for each cell. Therefore, the cells in the specified area of the data input / output form 30 and the fields of the database 25 can be mapped by a simple operation of specifying the area of the data input / output form 30 and the corresponding field on the screen.

  Further, in the data mapping apparatus 1 according to the first embodiment, cell data is associated between different areas based on cell position information in each area. That is, regardless of the position of the cell in the data input / output form, the cell is related between different areas depending on the position in the area. Thereby, even if the positional relationship between the data area 32 and the header areas 33 and 34 is shifted due to the design change of the data input / output form 30, the correspondence of the cell data can be maintained.

  In addition, since the mapping is performed in the area unit, the mapping can be kept valid even when a row or a column is added to the area. For example, in the data input / output form 30 shown in FIG. 2, when a line of “operating expenses” is added between “sales amount” and “cost of sales”, the number of each account item is in the line heading area. And the information on what row the cell in the data area is shifted correspondingly. Therefore, even if the design of the row insertion is changed, the correspondence between the row heading area and the cells in the data area is maintained.

  In the data mapping device 1 according to the first embodiment, the consistency between the designated data area 32 and the row heading area 33 or the column heading area 34 is determined. Encourage re-designation. It is possible to reduce the possibility of creating a buggy data input / output device without performing mapping based on an erroneous area designation.

  Next, a program according to the embodiment of the present invention will be described. As described above, the data mapping apparatus 1 is realized by executing the program according to the embodiment.

  FIG. 9 is a diagram illustrating a configuration of the program 60 according to the embodiment. The data mapping program 60 includes an input / output form display module 61, a field display module 62, a designation module 63, a determination module 64, and a mapping module 65.

  The input / output form display module 61 is a module that displays the data input / output form 30 by being executed by a computer. The field display module 62 is a module that displays information related to fields in the database 25 by being executed by a computer. The designation module 63 is a module that allows the computer to accept the designation of the area of the data input / output form 30 and the designation of the field corresponding to the area by being executed by the computer. The determination module 64 is a module for determining consistency of a plurality of designated areas by being executed by a computer. The mapping module 65 is a module that maps a specified area and a specified field by being executed by a computer.

  By executing the data mapping program 60 by a computer, the above-described data mapping apparatus 1 can be realized, and the cells of the data input / output form and the storage location of the database can be mapped by a simple operation.

  Moreover, a recording medium according to an embodiment of the present invention can be configured by recording the program on a recording medium. By reading the recording medium with a computer and executing it, a data mapping apparatus capable of mapping the cell of the data input / output form and the storage location of the database can be realized with a simple operation, similar to the above program.

  The data mapping apparatus 1, the data mapping method, and the program 60 according to the first embodiment of the present invention have been described above.

  In the data mapping apparatus 1 described above, the data input / output form 30 having the data area 32 composed of cells for data input, the row heading area 33 and the column heading area 34 has been described as an example. It goes without saying that the present invention can also be applied to the data input / output form 30 having only one of the heading areas 34. The present invention is also applicable to other types of data input / output forms 30. Hereinafter, another data input / output form 30 will be described.

  FIG. 10 is a diagram showing an example of a data input / output form 30 having a data area 32 composed of cells for data input and a data area 35 composed of cells for data display. In this example, the data area 32 corresponding to “current period” in the column heading is an input data area, and the data area 35 corresponding to “first period” in the column heading is a data area for display. In the data input / output form 30, the data input in the input data area 32 is stored in the database 25, and the data stored in the database 25 is displayed in the display data area 35.

  For example, the data input / output form 30 is mapped by mapping the data area 32 using the mapping list “LIST1” and mapping the data area 35 using the mapping list “LIST2”. When the data area 35 is mapped to the field 47, by selecting “output cell” as the attribute of the data area 35, the attribute of the data area 35 can be set for display. As a result, the type in the mapping list becomes “Refer”. This means that the data area displays data. As described above, even in the case of the data input / output form 30 having the data area including both the input cell and the output cell, the cell of the data input / output form 30 can be obtained by a simple operation of specifying the area and the field of the database 25. And the data storage location of the database 25 can be mapped.

  FIG. 11 is a diagram showing an example of the data input / output form 30 provided with a heading 36 composed of one cell. In this example, one heading 36 is attached to the entire sheet. By dragging and dropping the headline 36 to the corresponding “product code” field, the headline 36 is associated with all data input to the data area 32.

  In the example shown in FIG. 11, the data area 32 is divided into areas 32a, 32b, and 32c one column at a time. In each area, data of “stock amount”, “undelivered item”, and “revaluation reduction” are input. In the above-described embodiment, one data area 32 is composed of areas composed of a plurality of rows. For example, in the data input / output form shown in FIG. 2, each column of the data area 32 indicates data relating to “Company A” and “Company B”. In this case, in the database 25, any data of “Company A” and “Company B” is input in the “Company name” field, and the data in the data area 32 is any data of “Company A” or “Company B”. Are stored in the same record. On the other hand, in the data input / output form shown in FIG. 11, each data area 32 a, 32 b, 32 c corresponds to different fields “stock price”, “not received”, “devaluation” in the database 25. This data input / output form 30 can also be mapped by designating fields corresponding to the respective column header areas 32a, 32b, and 32c as shown in FIG.

  In the above-described embodiment, the data input / output form 30 having two heading areas of the row heading area 33 and the column heading area 34 has been described as an example. However, the present invention is a data input / output form having three or more heading areas. It is also applicable to. For example, as shown in FIG. 12, it may have a row heading area 33 indicating an account item, a column heading area 34 indicating a period, and a sheet heading area 37 indicating a company. In this case, the position of the cell in the data area can be expressed by three pieces of information (sheet information, row information, and column information). Based on this position information, the cell data in the data area 32 and the corresponding data in each heading area cell can be stored in the same record in the database 25. In this way, by making the information for managing the cell position multidimensional, it is possible to cope with even the number of headings of three or more.

  FIG. 13 is a diagram showing a data input / output form 30 in which a plurality of data areas 32 and 38 share a row header area 33. When such data mapping of the data input / output form 30 is performed, it is possible to map the row header area 33 and the column header area 34 for each of the data areas 32 and 38. By using the information in the area 33, mapping can be facilitated. For example, when the left data area 32 is first mapped and then the right data area 38 is mapped, the information of the row header area 33 mapped in the data area 32 is used.

  FIG. 14 shows a screen for setting the diversion of the row heading area 33. For example, a pop-up is displayed by clicking on an account item as a row heading. The pop-up displays a list of already mapped line headings. By selecting a row header to be diverted from this pop-up display, the row header area 33 can be mapped again without dragging and dropping. Mapping can be easily performed even when the data input / output form 30 is too large to fit into the monitor 21.

  Next, the data mapping apparatus 1 according to the second embodiment of the present invention will be described. A data mapping apparatus 1 according to the second embodiment is an apparatus that creates a data input / output form on a sheet in which cells for inputting / outputting data are arranged in a matrix and links the created data input / output form to a database. . In the following description, an example of creating an output data output form for outputting database data will be described. However, a data input / output form for data input / output is created by the data mapping apparatus 1 of the second embodiment. Is also possible.

  FIG. 15 is a diagram illustrating a configuration of the data mapping apparatus 1 according to the second embodiment. The data mapping apparatus 1 of the second embodiment has the same basic configuration as the data mapping apparatus 1 of the first embodiment, but includes a sheet display means 17 instead of the data input / output form display means 11. Furthermore, a base cell receiving means 18 and an area type setting means 19 are provided. Further, the determination unit 14 determines whether or not the data area and the heading area are set at appropriate locations, in addition to the consistency determination similar to that of the data mapping apparatus 1 of the first embodiment.

  The sheet display means 17 has a function of displaying a sheet having a plurality of cells arranged in a matrix. In this embodiment, a data output form for output is created on this sheet.

  The area type setting unit 19 has a function of setting a range in which a data area can be set and a range in which a heading area can be set in the displayed sheet. The area type setting unit 19 divides the sheet into respective ranges based on the base cell received by the base cell receiving unit 18.

  FIG. 16 is a diagram illustrating an example of a screen when a base point is received by the base point cell receiving unit 18. As shown in FIG. 16, the sheet display means 17 displays a sheet in which the heading area and the data area are not defined. When the base point setting button 70 is pressed in a state where any cell 71 on the sheet is focused, the base cell receiving unit 18 receives the focused cell 71 as the base cell.

  As shown in FIG. 17, the area type setting means 19 divides the sheet into four ranges by a vertical axis 72 and a horizontal axis 73 that pass through the upper left point of the base cell 71, and the lower right range is the data area settable range. 74, and the remaining range is a heading area settable range 75. Since the sheet extends rightward and downward, the size of the data output area is not limited by setting the lower right range of the four ranges as the data area settable range 74. It is also possible to cope with fluctuations in the data amount of the database 25. In addition, since there is a heading area setting range 75 above and to the left of the data area setting range 74, it is possible to set a heading area corresponding to the data area.

  In the second embodiment, the HDD database 25 stores data type information stored in each field. The data type information is information for identifying whether the data stored in each field is heading data or value data corresponding to the heading. For example, as shown in FIG. 18, in the accounting report data, the data type of the account item and the company name is a headline, and the data type of the report numerical value corresponding to the account item and the company is a value.

  The determination unit 14 determines whether the data area or the heading area specified by the specifying unit 13 is specified at an appropriate place on the sheet, that is, whether the type of the area on the sheet matches the data type of the field. It has a function to determine whether. Specifically, the determination unit 14 can set an area associated with a field whose data type is a heading as a heading area, an area associated with a field whose data type is a value as a data area, and the heading area can be set as the heading area. It is determined whether it is within the range or the data area is within the data area settable range. The determination unit 14 also has a function of determining the consistency between the designated column heading and row heading and the data area, as in the first embodiment.

  FIG. 19 is a diagram illustrating an operation of the data mapping apparatus 1 according to the second embodiment. In the second embodiment, the data mapping apparatus 1 first displays a sheet by the sheet display unit 17 (S30), and displays a field of the database 25 by the field display unit 12 (S32).

  Subsequently, the data mapping apparatus 1 accepts the setting of the base cell (S34). When receiving the setting of the base point cell, the area type setting unit 19 of the data mapping apparatus 1 sets the data area settable range and the heading area settable range for the sheet based on the set base point cell (S36). The setting of the data area settable range and the heading area settable range based on the base cell is performed by the method described with reference to FIG.

  Next, the designation unit 13 of the data mapping apparatus 1 accepts designation of an area (S38) and accepts designation of a field associated with the designated area (S40). FIG. 20 is a diagram illustrating an example of a screen when an area designation and a field designation are accepted. As shown in FIG. 20, by designating an area on the sheet and dragging and dropping the designated area onto the field, the field to which the area is mapped is designated.

  The determination unit 14 of the data mapping apparatus 1 determines whether or not the specified area type matches the field data type (S42). Specifically, the determination unit 14 reads the data type information of the field from the database 25, and determines the type of area associated with each field based on the read data type information. That is, an area associated with a field whose data type is a heading is a heading area, and an area associated with a field whose data type is a value is a data area. Then, the determination unit 14 determines whether the heading area is within the heading area settable range or the data area is within the data area settable range. In the example of FIG. 20, the header areas 76 and 77 associated with the header fields 41 and 42 are within the header area setting range, and the data area 78 associated with the value field 43 is the data area. Since it is within the settable range, the determination unit 14 determines that the area designation is consistent. On the other hand, in the example shown in FIG. 21, the area 76 associated with the value field 43 of the data type is determined as the data area, and the data area is within the settable area setting range. It is determined that there is an inconsistency in the correspondence between the fields. Then, the data mapping apparatus 1 notifies the user of an area designation error (S50).

  When it is determined by the determination unit 14 that the area and field types are consistent, the data mapping apparatus 1 performs mapping of the designated area and field (S44). The following operations are the same as those in the first embodiment, and the data mapping apparatus 1 determines whether or not all areas have been designated (S46). If it is determined that the mapping has been completed for all areas, the data mapping is performed. The device 1 determines whether the designated area is consistent (S48). When it is determined that the consistency is achieved, the data mapping operation by the data mapping apparatus 1 is completed. When it is determined that the consistency is not achieved, the area designation is prompted again (S50).

  Next, an example of data output to the data output form created by the data mapping apparatus 1 of the second embodiment will be described. FIG. 22 is a diagram illustrating an example of data stored in the database 25. When areas and fields are mapped as in the example of FIG. 20, the screen shown in FIG. 23 is output from the data in the database 25 shown in FIG. That is, since the row header area 76 is mapped to the account item (see FIG. 20), data is read from the account item field of the database 25 as the row header. Since the column header area 77 is mapped to the company name (see FIG. 20), data is read from the company name field of the database 25 as the column header. Then, for each cell in the data area 78, the data stored in the same record as the row header and column header data corresponding to the position of each cell is read. For example, data read to the cell 79 in 2 rows and 1 column of the data area is obtained as follows. The data of the row header corresponding to the cell 79 in 2 rows and 1 column is “cost of sales”, and the data of the corresponding column header is “A”. Therefore, in the database 25 shown in FIG. 22, the report numerical value stored in the same record as “cost of sales” “A” is “50” in the third row. Therefore, a value of “50” is read out to the cell 79 in 2 rows and 1 column.

  The data mapping apparatus 1 according to the second embodiment of the present invention has been described above.

  The data mapping apparatus 1 according to the second embodiment maps a mapped area and a field by associating an area including the cell with a database field in a sheet having a plurality of cells arranged in a matrix. You can create a data output form on the sheet.

  The data mapping apparatus 1 according to the second embodiment sets a data area settable range and a heading area settable range on a sheet, and when the area and field are specified, the type and field of the specified area are specified. It is determined whether or not the data types match. Thereby, an erroneous area designation can be prevented and a user who creates a data input / output device can be supported.

  In the second embodiment described above, the setting of the base cell is first accepted and the data area settable range and the heading area settable range are set. However, after the designation of the association between the area and the field is received, the base point is set. Cell settings may be accepted. In other words, the base cell may be received later, the data area setting range and the heading area setting range may be set, and it may be checked whether or not there is an inconsistency in the area and field designations performed so far.

  Next, a data mapping apparatus according to the third embodiment of the present invention will be described. The data mapping apparatus of the third embodiment has the same basic configuration and operation as the data mapping apparatus of the second embodiment (see FIGS. 15 and 19), but dynamically sets the range of each area. This is different from the data mapping apparatus of the second embodiment. In the following description, an example in which the column heading area is dynamically set will be described. However, the row heading area can be set dynamically as well.

  FIG. 24 is a diagram illustrating a screen example when the column heading area is dynamically set. In the example of FIG. 24, the screen for creating a data output form displays an interface 80 for selecting an option for outputting a company name when a column heading is associated with a company name field. When automatic expansion is selected in this interface 80, column headings are expanded and output for all companies stored in the database 25 when data is output to the data output form.

  FIG. 25 is a diagram illustrating an output example of data when automatic expansion is set. As shown in FIG. 24, one cell is specified as the column heading. By selecting the automatic expansion option, the company name in the database 25 is sequentially read out to the data output form to display the column. Configure the heading. Specifically, a column is added according to the number of companies read out, and a column heading area is configured in the added column. For example, when the data of 10 companies is read out, 9 columns are added and a total of 10 column heading areas are displayed. By expanding by adding a column, the data area is expanded as the column header area is expanded. Therefore, data corresponding to the column heading area can be displayed in the data area.

  In FIG. 24, since the column heading area and the data area column correspond to each other, as shown in FIG. 25, when the column is added and the column heading area and the data area are expanded, the relationship between the two is broken. There is no, and it is possible to display an appropriate data input / output form with consistency.

  By using such an automatic expansion function, it is not necessary to specify a heading area in accordance with the number of data in the database 25, which is particularly effective in a data output form.

  When the automatic expansion function is used, when the data input / output form is created, the spread of the data input / output form at the time of data output cannot be predicted. However, as described in the second embodiment, data is automatically generated by the automatic expansion of the heading area. Since the data area setting range is defined in the area where the area expands and the heading area cannot be specified in this range, the consistency of the data output form at the time of automatic expansion can be maintained.

  In the third embodiment, in order to maintain the consistency of the data input / output form even at the time of output, the determination unit 14 performs the matching described in the second embodiment when setting the column header area and the data area. In addition to the consistency check, it is preferable to perform the next consistency check, and to notify the user of the inconsistency in the area setting when consistency is not achieved. First, it is checked whether or not the column heading area for which the automatic expansion option is set corresponds to the position of the data area, that is, whether or not they are in the same column. As described above, this is to prevent the relationship between the column header area and the data area from being lost in the data input / output form automatically expanded at the time of data output. Second, it is checked whether another heading area exists in the same column as the column heading area for which the automatic expansion option is set. A column heading area in which the automatic expansion option is set adds a column at the time of data output. Therefore, if there is another heading area in the same column, there is a disadvantage that the column is added to the heading area. The second inconsistency check prevents the above inconvenience by preventing another heading from being set in the same column as the extended column heading area.

  Note that when a fixed headline is selected on the interface 80 shown in FIG. 24, headlines having the same number of company names as the designated area are output. For example, when three columns of headings are designated, data for three companies is output. At this time, if the number of companies stored in the database 25 is larger than the number of designated column headings, the company to be output may be selected from the company master.

  Moreover, the program provided with the module which implement | achieves the function of each component of the data mapping apparatus 1 of 2nd Embodiment or 3rd Embodiment is also contained in the scope of the present invention.

  As described above, according to the present invention, it is not necessary to individually specify the storage location of the cell data for each cell in the data area and heading area of the data input / output form. It is effective as a data mapping device for creating a data input / output device that links a data input / output form and a database.

It is a figure which shows the structure of the data mapping apparatus which concerns on embodiment. It is a figure which shows the screen displayed by the data mapping apparatus which concerns on embodiment. It is a figure which shows the interface which designates a data area and a field with the data mapping apparatus which concerns on embodiment. It is a figure which shows the interface which designates a column header area and a field with the data mapping apparatus which concerns on embodiment. This is a setting screen for popping up choices in column headings. It is a figure explaining the mapping by the data mapping apparatus which concerns on embodiment. It is a figure for demonstrating the mapping by the data mapping apparatus which concerns on embodiment. It is a flowchart which shows operation | movement of the data mapping apparatus which concerns on embodiment. It is a figure which shows the program which concerns on embodiment. It is a figure which shows the example of another data input / output form. It is a figure which shows the example of another data input / output form. It is a figure which shows the example of another data input / output form. It is a figure which shows the example of another data input / output form. It is a setting screen which diverts the set line heading area. It is a figure which shows the structure of the data mapping apparatus which concerns on 2nd Embodiment. It is a figure which shows the screen displayed by the data mapping apparatus which concerns on 2nd Embodiment. It is a figure which shows the heading area settable range and the data area settable range. It is a figure which shows the classification of the field of a database. It is a flowchart which shows operation | movement of the data mapping apparatus which concerns on 2nd Embodiment. It is a figure explaining the mapping by the data mapping apparatus which concerns on 2nd Embodiment. It is a figure explaining the mapping by the data mapping apparatus which concerns on 2nd Embodiment. It is a figure which shows the example of the data stored in the database. It is a figure which shows the result of the mapping by the data mapping apparatus concerning 2nd Embodiment. It is a figure which shows the example of a screen which sets automatic expansion | deployment of a column header area. It is a figure explaining the example of a data output when performing automatic expansion | deployment of a column header area.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Data mapping apparatus, 10 ... Control part, 11 ... Input-output form display means, 12 ... Field display means ", 13 ... Designation means, 14 ... Determination means, 15 * ..Mapping means, 16 ... database control means, 21 ... monitor, 22 ... keyboard, 23 ... mouse, 24 ... HDD, 25 ... database, 30 ... data input / output Form, 40 ... field information.

Claims (24)

A data mapping device for creating a data input / output device that links a data input / output form for inputting or displaying data and a database,
Means for displaying the data input / output form having a plurality of cells capable of inputting or displaying data;
Means for displaying a plurality of fields of the database;
Means for accepting designation of the data area of the data input / output form and the field corresponding to the data area, the heading area for displaying information on the data of the cells in the data area, and the designation of the field corresponding to the heading area When,
The data of the cells in the data area and the heading area are stored in the designated fields, respectively, and the data of the cells of the data area and the data of the cells of the heading area corresponding to the position of the cell are the same record Means for mapping to be stored in
A data mapping apparatus comprising: A data mapping device for creating a data input / output device that links a data input / output form for inputting or displaying data and a database,
Means for displaying the data input / output form having a plurality of cells capable of inputting or displaying data;
Means for displaying a plurality of fields of the database;
Specification of the data area in which the cells are arranged in a matrix and the field corresponding to the data area, the heading area arranged in correspondence with the row or column of the data area, and the field corresponding to the heading area Means to accept the designation;
The data of the cells in the data area and the header area are stored in the designated fields, respectively, and the data of the cells in the data area and the data of the cells in the header area corresponding to the row or column position of the cells Means for mapping so that is stored in the same record;
A data mapping apparatus comprising: Means for determining whether or not the designation of the heading area and the data area corresponds based on the number of cells of the designated heading area and the number of cells in the row or column of the designated data area; In addition,
3. The data mapping apparatus according to claim 2, wherein the mapping unit performs mapping according to determination that the heading area and the data area correspond to each other. The means for accepting the designation accepts selection of whether the data area is an area for inputting data or an area for displaying data when the data area is designated. The data mapping apparatus described in 1. A data mapping device for creating a data input / output device that links a data input / output form for inputting or displaying data and a database,
Means for displaying the data input / output form having a plurality of cells capable of inputting or displaying data;
Means for displaying a plurality of fields of the database;
Means for mapping so that data of cells in the area is stored in the field in response to the area of the data input / output form being dragged and dropped into any of the displayed fields;
A data mapping apparatus comprising: A data mapping device for creating a data input / output device that links a data input / output form for inputting or displaying data and a database,
Means for displaying a sheet having a plurality of cells into which data can be entered or displayed;
Means for displaying a plurality of fields of the database;
Storage means for storing data type information for identifying whether the data stored in each field is heading data or value data corresponding to the heading;
Means for receiving an area including at least one cell in the sheet and designation of the field associated with the area;
Based on the data type information of the field read from the storage means, the area associated with the field in which the header data is stored is defined as the header area, and the area associated with the field in which the value data is stored is the data. An area and means for mapping so that the cell data of the data area and the cell data of the heading area corresponding to the position of the cell constitute the same record;
A data mapping apparatus comprising: An area type setting means for setting a data area settable range in which the data area can be set in the sheet and a heading area settable range in which the heading area can be set;
The mapping means has an area associated with the field storing the heading data within the heading area settable range, and an area associated with the field storing the value data can be set as the data area. 7. The data mapping apparatus according to claim 6, wherein the mapping is performed when it is within a range. The area type setting means includes means for receiving selection of one of the cells arranged in a matrix.
One of the four ranges of the sheet partitioned by the vertical axis and the horizontal axis based on the cell receiving the selection is set as a data area settable range, and the remaining range is set as a headline area settable range. The data mapping apparatus according to claim 7. Means for receiving an extension setting of the heading area;
When displaying the data read from the database, a row or a column is added to the matrix-like cell according to the data read from the field associated with the heading area for which the extended setting has been made, and the heading area The data mapping apparatus according to claim 6, wherein a data input / output form for expanding a data area is created. When the extended setting is made in the row heading area corresponding to the row of the data area, it is determined whether another heading area exists in the same row as the row heading area, and the column corresponding to the column of the data area Means for determining whether or not another heading area exists in the same column as the column heading area when the extension setting is made in the heading area;
Means for notifying an inconsistency in area settings in response to the determination that another heading area exists in the same row as the row heading area or in the same column as the column heading area;
The data mapping apparatus according to claim 9, further comprising: Means for determining whether or not the position of the heading area and the data area that have been extended by the setting reception means correspond to each other;
Means for notifying an inconsistency in area settings in response to a determination that the positions of the heading area and the data area do not correspond;
The data mapping apparatus according to claim 9, further comprising: A data mapping method for creating a data input / output device linking a data input / output form for inputting or displaying data and a database,
Displaying the data input / output form having a plurality of cells into which data can be entered or displayed;
Displaying a plurality of fields of the database;
A step of accepting designation of a data area of the data input / output form and the field corresponding to the data area, a heading area for displaying information relating to data of cells in the data area, and the field corresponding to the heading area When,
The data of the cells in the data area and the heading area are stored in the designated fields, respectively, and the data of the cells of the data area and the data of the cells of the heading area corresponding to the position of the cell are the same record Mapping to be stored in
A data mapping method comprising: A program for linking a data input / output form for inputting or displaying data and a database,
Displaying the data input / output form having a plurality of cells into which data can be entered or displayed;
Displaying a plurality of fields of the database;
A step of accepting designation of a data area of the data input / output form and the field corresponding to the data area, a heading area for displaying information relating to data of cells in the data area, and the field corresponding to the heading area When,
The data of the cells in the data area and the heading area are stored in the designated fields, respectively, and the data of the cells of the data area and the data of the cells of the heading area corresponding to the position of the cell are the same record Mapping to be stored in
A program that causes a computer to execute. A program for linking a data input / output form for inputting or displaying data and a database,
Displaying the data input / output form having a plurality of cells into which data can be entered or displayed;
Displaying a plurality of fields of the database;
Specification of the data area in which the cells are arranged in a matrix and the field corresponding to the data area, the heading area arranged in correspondence with the row or column of the data area, and the field corresponding to the heading area A step of accepting the designation;
The data of the cells in the data area and the header area are stored in the designated fields, respectively, and the data of the cells in the data area and the data of the cells in the header area corresponding to the row or column position of the cell Mapping so that and are stored in the same record;
A program that causes a computer to execute. Determining whether or not the heading area and the data area correspond to each other based on the designated number of cells in the heading area and the number of cells in the designated row or column of the data area; Let it run
15. The program according to claim 14, wherein the mapping step causes the computer to perform mapping in response to the determination that the heading area and the data area correspond to each other. The step of accepting the mapping, when mapping the area and the field, accepts selection of whether the area is an area for inputting data or an area for displaying data. The program according to 13 or 14. A program that links a data input / output form for inputting or displaying data with a database,
Displaying the data input / output form having a plurality of cells into which data can be entered or displayed;
Displaying a plurality of fields of the database;
Mapping the area of the data input / output form so that data of cells in the area is stored in the field in response to being dragged and dropped into any of the displayed fields;
A program that causes a computer to execute. A program that links a data input / output form for inputting or displaying data with a database,
Displaying a sheet having a plurality of cells into which data can be entered or displayed;
Displaying a plurality of fields of the database;
Receiving an area including at least one cell in the sheet, and designation of the field associated with the area;
Reading from the storage means data type information for identifying whether the data stored in each field is heading data or value data corresponding to the heading;
Based on the data type information of the field read from the storage means, the area associated with the field in which the header data is stored is defined as the header area, and the area associated with the field in which the value data is stored is the data. Mapping the data of the cells of the data area and the data of the cells of the heading area corresponding to the position of the cells to constitute the same record,
A program that causes a computer to execute. An area type setting step for setting a data area settable range in which the data area can be set in the sheet and a heading area settable range in which the heading area can be set;
In the mapping step, an area associated with a field storing the heading data is within the heading area settable range, and an area associated with the field storing the value data can be set as the data area. 19. The program according to claim 18, wherein the mapping is performed when it is within a range. Receiving a selection of one of the cells arranged in a matrix,
In the area type setting step, one of the four ranges of the sheet partitioned by the vertical axis and the horizontal axis with the cell receiving the selection as a reference is set as a data area setting range, and the remaining range is found. The program according to claim 19, wherein the area setting range is set. Causing the computer to execute a step of accepting the extension setting of the heading area;
When displaying the data read from the database, a row or a column is added to the matrix-like cell according to the data read from the field associated with the heading area for which the extended setting has been made, and the heading area 19. The program according to claim 18, wherein a data input / output form for expanding a data area is created. When the extended setting is made in the row heading area corresponding to the row of the data area, it is determined whether another heading area exists in the same row as the row heading area, and the column corresponding to the column of the data area Determining whether or not another heading area exists in the same column as the column heading area when the extension setting is made in the heading area;
Notifying inconsistencies in area settings in response to a determination that another heading area is present in the same row as the row heading area or in the same column as the column heading area;
The program according to claim 21, wherein the program is executed by a computer. Determining whether or not the position of the header area and the data area corresponding to the extended setting in the setting reception step correspond to each other;
Informing the area setting inconsistency in response to the determination that the positions of the heading area and the data area do not correspond;
The program according to claim 21, wherein the program is executed by a computer. The recording medium which recorded the program in any one of Claims 13-23.

Images