JP2009169882A - Data management device, data management method, and data management program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data management device, data management method and data management program capable of simply performing conversion to a predetermined format. <P>SOLUTION: A data display device is a data management device for converting time series history data into a file of a predetermined format and managing the file and includes a displaying part 13 for displaying the time series history data in a tabular format, an inputting part 12 capable of designating a direction of arrangement of the time series history data, start date and time, tick time, and a start cell position, a conversion pattern storing part 22 for storing a conversion pattern in which an item designated by the inputting part 12 is defined, and a processing part 11 for converting the time series history data into a file of the predetermined format. A direction of arrangement, start date and time and a start cell position can be designated while the time series history data is displayed. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a data management apparatus, a data management method, and a data management program that convert and manage time-series history data into a file of a prescribed format.

  In recent years, the state of equipment is displayed on a display device as a monitoring application for equipment such as plants and buildings. For example, data measured by equipment such as a thermometer, an air flow meter, and a hygrometer is displayed on the display screen. Specifically, an icon indicating equipment and measurement data measured by the equipment are displayed on a plan view on which the layout of the building is displayed.

  In the above apparatus, by storing the measurement data in time series, it is possible to check the state of the facility at a past time point. However, since many different types of equipment are installed in the facility, the file format of the measurement data is diverse. That is, each facility device generates measurement data for a certain period as a time-series history data file. Then, a time-series history data file is transferred from each equipment device to the equipment management device provided with the above display device. At this time, if the equipment is different, the format of the time-series history data is usually different. For example, a thermometer and an air flow meter differ in the data arrangement direction, the data acquisition step time, and the like. Therefore, it is necessary to unify time series history data from different equipment in a prescribed format.

  Japanese Patent Application Laid-Open No. 2004-228561 discloses a method for importing spreadsheet software data into a database. In this document, a conversion table is used for importing into a database. However, the method of Patent Document 2 is general-purpose because data is extracted from a file such as management information, and the process of creating various conversion tables becomes complicated. Therefore, the burden of conversion work becomes large and the work becomes complicated.

