JP2002251306A - Device, method and program for inputting and outputting data - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily transfer database information of a different format with a small amount of workload. SOLUTION: A defining means 1B of a controlling part 1 defines fetch destination items of items to be fetched to output data and the arrangement sequence of each of the fetch destination items, and also sets a dummy item showing unnecessary fetch as the fetch destination item for items not to be fetched among respective items of input data to define fetch definition information, and a data fetching means 1A respectively fetches item data of input data corresponding to a fetch destination item concerned in each fetch destination item defined by the fetch definition information, outputs the time data as output data on the basis of the arrangement sequence of each fetch destination item and also attempts not to fetch an item in which a dummy item is set by the fetch definition information among respective items of the input data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data input / output device, and more particularly to a data input / output device for outputting externally input data of a predetermined database format as output data of a different database format.

[0002]

2. Description of the Related Art In a facility monitoring system for monitoring each facility in a building or factory, each facility is monitored by exchanging facility information of each facility using a communication network comprising a dedicated communication line. . On the other hand, in an information system in a building or a factory, database information such as personnel information, department information, and company-specific information is stored, processed, and managed by a host computer or the like. Between such independent systems, there is a case where it is necessary to exchange database information between different systems, for example, referring to database information of an information system by a monitoring system.

When exchanging database information between such different systems, the format (number of data items, item order or data structure) of the database information is often different. Needs to capture database information from the sender in a different format. For example, database information in a format used in the information system is converted into a text file in a CSV format or the like, and is transferred to the monitoring system side online via a communication network or offline using a storage medium. At this time, conventionally, the format of the database information is processed by the information system of the provider so that the database information is in a format suitable for the monitoring system.

[0004]

However, according to such a conventional method for exchanging database information, the database information is processed into a different format or manually input as necessary. In addition, every time individual information is exchanged, it is necessary for the operator to manually perform data processing or manually input data, which causes a problem that the working efficiency is poor and a heavy work load is imposed on the worker. It is also possible to create dedicated software to automate such data processing.However, since there is no versatility, it is necessary to develop dedicated software for each case where the database format differs between the sender and the receiver. However, considering its development man-hours, it lacks realism. An object of the present invention is to solve such a problem, and an object of the present invention is to provide a data input / output device capable of easily transferring database information of different formats with a small work load.

[0005]

In order to achieve the above object, a data input / output device according to the present invention comprises: a destination item of an item to be taken into output data, among items constituting input data; Definition means for defining the capture definition information indicating the arrangement order of each capture destination item in the output data, and, for each capture source item of the input data defined in the capture definition information, Data capturing means for capturing the data of the corresponding output data items, and outputting as output data based on the arrangement order of each capture destination item,
The definition means defines the import definition information by setting a dummy item indicating that the import is unnecessary as an entry destination of the items of the input data which are not imported into the output data, and defines the import definition information by the data import means. In the data definition items, items for which dummy items are set in the acquisition definition information are not imported.

[0006] As a specific configuration of skipping the capture using dummy items, the capture definition information includes a capture destination item name arranged according to the arrangement order of each item in the input data;
Each of the capture destination item names in the capture definition information is composed of a dummy item name inserted at a position corresponding to the arrangement order of the capture unnecessary items of the input data among the capture destination item names. Outputs the data captured from the corresponding input data item as output data according to the arrangement order of each capture destination item in the capture definition information, and if the capture destination item is a dummy item, The input data item at the position corresponding to the arrangement order of the dummy items in the import definition information may not be imported.

[0007] When defining the capture definition information, the definition means displays a list of preset captureable item names in a list display list on a display screen, and displays the list according to a predetermined item selection operation. The item names selected from the display list are sequentially added to the import list display list on the display screen as item names, and each import destination displayed in the import list display list in accordance with a predetermined save operation is displayed. The item names may be stored as capture definition information based on the display order.

