Export data with the Trend API

2024-07-08T11:12:56.924000Z

Can you please share the code as i am the beginner for codesys. I don't have any idea that how sqlite is integrated with the codesys.

Export data with the Trend API

2020-10-03T11:24:58.174000Z

Hello,
I understand now where my missing message were. i was answering at the starting message rather than the last...
So Datalog is working now.
I discovered that the HVAC library i am using has internally some logging group that must be configured but in a separate channel to avoid saving continuously all functions blocks parameters.
So i created a separate channel for logging these on event (change only) in a sqlite file
Also, for some reason i ignore, all parameters from my programs FB using HVAC FB from library where also logged without need to specify them individually.

But even when saving on a predefined cyclic time, the csv file format is still the same (one line for each tag)
I join one extract file.
So i still need some query tools to reformat this file to a traditional CSV graphing tools.
I can do this with some python script and it will be easier here because all tags have the same timestamp but if some body knows standard free tools for tracing from event log csv file, i would be so happy.

Trace also allows to save data on CSV file but the data are also grouped tag by tag and i could not succeed in storing them from my codesys app running on RPI up to now.
The joined file was from Trace example project downloaded from forge shared project and running on control win.

Export data with the Trend API

2020-10-02T08:35:18.144000Z

It is strange that our last message is not displayed here.
Anyway , thanks to your help , I finally catch where to add the ac datalog library ...
then did the module
Add the HMI display statistic
Search where to connect the HMI data...
Find a example project in a other conversation Here on datalog
Discovered how to generate the config using AC that create the objects in the application and add program and tasks..
And finally got the datalog working...

I also discovered that I can trigger a save of all data every x ms in the channel configuration so I hope that the data will be grouped in the CSV file on one line.

I also finallly catch how the trend storage api is working but could not succeed in reading more than one the 3 data that are recorded...

So It is a good progress...
Thanks for your help again

Export data with the Trend API

2020-10-01T21:57:03.292000Z

Ah. First add the ac_datalog library, then hit alt+2 to bring up the module window. After that add the datalog manager, datalog channel, then datalog storage.

You pick which application it is being deployed to in the datalog manager under the deployment window.

Export data with the Trend API

2020-10-01T21:51:04.108000Z

Yes but my problem was that more the way the data logged are saved.
The most standard CSV flat file have the tag name on the first line and then values for each tag on each line with time stamp as first colum
I will try to use the ac datalog but I need first to find how to add the application composer menu to be able to add the datalog in the device hierarchy

Export data with the Trend API

2020-10-01T20:53:01.254000Z

You can set in the DatalogStorage_CSV module what symbol(,;: etc) indicates the start of a new column. When you import the CSV file into excel it asks what symbol indicates a column seperation. So if you pick that same symbol in both steps you'll get your data in multiple columns for easy graphing etc.

Export data with the Trend API

2020-10-01T20:13:35.601000Z

To plot on a computer...
There are plenty of tools to plot curve from CSV file where the first coutume is the time stamp and other column give value for each tag
Here the datalog create on line for each log with timestamp, value, tag, type, group... ... and the recording is based on deadband for analog value
I think I could probably find some solution with some python.
I will try this datalog soon.

Export data with the Trend API

2020-10-01T15:47:59.397000Z

For plotting it on the PLC or on a computer?

It might be worth your time to talk to Codesys support.

Export data with the Trend API

2020-10-01T06:45:21.685000Z

I checked the datalog manager... this is a nice flexible tool but I don’t know the standard tools that can use such file for plotting some curve , I continue to investigate.

Export data with the Trend API

2020-10-01T06:27:43.706000Z

Thanks for your feedback.
I tested also the possibility to explore Sqllite file using a standard SQLite browser that has the export to CSV capacity.
This quite easy except that the format for logging floating point value in the SQLite is Dint .
The consequence is that the CSV file will be very big.
So I will check datalog manager capacity in the next days.

My idea would be in this case to log filtered value of my signals with a longer sampling time.

Recent posts to Export data with the Trend API

Export data with the Trend API

Export data with the Trend API

Export data with the Trend API

Export data with the Trend API

Export data with the Trend API

Export data with the Trend API

Export data with the Trend API

Export data with the Trend API

Export data with the Trend API

Export data with the Trend API