JP 2005-284754 A

  As described above, the conventional method has a problem that the process of converting the time series history data file of a different format into a prescribed format becomes complicated.

  The present invention has been made to solve such problems, and an object thereof is to provide a data management device, a data management method, and a data management program that can be easily converted into a specified format. To do.

  A data management apparatus according to a first aspect of the present invention is a data management apparatus that converts and manages time-series history data into a file of a prescribed format, and displays the time-series history data in a table format An input unit for specifying the direction of arrangement of the time-series history data in the tabular format, the start date and time, the ticking time, and the start cell position, and a conversion pattern in which the item specified by the input unit is defined. A conversion pattern storage unit for storing, and a processing unit for referring to the item defined by the conversion pattern and converting the time-series history data into the file of the default format, wherein the input unit is the tabular format In the state where the time series history data is displayed, the direction of the array, the start date and time, and the start cell position can be designated. Thereby, it is possible to specify while confirming the time series history data. Therefore, conversion to the specified format can be performed easily.

  A data management device according to a second aspect of the present invention is a data management device that converts time series history data into a file of a prescribed format and manages the data, and displays the time series history data file in a table format. And in the state where the time-series history data in the table format is displayed, an input unit that can specify a cell range of the time-series history data and a cell range of date and time, and an item specified by the input unit A conversion pattern storage unit that stores a defined conversion pattern; and a processing unit that converts the time-series history data into a file of the default format with reference to an item defined by the conversion pattern. . Thereby, it is possible to specify while confirming the time series history data. Therefore, conversion to the specified format can be performed easily.

  A data management apparatus according to a third aspect of the present invention is the data management apparatus described above, and creates a conversion pattern including correction contents when the file of the specified format converted by the processing unit is corrected. Is. As a result, the file in the specified format can be easily corrected.

  A data management apparatus according to a fourth aspect of the present invention is the data management apparatus described above, wherein the time-series history data file is a file in a form format relating to air conditioning control of building facilities or power usage. It is a feature. It is possible to easily confirm whether appropriate control is performed in the facility.

  A data management method according to a fifth aspect of the present invention is a data management method for converting and managing time-series history data into a file of a prescribed format, the step of displaying the time-series history data file in a table format And a step of designating an array direction of the time-series history data in the tabular format, a start date and time, a step time, and a start cell position, and a conversion pattern in which an item designated in the designating step is defined. And a step of referring to an item defined by the conversion pattern and converting the time-series history data into a file of the default format, wherein the specifying step includes: In the state where the history data is displayed, the direction of the array, the start date and time, and the start cell position are designated. Thereby, it is possible to specify while confirming the time series history data. Therefore, conversion to the specified format can be performed easily.

  A data management method according to a sixth aspect of the present invention is a data management method for converting and managing time-series history data into a file of a prescribed format, the step of displaying the time-series history data file in a table format In the state where the time-series history data in the table format is displayed, the step of designating the cell range of the time-series history data and the cell range of the date and time, and the item designated in the designating step are defined Storing a conversion pattern, and referring to an item defined by the conversion pattern, and converting the time-series history data into a file of the default format. Thereby, it is possible to specify while confirming the time series history data. Therefore, conversion to the specified format can be performed easily.

  A data management method according to a seventh aspect of the present invention is the data management method described above, and creates a conversion pattern including correction contents when a file of the specified format is corrected. As a result, the file in the specified format can be easily corrected.

  A data management method according to an eighth aspect of the present invention is the data management method described above, wherein the time-series history data file is a file in a form related to air conditioning control of building facilities or power usage. It is a feature. It is possible to easily confirm whether appropriate control is performed in the facility.

  A data management program according to a ninth aspect of the present invention is a data conversion program for converting and managing a time series history data file into a file of a prescribed format, and displaying the time series history data to a computer. A step of displaying in a format; a step of displaying an input area for designating an array direction of the time-series history data in the tabular format, a start date and time, a step time, and a start cell position; and Storing a conversion pattern in which a designated item is defined, and referring to the item defined by the conversion pattern, and converting the time-series history data into a file of the default format, In the state where the tabular time-series history data is displayed, the direction of the array, the start date and time, and the opening In which input area for designating the cell positions are displayed. Thereby, it is possible to specify while confirming the time series history data. Therefore, conversion to the specified format can be performed easily.

  A data management program according to a tenth aspect of the present invention is a data management program that converts and manages time-series history data into a file of a prescribed format, and displays the time-series history data file for a computer. A step of displaying in a format, and a step of displaying an input area for designating a cell range of time series history data and a cell range of date and time in a state where the time series history data in the table format is displayed, Storing a conversion pattern in which an item specified by the specified area is defined; referring to an item defined by the conversion pattern; and converting the time-series history data into a file of the default format; Is provided. Thereby, it is possible to specify while confirming the time series history data. Therefore, conversion to the specified format can be performed easily.

  A data management program according to an eleventh aspect of the present invention is the data management program described above, and creates a conversion pattern including correction contents when a file of the specified format is corrected. As a result, the file in the specified format can be easily corrected.

  A data management program according to a twelfth aspect of the present invention is the data management program described above, wherein the time-series history data file is a file in a form format relating to air conditioning control of building equipment or power usage. It is a feature. It is possible to easily confirm whether appropriate control is performed in the facility.

  According to the present invention, it is possible to provide a data display device, a data display method, and a data display program that can be easily converted into a prescribed format.

  The data management apparatus according to the present embodiment is a data management apparatus that converts time series history data into a file of a prescribed format and manages it. Specifically, for the data management device computer, the step of displaying the time series history data in a table format, the direction of the arrangement of the time series history data in the table format, the start date and time, the step time, and the start Displaying an input area for designating a cell position, storing a conversion pattern in which an item designated in the designated area is defined, referring to an item defined by the conversion pattern, and A step of converting time-series history data into a file of the default format. An input area for designating the direction of the array, the start date and time, and the start cell position is displayed in the state where the time-series history data in the tabular format is displayed.

  Hereinafter, specific embodiments to which the present invention is applied will be described in detail with reference to the drawings. FIG. 1 is a diagram schematically illustrating the overall configuration of the equipment monitoring system.

  The equipment monitoring system monitors equipment in a building equipment such as a building, for example. In the facility monitoring system, for example, a plurality of facility devices 2 are provided. The equipment 2 is arranged at a predetermined position in the building. Examples of the equipment 2 include an air conditioner, a heater, a humidifier, an air flow meter, a thermometer, a calorimeter, a wattmeter, and a valve. The equipment 2 monitors the temperature, air volume, humidity, heat consumption, power consumption, etc. in the building facilities. That is, the equipment 2 measures the temperature, air volume, humidity, heat consumption, power consumption, etc. at each point in the building. The equipment 2 acquires these measurement data at predetermined time intervals. For example, measurement data can be acquired every minute. Thus, the time change of measurement data is acquired in each equipment 2. In addition, since a plurality of facility devices 2 are installed, a plurality of measurement points are provided in the facility.

  Then, the measurement data measured by the equipment device 2 is transferred to the equipment management device 1. And the equipment management apparatus 1 memorize | stores the transferred measurement data. Here, the equipment device 2 and the equipment management device 1 may be connected via a network, and the measurement data from the equipment device 2 may be transmitted. For example, the measurement data is accumulated in the equipment device 2 for a certain period, and the accumulated measurement data is collected and transmitted. In this case, a data file including measurement data for a certain period is transferred to the facility management apparatus 1. Further, the measurement data may be stored in a storage medium such as an external memory or a storage disk, and the facility management apparatus 1 may read the measurement data of the storage medium. In this case, the facility equipment 2 and the facility management apparatus 1 may not be connected via a network. Of course, the measurement data may be transferred to the facility management apparatus 1 by combining them. From the equipment 2, a file in a form format relating to air conditioning control of building equipment or power use is transferred.

  Next, the configuration of the facility management apparatus 1 will be described. The equipment management device 1 is an arithmetic processing device such as a personal computer, for example, and displays a summary graph for equipment monitoring. That is, the facility management device 1 is a data display device for displaying measurement data. Specifically, the facility management apparatus 1 includes a processing unit 11, an input unit 12, a display unit 13, and a storage unit 20.

  The processing unit 11 includes a CPU, an MPU, and the like, and performs various arithmetic processes. The input unit 12 has input means such as a mouse and a keyboard. Various data are input by the user operating the input unit 12. The display unit 13 has a display device such as a CRT or a liquid crystal display. The display unit 13 displays the processing result and the like on the window of the display screen. The display unit 13 displays a summary graph for performing facility management. The storage unit 20 includes internal or external storage means such as a ROM (Read Only Memory), a RAM (Random Access Memory), and a hard disk. In addition, an operating system, an information processing program, and a number of application programs according to the present embodiment are installed on the hard disk. Further, the storage unit stores a data display program for displaying data in the summary graph as will be described later. Based on the information input by the input unit 12, the processing unit 11 performs processing and causes the display unit 13 to display the result. Alternatively, the processing result can be stored in the storage unit 20. For example, measurement data at the date and time designated by the user is displayed on a window such as a summary graph.

  Here, various types of equipment 2 are installed in the equipment. When the types of equipment are different, the format of the data file transferred to the equipment management apparatus 1 is different. For example, the direction in which the time series history data is arranged may be the vertical direction or the horizontal direction. In addition, the time-series history data has different ticks and date and time formats are different.

  The equipment management apparatus 1 converts the measurement data stored along the time series into data of a prescribed format and stores it. That is, the facility management apparatus 1 unifies the time-series history data file into a prescribed format. Then, a file in a prescribed format is stored as a database. The facility management apparatus 1 stores a conversion program for converting a time-series history data file into a specified format. Furthermore, the facility management apparatus 1 stores a program for generating a conversion pattern for conversion to a specified format. By converting the file into a standard format file, the summary graph can be displayed easily.

  Next, a configuration for performing data conversion processing will be described. The storage unit 20 includes a time-series history data storage unit 21, a conversion pattern storage unit 22, and a table data storage unit 23. Each storage unit may be physically provided in the same storage device.

  The time series history data storage unit 21 stores time series history data from the equipment 2. More specifically, the time series history data storage unit 21 stores a data file including time series history data. The time series history data includes historical measurement data. The data file of the time series history data includes measurement data of one or more measurement points. Further, the data file from the facility device 2 may be added with a point address, a point name, a measurement unit, a measurement date and time, a measurement time, etc. for identifying the measurement point. Such a data file is transferred for each equipment device 2. Therefore, the time-series history data storage unit 21 stores data files in different format formats depending on the type of the equipment device 2.

  The conversion pattern storage unit 22 stores a conversion pattern for converting the time series history data stored in the time series history data storage unit 21 into a prescribed format. That is, by reading this conversion pattern, the time series history data is converted into a table data file in a prescribed format. This conversion pattern is set for each type of equipment 2. That is, different conversion patterns are registered for data files of different formats.

  The table data storage unit 23 stores the table data converted into a prescribed format using the conversion pattern. Therefore, the format of the table data file stored in the table data storage unit 23 is unified. The processing unit 11 refers to the unified table data and displays a summary graph or the like.

  Next, creation of a conversion pattern will be described with reference to FIGS. 2 to 6 show windows displayed on the display unit 13 in order to create a conversion pattern. Here, creation of a conversion pattern proceeds with a data conversion pattern creation wizard. 2 to 6 are views showing windows of the data conversion pattern creation wizard. That is, the wizard screen for creating the conversion pattern proceeds in order from FIG. 2 to FIG. Note that the input and designation of each setting in the following description is performed by the input unit 12 having a mouse, a keyboard, and the like. For example, a file name or the like can be input using a keyboard, and each item can be checked using a mouse.

  In each window, clicking the “Next” button advances to the next window, and clicking the “Back” button returns to the previous window. Clicking the “Cancel” button cancels the creation of the conversion pattern.

  When creating a conversion pattern for time-series history data from a certain type of equipment 2, a conversion pattern creation program stored in the equipment management apparatus 1 is executed. Then, the conversion pattern creation program starts up and the window shown in FIG. 2 is displayed. FIG. 2 shows a first window 30 for creating a conversion pattern. In the first window 30, a pattern name input area 31, a file format input area 32, a file type input area 33, a delimiter input area 34, a quote input area 35, and a sample file input area 36 are displayed.

  In the pattern name input area 31, the name of the conversion pattern to be created is input. For example, the user inputs an appropriate name using the keyboard of the input unit 12 or the like. Of course, it is preferable to register pattern names so as not to overlap with other conversion patterns. In the file format input area 32, the file area of the data file of the time series history data is input. Here, you can specify whether the file format is an Excel file or a text file. Of course, other file formats may be specified.

  In the file type input area 33, the file type is input. Here, it can be specified whether the data file of the time series history data is a daily report, a monthly report, a hourly report, or a 30 minute report. For example, in the case of daily reports, measurement data for 24 hours is included in the data file, and in the case of hourly reports, measurement data for one hour is included. Furthermore, in the file type input area 33, the time interval of the time series history data can be specified. For example, in the hourly report, measurement data is measured every minute, and in the daily report, measurement data is measured every hour. Therefore, when the file type is input, it is possible to specify the increment time of the measurement data. As described above, the time interval of the time-series history data differs depending on the designated file type. Of course, the step time may be directly input.

  Next, a delimiter character is input into the delimiter input area 34. Here, the character which divides each measurement data etc. is designated. For example, in the data file of time series history data, it is specified whether the character that separates the measurement data is a comma, a tab, a semicolon, or the like. As will be described later, values delimited by delimiters are arranged in different cells when displaying time-series history data in a tabular format.

  A quotation mark is input in the quotation mark input area 35. That is, the quotation mark which quotes the character string is specified in the time series history data. For example, when double quotation is specified, the part surrounded by double quotation is recognized as a character string. In the sample file input area 36, a sample file name is input. That is, in the sample file input area 36, a sample file name to be opened as a sample file is selected. The sample file with the name input here is displayed in a third window 50 and a fourth window 60 described later. When the above input is made, the next button in the first window 30 is clicked to advance to the next window.

  Then, the second window 40 shown in FIG. 3 is displayed. In the second window 40, a point address automatic addition setting area 41, an additional header input area 42, and a digit number input area 43 are displayed. In the point address automatic addition setting area 41, it is set whether or not the point address is automatically added. When automatic addition is performed, a point address is automatically added. For example, a value obtained by adding 1 to the largest numerical value at a point address having the same header is automatically added. In the additional header input area 42, a header to be added to the point address is input. When automatic addition is performed, numbers after the header are automatically assigned so that the point addresses of the respective measurement points are different. In the digit number input area 43, the total number of digits of the point address is input. Here, enter the total number of digits including the header.

  When the above input is completed, the “next” button in the second window 40 is clicked to proceed to the next window. Then, the third window 50 shown in FIG. 4 is displayed. In the third window 50, a sample data display area 51 and an input area 52 are displayed. In FIG. 4, a sample data display area 51 is arranged on the left side in the third window 50, and an input area 52 is arranged on the right side. Further, the input area 52 includes a time series direction input area 53, a date data storage location designation area 54, a date cell designation area 55, a date format designation area 56, a time data storage location designation area 57, a time cell instruction area 58, a time A format designation area 59 is displayed.

  The sample data display area 51 displays sample data of a sample file in a table format. That is, a part of the sample file having the name specified in the first window 30 is displayed. FIG. 4 shows a table having 5 × 23 cells in the sample data display area 51. Therefore, as shown in FIG. 4, columns A to E and 1 to 23 rows are displayed. In each cell in the sample data display area 51, for example, measurement data, measured date, time, data unit, and the like are displayed. That is, each measurement data included in the data file of the time series history data is displayed in a state where it is separated by the delimiter specified in the delimiter input area 34 and arranged in different cells. Further, a scroll bar or the like may be provided so that all data of the sample file can be browsed.

