CN106709059B

CN106709059B - Terminal online rate index monitoring method and device based on metering automation system

Info

Publication number: CN106709059B
Application number: CN201710016014.6A
Authority: CN
Inventors: 赖宇阳; 张明明; 林伟斌; 赵云; 隋兴嘉; 郑楷洪
Original assignee: China South Power Grid International Co ltd; Power Grid Technology Research Center of China Southern Power Grid Co Ltd
Current assignee: China South Power Grid International Co ltd
Priority date: 2017-01-10
Filing date: 2017-01-10
Publication date: 2020-06-19
Anticipated expiration: 2037-01-10
Also published as: CN106709059A

Abstract

The invention relates to a method and a device for monitoring a terminal online rate index based on a metering automation system. The method comprises the following steps: acquiring a file named in a preset format and uploaded by a metering automation system, wherein the file stores the actual online times of a terminal and the times of the terminal needing to be online; carrying out integrity check on the file according to the name of the file; if the file passes the integrity check, checking whether the actual online times of the terminal stored in the file and the online times of the terminal are not null; and if not, acquiring a terminal online rate index according to the actual terminal online times and the terminal online times stored in the file. The terminal online rate index data obtained by the method is high in quality, and the online level of the terminal can be truly reflected.

Description

Terminal online rate index monitoring method and device based on metering automation system

Technical Field

The invention relates to the technical field of electric energy data application, in particular to a method and a device for monitoring a terminal online rate index based on a metering automation system.

Background

With the development of electric power systems, the demand for the automation degree of the electric power systems is higher and higher, and the construction, popularization and application of metering automation systems (electric energy metering automation systems) are undoubtedly a qualitative leap for electric power production. The metering automation system comprehensively considers all electric energy metering points related to a power supply enterprise, realizes multiple monitoring functions of metering devices with large quantity and dispersed geographic positions, can implement certain control manual operation, and plays an increasingly important role in power production.

The terminal online rate index is a key index for reflecting the monitoring degree of the electricity consumption of customers and distribution areas, and is also a basic index for reflecting the operation and maintenance level of the field terminal. When monitoring the on-line rate indexes of terminals such as a load control terminal, a distribution transformer terminal and a low-voltage centralized reading terminal, the traditional technical scheme is that each province and ground level unit utilizes a metering automation system to collect terminal on-line related data, and then the collected data is generated into a file and uploaded to a network level electric energy data platform. And the online rate related data of the terminals uploaded by provincial and regional units are collected and counted through a network level electric energy data platform, so that the online rate indexes of the terminals of all levels of molecular companies are monitored.

However, the terminal online rate related data is generated by each province and level measurement automation system, and the terminal online rate related data uploaded by each province and level unit often has data quality problems such as data loss and data mutation, and the data quality problems cannot be found in time, so that the data in the network level electric energy data platform cannot truly reflect the terminal online level.

Disclosure of Invention

Therefore, in order to solve the above problems, it is necessary to provide a method and an apparatus for monitoring a terminal online rate index based on a metering automation system, so that the obtained terminal online rate index can truly reflect the online level of the terminal.

A monitoring method of terminal on-line rate index based on a metering automation system comprises the following steps:

acquiring a file named in a preset format and uploaded by a metering automation system, wherein the file stores the actual online times of a terminal and the times of the terminal needing to be online;

carrying out integrity check on the file according to the name of the file;

if the file passes the integrity check, checking whether the actual online times of the terminal stored in the file and the online times of the terminal are not null;

and if not, acquiring a terminal online rate index according to the actual terminal online times and the terminal online times stored in the file.

A monitoring device for terminal on-line rate index based on a metering automation system comprises:

the system comprises a file acquisition module, a file processing module and a file processing module, wherein the file acquisition module is used for acquiring a file which is uploaded by a metering automation system and named in a preset format, and the file stores the actual online times of a terminal and the times that the terminal should be online;

the integrity check module is used for carrying out integrity check on the file according to the name of the file;

the data item checking module is used for checking whether the actual online times of the terminal stored in the file and the online times of the terminal are not null when the file passes the integrity check;

and the online rate index obtaining module is used for obtaining the terminal online rate index according to the actual terminal online times and the terminal online times stored in the file when the actual terminal online times and the terminal online times are not empty.

According to the monitoring method and device for the terminal online rate index based on the metering automation system, the naming of the file uploaded by the metering automation system is standardized, an index data verification mechanism of a network-level electric energy data platform is established, the integrity of the file uploaded by the metering automation system is checked according to the file naming, after the file integrity is checked, the data item in the file is checked, and the data with problems can be found timely through the file integrity check and the data line check, so that relevant personnel can correct the data with problems in time, the accuracy of the data is improved, the terminal online rate index data obtained by the monitoring method and device for the terminal online rate index based on the metering automation system is high in quality, and the online level of the terminal can be reflected really.

Drawings

FIG. 1 is a schematic flow chart of a method for monitoring a terminal on-line rate indicator based on a metering automation system according to an embodiment;

FIG. 2 is a schematic flow chart of monitoring daily/monthly online rate files according to an embodiment;

FIG. 3 is a schematic flow chart diagram illustrating monitoring of supplier monitor files according to an embodiment;

FIG. 4 is a schematic flow chart of another embodiment of monitoring daily/monthly online rate files;

FIG. 5 is a schematic flow chart illustrating monitoring of supplier monitor files according to another embodiment;

fig. 6 is a schematic structural diagram of a monitoring apparatus for terminal on-line rate indicator based on a metering automation system according to an embodiment.

Detailed Description

To further illustrate the technical effects of the invention, the following description of the technical solution of the present invention with reference to the accompanying drawings and preferred embodiments will be made clear and complete.

As shown in fig. 1, a method for monitoring a terminal online rate index based on a metering automation system includes the steps of:

s110, acquiring a file named in a preset format and uploaded by a metering automation system, wherein the file stores the actual online times of a terminal and the times of the terminal needing to be online;

s120, carrying out integrity check on the file according to the name of the file;

s130, if the file passes the integrity check, checking whether the actual online times of the terminal stored in the file and the online times of the terminal are not null;

and S140, if the terminal is not empty, acquiring a terminal online rate index according to the actual terminal online times and the terminal online times stored in the file.

