• State Not Answered
  • Replies 3 replies
  • Subscribers 2 subscribers
  • Views 74 views
  • Users 0 members are here
Options
Related

What's the best way to copy historical data from one PIPoint to another (on the same archive)?

gmalek

This could be doable with a custom program, but are there any out of the box tools for this, such as a command-line utility? Since both PI Points are on the same archive, I figured PI-to-PI would be out of the question.

Parents
  • 0

    While ​ has provided a custom code solution, I have an important question: is this to be a one-time copy, or once-a-day, or continually?

     

    I am sure you are well versed in (A) the MaxArcCollect limit, (B) know something about the data rate of the tag(s) in question, and (C) know how wide of a time range you are interested in. For a big copy, A, B, and C all are factors on what you can do.

     

    If it is a one-time copy and there are less than 1.5 million values, you can use SMT's Archive Editor to copy values from the source tag and paste into the target tag. For a small amount of tags, this is easy enough but for a huge amount of tags there can be a lot of inconvenient scrolling as well as very long wait times. But SMT is a build-in tool to help you achieve your goal.

     

    If you wanted continual (event-triggered) or periodic updates, you can do this with an Asset Analysis. It would be a very simple Expression, and Analytics is considered a build-in tool. There is a limitation on how far back in history you can go, so you may need to catch-up on history to present before using Analytics to perform perpetual updates.

Reply
  • 0

    While ​ has provided a custom code solution, I have an important question: is this to be a one-time copy, or once-a-day, or continually?

     

    I am sure you are well versed in (A) the MaxArcCollect limit, (B) know something about the data rate of the tag(s) in question, and (C) know how wide of a time range you are interested in. For a big copy, A, B, and C all are factors on what you can do.

     

    If it is a one-time copy and there are less than 1.5 million values, you can use SMT's Archive Editor to copy values from the source tag and paste into the target tag. For a small amount of tags, this is easy enough but for a huge amount of tags there can be a lot of inconvenient scrolling as well as very long wait times. But SMT is a build-in tool to help you achieve your goal.

     

    If you wanted continual (event-triggered) or periodic updates, you can do this with an Asset Analysis. It would be a very simple Expression, and Analytics is considered a build-in tool. There is a limitation on how far back in history you can go, so you may need to catch-up on history to present before using Analytics to perform perpetual updates.

Children
No Data