Hi all,

I was trying to manually enter data into a couple of Pi tags, data was from the 4-jul-2011 to 24-oct-2011 with a 1 minute interval. I am using the following code which I got from here.

Private PIServer As PISDK.Server

Private Const PIServerName As String = "stupisp01"

Public Sub UpdatePIPoints()
Set PIServer = PISDK.Servers(PIServerName)

' Cycle through Cells starting at row 2
Dim i As Long
For i = 2 To 1000000
' If blank cell encountered then do not continue
If Range("A" & i).Value = "" Then Exit For

' Check PI tag exists
On Error Resume Next
Err.Clear
If PIServer.PIPoints(Range("A" & i).Value).Name = Range("A" & i).Value Then
If Err.Number = 0 Then
' Get the PIPoint
Dim PITag As PISDK.PIPoint
Set PITag = PIServer.PIPoints(Range("A" & i).Value)
Err.Clear
Call PITag.Data.UpdateValue(Range("B" & i).Value, Range("C" & i).Value)
If Err.Number = 0 Then
Range("D" & i).Value = "Value written to PI."
MsgBox "A successful update was made to " & PITag
Else
Range("D" & i).Value = Err.Description
MsgBox "The update to " & PITag & "was unsucessful due to " & Err.Description
End If
Set PITag = Nothing
Else
Range("D" & i).Value = Err.Description
MsgBox "The update was unsucessful because the " & Err.Description
End If
Else
Range("D" & i).Value = "Tag does not exist."
MsgBox "The update to " & PITag & "was unsucessful due to the tag not existing"
End If

On Error GoTo 0

Next i

End Sub

I got no errors when I ran the program but the issue is that when I retrieve the data, only data from 10-sep-2011 appears. The tag wasn't created on that date it was created on the 24th-oct. I manually changed the point created value so I could write before the creation date. I am at a loss as to why the data doesn't appear. I am not sure if it is not being written into PI or it can't retrieve it for some reason.

On a similar note there was a tag which I was updating manually earlier this month. It is a collection of tags which I update every month with daily averages from a weather station. It was working fine before I updated the values this month but after I updated them only the last 6 days of data was available and everything before that couldn't be retrieved.

Also how can the above be tweaked to be able to delete data point in PI. All help is appreciated.


Regards,
Jitesh

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.

Thanks for that RJK. Found a compromise solution. Could anyone help with adapting the code for deleting PI data points in the archive?

Probably not what you are looking for, but if there aren't a whole lot of point values to delete they can be deleted manually via PI-SMT.

I do have some old PI-API code in a VB6 application that deleted PI point values, but Win 7 pretty well broke the app. If you want a snip of some of the PI-API code, let me know.

We only used the VB6 app to manually delete point values one at a time, so PI-SMT is an adequate replacement and I've not felt any overwhelming urge to re-code it in PI-SDK.

jhcoxx

I would suggest you create a csv file with all the values you want to delete. Make sure that ColA=tag,ColB=time,ColC=value,ColD=mode

Also check if your data was not entered with subseconds

dd-MMM-yy hh:mm:ss.00

Excel should look like this, please forgive my feeble attempt to duplicate Excel row & cols. Save the CSV file somewhere in the PI SERVER

MyTagname1,MyTime1,MyValue1,remove
MyTagname1,MyTime2,MyValue2,remove
MyTagname1,MyTime3,MyValue3,remove
MyTagname2,MyTime1,MyValue1,remove
MyTagname2,MyTime2,MyValue2,remove
MyTagname2,MyTime3,MyValue3,remove

@table piarch
@mode edit,t
@istructure tag,time,value,mode
@input C:\MyFile.csv

If this doesn't work walk up to your IT department and smack the first person you see. IT should never be in charge of what is happening in the engineering floor, as you can see I'm pro-Engineering

OK, this doesn't make sense, you can't find the tag in the archive table, can you find the tag if you do a normal tagsearch in Datalink. Also check if there isn't any spaces before and after the tagname. I presume you are logged into the piserver when you perform the piconfig commands.

No I didn't but thanks for that I have it working now.

i agree i like to read these forums for code snippets especially since i am just starting out learning pi/osisoft/vba