Exporting Ancillary Data

You can export the ancillary data into a file.

The Export feature for ancillary data appears and works in the same manner as the Export feature for parameters, cost data, travels, and runs scenarios.
  1. On the screen toolbar of the different ancillary data, click the Export button:Export button
    The Export Options dialog appears.
    Export Options dialog box for Parameters

    By default, CSV is selected in the Export Format field. The other fields that appear in the dialog apply to this format.

  2. If you choose to retain CSV as the Export Format, perform the following substeps:
    1. In the Export Columns list, choose one of the following options:
      • Visible Only - If selected, only the columns of the selected options: Sign-Up, Context, Scenario, are shown on the screen are exported. This is the default.
      • All - If selected, all columns are exported including those that are not shown on the screen.
    2. Select the options that you want to apply:
      • Selected Rows Only - If selected, only selected rows are to be exported.
      • Skip Header - If selected, the header will not be exported.
      • Suppress Quotes - If selected, quotation marks are not exported.
    3. In the File Name field, you can change or edit the file name that was automatically generated.
    4. Click Export.
      If your system has Excel, the data is shown in a spreadsheet. Otherwise, it is shown in a text editor such as Microsoft Notepad.
  3. If you choose PDF (Portable Document Format) in the Export Format drop-down list, the options in the Export Options dialog are changed. Perform the following substeps:
    1. Select any of the following options that you want to apply:
      • Maintain Columns Positions
      • Maintain Sort Order
    2. Click Export.
      The data is shown on a new tab. You can proceed to preview or print it.
      Note: When you click Print, make sure to select Save as PDF in the Destination field.