The method of the embodiment can be realized through a corresponding program, and the program runs in a grid-level electric energy data platform. According to the method, the data with problems can be found in time by carrying out integrity check on the uploaded files and checking the data items in the files, so that relevant personnel can correct the data with problems in time, and the accuracy of the data is improved.

For a better understanding of the present invention, the following is a detailed description of both the way in which automatically generated and automatically uploaded files are verified, and the way in which manually generated and manually uploaded files are verified. It should be noted that, in order to distinguish between the automatic and manual cases, the corresponding files are named as "first", "second", etc., and those skilled in the art should understand that the two files are substantially the same, for example, the first daily online rate file and the second daily online rate file are both substantially daily online rate files.

Firstly, a verification mode for automatically generated and uploaded files is as follows:

the files generally comprise daily online rate files, monthly online rate files, supplier monitoring files and the like, the files store actual online times of the terminal and the online times of the terminal, and the online times of the terminal are the product of the terminal number and the sampling times. The following describes the monitoring processes of the three files in detail.

(1) Daily online rate file:

in one embodiment, the file comprises a first daily online rate file (i.e., a daily online rate file). The method comprises the steps of collecting terminal online data of a certain area (such as a certain province) every day through a metering automation system, generating a day online rate file according to the terminal online data of each day, and generating the day online rate file according to the terminal online data of each day.

In order to facilitate management of the metering data, the time of generation of the daily online rate file is specified. In one embodiment, the first daily online rate file is automatically generated at a first preset time of day. For example, the file automatic generation time is set to 6 points per day, and when the time is reached, the automatic triggering is carried out, and the daily online rate file is automatically generated according to the interface specification. When a time point is set, the daily online rate file is generated only 1 time per day, and it should be noted that the present invention does not limit the number of times the daily online rate file is generated.

To facilitate management of metering data, as well as verification of files, the naming of daily online rate files is specified. In one embodiment, the naming of the first daily rate file may comprise: region unit code, generation time, day, data time, online rate, and sequence number. The name of the first daily online rate file can further comprise any one or any combination of a file identifier, an uploading mark and a file format of an online rate index. It should be noted that the present invention does not limit the naming format of the daily online rate file, and those skilled in the art can make other variations on the above naming.

In one embodiment, the name of the daily online rate file may be: provincial unit code _ SOEINFO (file identification of ONLINE rate indicator) _ generation time _ upload flag _ Day _ data time _ ONLINE (ONLINE rate) _ sequence number xml. Provincial corporate code is named according to certain rules, such as Guangdong 44, Guangxi 45, Yunnan 53, Guizhou 52, Hainan 46, Guangzhou 4401 and Shenzhen 4403. The generation time is the system time when the file is generated, the format can be YYYYMMDDHH24MMSS, and the generation time of the current file must be the same. The data time is the time of the data in the file, and the format can be YYYYMMDDHH24MMSS, with time, minute and second being 00. The sequence number can be defined according to actual needs, for example, the sequence number is defined as 001, 002, etc. The upload flag is to distinguish whether to upload automatically or manually, and may be defined by the user according to the user's needs, for example, the upload flag is: first (automatic on schedule).

To facilitate management of metering data, the upload time of the daily online rate file is specified. In one embodiment, the first daily online rate file is automatically uploaded at a second preset time of day, the second preset time being later than the first preset time. For example, the automatic upload time is set to 7 points per day, and when the time arrives, the automatic trigger is automatically triggered and the daily online rate file is automatically uploaded. When a time point is set, the daily online rate file is only uploaded for 1 time every day, and it should be noted that the number of times of uploading the daily online rate file is not limited in the present invention. If the system or the channel cannot be automatically triggered, a supplementary transmission process is adopted for processing.

As shown in fig. 2, after a metering automation system (for example, a metering automation system of a certain provincial company) automatically generates a standard file, the file is automatically uploaded to a grid-level electric energy data platform (hereinafter, referred to as a grid-level platform). And the network level platform performs integrity check and data item check on the uploaded files. The time point for performing the integrity check and the data item check is generally set after the time point for automatically uploading the file, for example, the file is uploaded at 7 points, the file directory is uploaded by scanning at 7 points and 5 points of the platform, and the data integrity check and the data item check are performed in a separate step.

In an embodiment, if the file is the first online daily rate file, the step of performing integrity check on the file according to the name of the file may include:

s121a, checking whether the data time of the file is the day before the current date;

checking whether the data time is the current date according to the file name, for example, the current date is 2 days, and the data time is 1 day;

s122a, checking whether the difference value between the uploading time of the file and the second preset time is within a preset range;

and checking the file uploading time, namely checking the file attribute of the network-level platform operating system. The preset range can be set according to actual needs, for example, the automatic file uploading time is set to 7 points per day, and the actual file uploading time is 7 points 0 to 7 points 10.

S123a, checking whether the difference value between the file generation time and the first preset time is within a preset range;

the preset range can be set according to actual needs, for example, the automatic file generation time is set to 6 points per day, and the actual file generation time is from 0 point to 10 points at 6 points;

through the verification of step S122a and step S123a, it can be ensured that the data is the original data.

S124, checking whether the number of the files uploaded by the metering automation system is a first preset number or not according to the sequence numbers of the files;

the first preset number is the number of daily online rate files which should be uploaded in the area, and is set according to actual conditions.

S125a, if all the check results are yes, determining that the file passes the integrity check, otherwise, determining that the file does not pass the integrity check;

the check is passed: the 4 items from S121a to S124a should pass the inspection, so that the process can proceed to the next link for processing;

check for failure: any one or several of the 4 items of S121a to step S124a failed the check, determining that the file failed the integrity check. Any one or more of the following actions may be taken: and generating a type of question list (requiring 2 working days for solving implementation and automatic file generation and automatic uploading function development), simultaneously transferring files to an abnormal file directory, recording logs, reporting a service supervisor by a monitoring person through a telephone, and issuing a notice.

If the file passes the integrity check, the network-level platform checks the file item by item according to the following rules, wherein the rules comprise:

1. the number of times that the terminal should be online and the number of times that the terminal is actually online are as follows: is not empty

If the number of times that the terminal should be online and the number of times that the terminal is actually online are not null, the next record check can be performed if the check is passed; and after all records are qualified, the file can be put in storage.

