User guide

Task: Exporting a Usage Report to a .csv file

This task exports selected fields from the DSView software system Usage Reports to a .csv file.

The exported file may be stored on a local or network drive. The exported report is named

usagereport.csv by default, but you may also append the date and time to the end of the file.

The output .csv file may be viewed in a text editor or spreadsheet application, such as

Microsoft Excel.

Once this task is added, you may run it on demand at any time; see Running tasks manually on

page 374.

To add the task:

1. Click the System tab.

2. Click Tasks in the top navigation bar. The Tasks window will open.

3. Click Add. The Add Task Wizard will appear.

4. Select Export Usage Report to a comma separated values (.CSV) file from the drop-down

menu. Type a 1-64 character name for the task.

5. Select a time to run the task (see Specifying when to run tasks on page 360), then click

Next.

6. The Specify Export Usage Report Properties window opens.

a. Type the directory in which to create the file, which may be a physical local drive on

the DSView server or at a shared network location specified by a UNC path. The

location cannot be set to a mapped network drive.The directory name must be entered

in case sensitive text if your operating system supports case sensitive filenames.

b. If the specified directory location is a network drive that requires a log in, enable the

password and confirm the password of a user account that has read/write access to the

network share location.

c. To append the date and time (in military time) to the end of the file name, enable the

Use date and time for file naming checkbox. For example, if you are creating the file

on October 1, 2010 at 10:04 pm, the file created will be named

usagereport1001102204.csv.

If an exported report file exists in the specified directory and you do not

enable this option, it will be overwritten when the new file is created.

d. Click Next.

368 DSView™ 4 Installer/User Guide