My Certificate Block - adding fields to rpt for issued certificates

My Certificate Block - adding fields to rpt for issued certificates

by Chris Collman -
Number of replies: 1
Picture of Documentation writers
I like the certificate report that uses a My Certificate block, especially 'view issued certificates' report with Excel download feature. This was offered by Chardelle as a way to see all certificates on a site.

But I can not figure out how to add the user profile fields idnumber and institution to it as an export in Excel.

Any clues would be appreciated. Was able to do this in the mod/certificate report in the course context but not the site context. Thus revealing I know nothing about php and how to access the MySQL datatables smile

If I figure it out, I will share here. Best Chris
Average of ratings: -
In reply to Chris Collman

Re: My Certificate Block - adding fields to rpt for issued certificates

by Chris Collman -
Picture of Documentation writers
OK, that was a long day. I had to add some fields (I guess) in lib.php, then create and place strings in the report.php.

Working on trying to take the date and put it into excel format. At moment

$arraydate = explode(',', userdate($user->certdate), 3);
$myxls->write_string($row,6,substr($arraydate[1],2));

Just about has it, except there is still a charcter in front of the date which I can delete in Excel, Another function I bet.

Better than it was.

I will upload a zip of the files in case anybody else wants to play. Have to go to a meeting. Shall return. Chris
Average of ratings: -