ADE Data Import

Compass has the ability to import data provided by the Arizona Department of Education (ADE).

The user has to request new data files from the ADE.  To do this, send an email to (put in contact info here) asking for the data files (need to come up with a consistent way to ask for these, will be helpful to both us and the ADE).

The ADE will generate the files and send an email when they are ready to be downloaded from their website.  There will be a link to the files in the email and also an expiration date for the files.

Click on the link to the files and depending on whether the user has a loging to the ADE Site or not will determine what steps are taken next.

If an account does not exist, the link in the email will show a form to set up an account.  This will generate another email with a link to activate the account.  The activation email also includes an activation code.  Once the account has been activated, an additional email will be generated "Welcome to ADE Secure File Delivery System".  The account creation should only need to be done once.

Either using an existing account or activating a new account, log into the site.

Once logged in, this will show the ADE Secure File Delivery page.  There is a line called 'View Your Deliveries: Recieved'  Recieved is a hyperlink that when clicked, will show the file available for download.

There should be 4 files:  ADETeacherData.csv, ADECertData.csv, ADEHQTTeacherData.csv and ADEAEPAExamData.csv

Click on the most recent Deliveries, which will show the files contained in the delivery.  Download each file to local machine.  This site does have a automatically log the user out after a period of inactivity.

Open https://lewis.yumaed.org/files/ and make sure the users have access to the ADEImportDataShare.  Once this is set up up, upload the files downloaded from ADE.  DO NOT rename the files.

The next step is to import the data.  To do this open the ADE Data Import menu option which is located in the People menu.

The ADE Data Import screen will show showing the last import date and the number of differences that were found in the data.

Clicking on Process ADE Files will import the new data files into Compass.  Clicking on View Differences will show a list of differences found comparing data in Compass to that of the ADE files.