Issue Details (XML | Word | Printable)

Key: MDL-16184
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Piers Harding
Reporter: Ron Meske
Votes: 0
Watchers: 1
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

First Access and Last Access dates for SCOs are always the same

Created: 24/Aug/08 06:22 AM   Updated: 12/Feb/09 04:34 AM
Return to search
Component/s: SCORM
Affects Version/s: 1.9.1, 1.9.2
Fix Version/s: 1.9.5

File Attachments: 1. Text File scorm_start_and_end_time_19.patch (6 kB)

Issue Links:
Duplicate
 
Relates
 

Database: Any
Participants: Dan Marsden, Jose G. C., Piers Harding and Ron Meske
Security Level: None
QA Assignee: Ron Meske
Resolved date: 29/Jan/09
Affected Branches: MOODLE_19_STABLE
Fixed Branches: MOODLE_19_STABLE


 Description  « Hide
The reports for SCOs display identical dates/times for First Access and Last Access when accesed from users profile activity reports regardless of data stored.

The logic for First A ccess of a sco is based on finding the earliest time of a all elemts modified, but this is not an acurrate result as each time a data is written to a field the timemodified is updated. Therefore if a Course has one SCO and only writes to the fields of total_time, score_raw, lesson_status, lesson_location, suspend_data, these fields may be updated several times while the sco is being viewed.

I recommend adding an additional field for storing the first access date.



 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Ron Meske made changes - 24/Aug/08 06:48 AM
Field Original Value New Value
Description The reports for SCOs display identical dates for First Access and Last Acces. It looks like there is only one field 'timemodified' being used for both dates in the table '*_scorm_scoes_track'. Recommend adding a field for first access. The reports for SCOs display identical dates/times for First Access and Last Access when accesed from users profile activity reports.

This also seems to occur if a course is completed in one session for the SCORM report accessed from the actual course.
Ron Meske made changes - 24/Aug/08 07:11 AM
Description The reports for SCOs display identical dates/times for First Access and Last Access when accesed from users profile activity reports.

This also seems to occur if a course is completed in one session for the SCORM report accessed from the actual course.
The reports for SCOs display identical dates/times for First Access and Last Access when accesed from users profile activity reports regardless of data stored.

The logic for First A ccess of a sco is based on finding the earliest time of a all elemts modified, but this is not an acurrate result as each time a data is written to a field the timemodified is updated. Therefore if a Course has one SCO and only writes to the fields of total_time, score_raw, lesson_status, lesson_location, suspend_data, these fields may be updated several times while the sco is being viewed.

I recommend adding an additional field for storing the first access date.

Dan Marsden made changes - 25/Aug/08 06:35 AM
Link This issue has been marked as being related by MDL-8150 [ MDL-8150 ]
Dan Marsden made changes - 01/Dec/08 12:50 PM
Link This issue is duplicated by MDL-16897 [ MDL-16897 ]
Dan Marsden made changes - 01/Dec/08 12:52 PM
Assignee Dan Marsden [ danmarsden ] Piers Harding [ piers ]
Piers Harding made changes - 29/Dec/08 02:42 AM
Attachment scorm_start_and_end_time_19.patch [ 15963 ]
Piers Harding made changes - 29/Jan/09 03:17 AM
Resolution Fixed [ 1 ]
Status Open [ 1 ] Resolved [ 5 ]
QA Assignee rmeske
Dan Marsden made changes - 12/Feb/09 04:34 AM
Fix Version/s 1.9.5 [ 10320 ]