Advisor Batch Uploads

If you have a list of 15+ UG students who need advisor assignments and/or changes, the list can be put into an Excel file and sent to enrolltech@uncc.edu for upload into Banner.

All advisor batch load requests will be applied to the current term, unless otherwise stated. If your data includes new students that are not currently enrolled, those students will not be processed in Banner. If changes and/or additions need to be made for more than one term, a separate CSV file must be submitted per term. To specify a term, simply state the term you would like to be applied to each file in the email sent. When submitting the CSV file please follow the guidelines below.


Replace Previous Advisor’s Assignments with a New Advisor Guidelines
  1. Create a four-column Excel file with the following information:
    1. Column A 
      1. Heading:  INPUT_STUD_ID
      2. Column Data: Student ID number 
    2. Column B 
      1. Heading:  INPUT_NEWADVR_ID
      2. Column Data:  New Advisor ID 
    3. Column C 
      1. Heading: INPUT_NEWADVR_TYPE
      2. Column Data: Advisor Type (ex. MAJR, MINR, PRO, etc.)
    4. Column D 
      1. Heading: INPUT_ADVR_ID
      2. Column Data: Advisor ID being replaced
  2. Save the file as CSV, instead of XLSX
  3. Name the file advisorload.csv
  4. Email CSV file to enrolltech@uncc.edu

 Change advisor example

Figure 1 - Note the field arrangement. The "input_advr_id" column contains the UNC Charlotte ID of the advisor that is being replaced.


Updating New Freshmen or Transfer Students Guidelines
  1. Create a three-column Excel file
    1. Column A
      1. Heading: INPUT_STUD_ID
      2. Column Data: Student ID number 
    2. Column B
      1. Heading: INPUT_ADVR_ID
      2. Column Data: Advisor ID number 
    3. Column C
      1. Heading: INPUT_ADVR_TYPE
      2. Column Data: Advisor Type. (values may include: MAJR, MINR, BEST, CNTR, FAC, MAS, MINR, OASE, or UNIV).
  2. Save the file as CSV, instead of XLSX
  3. Name the file advisorload.csv
  4. Email CSV file to enrolltech@uncc.edu

New advisor example

Figure 2 - Note the field arrangement. This is the format that should be sent to be uploaded to Banner.