About this task
You can use the Excel Add-In to add tags to your Historian system or to modify parameters for existing tags. For example, you can generate and define new tags either automatically or manually in an Excel worksheet and then import them in bulk to the Historian system.This can be a very convenient mechanism when you are working with large numbers of tags. If any conflicting names or parameters occur, the system displays a warning message to alert you to the problem. You can then eliminate the conflict and try again.
You can also modify tag parameters by editing them in the worksheet and then bulk importing them into Historian.
Procedure
- Build a tag worksheet in Excel using macros or any other tools you are familiar with.
Since Historian requires information about each tag that varies with the type of tag selected, verify that you have included all required information in the worksheet before attempting to import it into Historian. To determine what specific tag information is required, refer to the documentation provided with your SCADA application.
- Use the Import Tags command to bulk import this information into your Historian application.
Note: If any errors on the import occur, a window appears detailing the issues encountered during the import. If any error occurred with any line of the import, the whole import is aborted.