As shown in FIG. 4, in the table of the sample data display area 51, the measured date is shown in the cell in the first row of the A column (hereinafter abbreviated as A1 cell, and similarly for other cells). Yes.
Further, temperature and humidity measurement data are arranged in the vertical direction. Specifically, temperature measurement data is arranged in cells B4 to B23, and humidity measurement data is arranged in cells C4 to C23. Furthermore, the unit of temperature and the unit of humidity are shown in B3 cell and C3 cell, respectively. The measurement times are arranged in the A4 cell to A23 cell. Further, various data are also arranged in the 24th and subsequent columns (not shown).

  Here, the following input is performed while browsing the sample file. That is, various settings can be input while a part of the time-series history data of the sample file is displayed. In this way, the user can make settings while confirming the actual data file, so that the settings can be made easily. Therefore, it can input simply and can improve the convenience. The work burden on the user can be reduced. Furthermore, since the sample data display area 51 and the input area 52 are displayed in the same window, the sample data can be easily confirmed.

  First, input in the time series direction is performed in the time series direction input area 53. Here, since the time series is the vertical direction, the vertical column is checked. That is, in the table, since the temperature measurement data are arranged in the vertical direction, the time series direction is designated as the vertical direction. In the date data storage location designation area 54, the storage location of date data is designated. Here, since the date is shown in the A1 cell, the data in the file is checked. Of course, when the date is shown in the file name, the file name column is checked, and when the date is shown in the folder, the folder column is checked. Thereby, the measured date can be designated.

  When in-file data is designated in the date data storage location designation area 54, a date cell is designated in the date cell designation area 55. Here, the A1 cell in which the measured date is stored is designated. In the date format designation area 56, the date format is designated. Here, yyyy / mm / dd is designated with reference to the date displayed in the A1 cell. When the date is arranged across a plurality of cells, the cell range in which the date is arranged is designated.

  In the time data storage location designation area 57, the time data storage location is designated. Here, since the measured time is arranged in the A column, the in-file data is designated. If the time is included in the file name, specify the file name. If the time is not included, the relative position is designated. That is, the measured time can be specified from the relative position with respect to the cell position of the head measurement data and the step time. In the time data storage location designation area 57, a time cell is designated. Here, A4 cell to A28 cell in which the time of 1:00 to 24:00 is stored is designated. In the time format designation area 59, a time format is designated. Check the time displayed on the A4 cell and specify HH / mm. In this way, the measurement start date and time is specified.

  When the above input is completed, the “next” button in the third window 50 is clicked to proceed to the next window. Then, the fourth window 60 shown in FIG. 5 is displayed. In the fourth window 60, a data display area 61 and an input area 62 are displayed. In FIG. 4, a data display area 61 is arranged on the left side in the fourth window 60, and an input area 62 is arranged on the right side. Further, the input area 62 includes a matrix number input area 63, a point address cell designation area 64, a point name designation area 65, a data type cell designation area 66, a unit cell designation area 67, a data range designation area 68, and a data cell range designation. An area 69 is displayed.

  In the matrix number input area 63, the number of rows or the number of columns of measurement data at one measurement point is designated. As shown in the data display area 61, the measurement data of one measurement point is arranged in one row, so 1 is designated. When the number is two or more, the cell range in which the measurement data of one measurement point is arranged is designated in the data cell range designation area 69.

  In the point address cell designating area 64, the cell range of the point address is designated. That is, a cell (not shown) in which the point address of the measurement point is arranged is designated. Here, since there are two measurement points (temperature and humidity), two cells are designated. In the point name designation area 65, a cell range of point names is designated. That is, a cell (not shown) in which the point name is arranged is designated. Here, the point names of the temperature measurement point and the humidity measurement point are designated. In the data type cell designation area 66, the cell range of the data type of the measurement data is designated. That is, a cell (not shown) in which the data type of measurement data is arranged is designated.

  In the unit cell designation area 67, a unit cell range is designated. That is, the cell in which the unit of measurement data is arranged is specified. Here, the B3 cell and the C3 cell in which%, which is a unit of temperature, and% RH, which is a unit of humidity, are specified. In the data range designation area 68, a cell range of minute / 30 minutes / hour data is designated. That is, a cell range in which actual measurement data is arranged is designated. Here, B4 cell to C28 cell are designated. Thereby, the start cell position of the measurement data in the table of time series history data can be specified.

  When the above input is completed, the “next” button in the fourth window 60 is clicked to proceed to the next window. Then, the fifth window 70 shown in FIG. 6 is displayed, and the creation of the conversion pattern is completed. The created conversion pattern is stored with the pattern name specified in the pattern name input area 31. That is, the conversion pattern of the pattern name specified in the pattern name input area 31 is generated. The conversion pattern is stored in the conversion pattern storage unit 22. In this conversion pattern, a specified item is defined in the above processing. Further, when the “next processing” button is clicked, a pattern conversion process using the conversion pattern is performed in the processing unit 11.

  In the above description, the display position, display format, window layout, and the like of the designated area are examples, and are not particularly limited. For example, the number of wizard windows may be increased and each designated area may be displayed in a different window. That is, in the above description, an item defined in the same window may be defined on another window. Of course, an item defined in another window may be defined in the same window.

  Thus, in the time-series direction input area 53, the direction of arrangement of the time-series history data is designated. In the date cell designation area 55 and the time cell command area 58, the start date and time of the time series history data is designated. In the file type input area 33, the time interval of the time series history data is designated. In the data range designation area 68, the start cell position of the time series history data is designated. These designations can be designated by the input unit 12. Then, the display unit 13 displays at least a part of the contents of the time-series history data file in a table format so that at least the direction of the array, the start date / time, and the start cell position are designated. Then, with the time series history data being displayed, the direction of the array, the start date and time, and the start cell position are performed. Thereby, it can specify reliably and simply.

  When data conversion is performed using the above conversion pattern, a table data file in a prescribed format is obtained. That is, the data conversion program is started and a conversion pattern to be used is designated. Further, a data file of time series history data to be converted is selected. The converted table data file has a DMS format as shown in FIG. 7, for example. As shown in FIG. 7, in the table data, the data is arranged in the matrix direction. That is, each data and identifier is arranged in a matrix and becomes table data. Here, one conversion pattern is designated, and one or more data files are read to perform data conversion processing. That is, when one conversion pattern is designated, one or two or more data files are converted into a prescribed format file based on the conversion pattern.

  In the prescribed format file, as shown in FIG. 7, a date cell 81, a point address cell 82, a point name cell 83, a data type cell 84, a unit cell 85, and a measurement data cell 86 are arranged in this order from the left side. In the date cell 81, the measured date is stored. The point address cell 82 stores the point address of each measurement point. The point name cell 83 stores the point name. The data type cell 84 stores the data type. A unit cell 85 is stored. Measurement data is stored in the measurement data cell. Further, data relating to one point address is stored in one line. For example, in the top row, the date, point address, point name, data type, unit, and measurement data relating to the point address 99900001 are shown side by side in the horizontal direction. Also. In each row, measurement data at each point is arranged side by side. Of course, multiple measurement data arranged in each row has a specified time interval.

  In this way, the conversion processing is performed by selecting the data file of the time series history data from the same equipment 2 or the same kind of equipment 2. Then, the file is converted into a tabular file as shown in FIG. Moreover, the same conversion process can be repeatedly performed by creating a conversion pattern. Therefore, it is possible to easily convert time-series history data from a certain equipment 2. Different conversion patterns are created for different types of equipment 2. And it converts into the file of a regulation format using each conversion pattern. As a result, the format of the time-series history data is unified and imported into the database.

  In the conversion pattern creation process described above, some designations may be omitted. For example, when the delimiter character is limited in advance, it is not necessary to specify the delimiter character in the delimiter input area 34. At least the arrangement direction of the time series history data, the start date and time, the step time, and the start cell position may be specified.

  Or, instead of the time series history data array direction, start date / time, step time, and start cell position, specify the cell range where the measurement date / time is placed and the cell range of the measurement data in the time series history data file. You may make it do. That is, in the tabular time-series history data displayed on the display unit, the cell range of the measurement data and the cell range of the measurement date and time are input. As described above, the absolute time may be input instead of inputting the step time. Further, if the difference between adjacent cells is taken, the step time can be indirectly specified. In addition, the direction of the array is indirectly specified by specifying the cell range of the measurement data. That is, if a long cell range is specified in the vertical direction, it is specified that the arrangement direction is the vertical direction. In this case as well, the work burden can be reduced if input is possible while browsing part of the time-series history data.

  Further, the created conversion pattern can be modified as appropriate. For example, a tabular file shown in FIG. 7 is read and displayed on the display unit 13. That is, the converted file is displayed. Then, while browsing the converted tabular file, the cells in the file are corrected, changed, or added. The correction, change, and addition process are stored like a macro function. Then, this process is added to the conversion pattern to update the conversion pattern. When the updated conversion pattern is executed, the contents of the table data are updated. In this way, convenience can be further improved by appropriately modifying the conversion pattern.

  That is, one or more identifiers such as the point address, point name, unit, and data format of the measurement point are corrected. The identifier indicates a character string other than measurement data, a numerical value, or the like in a table data file. And when it corrects, the conversion pattern containing the correction content is produced. That is, the user corrects an identifier such as a point name and registers it as a conversion pattern. By performing conversion using this conversion pattern, the same correction for a specific identifier can be repeatedly performed. That is, the same correction is performed on the identifiers arranged in specific cells for different table data. As a result, the file in the specified format can be easily corrected.

  In FIG. 7, for example, it is assumed that the point name of the point address 999000001 arranged in the first column is corrected from “TA10” to “TA100”, and the corrected content is stored as a conversion pattern. When another file is converted with this conversion pattern, the point name in the first column is corrected to “TA100”, and the table data file is updated. That is, the identifier can be similarly corrected for another data file. By doing in this way, the same correction can be performed on the time-series history data from the same equipment 2. For example, even when time-series history data of different days is transferred in different data files, the same correction can be performed on the converted files. Therefore, the trouble of correcting the identifier can be saved. The work burden on the user can be reduced, and convenience can be improved.

  In the above description, the identifier is specified by the character string in the time series history data, but the present invention is not limited to this. Also, the designation of the identifier may be automatic input or character input by the user. Furthermore, a character string may be specified in the time series history data. Then, the specified identifier is corrected and incorporated into the converted file. Thus, the facility management apparatus 1 may be provided with a function for complementing the identifier. Note that a conversion pattern for correcting the identifier may be incorporated into the conversion pattern created by the processes of FIGS. 2 to 6 and stored as a single conversion pattern file. In this case, the correction content is registered as a part of the conversion pattern. Or you may preserve | save the conversion pattern for correcting an identifier as a file different from the conversion pattern produced by the process of FIGS. The conversion pattern is edited by correcting the file in the specified format converted by the processing unit 11 and storing the correction content. Therefore, the same correction can be repeatedly performed on different files.

