Hi Every body,
A question is: a student paper that was submitted as assignment on Blackboard but the file is blank , Is it possible to find the submitted file size from the logs. or how can i find the size on db
There is a known issue where students who use Edge, and have the document they wish to submit already open on their computer, find that the file they submit is 0kb.
Also Blackboard support can provide a query to find problem files. We had a student who had a 0kb file uploaded using Chrome. Bb provided a query we could use to prove that the file was submitted at 0kb.
The query was
select * from files where pk1 = (select files_pk1 from attempt_files where attempt_pk1 = ( select pk1 from attempt where gradebook_grade_pk1 IN ( select pk1 from gradebook_grade where course_users_pk1 = ( select pk1 from course_users where users_pk1 = (select pk1 from users where user_id = 'INSERT USERNAME HERE') AND crsmain_pk1 = 'INSERT PK1 OF COURSE HERE' ) ) ))
An easy way to get the PK1 of a course is to go into the course and look in the url for the part that says course_id=_XXXXXX_1 The XXXXXX bit should be the pk1.
Retrieving data ...