Thread Content
This post was last edited by powersstar on 2017-2-4 at 16:09. Due to on-site requirements, it was necessary to retrieve certain data from the DCS system and store it directly in an SQL database. Many attempts were made, but none succeeded (OPC required purchase, so it wasn’t used). Eventually, an expert was hired who wrote a small software program that can be installed on any workstation to retrieve the data, without requiring any special hardware! ! I’m not sure about the principle behind it. The software was uploaded on 2017-2-4; please download the attachment by yourself. If it won’t run, install the VB6.0 runtime library to make it work! ! Please turn off the firewall or allow access through it! ! Additional note: 1. There is a limit on the number of data points that can be transmitted; one master card can transmit up to 200 analog data points and 3,200 digital data points. Beyond this limit, transmission is not possible. 2. I checked and saw that the software is command-line based; it has no interface – just something similar to the CMD window in Windows, with data being displayed line by line. 3. Friends who are interested can discuss it together. 4. Emphasize: it is not OPC. Use cases: 1. Reports: Since the reports generated by the central control system are produced on a scheduled basis, this solution allows for real-time, continuous report generation; for example, the data for 8:00 can be viewed as early as 8:10. Report template: 8:00, 12mg; 9:00, 10:00. 2. Extract data: Extract the data into a database for use by third-party platforms. It’s not clear whether the latest software for the central control system can achieve this; previous attempts showed that it was not possible, as data could only be extracted in TXT format. 3. LED large screen.
Hehe, actually he still used OPC; it’s just that the authorization for the central control system was bypassed
This post was last edited by powersstar on 2017-1-16 at 11:50. The person in the second comment is wrong; there is no such thing as a crack. It has been tested that data can also be obtained properly on computers without the central control software installed. 1. It’s not OPC being used! ! 2. There is no crack.
It’s free OPC, right? You can’t view trends – only real-time data?
100% is not OPC; it’s a program written by that expert themselves
They don’t provide training for it; it’s custom-made
Copy the program and send it over for a look.
I took a screenshot when I had time; haha, but copying it out isn’t very useful either, because there’s still a database that needs to be set up, and errors occur if the database isn’t running
However, there is a limit on the number of data points that can be transmitted: one master card can transmit up to 200 analog data points and 3,200 digital data points; beyond this limit, transmission is not possible
Hehe, it’s more convenient to use this software when there’s a need to display data directly on the LED – it allows data to be sent straight to the LED screen