Further, in the data input / output method according to the present invention, of the items constituting the input data, the destination items of the items to be taken into the output data and the arrangement order of the destination items in the output data are set. In addition, as a destination item of items that are not taken into the output data among the items of the input data, a dummy item indicating that the import is unnecessary is set and the import definition information is defined. For each destination item of the output data, the data of the input data item corresponding to the destination item is taken in, and output as output data based on the arrangement order of each destination item. Among the items, items for which dummy items are set in the import definition information are not imported.

[0009] As a specific method of skipping the capture using the dummy items, the capture definition information includes a capture destination item name arranged according to the arrangement order of each item in the input data, and a capture destination name. It consists of the item name and the dummy item name inserted at the position corresponding to the arrangement order of input data unnecessary items, and is taken from each input destination item of the import definition information and the corresponding input data item The output data is output as output data according to the arrangement order of each capture destination item in the capture definition information, and if the capture destination item is a dummy item, the placement of the dummy item in the capture definition information The input data at the position corresponding to the order may not be taken in.

[0010] When defining the import definition information, a list of preset importable item names is displayed in a list display list on the display screen, and selected from the list display list in accordance with a predetermined item selection operation. The acquired item names are sequentially added to the import list display list on the display screen as import item names, and each import item name displayed in the import list display list according to a predetermined save operation is displayed. You may make it save as acquisition definition information based on the display order.

[0011] A program according to the present invention sets a destination item of an item to be taken into output data among items constituting input data, and sets an arrangement order of each destination item in the output data. A step of setting a dummy item indicating that importing is not required as an importing destination item of an item that is not imported into the output data, and defining the importing definition information; and For each destination item, the data of the input data item corresponding to the destination item is imported, and output as output data based on the arrangement order of each destination item,
And a step of not taking in items for which dummy items are set in the take-in definition information among the items of the input data.

As a specific program for skipping capture using dummy items, the capture definition information includes the capture destination item names arranged according to the arrangement order of each item in the output data, and the capture destination items. A step consisting of a dummy item name inserted at the position corresponding to the arrangement order of the input data unnecessary items in the item name, and the input data items corresponding to each import destination item of the import definition information The captured data is output as output data according to the arrangement order of each capture destination item in the capture definition information. If the capture destination item is a dummy item, the dummy item in the capture definition information Of not taking in the input data item at the position corresponding to the arrangement order of the input data.

When defining the import definition information, the item names of preset importable items are displayed in a list on a list display list on the display screen, and selected from the list display list in accordance with a predetermined item selection operation. Item names are added to the import list display list on the display screen sequentially as import item names, and each import item name displayed in the import list display list according to a predetermined save operation is displayed. And storing as capture definition information based on the order.

[0014]

Next, embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram showing a system configuration in which a data input / output device according to one embodiment of the present invention is used. This system includes a monitoring system 10 that monitors each facility in a building or a factory, personnel information,
And an information system 20 for managing database information such as department information and company-specific information. The database information of the information system 20 and the database information of the monitoring system 10 are exchanged as necessary. You. The database information is usually
It is composed of a plurality of records (card data), and each record is composed of item data corresponding to a plurality of items. This embodiment is also based on database information having such a general configuration.

The equipment monitoring system 10 includes an equipment LAN.
A plurality of upper controllers 13 </ b> A to 13 </ b> N are connected via 19. Each upper controller 13A-13
Under the control of N, equipments 14A to 14 including a plurality of control devices 15 and a plurality of operation terminals 16 further connected thereunder.
N are respectively arranged. The central monitoring device 11 is L
Each of these higher-level controllers 13A to 13A-1
By performing data communication with 3N, the states of the facilities 14A to 14N under the respective upper controllers 13A to 13N are centrally monitored.

The central monitoring device 11 is connected to a data input / output device 12 for receiving input data input from an external information system 20 based on a format used by the central monitoring device 11. FIG. 2 shows a configuration example of the data input / output device 12. The data input / output device 12 is entirely composed of a computer, and includes a control unit 1, a data input / output unit 2, a storage unit 3, an operation input unit 4, and a display unit 5. The control unit 1 is configured by a microprocessor such as a CPU that controls each unit of the data input / output device 12, reads a program 3A stored in the storage unit 3 in advance, and activates the program. Various functions are realized by cooperation. The control unit 1 includes a data acquisition unit 1 as a unit for realizing various functions.
A and definition means 1B are provided.

