The Generate WDIS Extracts screen makes generating, viewing, and downloading data for multiple surveys possible. In addition to downloading, reviewing, etc., you can also send one or multiple survey extracts directly from this screen.
The filters and data displayed on the Generate WDIS Extracts can be customized by administration via Florida Reports > Florida Reports Setup. In the image shown, the District Options tab is selected.
1. From the Florida Reports menu, click Generate WDIS Extracts.
2. Select the Survey from which to pull data from the corresponding pull-down.
3. The Survey Window can be utilized to pull data over a specific time frame. Here you can select the applicable month, day, and year from the provided pull-downs, or click the calendar icon for a calendar view.
If you want the survey dates to pull in upon running this report, from the Florida Reports menu, select Florida Reports Setup, and click the Survey Dates tab. Define the survey dates for each survey.
4. The Mode defaults to Initial. Use the pull-down to select Magic Batch instead when applicable.
Initial should be selected for initial files that have not yet been sent to DOE and/or are not at least 80% error-free. Doing so will generate the initial file along with the appropriate header record.
The Initial record must first be accepted and D-files available by the state before a Magic Batch can be sent.
Magic Batch should be selected once the data is at least 80% error-free and data has been compared to the D-file sent by DOE (this is done in step 9 when the D-file(s) are downloaded). Note: Magic Batch cannot be used without the D-file data.
The D-file can be requested from DOE once the initial has been accepted.
5. Select the Format in which you'd like to extract and view or send data.
Text File (DOE Format) can be selected to view data from the perspective of DOE without extracting data to be sent to the state.
Excel CSV File can be used to view data the same as the Text File in a more readable format; while DOE format is one line of data, the Excel formats presents data in columns.
DOE FTP should be selected when you are ready to send extracts to DOE. Once selected, the Send Extract(s) button will display below the Format pull-down.
6. Select Engage DQ2 Preflight Mode to send the Initial data to DQ2 Preflight. The selected Format should be DOE FTP. DQ2 Preflight is used to review survey data and to work out any potential issues prior to official survey submission. Data residing in the Preflight system will not be used by FLDOE for any reporting.
Errors on submitted files sent via the DQ2 Preflight process can be viewed from the Survey Submission Page in the DQ2 Application User Interface. The D-File can also be downloaded via Generate DOE Extracts by clicking Download O/D-Files.
7. Select which extracts to generate, or click Select All to select all extracts.
8. Click Generate Extract(s) to pull all data and create an extract. Once this has been done, you will see Extract Successful next to a green check mark. Note: The green check mark will disappear after a few minutes. This only has to be done once unless data has been changed or updated. Generating the extract now makes it available for downloading and viewing.
9. Click Download O/D-file(s) to download original files from DOE, in addition to errors that need to be addressed after the initial extract. The D-file is your data reviewed and sent back by DOE; downloading it synchs your data with that of DOE.
10. Click Download Edit/Validation File(s) to populate data tables with additional validation codes.
The next section lists all of the different extracts with the option to download, view, look at history, and send.
11. To view the extract, click Download Extract. The type of file that downloads here is dependent upon the Format selected in step 5.
The image displayed shows an example of a Text File (DOE Format):
The image displayed shows an example of an Excel CSV File:
12. Click the HTML View button to view the extract in a new screen and view data in a more readable format via Focus.
Click the Go back link to navigate from the HTML View of the extract back to the Generate WDIS Extracts screen.
As displayed, this initial extract is currently Unlocked meaning that data can be updated, edited, and the extract regenerated. If data needs to be temporarily frozen, the data can be locked using the Lock Initial button.
13. For a complete history of users who have generated extracts, click Extract History.
Clicking Extract History will generate a pop-up screen that lists the Extract User, School Year, Survey, Extract, Mode, Process, Time and Date, and the Number of Records.
14. Send Via FTP is used when you are ready to send data to the state, or click Send Extract(s) at the top of the screen to send all extracts. Note: This button only displays if DOE FTP is chosen in the Format pull-down. When the files have been successfully sent, you will see a green check mark displayed as shown in the image.
See Additional Features for more information on Exporting, Searching, and more.