If one of the number of times that the terminal should be online and the number of times that the terminal is actually online is empty, or both of the number of times that the terminal should be online and the number of times that the terminal is actually online are empty, the check fails, and any one or more of the following operations can be adopted: generating a type of question list (requiring 2 working days for solving the problem of the real data source generation function development), transferring the file to an abnormal file directory, recording the log, simultaneously interrupting the file processing, reporting the service supervisor by the monitoring personnel through the telephone, and issuing the notice.

And if the file passes the integrity check and the data item check, the platform puts the file into a warehouse, and obtains a terminal online rate index according to the ratio of the actual terminal online times to the terminal online times stored in the file. And after the network-level platform finishes warehousing the files, recording warehousing logs, transferring the files to a backup directory and compressing the files.

(2) Monthly online rate file:

in one embodiment, the file comprises a first monthly online rate file (i.e., monthly online rate file). The method comprises the steps of collecting terminal online data of each month in a certain area (such as a certain province) through a metering automation system, generating a month online rate file according to the terminal online data of each month, and generating the month online rate file according to the terminal online data of each month according to the specific mode in the prior art.

To facilitate management of the metering data, the time of generation of the monthly online rate file is specified. In one embodiment, the first monthly online rate file is automatically generated at a first preset time on the nth day of each month, where N is a fixed value. N may be set according to actual needs, such as day 1 of each month, or day 2 of each month, etc., and since the number of days of each month is not necessarily the same, N should be set to a value of 28 or less in order to ensure that data of each month is normally and automatically generated. To facilitate management of the metering data, the first preset time may be the same as the first preset time of the daily online rate file. For example, the file automatic generation time is set to 6 points 1 day per month, and when the time arrives, the automatic triggering is performed, and the monthly online rate file is automatically generated according to the interface specification. When a time point is set, the monthly online rate file is generated only 1 time per month, and it should be noted that the generation times of the monthly online rate file are not limited by the present invention.

To facilitate management of metering data, as well as verification of files, the naming of monthly online rate files is specified. In one embodiment, the naming of the monthly first online rate file may comprise: region unit code, generation time, month, data time, online rate, and sequence number. The name of the monthly first online rate file can further comprise any one or any combination of a file identifier, an uploading mark and a file format of an online rate index. It should be noted that the present invention does not limit the naming format of the monthly online rate file, and other variations may be made on the basis of the above naming.

In one embodiment, the name of the monthly online rate file may be: provincial unit encoding _ SOEINFO _ generation time _ upload flag _ Mon (month) _ data time _ ONLINE _ sequence number xml. Provincial corporate code is named according to certain rules, such as Guangdong 44, Guangxi 45, Yunnan 53, Guizhou 52, Hainan 46, Guangzhou 4401 and Shenzhen 4403. The generation time is the system time when the file is generated, the format can be YYYYMMDDHH24MMSS, and the generation time of the current file must be the same. The data time is the time of the data in the file, and the format can be YYYYMMDDHH24MMSS, with time, minute and second being 00. The sequence number may be self-defined, e.g., sequence numbers 001, 002, etc. The upload flag is to distinguish whether to upload automatically or manually, and may be defined by the user according to the user's needs, for example, the upload flag is: first (automatic on schedule).

To facilitate management of the metering data, the upload time of the monthly online rate file is specified. In one embodiment, the first monthly online rate file is automatically uploaded at a second preset time on the nth day of each month, wherein the second preset time is later than the first preset time, and N is a fixed value. For example, the automatic upload time is set to 1 day 7 a month, and when the time arrives, the automatic trigger is made and the monthly online rate file is automatically uploaded. When a time point is set, the monthly online rate file is uploaded only 1 time per month, and it should be noted that the number of times the monthly online rate file is uploaded is not limited by the present invention. If the system or the channel cannot be automatically triggered, a supplementary transmission process is adopted for processing.

As shown in fig. 2, after a metering automation system (e.g., a metering automation system of a certain provincial company) automatically generates a file of a specification, the file is automatically uploaded to a network-level platform. And the network level platform performs integrity check and data item check on the uploaded files. The time point for performing the integrity check and the data item check is generally set after the time point for automatically uploading the file, for example, the file is uploaded at 7 points 1 day a month, the file directory is uploaded by 5 point scans by 7 point platforms, and the data integrity check and the data item check are performed in separate provinces.

In an embodiment, if the file is the first monthly online rate file, the step of performing integrity check on the file according to the name of the file may include:

s121b, checking whether the data time of the file is the same day of the month before the current date;

checking whether the data time is the current date according to the file name, wherein the current date is 2 months and 1 day, and the data time is 1 month and 1 day;

s122b, checking whether the difference value between the uploading time of the file and the second preset time is within a preset range;

and checking the file uploading time, namely checking the file attribute of the network-level platform operating system. The preset range can be set according to actual needs, for example, the automatic file uploading time is set to 1 day 7 per month, and the actual file uploading time is from 7 points 0 to 7 points 10.

S123b, checking whether the difference value between the file generation time and the first preset time is within a preset range;

the preset range can be set according to actual needs, for example, the automatic file generation time is set to 6 points on 1 day per month, and the actual file generation time is from 0 point to 10 points on 6 points;

through the verification of step S122b and step S123b, it can be ensured that the data is the original data.

S124, checking whether the number of the files uploaded by the metering automation system is a second preset number or not according to the sequence numbers of the files;

the second preset number is the number of monthly online rate files which should be uploaded in the area, and is set according to actual conditions.

S125b, if all the check results are yes, determining that the file passes the integrity check, otherwise, determining that the file does not pass the integrity check;

the check is passed: the 4 items from S121b to S124b should pass the inspection, so that the process can proceed to the next link for processing;

check for failure: any one or several of the 4 items of S121b to step S124b failed the check, determining that the file failed the integrity check. Any one or more of the following actions may be taken: and generating a type of question list (requiring 2 working days for solving implementation and automatic file generation and automatic uploading function development), simultaneously transferring files to an abnormal file directory, recording logs, reporting a service supervisor by a monitoring person through a telephone, and issuing a notice.

(3) Supplier monitoring document:

