How to replace the existing values to 0 in PI archive editor for a certain period in bulk? This has to be done something with piconfig tool. wondering if anyone can help me out..
You are right, an easy way would be to use piconfig
I would suggest you the following procedure using the following piconfig script. We will create a file with all the events from a PI Tag in a period of time.
Please open a command promnt and go to /pi/adm and introduce the following script. Change 'sinusoid' for the PI Tag that you wish to change the value for.
@istructure tag, starttime, endtime, count
@ostructure tag, time
'sinusoid','19-Nov-2015 00:00:00','19-Nov-2015 23:59:00', *
Please add a comma and a the value that you will like to replace it for. You could do this with notepad or with Excel.
@istructure tag, time, value
Note: the file tmpdelevents.dat will be located in pi/adm
Please let me know if you have any issues following the procedure
Very useful with good screenshots….. thanks for your help.
By the way, I did managed to get the tag & time period using SQL commander query and did used your script to replace the values in bulk.
Thanks a lot for your prompt help.
Is it possible to do this kind of substitution automatically, rather than the manual entry shown here?
I have the same question: is there a way to bulk modify via the archive editor (IE, set all selected points to 0)?
Retrieving data ...