File export

Use the file export to export specific tables from your database as a csv (comma separated values) file.

Go to section

File Export for Customers

File Export for Facility Schedules

File Export for Attendance

File Export for Activities

File Export for Instructors

File Export for lighting systems

File Export for USA Hockey

Using the File Export for Customers

From the File Export page, select Customers from the Table Name list. Then click Submit.

The following options are included on this page:

Name of Field	Type	Description
Custom Lists
Custom List	Dropdown list	Title of email recipient list. Click Preview/Edit List to view or edit the custom lists of email recipients.
Transaction Type	Hyperlink	Link to the transaction type list page to narrow down the customer records to be exported.
Show additional filter options	Checkbox	Option to select additional filters to the custom list to fine tune the email recipient list. See Report Filters. Select the checkbox to display filter criteria (Population, Registration, Facility, Membership, Daycare, Leagues, POS). Click More>>> for a particular section to expand it so that you can add filter criteria. Click <<<Less to collapse the section. Note: Add criteria to filter the email recipient list. For example, if an activity is added as a filter, only customers in the custom list who are registered in the activity are included in the email recipient list.
Field Selection (Option to include the following customer record fields in the export. Minimum one field required.)
customer_id	Checkbox	Customer ID is a number automatically assigned by ACTIVE Net when a customer record is created.
customertype_id	Checkbox	Customer type
geographic_area_id	Checkbox	Geographic Area
lastpayee_id	Checkbox	Customer ID of the last payee
site_id	Checkbox	Site where customer is attached
grade_id	Checkbox	Grade of the customer
firstname	Checkbox	First Name
lastname	Checkbox	Last Name
address1	Checkbox	First line of the address
address2	Checkbox	Second line of the address
city	Checkbox	City
state	Checkbox	State or Province
zipcode	Checkbox	Postal or Zip Code
homephone	Checkbox	Home phone number with area code and extension
workphone	Checkbox	Work phone number with area code and extension
cellphone	Checkbox	Cell phone number including area code and extension
faxphone	Checkbox	Fax number including area code and extension
pagerphone	Checkbox	Pager number with area code and extension
otherphone	Checkbox	Other phone number with area code and extension
email	Checkbox	Email address
ssn	Checkbox	Social Security Number
birthdate	Checkbox	Date of birth
carddate	Checkbox	Date the membership card was last printed
entrydate	Checkbox	Entry date of the customer record
gender	Checkbox	Gender
generalalert	Checkbox	Notes entered in the General Alert section
headofhousehold	Checkbox	Head of Household flag: Yes or No
lastwaiverdate	Checkbox	Date the customer last signed a waiver
mailingaddress1	Checkbox	First line of the mailing address
mailingaddress2	Checkbox	First line of the mailing address
mailingcity	Checkbox	City of the mailing address
mailingstate	Checkbox	State or Province of the mailing address
mailingzipcode	Checkbox	Postal or Zip Code of the mailing address
medicalalert	Checkbox	Notes entered in the Medical Alert section
notes	Checkbox	Notes entered in the Customer Notes section
occupation	Checkbox	Occupation
resident	Checkbox	Residency status: Yes or No
specialhandling	Checkbox	Special Handling customer flag: Yes or No
lastphotographed	Checkbox	Date the customer was last photographed
password1	Checkbox	Not returned as this is a secure field
password2	Checkbox	Not returned as this is a secure field
question	Checkbox	Security question
answer	Checkbox	Not returned as this is a secure field
emergencyfname1	Checkbox	First name of first emergency contact
emergencylname1	Checkbox	Last name of first emergency contact
emergencyphone1	Checkbox	Phone number of first emergency contact
emergencyrelation1	Checkbox	Relationship of the first emergency contact to the customer
emergencyfname2	Checkbox	First name of second emergency contact
emergencylname2	Checkbox	Last name of second emergency contact
emergencyphone2	Checkbox	Phone number of second emergency contact
emergencyrelation2	Checkbox	Relationship of the second emergency contact to the customer
pa_popid	Checkbox	Not in use anymore
nomail	Checkbox	'Promotional Email' customer flag: Yes or No
externalid	Checkbox	Not in use anymore
datemodified	Checkbox	Date the record was last modified
externalidtext	Checkbox	External id entered in customer record
retired	Checkbox	Retired customer flag: Yes or No
gradeagedelta	Checkbox	Years Ahead of Grade
no_postalmail	Checkbox	'Promotional Postal Email' customer flag: Yes or No
not_online_activated	Checkbox	Online user activation flag: Yes or No
login_created	Checkbox	Flag to denote whether customer's online login has been created
login_used	Checkbox	Flag to denote whether customer's online login has been used
occupation_id	Checkbox	The ID number associated with the customer's occupation.
interest_date	Checkbox	The last date that the customer was charged interest for late payments.
county	Checkbox	The customer's county.
membership_overusage	Checkbox	If this option is not 0, then the customer allows membership overuage.
country	Checkbox	The customer's country.
mailingcountry	Checkbox	The country on the customer's mailing address.
mailingname	Checkbox	The name on the customer's mailing address.
can_be_scheduled	Checkbox	If this option is not 0, then the instructor can be booked.
human_resource_id	Checkbox	The ID number associated with the facility table for the customer if they are a bookable instructor.
failed_logon_count	Checkbox	The number of failed login attempts for the customer's account.
age_category_id	Checkbox	The ID number associated with the customer's age category.
customer_title_id	Checkbox	The ID number associated with the customer's title.
middlename	Checkbox	The customer's middle name.
residency_expires_date	Checkbox	The date on which the customer's residency status expires.
soundex_firstname	Checkbox	The soundex for the customer's first name. Soundex is used in the “sound like” feature in the customer search.
soundex_lastname	Checkbox	The soundex for the customer's last name.
emergency_other_phone1	Checkbox	The customer's emergency contact’s other phone #1.
emergency_other_phone2	Checkbox	The customer's emergency contact’s other phone #2.
soundex_middlename	Checkbox	The soundex for the customer's middle name.
is_temp_password	Checkbox	If this option is not 0, then the customer's current password is temporary and needs to be changed after their initial login.
legal_name	Checkbox	The customer's legal name for payroll purposes.
additional_email	Checkbox	The customer's additional email address.
late_fee_date	Checkbox	The last date that the customer was charged for late fees.
carrier_id	Checkbox	The ID number associated with the customer's cell phone carrier.
agree_receive_text_message	Checkbox	If this option is not 0, then the customer has agreed to receive text messages.
Created Online / Staff Side	Checkbox	If the customer was created online, this column displays Online. If the customer was created on the staff side, this column displays Staff Side. For customers without this information on file, this column displays Unknown.
Subscription List	Checkbox	Displays the list of customer subscriptions in a single column.
Options
Include 'No Promotional Email' Customers	Checkbox	Option to include customers who are not included in the promotional emailing list. If this option is not selected, only customers with the Promotional Email checkbox selected are returned (for example: only those who are in the emailing list will be included).
Include 'No Promotional Postal Mail' Customers	Checkbox	Option to include customers who are not included in the promotional postal mailing list. If this option is not selected, only customers with the Promotional Postal Mail checkbox selected are returned (for example: only those who are in the postal mailing list are included).
Special Handling Customers	Checkbox	Option to include only customers whose Special Handling checkbox is selected. If this option is not selected, all customers are returned.
Include Retired Customers	Checkbox	Option to include customers who have been retired. If this option is selected, customers whose Retire Customer Record checkbox is selected are included.
Include Membership Package?	Checkbox	Select this checkbox to display all of the effective membership packages purchased by the customers in the export file.
Include Note / Alert?	Checkbox	Select this option to display the following fields in the export: Note / Alert Type Note / Alert Description Note / Alert Start Date Note / Alert End Date Note / Alert Created Date
Show Specific Custom Questions	Hyperlink	Link to the custom question answer list page to select specific custom questions and answers to display in the export file.
Customer Account Created	Dropdown list	To only include customers in the report who were created either online or on the staff side, select Online or on Staff Side. To include all customers no matter where they were created, select Both.
Only Show Customers Missing Any of Selected Fields?	Checkbox	To only include customers in the report who are missing data for one or more of the fields that you have selected, select this option.
Enrollment State	Dropdown list	Enrollment state during timeframe (or other criteria specified above) to limit customer records returned with export.
Customers Born In	Dropdown list	Option to return only customers born who were on a certain month. If All Months is selected, all customers are returned.
Instructors Only	Checkbox	Option to return only customers who are also instructors.
Unique Addresses	Checkbox	Option to return only customers with unique addresses. For records with duplicate addresses, the head of household is returned. If no head of household is designated, the first customer record created with the address is returned.
Sort Options
Sort Options	Dropdown list	Option to sort the exported records by customer name, age and name, zip code and name, or zip code and address.

