Table of Contents
1. Introduction
This will be a guide to show how to Obsolete tags from your Canary historian. In the event that you need to be sparing with the tags in your historian, you would want to reclaim some of the licensed tags. Your tags will not be removed from the past data, but it will clear up the tag count on your license. There are a few reasons you would need to do this. If your tags are no longer used or have been deleted from your PLC. If you are no longer historizing tags or they have been replaced. If, for some reason, you are over your licensed tag count.
There are 5 main steps that you need to follow to … (summary of steps that will follow in detail below):
- Get a report of the relevant tags in Ignition that were logging to Canary, along with the Tag list from Canary for the specific dataset tied to the Collector.
- Format both lists the same, and use a VLOOKUP to compare the lists to find tags that are no longer being historized.
- Create a new CSV of obsolete tags.
- Observe the licensed tag count and the obsolete tags.
- Summary
These steps are described in greater detail in the following sections.
2. Getting the Tag lists
- We have unticked history in Ignition, but the tags still exist in Canary
Get a Tag list from Ignition to see which tags are no longer historizing:
- Use the Report tool and set up the parameters to be similar to those shown. Traits – History Enabled,
- Click the “Property button below the “include UDT Definitions” and set Name to Storage Provider LIKE CanaryLocal (Which will be the Collector we use for the Tags we are interested in).
- Press search to see the list.
- Export the tag list using the button in the top right. It will generate a CSV file. (The Quality and Tag type are default generated, we will clear it out in Excel.)
Get the Tag list from Canary(This will be a list of the Tags that have been historized):
Open the historian tile, look for the white drop down arrow inside of your dataset and then inside one of the HDB files.
Deselect the include parent path
- When you just want to drop your tag count from your license tags.
All you need are the tag paths that you don’t need anymore in a csv file, they need to be in the same tag structure as they are in your Canary.
3. Format and filter the lists
First we will replace ,”AtomicTag”,”Good” with nothing.
We need the tags from Ignition to have the same structure as Canary. So we will change the Delimiter from “/” to “.”
We add a column called “Is Canary Tag in Ignition Tag list” and set the formula to:
=SUMPRODUCT(–EXACT(A2; B$2:B$100))>0
This will compare each row to see if the Canary Tag is still in Ignition. We also set the data to filter by this column so we can narrow the list.
We now have a list of Tags that are no longer being historized but still exist in your Canary Historian.
4. Create CSV with the difference
Copy the List of Tags we filtered to a new Spreadsheet without the Header. Save the document as a UTF-8 CSV.
5. Obsolete the tags
Go to the Canary Administrator. Make sure the logging session which logs to your dataset is stopped before proceeding. Disabling the collector on the Gateway will be the easiest.
- Open the Historian tile.
2. Find and enter the Dataset where you are logging to from Ignition.
3. Find the White dropdown arrow, and you will see more options appear.
4. Select the Obsolete Tag option
6. Find the CSV and open it, and then press ok.
7. You should see the following success pop-up.
8. If it is unsuccessful, read through the error logs and make the adjustments recommended.
9. If successful, go back to the Dataset Options in step 4 and do a Roll-over; otherwise, the automatic daily roll-over will show your active tags only.
6. Summary
Here is a summary of what you need to do:
- Get your tags no longer needed in the historian.
- Create a csv and make the list of tags you wish to obsolete with no headers.
- Goto the dataset with your tags in, and obsolete.
For additional resourcing, please direct yourself to the Canary user manual:
https://helpcenter.canarylabs.com/t/35yfymm/obsoleting-tags-from-a-dataset-version-25
If you are using older versions :
https://helpcenter.canarylabs.com/t/p8y8glp/obsoleting-tags-from-a-dataset-version-24
https://helpcenter.canarylabs.com/t/g9hvl8g/obsoleting-tags-from-a-dataset-version-23