Bulk Upload CU Tags

You can take a list of CU Tags from Excel and bulk upload them into Solution Center.

For the tags to properly upload:

• The tags need to be in Sheet 1 of the Excel table.

• They need to start in Column A, Row 1 in the Excel table (also known as cell A1).

• They cannot have row breaks (empty rows) among them. All the tags need to be contiguous like the following example of roadside hazards:

  

  NOTE: Do not worry about the alphanumeric sorting of the tags. Upon upload, they are automatically re-sorted in alphanumeric fashion.

To bulk upload CU Tags, follow these steps:

1. Ensure your Excel table meets the criteria above.

2. Save your Excel table (the name of the table does not matter to Solution Center).

3. In Solution Center, click Designer > Client Application > CU Tags.

4. Click the Add button.

5. Type a descriptive name for the Tag Category. This name is visible in the client application, so ensure it is understandable for users.

6. If desired, check the box to Allow Multiple Tags.

   1. Allowed: The user can add more than one tag from the category to a CU.

   2. Not Allowed: The user can add only one tag from the category to a CU.

7. Choose a Color.

8. Near “Tags,” click Bulk Upload.

9. Locate the Excel table.

10. Click the Excel table to highlight it, then click Open.

11. A confirmation dialog appears confirming the number of tags it found to upload. Click Upload (or, click Cancel if the number does not seem correct and investigate if you selected the correct Excel table).

    NOTE: If your list happens to have duplicate tags, they are not entered in duplicate fashion. For example, if “Blind Curve” happened to be listed twice in Excel, it is only added once in Solution Center.

12. Visually confirm the tags look appropriate.

    

13. After Bulk Upload, the list is automatically saved. However, if you then make small changes, ensure you click Save for those changes to persist.