Using File Export for Facility Schedules

From the File Export page, select Facility Schedules from the Table Name list. Then click Submit.

The following options are included on this page:

General

Select any or all of the following filters for this report:

Set up Reservation Date Range Filter

Select a Beginning Date for the facility reservation.
Select an Ending Date for the facility reservation.

Set up Center Filter

Click Center to view the Center List page.
From the Center List page, select the centers.
Click Add All Selected.

Set up Reservation Site Filter

Click Reservation Site to view the Site List page.
From the Site List page, select the sites.
Click Add All Selected.

Set up Facility Filter

Click Facility to view the Facility Search page and then search for facilities. The facility search results are displayed on the Facility List page.
From the Facility List page, select the facilities.
Click Add All Selected.

Set up Facility Type Filter

Click Facility Type to view the Facility Type List page.
From the Facility Type List page, select the facility types.
Click Add All Selected.

Set up Schedule Type Filter

Click Schedule Type to view the Schedule Type List page.
From the Schedule Type List page, select the schedule types.
Click Add All Selected.

Set up Instructor Filter

Click Instructor to view the Instructor Search page and then search for instructors. The instructor search results are displayed on the Instructor List page.
From the Instructor List page, select the instructors.
Click Add All Selected.

Permit

Select any or all of the following filters for this report:

