How to create a file to be loaded in Banner for Recruit Records
Problem Description :
Loading files that Admissions gets from SAT purchases or from Scanned College nights as Recruit Records in Banner
Resolution :
How to create a file to be loaded in Banner for Recruit Records
You will receive a file from Admissions – Ask for it in CSV format.
SSS2 has already been set up for this in Banner. You can look at SRATPFD to see the fields that you can load.
Name-First
Name – MI
Name _Last
Street_Line_1
Street_Line_2
City
Stat_code
Zip
Gender
Email_addr
HSCH_SBGI_CODE
Mon(these are for birthdate and must be separated into 3 columns – do text to columns –after you do it � � � � � �reformat the first cell to general and the date will show correctly)
Day
Yr
To get the file correct follow the following steps after you have it in the correct column order - to fix the bday column
1. format the cells on the birthdate to custom- 00 (2 Zeros) on birthdate and birthmonth
2. Save the file to your desktop as csv file
3. Open EXCEL and import in the file - (under data)choose to import in from text - comma delimited - general data format - except the birthday column - change the format to text
4. text to columns - be sure that the column data format = TEXT on all 3 birthday columns
5. Save as a csv and move to pebbles
Sample: � Remove any headers
01 /tmp/FILENAME.csv � � (use the filename you were given)
02 SSS2
03 blank
04 blank
05 G
06 201408 example – use the term you want the recruit record created for.
07 US
08 A
09 blank
10 blank
11 blank
12 SAT
13 blank
14 MA
15 WEB
16 blank
17 HOME
18 N
19 blank
20 N
21 N
22 U
23 blank
24 blank
Revision Date : 9/16/2016