• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
How many items may be attached to a course? The reason for the question is as follows:

In the Course Reading Management online module (course reserves ), a staffer
successfully added a document to an instructor's course. The system returned a
message saying the document was added. However, after refreshing and even restarting
the server, the document title does not appear in the document list for that course.
Is there a limit to how many documents can be attached?

document's barcode: 32815007719084
Course Code is: PEP442.01

The item does appear in the C.R. web OPAC, although the course and instructor fields are blank.

Resolution:
Item barcode 32815007719084 = z30_rec_key 000344646-000010:

SQL> select z30_rec_key from z30 where z30_barcode = '32815007719084';

Z30_REC_KEY
---------------
000344646000010


util f/3/12 shows that this item is linked to abc30 doc 417:

ENTER HOME LIBRARY : bro50
ENTER DOC-NUMBER : 000344646
ABC01 000344646
ABC30 000000417
END

We see that there are 53 docs linked to the course PEP442.01:

SQL> select count(*) from z11 where z11_text = '$$aPEP442.01';

COUNT(*)
----------
53

but this doc is not one of them:

SQL> select count(*) from z11 where z11_text = '$$aPEP442.01' and z11_doc_number = '000000417';

COUNT(*)
----------
0


The number of docs which can be linked to a course is in the hundreds ... certainly not 53.

They need to go into Courses and select the Course -- click on Docs -- Add

and then specify the Document number (000000417) or barcode.

If this happens frequently, then some additional analysis might be necessary.

• Article last edited: 10/8/2013