User Views › Object Menu Bar › File Menu › Creating Output and Reports › Output Destinations

Output Destinations

The Output Destinations page enables you to choose the output destination for the report. The reports are divided into two parts Formatted Report Destinations and Raw Data Destinations. The Raw Data reports have no limits to the number of records you can output. You can choose one or more Destinations.

When you select a destination the relevant page node becomes selectable in the navigation tree. You can then select the relevant node and specify the format and the exact location where the reports are sent. For example, if you select the e-Mail destination then the e-Mail node becomes selectable in the navigation tree. You use the e-Mail page to specify the email addresses, subject and message text.

The following is an example of the Output Report wizard Destinations page:

Click each left pane option for each destination created and set the output and destination parameters for that type of output. When you are finished, click the Output button.

The following Output destinations are available:

Printer

Displays a simple print dialog where you can specify the printer, number of copies, orientation, and paper size. When you click the Perform button, the Windows Client displays execution information as the output is generated, and then prints the output.

Web Publishing

Displays a destination table with blank green and white rows. Click one of the rows and then navigate to the directory on your local drive where you want the reports published.

When you click the Perform button, execution information is displayed as the output is generated, and the newly generated HTML version of the report is published to the web directory that you specify.

You can include the following with your reports:

• PDFs
• Tables
• Comma delimited files

You can also add interactive SVG graphs in the following formats (you can select more than one):

• Line
• Bar
• Pie
• Gantt
• Stack Bar
• % Stack Bar

Note: For information about Web Publishing on a web server on your domain or on a file server on your domain, see the section View and Output Definition Dialog. For information on how to delete web published files, see the section Deleting Web Publishing Files.

Observe the following:

• When exporting views to Web Publishing, you must use alphabetic characters (A-Z), numbers (0-9), underscore (_), dash (-), space ( ), %, (), and {} to name the view.
• Reports published in languages other than English do not contain graphs.

The following is an example of the Output Report wizard Destinations Web Publishing page:

e-Mail

Use the e-Mail option, shown in the following example, to specify a destination address for the email, provide a subject and email message, and specify a report attachment format. To specify an address, enter the address in the To field, or click the To button to access your email address book. The mail function automatically populates the subject line with the report name. You can overwrite this to enter your own subject. The email function populates the Text field with a default text. You can overwrite this to enter your own text.

By default, the report is sent as an attachment. The default attachment format is PDF. However, you can specify any of the following formats:

• Web Page (HTML)
• PDF document
• Excel Workbook (XLSX)

  Note: For the attachment format Excel Workbook (XLSX), the Excel application must be installed on the machine where the output is performed.

• XML, Excel compatible (XML+XSD)
• CSV, Excel compatible (XLS)
• CSV, Comma delimited (TXT)

Note: A PDF file is recommended because generally speaking it is much smaller than the equivalent HTML or Excel (XSD+XML) file.

The following is an example of the Output Report wizard Destinations e-Mail page:

File (PDF, HTML, XML, TXT)

Formatted reports, lets you specify the file location and type to generate for formatted reports. You can specify PDF, HTML, XML, and TXT formats for reports.

When you click the Perform button, execution information is displayed as the output is generated, and the newly generated reports are published to the local directory that you specified.

Observe the following:

• Writing to a TXT file provides the best performance, especially when copying a large number of records.
• For information about sending reports to a file server on your domain, see the section View and Output Definition Dialog.

The following is an example of the Output Report wizard Destinations Export into Excel page:

Export into Excel

Use the Export into Excel option, shown in the following example, to specify a destination address and the format for the file.

The following file formats are available:

• Excel Workbook (XLSX)
• XML, Excel compatible (XML+XSD)
• CSV, Excel compatible (XLS)

The default file format is Excel Workbook (XLSX).

Click the Perform button to create the report.

Observe the following:

• If Excel Workbook (XLSX) is the specified output format, the Microsoft Excel application must be installed on the machine where output is performed.
• If XML format is specified, the schema file (.xsd) is created at the output path. The required data is collected in a xml file with the format supported by Excel and then past to Excel. When you click Perform, Excel opens and Excel displays an Open XML dialog box with several selection options. We recommend you select the As an XML table option. Selecting this option creates a new spreadsheet with the table data. If numeric cells do not display properly in Excel, try expanding the cell width. See the Excel Help for sizing cells.
• Importing XML to Excel converts ‘-0’ to ‘0’ and ‘-None’ to ‘None’ for numeric field types.
• If the data you are exporting contains hexadecimal values, or values with significant leading zeroes (for example, volume serial numbers), Excel might misinterpret your data. In this case, you should first export the data to a comma delimited file (use the File (MDB, TXT, EXCEL-XML) option under Raw Data Destinations in the Destinations dialog), and then using Excel, import the comma delimited file to Excel manually, being sure to specify the "Text" format for the fields with hexadecimal values or significant leading zeroes.
• The following is the default file destination:

  C:\BRIGHTSTOR SRM DATA\DATABASE\Doc\filename Excel.XLSX.

  Use the Browse button to browse to a different location if you want to change the output report destination default.

• For information about sending spreadsheets to a file server on your domain, see the section View and Output Definition wizard.

The following is an example of the Output Report wizard Destinations Export into Excel page:

• FTP Server - Select this option to send the report to a FTP Server. When selected the FTP Server dialog appears, as shown in the following example. The FTP Server dialog allows you to specify the FTP Server you want the report sent to and it allows you to select the format of the report. The following formats are available:
  • Web Page (HTML)
  • PDF document
  • Excel Workbook (XLSX)
  • XML, Excel compatible (XML+XSD)
  • CSV, Excel compatible (XLS)
  • CSV, Comma delimited (TXT)

  The following is an example of the Output Report wizard Destinations FTP Server page:

  

Publish in Home Page's Storage Summary Section

If you have the My Storage Summary section open in the Home view and then select this option and click Perform, the graph of the object view is displayed in the My Storage Summary section immediately. If the graph is already displayed in the My Storage Summary section and you click Perform, then the graph is refreshed immediately.

Note: Use the View and Output Definition wizard if you want to publish to the My Storage Summary section of the Home view automatically each time the Home view is displayed or on a scheduled basis.

File (MDB, TXT, XML, EXCEL-XML)

Raw data reports, lets you specify the file location and type to generate for raw data reports. You can specify MDB, TXT, XML, and Excel (XML+XSD) formats for the raw reports.

The output destination default is C:\BRIGHTSTOR SRM DATA\DATABASE\Doc\filename.fileformat. The file is named after the object table by default. You can enter a new name and location.

Click the Perform button, the data is created in the file type specified in the local directory specified.

Observe the following:

• Writing to a TXT file provides the best performance, especially when copying a large number of records.
• You have the option to have the reports filed on your local drive or a file server on your domain:
  • If you want the reports filed on your local drive then select the local directory where you want them filed.
  • If you want the reports filed on a file server on your domain, see the instructions in the section Outputting Reports to a File Server.

The following is an example of the Output Report wizard Destinations File (Raw Data) page:

Export to Host

Raw data reports, if you check the Export to Host check box and then click the Perform button, a copy of the object (capture data) is written to a sequential data set on the host using naming conventions established as part of the host configuration. Because the destination parameter needed to perform this function is established in sysparm CAPPFX, an Export to Host option is not displayed in the left pane.

The capture data exported to the host can be viewed from the object Operate menu, Show Log/Cap, Capture option.

Note: For more information about system parameter CAPPFX, see the chapter "System Parameters" in the CA Vantage SRM Configuration Guide.