If you are registered to use the TextBooks module, then you may import Course and TextBook data. These are two separate functions – the Course data includes all Courses (i.e. Subjects) that are taught. The TextBook data lists all Items required per Course. You must have imported all the Items using, say, the Inventory import function before you import the TextBook data. Thus, the latter assumes that the related Inventory data is on file already!

The two sets of data must be imported separately, although they can be performed in any order.

1: Courses (i.e. Subjects):

The code that must be entered in the MLE box is: TEXTCOURSE, ss, SKIPDUP

Where nn is the shop code associated with the data being loaded. If absent, then the current shop is assumed. The string SKIPDUP is optional and may be included to skip all input that is already on file. This parameter may also be the first parameter, if the current shop is being used as the shop code for the data being loaded. Included in the data are lecturer details (name, phone number etc) – this will maintain the table of Lecturer codes. The course (i.e. subject) description may also be included – this will set up the table of Subject codes.

The fields in the input record are defined below:

2: Textbooks required per Course (i.e. Subject):

The code that must be entered in the MLE box is:
TEXTBOOK,keyword-1,keyword-2,keyword-3,…

Where keyword may be entered in any sequence and may be any of the following codes:

AUTOCALC If the Item code is a 12 digit number, that commences with any code, then the check digit will be computed in the last (i.e. 13th) position. If this parameter is read in, then the following parameter is ignored.

AUTOCALC=xxx where xxx represents the first three characters of a 12 digit number. Only those 12 digit numbers commencing with xxx will have the check digit computed and inserted into the 13th position. Up to twenty of these parameters may be entered, in order to accept a number of codes.

ADDZERO If this parameter is present, then the above conversion of a 12 digit number, is changed when the first two digits are both zeroes. The 12 digits are shifted to the right and a zero is added to the front of the number. The number will then start with three zeroes.

SHOP=ss where ss is the Shop code that is going to be used in place of the current shop, i.e. the shop where we are running this data import.

STARTNUMOK If this parameter is present, then any Item Code that commences with a digit (0-9) will be accepted, provided that the number does not contain 8, 10 or 13 digits.

IGNOREDUP If this parameter is present, then all input data will be ignored if a match is found i.e. if the record is already on file, then the input record will be ignored.

Note that the keywords are not case sensitive.

The fields in the input record are defined below:
 

Field	Maximum Length
Year	4 (e.g. ‘01’ or ‘2001’)
Semester Code	2
Subject Code	10
Item Type: Prescribed or Reference	1 (P or R)
Item Code	13
Quantity Required in the Booklist	5 (Default is 1)
Line Number (if zero, then this increments by 5 for each entry)	3
Course Quantity as Suggested by the Lecturer	5
Course Quantity as Suggested by the Textbook Buyer	5
Course Quantity Actually Ordered	5
Confirmation Date	10 (DD/MM/YYYY)
Status (0.new 1.Adopted 2.Estimated 3.Decided 4.Ordered	1
Order Due Date	10 (DD/MM/YYYY)
Comments	60

Notes:

1. The Item Type is retained within Table 93 – any single character may be used as the Item Type.

2. If the Line Number is not supplied, then one will be assigned, being incremented by 5 as each Item is processed. It is, therefore, imperative, that the data is loaded in the correct sequence, and all details for the same Year & Semester & Subject & Item Type must be together.

3. The date may be entered as: DD/MM/YY or DD/MM/YYYY.