Next, a method for creating a conversion pattern will be described with reference to FIG. FIG. 8 is a flowchart showing a conversion pattern creation procedure. First, a sample file for creating a conversion pattern is designated (step S101). Here, one sample file is designated. For example, the sample file name is input in the first window 30 shown in FIG. Then, the sample file having the designated file name is read (step S102), and the sample file is displayed (step S103). Thereby, as shown in the third window 50 and the fourth window 60, at least a part of the sample file is displayed. Then, the storage location of date / time data and measurement data is designated (step S104). In other words, the date / time data and the measurement data are specified while browsing the displayed time-series history data. Then, the conversion pattern is stored (step S105). Thus, a conversion pattern file in which each item is defined is generated. By reading this conversion pattern from the next time, the same conversion process can be repeated.
As described above, according to the present invention, data measured at regular intervals, which is a characteristic of time-series history data used in air conditioning management and power management, is directly or indirectly associated with a specific time. Focusing on the points that are attached and enumerated in a certain direction, it has realized simplicity by having an input item specialized for the target data and an interface that facilitates feature input of the target data.

  Next, a conversion process using the above conversion pattern will be described with reference to FIG. FIG. 9 is a flowchart showing a data conversion method.

  First, a conversion pattern and a conversion target file are specified (step S201). That is, a conversion pattern corresponding to the conversion target file is selected. Here, two or more conversion target files may be designated. Then, the processing unit 11 reads the designated conversion pattern and conversion target file (step S202). Then, the conversion is executed based on the items defined in the conversion pattern (step S203). In other words, the processing unit 11 refers to the items defined in the conversion pattern and converts the conversion target file into a file of a prescribed format. For example, each data of the time series history data is extracted and converted into a file of a prescribed format. Convert.

  Then, the display unit 13 displays a confirmation screen for confirming the conversion result (step S204). That is, the converted standard format file is read and displayed. Then, while browsing the confirmation screen, the user specifies the correction of the conversion result and the storage destination (step S205). Further, the correction content may be stored as a conversion pattern by correcting the conversion pattern. That is, the identifier is corrected, and the correction content is added to the conversion pattern. Then, the standard file is output (step S206). In this way, the conversion process to the specified format is executed. By using the conversion pattern as described above, the data can be easily converted.

  Of course, the above devices may not be physically one device. The conversion pattern creation process and the conversion process may be performed by different computers. Various programs installed in the computer to constitute the facility management apparatus 1 can be stored in a recording medium, and can be transmitted via a communication medium. A summary graph can be displayed by performing conversion processing on a file in a form format relating to air conditioning control of building facilities or power usage. Therefore, it can be easily confirmed whether appropriate control is performed in the facility. Therefore, it can contribute to the work of energy saving management. In the above-described embodiment, the example used for building monitoring and management has been described. However, the present invention is not limited to this, and can be used for various buildings, building facilities, commercial facilities, and the like.