Set up Transaction Site Filter

Click Transaction Site to view the Site List page.
From the Site List page, select the sites.
Click Add All Selected.

Set up Event Type Filter

Click Event Type to view the Event Type List page.
From the Event Type List page, select the event types.
Click Add All Selected.

Set up Customer Filter

Click the Customer link to view the Customer Search page and then search for customers. The customer search results are displayed on the Select Customer List page.
From the Select Customer List page, select the customers.
Click Add All Selected.

Set up Customer Type Filter

Click the Customer Type link to view the Customer Type List page.
From the Customer Type List page, select the customer types.
Click Add All Selected.

Activity

Select any or all of the following filters for this report:

Set up Activity Filter

Click the Activity link to view the Activity Search page and then search for activities. The activity search results are displayed on the Select Activity page.
From the Select Activity page, select the activities.
Click Add All Selected.

Set up Activity Type Filter

Click Activity Type to view the Activity Type List page.
From the Activity Type List page, select the activity types.
Click Add All Selected.

Set up Supervisor Filter

Click Supervisor to view the Supervisor List page.
From the Supervisor List page, select the supervisors.
Click Add All Selected.

Field Selection

Select one or more the following checkboxes to include the selected customer records in the export:

facilitytype
itemname
Item Number (displays the facility number if the item is a facility)
startdate
setuptime
starttime
enddate
endtime
teardowntime
eventtype
eventdescription
permitstatus
permitnumber
scheduletype
customer
customertype
email
homephone
workphone
residentialaddress
activitytype
activitynumber
activitystatus
Activity Department
Activity Category
Activity Other Category
supervisor
center
reservationsite
eventnotes
Attached Equipment

Options

Include

Select one or more of the following options:

Activity
Daycare
Regular Reservation
League

Show Child Facilities as Booked?

Select this checkbox to display child facility reservation records in the report.

Show Specific Custom Questions

Select specific custom questions and answers to display in the export file.

Include

Select an option from the dropdown list:

All
Facilities
Instructors

Sort By

Select an option from the dropdown list to group the records:

Facility Type
Facility Name
Event Type
Date/Time

Save Report Definition

In the Report Title box, enter a report title.
Click Save to save the report definition with the current report title. If you have changed the report title, then the original report title is replaced by the new one.
Click Save As to save another version of the report definition using a different report title.
Click Recall/Schedule on top of the page to access a previously saved report definition from the Report Definitions page.

Using the File Export for Attendance

From the File Export page, select Attendance from the Table Name list. Then click Submit.

The following options are included on this page:

