26 Replies Latest reply on Jun 14, 2013 6:13 PM by Gopal

    PI integration with Maximo

    yokogawa

      Hi,

       

      What are the possible ways to  connect to  Maximo tool?

       

       

        • Re: PI integration with Maximo
          MichaelvdV@Atos

          Bhaskara Rao

          Hi,

           

          What are the possible ways to  connect to  Maximo tool?

           

          Searching for 'maximo opc' on google yields a number of results, including:

           

          Opc Client for Maximo

           

          or

           

          OSIsoft RLINK PM for Maximo

            • Re: PI integration with Maximo

              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.

               

              http://videostar.osisoft.com/UC2010/presentations/PPT/UC2010_PT1893_Enterprise_Integration_Gopal_Verhoeff.pdf

               

              Using the PI Data Access (PI Notif. with XML, PI Web services, PI OLEDB, PI JDBC etc.) gives you the maximum flexibility.

                • Re: PI integration with Maximo

                  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:

                   

                  <Notification>

                   

                  <item name="NotificationName" type="Standard">Chiller Suction</item>

                   

                  <item name="NotificationDescription" type="Standard"/>

                   

                  <item name="NotificationState" type="Standard">OutsideControl</item>

                   

                  ...

                   

                  ...

                   

                  </Notification>

                   

                   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:

                  http://vcampus.osisoft.com/members/Gopal/files/XMLDC_5F00_VB.zip.aspx

                  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:

                  http://vcampus.osisoft.com/members/Gopal/files/XMLandXSLFiles.ZIP.zip.aspx

                   

                  For a compiled DLL, see link in the post below.

                   

                   

                   

                   

                   

                    • Re: PI integration with Maximo

                      Priyanka posted the DLL (from her VS2010 compile) here:

                       

                      vcampus.osisoft.com/.../7953.aspx

                       

                      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).

                        • Re: PI integration with Maximo

                          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.= =

                           

                          <Notification>
                            <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>
                          </Notification>

                           

                          = = = = = = = = = = = = = = >

                           

                          <= = 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:template match="/">
                          <xsl:value-of select="//*[contains(@name,'WriteToTag')]"/>,<xsl:value-of select="//*[@name='TriggerTime']"/>,<xsl:value-of select="//*[contains(@name,'TagValue')]"/>
                          </xsl:template>
                          </xsl:stylesheet>

                           

                          = = = = = = = =  = = =  >

                           

                          <= = After transform = =

                           

                          sinusoid,4/4/2011 9:40:00 PM,376

                           

                          = = = = = = = = = = = = =

                           

                          PI-UFL is a standard interface - see the User Manual for more details.

                            • Re: PI integration with Maximo
                              andreas

                              Just before the developers jump in  

                               

                              Gopal

                               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

                               

                              Gopal

                              ... 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.

                                • Re: PI integration with Maximo

                                  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.

                                    • Re: PI integration with Maximo
                                      andreas

                                      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:

                                       

                                      [INTERFACE]
                                      PLUG-IN=ASCIIFiles.dll
                                       
                                      [PLUG-IN]
                                      IFM=E:\PIPC\Interfaces\PI_UFL\Examples\XML\*.xml
                                      IFS=N
                                      REN=_OK
                                      ERR=BAD
                                      PURGETIME=1d
                                      PFN=False
                                      NEWLINE=13,10
                                       
                                      [SETTING]
                                      DEB=4
                                      MAXLOG=10
                                      MAXLOGSIZE=20
                                      MSGINERROR=E:\PIPC\Interfaces\PI_UFL\Examples\XML\errors_xml.out
                                      OUTPUT=E:\PIPC\Interfaces\PI_UFL\Examples\XML\pi_ufl_xml.out
                                      LOCALE=en-us
                                       
                                      [FIELD]
                                      FIELD(1).NAME="TAG_ID"
                                      FIELD(1).TYPE="String"
                                      FIELD(3).NAME="TIMESTAMP"
                                      FIELD(3).TYPE="DateTime"
                                      FIELD(3).FORMAT="M/d/yyyy h:mm:ss pp"
                                      FIELD(8).NAME="VALUE"
                                      FIELD(8).TYPE="String"
                                       
                                      [MSG]
                                      MSG(1).NAME="MSG_TimeStamp"
                                      MSG(2).NAME="MSG_TagName"
                                      MSG(3).NAME="MSG_Value"
                                       
                                      [MSG_TimeStamp]
                                      MSG_TimeStamp.FILTER=C1=="*TriggerTime*"
                                      TIMESTAMP=["*>(*)<*"]
                                       
                                      [MSG_TagName]
                                      MSG_TagName.FILTER=C1=="*WriteToTag*"
                                      TAG_ID=["*>(*)<*"]
                                       
                                      [MSG_Value]
                                      MSG_Value.FILTER=C1=="*TagValue*"
                                      VALUE=["*>(*)<*"]
                                      StoreInPI(TAG_ID, ,TIMESTAMP,VALUE, , )
                                       
                                       

                                        • Re: PI integration with Maximo

                                          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:

                                           

                                          vcampus.osisoft.com/.../7832.aspx

                                           

                                           

                                           

                                          This example calls a SharePoint web service to add to a PI Notification alert to a SharePoint List.

                                            • Re: PI integration with Maximo
                                              junechong

                                              i can't find the download for RLINK - MRO Maximo Install Kit. anyone ?

                                                • Re: PI integration with Maximo
                                                  andreas

                                                  RLINK - MRO Maximo is not available through vCampus.

                                                    • Re: PI integration with Maximo
                                                      junechong

                                                      there is a post up there for link to download OPC client (Maximo) .... once i click on it , it is not available.

                                                        • Re: PI integration with Maximo
                                                          hanyong

                                                          Hi June,

                                                           

                                                          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.

                                                            • Re: PI integration with 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.

                                                               

                                                               

                                                                • Re: PI integration with 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:

                                                                   

                                                                  pulse.vportal.net/index.cfm

                                                                   

                                                                  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

                                                                   

                                                                  Level: All

                                                                   

                                                                  Speakers:

                                                                   

                                                                  Scott Larson, GenPower Services, LLC.

                                                                   

                                                                  Gopal GopalKrishnan, P.E., OSIsoft, LLC.

                                                                   

                                                                  ABSTRACT:

                                                                   

                                                                  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).

                                                                   

                                                                  = = = >

                                                                   

                                                                   

                                                                   

                                                                   

                                                                    • Re: PI integration with Maximo
                                                                      junechong

                                                                      thank Gopal . manage to get the slides ...

                                                                        • Re: PI integration with Maximo
                                                                          tboers

                                                                          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?

                                                                           

                                                                          Thanks!

                                                                            • Re: PI integration with Maximo

                                                                              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.

                                                                               

                                                                               

                                                                                • Re: PI integration with Maximo

                                                                                  The full set of files from vCampus 2011 used in the SAP/Maximo Lab is at the URL below:

                                                                                   

                                                                                  vcampus.osisoft.com/.../vCampusLive2011_5F00_SAPMaximoLab.zip.aspx

                                                                                   

                                                                                   

                                                                                   

                                                                                   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.

                                                                                   

                                                                                  There is no “User Manual” for the custom XML Delivery Channel; you are encouraged to review the code and the inline comments to become familiar with its functionality.

                                                                                   

                                                                                  The XML Delivery Channel is not “supported” via OSIsoft technical support.  The code is provided on an “as is” basis to illustrate the extensibility features of PI Notifications Delivery Channel. 

                                                      • Re: PI integration with Maximo
                                                        Guevara

                                                        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.

                                                          • Re: PI integration with Maximo
                                                            Mike Zboray

                                                            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.

                                                  • Re: PI integration with Maximo

                                                    (moved this discussion thread to the appropriate forum: PI System Integration)