Ad Hoc Exports

Creating User Exports

1. Click the Reports button.
2. Click the Export/Ad Hoc File button.
3. The User Export screen opens. Click the Start Over button to clear all previous selections.
4. Note: To recall an existing report, click the Saved Export button. Click the radio button on the top of the screen to see All reports. Highlight the file name in the Export Name column and click the Restore Saved Export button. Skip to step 9.
5. To start building the export, click a field in the Demographic column to select it. Click the Right Arrow button to move it into the Selected column. Continue this process until all desired fields are moved.
6. Note: Use the Demographic scroll bar to find the fields. Alternatively, use the Wildcard field to perform the search by typing the word in the field, selecting the appropriate radio button, and clicking the Query button.
7. You can add one other category. Click the Other Category drop-down arrow and select the category.You can’t search in this category, but you can add fields to your report.
8. To modify the order that the fields will appear in the export, click a field in the Selected column and click the Up Arrow or Down Arrow to move it in the list. After the order of fields has been completed, click the Create File button.
9. Click Create File
10. Make sure that Special Delimiter is set to Tab, Fixed Length should be unchecked, Number of Columns to Order On is set to 1, Double Quotes Around Character Fields is set to No, and Export Field Titles First is checked.
11. Click Save as . . .
12. In the Save in drop-down at the top, choose a location to save your data or click on Save As to browse to a file location
13. In the File name: field, type a name for your data extract (it is good to use a date in your file name to indicate when it was extracted:discipline03092007.txt)Always name the file with the .txt file extension.
14. Click Save
15. Click Goto Extract
16. Click Clear Extract Criteria
17. Click the Schools tab
18. Click your school’s name on the left side then click Add>>.
19. Click Run Extract.
20. oIf you get an error message here about your school not being selected, go back to the Basic tab and choose your school from the drop-down (right above the check box for Include Cross Enrolled Students) – if you don’t get the error message, don’t worry about this step.
21. Click Go Back
22. Click the Exit Door
23. Click Create Export
24. Click OK at the FERPA warning
25. If a data extract has never been run on your computer, you may possibly be asked to install some software at this step.If so, install it.It may make you log back in after it installs.
26. The export will generate (you may get an hour-glass for a few minutes).Click OK when you get the message that the export is complete.
27. Click the Exit Door – if asked to save, choose either Yes or No – it doesn’t matter.
28. Continue clicking OK, the Exit Door, or Yes until you have exited from NC WISE.

1. Close any other windows that may be open.
2. Open Excel (Start>Programs or All Programs>Microsoft Office>Microsoft Excel)
3. Click the File menu
4. Choose Open From the Look in drop-down box at the top, choose the location that you saved your data
5. At the bottom, change the Files of type drop-down to All Files
6. Either double-click your file name or click your file and then click Open
7. On the Text Import Wizard screen, choose Delimited and then click Next
8. Be sure that Tab is checked and click Next
9. Click Finish
10. If some of your columns contain #######, double-click the divider separating that column and the next column to resize the column.
11. Save the file using File/Save as… Click on the up arrow beside Save as file type and choose Microsoft Office Excel Workbook.