Problems exporting data in Banner 9

Problem

Unable to export data from Banner 9-PROD into Excel

I am not able to export from Banner NHIDIST screen

I am not able to export from a Banner screen

Banner brings up a popup window instead of a browser where I can save the TEXT as a file

When I export data out of banner it returns the output as a .csv file with no headers.

Solution

Try resetting Internet Explorer

  1. Click in Internet Explorer
  2. Click Internet Options
  3. Click Advanced
  4. Click Reset
  5. Select Delete personal settings
  6. Click Reset
  7. Click Close
  8. Restart computer

Try changing Data extract format

  1. In Banner, navigate to GUAUPRF screen
  2. Click on 2nd tab
  3. Change Data extract format from FILE to WEBUTIL
  4. Change Data extract format from WEBUTIL to TEXT or FILE if you want a browser to show the TEXT so you can save it.

When cannot export to excel with headers

  1. In Banner, navigate to GUAUPRF screen
    1. Click on left menu bar
    2. Click My Preferences
    3. Under DATA EXTRACT section check the box next to Include Header Row in Data Extract

Need More Help?

Please contact the service desk if you need further assistance

 

Products or Services Involved

  • Internet Explorer
  • Banner 9
  • Excel

Cause

Internet Explorer settings

Incorrect Data extract format in Banner