in one embodiment, the file comprises a first vendor monitoring file (i.e., a vendor monitoring file). The supplier is a related manufacturer in the region, such as Huazhi supplier, Sanxing supplier, etc. The specific mode of acquiring the terminal online data of the supplier in a certain area (such as a certain province) through the metering automation system, then generating the supplier monitoring file according to the terminal online data of the supplier, and generating the supplier monitoring file according to the terminal online data of the supplier can be realized according to the existing mode in the prior art.

To facilitate management of metering data, supplier monitoring file generation times are specified. In one embodiment, the first supplier monitor file is automatically generated at a first preset time every nth day of the month, N being a fixed value. N may be set according to actual needs, such as day 1 of each month, or day 2 of each month, etc., and since the number of days of each month is not necessarily the same, N should be set to a value of 28 or less in order to ensure that data of each month is normally and automatically generated. To facilitate management of the metering data, the first preset time may be the same as the first preset time of the daily online rate file. For example, the supplier monitor file automatic generation time is set to 1 day 6 per month, and when the time arrives, it is automatically triggered, and the supplier monitor file is automatically generated according to the interface specification. When a time point is set, the supplier monitor file is generated only 1 time per month, and it should be noted that the present invention does not limit the number of times the supplier monitor file is generated.

To facilitate management of metering data, as well as verification of files, provisions are made for naming vendor monitoring files. In one embodiment, the first vendor monitoring naming of files comprises: region unit code, generation time, month, data time, supplier, and sequence number. The first supplier monitoring file naming also comprises any one or any combination of file identification, uploading mark and file format of the online rate index. It should be noted that the invention does not limit the naming format of the supplier monitor file, and other variations can be made on the basis of the above naming.

In one embodiment, the name of the vendor monitor file may be: provincial unit code _ SOEINFO _ generation time _ upload flag _ Mon _ data time _ provider _ sequence number xml. Provincial corporate code is named according to certain rules, such as Guangdong 44, Guangxi 45, Yunnan 53, Guizhou 52, Hainan 46, Guangzhou 4401 and Shenzhen 4403. The generation time is the system time when the file is generated, the format can be YYYYMMDDHH24MMSS, and the generation time of the current file must be the same. The data time is the time of the data in the file, and the format can be YYYYMMDDHH24MMSS, with time, minute and second being 00. The sequence number is a sequence number generated by the data files of the same type and can be defined as required, for example, the sequence number is 001, 002, etc. The upload flag is mainly used for distinguishing whether the upload is automatic upload or manual upload, and can be defined by the user according to the user's needs, for example, the upload flag is: first (automatic on schedule).

To facilitate management of metering data, a provision is made for the upload time of the supplier monitoring file. In one embodiment, the first supplier monitoring file is automatically uploaded at a second preset time on the nth day of each month, the second preset time is later than the first preset time, and N is a fixed value. For example, the automatic upload time is set to 1 day 7 a month, and when the time arrives, it is automatically triggered and the supplier monitor file is automatically uploaded. When a time point is set, the supplier monitoring file is uploaded only 1 time per month, and it should be noted that the present invention does not limit the number of times the supplier monitoring file is uploaded. If the system or the channel cannot be automatically triggered, a supplementary transmission process is adopted for processing.

As shown in fig. 3, a metering automation system (e.g., a metering automation system of a certain provincial company) automatically generates a standard file, and then automatically uploads the file to a network-level platform. And the network level platform performs integrity check and data item check on the uploaded files. The time point for performing the integrity check and the data item check is generally set after the time point for automatically uploading the file, for example, the file is automatically uploaded at 7 points 1 day a month, the file directory is scanned and uploaded at 7 points 5 points of the platform, and the data integrity check and the data item check are performed in separate provinces.

In one embodiment, if the file is the first vendor monitoring file, the step of performing integrity check on the file according to the file name may include:

s121c, checking whether the data time of the file is the same day of the month before the current date;

s122c, checking whether the difference value between the uploading time of the file and the second preset time is within a preset range;

S123c, checking whether the difference value between the file generation time and the first preset time is within a preset range;

through the verification of step S122c and step S123c, it can be ensured that the data is the original data.

S124, checking whether the number of the files uploaded by the metering automation system is a third preset number or not according to the sequence numbers of the files;

the third preset number is the number of the supplier monitoring files which should be uploaded by the supplier in the region, and is set according to the actual situation.

S125c, if all the check results are yes, determining that the file passes the integrity check, otherwise, determining that the file does not pass the integrity check;

the check is passed: the 4 items from S121c to S124c should pass the inspection, so that the process can proceed to the next link for processing;

check for failure: any one or several of the 4 items of S121c to step S124c failed the check, determining that the file failed the integrity check. Any one or more of the following actions may be taken: and generating a type of question list (requiring 2 working days for solving implementation and automatic file generation and automatic uploading function development), simultaneously transferring files to an abnormal file directory, recording logs, reporting a service supervisor by a monitoring person through a telephone, and issuing a notice.

In one embodiment, the first supplier monitor file further stores a correspondent manufacturer and a correspondent manufacturer code; if the document is the first supplier monitoring document, after the document passes the integrity check, the method may further include the steps of: checking whether the communication manufacturer and the communication manufacturer code stored in the file are not empty at the same time. And if the actual online times of the terminal and the online times of the terminal stored in the file are not null, and the communication manufacturer code stored in the file are not null at the same time, acquiring a terminal online rate index according to the actual online times of the terminal and the online times of the terminal stored in the file.

Namely, the data item checking rule set for the supplier monitoring file includes:

1. the number of times that the terminal should be online and the number of times that the terminal is actually online are as follows: is not empty;

2. communication manufacturer and terminal manufacturer coding: not empty at the same time.

The next record check can be carried out if the check is passed; and after all records are qualified, the file can be put in storage.

The check fails, and any one or more of the following actions may be taken: generating a type of question list (requiring 2 working days for solving the problem of the real data source generation function development), transferring the file to an abnormal file directory, recording the log, simultaneously interrupting the file processing, reporting the service supervisor by the monitoring personnel through the telephone, and issuing the notice.

Secondly, a verification mode of manually generated and uploaded files is as follows:

if some files cannot be uploaded successfully automatically due to system reasons, manual supplementary transmission needs to be carried out on the files which cannot be uploaded automatically, the files which are transmitted manually are generally the same as the files which are uploaded automatically, and daily online rate files, monthly online rate files, supplier monitoring files and the like are also included. The following describes the monitoring processes of the three files in detail.