It is a block diagram which shows typically the structure of an equipment monitoring system. It is a figure which shows an example of the window displayed in the data management method concerning this Embodiment. It is a figure which shows an example of the window displayed in the data management method concerning this Embodiment. It is a figure which shows an example of the window displayed in the data management method concerning this Embodiment. It is a figure which shows an example of the window displayed in the data management method concerning this Embodiment. It is a figure which shows an example of the window displayed in the data management method concerning this Embodiment. It is a figure which shows the data file of the table format converted in the data management method concerning this Embodiment. It is a flowchart which shows the preparation method of the conversion pattern concerning this Embodiment. It is a flowchart which shows the data conversion method concerning this Embodiment.

Explanation of symbols

1 equipment management device, 2 equipment facilities, 11 processing section, 12 input section,
13 Display section,
20 storage unit,
21 time-series storage data storage unit, 22 conversion pattern storage unit,
23 Table data storage unit 30 First window,
31 pattern name input area, 32 file format input area,
33 File type input area, 34 Delimiter input area,
35 quotes input area, 36 sample file input area,
40 Second window 41 Point address automatic additional setting area 42 Additional header input area 43 Digit number input area
50 3rd window 51 Sample data display area 52 Input area 53 Time series direction input area 54 Date data storage location specification area 55 Date cell specification area 56 Date format specification area 57 Time data storage location specification area 58 Time cell command Area, 59 time format designation area 60 fourth window 61 data display area 62 input area 63 number of matrix input area 64 point address cell designation area 65 point name designation area 66 data type cell designation area 67 unit cell designation area 68 Data range specification area, 69 Data cell range specification area 70 5th window 81 Date and time cell, 82 Point address cell, 83 Point name cell 84 Data type cell, 85 Unit cell, 86 Measurement data cell

