We covered the overall PI to other line-of-business system integration in a UC talk - see link below
UC talk: PI Data Access and Enterprise Integration
As an enterprise class infrastructure software, PI can deliver more value by “talking” to other business processes such as maintenance, production, and quality in your enterprise. Attend this session to see how the real time PI values and events are transformed into “transactions” in business systems such as SAP, IBM Maximo, and Ventyx AssetSuite. You will also see the use of orchestration and messaging infrastructure tools such as Microsoft BizTalk, SAP MII, and IBM Websphere in the end to end data flow from the plant floor to enterprise line-of-business (LOB) systems.
Using the PI Data Access (PI Notif. with XML, PI Web services, PI OLEDB, PI JDBC etc.) gives you the maximum flexibility.
The code for the XML Delivery Channel (included in the PI Notif. toolkit ) has been enhanced to include the following:
- XML Files are generated to include a datetime suffix for the given filename (so that the files are not overwritten). For example, if C:\MyFolder\Myfile.XML is specified, it will result in files with names such as MyFile _2010Mar15_120801_0700.XML
· XML file uses Item/Value pair syntax for the content - for example:
<item name="NotificationName" type="Standard">Chiller Suction</item>
<item name="NotificationDescription" type="Standard"/>
<item name="NotificationState" type="Standard">OutsideControl</item>
Please see file attachments for a full sample XML.
- If an XSL file is included in the XML destination folder (i.e. C:\MyFolder\MyFile.XSL), a second XML file is generated for each Notification after applying the XSL transform to the file MyFile _2010Mar15_120801_0700.XML. The second file is named as MyFile _2010Mar15_120801_0700_MyFile.XML
Note the filenaming pattern: MyFile.XML expects MyFile.XSL; if MyFile.XSL does not exist in C:\MyFolder, then no transform is done.
Here is the link to the ZIP with the revised code:
This code has been verified w/VS2010 and AF 2010 and PI Notif. 2010. Only the source is included in the ZIP, you must compile it to generate the required binaries.
Sample XML and XSL files are here:
For a compiled DLL, see link in the post below.
Priyanka posted the DLL (from her VS2010 compile) here:
After you register this DLL (remember to restart PI System Explorer and also the PI Notifcation Scheduler), you should see XML as an option in Delivery Channel drop down ( in addition to EMail and Web Service).
Sometimes, you want to write back to PI based on a PI Notifications trigger. The XML Delivery channel that writes to the XML can use a suitable XSL transform to write to file in a format required by PI UFL i.e. the Universal File Loader (aka PI BatchFL). For example, XML from a PI Notif., XSL etc, are shown below.
<= = XML from PI Notif.= =
<item name="NotificationName" type="Standard">Reading Frequency</item>
<item name="NotificationDescription" type="Standard" />
<item name="NotificationState" type="Standard">OutsideControl</item>
<item name="StartTime" type="Standard">4/4/2011 9:24:00 PM</item>
<item name="EndTime" type="Standard">1/1/1970 12:00:00 AM</item>
<item name="TriggerTime" type="Standard">4/4/2011 9:40:00 PM</item>
<item name="Priority" type="Standard">Normal</item>
<item name="Target" type="Standard">\\GOPALE6410W7\myAF\Chiller</item>
<item name="State" type="Standard">OutsideControl</item>
<item name="NotificationInstanceID" type="Standard">1</item>
<item name="NotificationUniqueID" type="Standard">fe6f9125-44c0-4c39-a3f5-accf645d54bf</item>
<item name="\\GOPALE6410W7\myAF\Chiller|WriteToTag" type="AFAttribute">sinusoid</item>
<item name="\\GOPALE6410W7\myAF\Chiller|TagValue" type="AFAttribute">376</item>
= = = = = = = = = = = = = = >
<= = XSL = = = = = = = = =
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output omit-xml-declaration="yes" method="xml" version="1.0" />
<xsl:value-of select="//*[contains(@name,'WriteToTag')]"/>,<xsl:value-of select="//*[@name='TriggerTime']"/>,<xsl:value-of select="//*[contains(@name,'TagValue')]"/>
= = = = = = = = = = = >
<= = After transform = =
sinusoid,4/4/2011 9:40:00 PM,376
= = = = = = = = = = = = =
PI-UFL is a standard interface - see the User Manual for more details.
Just before the developers jump in
PI UFL (aka PI BatchFL)
PI UFL includes a BatchFL mode, but in general PI UFL has much more functionality than BatchFL - that are two different interfaces
... use a suitable XSL transform to write to file in a format required by PI UFL
most likely you could go without the transformation using the INI file of PI UFL to read the data.
Andreas, it will help if you can post an actual INI that can work with the PI Notif. XML shown above.
Actually, PI UFL also includes a POP3 email listener, so you can also directly send a PI Notif. email.
After spending some time with the UFLDesigner (A GUI to create the INI files) a first very simple version for the benefit of the people having the PI UFL interface, please note that the PI UFL interface is not part of the vCampus product kit:
FIELD(3).FORMAT="M/d/yyyy h:mm:ss pp"
StoreInPI(TAG_ID, ,TIMESTAMP,VALUE, , )
The XML file can also be processed by SSIS (SQL Server Integration Services) to call any web service - see example and demo in the OSIsoft vCampus Live! 2010 talk:
This example calls a SharePoint web service to add to a PI Notification alert to a SharePoint List.
i can't find the download for RLINK - MRO Maximo Install Kit. anyone ?
RLINK - MRO Maximo is not available through vCampus.
there is a post up there for link to download OPC client (Maximo) .... once i click on it , it is not available.
I just tested the link and it seems to bring me to the download page for the OPC Client for Maximo correctly. The OPC Client is a product of another company, Matrikon. Another way to get to it is to go to Matrikon's homepage and search for the keyword Maximo.
Can you please post more info. on why you are wanting to use OPC to link to Maximo. Doesn't PI and the discussions previously mentioned in this thread work for you?
Often, OPC is not suitable since you need to able to send aggregate values ( which is done PI Totalizers) for runhours. There are other examples in the presentations referenced previously. Also, the PI System allows you to do condition assessment and provide the triggers to initiate a transaction in Maximo.
We did a presentation with GenPower on the PI Maximo integration in Feb 2011 at the Maximo User Conference (i.e. Pulse); this is to get to the video/audio and full transcripts for the talk at Pulse 2011:
Click “I did not attend…”
Fill out info to get username/password
Search for “osisoft ” or "gopal" or "scott"– and this talk should be listed:
If IBM's http://pulse.vportal.net/index.cfm does not work, the slides are in the attached ZIP file.
<= = =
I-1418: Better Asset Maintenance Using Equipment Operations Data
Session Format: Breakout Session
Track: Maximo – Enterprise Asset Management
Where: Las Vegas MGM Conference Center - Level 3 - Room 314
When: Mon, 28/Feb, 2011 05:00 PM - 06:00 PM
Scott Larson, GenPower Services, LLC.
Gopal GopalKrishnan, P.E., OSIsoft, LLC.
Longview Power (owned by GenPower) is a new 695 MW (net) SCPC (supercritical pulverized coal) mine-mouth power plant based in West Virginia. With a focus on reliability and efficiency, we are targeting the best heat-rate (8728 Btu/Kwh) – the lowest among the 343 coal power plants in the US. We have standardized on IBM Maximo for maintenance and the OSIsoft PI System for operations data from our plant computer systems. Attend this session to learn how we have connected these two systems in real-time to deploy best practices in usage and condition-based maintenance (CBM) strategies, visual integration of operations and maintenance data, and others. Maximo’s open, standards-based architecture supports real-time collaboration for reducing maintenance costs without sacrificing equipment reliability. The use cases discussed relate to power generation assets, but are equally applicable to other industries, including critical facilities and data centers.
What will your audience walk away with? 3 key bullets:
1. Best practices in using equipment operations data in maintenance for reducing costs and improving operational efficiency.
1. Moving beyond data integration to event integration and visual integration, for ease of use and navigation for both Operations and Maintenance personnel.
1. How to get operations and maintenance to work together to improve ROA (return on assets).
= = = >
thank Gopal . manage to get the slides ...
I tried to log on to the site but, failed. probably its not possible to register any more. Would it be possible for you Gopal to send me de slidepack you refer to?
What question(s) are you trying to answer? If you are just trying to get some details on PI to Maximo integration, please look at the hands-on lab notes from vCampus Live 2011. And, if you want to see a demo, vCampus Live 2010 talk on Line-of-Business integration includes a short demo from Longview Power.
The full set of files from vCampus 2011 used in the SAP/Maximo Lab is at the URL below:
The HandOn Lab documentation (PDF) alone is in the attachment to this post.
The XML Delivery Channel example contained in the PI Notifications Developer Toolkit has been extended with the following. The key features that are demonstrated in this lab are:
· Generate an XML file containing the PI Notifications subscription content.
· Optionally, if an XSL file is specified, apply the XSL transform to the first XML to generate a second XML file. XSL can include scripting.
· Optionally, if an HTTP URL endpoint is specified, send the transformed XML content to the specified endpoint. The XSL in the previous step can include SOAP elements if you are calling a SOAP Web Service.
For HttpBinding, the Authentication can be set to NONE, BASIC or NTLM; username/password can be included by suitably configuring the Element and/or modifying the XML Delivery Channel code.
As such, you can call many SOAP web services (including those with complex data types).
If you need security and authentication that involve passing parameters via SOAP Headers and other WS-* schemes, you’ll have to modify or incorporate them in the XSL and/or the XML Delivery Channel code.
§ Optionally, if an FTP URL is specified, you can upload the file to the specified site. FTP upload can include username/password authentication.
§ For HTTP and FTP, username/password provided via Element Attributes is used if it is provided. Otherwise, the PI Notification Scheduler service account username/password is used, as required.
Here is an example of XML Delivery Channel with its built-in support to call web services. This shows PI Notifications integrated with CISCO CEBT - Collaboration Enabled Business Transformation.
OSIsoft PI Software Demo at Cisco Live 2012 - YouTube
Here we see Stewart Young, Alliances Manager for Cisco at OSIsoft, and Ivan Yudhi, Engineer at OSIsoft, talk about the integration of the OSIsoft PI software with CISCO CEBT… 3 minute video from San Diego, CA.
Here is the YouTube link from the UK show (3 minute video - has more details)
More info about CEBT is here: http://www.cisco.com/en/US/services/ps6887/ps11250/cisco_cebt_whitepaper_services.pdf
Gopal, I'm trying to folllow the lab, but at the time that I try to create the notification, the content tab does not appear, only a message tab related to an e-mail ¿why is this happening?, thank you.
captura.jpg 107.7 KB
Carlos, the PI Notifications user interface has changed since that document was created. The Message tab provides greater customization of notifications than the old Content tab. The content pane on the right hand side of the Message tab contains all the information of the old Content tab. However, if you want to go back to the old Content tab, from the Notifications tab, click the Tools menu > Notification Settings > Global Configuration tab and set the value "Use Delivery Formats by Default" to False. This will cause newly created notifications to use the old style content, but be aware it is global setting so it affects everyone on your system.
Hello Michael Thank You, I´ve made what you said and is working, now I am having another problema, when the XML file is being generated In the attribute which is coming from PI I am receiveng the an error "Unable to open a session on a server. The user name and password may be incorrect.", I' have created trusts in the PI server for the AF Servere (they are in different machines) but still receiving the error, do you have any commetaries about this problema.
This is definitely a connection issue. Your trust may not be firing for some reason. Please review the PI Server log for messages from source pilicmgr and pibasess. OSIsoft Technical Support will be more than happy supporting you with this issue.
For tech support purposes, it will be easier to first get things working via Email delivery channel.
(moved this discussion thread to the appropriate forum: PI System Integration)