(1) Daily online rate file:

in one embodiment, the file comprises a second daily online rate file (i.e., a daily online rate file) that is manually generated from the work order. The work order may be a work order issued by the network-level platform or an update data application work order approved by the network-level platform. The user manually generates a file from the work order according to the interface specification.

The manual uploading daily online rate file is named in the same way as the automatic uploading daily online rate file. In one embodiment, the naming of the second day online rate file may comprise: region unit code, generation time, day, data time, online rate, and sequence number. The name of the second day online rate file can further comprise any one or any combination of a file identifier, an uploading mark and a file format of the online rate index. It should be noted that the invention does not limit the naming format of the daily online rate file, and other variations can be made on the basis of the above naming.

In one embodiment, the manual upload daily online rate file may be named as: provincial unit encoding _ SOEINFO _ generation time _ upload flag _ Day _ data time _ ONLINE _ sequence number xml. Provincial corporate code is named according to certain rules, such as Guangdong 44, Guangxi 45, Yunnan 53, Guizhou 52, Hainan 46, Guangzhou 4401 and Shenzhen 4403. The generation time is the system time when the file is generated, the format can be YYYYMMDDHH24MMSS, and the generation time of the current file must be the same. The data time is the time of the data in the file, and the format can be YYYYMMDDHH24MMSS, with time, minute and second being 00. The sequence number generated by the data files of the same type can be defined by self according to needs, for example, the coding is started from the sequence number of 001, and the generation cannot be repeated every time. The upload flag is to distinguish whether to upload automatically or manually, and may be defined by the user according to the user's needs, for example, the upload flag is: second (complement).

As shown in fig. 4, after the canonical file is manually generated, the file is manually uploaded to the network-level platform. The monitoring personnel manually check the integrity of the files. Therefore, in an embodiment, if the file is the second-day online rate file, the step of performing integrity check on the file according to the name of the file may include: and when the selected operation of the corresponding file is detected when the number of the files is determined to be complete according to the work order, determining that the corresponding file passes the integrity check. And checking the number of the files by a monitoring worker according to the work order, clicking and selecting the corresponding sequence number data file to process the next step if the number of the files is complete, otherwise, noting the reason, proposing a requirement and returning the work order.

If the file passes the integrity check, the network-level platform automatically checks the file item by item according to the following check rule. The rules include:

1. the number of times that the terminal should be online and the number of times that the terminal is actually online are as follows: are all not empty

The check is passed: the next record check can be carried out if the check is required to pass all the records; and after all records are qualified, the file can be put in storage.

Check for failure: and (5) noting the reason, making a request and returning a work order.

If the file passes the integrity check and the data item check, automatically warehousing according to the following steps: and judging the allowable updating range of the data according to the work order, and only updating or warehousing the allowable updating data. And after the storage is finished, recording a log, transferring the file to a backup directory and compressing the file. And modifying the status of the question list into processed status, and recording the modification completion time.

(2) Monthly online rate file:

in one embodiment, the file comprises a second February online rate file (i.e., a monthly online rate file). The work order may be a work order issued by the network-level platform or an update data application work order approved by the network-level platform. The user manually generates a file from the work order according to the interface specification.

The manual uploading of the monthly online rate file is named in the same way as the automatic uploading of the monthly online rate file. In one embodiment, the naming of the second February online rate file may comprise: region unit code, generation time, month, data time, online rate, and sequence number. The second february online rate file name may further include any one or any combination of a file identifier, an upload flag, and a file format of an online rate indicator. It should be noted that the present invention does not limit the naming format of the monthly online rate file, and other variations may be made on the basis of the above naming.

In one embodiment, the name of the manually uploaded monthly online rate file may be: provincial unit encoding _ SOEINFO _ generation time _ upload flag _ Mon _ data time _ ONLINE _ sequence number xml. Provincial corporate code is named according to certain rules, such as Guangdong 44, Guangxi 45, Yunnan 53, Guizhou 52, Hainan 46, Guangzhou 4401 and Shenzhen 4403. The generation time is the system time when the file is generated, the format can be YYYYMMDDHH24MMSS, and the generation time must be the same. The data time is the time of the data in the file, and the format can be YYYYMMDDHH24MMSS, with time, minute and second being 00. The sequence number may be self-defined as desired, e.g., sequence numbers 001, 002, etc. The upload flag is to distinguish whether to upload automatically or manually, and may be defined by the user according to the user's needs, for example, the upload flag is: second (complement).

As shown in fig. 4, after the canonical file is manually generated, the file is manually uploaded to the network-level platform. The monitoring personnel manually check the integrity of the files. Therefore, in an embodiment, if the file is the second February online rate file, the step of performing integrity check on the file according to the name of the file may include: and when the selected operation of the corresponding file is detected when the number of the files is determined to be complete according to the work order, determining that the corresponding file passes the integrity check. And checking the number of the files by a monitoring worker according to the work order, clicking and selecting the corresponding sequence number data file to process the next step if the number of the files is complete, otherwise, noting the reason, proposing a requirement and returning the work order.

(3) Supplier monitoring document:

in one embodiment, the file comprises a second vendor monitoring file (i.e., a vendor monitoring file). The work order may be a work order issued by the network-level platform or an update data application work order approved by the network-level platform. The user manually generates a file from the work order according to the interface specification.

The manual uploading of the monthly online rate file is named in the same way as the automatic uploading of the monthly online rate file. In one embodiment, the second vendor monitoring naming of files comprises: region unit code, generation time, month, data time, supplier, and sequence number. The second supplier monitoring file naming also comprises any one or any combination of file identification, uploading mark and file format of the online rate index. It should be noted that the invention does not limit the naming format of the supplier monitor file, and other variations can be made on the basis of the above naming.

