sasacam.blogg.se - Add pi datalink to excel

ADD PI DATALINK TO EXCEL HOW TO
ADD PI DATALINK TO EXCEL DRIVER
ADD PI DATALINK TO EXCEL CODE

Combined with the computational, graphic, and formatting capabilities of Microsoft Excel, PI DataLink offers powerful tools for gathering, monitoring, analyzing, and reporting PI System data. Have a Look at the PI Developer Technologies and you may find another easier way to extract your data. Details: PI DataLink is an add-in for Microsoft Excel that enables you to retrieve information from your PI System directly into a worksheet. There is also the powershell scripts for the PI System that you could use.

ADD PI DATALINK TO EXCEL DRIVER

As well you could use an ODBC client with the PI ODBC driver to query data out of the PI System and that is also easier to automate. Excel Details: PI DataLink is an add-in for Microsoft Excel that enables you to retrieve information from your PI System directly into a worksheet.

ADD PI DATALINK TO EXCEL CODE

NET code with the AF SDK which is easier to automate than excel.

There are many many ways to consume data out of the PI System and it really depends of what you are trying to do. I think that you may need to step back and ask yourself what you are trying to achieve? There are many things and it could be complex. It may also be that the task is running as a background task where threads have no access to the UI stuff.

"Start in (optional)" option contains only the batch file pathĭepending on the configuration of your scheduled task it may run as a system user for which the user profile does not have access to the correct excel add-ins. PI DataLink is a Microsoft Excel add-in that enables you to retrieve information from your PI Server directly into a spreadsheet.

"Program/script" option contains only the batch file name.

"Run with highest privileges" option selected.

"Run whether user is logged in or not" option.

Scheduled task running as admin user which permissions on all files.

It seems like when it's run by the scheduled task, Excel is not loading the DataLink add-in and therefore doesn't recognise the function name. The code is as follows: ThisWorkbook.Sheets(SheetName).Range(Cells(5, PTTagNamesCol), Cells(RangeRowCount, PTTagNamesCol)) = Application.Run("PISampDat", TagName, EDate, SDate, "5m", 0, PiServer)

ADD PI DATALINK TO EXCEL HOW TO

PI DataLink, Convert Excel Spreadsheet to HTML, Spreadsheet Consolidator. Beginner Recommended for most learners Learn how to use PI DataLInk (MS Excel add-in) to access your process data, Aprenda o Bsico do PI System e Recursos. "PISampDat" is not a macro but the name of a function in the add-in. We enter the symbol of the stocks we either own or are looking to add in this.

In this workbook or all macros may be disabled. If I run the workbook or the batch file manually, it works as expected, but if I use the scheduled task, I get the following error:ġ004: Cannot run the macro 'PISampDat'. The workbook is run by a batch file, which is in turn triggered by a Windows scheduled task.

I have an Excel workbook with some VBA code, which uses the PISampDat function of the OSIsoft DataLink add-in to pull multiple columns of data.