1. Log on to your Infinite Campus DB Server using remote desktop.  (Contact your network admin
or Infintite Campus support for assistance with this.)

2. Put these files on that server, in their own directory.

3. Edit the csvdump.bat file to include your database name.  (If you don't know this, 
you can find it using the sql server management tool and looking for something with a similar name
to your district or contact Infinite Campus Support.)
Replace the YOUR_DB_NAME there.

4. Look at the .sql files and read the comments.     Note the following assumptions:

A. All your users in IC should be users in SIMS.
B. All your users in IC should be able to access the main functionality of SIMS.
C. Access to students in SIMS is based on their staff assignment, all users are given
    access to all students in their school.
D. If you want users to have access to all students, remove the rem line in the csvdump.bat for 
the all_students_in_district.csv line.
E. Students will be flagged for behavior if they have 2 or more suspensions.  (Edit the suspension_system_flags.sql to change
the number and type of behavior incidents.)
F.  Studnts are considered ESL if they have an EnglishProficiency <= 5



These scripts assume you can access your db via sqlcmd 
edit the sqlcmd with the name of your database.

In SIMS make sure you have created a user with the username district_upload.   In the csvdump.bat, replace "your_created_password" in the line beginning with
that chosen password.  A confirmation email will be sent to the email address of this user when you do an 
automated upload.





user_output.sql
If you use a district key put it between the '' on the set @district_key line.  (You set the district key by editing your district in SIMS)



enrollment_output.sql
This will return current (and future) enrollments, as well as enrollments that ended in the past 3 months.  This allows students to be seen in both
schools/grades during the summer transition.


