Utility Pack 6.0 Instructions

[takslasher]

Good day,

Saw that Utility Pack 6.0 was added to the plugins, but without any instruction.

I have input the files below as I understood it. Chanel 11 is added Archive number in Archive list. Tried minute archive but the result is the same.

Export historical archive to CSV
Enter archive bit (see Archives table): 11
Enter channel numbers: 101, 102
Enter start date and time (UTC, YYYY-MM-DD HH:MM:SS): 2024-08-15 12:00:00
Enter end date and time (UTC, YYYY-MM-DD HH:MM:SS): 2024-08-15 16:00:00
Enter output file name:

The result is the file without any extension and only data in it below:

“Timestamp,Val101,Val102”

Nothing else in the file and nothing else created. Also the files in the Archive folder are in UTC and how does it extracts them? Using UTC Time or PC Time?

Regards.

[Mikhail]

Hello,
Open the Archives table of your project. Please check if there is an archive with bit 11 in the table?

[Mikhail]

Input and output timestamps in UTC.

• This reply was modified 9 months, 4 weeks ago by Mikhail.

[Mikhail]

The result is the file without any extension and only data in it below

The output filename should have the same name as it was entered.

[takslasher]

What does mean bit 11 in the table?
When I open Archive list I have [#],[Active],[Code],[Name],[kind],[module]
On #2 have minute archive, tried number 2 but the result is the same.

[Mikhail]

The Minute archive has bit 1.
See https://ibb.co/jv7HS8J

[takslasher]

Thank you,

Did not know where to look for this bit number.
Was looking in Server -> Archives.
It would be good to add somewhere as help to look in Secondary tables.

Thanks Mikhail.

[Mikhail]

Were you able to obtain the data using the bit number?

[takslasher]

Hi Mikhail,

Yes it worked fine.
Had issues extracting data when the data itself is missing. If the PC was shutdown (The report would not generate), when the sensor is not connected just generate blank data.

Another question the data is saved in UTC, will there be any changes in script to convert while generating data?

Regards.

[Mikhail]

Hi,

will there be any changes in script to convert while generating data?

There are no such plans. We might add a time zone option for a fee.
I would like to understand for what purposes you export data to CSV?

[takslasher]

Hi,

We just want to have daily backup in easily accessible format.
So right now are testing all the options and looking how it is going to work.
Option is getting reports by the operator is also considered.

Regards.

[Mikhail]

Hi,

We just want to have daily backup in easily accessible format.

Good idea. It can be used in a combination with other backup methods.

[fischerp]

Hello,
I would like to add my voice to this question. I am also interested in the possibility of creating a pure CSV file without an XML header. As a test, I have only unzipped the ZIP file on the computer on which Rapid-Scada is running. That works.
Is it possible, like the other plugins, to integrate the function into the frontend (Webstation)?
Greetings
Peter

[Mikhail]

Hello,

I am also interested in the possibility of creating a pure CSV file without an XML header.

Could you provide an example of the existing file you get and a file you need?

Is it possible, like the other plugins, to integrate the function into the frontend

In the modern Administrator app, there is ExtExternalTools extension. Using this extension, you can add custom command to run command line utilities from the UI.

[Mikhail]

Find ExtExternalTools in the Administrator options, and configure the extension properties.

[Author]

Posts