Adoption Import File Specification

Format Layouts for Various Import/Export Files (Banner, Course Adoption, etc.)

From Campus to TCS:

File Name: Adpt-Imp.txt
File Type: DOS ASCII Text – Tab Delimited
Line Terminator: Carriage Return/Line Feed [decimal 13:10]

There is one line per adoption. If there is more than one book per adoption, you must provide a new line for each with the department, course, and section duplicated.

The fields with an “*” in the front are required.

If you are exporting for use with the on-line faculty adoptions then you also need fields 5 (Instructor) and 18 (Instructor Email).

If you are only reporting Actual Enrollment then fields 1, 2, 3, and 19 are required.

The fields MUST be provided in the order listed. This means that if position 8, Required (Y/N), is going to be imported then positions 5-7 must be populated or entered as an empty position. An empty position in Excel would display as an empty column. An empty position in text format would be denoted with an empty tab delimiter.

* Denotes Required Fields
~ Denotes Non-Book Fields
(ABC) Denotes Excel column label if editing in Excel prior to saving as tab delimited

*~1 (A). Department
*~2 (B). Course
*~3 (C). Section
~4 (D). Estimated Enrollment
~5 (E). Instructor
6 (F). ISBN-13
7 (G). Quantity to Cover
8 (H). Required (Y/N)
~9 (I). Course Description
10 (J). Author
11 (K). Title
12 (L). Edition
13 (M). Copyright Year
14 (N). New Price
15 (O). Used Price
16 (P). QOH New
17 (Q). QOH Used
~18 (R). Instructor Email
~19 (S). Actual Enrollment
~20 (T). Campus Class Number (unique per store/term/dept/crs/sect)
~21 (U). Store Number (if the file contains detail for multiple stores)
~22 (V). reserved for admin use
~23 (W). Virtual Crs Flag (“VC” = Campus Class Number is for all stores)
~24 (X). Section Web Comments (pain text only.)

A/R Customer File Export to TCS

From Campus to TCS:
File Name: BKSTCHRG_yyyymmdd_hhmnss.TXT
File Type: DOS ASCII Text
Line Terminator: Carriage Return/Line Feed [decimal 13:10]
Line Layout as follows:

This file can either be fixed column as shown below or Tab delimited in the order below.
The Customer must indicate their preference when the interface is initially configured.

Columns:

1 – 10	Customer Identification Number                                     Up to 10 numeric characters left justified – space filled
11 – 40	Customer Name Up to 30 alpha characters left justified – space filled (Last name, First name)
41 – 50	Credit limit dollar amount 10 numeric characters right justified – space filled No decimal (2 point assumed) Remit ‘9999999999’ if Credit Limit is NOT Limited Remit ‘0’ (zero) if Credit Limit is NONE
51 – 65	Customer type/termyear (e.g. PELLGRNT/201310) Customer type is limited to 8 alpha numeric characters Termyear is limited to ‘/’ and 6 alpha numeric characters These two fields should be concatenated and then left justified in 15 characters – space filled.
66 – 100	E-mail address (optional) Up to 35 characters left justified – space filled
101 – 110	Expiration Date (optional) Up to 10 characters left justified – space filled Format: mmddyy or mm/dd/yy or mm/dd/yyyy

A/R Customer File Export to Campus

From TCS to Campus:

File Name: BKSTINVO_yyyymmdd_hhmnss.TXT
File Type: DOS ASCII Text
Line Terminator: Carriage return/line feed [decimal 13:10]

Line layout as follows:
This file can either be fixed column as shown below or Tab delimited in the order below.
The Customer must indicate their preference when the interface is initially configured.

Columns

1 – 10	Customer Identification Number Up to 10 numeric characters left justified – space filled
11 – 40	Customer Name Up to 30 alpha characters left justified – space filled (Last name, First name)
41 – 55	Customer type/termyear (e.g. PELLGRNT/201310) Up to 15 alpha numeric characters left justified – space filled This field is same as what is sent in the BKSTCHRG file. (Customer type is limited to 8 alpha numeric characters Termyear is limited to ‘/’ and 6 alpha numeric characters These two fields should be concatenated and then left justified in 15 characters – space filled.)
56 – 65	Transaction Reference Up to 10 numeric characters 5 digit register number + 5 digit receipt number
66 – 75	Transaction amount 10 numeric characters right justified – space filled Positive value     (e.g. ‘      1423’ = $14.23 charge) Negative value    (e.g. ‘     –1423’ = $14.23 credit)
76 – 83	Transaction date 8 numeric characters YYYYMMDD format (e.g.  20130620 = June 20, 2013)