I have a question about PI ACE. Does the PI ACE support VBA language?
Yes, VBA language would be supported by PI ACE but you need to keep in mind that there are two types of scheduler:
Please find in this link the differences between this two types: Differences between PI ACE for VB6 and PI ACE for VB.NET
Please let us know more about your project, if possible.
Thank you in advance ,
Strictly speaking, ACE 1.x doesn't support VBA, but rather VB6. VBA requires some host parent application since the "A" in VBA stands for "Application". Granted the code and syntax are much the same but there is that subtle distinction.
I liked the link you provided but one thing it doesn't mention - and this is a major distinction - is that ACE 1.x, which is based on VB6, does not integrate easily with AF. Because ACE 2.x is .NET based, it can integrate quite easily with AF.
Whether someone wants to use Visual Basic (be it VB.NET, VB6, or VBA) is a matter of their choosing. But your first question is very legitimate. I would strongly urge anyone to first and foremost ask "Can this calculation be done in Asset Analytics?" Once it's determined that it can't, perhaps because of looping or some other special requirement, only then should alternatives be considered. And ACE is a valid alternative. Or in my opinion, ACE 2.x is a valid alternative and 1.x never is.
Hi Carlos & Rick,
I have a plan to bring data from PI into MATLAB for calculating Fourier Transforms and push the results back to PI. So I want to ensure my code are executed by PI ACE Scheduler.
About question 2, I just think simply that we can make use of VBA which is integrated in MATLAB instead of installing Visual Studio
Thanks for your explanation. It’s clear to me.
Thanks for the clarification, another option in order to Access to PI data with Matlab would be using AF SDK. Have you consider this option?
There are several resources that could help you:
White Paper - Using the PI-to-MATLAB Utility.pdf
PI-Data-With-MATLAB-White-Paper/mAF_GetAttributeInterpolatedValues.m at master · osisoft/PI-Data-With-MATLAB-White-Paper…
Accessing AF via Matlab
Retrieving data ...