Downloading Activity Information to an Excel Workbook

Overview

Using download links located on the Activities pages, researchers can download an Excel workbook containing Activity, User and Request details for a particular Activity. Both download links create an .xls document titled Activity[ID] where ID is the Activity ID number. Separate Details, Users and Requests worksheets supply information about the Activity, associated users, and transactions. No permission changes are required to allow a researcher to generate or access the Excel document. The process is done in memory on the server and streamed directly to the user.

Downloading Activity Information

Customizing the Export Course Info Form

You can customize the information displayed in the Activities export file by using .txt files to define the Details, Users, and Requests queries.

You will need to create the following three files and place them in the Aeon web folder (C:\Program Files\Aeon\Web by default):

• ActivityDetailExportQuery.txt
• ActivityUsersExportQuery.txt
• ActivityRequestsExportQuery.txt

These files will override the default predefined queries. You can use these queries to define the fields you want to display, the filters that are applied to exported data, and how field names should be presented.

Field Options

You can use fields from the Users, Transactions, and Activities tables for Activity exports. To see a list of the fields in these tables, see Key Aeon Data Tables.

Query Examples

This ActivityDetailExportQuery.txt example creates a Details worksheet that displays only the Activity name.

The ActivityUsersExportQuery.txt example creates a Users worksheet that displays only the username, first name, and last name; the columns are displayed as UN, First and Last as defined in the query.