Table Of Contents
Cisco StadiumVision Director Bulk Administration Tool
Prerequisites for the Bulk Administration Tool
Restrictions for the Bulk Administration Tool
Information About the Bulk Administration Tool
Locations and DMPs TSV File Format
Locations to DMP Mapping TSV File Format
How to Use the Bulk Administration Tool
Exporting and Downloading a TSV File for Locations and DMPs
Creating a DMP or Location Entry in a TSV File
Creating an IP Phone or Third Party Device Entry
Exporting and Downloading a TSV File for DMP Mapping
Exporting Luxury Suite Names and PIN Information
Configuration Examples for the Bulk Administration Tool
Example: Linking and Unlinking Existing DMPs to Locations Using a TSV File
Troubleshooting the Bulk Administration Tool
Feature Information for the Cisco StadiumVision Director Bulk Administration Tool
Cisco StadiumVision Director Bulk Administration Tool
First Published: November 4, 2011The Bulk Administration Tool is functionality within the Cisco StadiumVision Director software that provides an alternative to manually defining DMPs, IP Phones, locations, and third-party touch panels in the Devices area of the Control Panel. It allows you to add, delete, or modify device definitions in bulk to the Cisco StadiumVision Director database as a batch export and import of data.
In addition to defining the DMPs, you can use the Bulk Administration Tool to associate the DMP with a particular location. This is referred to as linking or creating a DMP-to-location mapping.
Beginning in Cisco StadiumVision Director Release 2.4, you also can use the Bulk Administration Tool to export a list of configured suite names and PIN information.
Note This document contains information about BAT through Cisco StadiumVision Director Release 3.0. For a list of changes in Cisco StadiumVision Director Release 3.1, see the Release Notes for Cisco StadiumVision Director Release 3.1.
Contents
•Prerequisites for the Bulk Administration Tool
•Restrictions for the Bulk Administration Tool
•Information About the Bulk Administration Tool
•How to Use the Bulk Administration Tool
•Configuration Examples for the Bulk Administration Tool
•Troubleshooting the Bulk Administration Tool
•Feature Information for the Cisco StadiumVision Director Bulk Administration Tool
Prerequisites for the Bulk Administration Tool
Before you use the Bulk Administration Tool, be sure that the following requirements are met:
•You have a Cisco StadiumVision Director user account that is configured for an administrator role.
•Determine the TV locations and a naming convention for devices that you want to add. A good naming convention will aid in problem isolation and troubleshooting, enabling you to more easily identify a TV or DMP that is experiencing difficulty.
Restrictions for the Bulk Administration Tool
When using the Bulk Administration Tool, consider the following restrictions:
•The Bulk Administration Tool has been tested with Microsoft Excel 2007. Other versions have not been tested, but might also work.
•The Bulk Administration Tool supports tab-delimited text format only beginning in Cisco StadiumVision Director Release 2.4. This is the preferred format for Unicode text to support internationalization and localization.
Note When updating files, be sure to save text files as `Unicode text (*.txt) and not `Text (Tab Delimited) (*.txt)' format for import into Cisco StadiumVision Director.
•To avoid errors due to truncation, limit the contents of the CSV fields to 200 characters in length.
•When you import a file, the following limitations exist:
–No message is displayed when the import is completely successful.
–No error message is displayed if the imported file is not saved as a unicode text file format "Unicode text (*.txt)" using tab-separated values. In this case, the file is simply ignored and no action is taken. Be sure that you can confirm that your imported data has been uploaded.
Information About the Bulk Administration Tool
The Bulk Administration Tool for Cisco StadiumVision Director provides an alternative to manually adding, updating or deleting device information in the StadiumVision Director database. Device information can include DMPs, IP Phones, and third-party touch screens used for local TV control.
The Bulk Administration Tool uses a tab-separated values (TSV) text file to import and export data. This file can be edited using a standard spreadsheet application, such as Microsoft Excel.
Before the data is imported, the Bulk Administration Tool gets the current configuration from StadiumVision Director (which might be empty, if this is the first time you are using the tool), merges the two sets of information, and checks for errors. If no errors are found, the Bulk Administration Tool synchronizes the database. If errors are found, the Bulk Administration Tool returns an error message, as described in the "Possible Error Messages" section.
The Bulk Administration Tool in Cisco StadiumVision Director Release 2.4 supports the following functions:
•DMPs, luxury suites, locations, and local control devices (IP Phone, AMX or Crestron touch panels) can be loaded into the Cisco StadiumVision Director database in a bulk manner.
•Bulk association of DMP to Location is enabled using the "Entry Type" field to support the location association.
•Can be used in connection with an off-the-shelf bar code scanner for capturing DMP MAC addresses and TV Location IDs.
•Incremental updates are supported, allowing the tool and the Cisco StadiumVision Director user interface to be used interchangeably.
•The Bulk Administration Tool supports internationalization (i18n) for import/export of data, and for localization (L10n) of messages and headers.
•Data files for the Bulk Administration Tool should be saved and imported as .txt data files in Unicode or UTF-16 format. Exported data is in UTF-16LE with Byte Order Mark (BOM)—this format is supported in Microsoft Windows and Apple MAC environments for all Unicode, including double-byte characters found in Chinese.
Note Microsoft Excel 2007 does not support UTF-16LE format, but you can use Unicode UTF-8.
•TSV data is validated upon upload and any errors detected are logged in a separate file.
•Existing database records can be deleted or modified in bulk using the "Operation Type"field.
TSV File Formats
The format of the TSV file differs depending on whether you are using export/import from the Locations & DMPs tab or from the Locations-DMP Mapping tab in the Devices window of Control Panel Setup.
Locations and DMPs TSV File Format
Table 1 describes the TSV file format and field descriptions for the text file used for import and export of information from the Locations & DMPs tab on the Devices screen of the Control Panel Setup window.
Locations to DMP Mapping TSV File Format
Table 2 describes the TSV file format and field descriptions for the text file used for import and export of information from the Locations-DMP Mapping tab on the Devices screen of the Control Panel Setup window.
How to Use the Bulk Administration Tool
This section includes the following tasks:
•Exporting and Downloading a TSV File for Locations and DMPs
•Exporting and Downloading a TSV File for DMP Mapping
•Exporting Luxury Suite Names and PIN Information
Exporting and Downloading a TSV File for Locations and DMPs
Tip If you do not yet have any information for Locations and DMPs in the Cisco StadiumVision Director Server, you can export an empty file that will have the appropriate formatting for headings only so that you can add new Locations and DMPs from a spreadsheet application.
To export and download a TSV file for Location and DMP information from the Cisco StadiumVision Director server, complete the following steps:
Step 1 Log into Cisco StadiumVision Director as an administrator.
Step 2 From the Cisco StadiumVision Director main menu, click Control Panel.
The Control Panel window is displayed in a new window.
Step 3 From the Control Panel window, click Setup > Devices > Locations & DMPs tab.
Step 4 Click Export.
Step 5 When the Export box displays, click Download.
Step 6 When the "Select location for download" window appears, type the name of the .txt file that you want to save, or accept the default name and click Save.
Editing a TSV File
This section describes some of the related tasks to modify a TSV file with data to be imported into Cisco StadiumVision Director. This section includes the following tasks:
•Creating a DMP or Location Entry in a TSV File
•Creating an IP Phone or Third Party Device Entry
Figure 1 shows a sample TSV file with data showing delete, update, and create operation types as a reference for the tasks described in this section.
Figure 1 Sample Edit of a TSV File
Creating a DMP or Location Entry in a TSV File
To create a DMP or Location entry in a TSV file, complete the following steps:
Step 1 Open the file that you exported from the Cisco StadiumVision Director Server in a standard spreadsheet application (such as Microsoft Excel), as a tab-delimited text (.txt) file.
Step 2 In the first available cell of the Operation Type column, type create (see Figure 1).
Step 3 In the corresponding Entry Type cell, type one of the following values with the appropriate case:
•DMP—Specifies that the entry is for a new DMP.
•LOCATION—Specifies that the entry is for a physical location of the TV to which the DMP is attached.
•LOCATIONn—Specifies that the entry is for both the DMP and the location.
Step 4 Complete the remaining cells according to the Entry Type that you specified, and refer to Table 1 for a description of optional and required fields:
•For a new DMP entry—Data supplied should include the IP address, Name, Model Name, and TV Type. Only the IP address, Name, and Model Name are required.
Timesaver The MAC address is populated automatically when Cisco StadiumVision Director polls the DMP using its IP address.
•For a new LOCATION entry— Data supplied should include the Location Name and the Location ID (optional).
Step 5 Save the file as a Unicode text (*.txt) file.
Note Do not save as `Text (Tab Delimited) (*.txt).
Creating an IP Phone or Third Party Device Entry
To create an IP phone or third party device entry in a TSV file, complete the following steps:
Step 1 Open the file that you exported from the Cisco StadiumVision Director Server in a standard spreadsheet application (such as Microsoft Excel), as a tab-delimited text (.txt) file.
Step 2 In the first available cell of the Operation Type column, type create (see Figure 1).
Step 3 In the corresponding Suite Control Type cell, type one of the following values with the appropriate case:
•Infrared
•IP Phone
•3rd Party
Note An IP phone can only be created as part of a LOCATION or LOCATIONn entry type. So, you can either add the IP Phone as part of a LOCATION "create" entry, or a LOCATION "update" entry. For more information about updating an existing entry, see the "Updating an Existing Entry" section.
Step 4 Complete the remaining cells according to the Suite Control Type that you specified, and refer to Table 1 for a description of optional and required fields.
Step 5 Save the file as a Unicode text file.
Note Do not save as `Text (Tab Delimited) (*.txt).
Deleting an Existing Entry
To delete an existing entry in a TSV file, complete the following steps:
Step 1 Open the file that you exported from the Cisco StadiumVision Director Server in a standard spreadsheet application (such as Microsoft Excel), as a tab-delimited text (.txt) file.
Step 2 In the Operation Type cell that corresponds to the entry that you want to remove, type delete (see Figure 1).
Step 3 Save the file as a Unicode text file.
Note Do not save as `Text (Tab Delimited) (*.txt).
Updating an Existing Entry
For most fields that you want to update, simply overwrite the existing value and Cisco StadiumVision Director will replace that value based on the matching MAC or IP address for the entry when you import the data.
For name-related fields, the updates are made in two separate cells—one that states the original "old" name, and one that specifies the modified name. For example, Figure 1 shows how to change the name of LOCATIONn at 10.50.1.4. The original name of "300-SW-021" is typed in the cell labeled "Old Name," and the modified name of "100-SE-031" is typed in the cell labeled "Name."
To update an existing entry in a TSV file, complete the following steps:
Step 1 Open the file that you exported from the Cisco StadiumVision Director Server in a standard spreadsheet application (such as Microsoft Excel), as a tab-delimited text (.txt) file.
Step 2 In the Operation Type cell that corresponds to the entry that you want to modify, type update (see Figure 1).
Step 3 Complete the appropriate cells for the corresponding field values that you want to modify (according to the type of entry that you are changing), and refer to Table 1 for a description of optional and required fields.
Tip Any field that that you do not want to change can be left blank.
Step 4 To change the value of a name-related field, do one of the following:
•To rename a device:
–Copy the value from the "Name" field, to the "Old Name" field.
–Type the new name in the "Name" field.
•To rename a suite:
–Copy the value from the "Suite Name" field, to the "Old Suite Name" field.
–Type the new name in the "Suite Name" field.
•To rename a suite controller:
–Copy the value from the "Suite Controller Name" field, to the "Old Suite Controller Name" field.
–Type the new name in the "Suite Controller Name" field.
Step 5 Save the file as a Unicode text file.
Note Do not save as `Text (Tab Delimited) (*.txt).
Exporting and Downloading a TSV File for DMP Mapping
You can export two forms of TSV files from the Location-DMP Mapping tab, with the following information:
•MAC address information only (exported from the Available Devices box)— TSV file that contains all of the MAC addresses from existing DMPs that you can use to copy into the TSV file with location information to link existing MAC addresses to locations.
•MAC address and location information (exported from the Locations box)—TSV file that contains MAC addresses, location names, and location IDs. This file is used to link or unlink DMPs from locations.
To export and download a TSV file for DMP mapping information from the Cisco StadiumVision Director server, complete the following steps:
Step 1 Log into Cisco StadiumVision Director as an administrator.
Step 2 From the Cisco StadiumVision Director main menu, click Control Panel.
The Control Panel window is displayed.
Step 3 From the Control Panel window, click Setup > Devices > Location-DMP Mapping tab.
(Optional) To export a list of available MAC addresses only for existing DMPs, complete the following steps:
Step 4 In the Available Devices box, click Export.
a. When the Export box displays, click Download.
b. When the "Select location for download" window appears, type the name of the .txt file and specify the file location, or accept the default name and click Save.
A TSV file that contains only MAC addresses is created.
To export the current mapping of DMPs to Locations, complete the following steps:
Step 5 In the Locations box, click Export.
a. When the Export box displays, click Download.
b. When the "Select location for download" window appears, type the name of the .txt file and specify the file location, or accept the default name and click Save.
A TSV file that contains MAC addresses, Location names, and Location IDs is created.
Importing a TSV File
To import a TSV file to Cisco StadiumVision Director server, complete the following steps:
Step 1 Log into Cisco StadiumVision Director as an administrator.
Step 2 From the Cisco StadiumVision Director main menu, click Control Panel.
The Control Panel window is displayed.
Step 3 Do one of the following:
•To import a TSV file for DMP mapping, from the Control Panel window, click Setup > Devices > Locations & DMPs tab. Click Import.
•To import a TSV file for DMP mapping, from the Control Panel window, click Setup > Devices > Location-DMP Mapping tab. Click Import.
Step 4 When the "Select file for upload" window appears, select the location and name of the .txt file that you want to import, and click Open.
When the import is complete, a message is displayed that shows the total number of records that were processed, the number that were successfully processed, and the number that failed.
No confirmation is provided if the import is completely successful. See also the "Restrictions for the Bulk Administration Tool" section.
If any records failed, a message box is displayed that allows you to save a text file that includes only the rows that contain errors and an indicator of the error. For more information, see the "Troubleshooting the Bulk Administration Tool" section.
Exporting Luxury Suite Names and PIN Information
Beginning in Cisco StadiumVision Director Release 2.4, you can generate PINs for luxury suites, and you can manage these assignments by exporting the configured PINs for all luxury suites in a tab-delimited text file using the Bulk Administration Tool.
Note You cannot import PIN information to Cisco StadiumVision Director.
To export luxury suite names and PIN information from the Cisco StadiumVision Director server, complete the following steps:
Step 1 Log into Cisco StadiumVision Director as an administrator.
Step 2 From the Cisco StadiumVision Director main menu, click Control Panel.
The Control Panel window is displayed.
Step 3 From the Control Panel window, click Setup > Luxury Suite > Local Control PINs tab.
Step 4 Click Export.
Step 5 When the Export box displays, click Download.
Step 6 When the "Select location for download" window appears, type the name of the .txt file that you want to save, or accept the default name and click Save.
A TSV file that contains suite names, PIN names, PIN types, and modify dates is created. You can import this file into a standard spreadsheet application as a tab-delimited text file as with other downloaded text files from the Bulk Administration Tool.
Configuration Examples for the Bulk Administration Tool
This section provides examples of how to modify TSV files to implement specific types of changes.
Example: Linking and Unlinking Existing DMPs to Locations Using a TSV File
To link the DMP to a location, complete the following steps:
Step 1 Open the TSV file for DMP mapping that you exported from the Locations box of the Cisco StadiumVision Director Server in a standard spreadsheet application (such as Microsoft Excel), as a tab-delimited text (.txt) file.
For more information, see the "Exporting and Downloading a TSV File for DMP Mapping" section.
To link an existing DMP to a location, complete the following steps:
Step 2 In the MAC field, enter the MAC address of an existing DMP.
Tip If you exported a list of existing DMP MAC addresses, you can copy the MAC addresses from that text file.
a. In the LocationName field, type a name for the location that you want to link to the corresponding DMP.
b. (Optional) In the LocationID field, type an ID for the location.
To unlink an existing DMP from a location, complete the following step:
Step 3 In the MAC field for an existing DMP, delete the MAC address.
Step 4 Save the file as a Unicode text file.
Note Do not save as `Text (Tab Delimited) (*.txt).
Step 5 Import the TSV file to Cisco StadiumVision Director. See the "Importing a TSV File" section.
Troubleshooting the Bulk Administration Tool
If any records failed while importing a TSV file to Cisco StadiumVision Director, a message box is displayed that allows you to click Download to create a text file that includes only the rows that contain errors along with an error message.
After you download this file and save it as a text file, you can open it in a spreadsheet application as you would any of the downloaded text files from Cisco StadiumVision Director to view the specfic errors.
Troubleshooting Tips
•You must open the error file with Microsoft Excel or another spreadsheet application.
If you double-click the file to open it, the content is opened in Notepad (by default on a Windows computer), but the error information is unreadable.
•Be sure that you can confirm that your imported data has been uploaded to the Cisco StadiumVision Director server because when you import a file, the following limitations exist:
–No confirmation message is displayed when the import is fully successful.
–No error message is displayed if the imported file is not saved as a unicode text file format "Unicode text (*.txt)" using tab-separated values. In this case, the file is simply ignored and no action is taken.
•If you cannot get your import to work as expected, try to simplify the content in the import file until it works. Then, add additional information for import.
Error Messages
Caution No error message is displayed if the imported file is not saved as a unicode text file format "Unicode text (*.txt)" using tab-separated values. In this case, the file is simply ignored and no action is taken. Be sure that you can confirm that your imported data has been uploaded.
Table 3 provides a list of possible error messages, their meanings, and recommended resolutions.
Feature Information for the Cisco StadiumVision Director Bulk Administration Tool
Table 4 lists the release history for this feature.
Cisco and the Cisco Logo are trademarks of Cisco Systems, Inc. and/or its affiliates in the U.S. and other countries. A listing of Cisco's trademarks can be found at www.cisco.com/go/trademarks. Third party trademarks mentioned are the property of their respective owners. The use of the word partner does not imply a partnership relationship between Cisco and any other company. (1005R)
Any Internet Protocol (IP) addresses and phone numbers used in this document are not intended to be actual addresses and phone numbers. Any examples, command display output, network topology diagrams, and other figures included in the document are shown for illustrative purposes only. Any use of actual IP addresses or phone numbers in illustrative content is unintentional and coincidental.
© 2011 Cisco Systems, Inc. All rights reserved.