Claims (12)

A data management device that converts and manages time-series history data into a specified format file,
A display unit for displaying the time series history data in a tabular format;
An input unit for designating the direction of the arrangement of the time-series history data in the tabular format, the start date and time, the step time, and the start cell position;
A conversion pattern storage unit for storing a conversion pattern in which an item designated by the input unit is defined;
A processing unit that refers to items defined by the conversion pattern and converts the time-series history data into the file of the default format,
A data management device in which the input unit can designate the direction of the array, the start date and time, and the start cell position in a state where the time-series history data in the tabular format is displayed. A data management device that converts and manages time-series history data into a specified format file,
A display unit for displaying the time-series history data file in a tabular format;
In a state where the time-series history data in the table format is displayed, an input unit capable of designating a cell range of the time-series history data and a cell range of date and time,
A conversion pattern storage unit for storing a conversion pattern in which an item designated by the input unit is defined;
A data management apparatus comprising: a processing unit that refers to an item defined by the conversion pattern and converts the time series history data into the file of the default format.   The data management apparatus according to claim 1, wherein when a file having a specified format converted by the processing unit is corrected, a conversion pattern including correction contents is created.   4. The data management apparatus according to claim 1, wherein the time-series history data file is a file in a form format relating to air conditioning control of a building facility or power usage. 5. A data management method for converting and managing time series history data into a file of a prescribed format,
Displaying the time series history data file in a tabular format;
Designating the array direction of the time-series history data in the tabular format, the start date and time, the step time, and the start cell position;
Storing a conversion pattern in which the specified item is defined in the specifying step;
Referring to the item defined by the conversion pattern, converting the time series history data into the file of the default format,
A data management method in which, in the specifying step, the direction of the array, the start date and time, and the start cell position are specified in a state where the time-series history data in the tabular format is displayed. A data management method for converting and managing time series history data into a file of a prescribed format,
Displaying the time series history data file in a tabular format;
In the state of displaying the time-series history data in the tabular format, a step of designating a cell range of the time-series history data and a cell range of the date and time;
Storing a conversion pattern in which the specified item is defined in the specifying step;
A step of converting the time-series history data into the file of the default format with reference to an item defined by the conversion pattern.   7. The data management method according to claim 5, wherein when the file having the specified format is corrected, a conversion pattern including the correction content is created.   The data management method according to any one of claims 5 to 7, wherein the time-series history data file is a file in a form related to air conditioning control of building facilities or power usage. A data conversion program that converts and manages a time-series history data file to a file of a specified format,
Against the computer,
Displaying the time-series history data in a tabular format;
Displaying an input area for designating the direction of the arrangement of the time-series history data in the tabular format, the start date and time, the step time, and the start cell position;
Storing a conversion pattern in which an item designated in the designated area is defined;
Referring to the item defined by the conversion pattern, converting the time series history data into the file of the default format,
A data management program in which an input area for designating the direction of the array, the start date and time, and the start cell position is displayed in a state where the time-series history data in the tabular format is displayed. A data management program that converts and manages time-series history data into a specified format file,
Against the computer,
Displaying the time-series history data file in a tabular format;
In a state where the time-series history data in the tabular format is displayed, displaying an input area for designating a cell range of the time-series history data and a cell range of the date and time;
Storing a conversion pattern in which an item designated by the designated area is defined;
A step of converting the time-series history data into the file of the default format with reference to an item defined by the conversion pattern.   The data management program according to claim 9 or 10, wherein when the file having the specified format is corrected, a conversion pattern including correction contents is created. The data management program according to any one of claims 9 to 11, wherein the time-series history data file is a file in a form format relating to air conditioning control of a building facility or power usage.

Images