...

REPORTING
batch.title=ssp_import

EMAIL NOTIFICATION    NOTE: ** indicates required if batch.sentMail is true)
batch.sendEmail=true                                   Activate email (default: true)
**batch.smtp.host=localhost                         host name (default: localhost)
**batch.smtp.port=25 port                                    port (default: 25)
**batch.smtp.protocol=smtp protocol                          protocol to be used (default: smtp)
**batch.smtp.username=sysadmin               username  (default: sysadmin)
**batch.smtp.password=password               password  (default: password)

RECIPIENTS - COMMA SEPERATED address as string. Address must follow RFC822 syntax. (default: "SSP DATA IMPORTER"&lt;sysadmin@localhost&gt;<sysadmin@localhost>)
**batch.email.recipients="SSP DATA IMPORTER"&lt;sysadmin@localhost&gt;<sysadmin@localhost>
**batch.email.replyTo="SSP DATA IMPORTER"&lt;sysadmin@localhost&gt;<sysadmin@localhost>

CSV FILE FORMAT

1. Name of csv file MUST correspond to the name of the external_table that is to be imported. example: external_person.csv

2. format supported is comma delimite. Quote character is " and the escape character is also "

3. Each file MUST have an initial line containing the column names in the format of the external table. example for external_faculty_course first line would contain: faculty_school_id,term_code,formatted_course,title,section_code,section_number

4. Partial data updates are supported. However, in addition to the data being updated the key values for the specific table MUST be supplied.

   For SSP version 2.0 keys for each external table:

   TABLE	KEY
   external_course	code
   external_course_program	program_code, course_code
   external_course_requisite	requiring_course_code, required_course_code, requisite_code
   external_course_tag	course_code, tag
   external_course_term	course_code, term_code
   external_department	code
   external_division	code
   external_faculty_course	(NONE) recommended faculty_school_id,term_code,formatted_course,title
   external_faculty_course_roster	(NONE) recommended faculty_school_id,school_id,term_code,formatted_course,title
   external_person	school_id
   external_person_note	code
   external_person_planning_status	school_id
   external_program	code
   external_registration_status_by_term	school_id,term_code
   external_student_academic_program	school_id, degree_code, program_code
   external_student_financial_aid	school_id
   external_student_test	school_id, test_code, sub_test_code, test_date, discriminator
   external_student_transcript	school_id
   external_student_transcript_course	school_id, term_code, formatted_course, section_code
   external_student_transcript_term	school_id, term_code
   external_term	code

...