In one embodiment, the name of the vendor monitor file may be: provincial unit code _ SOEINFO _ generation time _ upload flag _ Mon _ data time _ superior _ sequence number, xml. Provincial corporate code is named according to certain rules, such as Guangdong 44, Guangxi 45, Yunnan 53, Guizhou 52, Hainan 46, Guangzhou 4401 and Shenzhen 4403. The generation time is the system time when the file is generated, the format can be YYYYMMDDHH24MMSS, and the generation time must be the same. The data time is the time of the data in the file, and the format can be YYYYMMDDHH24MMSS, with time, minute and second being 00. The sequence number is a sequence number generated by the data file of the same type, and may be defined by a specification, for example, the sequence number is 001, 002, or the like. The upload flag is mainly used for distinguishing whether the upload is automatic upload or manual upload, and can be defined by the user according to the user's needs, for example, the upload flag is: second (complement).

As shown in fig. 5, after the canonical file is manually generated, the file is manually uploaded to the network-level platform. The monitoring personnel manually check the integrity of the files. Therefore, in one embodiment, if the file is the second supplier monitoring file, the step of performing integrity check on the file according to the name of the file may include: and when the selected operation of the corresponding file is detected when the number of the files is determined to be complete according to the work order, determining that the corresponding file passes the integrity check. And checking the number of the files by a monitoring worker according to the work order, clicking and selecting the corresponding sequence number data file to process the next step if the number of the files is complete, otherwise, noting the reason, proposing a requirement and returning the work order.

If the file passes the integrity check, the network-level platform automatically checks the file item by item according to the following check rule. In one embodiment, the second supplier monitor file further stores a correspondent manufacturer and a correspondent manufacturer code; if the document is the second supplier monitoring document, after the document passes the integrity check, the method further comprises the following steps: checking whether the communication manufacturer and the communication manufacturer code stored in the file are not empty at the same time; and if the actual online times of the terminal and the online times of the terminal stored in the file are not null, and the communication manufacturer code stored in the file are not null at the same time, acquiring a terminal online rate index according to the actual online times of the terminal and the online times of the terminal stored in the file. Namely, the network-level platform checks the data items according to the following rules:

2. Coding of communication manufacturers and terminal manufacturers: not empty at the same time.

The check is passed: the next record check can be carried out; and after all records are qualified, the file can be put in storage.

In order to facilitate the people to know the online condition of the terminal, the files stored in the database need to be published in the interface. In order to ensure the reasonability of the data, the data is required to be checked according to a custom rule, the checking time can be set according to needs, for example, set to 9 points per day, and when the time is reached, the network-level platform automatically checks the reasonability of the data according to the city.

Therefore, in an embodiment, after obtaining the terminal presence rate indicator according to the actual terminal presence times and the terminal presence times stored in the file, the method may further include the steps of:

s150, checking whether the obtained terminal online rate index is reasonable according to preset conditions;

and S160, displaying the obtained terminal online rate index, and carrying out abnormal identification on the unreasonable terminal online rate index during display.

In checking the reasonableness of data, the requirements of the day/month online rate file (including automatic upload and manual upload) and the supplier monitoring file (including automatic upload and manual upload) are different, so different reasonableness checking conditions are defined for the two files, respectively, and the following description will be made in conjunction with the two embodiments.

If the file is a first daily online rate file, a second daily online rate file, a first monthly online rate file, or a second monthly online rate file, in an embodiment, the step of checking whether the obtained terminal online rate index is reasonable according to a preset condition includes any one or any combination of the following steps:

checking whether the terminal online rate index is greater than 0 and less than or equal to 1; namely, the index value of the terminal online rate is more than 0 and less than or equal to 100 percent;

checking whether the daily-to-annular ratio fluctuation of the online times of the terminal is within a preset range; when the terminal online rate index value is determined, the denominator is the number of times that the terminal should be online, and the numerator is the actual number of times that the terminal is online, so that the condition is whether the fluctuation of the denominator value daily-to-annular ratio is within the preset range. The preset range can be set as required, but is not suitable to be set too large, and can be set to be within +/-3% for example;

checking whether the daily-to-annular ratio fluctuation of the terminal online rate index is within a preset range; the preset range can be set as required, but is not suitable to be set too large, and can be set to be within +/-5% for example;

checking whether the actual online times of the full-caliber terminal are equal to the sum of the actual online times of the terminal of the direct supply straight pipe and the actual online times of the terminal of the county-level subsidiary company, and whether the online times of the full-caliber terminal are equal to the sum of the online times of the terminal of the direct supply straight pipe and the online times of the terminal of the county-level subsidiary company; the numerator corresponding to the full aperture is equal to the sum of the numerator corresponding to the direct supply straight pipe and the numerator corresponding to the county-level subsidiary company, and the denominator corresponding to the full aperture is equal to the sum of the denominator corresponding to the direct supply straight pipe and the denominator corresponding to the county-level subsidiary company;

checking whether the actual online times of the terminals in each month are equal to the sum of the actual online times of the terminals on all days in the corresponding month, and whether the online times of the terminals in each month are equal to the sum of the online times of the terminals on all days in the corresponding month; namely, the numerator of the monthly online rate is the sum of the numerators of the daily online rate (natural month), and the denominator of the monthly online rate is the sum of the denominators of the daily online rate (natural month);

and if the corresponding conditions are met, determining that the terminal online rate index is reasonable. Otherwise, the terminal online rate index is determined to be unreasonable, and a second type of question list is generated without reporting to the market department. And for the data additionally transmitted, if the work order problem does not exist any more, modifying the state of the problem order into processed state, and recording the modification completion time.

If the file is a first supplier monitoring file or a second supplier monitoring file, in an embodiment, the step of checking whether the obtained terminal online rate index is reasonable according to a preset condition may include:

checking whether the actual online times of the terminals in each month are equal to the sum of the actual online times of the terminals of all suppliers in the corresponding month, and whether the online times of the terminals in each month are equal to the sum of the online times of the terminals of all suppliers in the corresponding month; i.e., the monthly online rate numerator equals the sum of the numerators monitored by the supplier and the monthly online rate denominator equals the sum of the denominators monitored by the supplier.

Other conditions for judging the reasonability of the data can be set by a person skilled in the art according to actual conditions, and the invention is not limited to the conditions.

After 10 points of data are transmitted or the data are supplemented and transmitted into a database every day by the network-level platform, the day/month online rate and the supplier monitoring data are automatically issued according to the following rules:

1. day/month online rate data

(1) The city grade: if the number of the data is complete (including the caliber), the platform automatically releases the data, otherwise, all the data in the city are not released;

(2) step (4) province level: summarizing and counting the released ground-level data, and releasing the data only if all the prefectured cities have releasing conditions;

