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) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">Click **Save**
 * 15) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">Click **Goto Extract**
 * 16) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">Click **Clear Extract Criteria**
 * 17) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">Click the **Schools** tab
 * 18) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">Click your school’s name on the left side then click **Add>>**.
 * 19) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">Click **Run Extract**.
 * 20) <span style="mso-bookmark: _Toc449489537; msobookmark: _toc508528556;"><span style="font-family: 'courier new'; mso-fareast-font-family: 'Courier New'; msofareastfontfamily: 'courier new'; msolist: ignore;">o <span style="font-family: 'Arial','sans-serif';">If 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) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">Click **Go Back**
 * 22) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">Click the **Exit Door**
 * 23) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">Click **Create Export**
 * 24) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">Click **OK** at the FERPA warning
 * 25) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">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) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">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) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">Click the **Exit Door** – if asked to save, choose either **Yes** or **No** – it doesn’t matter.
 * 28) <span style="font-family: 'arial','sans-serif'; mso-bookmark: _Toc449489537; msobookmark: _toc449489537; msobookmark: _toc508528556;">Continue clicking **OK**, the **Exit Door,** or **Yes** until you have exited from NC WISE.

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