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??