(3) network level: and automatically summarizing and counting the issued provincial data.

2. Supplier monitoring data

(1) The city grade: if data exist in factory monitoring and operator monitoring, the data are automatically released;

If the city is not released or there is a question list released for various reasons, the network-level platform monitoring interface needs! And prompting. The network-level platform marks a 'release' mark on the released data, the released data is not allowed to be modified, monitoring personnel can manually cancel the data release, and the data release canceling rule is the same as the data release rule.

Based on the same inventive concept, the invention also provides a monitoring device for the terminal on-line rate index based on the metering automation system, and the specific implementation mode of the device is described in detail below by combining the attached drawings.

As shown in fig. 6, a monitoring device for terminal on-line rate indicator based on a metering automation system includes:

the file acquisition module 110 is configured to acquire a file named in a preset format and uploaded by the metering automation system, where the file stores an actual online frequency of the terminal and an online frequency of the terminal;

an integrity check module 120, configured to perform integrity check on the file according to the name of the file;

a data item checking module 130, configured to check whether the actual online times of the terminal and the online times of the terminal stored in the file are both null when the file passes the integrity check;

and an online rate index obtaining module 140, configured to obtain a terminal online rate index according to the actual terminal online times and the terminal online times stored in the file when the actual terminal online times and the terminal online times are not empty.

The device of the embodiment can operate in a grid-level electric energy data platform. The device of the embodiment can timely find out data with problems by carrying out integrity verification on the uploaded files and verifying data items in the files, timely correct data with problems and improve the accuracy of the data.

In one embodiment, the file comprises a first daily rate file; the naming of the first daily rate file comprises: region unit coding, file identification of online rate index, generation time, uploading mark, day, data time, online rate, sequence number and file format; the first daily online rate file is automatically generated at a first preset time every day and is automatically uploaded at a second preset time every day, and the second preset time is later than the first preset time.

In one embodiment, the file further comprises a first monthly online rate file; the naming of the monthly first online rate file comprises: region unit coding, file identification of online rate index, generation time, uploading mark, month, data time, online rate, sequence number and file format; the first monthly online rate file is automatically generated at a first preset time of the Nth day of each month, and is automatically uploaded at a second preset time of the Nth day of each month, wherein the second preset time is later than the first preset time, and N is a fixed value.

In one embodiment, the document further comprises a first vendor monitoring document; the first vendor monitoring naming of files comprises: region unit coding, file identification of online rate index, generation time, uploading mark, month, data time, supplier, sequence number and file format; the first supplier monitoring file is automatically generated at a first preset time of the Nth day of each month, and is automatically uploaded at a second preset time of the Nth day of each month, wherein the second preset time is later than the first preset time, and N is a fixed value.

In one embodiment, the files include a second daily online rate file, a second february online rate file, and a second supplier monitoring file manually generated from a work order.

In one embodiment, the first or second supplier monitor file further stores a correspondent manufacturer and a correspondent manufacturer code; the data item checking module 130 is further configured to check whether the correspondent manufacturer and the correspondent manufacturer code stored in the file are not empty at the same time when the file is the first supplier monitoring file or the second supplier monitoring file. The online rate index obtaining module 140 obtains a terminal online rate index according to the actual terminal online times and the terminal online times stored in the file when the actual terminal online times and the terminal online times stored in the file are not empty, and the communication manufacturer code stored in the file are not empty at the same time.

Other technical features of the monitoring device based on the terminal online rate index of the metering automation system are the same as those of the monitoring method based on the terminal online rate index of the metering automation system, and are not repeated herein.

Compared with the prior art, the method and the device for monitoring the terminal online rate index based on the metering automation system have the following advantages:

1. clear data uploading process is formulated, steps are clear, operation is specific, two-stage main station monitoring personnel of a network and a province can master the process according to the monitoring process through simple training, and usability is high;

2. the uploaded files are effectively controlled, and the data are ensured to be clear and definite in the warehousing process;

3. through carrying out the check-up to data, the data that in time finds the existence problem communicates through the work order mode, in time rectifies and reforms data, has improved the accuracy of data.

The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.

Claims

1. A monitoring method of terminal on-line rate index based on a metering automation system is characterized by comprising the following steps:

acquiring a file named in a preset format and uploaded by a metering automation system, wherein the file stores the actual online times of a terminal and the times of the terminal needing to be online; the terminal online times are the product of the terminal number and the sampling times;

carrying out integrity check on the file according to the name of the file; the file name comprises data time, generation time and a sequence number; the data time is the time of the data in the file; the generation time is the system time when the file is generated; setting the file to be automatically generated at a corresponding first preset time, and automatically uploading the file at a corresponding second preset time; the second preset time is later than the first preset time;

if not, acquiring a terminal online rate index according to the actual terminal online times and the terminal online times stored in the file;

wherein the step of performing integrity check on the file according to the file name comprises:

checking whether the data time of the file is a preset data time;

checking whether the difference value between the actual uploading time of the file and the second preset time is within a preset range;

checking whether the difference value between the actual generation time of the file and the first preset time is within a preset range;

checking whether the number of the files uploaded by the metering automation system is a preset number or not according to the sequence numbers of the files; the preset number is the number of the files which should be uploaded;

if all the check results are yes, determining that the file passes the integrity check, otherwise determining that the file does not pass the integrity check;

or the like, or, alternatively,

if the file is manually generated according to a work order, the step of performing integrity check on the file according to the file name comprises the following steps:

and when the selected operation of the corresponding file is detected when the number of the files is determined to be complete according to the work order, determining that the corresponding file passes the integrity check.

2. The method for monitoring terminal on-line rate indicator based on metering automation system as claimed in claim 1,

the file comprises a first online-per-day rate file; the naming of the first daily rate file comprises: region unit coding, file identification of online rate index, generation time, uploading mark, day, data time, online rate, sequence number and file format; the first daily online rate file is automatically generated at the first preset time of each day and is automatically uploaded at the second preset time of each day;

the preset data time is the day before the current date.

3. The method for monitoring terminal on-line rate indicator based on metering automation system as claimed in claim 1,

