Channel Name & Content Title is null in content_summary_logs.csv

[hani647]

Observed behavior

Channel Name & Content title seems to be missing in kolibri v15.6 in content_summary_logs.csv report. For previous version
it seems to be there but not sure what happened with newer version?

Errors and logs

Expected behavior

content_summary_logs.csv must have "Content title" so that admin can see the time spent by the user on any specific item.
…

User-facing consequences

learner

Steps to reproduce

1. Generate "content_summary_logs.csv".
2. Check content_summary_logs.csv
3. You will see Channel Name & Content Title is empty.

Context

Kolibri: v15.x+

[rtibbles]

Hi @hani647 - thanks for reporting this. We've had a similar report from a user on our community forums: https://community.learningequality.org/t/kolibri-session-log-files-empty-system-glitches/2513/8 but have so far been unable to replicate the error in our local testing.

I am wondering if there's anything specific to your context that we might be missing? What language are the Channel titles and Resource titles in? What script are they using? Is there anything else that might be relevant that we may be missing?

[rtibbles]

Also - do you happen to know what Python version is being used to run Kolibri?

[hani647]

Hey @rtibbles ,
Thanks for the prompt response, I'm using Python 2.7.18.

[hani647]

Content title & Channel name are in English. We're using below endpoint to generate content_summary_logs.csv on Kolibri server and that causing the issue that's mentioned in your forum issue too.

/api/tasks/tasks/startexportlogcsv/

[hani647]

@rtibbles its worth to mention here that same code works well with kolibri v13.x and that column empty issue only exist in v15.x.

[rtibbles]

Thanks for the detailed feedback here - we think we've isolated the issue to a regression that occurred in the 0.15.5 release. In an effort to generate CSV files that were not vulnerable to injection attacks when opened in Microsoft Excel, it seems that these columns ended up getting removed instead of just santized.

[rtibbles]

This has now been fixed in #9602 - we are planning to make our next patch release by the end of August which will include this fix. Thanks for reporting!