Adding Export Request Button

Researchers can now export their request details to an Excel spreadsheet by clicking an "Export" link. This new functionality will be included by default on the Aeon web pages starting with Aeon 3.8. This link is only added to the default ViewAllRequests.html web page. Modify the following pages to add the Export link to the ViewAllRequests.html page.

main.css

Add this in the /* DEFAULT TABLE */ section:

.table-export-link {display: inline-block; float: right;}
.table-export-link a {color: #bbb;}

ViewAllRequests.html

Replace this:

<#TABLE name="ViewAllRequests" headerText="All Requests" noDataAction=
"ShowMessageRow" noDataMessage="No Requests" sortable="true"

with this:

<#TABLE name="ViewAllRequests" headerText="All Requests" noDataAction=
"ShowMessageRow" noDataMessage="No Requests" sortable="true" exportable="true"

Adding the Export link to Other Aeon Web Pages

This functionality can be added to other pages and tables as well, except the Search Results table or to the Researcher Tags table.

To add an export option to the other pages:

1. Create the link by adding the attribute 'exportable' = true to the TABLE tag on the table to export. Adding this attribute creates a right-justified link to display in the table's caption to allow the researcher to download the spreadsheet.

   <#TABLE name="ViewAllRequests" headerText="All Requests" noDataAction=
   "ShowMessageRow" noDataMessage="No Requests" sortable="true" exportable="true"

2. (Optional) Customize the link name by adding the attribute 'exportLinkText' attribute to specify the text for this link. If not provided, "Export" will display by default.

   <#TABLE name="ViewAllRequests" headerText="All Requests" noDataAction=
   "ShowMessageRow" noDataMessage="No Requests" sortable="true" exportable=
   "true" exportLinkText="Export this List

3. Create table link for download by creating SQL query to specify the requests in the table to be downloaded.
   1. When creating custom SQL queries for this feature, you will have access to a variable named '@Username' that will be set to the researcher's username. For example, to retrieve all the fields in the transactions table that belong to the current researcher, a custom ExportViewAllRequests.sql file might contain the line SELECT * FROM Transactions WHERE Username = @Username OR ResearcherUsername = @Username

   2. Add the query to the Aeon Web directory in the folder named sql (C:\Program Files (x86)\Aeon\Web\sql)

   3. Name the query file with the following naming convention 'Export[table name].sql', where [table name] is the name of the table as defined in the 'name' attribute for the table tag.