Import Trends

Hi, I'm working on a project where some of the existing field equipment  changed.

I needed to changes trend data so I copied the existing data to another location.

I then deleted the trend data in the Data folder so that the trending would re-initialise correctly with the new devices.

I want to import the data I backed up to another location.

I've seen some methods in the forum on how to best achieve this.

Can anyone offer some advice?

Does the Trend Server have to be stopped before importing Trend Data or can it be done while it is running?

Any advice would be greatly appreciated.

Many thanks.

Parents
  • Hi ,

    This is a common issue and one that lots of customers request we fix, see this SCADA Ideas post:
    https://citectscada.ideas.aha.io/ideas/SCADA-I-16

    Unfortunately, at the moment the only way to modify Trend Tags is what you have done. The only issue is getting the old Trend data back into the new Trend tags. It isn't easy and is a fair bit of work. I have done this before when working in the project delivery team for a couple of customers. So it is possible, like I said, just a bit involved and something you need to carefully plan and test before doing it on your production system.

    Basically you have two main steps:
    1. Export data from the old trend history files into CSV format (Batch Trend Export to CSV)
    https://softwareforums.aveva.com/citect_community/cit-toolbox/f/187/t/24070
    2. Import data into the trend tag using Cicode (Trend Import CSV)
    https://softwareforums.aveva.com/citect_community/cit-toolbox/f/187/t/24075

    So you definitely need to do step two when Citect is running, since you need to execute cicode to complete the work to import the data.

    Wishing you the best of luck. If you haven't already, consider up-voting the SCADA Idea Trend modify post.
Reply
  • Hi ,

    This is a common issue and one that lots of customers request we fix, see this SCADA Ideas post:
    https://citectscada.ideas.aha.io/ideas/SCADA-I-16

    Unfortunately, at the moment the only way to modify Trend Tags is what you have done. The only issue is getting the old Trend data back into the new Trend tags. It isn't easy and is a fair bit of work. I have done this before when working in the project delivery team for a couple of customers. So it is possible, like I said, just a bit involved and something you need to carefully plan and test before doing it on your production system.

    Basically you have two main steps:
    1. Export data from the old trend history files into CSV format (Batch Trend Export to CSV)
    https://softwareforums.aveva.com/citect_community/cit-toolbox/f/187/t/24070
    2. Import data into the trend tag using Cicode (Trend Import CSV)
    https://softwareforums.aveva.com/citect_community/cit-toolbox/f/187/t/24075

    So you definitely need to do step two when Citect is running, since you need to execute cicode to complete the work to import the data.

    Wishing you the best of luck. If you haven't already, consider up-voting the SCADA Idea Trend modify post.
Children
No Data