The data input unit 2 includes a data input / output device 1
The data to be processed in step 2 is exchanged with the central monitoring device 11. Further, the definition unit 1B of the control unit 1 defines the capture definition information for capturing the input data into the output data, and stores it in the storage unit 3. The data acquisition means 1A defines the definition means 1B
Various types of information including the capture definition information defined in (1) are read from the storage unit 3, and based on the capture definition information, input data is captured and output according to the format of output data. The operation input unit 4 detects an operation of a worker and inputs the operation to the control unit 1. The display unit 5 displays the processing contents of the control unit 1 on a screen. The storage medium 3 is, specifically, a computer-readable storage medium such as a hard disk or a CD-ROM on which the program 3A or the like is recorded.

Next, the operation of this embodiment will be described with reference to FIG. FIGS. 3A and 3B are explanatory diagrams showing a fetching process operation of the data input / output device. FIG. 3A is a schematic diagram of a fetching process example, and FIG. 3B is a detailed diagram of a fetching process example. Hereinafter, a case where the database information held by the host computer 21 of the information system 20 is transferred to the central monitoring device 11 of the equipment monitoring system 10 will be described as an example. When the database information of the host computer 21, that is, the provider data is taken into the central monitoring device 11 as usage data and used, if the data format of the provider data and the usage data is different, the data input / output device 12 Use to change the data format.

When the data input / output device 12 captures input data (provider data in this case) as output data (utilization data in this case), information necessary for the capture process, here, item correspondence information and The capture definition information is created in advance. The item correspondence information is information that defines the correspondence between each item of input data and each item of output data. Import definition information is information that defines the necessity of import and the order of items in output data for each item of input data. For items that need to be imported, the import destination is determined based on the item correspondence information. Items are automatically determined and imported. Such item correspondence information and capture definition information are defined by the operator using the definition unit 1B of the control unit 1 and stored in the storage unit 3.

As shown in FIG. 3, input data 31 transferred from the central monitoring device 11 is received by the control unit 1 via the data input / output unit 2 and stored in the storage unit 3. Then, the data acquisition means 1A of the control unit 1 refers to the acquisition definition information 32A and the item correspondence information 32B, sequentially acquires the data according to the format of the output data 33, and stores it in the storage unit 3. In this example, the input data 31 is provided with items such as “employee number, department name, name, gender, address, date of birth, personal identification number,...” From the top. on the other hand,
The output data 33 is provided with items such as “card number, name, department name, gender, date of birth, personal identification number,...” From the top.

When the input data 31 and the output data 33 are compared, the item “address” of the input data 31
3, the order of the items “affiliation name” and “name” is interchanged. Also, the input data 31
The item “employee number” has been renamed to “card number” in the output data 33. Therefore, in the import definition information 32A, "dummy" indicating that reading is unnecessary is set for the item "address" of the input data 31, and the order of the items "affiliation" and "name" is set. In the item correspondence information 32B, the item “employee number” is associated with the “card number”.

The data fetching means 1A fetches the input data 31 according to the format of the output data 33 by using such fetch definition information 32A and item correspondence information 32B.
It is stored in the storage unit 3. When all the input data 31 has been fetched, the output data 33 is read from the storage unit 3 to the control unit 1 and transferred to the central monitoring device 11 via the data input / output unit 2. Thereby, the central monitoring device 11
Thus, the input data (provider data) 31 having the format on the information system 20 side can be used as the output data (use data) 33 conforming to the format on the facility monitoring system 10 side.

FIG. 4 shows the details of the fetching operation. The capture definition information 32A is composed of a plurality of capture destination items arranged in the order of the items of the output data 33. That is, the item order corresponds to the item order of the output data 33,
Numeric information indicating the output order of each item is omitted. Therefore, the "affiliation name" and the "name"
When the order of the items is changed, the input data 31
The third item “affiliation name” is set third in the import definition information 32A, and the third item “name” is set second in the input data 31 in the import definition information 32A.

