AnsweredAssumed Answered

Data entered through VBA doesn't trigger calculations

Question asked by srikanth.nadikatla on Aug 20, 2018
Latest reply on Aug 23, 2018 by Steve Boyko

HI ALL,

 

I am using VBA to enter some values to some of the inputs which inturn should trigger calculation. I was using sample VBA by osisoft (piexam32) which uses PIPutVal to enter values to input PI tags of some AF Analyses. In standalone PI server environment, I was able to enter values and that action triggered calculations as well. However, in collectives, it is not writing to secondary PI server and it doesn't trigger calculations as well. I am trying to write something like below which writes to both collective members but still doesn't trigger calculations. Any ideas?

 

    Set picol = Servers.Item(picollective) 

    Set picollist = picol.ListMembers

    

    Set picolmem = picollist.Item(primary) 

    Set srv = picol.MemberOpen(picolmem, "") 

    srv.PIPoints(sTagname).Data.UpdateValue sValue, sTime 

    srv.Close 

      

    Set picolmem = picollist.Item(secondary) 

    Set srv = picol.MemberOpen(picolmem, "") 

    srv.PIPoints(sTagname).Data.UpdateValue sValue, sTime 

    srv.Close 

Outcomes