Downloading Activity Information to an Excel Workbook

Print Friendly and PDF Follow

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

  1. From the Aeon main menu, navigate to the Activities section on the left menu.
  2. Click on the Activities link.
  3. Next to the Activity you want to download, click XLS.
  4. You can also click a specific ID to view the Activity information, then click Download Excel workbook with all Activity details.
  5. The .xls file will begin to download immediately.

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.

SELECT Name as ActivityName FROM Activities WHERE ID = <#ActivityID>

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.

SELECT username as UN, FirstName as First, LastName as Last FROM Users WHERE username IN (SELECT username FROM ActivityLink WHERE ID = <#ActivityID>)

 

 

Questions?

If this article didn’t resolve your issue, please contact Atlas Support for assistance:

Contact Support