For items that do not need to be fetched among the items of the output data 33, "dummy" items are inserted at corresponding positions in the order of the items. Therefore, when the items “address” and “hire date” of the input data 31 are not taken in, the input address 31 corresponding to the “address” located at the fifth position from the top in the input data 31 from the top of the take-in definition information 32A 5
A “dummy” item is set as the third item, and “dummy” is set as the tenth item from the top of the capture definition information 32A in correspondence with the “entering date” located tenth from the top in the input data 31. The item is set.

The item correspondence information 32B is composed of the item names of the output data 33 arranged corresponding to each item of the input data 31. Therefore, “card number” is set as an item of the output data 33 corresponding to the item “employee number” of the input data 31. In addition, input data 3
When the same item name is used for both 1 and the output data 33, such item correspondence information 32B can be omitted.

In the data fetching means 1A of the control section 1, when fetching one record from the input data 31, for each fetch destination item of the fetch definition information 32A, the data of the input data 31 corresponding to the fetch destination item is read. Get the actual item data from the item. At this time, the item correspondence information 32B is referred to, and the source item of the input data 31 corresponding to the destination item is selected. And "dummy" as the capture destination item
If the setting is made, the fetching of the fetching source item of the input data 31 corresponding to the item position of the fetching destination item is skipped. Then, at the point in time when the capture of each capture destination item has been completed, the item data is stored in the output data 33 as one record.

The capture definition information is defined by the definition means 1B using a screen as shown in FIG. Definition means 1B
Displays a capture item selection screen shown in FIG. 5 on the display unit 5 in response to a capture start instruction from a worker via the operation input unit 4. On the capture item selection screen, an item list 41 is provided on the left side, and a list of captureable item names used in the facility monitoring system 10 is displayed. In addition, a capture item list 42 is provided on the right side of the screen.
A list of capture destination item names to be captured as output data 33 is displayed. A “selection button” 43 is provided between the item list 41 and the import item list 42.
An “execute button” 44 is arranged at the lower left of the screen.

FIG. 6 shows a flowchart of the capture item selection processing. The definition means 1B first reads the retrievable item data from the storage unit 3 (step 100), and displays a list on the item list 41 of the retrieval item selection screen (step 101). The fetchable item data is data indicating items that can be fetched by the data input / output device 12, and is stored in the storage unit 3 in advance. Then, the process proceeds to an operation waiting loop (steps 102 and 104) for the worker. In this operation waiting loop, when an item selection operation by the “select button” 43 is detected in the operation input unit 4 (Step 102: YES), the item name selected in the item list 41 is taken as the destination item. One of them is additionally displayed in the fetched item list 42 (step 103), and the process returns to the operation waiting loop.

In this way, the fetch destination items are sequentially selected from the item list 41 in accordance with the order of the items of the output data 33, and are listed in the fetched item list 42.
In addition, “dummy” items are provided in advance in the importable item data, and when there is an item that does not need to be imported in the input data 31, a position corresponding to the item order in the imported item list 42. Then, the "dummy" item may be selected.
Then, in the operation waiting loop, when an execution operation by the “execution button” 44 is detected in the operation input unit 4 (Step 104: YES), the items in the acquisition item list 42 are arranged in the display order. Storage unit 3 as embedded definition information
(Step 105), and the series of processing ends.

Thereafter, the processing shifts to the data fetching means 1A, and after the file selection processing of the input data 31 is performed, the fetching processing described with reference to FIG. 4 is started. Thereby, the item order in the output data and the unnecessary items in the input data can be changed by an extremely easy operation of operating the selection button according to the item order in the output data 33.
It can be defined as import definition information.

