CN101150468A - A data collection and electronic recording system and its data collection and recording method - Google Patents
A data collection and electronic recording system and its data collection and recording method Download PDFInfo
- Publication number
- CN101150468A CN101150468A CNA2007100475265A CN200710047526A CN101150468A CN 101150468 A CN101150468 A CN 101150468A CN A2007100475265 A CNA2007100475265 A CN A2007100475265A CN 200710047526 A CN200710047526 A CN 200710047526A CN 101150468 A CN101150468 A CN 101150468A
- Authority
- CN
- China
- Prior art keywords
- equipment
- data
- data acquisition
- computer
- programmable controller
- 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.)
- Pending
Links
Images
Landscapes
- General Factory Administration (AREA)
Abstract
The invention relates to a data acquisition and electronic recording system, which includes device 1, device 2, device 3 to device N and the serial communications interfaces. device 1, device 2, device 3 to device N are respectively connected to the serial communications interfaces, which is characterized in that every serial communications interface is connected to a router through an Ethernet interface, and the router is connected to a computer. The data acquisition and recording method is to switch on the computer and connect the computer to the physical addresses of the programmable controller for every device in order to develop a data zone for every device and to create the communications daemon by embedding the driver for the programmable controller according to the definition. The computer acquires the operating data for every device and puts the operating data in the corresponding zone as the acquired data is finally stored in the database. The invention has the advantage that the invention ensures that the pharmaceutical and food processing companies operate all machinery equipment supplied by different suppliers in an on-line manner, while data acquisition and recording can be performed.
Description
Technical field
The present invention relates to a kind of data acquisition and electronic recording system and data acquisition-and-recording method thereof, relate in particular to a kind of data acquisition and electronic recording system and data acquisition-and-recording method thereof, belong to the data acquisition-and-recording technical field at manufacturing and processing enterprise's setting of all kinds of pharmacy and food.
Background technology
Equipment in pharmacy and the food production processing enterprise is provided by each professional equipment manufacturer, finally forms on line.Provide different equipment just because of different equipment suppliers, the control system that they adopt also is not quite similar, as PLC Mitsubishi is arranged, the Omron, Siemens, the brand that Panasonic or the like is not following tens kinds, a kind of brand comprises tens kinds of models again, and the PLC of these brands has different communications protocol, most of manufacturers are to underground again its communication format of these communications protocol and regulation, make that the user wants the PLC with brand or different brands is coupled together, the all devices that is about on the production line couples together, realize sharing of centralized control and data, very difficulty.
Current, all there be complete production management system and the data record standard of a cover in all kinds of pharmaceutical factories by the GMP authentication.Just with the product of a lot number, finish the Various types of data that this batch production task produced and have thousands of, can carry out the collection and the exchange of data and write down the most at present equipment that also rests on hand-kept or single device or many same suppliers of these data, print again by artificial synthetic binding into book form, form the production management file.In process of production, the manager is if need a certain real time data of inquiry, often needing to employ many resources just can obtain, waste time and energy, and be difficult for observing continuously and intercepting, caused enterprise to obtain these data necessary can only adopt the method that artificially collects, wasted time and energy, and be not easy to management and share.
Summary of the invention
The purpose of this invention is to provide and a kind ofly pharmacy can be carried out online data acquisition and electronic recording system and data acquisition-and-recording method thereof with the equipment that all different manufacturers in the food production processing enterprise provide.
For realizing above purpose, technical scheme of the present invention provides a kind of data acquisition and electronic recording system, it is characterized in that, comprise first equipment, second equipment, the 3rd equipment ... N equipment and serial communication interface, first equipment, second equipment, the 3rd equipment ... N equipment programmable controller separately is connected with serial communication interface respectively, it is characterized in that each serial communication interface is connected with router by Ethernet interface, router is connected with computer.
Described first equipment, second equipment, the 3rd equipment ... the equipment that N equipment provides for different manufacturers, and having a programmable controller that different manufacturers oneself are equipped with, programmable controller has Siemens, Panasonic, Mitsubishi, Omron, Delta, grand or the like forever.
Described serial communication interface is 485 communication interfaces or RS232 communication interface.
A kind of data acquisition and electronic recording system data acquisition-and-recording method is characterized in that, use delphi language compilation software, and operation the steps include: on computers
The first step. drive computer, first equipment, second equipment, the 3rd equipment that the definition computer connects ... the physical address of the programmable controller in the N equipment;
Second step. be first equipment, second equipment, the 3rd equipment ... N equipment is opened up a data field respectively, for reading first equipment, second equipment, the 3rd equipment ... the service data of N equipment is as temporary;
The 3rd step. according to the driver of definition embedding programmable controller, create the communication process;
The 4th step. computer is gathered first equipment, second equipment, the 3rd equipment respectively ... the service data of N equipment is in pairing data field;
The 5th step. the order of collection is to scan successively by the physical address that defines, and collected data finally leave in the database, generate required figure and form.
The present invention utilizes the existing hardware switch technology, programmable controller with different model, the production of different manufacturer, original serial communication interface, be converted to the communication interface of Ethernet, simultaneously with the various kinds of sensors signal of workshop synergic system, as temperature, humidity, room pressure reduction etc., also be converted to the Industrial Ethernet interface, making equipment in the whole workshop and various kinds of sensors form one like this is the Local Area Network of core with the Industrial Ethernet.Thereby the communication modes that makes whole system belongs to unified communication format with Ethernet.By the conversion of hardware, the explanation of software can be carried out all devices in pharmacy and the food production processing enterprise onlinely, and this cans be compared to allows everybody all speak standard Chinese pronunciation, thereby makes everyone can both " understand " various dialects.
Configuration software of the present invention is an operating platform, it can be come in the real time data acquisition that each equipment is given different IP addresses, also can come in the real time data acquisition of each transducer, and these data are made form and the figure that the various GMP of meeting administrative institute needs on request, in real time these forms and figure have been placed on the gerentocratic desktop, these data forms and figure have also just left in the great memory of computer simultaneously, inquire about at any time and manage for the manager.Realized docking by a computer (PC) and whole workshop.As need each workshop of whole plant area is combined into a network, for administrator administers, that is just very convenient.Invest under the situation of hardware engineering not needing, utilize network can realize the networking of full factory, realize sharing and exchange of data resource.
Advantage of the present invention is:
1. the authenticity of data and continuity
By the data of system acquisition, changed the mode of manual process in the past, not only can obtain the approval of authoritative department, also for the manager provides basic parameter accurately, a large amount of artificial ledgers also will be replaced by the memory that calculates;
2. the visuality of production link
Different managers can observe the basic condition that each production link is moving in real time by network authorization system, and no matter where the manager is in;
3. the trackability of Various types of data
Owing to the data in all previous batch of production process all are stored in the computer, modes such as the manager can inquire about by lot number, time inquiry, equipment query, can reappear the whole parameters in the original batch production process, make the data form of equipment, or form graph curve;
4. human resources have been saved
Because data all are stored in the computer by backup, call, bind into file as need, only need less personnel, can finish the work that originally takes time and effort;
5. a spot of on-the-spot retrofit work
Owing to be the control system of utilizing existing equipment, transforming just increases a communication interface, thus to the function of original equipment without any influence, expense is also just very low;
6. on-the-spot input, electronic signature
The operator is by on-the-spot input, with the lot number of current device operation, zero-time, deadline or the like parameter, is pooled to the database of system, and final " label " go up operator's " name ", thereby " system of real name " of assurance running.
Description of drawings
Fig. 1 is a kind of data acquisition and electronic recording system structural representation;
Fig. 2 is a kind of data acquisition and electronic recording system data acquisition-and-recording program flow diagram.
Embodiment
The invention will be further described below in conjunction with drawings and Examples.
Embodiment
With certain pharmaceutical factory workshop five equipment being arranged is example:
As shown in Figure 1, be a kind of data acquisition and electronic recording system structural representation, described a kind of data acquisition and electronic recording system are made up of first equipment 1, second equipment 2, the 3rd equipment 3, the 4th equipment 4 and the 5th equipment 5 and serial communication interface, Ethernet interface, router and computer.
The programmable controller 1 of first equipment 1 adopts Siemens's programmable controller, the programmable controller 2 of second equipment 2 adopts Panasonic's programmable controller, the programmable controller 3 of the 3rd equipment 3 adopts Mitsubishi's programmable controller, the programmable controller 4 of the 4th equipment 4 adopts the Omron programmable controller, the programmable controller 5 of the 5th equipment 5 adopts grand forever programmable controller, at first these five kinds of model programmable controllers are connected with serial communication interface respectively, each serial communication interface is converted to the interface of Ethernet respectively, these five Ethernet interfaces are linked on the router, and router is connected with computer.
Use delphe language compilation software, operation on computers, after computer powers on, define the physical address of these five programmable controllers respectively, be about to Siemens's programmable controller and be decided to be 100, Panasonic's programmable controller is decided to be 101, Mitsubishi's programmable controller is decided to be 102, the Omron programmable controller is decided to be 103, grand forever programmable controller is decided to be 104, for equaling 100 to 104 equipment, the address opens up five data fields then as temporary, again by Siemens, Panasonic, Mitsubishi, the Omron, the grand forever driver that embeds their special uses along the program of controller able to programme, software of the present invention just scans these equipment successively according to this order, as long as these equipment are in running status, native system just can collect the corresponding data of these equipment.These data generate user required all kinds of forms and figure automatically, and for good and all leave in the memory of computer through handling, and call and inquire about for the manager at any time.
The present invention can make up the technological process in various different workshops, forms the subtype and the data form that meet user's needs.Simultaneity factor is made up of two cover computer backups, and when a cover computer went wrong, the second cover computer replaced automatically, guarantees the continuity and the fail safe of data acquisition.
Claims (4)
1. data acquisition and electronic recording system, comprise first equipment (1), second equipment (2), the 3rd equipment (3) ... N equipment (N) and serial communication interface, first equipment (1), second equipment (2), the 3rd equipment (3) ... N equipment (N) programmable controller separately is connected with serial communication interface respectively, it is characterized in that, each serial communication interface is connected with router by Ethernet interface, and router is connected with computer.
2. a kind of data acquisition according to claim 1 and electronic recording system, it is characterized in that, described first equipment (1), second equipment (2), the 3rd equipment (3) ... the equipment that N equipment (N) provides for different manufacturers, and have the programmable controller that different manufacturers oneself are equipped with.
3. a kind of data acquisition according to claim 1 and electronic recording system is characterized in that, described serial communication interface is 485 communication interfaces or RS232 communication interface.
4. a kind of data acquisition according to claim 1 and electronic recording system data acquisition-and-recording method is characterized in that, use delphe language compilation software, and operation the steps include: on computers
The first step. drive computer, with first equipment (1), second equipment (2), the 3rd equipment (3) of computer connection ... the physical address of the programmable controller in the N equipment (N);
Second step. be first equipment (1), second equipment (2), the 3rd equipment (3) ... N equipment (N) is opened up a data field respectively, for reading first equipment (1), second equipment (2), the 3rd equipment (3) ... the service data of N equipment (N) is as temporary;
The 3rd step. according to the driver of definition embedding programmable controller, create the communication process;
The 4th step. computer is gathered first equipment (1), second equipment (2), the 3rd equipment (3) respectively ... the service data of N equipment (N) is in pairing data field;
The 5th step. the order of collection is to scan successively by the physical address that defines, and collected data finally leave in the database, generate required figure and form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007100475265A CN101150468A (en) | 2007-10-29 | 2007-10-29 | A data collection and electronic recording system and its data collection and recording method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007100475265A CN101150468A (en) | 2007-10-29 | 2007-10-29 | A data collection and electronic recording system and its data collection and recording method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101150468A true CN101150468A (en) | 2008-03-26 |
Family
ID=39250819
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2007100475265A Pending CN101150468A (en) | 2007-10-29 | 2007-10-29 | A data collection and electronic recording system and its data collection and recording method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101150468A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102184336A (en) * | 2011-05-27 | 2011-09-14 | 成都欧林生物科技股份有限公司 | Method and system for GMP (Good Manufacturing Practice) validation automation in pharmaceutical industry |
| CN107465620A (en) * | 2017-08-03 | 2017-12-12 | 爱普（福建）科技有限公司 | A kind of conventional data router and its communication means |
| CN108132642A (en) * | 2017-12-25 | 2018-06-08 | 天津百利机械装备集团有限公司中央研究院 | PLC control panel process data loggers |
| CN112034794A (en) * | 2020-08-12 | 2020-12-04 | 重庆华森制药股份有限公司 | Automatic production control system and method for kumquat ice plum slices |
-
2007
- 2007-10-29 CN CNA2007100475265A patent/CN101150468A/en active Pending
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102184336A (en) * | 2011-05-27 | 2011-09-14 | 成都欧林生物科技股份有限公司 | Method and system for GMP (Good Manufacturing Practice) validation automation in pharmaceutical industry |
| CN107465620A (en) * | 2017-08-03 | 2017-12-12 | 爱普（福建）科技有限公司 | A kind of conventional data router and its communication means |
| CN107465620B (en) * | 2017-08-03 | 2020-07-10 | 爱普（福建）科技有限公司 | General data router and communication method thereof |
| CN108132642A (en) * | 2017-12-25 | 2018-06-08 | 天津百利机械装备集团有限公司中央研究院 | PLC control panel process data loggers |
| CN112034794A (en) * | 2020-08-12 | 2020-12-04 | 重庆华森制药股份有限公司 | Automatic production control system and method for kumquat ice plum slices |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Lins et al. | Industry 4.0 Retrofitting | |
| CN102929911B (en) | Substation and scheduling station method of integrated modeling | |
| US7650196B2 (en) | Production monitoring and control system having organizational structure-based presentation layer | |
| US7672737B2 (en) | Hierarchically structured data model for utilization in industrial automation environments | |
| EP1364259B1 (en) | A method and apparatus for generating an application for an automation control system | |
| US7650405B2 (en) | Tracking and tracing across process boundaries in an industrial automation environment | |
| CN1937559B (en) | Proxy server for integration of industrial automation data over multiple networks | |
| Drath et al. | An evolutionary approach for the industrial introduction of virtual commissioning | |
| CN101553763A (en) | Hierarchically structured data model for utilization in industrial automation environments | |
| AU5355999A (en) | Distributed automation system | |
| EP3779623A1 (en) | A system for generation of a holistic digital twin | |
| CN101150468A (en) | A data collection and electronic recording system and its data collection and recording method | |
| CN107071013A (en) | A kind of the service response method and service system of intelligent substation access regulation and control main website | |
| CN106094775A (en) | A kind of cutting production line long distance control system | |
| CN104766107A (en) | System utilizing RFID electronic product code to collect data in BIM | |
| KR102371120B1 (en) | Advanced Operation Method for Industrial Process Equipment System using AutomationML to OPC UA Industry Standard | |
| CN105868410A (en) | Model-driven intelligent SCD (substation configuration description) file and CIM/E (common information model/efficiency) file conversion tool and method | |
| CN117591079A (en) | Design construction method of enterprise-level integrated operation management system | |
| US20050228765A1 (en) | Mechanism for synchronizing manafacturing information systems and document content management systems data | |
| Nowacki et al. | Changing a running system: A guideline for retrofitting brownfield manufacturing systems | |
| Lehmann et al. | Towards a comprehensive life cycle approach of building automation systems | |
| Zwegers et al. | Managing re-engineering with the CIMOSA architectural framework | |
| Zielstorff et al. | Harmonizing Heterogeneity: A Novel Architecture for Legacy System Integration with Digital Twins in Industry 4.0 | |
| Berge | Software for automation: architecture, integration, and security | |
| Zielstorff et al. | Overcoming Challenges in Integrating Legacy Devices with Asset Administration Shells-An OPC UA Case Study |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20080326 |