ROSIsoft, OSIsoft PI and R - Version 2.1

Blog Post created by ernstamort on Oct 2, 2019

Like • Show 7 Likes7
Comment • 6

Hi Guys,

Just a quick update for those who were using the ROSIsoft R Package.
I developed and released this library a few years ago (check out my post here ROSIsoft, OSIsoft PI and R - Version 2 ), just as a community package for anyone interested in playing around with OSI-PI and R.
I was revisiting the project recently, and made some minor updates to add support for R version 3.5+.

The library was built with a fairly simple purpose ; create a way to access PI data directly out in R, and into a data frame.

Let me know if you have any problems with the latest built.

For a copy, bug fixes or enhancements just drop me a quick note.

Outcomes

matapetrol Nov 2, 2019 2:58 PM

Hi Ernst,

Thanks for this awesome package! I am using ROSIsoft in R3.4.4, and finding problems with GetPointSummaries:

GetPointSummaries(PointName = tag,StartTime = '*-10d' , EndTime = '*-1h',SummaryType = 'all',CalculationBasis ='TimeWeighted',Seconds = 60*60)

The above function works sometimes for some tags, but it is not consistent. Any idea why?

It returns this:

9999-12-31 20:00:00 NaN NaN NaN NaN NaN NaN NaN NaN 0

Did you fix this issue in the latest version? How can I get it?

Regards,

Carlos Mata

Actions

ernstamort @ matapetrol on Nov 4, 2019 4:36 PM

Hi Carlos,

No problem, I can look into it. Could you help me to narrow it down:

Could you check the pi tags that causes the error?

Does it work with Excel DataLink? What are the results?

Glad you like it

Holger

Actions

matapetrol @ ernstamort on Nov 4, 2019 5:55 PM

Hi Holger,

I haven't learned Excel datalink so far :s, but it works in my VBA macro with PI SDK:

For analog tags I use:

Set ra = sampdata.Summaries2(dateStartPI, dateEndPI, interval, asAverage, cbTimeWeightedDiscrete)

For discrete tags I use:

Set rd = sampdata.FilteredSummaries(dateStartPI, dateEndPI, interval, "'" & tag & "' = ""OPEN"" or '" & tag & "' = ""TRAVEL""", asCount, cbTimeWeighted)

It's getting 30K rows for each of ~1000 tags. I run the above lines to push aggregated data to a relational database to run hydraulic models and do analytics.

Regards,

Carlos Mata

Actions

paddleguy Nov 25, 2019 3:20 PM

I cant seem to locate the ZIP file for the 3.5+ update.

Actions

ernstamort @ paddleguy on Nov 25, 2019 3:25 PM

Hi, I removed the zip file from he post. Please send me and email to hamort@tqsintegration.com with a shared folder and I will upload it ....

Actions

paddleguy @ ernstamort on Nov 25, 2019 3:34 PM

Done, thanks cant wait to start trying it out.

Actions

6 Comments

matapetrol Nov 2, 2019 2:58 PM
Hi Ernst,

Thanks for this awesome package! I am using ROSIsoft in R3.4.4, and finding problems with GetPointSummaries:

GetPointSummaries(PointName = tag,StartTime = '*-10d' , EndTime = '*-1h',SummaryType = 'all',CalculationBasis ='TimeWeighted',Seconds = 60*60)

The above function works sometimes for some tags, but it is not consistent. Any idea why?

It returns this:

9999-12-31 20:00:00 NaN NaN NaN NaN NaN NaN NaN NaN 0

Did you fix this issue in the latest version? How can I get it?

Regards,

Carlos Mata
Like • Show 0 Likes0
Actions
- ernstamort @ matapetrol on Nov 4, 2019 4:36 PM
  Hi Carlos,
  
  No problem, I can look into it. Could you help me to narrow it down:
  
  Could you check the pi tags that causes the error?
  
  Does it work with Excel DataLink? What are the results?
  
  Glad you like it
  
  Holger
  Like • Show 0 Likes0
  Actions
  - matapetrol @ ernstamort on Nov 4, 2019 5:55 PM
    Hi Holger,
    
    I haven't learned Excel datalink so far :s, but it works in my VBA macro with PI SDK:
    
    For analog tags I use:
    
    Set ra = sampdata.Summaries2(dateStartPI, dateEndPI, interval, asAverage, cbTimeWeightedDiscrete)
    
    For discrete tags I use:
    
    Set rd = sampdata.FilteredSummaries(dateStartPI, dateEndPI, interval, "'" & tag & "' = ""OPEN"" or '" & tag & "' = ""TRAVEL""", asCount, cbTimeWeighted)
    
    It's getting 30K rows for each of ~1000 tags. I run the above lines to push aggregated data to a relational database to run hydraulic models and do analytics.
    
    Regards,
    
    Carlos Mata
    Like • Show 0 Likes0
    Actions
paddleguy Nov 25, 2019 3:20 PM
I cant seem to locate the ZIP file for the 3.5+ update.
Like • Show 0 Likes0
Actions
- ernstamort @ paddleguy on Nov 25, 2019 3:25 PM
  Hi, I removed the zip file from he post. Please send me and email to hamort@tqsintegration.com with a shared folder and I will upload it ....
  Like • Show 1 Like1
  Actions
  - paddleguy @ ernstamort on Nov 25, 2019 3:34 PM
    Done, thanks cant wait to start trying it out.
    Like • Show 0 Likes0
    Actions

ROSIsoft, OSIsoft PI and R - Version 2.1

Outcomes

Related Content

Recommended Content