PATH: Ad hoc Reporting > Data ExportThe Data Export tool allows users to view the results of Ad hoc filters in multiple report formats and files. All Ad hoc filters created via the Filter Designer are able to be exported via the .
When using Custom Tab fields within Ad Hoc Query Wizard, all students will appear in the results even if the student does not have a record within the custom dated tab. When exporting fields from a Custom Tab that is Table or List Element Tab Type, Ad Hoc logic will output every possible combination based on a specific date and time. The Table Tab Type stores specific times. The List Element Tab Type always stores 12:00 AM.
Data Export Editor
The following logic is used when reporting NULL or field values of 0 within Ad hoc filters:
- Float fields = NULL will output as blank unless a default value exists within the Attribute/Dictionary.
- Float fields = 0 will output as a value of 0.
- Number fields = NULL will output as blank unless a default value exists within the Attribute/Dictionary.
- Number fields = 0 will output as 0.
BIE SPECIFIC LOGIC:
- If an EnrollmentBIE field has a default value, a NULL field will report the default value when filtering data or exported via the Data Export tool.
- This logic applies to all fields within the EnrollmentBIE table with the exception of foreign keys and End Year.
CUSTOM DATED FIELD LOGIC:
- Dated Custom fields use the date for outputting records.
- All possible combinations of records for a distinct date and time report.
- Values tied to records on other dates will not show in the output for another date/time.
Specific calendars can be selected for the following saved filters:
- Query Wizard filters using a Student Data Type or a Course/Section Data Type
- Pass-Through SQL Queries using a Student Data Type or a Course/Section Data Type
Select a saved Student Data Type and saved Course/Section filters and select from which calendars to report data. Select calendars by the active year, by the school name or by year. If a calendar is selected in the Campus Toolbar, that calendar is already selected.
Calendars cannot be selected if the query is for Census/Staff Data Types.
Only calendars to which the user is assigned calendar rights are available for selection.
Data Export Calendar Selection
Export an Ad hoc Filter
- Select an Ad hoc filter from the Saved Filters window. This field is populated with filters created in the Filter Designer tool. A description of the filter may appear if established within the filter itself.
Select the desired format of the exported Ad hoc filter by clicking the appropriate radio button in the Pick an Export Format area. See the Data Export Fields table below for more information.
The length of each field within an Ad hoc filter must be defined in order to properly generate the Fixed Width format. Field lengths are established within the Filter Designer tool.
- Select the Export button. The exported Ad hoc filter will display in a separate window in the designated format.
Data Export Fields
The following describes each available field:
All fields within an Ad hoc filter that have a Column Header established will report that value in the header of exported Ad hoc reports. Column headers are defined in the Ad hoc Query Wizard tool.
HTML list report
Exports the results of the Ad hoc filter in HTML format (See image 2).
Exports the results of the Ad hoc filter in XML format (See image 3).
Delimited values (CSV)
Exports the results of the Ad hoc filter in a number of Delimited values (CSV).
The Double quote data dropdown list allow users to determine when double quotations are added to exported Ad hoc filter data (see image 6).
The Include Subtotals checkbox allows users to properly display aggregate totals that may be included in the filter.
Exports the results of the Ad hoc filter in Fixed Width format (see image 10).
Exports the results of the Ad hoc filter in PDF format. Selecting the Field Name Only radio button means field names in the header will only display the field name as it exists in the database (i.e., grade is reported for the student.grade database field (see image 11)). Selecting the Table Name and Field Name radio button means both the table and field name will display in the header on the report (i.e., student.grade is reported in the header for the student.grade database field (see image 12)).
Exported Data Examples
The following are examples of Ad hoc filters exported in various formats:
HTML List Report Format
Delimited Values (CSV) - Comma Delimited
Delimited Values (CSV) - Tab Delimited
Delimited Values (CSV) - Tab Delimited with Double Quote Data
Delimited Values (CSV) - Pipe Delimited
Delimited Values (CSV) - Caret Delimited with Column Display Header Included
Delimited Values (CSV) - Caret Delimited without Column Display Header
PDF Report - Field Name Only
PDF Report - Table Name and Field Name
PDF Report - Grouped Fields within the Ad hoc Filter
PDF Report - No Grouped Fields within the Ad hoc Filter
Search Ad hoc Filters
Users have the ability to identify which students are included within an Ad hoc filter prior to exporting data.
Searching Ad hoc Filters within the Data Export Wizard
To generate a list of all students included within an Ad hoc filter, select the filter from the Saved Filters window and click the Search button. Student results will appear in the Search tab on the right.
Edit Ad hoc Filters
Users can edit Ad hoc filters prior to exporting data.
Editing an Ad hoc Filter
To edit an Ad hoc filter prior to using the Data Export tool, select the filter from the Saved Filters window and click the Edit button. Users will be directed to the Filter Designer tool with all existing fields/values selected.
Editing and Ad hoc Filter - Filter Designer
From here, users can edit filter values as desired. For more information about editing and creating Ad hoc filters within the Filter Designer, refer to the Filter Designer page.
Delete Ad hoc Filters
Users have the ability to delete Ad hoc Filters within the Data Export tool.
Deleting an Ad hoc Filter
To delete an Ad hoc filter, select the filter from the Saved Filters window and click the Delete button. Users will be prompted with a confirmation pop-up message.
Confirming Deletion an Ad hoc Filter
Select the OK button to permanently delete the filter. Select the Cancel button to cancel the deletion process and return to the Data Export Wizard editor.
Deleting an Ad hoc Filter within the Data Export tool will permanently delete from all areas of Infinite Campus.