This is the same task as in our last campaign (T181305)
We would like to track the following:
*Who did whitch module (user id)
*Exitpoints of modules per user id
*Timeframe in which the users completed the steps
@Ragesoss: Is it possible that you provide @GoranSMilovanovic again with the data? Just as last time :)
I've just emailed the this data to Goran.
It includes extra timestamps for the start time and the last time a new slide was visited, but only for recent records since we started saving such data.
Here's the updated code I used to pull the data:
module_ids = [40001, 40002, 40003, 40004]
csv_data = [['username', 'training_module', 'last_slide_completed', 'module_completion_date', 'started_at', 'last_slide_completed_at']]
module_ids.each do |m_id|
tm = TrainingModule.find(m_id)
tmus = TrainingModulesUsers.where(training_module_id: m_id)
tmus.each do |tmu|
csv_data << [tmu.user.username, tm.slug, tmu.last_slide_completed, tmu.completed_at, tmu.created_at, tmu.updated_at]
end
end
CSV.open('/home/ragesoss/wmde_training_data.csv', 'wb') do |csv|
csv_data.each do |line|
csv << line
end
end@Ragesoss: I'm sorry - I didn't specify the time, when we need that Information. The campaign will end on 10. May. So we would need the information on 11. May or the Monday after the campaign. Shall I reopen the task on that day or write you a reminder? How would be the easiest way for you?
@Stefan_Schneider_WMDE Cool. Ping me here at the end of the campaign and I can do that.
Hi @Ragesoss, could you please provide the data like described in the task description? We need the data from the 07. May until today 16. May. Could you send me a list or a table per mail (stefan.schneider@wikimedia.de)? Any readable format is OK. Thx in advance!
@Stefan_Schneider_WMDE I've sent you a CSV with the data. Please reopen if there's anything else you need.