Editing tag values logged in tag history / citadel database

[Stuart Wilson]

Hi,

I having been logging data from input/output tags and memory tags to my citadel database over the past week and due to some errors in my vi (my fault) some values are showing on my trends that are incorrect. These values are affecting my calculations (e.g. zeros, infinite numbers etc) and I would really like to delete them if possible.

Does anyone know a way of going in to the database/tag history and selecting and deleting values whilst still leaving other data in tact?

Many thanks,

Stuart

[TimM(AE)]

You can remove the data from a Citadel database using LabVIEW, Lookout or Measurement and Automation Explorer (MAX). This is a two step process:

1. First you archive the data that you want to delete. When archiving, choose to delete this data from the original database. The archiving operation will move the data from your database to new database.
2. The second step is to delete the new archived database. This removes the extra database that was created by the archive operation. Once the data has been archived you can remove the archived data by either deleting the database manually or by using file VIs from LabVIEW.

The document elaborates this process for MAX, LabVIEW and Lookout separately

• Measurement and Automation Explorer (MAX) You must have Historical Data Viewer installed. It comes with Lookout 5.0 and LabVIEW DSC 6.1.
  To remove the historical data in MAX, follow these steps:
1. Under the Historical Data folder in MAX, select the database that you want to remove data from.
2. Right-click the database and select New View»Trace. This creates a trace view with the default name of New View under the database folder.
3. On the Trace Attributes page, click on Add new traces. Select the traces you want to archive.
4. Select a starting and stopping time.
5. Right-click New View and select Archive.
6. Enter a directory path to store the archived data.
7. Check the Delete data from source database checkbox to delete the data from the source database.
8. Click Start.
9. Once it is complete, click Close.