Hi there,
I have an enquiry regarding Codesys3.5 programming,
I have recently did a factory batch control project with Codesys3.5 and the Visualization using codesys visualization also.
Now the client (Food Factrory) request two new modifications :
1- job detail report (including every batch data).
2- storing data in their sql server database.
So if any example or any guide can help me to complete these tasks I will be very grateful,
Thanks in advance
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
How are you storing data in their SQL server database? How are you communicating with it? The datalog manager can log to an sqlite file and you can move files to a network location but that doesn't strike me as what they would be wanting but maybe it helps you. Maybe the IIOT libraries have some of the functionality that you need. There also OPC UA, as well as something custom with ethernet IP.
The job detail report is definately doable with the datalog manager, where do they want to have access to the job detail report? On the PLC's HMI or on external devices? The datalog manager doesn't immediately make a visualization displaying the data. The trend functionality does, and creates an sqlite file. There are a few other ways of doing this depending on what functionality you want.
The only problem with creating logs on the PLC itself is that you're using up write cycles on your storage. I haven't seen an easy solution to that presented other than writing your own logging program to use something like an SD card.
Hi there,
I have an enquiry regarding Codesys3.5 programming,
I have recently did a factory batch control project with Codesys3.5 and the Visualization using codesys visualization also.
Now the client (Food Factrory) request two new modifications :
1- job detail report (including every batch data).
2- storing data in their sql server database.
So if any example or any guide can help me to complete these tasks I will be very grateful,
Thanks in advance
How are you storing data in their SQL server database? How are you communicating with it? The datalog manager can log to an sqlite file and you can move files to a network location but that doesn't strike me as what they would be wanting but maybe it helps you. Maybe the IIOT libraries have some of the functionality that you need. There also OPC UA, as well as something custom with ethernet IP.
The job detail report is definately doable with the datalog manager, where do they want to have access to the job detail report? On the PLC's HMI or on external devices? The datalog manager doesn't immediately make a visualization displaying the data. The trend functionality does, and creates an sqlite file. There are a few other ways of doing this depending on what functionality you want.
The only problem with creating logs on the PLC itself is that you're using up write cycles on your storage. I haven't seen an easy solution to that presented other than writing your own logging program to use something like an SD card.
You might want to also look at the Oscat Netlib library.
Last edit: Morberis 2020-10-06