Thank you Stuart -- didn't see your reply before responding to Rex and Ray. It seems this would work also for Simple Course Pages created in the course as well? I hadn't realized that was what she was wanting to look at before my first question. Thanks!
Doug Douglas Mills Director of Instructional Technology Department of Chemistry University of Illinois On 6/25/15, 8:49 PM, "lon-capa-users-boun...@mail.lon-capa.org on behalf of Stuart Raeburn" <lon-capa-users-boun...@mail.lon-capa.org on behalf of raeb...@msu.edu> wrote: >Hi Doug, > >> I'm sure there must be a way to do this but I'm not finding it. Is >> there a way to view usage information for content uploaded into a >> course (I.e. not in authoring space anywhere)? How is that done? > >Every page access in a course is recorded in the activity.log file for >the course. What usage information do you wish to view? > >When you use /adm/trackstudent (e.g., by selecting the "View a user's >recent activity" item in People > Users > "List and Modify Multiple >Course Users" to view a user's activity in a course) you are viewing >the contents of this file sorted chronologically, and filtered to show >only records for that particular student. > >If you delete the "selected_student=username:domain" item from the >query string appended to /adm/trackstudent you can display all page >accesses (although each page only displays 500 records at a time). > >Comments 15, 16, and 17 in bug 121: >http://bugs.loncapa.org/show_bug.cgi?id=121 >request the ability to filter trackstudent results by resource or by >map (i.e., folder). > >I have re-opened that bug and re-assigned it to myself to implement a >user interface to access the filtered results (this will likely be >made available from the Statistics menu). > >For now what you could do to access usage data for content uploaded >directly to a course is to call /adm/trackstudent and refresh the >display a few times until the most recent date/time for the processed >data is the current date/time. > >Then contact a system administrator with command line access to the >library server in your domain and request a dump of the appropriate >MySQL tables: > > coursenum_domain_activity > coursenum_domain_machine_table > coursenum_domain_resource > coursenum_domain_students > >(replacing coursenum_domain with the values for the course, e.g., >22764011027874598uiuclibrary1_uiuc) so you can load them into a MySQL >instance running offline. There you will run MySQL queries to extract >the usgae data you are interested in, e.g., for a resource with id=22 >in the coursenum_domain_resource table: > >select distinct(student_id) from coursenum_dom_activity where res_id = >'22'; > >In the four tables, coursenum_domain_resource maps unique IDs to >LON-CAPA's unique resource identifiers (symbs), and >coursenum_domain_activity lists timestamps and user IDs etc. for >accesses to each unique ID. Each ID is an auto_incremented number (1 >.. N). Mapping of user ID to student username:domain is in >coursenum_domain_students. > >You are interested in the symbs for the content uploaded into the >course (i.e., *not* imported into the course from the shared >repository) which for content at the top level of the course will have >the form: > >uploaded/<dom>/<coursenum>/default.sequence___<id>___uploaded/<dom>/<cours >enum>/docs/default/<id>/<filename> > >where <id> is LON-CAPA's index for the resource in the particular folder. > >As Course Coordinator you can list all "symbs" in a course using: >Course Editor > Content Utilities > List Resource Identifiers > >Let me know if you have any questions. > >Thanks, > >Stuart Raeburn >LON-CAPA Academic Consortium > >Quoting "Mills, Douglas G" <dmi...@illinois.edu>: > >> Hi All, >> >> I'm sure there must be a way to do this but I'm not finding it. Is >> there a way to view usage information for content uploaded into a >> course (I.e. not in authoring space anywhere)? How is that done? >> Thanks, >> >> Doug >> >> Douglas Mills >> Director of Instructional Technology >> Department of Chemistry >> University of Illinois > >_______________________________________________ >LON-CAPA-users mailing list >LON-CAPA-users@mail.lon-capa.org >http://mail.lon-capa.org/mailman/listinfo/lon-capa-users _______________________________________________ LON-CAPA-users mailing list LON-CAPA-users@mail.lon-capa.org http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