As described above, in the present embodiment, the control unit 1
Definition means 1B defines the fetch destination items of the items to be captured in the output data and the arrangement order of the respective capture destination items. Is set to define the capture definition information, and for each capture destination item defined by the capture definition information, the data capture means 1A sets the input data corresponding to the capture destination item. Each item data is fetched and output as output data based on the arrangement order of each fetched destination item, and among the items of the input data, items for which dummy items are set in the fetch definition information are not fetched This eliminates the need for workers to manually process data and manually input data each time individual database information is exchanged, It can correspond to the format of different database information in a very simple operation of defining. Therefore, database information having different formats can be easily transferred with a small work load.

In the above, the database information used by the host computer 21 of the information system 20 is used by the central monitoring device 11 of the equipment monitoring system 10, and the data input / output device 12 connected to the central monitoring device 11 is used.
Although the description has been given of an example in which processing is performed in the above, the present invention is not limited to this, and can be applied to delivery in the reverse direction. That is, the database information used by the central monitoring device 11 can be processed by the data input / output device 12 to be used by another system such as the host computer 21.

In this case, as shown in FIG. 7, the data input / output device 12 receives the usage data used by the central monitoring device 11 as input data 34, and the destination data to be passed to the host computer 21 is the output data. 36 is output. Then, according to the format of the input data 34 and the format of the output data 36, the capture definition information 35A and the item correspondence information 35B are defined. In this example,
In the input data 34, items such as "card number, name, department name, gender, date of birth, personal identification number, ..." are provided from the top. On the other hand, in the output data 36, items such as "card number, name, department name, password, birth date, ..." are provided from the top.

When the input data 34 and the output data 36 are compared, the item “sex” of the input data 34
6, the order of the items “birth date” and “password (password)” is interchanged. Also,
The item “PIN” in the input data 34 corresponds to “Password” in the output data 36. Therefore, in the import definition information 35A, “dummy” that is not read for the item “sex” of the input data 34 is set,
The order of the items "Date of birth" and "Password" is set. In addition, item correspondence information 35B
In, the item “PIN” is used as data of “Password”.

The data fetching means 1A fetches the input data 34 in accordance with the format of the output data 36 by using the fetch definition information 35A and the item correspondence information 35B.
It is stored in the storage unit 3. At the point in time when all the input data 34 has been fetched, the output data 36 is read from the storage unit 3 to the control unit 1 and transferred to the central monitoring device 11 via the data input / output unit 2. Thereby, the central monitoring device 11
Then, the input data (use data) 34 conforming to the format of the facility monitoring system 10 can be transferred to the host computer 21 as output data (providing destination data) 36 having the format of the information system 20.

FIG. 8 shows the details of the fetching operation. The capture definition information 35A is composed of a plurality of capture destination items arranged in the order of the items of the output data 36. That is, the item order corresponds to the item order of the output data 36,
Numeric information indicating the output order of each item is omitted. Accordingly, when the order of the items “birth date” and “password (password)” in the input data 34 is exchanged, the fifth item “birth date” in the input data 34 is the sixth item in the import definition information 35A. Set and input data 3
In the fourth item, the sixth item “PIN” is the import definition information 35A.
Is set to the fifth.

If no capture is required, no data output definition is performed, and if a blank item is to be entered, "dummy" is set. Therefore, the item “sex” of the input data 34
Is not taken in, in order to insert an empty item corresponding to the “gender” located fourth from the beginning in the input data 34, “dummy” is set as the fourth item from the beginning of the import definition information 35A. Is set. The item correspondence information 35B includes the item names of the output data 36 arranged corresponding to the respective items of the input data 34. Therefore, the item “password” of the input data 34 corresponds to the item “password” of the output data 36. The input data 34
In the case where the same item name is used for both the and the output data 36, such item correspondence information 35B can be omitted.

In the data fetching means 1A of the control section 1, when fetching one record from the input data 34, for each fetch destination item of the fetch definition information 35A, the data of the input data 34 corresponding to the fetch destination item is read. Get the actual item data from the item. At this time, the item correspondence information 35B is referred to, and the source item of the input data 34 corresponding to the destination item is selected. And "dummy" as the capture destination item
If set, empty data is output for the source item of the input data 34 corresponding to the item position of the destination item. Then, at the time when the capture of each capture destination item is completed, the item data is stored in the output data 36 as one record.

