Importing Catalog Data
Please send us the data in txt file format, vertical pipe "|" delimited with column names in the first row. Include all of the following column headers:
[Edition] [varchar](9), [Department] [varchar](150), [DepartmentAbbr] [varchar](150), [CourseCode] [varchar](150), [CourseLabel] [varchar](250), [CourseDescription] [varchar](7000), [Units] [varchar](40), [LectureHours] [varchar](20) NULL, [LabHours] [varchar](20) NULL, [OtherHours] [varchar](20) NULL, [Prerequisite] [varchar](1000) NULL, [Corequisite] [varchar](1000) NULL, [Recommended] [varchar](1000) NULL, [Offered] [varchar](250) NULL, [GradeBasis] [varchar](50) NULL
All columns required.
Do not include the actual bracket in the column names.
No spaces in the column names.
Columns with the word NULL in the line are not required to contain data.
All other columns are required to contain data.
Columns not required to contain data are still required to be included in the file.
The detail info above, such as "varchar(150)", is telling you that the field should not be longer than 150 characters. If it is, it would be cut off. That’s bad.
If anything were to get cut off, the file would actually not be able to be imported.
An IT person can do those checks for you on your side before you send the file.
If you have trouble with getting your data into a text file, you can send the file as an Excel file (xls) (in which case you do not have to worry about a delimiter).
File Naming Convention
Name the file "tblCatalogDataImport_ABCD_yearmonthday.txt" (Ex. tblCatalogDataImport_SDSU_20151109.txt) We're using tbl for table, followed by the type of import this is, "_", followed by the school acronym, "_", year, month, day and text file extension file type of ".txt".
[Edition]: 2014-2015 [Department]: Business Administration [DepartmentAbbr]: Bus [CourseCode]: Bus 100B [CourseLabel]: Exploration of Business II [CourseDescription]: Continued exploration of business careers. Additional business departments and other campus services provide information on courses, skills needed, opportunities, and drawbacks of various occupations. [Units]: 1 [LectureHours]: 3 [LabHours]: 3 [OtherHours]: 1 [Prerequisite]: Bus 100A and Registration in the Faculty-Student Mentor Program. [Corequisite]: Concurrent enrollment in BUS 100B L (Lab). [Recommended]: Keyboarding ability of 25 words per minute. [Offered]: Fall [GradeBasis]: c/nc<br>
We aren’t accepting different department names that have the same dept abbreviation.
BIOL: BIOLOGY/BIOLOGICAL SCIENCES, GENERAL
BIOL: FORESTRY, GENERAL
BUS: BUSINESS/COMMERCE, GENERAL
BUS: BUSINESS/OFFICE AUTOMATION/TECHNOLOGY/DATA ENTRY
BUS: COMPUTER AND INFORMATION SCIENCES, GENERAL
Find unique names or append the department names.