When the archive file is saved (presumably for admin activities), a normal Operator with Operator rights cannot view or use details which are stored in the archive file... However they can save to their directory a file from the Events screen, which can be in a readable format.
Is it possible to do an automated save of events (in a txt or CSV file format) at regular intervals e.g. every month? Or has this been done on other projects?
This to me seems like standard functionality of SCADA systems, to be able to automatically store and subsequently view readable files (CSV, txt etc.) that can be analysed at a later date.
Automated saving of archive events in a text file
- Ashraf.nsubuga
- Posts:9
- Joined: Tue Sep 06, 2016 5:04 pm
Automated saving of archive events in a text file
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: Automated saving of archive events in a text file
Reading data which is stored in the archive files is possible for every WinCC OA user.
There is currently no mechanism which prevents a user from reading data.
Why do you think that a operator cannot read the information?
If you want to create reports (e.g. time based) you can use the Excel Report functionality of WinCC OA.
For details please have a look at the WinCC OA documentation.
Best Regards
Leopold Knipp
Senior Support Specialist
There is currently no mechanism which prevents a user from reading data.
Why do you think that a operator cannot read the information?
If you want to create reports (e.g. time based) you can use the Excel Report functionality of WinCC OA.
For details please have a look at the WinCC OA documentation.
Best Regards
Leopold Knipp
Senior Support Specialist
- Ashraf.nsubuga
- Posts:9
- Joined: Tue Sep 06, 2016 5:04 pm
Re: Automated saving of archive events in a text file
Sorry, I should have been more clearer...
I meant *backup* archive file. Operator's who do not have admin permissions aren't able to use the backup archive.
It is more ideal to create automated saving of events in the current archive at regular intervals in a text readable file for future analysis.
I meant *backup* archive file. Operator's who do not have admin permissions aren't able to use the backup archive.
It is more ideal to create automated saving of events in the current archive at regular intervals in a text readable file for future analysis.
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: Automated saving of archive events in a text file
If you know exactly which information you need for future analysis you can probably create the text files, e.g. filtering for specific dp elements or a defined time range will not be possible in an easy way if you just have text files.
I still do not understand which is meant with "backup" archive file.
Which type of archiving are you using (value archives/HDB or Oracle archiving/RDB)?
Best Regards
Leopold Knipp
Senior Support Specialist
I still do not understand which is meant with "backup" archive file.
Which type of archiving are you using (value archives/HDB or Oracle archiving/RDB)?
Best Regards
Leopold Knipp
Senior Support Specialist
- Ashraf.nsubuga
- Posts:9
- Joined: Tue Sep 06, 2016 5:04 pm
Re: Automated saving of archive events in a text file
I have value archives in my system. In the configuration of the value archive you can set the time that you want to create backupss of the value archive.
You can save events directly in the Event screen in xls / csv file formats and filter the Event columns. It would be ideal automate this manual saving of the event table at a pre-defined interval (days, weeks, months) or when the events reach the limit for the table (e.g. 2000 records).
You can save events directly in the Event screen in xls / csv file formats and filter the Event columns. It would be ideal automate this manual saving of the event table at a pre-defined interval (days, weeks, months) or when the events reach the limit for the table (e.g. 2000 records).