• State Verified Answer
  • Replies 2 replies
  • Subscribers 3 subscribers
  • Views 483 views
  • Users 0 members are here
Options
Related

Can I bulk retrieve point data using only Pointid?

James.Aylard

Using DataLink or PI Builder, is it possible to retrieve point attributes in bulk by providing only the pointid? I would like to retrieve the point name and ideally other attributes, but I do not see how to do this, in bulk, using only the pointid. Since PI logs often only include the pointid to identify a point with issues, it seems there must be some way to do this.

 

Thanks.

Parents
  • 0

    ​ PI DataLink is a client tool to retrieve time series data, whereas PI Builder is a client tool for configuration. Inherently they serve two different purposes. It seems you're better serve with PI Builder based on what I can infer from your question - I read that you're trying to do some sort of debugging with PI Points. However, your question is on "how" to do something and doesn't explain the "what" problem you're trying to solve.

     

    Given the lack of information of what problems you're trying to solve, I will attempt to describe what you can do with PI Point ID in PI Builder.

     

    First off, in the Tag Search dialog box, you can search by PI Point ID. To do this, go to the search bar (rectangular box really) and type in "PointID:XX" with XX being a number corresponding to the PointID of interest. The search will return the PI Point with that PointID. This is one way to find the PI Point corresponding to the PointID of interest.

     

    Secondly, create a blank Excel spreadsheet and select the "Headers" icon, select PI Point as your object type, then pick-n-choose the columns (headers) that you want on your spreadsheet, including the required columns. Once you have that, populate the PointID column with the PI Point ID of interest, then put "x" in the corresponding 1st column and populate the "ObjectType" column with "PIPoint". Now select "Retrieve" and you will get the PI Point configuration for all the PI Point ID that you have listed in the spreadsheet.

     

    Hope this helps.

     

Reply
  • 0

    ​ PI DataLink is a client tool to retrieve time series data, whereas PI Builder is a client tool for configuration. Inherently they serve two different purposes. It seems you're better serve with PI Builder based on what I can infer from your question - I read that you're trying to do some sort of debugging with PI Points. However, your question is on "how" to do something and doesn't explain the "what" problem you're trying to solve.

     

    Given the lack of information of what problems you're trying to solve, I will attempt to describe what you can do with PI Point ID in PI Builder.

     

    First off, in the Tag Search dialog box, you can search by PI Point ID. To do this, go to the search bar (rectangular box really) and type in "PointID:XX" with XX being a number corresponding to the PointID of interest. The search will return the PI Point with that PointID. This is one way to find the PI Point corresponding to the PointID of interest.

     

    Secondly, create a blank Excel spreadsheet and select the "Headers" icon, select PI Point as your object type, then pick-n-choose the columns (headers) that you want on your spreadsheet, including the required columns. Once you have that, populate the PointID column with the PI Point ID of interest, then put "x" in the corresponding 1st column and populate the "ObjectType" column with "PIPoint". Now select "Retrieve" and you will get the PI Point configuration for all the PI Point ID that you have listed in the spreadsheet.

     

    Hope this helps.

     

Children
No Data