Name of Field	Type	Description
Filters
Season	Hyperlink	Filter the attendance export by season.
Term	Hyperlink	Filter the attendance export by term.
Department	Hyperlink	Filter the attendance export by department.
Activity Meeting Dates	Date range	Filter the attendance export by activity meeting dates.
Activity Type	Hyperlink	Filter the attendance export by activity type.
Attendance Code	Hyperlink	Export only attendance records that are assigned a specific attendance code.
Field Selection (Option to include the following attendance record fields in the export. Minimum one field required.)
Instructor Attendance Code	Checkbox	Include the instructor attendance code in the export.
Customer Attendance Code	Checkbox	Include the customer attendance code in the export.
Exclude From Payroll	Checkbox	Exports a Yes or No value based on whether the attendance record is excluded from payroll calculations.
Mark As Unattended	Checkbox	Exports a Yes or No value based on whether the attendance record is marked as unattended or not.
Needing To Be Rescheduled	Checkbox	Exports a Yes or No value based on whether the attendance record is marked as needing to be rescheduled or not.
Date Of Lesson	Checkbox	Include the lesson date in the export.
Attended	Checkbox	Exports a Yes or No value.
Makeup Date	Checkbox	Exports a Yes or No value.
Activity Name	Checkbox	Include the activity name in the export.
Activity Number	Checkbox	Include the activity number in the export.
Activity Start Date	Checkbox	Include the activity start date in the export.
Activity End Date	Checkbox	Include the activity end date in the export.
Activity Type	Checkbox	Include the activity type in the export.
Season	Checkbox	Include the season in the export.
Term	Checkbox	Include the term in the export.
Department	Checkbox	Include the department in the export.
Customer First Name	Checkbox	Include the customer's first name in the export.
Customer Last Name	Checkbox	Include the customer's last name in the export.
Customer ID	Checkbox	Include the customer ID in the export.
Customer Email	Checkbox	Include the customer's email in the export.
Customer Address1	Checkbox	Include the customer's address1 field in the export.
Customer Address2	Checkbox	Include the customer's address2 field in the export.
Customer City	Checkbox	Include the customer's city in the export.
Customer State	Checkbox	Include the customer's state in the export.
Customer Zip Code	Checkbox	Include the customer's zip code in the export.
Customer Home Phone	Checkbox	Include the customer's home phone in the export.
Customer Work Phone	Checkbox	Include the customer's work phone in the export.
Customer Cell Phone	Checkbox	Include the customer's cell phone in the export.
Instructor First Name	Checkbox	Include the instructor's first name in the export.
Instructor Last Name	Checkbox	Include the instructor's last name in the export.
Instructor Employee Number	Checkbox	Include the instructor's employee number in the export.
Instructor Email	Checkbox	Include the instructor's email in the export.
Instructor Home Phone	Checkbox	Include the instructor's home phone in the export.
Instructor Work Phone	Checkbox	Include the instructor's work phone in the export.
Instructor Cell Phone	Checkbox	Include the instructor's cell phone in the export.
Instructor Address	Checkbox	Exports the instructor's Address1 + Address2.
Instructor City	Checkbox	Include the instructor's city in the export.
Instructor State	Checkbox	Include the instructor's state in the export.
Instructor Zip Code	Checkbox	Include the instructor's zip code in the export.
Attendance Note	Checkbox	Include the attendance note in the export.
Options
Activity Status	Dropdown list	To export only activities with a specific activity status, select the activity status to export.
Attendance	Dropdown list	To export attendance for instructors or customers only, select Instructor Only or For Customers Only.
Dates	Dropdown list	To export dates with or without attendance entry only, select Without Attendance Entry Only or With Attendance Entry Only.
Lessons	Dropdown list	Select whether you want to export Private Lessons Only, Need To Be Rescheduled Private Lessons Only, Rescheduled Private Lessons Only, or All (regular activities and private lessons).
Include Only Entries With Notes Attached?	Checkbox	Select whether or not you want to export only records that have notes attached.

Using the File Export for Activities

From the File Export page, select Activities from the Table Name list. Then click Submit.

The following options are included on this page:

