Grass Valley NV9000-SE v.3.0 - Manual (Page 74)

54 Rev 3.0 • 25 Mar 10
6. Importing and Exporting Data
Importing Data
How to Import Data to a Table
Be sure to organize the spreadsheet into rows and columns that match the table into which the data
is being imported.
1 Launch NV9000-SE. (See Launching and Exiting the Application on page 12.)
2 Click the ‘Tasks’ pane and select ‘Import Data File’. The ‘Import Data File’ page appears:
Figure 6-1. Import Data File Page
3 In the ‘Source File’ section, click
Browse
and select the spreadsheet you want to import. The
spreadsheet must be a .csv or .xls file.
4 From the ‘Column delimiter’ drop-down list, select how the columns in the file with be delin-
eated. When imported, the file is converted to text and the columns are separated by the delim-
iter you choose: comma (,), tab <tab>, or slash (/).
5 Enter the ‘Column header line number’ and the ‘Data start line number’ in the fields provided
to determine which columns and rows will be imported. For example, if you want only columns
55 and greater to be included, enter 55. You can only enter a single number and not a range. For
example, you can enter 4, but not 4 - 15. Every column or line that matches the number entered,
and all those following it sequentially, will be imported.
6 In the ‘Target Table(s)’ section, select a table into which the data will be imported.
Click the ‘Target Table’ radio button and from the drop-down list select a table:
• ‘Devices’ — A list of level sets and associated devices, one level set per row, with name and
description. See Devices on page 157.
• ‘Categories’ — A list of existing categories, one per row, with name and description. See
Categories on page 189.
• ‘Category Details’ — A list of existing devices and the associated category, one device per
row, with ID and suffixes. See Categories on page 189.
• ‘PhysConns’ — A list of all physical connections for all devices in the NV9000-SE system.
See Adding, Updating or Deleting Physical Connections on page 177.
7 Click Create Mapping . The ‘Category to Source File Mapping’ page appears, as shown in
Figure 6-2.