Transcript CFNC Admission Import V2

CFNC Admission Import V2
Presenter
CPCC
Charles Cox
ITS Project Leader
CFNC Admission Import V2
What is CFNC
 Web Site Managed by College Foundations of NC. Part of
Pathways of North Carolina (www.CFNC.org).
 CFNC Contact:
Robin Greene - [email protected]
General Overview of
Admission Import Process
CFNC
XAP
Communicator
Colleague
Process Flow
Admissions
Architecture
Student is ready to
register
(If qualified)
Custom Move to Student and
Application Status change
CFNC On Line
Application
AAI (ELF)
Import
Phase I
AAI (ELF)
Import
Phase II
4 Flat Files
Datatel
Datatel
(1 custom)
Intermediate Files
Colleague Files
What makes up the Admissions Flat
Files
 The Admissions application produces a set of 4 flat files in
order to import into colleague.




MAIN File: General Demographic info for a student
INST File: Transcript, Degree, and High School info
TESTS File: Test scores and times
MISC File: North Carolina Specific info (Custom file)
All Files are extracted to conform to the defined AAI flat file
definition defined by Datatel’s Admissions Application
Interface
(AAI) process with the MISC file enhancement.
Where is the Application?
 If the .Main file cannot be found no data is processed.
 Each file must have same file name with the file
extension being different (.main, .inst, etc).
 File name format:
School Code + Year+Month+Day+Hour+Min
 Example
 CPCC200602010905.main
 CPCC200602010905.inst
 CPCC200602010905.misc
 CPCC200602010905.tests
What’s new for CFNC V2
 New Fields being imported into colleague.
 New Ethnicity field required by Fed Govt
 New Races field required by Fed Govt (all that apply)
 Student Cell Phone Number
 Primary Language (on Foreign students)
 Mailing address (if different from Primary address)
Mailing address City, State, Zip, Country
 Preferred Name
 Mother’s Education level
 Father’s Education level
Made Possible By
 Modifications made by CFNC to the online application
for requested enhancements over the past 2 years.
 Modifications made by NCCCS to bring over the new
import fields into Colleague.
 Beta tested by CPCC, Stanly CC, College of Albemarle
Download Manager
CFNC Control Site Slots
CFNC Control Site Slots
Click
“CLEAR”
CFNC Control Site Slots
Click
“Pre-generated”
CFNC Control Site Slots
Click
CFNC…Main
File V2
CFNC Control Site Slots
Fill in fields like this example above. (Use Custom selection for Pattern)
CFNC Control Site Slots
Repeat the other 3 slots the same as Main selecting the V2 versions for
INST, MISC, TESTS.
CFNC Control Site Slots
Click
Mark/Unmark
CFNC Control Site Slots
Date range before
School started
downloading
Click on “MARK DOWNLOADED” on each of the four download formats.
Very Important: if this step is skipped you will receive downloads of every
application your college has ever received.
XAP Communicator
Xap Communicator normally runs on a IT Server and may only be
accessible by your IT staff. The following needs to be done on XAP
Communicator program. Click on Preferences.
XAP Communicator
Make sure your current CFNC username and password is filled in. Also the
XAP server should be your live account if this is your production Xap
program. All other items here can default. Click on Download Tab.
XAP Communicator
Your first 4 items should look like this. You may have other entries also.
Click on Main file V2 and click on “edit selected settings” button.
XAP Communicator
Fill in the directory location you plan to save the downloaded file. The
local server space. Then click on “post-Download Actions”
XAP Communicator
Fill in the URL or IP address of your datatel server, Username used to FTP
the files into colleague, password of FTP login. Directory where to ftp the
files on colleague.
\datatel\coll18\production\apphome\DATA\DATA_I\IMPT.APPL.DATA.
Click OK.
XAP Communicator
Repeat the setup process for the other three V2 download formats.
Colleague Updates
Mailing
address
type
Colleague Updates
MRGC - IBIO.PERSON.NCM
Add new
fields
Lastly
• Verify the reports are coming out with correct results and no
unusual errors..
• Check Colleague screens (SHAP, RGPE, XNCA, FPER, IASU)
• Primary Language (foreign students only ) FPER
• Ethnicity and Races, addresses, preferred name on RGPE, NAE
Questions??