CN103996279B - Automatic acquisition method for electricity consumption information of users - Google Patents
Automatic acquisition method for electricity consumption information of users Download PDFInfo
- Publication number
- CN103996279B CN103996279B CN201310753295.5A CN201310753295A CN103996279B CN 103996279 B CN103996279 B CN 103996279B CN 201310753295 A CN201310753295 A CN 201310753295A CN 103996279 B CN103996279 B CN 103996279B
- Authority
- CN
- China
- Prior art keywords
- palm machine
- dbf
- client computer
- infrared palm
- infrared
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 33
- 230000005611 electricity Effects 0.000 title abstract description 8
- 238000004891 communication Methods 0.000 claims abstract description 7
- 238000001514 detection method Methods 0.000 claims description 15
- 238000013480 data collection Methods 0.000 claims description 14
- 230000008859 change Effects 0.000 claims description 8
- 238000006243 chemical reaction Methods 0.000 claims description 2
- 235000013399 edible fruits Nutrition 0.000 claims 1
- 238000004321 preservation Methods 0.000 claims 1
- 230000008569 process Effects 0.000 abstract description 5
- 238000010586 diagram Methods 0.000 description 5
- 238000009434 installation Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 238000013459 approach Methods 0.000 description 2
- 210000004556 brain Anatomy 0.000 description 2
- 230000002452 interceptive effect Effects 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000000052 comparative effect Effects 0.000 description 1
- 230000006835 compression Effects 0.000 description 1
- 238000007906 compression Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000011045 prefiltration Methods 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
Landscapes
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses an automatic acquisition method for electricity consumption information of users, which belongs to the technical field of smart power grids. The method comprises the following steps: automatically detecting and installing an infrared hand-held console; converting to-be-downloaded data into a database file DBF in the format of dBaseIII supported by the infrared hand-held console; and uploading the database file DBF to a server from a client computer and storing the database file DBF, or downloading the database file DBF to the client computer and storing the database file DBF in the infrared hand-held console. The method provided by the invention is directed at a series of problems like poor carrier communication signals and unsmooth GPRS channels of a traditional acquisition system, fully utilizes related subject theories like an SSH framework and intelligent identification, integrates the infrared hand-held console into an acquisition system, allows DBF files in the format of dBaseIII to be generated from failed electricity consumption information of users by using an HWZJ module and finally writes electricity consumption information of users into a database through process flow consisting of downloading, reading, parsing, etc., thereby realizing intelligentization and automation of an electrical power system.
Description
Technical field
The present invention relates to intelligent power grid technology field, more particularly to a kind of method of automatic data collection user power utilization information.
Background technology
With China intelligent grid study gradually deeply, client to the accuracy of power information, real-time, interactive carry
Requirement very high is gone out, to realizing the collection completely of power information and being completely covered.Power information acquisition system is to realize electricity
The interactive basis of net, is also that grid company manages the foundation that power consumer in region settles accounts the electricity charge.Electric power in face of magnanimity is used
Family information, write into Databasce after the completion of automatically and quickly user profile is gathered, realize power consumer " all standing is gathered entirely
Control in full " is most important.
State Grid Corporation of China is in order to realize the target of " all standing gathers control in full entirely ", and the power information collection system for proposing
System.With the main website part of telecommunications system acquisition system can be divided into WEB layers, interface layer, database layer, prefilter layer, gateway layer.It is existing
Power information acquisition system due to the influence of the objective condition such as communication channel problem, carrier communication situation difference, be extremely difficult to state
The design object of net.At present, the relatively good provincial company done, collection success rate is 95% or so.
The content of the invention
In view of this, it is an object of the invention to provide a kind of method of automatic data collection user power utilization information, for improving
The efficiency of power information automatic data collection.
The invention provides a kind of method of automatic data collection user power utilization information, including：
By reading infrared palm machine numbering automatic detection and installing infrared palm machine, the data conversion of lower dress into infrared palm will be treated
The database file DBF of the dBaseIII forms that machine is supported；The DBF files are uploaded onto the server upper guarantor from client computer
Deposit, and DBF file warehousing flags are set；Or by the DBF file downloads to client computer, and it is stored in infrared palm
Machine.
The invention provides a kind of infrared palm machine integrated approach based on SSH frameworks, realize power consumer " all standing is complete
Gather control in full ".For traditional acquisition system because multicarrier communication signal is poor, a series of problems, such as GPRS passages are not smooth, fully
Theoretical using related disciplines such as SSH frameworks, Intelligent Recognitions, be integrated into infrared palm machine in acquisition system, will gather by independent research
The power consumer information of failure generates the DBF files of dBaseIII forms by HWZJ modules, by lower dress, copy reading, parsing etc.
Flow, most user profile is written in database at last, realizes the intellectuality and automation of power system.After using this method,
Automatic data collection success rate is more than 99.8%.
Brief description of the drawings
Fig. 1 is a kind of method flow diagram of automatic data collection user power utilization information provided in an embodiment of the present invention；
Fig. 2 is the method flow diagram of automatic detection and installation infrared palm machine in the embodiment of the present invention；
Fig. 3 is the method flow diagram of lower dress DBF files in the embodiment of the present invention；
Fig. 4 is the method flow diagram of upload DBF files in the embodiment of the present invention.
Specific embodiment
To make the object, technical solutions and advantages of the present invention clearer, further is made to the present invention below in conjunction with the accompanying drawings
Detailed description.
As the important supplement means of power information acquisition system, the embodiment of the invention provides a kind of based on SSH frameworks
Infrared palm machine integrated approach, realize " all standing gathers control in full entirely " of power consumer.For traditional acquisition system because of carrier wave
Signal of communication is poor, a series of problems, such as GPRS passages are not smooth, makes full use of the related disciplines such as SSH frameworks, Intelligent Recognition theoretical,
Be integrated into infrared palm machine in acquisition system by independent research, and the power consumer information for gathering failure is generated by HWZJ modules
The DBF files of dBaseIII forms, by flows such as lower dress, copy reading, parsings, most user profile is written in database at last,
Realize the intellectuality and automation of power system.After this method, automatic data collection success rate is more than 99.8%.
Fig. 1 is a kind of method flow diagram of automatic data collection user power utilization information provided in an embodiment of the present invention, including following
Step：
Step 101, automatic detection and installation infrared palm machine.Infrared palm machine is adopting for power information acquisition system gathered data
Collection equipment, can be used to gather the equipment such as ammeter, water meter, gas meter.Fig. 2 is automatic detection and the method stream for installing infrared palm machine
Cheng Tu, including：
Whether step 1011, automatic detection client computer access infrared palm machine, when user opens the infrared palm machine page,
HWZJ modules（Infrared palm machine communication management module）Reading infrared palm machine numbering order will be sent, reading order successfully will be prompted to red
Outer palm machine is successfully accessed prompting, otherwise points out access failure.
The technology that HWZJ modules are used in itself is all the scheme of comparative maturity, and its function includes：Automatic detection is simultaneously pacified
Whether dress client installs newest infrared palm machine driver；It is automatic to generate failure file of checking meter in server end；Automatically will copy
Transmission of the table failure file from server end to client；Automatically the successfully file of checking meter of client is transferred to server end,
And write into Databasce.Its operation principle is：HWZJ modules are B/S structures, realize setting the storage such as database, file, excel
Data in standby, change into the DBF files that infrared palm machine is capable of identify that, by upload and download function, this file are issued to
Infrared palm machine is uploaded onto the server.
Whether step 1012, automatic detection client computer install infrared palm machine driving, HWZJ module applications ActiveX controls
Part, infrared palm machine is driven and downloads to client computer.By changing the numbering that infrared palm machine drives（The volume that infrared palm machine drives
Number it is that, by Version Control, the driving of each version only has unique number, so passing through identiflication number, it is possible to determine that version is believed
Breath）, it is possible to achieve infrared palm machine driving is automatically updated, automatically updating step includes：Whether client computer detection service device end
There is more new file；If updating, client computer will automatically be downloaded and replace server end and drive file, restart client electricity
Brain, client computer normally runs；If do not updated, client computer normally runs.This step is to update to drive file, more
New method is exactly first to confirm whether client file is newest driving, if it is not, just by the driving file of client
Delete, newest driving file is then write client.
Infrared palm machine is downloaded to client computer by step 1013, automatic installation infrared palm machine driver, HWZJ modules
Afterwards, driver is installed by infrared palm machine automatically.
Step 1014, automatic installation infrared palm machine signal procedure, HWZJ modules download infrared palm machine signal procedure in the lump
To client computer, such that it is able to realize being interacted with infrared palm machine.Signal procedure is used to for driver to be put into specified location,
Infrared palm machine signal procedure will download to client in step 1012, and this step is exactly that the infrared palm machine of client communicates
Process in program write-in infrared palm machine.
Step 102, the DBF for generating and parsing dBaseIII forms（Database file）File.The step is will will
The data of lower dress（No matter the data source of under band dress data is file, database, excel etc.）, infrared palm machine will be changed into
The DBF files of the dBaseIII forms of support.In other words, the DBF files of dBaseIII forms are exactly the database of infrared palm machine,
Data are issued for storing.Parsing DBF files and generation DBF files function and significance be it is opposite, parsing DBF files be by
The DBF files of the dBaseIII forms that infrared palm machine is supported are converted into other data（Including file, database, excel etc.）.
The DBF files of dBaseIII forms are generated, according to the actual requirements（Such as lower dress data need failure information of checking meter,
Just form the download file of failure of checking meter；Failure information is recruited if necessary to mend, the download file mended and recruit failure is just formed）, lower dress
Data will generate the DBF files of dBaseIII forms by HWZJ modules.User using infrared palm machine fails automatic data logging
User profile, and choose and need the user profile of infrared palm machine copy reading by HWZJ module polls out, then by HWZJ moulds
Block generates the DBF files of dBaseIII forms, is stored in service end.Generation and parsing DBF files are that source data is compiled into DBF
One two-way process of the target data of file, generation and analytic method are a reciprocal methods, that is, it is main website to generate DBF files
The task of checking meter for issuing, and it is the assignment file of checking meter that palm machine is uploaded to parse DBF files.Generate data process be by using
Application module in program, data flow is read from internal memory, the binary stream according to required for specification forms DBF.Parsing number
According to process be the form that translates the file into data flow, be put into internal memory so that the later stage uses.
The DBF files of dBaseIII forms are parsed, according to the actual requirements, uploading data will be parsed by HWZJ modules
The DBF files of dBaseIII forms.DBF files after infrared palm machine copy reading are parsed displaying by user by HWZJ modules
To user, while entering database.
Step 103, lower dress and upload DBF files.Upload and the main cause of lower dress DBF files is that infrared palm machine is to connect
On client computer, the DBF information of generation is very random, and for the ease of management DBF files, the present embodiment preserves DBF files
On the server, then download on client computer again, and be stored in infrared palm machine again.And DBF files are uploaded, being exactly will
On DBF uploads onto the server from client computer.
As shown in figure 3, the step of lower dress includes：
Step 1031, infrared palm machine access client computer, log in HWZJ modules.Infrared palm machine accesses client computer
Afterwards, if logging in HWZJ modules first, HWZJ modules are by the CAB bags in ActiveX control（The compression that Microsoft is worked out
Bag form, is usually used in the installation procedure of software）Client computer is downloaded to from server end.The concrete function of CAB bags is to treat
The file of upgrading, by CAB bands to client, then updating client.Whether automatic detection infrared palm machine accesses client electricity
Whether brain, client computer have infrared palm machine driver etc..
Step 1032, using infrared palm machine user inquire about check meter unsuccessfully（Can also be according to specific business demand）Data.
It is manually entered check meter segment number and date.
Step 1033, by HWZJ modules, generated in server end and preserve DBF files.The generation that step 102 is mentioned
DBF files generate DBF files merely by module, do not point out that this file will be saved in client or server end,
And this step then indicates that generation DBF files are saved in server end.
Step 1034, judge whether to check meter full detail unsuccessfully（Can also be according to specific business demand）Under be attached to it is infrared
Palm machine, if it is, infrared palm machine will be attached under DBF files；The information that otherwise choosing needs lower dress is checked meter unsuccessfully（Can also root
According to specific business demand）, HWZJ modules change DBF files automatically, in the DBF files for having generated, increase or delete number
According to.
Step 1035, infrared palm machine are transferred to.
As shown in figure 4, the step of uploading includes：
Step 1031 ', infrared palm machine accesses and client computer and logs in HWZJ modules.Infrared palm machine accesses client computer
Afterwards, if logging in HWZJ modules first, the CAB bags in ActiveX control are downloaded to client by HWZJ modules from server end
End computer.Whether automatic detection infrared palm machine accesses whether client computer, client computer have infrared palm machine driver etc..
Step 1032 ', by the DBF files passes in infrared palm machine to server end.
Step 1033 ', will upload DBF file write datas storehouse.
Step 1034 ', the failure information of checking meter judged in DBF files（Can also be according to specific business demand）Whether pass through
Manual change, if it is, modification DBF file warehousing flags；Do not change otherwise.For the demand of business, infrared palm machine is carried
For two kinds of typing modes：It is manually entered and is automatically entered with infrared, if if automatically entering, data validity just occurs
Problem, so needing to make a decision typing mode.The method of judgement is that, by HWZJ module automatic decisions, those data are to add by hand
Plus data, or automatic data logging data.
Step 1035 ', infrared palm machine query page show checking meter unsuccessfully in the DBF files changed（Can also basis
Specific business demand）Information.
Step 1036 ', infrared palm machine extract.
HWZJ modules in the present embodiment use the realization of SSH frameworks.The present embodiment can support different manufacturers
Infrared palm machine（Because infrared palm machine is including copying water meter, ammeter, gas meter etc.）Checked meter.
In a word, presently preferred embodiments of the present invention is the foregoing is only, is not intended to limit the scope of the present invention.
Claims (4)
1. a kind of method of automatic data collection user power utilization information, it is characterised in that including：
By reading infrared palm machine numbering automatic detection and installing infrared palm machine, the generation simultaneously parses dBaseIII forms
DBF Files steps are the database file DBF that will treat the dBaseIII forms that the data conversion of lower dress is supported into infrared palm machine；
The DBF files for generating dBaseIII forms are specially：According to the actual requirements, treat that lower dress data will be generated by HWZJ modules
The DBF files of dBaseIII forms；The DBF files for parsing dBaseIII forms are specially：According to the actual requirements, uploading data will
Parsed by HWZJ modules；Actual demand is specially to be formed if lower dress data need to check meter failure information and checks meter under failure
Dress file；
The DBF files are uploaded onto the server upper preservation from client computer, and DBF file warehousing flags are set；Or will
The DBF file downloads are stored in infrared palm machine on client computer；
It is described by DBF file downloads to client computer the step of specifically include：Infrared palm machine accesses client computer and logs in
HWZJ modules, miss data of checking meter is inquired about using the user of infrared palm machine；By HWZJ modules, generate and preserve in server end
The DBF files of the miss data of checking meter；Judge whether that infrared palm machine will be attached under miss data of all checking meter, if it is,
Infrared palm machine will be attached under DBF files；Otherwise choosing needs the miss data of checking meter of lower dress, and HWZJ modules change DBF texts automatically
Part, in the DBF files for having generated, increases or deletes data；Infrared palm machine is transferred to；
It is described by DBF files from client computer upload onto the server on step specifically include：Infrared palm machine accesses client
Computer simultaneously logs in HWZJ modules, by the DBF files passes in infrared palm machine to server end
And the database at write service device end；Whether the failure information of checking meter in the DBF files is judged by manual change, such as
Fruit is then to change DBF file warehousing flags；Do not change otherwise；The DBF files changed are shown in infrared palm machine query page
In failure information of checking meter；Infrared palm machine is extracted.
2. the method for automatic data collection user power utilization information according to claim 1, it is characterised in that the automatic detection and
The step of installing infrared palm machine specifically includes：
When user opens the infrared palm machine page in client computer, it is infrared that infrared palm machine communication management module HWZJ sends reading
Palm machine numbering order, reading order successfully will be prompted to infrared palm machine and be successfully accessed prompting；Otherwise prompting access failure；
Whether automatic detection client computer installs newest infrared palm machine drives, if it is not, by newest infrared palm machine
Driving downloads to client computer and runs, and the infrared palm machine is installed automatically and is driven；Simultaneously by under infrared palm machine signal procedure
It is downloaded to client computer and installs automatically.
3. the method for automatic data collection user power utilization information according to claim 2, it is characterised in that described to install red automatically
The step of outer palm machine drives specifically includes：
Whether client computer detection service device end has the more new file that infrared palm machine drives, if it has, client computer will be from
It is dynamic to download and replace driving file, restart client computer, client computer normally runs；Otherwise client computer is normally transported
OK.
4. the method for automatic data collection user power utilization information according to claim 1, it is characterised in that the infrared palm machine connects
Further included after entering client computer：
If logging in HWZJ modules first, the CAB bags in ActiveX control are downloaded to client by HWZJ modules from server end
End computer；And whether automatic detection infrared palm machine accesses client computer, and whether client computer has infrared palm machine to drive
Program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310753295.5A CN103996279B (en) | 2013-12-31 | 2013-12-31 | Automatic acquisition method for electricity consumption information of users |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310753295.5A CN103996279B (en) | 2013-12-31 | 2013-12-31 | Automatic acquisition method for electricity consumption information of users |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103996279A CN103996279A (en) | 2014-08-20 |
| CN103996279B true CN103996279B (en) | 2017-05-24 |
Family
ID=51310429
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310753295.5A Active CN103996279B (en) | 2013-12-31 | 2013-12-31 | Automatic acquisition method for electricity consumption information of users |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103996279B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101478574A (en) * | 2009-01-21 | 2009-07-08 | 深圳职业技术学院 | Remote monitoring system based on B/S structure and method thereof |
| CN101840530A (en) * | 2008-10-09 | 2010-09-22 | 北京农业信息技术研究中心 | Management method and system of farming information collection and safe production of fruit-and-vegetable agricultural products |
| CN202976179U (en) * | 2012-11-28 | 2013-06-05 | 无锡扬晟科技有限公司 | Safety management system based on Internet of things technology |
| CN103177327A (en) * | 2012-10-18 | 2013-06-26 | 海宁市供电局 | Comprehensive management system for low-voltage power operations based on B/S (browser/server) and C/S (client/server) architectures |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB2364484B (en) * | 2000-06-30 | 2004-10-13 | Nokia Mobile Phones Ltd | Apparatus and methods for a client server system |
| KR100874270B1 (en) * | 2008-03-19 | 2008-12-16 | 주식회사 패턴플랜트 | Contents providing system with transcoding video contents |
-
2013
- 2013-12-31 CN CN201310753295.5A patent/CN103996279B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101840530A (en) * | 2008-10-09 | 2010-09-22 | 北京农业信息技术研究中心 | Management method and system of farming information collection and safe production of fruit-and-vegetable agricultural products |
| CN101478574A (en) * | 2009-01-21 | 2009-07-08 | 深圳职业技术学院 | Remote monitoring system based on B/S structure and method thereof |
| CN103177327A (en) * | 2012-10-18 | 2013-06-26 | 海宁市供电局 | Comprehensive management system for low-voltage power operations based on B/S (browser/server) and C/S (client/server) architectures |
| CN202976179U (en) * | 2012-11-28 | 2013-06-05 | 无锡扬晟科技有限公司 | Safety management system based on Internet of things technology |
Non-Patent Citations (1)
| Title |
|---|
| 手持PDA抄表终端系统的设计与实现;夏丹;《中国优秀硕士学位论文全文数据库工程科技II辑》;20090515(第5期);C042-330页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103996279A (en) | 2014-08-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103941675B (en) | Safety monitoring based on wireless network manages system | |
| CN102637203B (en) | Method for processing electric quantity data and monitoring master station for automatic electric energy metering systems | |
| CN103592907B (en) | A kind of Ethernet Data Acquisition System | |
| CN107909300A (en) | Intelligent plant management platform and method | |
| CN103955783A (en) | Low-voltage carrier wave installation site information collecting method | |
| CN104408050A (en) | Online automatic interpretation system and method of test data | |
| CN102567412A (en) | Method for processing computer-assisted network load analysis information | |
| CN106843908A (en) | Data integrated collection method and system | |
| CN102209118A (en) | Distributed mass data gathering method | |
| CN202873069U (en) | Test and verification device for Internet of things (IOT) | |
| CN114449018B (en) | Automatic log file uploading method and system for power acquisition terminal | |
| CN104599338A (en) | Cloud computing based attendance managing system | |
| CN105608382A (en) | Software maintenance method, software problem judgment method and corresponding apparatuses | |
| CN107301498A (en) | Generalized information management system for the military service monitoring of high-speed railway wheel rail relation | |
| CN103218680A (en) | Data analysis and decision making system of water enterprise | |
| CN103996279B (en) | Automatic acquisition method for electricity consumption information of users | |
| CN103227829A (en) | System for managing rail vehicle operation control information | |
| CN103569421A (en) | Data collection and analysis device for cigarette packing machine | |
| CN108400899A (en) | A kind of remote update system and method for FPGA | |
| CN208210013U (en) | Vibration analysis system based on things-internet gateway edge calculations | |
| CN111105202A (en) | Equipment management system | |
| CN106406856A (en) | Standalone one-key automatic deployment method for Oracle | |
| CN109507922B (en) | Port data acquisition method based on intelligent Internet of things | |
| CN102231197B (en) | Semantic type report implementation framework structure based on double-layer structure | |
| CN202837930U (en) | Process storage and output device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |