Help by adding the date column in gradebook

Help by adding the date column in gradebook

од Jhon Do -
Број на одговори: 5
Greetings moodle community.

I need help to include the date column for each of the activities of my students to be able to export it as .xls

There is an option for moodle 1.9 but can not find anything for 2.1.

Someone could help me with this?
Во одговорот до Jhon Do

Re: Help by adding the date column in gradebook

од John Samuel -

i am wondering how do you export Date in gradebook to excel ?

we have the Datetime user profile field for moodle 1.9 but when we export we only get bunch of numbers.. can you please assist me to be able to export it?

Thanks,

Sam

Во одговорот до John Samuel

Re: Help by adding the date column in gradebook

од Marty Soupcoff -

@Sam - Check to see what format you have the dates column in Excel. If you have the dates in number format, then it will display numbers starting from 1/0/1900.

Examples: 1/0/1900 = 0, 2/12/2012 = 40951

Change the date column to date format (there are multiple you can select from) and you should be good to go.

Happy Moodle Logooodling!

Во одговорот до Marty Soupcoff

Re: Help by adding the date column in gradebook

од John Samuel -

i believe it's a unix timestamp and i also believe that there is hack that will help you export dates as dates without converting in excel.

i just can't recall that forum

Во одговорот до John Samuel

Re: Help by adding the date column in gradebook

од Jhon Do -

I have an option for 1.9 and is in this reference, but its in Spanish, I hope will be useful.

Someone who can implement it in 2.1?