Rockwell Automation FactoryTalk Historian SE 3.0 H2H Interface Installation and Configuration Guide - Manual (Page 26)

Chapter 5 Creating Multiple FTSS Tags
26 Rockwell Automation Publication H2H-IN001A-EN-E–July 2012
3. In the Add-Ins tab, click PI-SMT, and select Import Tags.
The Import PI Tags dialog box appears.
4. Under Import from, select the Source Server that uses the
FTLD interface.
NOTE
If the server is not listed, click Connections and add the server
in the Connection Manager. Refer to the help in the Connection
Manager for more information.
5. Under Point Source, type FTLD.
6. Click OK. The tags are imported and displayed in the Excel
workbook.
In these steps we will automate the process of creating FTSS tags
described in "Create a Target Point on the Target Server (page 21)".
To create FTSS tags:
1. In the Excel workbook, select the tag names in the Tag column
for which you want your H2H Interface to collect data.
2. Press Ctrl+C to copy the names of the tags.
3. Click Sheet2, press Ctrl+V to paste the names of the tags to
the A column, starting from the A1 cell.
4. In the B1 cell, type STAG=.
5. In the C1 cell, type =$B$1&A1.
In this way you create a formula that will add the expression
from the B1 cell to all the cells to which you will copy it.
6. In the C column, copy the C1 cell and paste it in the
subsequent cells of the column that are located in the rows
with the tag names you have pasted in the A column.
In this way you add a
STAG= expression to each name of the
tag.
7. Copy the modified tag names from the C column.
8. Click Sheet1 and go to the exdesc column.
Create FTSS Tags