the file comprises a monthly first online rate file; the naming of the monthly first online rate file comprises: region unit coding, file identification of online rate index, generation time, uploading mark, month, data time, online rate, sequence number and file format; the first monthly online rate file is automatically generated at the first preset time of the Nth day of each month, and is automatically uploaded at the second preset time of the Nth day of each month, wherein N is a fixed value;

the preset data time is the same day of the month before the current date.

4. The method for monitoring terminal on-line rate indicator based on metering automation system as claimed in claim 1,

the document comprises a first vendor monitoring document; the first vendor monitoring naming of files comprises: region unit coding, file identification of online rate index, generation time, uploading mark, month, data time, supplier, sequence number and file format; the first supplier monitoring file is automatically generated at the first preset time of the Nth day of each month, and is automatically uploaded at the second preset time of the Nth day of each month, wherein N is a fixed value;

the preset data time is the same day of the month before the current date; the first supplier monitoring file also stores a communication manufacturer and a communication manufacturer code; if the document is the first supplier monitoring document, after the document passes the integrity check, the method further comprises the following steps:

checking whether the communication manufacturer and the communication manufacturer code stored in the file are not empty at the same time; and if the actual online times of the terminal and the online times of the terminal stored in the file are not null, and the communication manufacturer code stored in the file are not null at the same time, acquiring a terminal online rate index according to the actual online times of the terminal and the online times of the terminal stored in the file.

5. The method for monitoring terminal on-line rate indicator based on metering automation system as claimed in claim 1,

the files comprise a second daily online rate file, a second february online rate file and a second supplier monitoring file which are manually generated according to a work order;

the second supplier monitoring file also stores a communication manufacturer and a communication manufacturer code; if the document is the second supplier monitoring document, after the document passes the integrity check, the method further comprises the following steps: checking whether the communication manufacturer and the communication manufacturer code stored in the file are not empty at the same time; and if the actual online times of the terminal and the online times of the terminal stored in the file are not null, and the communication manufacturer code stored in the file are not null at the same time, acquiring a terminal online rate index according to the actual online times of the terminal and the online times of the terminal stored in the file.

6. The method for monitoring the terminal online rate index based on the metering automation system as claimed in any one of claims 1 to 5, wherein after the terminal online rate index is obtained according to the actual terminal online times and the terminal online times stored in the file, the method further comprises the following steps:

checking whether the obtained terminal online rate index is reasonable or not according to preset conditions;

and displaying the obtained terminal online rate index, and carrying out abnormal identification on the unreasonable terminal online rate index during display.

7. The method for monitoring the terminal online rate index based on the metering automation system as claimed in claim 6, wherein the step of checking whether the obtained terminal online rate index is reasonable according to the preset condition comprises any one or any combination of the following steps:

checking whether the terminal online rate index is greater than 0 and less than or equal to 1;

checking whether the daily-to-annular ratio fluctuation of the online times of the terminal is within a preset range;

checking whether the daily-to-annular ratio fluctuation of the terminal online rate index is within a preset range;

checking whether the actual online times of the full-caliber terminal are equal to the sum of the actual online times of the terminal of the direct supply straight pipe and the actual online times of the terminal of the county-level subsidiary company, and whether the online times of the full-caliber terminal are equal to the sum of the online times of the terminal of the direct supply straight pipe and the online times of the terminal of the county-level subsidiary company;

checking whether the actual online times of the terminals in each month are equal to the sum of the actual online times of the terminals on all days in the corresponding month, and whether the online times of the terminals in each month are equal to the sum of the online times of the terminals on all days in the corresponding month;

and if the corresponding conditions are met, determining that the terminal online rate index is reasonable, otherwise, determining that the terminal online rate index is unreasonable.

8. The method for monitoring the terminal online rate index based on the metering automation system as claimed in claim 6, wherein the step of checking whether the obtained terminal online rate index is reasonable according to the preset condition comprises:

checking whether the actual online times of the terminals in each month are equal to the sum of the actual online times of the terminals of all suppliers in the corresponding month, and whether the online times of the terminals in each month are equal to the sum of the online times of the terminals of all suppliers in the corresponding month;

9. A monitoring device for terminal on-line rate index based on measurement automation system is characterized by comprising:

the system comprises a file acquisition module, a file processing module and a file processing module, wherein the file acquisition module is used for acquiring a file which is uploaded by a metering automation system and named in a preset format, and the file stores the actual online times of a terminal and the times that the terminal should be online; the terminal online times are the product of the terminal number and the sampling times;

the integrity check module is used for carrying out integrity check on the file according to the name of the file; the file name comprises data time, generation time and a sequence number; the data time is the time of the data in the file; the generation time is the system time when the file is generated; setting the file to be automatically generated at a corresponding first preset time, and automatically uploading the file at a corresponding second preset time; the second preset time is later than the first preset time; wherein the step of performing integrity check on the file according to the file name comprises:

checking whether the data time of the file is a preset data time;

or the like, or, alternatively,

when detecting the selected operation of the corresponding file when the number of the files is determined to be complete according to the work order, determining that the corresponding file passes the integrity check;

10. The metering-automation-system-based terminal-on-line rate indicator monitoring device of claim 9,

the file also comprises a monthly first online rate file; the naming of the monthly first online rate file comprises: region unit coding, file identification of online rate index, generation time, uploading mark, month, data time, online rate, sequence number and file format; the first monthly online rate file is automatically generated at the first preset time of the Nth day of each month, and is automatically uploaded at the second preset time of the Nth day of each month, wherein N is a fixed value;

the document also includes a first vendor monitoring document; the first vendor monitoring naming of files comprises: region unit coding, file identification of online rate index, generation time, uploading mark, month, data time, supplier, sequence number and file format; the first supplier monitoring file is automatically generated at the first preset time of the Nth day of each month, and is automatically uploaded at the second preset time of the Nth day of each month, wherein N is a fixed value;

the first supplier monitoring file or the second supplier monitoring file also stores a communication manufacturer and a communication manufacturer code; the data item checking module is also used for checking whether a communication manufacturer and a communication manufacturer code stored in the file are not empty at the same time when the file is a first supplier monitoring file or a second supplier monitoring file; and the online rate index obtaining module obtains the terminal online rate index according to the actual terminal online times and the terminal online times stored in the file when the actual terminal online times and the terminal online times stored in the file are not null and the communication manufacturer code stored in the file are not null at the same time.