Hi,
I need to remap several hundreds of data points with new names & new structures.
I want to keep the history of those data points. Can be the history of the old datapoints linked with the new one?
(for example: display history of the old data point name by using the new names?)
Those datapoints are archived in a Oracle database.
Thanks in advance for your help,
Lionel.
How to keep history after remapping archived datapoints?
- lwallet
- Posts:19
- Joined: Mon Oct 23, 2017 3:50 pm
How to keep history after remapping archived datapoints?
- fmulder
- Posts:330
- Joined: Wed Feb 03, 2010 9:46 am
Re: How to keep history after remapping archived datapoints?
The standard answer is probably no but the 'old' data is relationally linked to a table called 'ELEMENTS'.
Maybe you can:
* Copy the table 'ELEMENTS' to a new name e.g. 'OLD_ELEMENTS"
* then make your new structure -> this will cause a new set of dp elements in 'ELEMENTS'
* Make a view to link the new element to the old
This will not be a simple solution but should be doable.
You could also consider to write your new dp element ID into all the old values. Again, not too simple
share the fun
Frenk Mulder
Maybe you can:
* Copy the table 'ELEMENTS' to a new name e.g. 'OLD_ELEMENTS"
* then make your new structure -> this will cause a new set of dp elements in 'ELEMENTS'
* Make a view to link the new element to the old
This will not be a simple solution but should be doable.
You could also consider to write your new dp element ID into all the old values. Again, not too simple
share the fun
Frenk Mulder