The capture definition information is defined by the definition means 1B using a screen as shown in FIG. Definition means 1B
Displays an output item selection screen shown in FIG. 9 on the display unit 5 in response to a capture start instruction from the operator via the operation input unit 4. In the output item selection screen, an item list 51 is provided on the left side, and each outputable item name used in the facility monitoring system 10 is displayed in a list. An output item list 52 is provided on the right side of the screen.
A list of capture destination item names to be captured as output data 36 is displayed. A “selection button” 53 is provided between the item list 51 and the output list 52.
An “execute button” 54 is arranged at the lower left of the screen.

The output item selection processing is the same as the above-described fetched item selection processing of FIG. 6, although there are differences in screens and list names. Therefore, although detailed description is omitted here, the output data 36
In accordance with the item order, the import destination item is set to the item list 51.
, The output item list 52
Listed in In addition, “dummy” items are provided in advance in the importable item data, and when an empty item is set in the input data 34, the import item list 5
The "dummy" item may be selected at a position corresponding to the item order among the items 2. Thus, the item order in the output data and the unnecessary items in the input data can be defined as the import definition information by the extremely easy operation of operating the selection button in accordance with the item order in the output data 36. it can.

[0041]

As described above, according to the present invention, the definition means defines the capture destination items of the items to be captured in the output data and the arrangement order of the capture destination items. As the destination field for the fields that are not imported,
Define the import definition information by setting a dummy item indicating that import is unnecessary, and use the data import means for each import destination item defined in the import definition information and output corresponding to the import source item Data of each data item is fetched and output as output data based on the arrangement order of each fetched destination item, and fetching of items of input data for which dummy items are set in the fetch definition information Since it is not performed, it is not necessary for workers to manually process data or manually input data every time each database information is exchanged, and it is an extremely simple operation to define capture definition information Can handle database information of different formats. Therefore, database information having different formats can be easily transferred with a small work load.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a system configuration in which a data input / output device according to an embodiment of the present invention is used.

FIG. 2 is a configuration example showing a data input / output device.

FIG. 3 is an explanatory diagram showing a fetch processing operation of the data input / output device.

FIG. 4 is an explanatory diagram showing details of an import processing operation.

FIG. 5 is a display example of a capture item selection screen.

FIG. 6 is a flowchart showing a capture item selection process.

FIG. 7 is an explanatory diagram showing another fetch processing operation of the data input / output device.

FIG. 8 is an explanatory diagram showing details of another capture processing operation.

FIG. 9 is a display example of another capture item selection screen.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Control part, 1A ... Data taking-in means, 1B ... Defining means,
2 data input / output unit, 3 storage unit, 3A program
4 operation input unit, 5 display unit, 10 equipment monitoring system, 11 central monitoring device, 12 data input / output device, 1
3A to 13N: host controller, 14A to 14N: equipment, 15: control device, 16: operation terminal, 19: equipment system LA
N, 20: information system, 21: host computer,
29 ... information LAN, 31, 34 input data, 32A,
35A import definition information, 32B, 35B item correspondence information, 3
3,36 output data.

Claims (9)

