Recent posts to TREND FILE RECORDING MANAGMENThttps://forge.codesys.com/forge/talk/Visualization/thread/8138fd6880/2020-10-20T12:37:08.981000ZRecent posts to TREND FILE RECORDING MANAGMENTTREND FILE RECORDING MANAGMENT2020-10-20T12:37:08.981000Z2020-10-20T12:37:08.981000Zjeromebunelhttps://forge.codesys.com/u/jeromebunel/https://forge.codesys.come61b204c8217af9368501ad6511e7fdae705dc68<div class="markdown_content"><p>Hello. I found a solution to my "STORAGE TREND" problem.<br/>
In the "Trend Storage" dialog box, I use the "No limit" option.<br/>
Then I regularly delete the oldest data from the SQLite database with an SQL query executed by a Python script.</p>
<p>I share with you this request:</p>
<div class="codehilite"><pre><span></span><span class="o">*</span><span class="k">Delete</span> <span class="k">from</span> <span class="n">TblTrendData</span> <span class="k">where</span>
<span class="p">(</span>
<span class="k">select</span>
<span class="nb">date</span> <span class="p">(</span><span class="n">TS</span> <span class="o">/</span> <span class="mi">1000000</span><span class="p">,</span> <span class="s1">'unixepoch'</span><span class="p">)</span> <span class="k">as</span> <span class="n">dt</span><span class="p">,</span>
<span class="k">where</span> <span class="n">dt</span><span class="o">></span> <span class="nb">date</span> <span class="p">(</span><span class="s1">'now'</span><span class="p">,</span> <span class="s1">'- 30 days'</span><span class="p">)</span>
<span class="p">)</span> <span class="o">*</span>
</pre></div>
<p>This is how I delete data older than 30 days.</p>
<p>before executing this request; it is imperative to stop the recordings by setting to 0 "Record Conditions" variable</p></div>TREND FILE RECORDING MANAGMENT2020-10-16T12:52:26.546000Z2020-10-16T12:52:26.546000Zjeromebunelhttps://forge.codesys.com/u/jeromebunel/https://forge.codesys.coma60df31737c7e949d57fddf6682cbc7bb744a7c2<div class="markdown_content"><p>Hello.<br/>
I'm surprised no one reacted to my previous post.</p>
<p>Maybe I explained badly.</p>
<p>So,<br/>
For the storage of the trend, there are three possibilities of file management:</p>
<p>1) no limit<br/>
2) limited file size<br/>
3) limited in number of registrations.</p>
<p>In case 2, what happens when the file is full?</p>
<p>In case 3, what happens when the maximum number of records is reached?</p>
<p>Thank you</p></div>TREND FILE RECORDING MANAGMENT2020-10-16T12:52:23.526000Z2020-10-16T12:52:23.526000Zjeromebunelhttps://forge.codesys.com/u/jeromebunel/https://forge.codesys.come0bb9b991fdd78a723cd7f69d83b010455b879a5<div class="markdown_content"><p>Hello.<br/>
I'm surprised no one reacted to my previous post.</p>
<p>Maybe I explained badly.</p>
<p>So,<br/>
For the storage of the trend, there are three possibilities of file management:</p>
<p>1) no limit<br/>
2) limited file size<br/>
3) limited in number of registrations.</p>
<p>In case 2, what happens when the file is full?</p>
<p>In case 3, what happens when the maximum number of records is reached?</p>
<p>Thank you</p></div>TREND FILE RECORDING MANAGMENT2020-10-15T13:27:38.429000Z2020-10-15T13:27:38.429000Zjeromebunelhttps://forge.codesys.com/u/jeromebunel/https://forge.codesys.com0ab555169468bb5195840b305c7ab054d8af4ba7<div class="markdown_content"><p>Hello to all.</p>
<p>My question concerns the management of the trend curve files recording.</p>
<p>1) no limit<br/>
2) limited in file size<br/>
3) limited in number of registrations.</p>
<p>I thought that once the limit is reached (file size or number of recordings), the recording will continue as a circular buffer. That is, the oldest data is replaced by the most recent data.<br/>
But it seems not. I notice that the SQLlite file is no longer refreshed.</p>
<p>How do you deal with this problem?</p>
<p>Is it possible to operate as a circular buffer</p>
<p>Thank you</p>
<p>Jerôme Bunel.</p></div>