Import a File

Import a File

You can import a csv or txt file using the Default Template or, if you anticipate reusing the file's import specifications, you can create a template as you import the file.

1. On the left navigation menu, click Import.
2. Do either of the following:
   • To import a file using the Default Template, click Default Template. Continue to step 4.
   • To import a file and create a template with its specifications, click Add Template.

3. Type a Template Name and, optionally, a Description of the template.
4. Next to Import File Path, click . Select the file you want to import.
5. For Import File Type, click either Comma Separated (csv file) or Tab Delimited (txt file).
6. For Header lines to ignore (including blank lines), type the number of lines to ignore when importing the file.
7. For Header line that contains field names, if any, type the line number that contains field names.
8. For Fields per record, type the number of columns that contain data.
9. Optional: To allow blank data in the file to replace existing data for prospects, select the Allow blanks to overwrite existing data check box.
10. For the settings under Mapping of the import fields to AdmissionsPlus, refer to the following diagram and table.
    
    
    

    Set the School, Program, Grade Level, and Year
    A	Do either of the following: If the information in the file differs for prospects, click Multiple for the specification. For example, if the prospects are in different grades. If the information in the file is the same for all prospects, click Single for the specification. For example, if all the prospects are applying to the same program.
    B	Do either of the following: If you clicked Multiple, in the drop-down list, select the field in the file that contains the prospects' information for that specification. If you clicked Single, in the drop-down list, select the AdmissionsPlus data that applies to all prospects in the file.

11.  Under Set primary and secondary keys, do the following:
    1. In the Primary key field in the import file drop-down list, select a field from the file with data that uniquely identifies prospects.
    2. In the Primary key in AdmissionsPlus drop-down list, select the AdmissionsPlus field that corresponds to the file field you chose.
12. Optional: Under Select fields for secondary key check, do the following:
    1. In the Field in Import File drop-down lists, select fields from the file with data that uniquely identifies prospects.
    2. In the Field in AdmissionsPlus drop-down lists, select fields that correspond to the file fields you chose.
13. On the [Demographic/Admission/Contact] Fields tab, in the Fields from filecolumn, click the row and select the file field that matches the AdmissionsPlus field.

    If the file being imported contains data for more than one contact, click Add Contact. Click the Contact [#] Fields tab, and match the fields between the file and AdmissionsPlus.
    

14. To prevent a duplicate prospect from being imported into AdmissionsPlus, do the following:
    1. Click Select Fields for Contact Comparison.
    2. Select the check boxes for the contact fields whose data you want to compare between the file and AdmissionsPlus, and then click Save.
15. If you are creating a template with these specifications, click Save.
16. Click Next. The Import Wizard dialog box opens.
17. Select the check boxes next to the prospects you want to import, or select the check box in the header to import all prospects.

    You can click a prospect in the main table to view their information in the Demographic Fields and Contact Details tables.

18. Click Save.