[Claims] 1. A data input / output device for outputting input data in a database format composed of a plurality of items arranged in a predetermined order as output data in a different database format, wherein: Definition means for defining a capture destination item of an item to be captured in the output data, and capture definition information indicating an arrangement order of each capture destination item in the output data, and the definition defined in the capture definition information For each source item of input data, data of the item of the output data corresponding to the source item is read, and the data is output as the output data based on the arrangement order of the destination items. Means, wherein the definition means indicates, as an entry destination of an item which is not taken into the output data among the items of the input data, a data indicating that the entry is unnecessary. A me item is set to define the capture definition information, and the data capture unit does not capture, among the items of the input data, an item for which a dummy item is set in the capture definition information. A data input / output device characterized by the above-mentioned. 2. The data input / output device according to claim 1, wherein the fetch definition information includes fetch destination item names arranged according to an arrangement order of each item in the input data, and these fetch destination items. And a dummy item name inserted at a position corresponding to the arrangement order of the unnecessary items of the input data in the input data, wherein the data capturing means corresponds to each capturing destination item of the capture definition information. The data fetched from the input data item is output as output data in accordance with the arrangement order of each fetch destination item in the fetch definition information. If the fetch destination item is a dummy item, the data is output. A data input / output device that does not take in the input data at a position corresponding to the arrangement order of the dummy items in the input definition information. 3. The data input / output device according to claim 2, wherein, when defining the capture definition information, the definition unit sets a preset item name of a captureable item to a list display list on a display screen. List display, the item name selected from the list display list according to a predetermined item selection operation is sequentially added and displayed as the capture destination item name in the capture list display list of the display screen, the predetermined save operation The data input / output device according to claim 1, wherein each of the capture destination item names displayed in the capture list display list is stored as the capture definition information based on the display order. 4. A data input / output method for outputting input data in a database format composed of a plurality of items arranged in a predetermined order as output data in a different database format, the data input / output method comprising: Setting the fetch destination items of the items to be captured in the output data and the arrangement order of the respective capture destination items in the output data, and capturing the items of the input data that are not captured in the output data. As a destination item, a dummy item indicating that capture is unnecessary is set to define the capture definition information. For each capture destination item of the output data defined in the capture definition information, the capture destination item is And the data of the items of the input data corresponding to the input data are output, and output as the output data based on the arrangement order of the input destination items. Data input and output method characterized in that the items which the dummy entry in the capture definition information of each item of data is set not to perform the capture. 5. The data input / output method according to claim 4, wherein the fetch definition information includes fetch destination item names arranged according to an arrangement order of each item in the input data, and these fetch destination items. And the dummy item name inserted at a position corresponding to the arrangement order of the unnecessary items of the input data in the input data. The captured data is output as output data in accordance with the arrangement order of each capture destination item in the capture definition information. If the capture destination item is a dummy item, the dummy data in the capture definition information is output. A data input / output method, wherein the input data at a position corresponding to the arrangement order of the items is not taken in from the items. 6. The data input / output method according to claim 5, wherein when defining the capture definition information, a list of preset captureable item names is displayed in a list display list on a display screen, and The item name selected from the list display list according to the item selection operation is sequentially added to the import list display list on the display screen as the import item name, and the import is performed according to a predetermined save operation. A data input / output method, wherein each import destination item name displayed in the list display list is stored as the import definition information based on the display order. 7. A program for causing a computer to execute processing for outputting input data in a database format composed of a plurality of items arranged in a predetermined order as output data in a different database format. Among the constituent items, the setting of the fetch destination item of the item to be fetched into the output data and the arrangement order of each fetch destination item in the output data are performed. Setting a dummy item indicating that import is unnecessary as an import destination item of an item which is not to be imported, and defining the import definition information; and each import destination item of the output data defined by the import definition information. In each case, the data of the item of the input data corresponding to the destination item is fetched, and based on the arrangement order of the destination items. Program for executing and outputs as the output data, and a step of not performing the uptake for the items dummy items in the take-definition information of the items of the input data is set. 8. The program according to claim 7, wherein the fetch definition information includes a fetch destination item name arranged in accordance with an arrangement order of each item in the output data, and a fetch destination item name among the fetch destination item names. A step consisting of a dummy item name inserted at a position corresponding to the arrangement order of the unnecessary items of the input data; and taking in the input data items corresponding to the respective take-in destination items of the take-in definition information. The output data is output as output data according to the arrangement order of each capture destination item in the capture definition information. If the capture destination item is a dummy item, the dummy item in the capture definition information is output. Not taking in the input data item at a position corresponding to the arrangement order of the input data. 9. The program according to claim 8, wherein when defining the import definition information, a list of preset item names of the importable items is displayed in a list on a display screen, and a predetermined item is selected. An item name selected from the list display list according to an operation is sequentially added to the import list display list on the display screen as the import destination item name, and the import list display list is displayed according to a predetermined save operation. And storing the name of each capture destination item displayed in the table as the capture definition information based on the display order.