Name of Field	Type	Description
Filters Use one or more of the following filters to narrow down the export: Activity Department Season Term Activity Site (If the current user has the 'Registration: Multi-Site Reports' permission, then the Activity Site filter is displayed and the user can select the required sites to export. Otherwise, the Activity Site filter is hidden and the user can only export data for the current logged-in site. ) Activity Type Activity Category Activity Other Category Instructor Supervisor Center Facility Activity Start Date Activity End Date Team Activity Skill Age Range
Field Selection Include one or more of the listed activity record fields in the export.
Options
Activity Status	Dropdown List	Option to only include activities with a particular status. The options include: Open - Activities that are still open for registration. Closed - Activities that have been closed for registration. Cancelled - Activities that have been cancelled and will not be held anymore. Tentative - Activities that are scheduled but not yet fully certain to run. Activities whose enrollment are way below the minimum enrollment required may be placed on Tentative status. Note that retired activities that are copied to a new season will also get this status, until the status is changed to Open. On Hold - Activities that have some technical issues (for example, instructor may not be available) and may end up not running. Retired - Activities that will not be offered anymore. Date Conflicted - Activities whose facility schedules have conflicting dates. These activities may end up not running at their original facilities so will need to have them updated prior to being switched to Open. Any Status - Include all activities regardless of status.
Enrollment Status	Dropdown List	Option to only include activities depending on their enrollment status, as selected from either Any Status, Full, Under Maximum, Under Maximum + Waitlist, and Under Minimum.
Activity Instructor	Dropdown List	To only include activities with or without an instructor, select Only Activities with Instructors or Only Activities without Instructors.
Only Include if Minimum Enrollment Met?	Checkbox	Select to only include activities that have met their minimum enrollment requirements.
Only Include Activities that have Fees Without a Valid G/L Account?	Checkbox	Select to only include activities that have fees without a valid GL account.
Only Show Activities Qualified for Commission	Checkbox	To include only activities that qualify for commission, select this option.
Only Show Activities Without Reserved Facility?	Checkbox	Option to only include activities with no facility reserved.
Show on Internet?	Dropdown List	To include only activities that are set to show or be hidden on the public site, select Show on Internet Only or Hide on Internet Only.
Allow Internet Registration?	Dropdown List	To include only activities that do or do not allow internet registration, select Allow Internet Registration Only or No Internet Registration Only.
Include in Catalog?	Dropdown List	To include only activities that are or are not included in the activity catalog, select Include in Catalog Only or Exclude in Catalog Only.
Only include Activities with no Sub-Activities	Checkbox	Select to include only activities without sub-activities.

Using the File Export for Instructors

From the File Export page, select Instructor from the Table Name list. Then click Submit.

The following options are included on this page:

Name of Field	Type	Description
Filters Use one or more of the following filters to narrow down the export: Season Term Department Activity Category Activity Other Category Activity Site Instructor Instructor Skill
Field Selection Include one or more of the listed activity record fields in the export. See below for more infromation about specific fields.
Resident	Exports either Yes or No.
Head of Household?	Exports either Yes or No.
Special Handling?	Exports either Yes or No.
Promotional Email?	Exports either Yes or No.
Promotional Postal Mail?	Exports either Yes or No.
Membership Overusage?	Exports either Yes or No.
Notes	Exports the text typed in the Notes field.
Medical Alert	Exports the text typed in the Medical Alert field.
General Alert	Exports the text typed in the General Alert field.
Bio Description	Exports the text typed in the Bio Description field.
Prevent Further Use?	Exports either Yes or No.
PFU as of Date	Exports the date entered to Prevent Further Use "as of".
Allow Online Administration	Exports either Yes or No.
Include Payment Information?	Exports either Yes or No.
Exclude from Payroll Calculations?	Exports either Yes or No.
Public Information-Home Phone	Exports either Yes or No.
Public Information-Work Phone	Exports either Yes or No.
Public Information-Cell Phone	Exports either Yes or No.
Public Information-Fax Phone	Exports either Yes or No.
Public Information-Pager Phone	Exports either Yes or No.
Public Information-Other Phone	Exports either Yes or No.
Public Information-Email	Exports either Yes or No.
Public Information-Photo	Exports either Yes or No.
Email Registration Notification?	Exports either Yes or No.
Instructor Skills	Lists all of the selected instructor skills.
Open 24 Hours?	Exports either Yes or No.
Reserve Default Facility	Exports either Yes or No.
Options
Only Instructors Prevent Further Use as Of	Date	To include only instructors that were set to Prevent Further Use on or after a specific date, select the date here.

Using File Export for lighting systems

