Kind regards,
Jaroslav

Just wondering if there is anything like this as you mentioned available meanwhile. A command-line utility to extract data from the internal archive to CSV file.

Or a new function block to store data to a logging file? Maybe in the new version of Rexygen?

Regards,
Peter

Thanks for your feedback on this.

"On the other hand, there is an internal archiving system in REX, which is way more efficient than storing data in a text file. The downside is that (as of current version 2.50.1) the data can be extracted only using RexView. If there was a command-line utility to extract data from the internal archive to CSV file, which you could run e.g. every day at midnight, would that fit your needs?"

That would be great of course!
Thanks once more for all your effort providing these examples and information!

Regards,
Peter

On the other hand, there is an internal archiving system in REX, which is way more efficient than storing data in a text file. The downside is that (as of current version 2.50.1) the data can be extracted only using RexView. If there was a command-line utility to extract data from the internal archive to CSV file, which you could run e.g. every day at midnight, would that fit your needs?

As for the hand-coding, I understand your comment and thank you for that. It is not in human power to have function blocks for everything and completely avoid hand coding. Still I believe there is a lot you can do with REX without typing a line of code...

Moreover, in some scenarios, a few lines of code are worth tens or hundreds of function blocks. It's the possibility to combine these two approaches almost seamlessly which we consider one of the big advantages of REX.

Kind regards,
Jaroslav

Thank you very much for this example.
Based on the "relative complexity" of such a basic feature, I strongly suggest to have a function block available for this.

It is not a complaint, but a challenge since I only refer to the features on the website about Rex Control stating:

Features of the REX Control System
Graphical programming without hand-coding

But nevertheless with this example it appears to be easy to create what I would like to have.
Thanks once more!

Best regards,
Peter

The README file should contain all the information you need. I am not writing more about the example on purpose. Your comments are highly welcome.

Regards,
Jaroslav

I agree and factually still looking forward for an example of "logging data to a text file" as well.

Regards,
Peter

Store a "line" of comma separated temperature and other values, every one minute or so, onto a flash drive or similar for later analysis purposes.

However it is done, code or a module, an example would be really useful!

Thanks
Regards
Evan

Thanks,
Peter

Let's say we take 2 pieces of 1-wire temperature sensors and sampling every 5 seconds, but store an average of the temperature reading for each sensor every minute to a logging file (TXT file, or CSV file or something like that).
...
I can imagine we need to save data first to RAM drive in order to avoid too many write cycles to USB drive or external drive and do the processing (averaging of data over 1 minute and eventually formatting the output (instead of 24.23019383 degrees C, that is will become 24.2 degrees C) before it will be saved to the logging file.

Hi guys,
for averaging, you can use:

• AVG block - in this case it must be placed inside a task with sampling period 5 seconds and n=12 should be set. This will give you a 1-minute running average. Therefore you can export its output directly, without any need for postprocessing.

• TRND block - in this case the sampling period of the task can be arbitrary, you just have to set the pfac parameter so that pfac*Ts=60, where Ts is the sampling time in seconds. It is also necessary to set ptype1=5: Average. By that, you'll get the average temperature in 1-minute intervals at the y1 output.

Both of these approaches are handled in RAM and give you the value which you want to store in a text file.

Hope this helps somehow. I'll add some more hints...

Jaroslav

I'm still very interested in the way HOW to simply log data within RexControl system (without the need of running a separate script where data will be logged independently from the RexControl system. Whenever you have the possibility to come back to this, I looking forward for this.
Thanks in advance,

Regards,
Peter

I would use the TRND block for averaging and archiving the data and move it to a database afterwards as Scoobsalamander recommended. Since this is not an option for Peter, I would use the AVG block for averaging the temperatures and the EPC block for storing the data in a text file. However, from there, you have to rely on "Linux magic" and use e.g. sed or awk commands. It's also possible to use the REXLANG block, which is very similar to the EPC-based approach.

I'll get back to this topic and create some examples based on your discussion, but not in the next week since I'm at SPS/IPC in Nuernberg/Germany.

Jaroslav

Thanks for your proposal, but i intend to use the device remotely without the using rexview. So the data logging / archieving to a CSV, or TXT file should be done automatically every week or every month. Without having checked your example, I think this is not happening if you speak about the export from the trenplot data inside RexView.
That is the reason I expected that there is another function block like SGSLP available for this purpose.

So I guess still not the solution I am looking for....

From within REXview you can export the data fromt the TREND and/or Archive to a CSV file.

Small example (original example + TREND block)

This is more or less what I want to achieve. A TXT or CSV file that provides and overview of the historical parameters saved once every minute with date / time stamp and a header information.
Which function block to use for such kind of archive / logging file? If such files automatically can be stored as a single file once every week or month it would be great.

There or various blocks but I could not find a nice example on how to achieve this. And I feel this might be a commonly used thing in industrial applications.

So basic question: Who can provide a basic example that is doing such a job?

Example file below (TAB separated values):

TIME    MM    DD    T01    T02    T03    T04    T05    T06    T07    Operate    Cycle    RunHrs    ActiveHrs    Counter1    LatchingAlarm
00:00    02    01    41.16    47.9    52.74    3.07    0.51    7.27    0.23    0    1    678    672    1329    0
00:01    02    01    40.98    49.38    54.48    3.13    0.51    7.27    0.23    0    1    678    672    1329    0
00:02    02    01    40.89    48.53    53.28    3.35    0.51    7.28    0.23    0    1    678    672    1329    0
00:03    02    01    40.83    53.05    54.94    3.13    0.51    7.28    0.22    0    1    678    672    1329    0
00:04    02    01    41.12    45.04    54.85    2.72    0.51    7.27    0.22    0    1    678    672    1329    0
00:05    02    01    40.81    49.18    53.99    3.07    0.51    7.25    0.2    0    1    678    672    1329    0
00:06    02    01    40.54    50.24    53.83    3.26    0.51    7.23    0.22    0    1    678    672    1329    0
00:07    02    01    40.43    49.39    53.47    3.43    0.51    7.25    0.22    0    1    678    672    1329    0
00:08    02    01    40.41    48.81    53.61    3.14    0.51    7.27    0.22    0    1    678    672    1329    0
00:09    02    01    40.35    48.12    53.29    1.99    0.51    7.26    0.22    0    1    678    672    1329    0
00:10    02    01    40.28    49.02    53.38    2.7    0.51    7.24    0.23    0    1    678    672    1329    0
00:11    02    01    40.16    49.39    53.66    3.18    0.51    7.22    0.23    0    1    678    672    1329    0

Regards,
Peter