From the File Export page, select Lighting Export from the Table Name list. Then click Submit.

The following options are included on this page:

Name of Field	Type	Description
General
Reservation Date	Date range	Select a Beginning Date for the facility reservation. Select an Ending Date for the facility reservation.
Center	Hyperlink	Click Center to view the Center List page. From the Center List page, select the centers. Click Add All Selected.
Reservation Site	Hyperlink	Click Reservation Site to view the Site List page. From the Site List page, select the sites. Click Add All Selected.
Facility	Hyperlink	Click Facility to view the Facility Search page and then search for facilities. The facility search results are displayed on the Facility List page. From the Facility List page, select the facilities. Click Add All Selected.
Facility Type	Hyperlink	Click Facility Type to view the Facility Type List page. From the Facility Type List page, select the facility types. Click Add All Selected.
Schedule Type	Hyperlink	Click Schedule Type to view the Schedule Type List page. From the Schedule Type List page, select the schedule types. Click Add All Selected.
Instructor	Hyperlink	Click Instructor to view the Instructor Search page and then search for instructors. The instructor search results are displayed on the Instructor List page. From the Instructor List page, select the instructors. Click Add All Selected.
Options
Musco Username	Text	Enter the username for your Musco lighting system.
Musco Password	Text	Enter the password for your Musco lighting system.
Include Rental Setup and Cleanup time	Check box	If this check box is selected, then the Lighting Exporting report displays reservation start times and end times that include setup and cleanup times.
Save Report Definition In the Report Title box, enter a report title. Click Save to save the report definition with the current report title. If you have changed the report title, then the original report title is replaced by the new one. Click Save As to save another version of the report definition using a different report title. Click Recall/Schedule on top of the page to access a previously saved report definition from the Report Definitions page.

Using File Export for USA Hockey

From the File Export page, select USA Hockey Export from the Table Name list. Then click Submit.

Note that the USA Hockey Export option is displayed only if:

• USA Hockey integration for your organization has been enabled.

• The logged-in user account profile is granted the General - USA Hockey Export permission.

The following options are included on this page:

Name of Field	Type	Description
Filters Use one or more of the following filters to narrow down the export: Activity Department Season Term Activity Category Activity Type Activity Start Date Range Activity Site Instructor For staff users with profiles without the Front Desk/Administration: Registration-Registration (Multi-Site) permission, after selecting the Reports Home > General Reports > File Export report > Table Selection section > USA Hockey Export table, the Activity Site filter is hidden.
Field Selection Include one or more of the listed activity record fields in the export. See below for more infromation about specific fields.
Activity Name	Activity name
Activity Number	Activity number
External Number	USA Hockey number
Position	Position for USA hockey, for example: coach, player
Description	Description
First Name	Customer's first name
Last Name	Customer's last name
Title	Customer's title
Gender	Customer's gender
Address 1	Customer's address 1
Address 2	Customer's address 2
City	Customer's city
State	Customer's state
Zip code	Customer's zip code
Country	Customer's country
Date of birth	Customer's birthdate
Email	Customer's email address
Phone	Customer's phone number
Options
USA Hockey format	Checkbox	This option determines the report format: If it is selected (default status), then the report includes only the following columns: Activity Name Activity Number External Number Position If it is unselected, then the additional columns are displayed.

File export

Go to section

Using the File Export for Customers

Custom Lists

Field Selection

Options

Sort Options

Using File Export for Facility Schedules

General

Set up Reservation Date Range Filter

Set up Center Filter

Set up Reservation Site Filter

Set up Facility Filter

Set up Facility Type Filter

Set up Schedule Type Filter

Set up Instructor Filter

Permit

Set up Transaction Site Filter

Set up Event Type Filter

Set up Customer Filter

Set up Customer Type Filter

Activity

Set up Activity Filter

Set up Activity Type Filter

Set up Supervisor Filter

Field Selection

Options

Include

Show Child Facilities as Booked?

Show Specific Custom Questions

Include

Sort By

Save Report Definition

Using the File Export for Attendance

Filters

Field Selection

Options

Using the File Export for Activities

Filters

Field Selection

Options

Using the File Export for Instructors

Filters

Field Selection

Options

Using File Export for lighting systems

General

Options

Save Report Definition

Using File Export for USA Hockey

Filters

Field Selection

Options

Related topics