Hi Carlos,

I translated the simple certificate language strings into Mexican spanish at AMOS (http://lang.moodle.org/). I will try it in my local server and report to you.

It certainly looks very nice and useful.

Hello Carlos,

I'm using the Simple Certificate plugin and accurate paste text and a picture on the back of the certificate on page 02.

Please, vote in this module in Moodle Tracker,  to the moodle admin give me edit access to tracker, so i can use it to put improvements tasks and any one can report a bug (in moodle tracker).
https://tracker.moodle.org/browse/CONTRIB-4120

Hi Carlos,

This may be an ignorant question but do I understand this module to allow for custom certificate?  I mean can I create a custom cert. in a PDF with appropriate spaces for customizable text, and just upload it into the system?

Thanks in advance, Steve

Works great with 2.4.3 so far.  Thanks for doing the mods.  One question: Is there a way I can add variables other than the ones you've listed in the module help?  Info from other global or custom fields?  I added a couple of unique fields to the user profile area and I need the info displayed on the cert.

Thanks,

Greg

hi

just for information, french language file (thanks to Daniel Methot) is updated in AMOS system for all Moodle 2.x versions.

cheers.

More than 1000 downloads,  that's great,  thanks for all

you can add in the certificate list of fully equipped Scorm with the completion date?
something like the attached file

Hello again Carlos, I think I found a little bug in this module.

With the module installed, if I try to launch an activity report I get an error message that says it can not access the table "simple_certificate" (in debug mode).

I tried to copy the table "simplecertificate" into a new table called "simple_certificate" and the error has been fixed.

New version has come,  version 2.0.0,  with many improvements like:

• 2-side certificate with text and image;
• disabling QR code;
• user's profile fields (user custom fields too)

Enjoy

This plugin is now available to moodle 2.5

Hi,

I am new to moodle and my first add-on is simple certificate and found it very useful and easy. Just one suggestion if can be consider to add a unique certificate number (auto generated) and provided a variable of the same so it can be displayed on the certificate.

thanks

Olá Carlos,

É possível neste módulo realizar a liberação do certificado apenas quando o aluno atingir uma nota X (60% por exemplo)?

Caso seja possível, como eu poderia configurar esta opção?

Hi, Carlos. Nice Job with the plugin.

I've installed and tested it and i really like it. There's some issue that i'd like to tell you about: When you use an empty parragraph tag in the text box, the whole text disappears. I mean that if i use <p></p> in the html code, the whole text get lost, whereas using </br> tags works fine. I've tried in different browsers with the same behavoir. It's not a big deal, just a bit odd.

Does it happen to you, or should it be something about my theme, browser, or whatever?

Thanks.

New plug-in version available

• plug-in version for moodle2.2 is now fixed (it's was broken);
• some deprecated warnings is now fixed;

Okay, so forgive me because I am a newbie. I have installed this plugin and everything checks out. My question is how does the certificate get implemented? Does the certificate become available when the user completes the course within the conditions set for completion? Does the Teacher/Administrator have to make it or send it to them? There is no indication of a certificate when someone completes my course. The only place where there is anything about a certificate is in the Site Admin >Plugins >Simple Certificate. I don't see it anywhere in the Course Administration or in the user settings when they complete it. Please help.

I recently upgraded to Moodle 2.5 and upgraded to your most recent version of Simple Certificate. When I print a certificate using the {DATE} option see (Screen Capture 1) the certificate  prints the numeral '1' where I've specified the date should appear.

In your previous response you referred me to http://www.php.net/manual/en/function.date.php for additional information on how to format the {DATE} variable but no matter how I try to implement your recommendation I do not get a date. As the 'help' for the certificate does not provide additional information, please provide some examples of how I would use the {DATE} variable. 

Thank you

Hi, thank you for this plugin.  Your hard work is very much appreciated.  I have installed it on a 2.2 version of Moodle.  All works great except for the custom fields that I have created.  The certificate is not pulling the information from the short names created under Administration > Site administration > Users
> Accounts > User profile fields.  I have tried all different combinations (i.e. PROFILE_PHOTOID, profile_photoid, profile_field_photoid, etc.)

Some of my fields below (custom ones not working):

Proof of Completion Certificate is presented to:
Name:  {USERNAME}    <--- works
Type of Photo ID:  {profile_field_photoid}  <--- no (custom)
ID Number:  {PROFILE_IDNUMBER}  <--- no (custom)
ID Expiration Date:  {PROFILE_IDEXPIRATION}   <--- no (custom)
Completion Date: {DATE}  <--- works
for Completion of {COURSENAME}.  <-- works

Any help would be appreciated. Thanks!

New version is released, 2.1.0

and i will not apply new stuffs in this plugin for moodle 2.3 and 2.2, this is the last version for them

Changes:

version - 2.1.0
-Put code in a text mark (#17)
-Bulk Operations (#21)
-QR Code in frontpage (#22)
-Background images not required item (#27)

---FIXED BUGS
-Issue options send as email: conding_excetpion thrown (#22)-slabrador

see at:
https://github.com/bozoh/moodle-mod_simplecertificate/issues?milestone=4&page=1&state=closed

New version: v2.1.1 - 2013092800,  Enjoy

• improvements

#28 -TCPDF ERROR: Can't open image file
#33 - put check boxes in bulk operations
#35 - Put SIMPLECERT_PER_PAGE e SIMPLECERT_MAX_PER_PAGE in settings

• fixed bugs

#30 - Wrong translation
#32 - Wrong db field
#34 - The head of table in bulk operation is not translated

Reporting another issue ... latest version of simplecert installed ... Moodle 2.4.highest - CentOS PHP 5.3.3.

Using latest FireFox.

[Wed Oct 09 18:00:53 2013] [error] [client IPADDRESSofclient] PHP Fatal error:  Call to undefined method core_renderer::tabtree() in /var/www/html/mod/simplecertificate/locallib.php on line 1083, referer: http://site/course/view.php?id=4

After setting up a simplecert, when clicking the link to it, get blank page with only header of the moodle site and the beginning of the rest of the page (blocks/content/etc are gone).  There is a 'box' started with certificate in the content area.  Switching themes made no diff.

Commented out the line referenced above: 1083

//      echo $OUTPUT->tabtree($tabs, $tab);

Now renders and can click links to acquire cert, but there might be some other functionality now broken ... don't know and really don't have the time right now to investigate more.

'spirit of sharing', Ken

Hi Carlos. First off, great plugin. Quick question for you. If I'm logged in as a user called Training Manager. When I navigate to the Issued Certificates tab for a course it lists the users who have certificates just fine. However, if I click on the PDF link, it opens up in a new browser window and instead of the {username} variable saying John Doe like it should it says Training Manager. If I navigate to Bulk Operations tab and download the certificate it has the correct name on it, John Doe.

Did I do something wrong? Maybe I have a configuration setting wrong?

I attached a screenshot and spliced the two screens so you can see that the certificate was awarded to John Doe but comes up as Training Manager.

Hi there,  

I am having a problem with the certificate issue. When a user finishes the course the certificate link becomes available.  But when the certificate is clicked I get the message: "The certificate can't be issued, because the user hasn't reached the course objectives" The objectives is 100 score completion and student even shows as passed. It is the same settings used with the previous version that works.  I have just updated to the latest Simple Certificate version, then when i got the error, tried to uninstall the module and re install it. Are there any ideas as to what might be causing the issue? I am running the latest version of 2.5.2+.

Cheers

Steve

For some reason the {TEACHERS} variable does not show up any values on the certificate but the other variables are working fine? Any help is appreciated. I am running Moodle 2.5. Thanks!

New simplecertificate version v.2.1.2

Fixed BUGS:

1. #39 No certificate are displayed in moodle 2.2 bug
2. #42 Fatal error: Call to undefined method core_renderer::tabtree() in /home/elo.ja.nl/www/mod/simplecertificate/locallib.php on line 1083 on moodle 2.4 bug
3. #43 Error when upgrading - Moodle 2.4 branch bug
4. #46 Bulk operations : Doesn't write the grade on pdf bug
5. #47 Front text is printed in front and in back page, back text is ignored bug

Enhancements:

1. #41 improve {TEACHERS}
2. #44 Add "send to e-mail" in bulk operation
3. #48 Create a test case checklist
4. #49 put a white background in QR code

Plugin version for moodle 2.6 is release !

Hi Carlos. 

Thanks for the plugin, it's exactly what I'm looking for. However, I have a problem with it: i have the issue options selected as Email User the PDF. I do get the email, but no attachement, even though it's coming up on-screen fine. 

Any ideas on howto fix this? Thanks!

Hugh. 

Hi Carlos,

I notice that your certificate can be emailed to the student.

Would it be possible to re-notify the student via email that based on the certificate date that the course needed to be done again?  For example an annual Fire Safety compliance course. It would be good to be able to set the number of days between certificate issue and the reminder.

I hope this is possible 

Cheers

Mark

Hi Carlos, 

I've popped this into a different thread - I hope this is ok. Is there a way to edit the text/subject in the email that is sent to users? An XML file of something similar or is it hard-coded?

Thanks!

Hugh.

I installed the module in 2.6.  I can add Simple Certificate as an activity to a test course in weekly format.  However, when I login as a student, I can see all activities except for the certificate activity.  I have no restricted access or completion requirements set.  Am I missing something?  If I login with the admin account, the certificate activity displays appropriately.

Hi, 

I just installed simple certificate the latest version just now, on a moodle 2.6 install on linux. 

I was wanting to know how do i get the certificate to appear when the student has completed the work. but not before.. is this possible. 

Many thanks for your help. 

Hi Carlos, 

All is working brilliantly with this plugin - thanks for creating it. I've tried to change the text in the Lang>En>simplecertificate.php file for one of my on-screen messages - however this isn't reflected on-screen. Any ideas what I might be doing wrong? Is this caching somewhere etc?!

Thanks. 

Hugh.

Is there a way to have a fraction of an hour or a decimal in the Hours in course field?  Whenever I put something like .5 or 0.5 the hours field is blank on the certificate.  If I put in 1/2, it shows as 1 hour on the certificate.

Moodle v.2.5.1 + Oracle 11.2.0.1.0

Simple Certificate version 2013111200

------------------------------------------------

I have a course with four tests, and a certificate associated with each test. As configured, the certificates are only available when the related test is passed with a grade of 70% or higher. Each certificate is also configured to email the certificate to the student and notify the course administrator when the certificate is completed. I am experiencing a problem with messages being sent to the course administrator for two certificates when the link on the course main page is selected, and no message is being sent to the course administrator for one certificate when the 'get certificate' button is selected. The following are the exact symptoms for each situation

Here is how the course main page is set up...

Here is how each Certificate is configured with the exception of the 'Certificate Text' field which is different for each test that is associated with each Certificate.

Thank you for any assistance.

Thank you for this great certificate module! I got it working just fine. One question:

If I set certlifetime = 0 will my certificates stay ? I want to keep our certificates

Hi Carlos! As requested, here are my suggestions...

If you don't mind, I have a few suggestions for a future release of this wonderful plugin. Would it be possible to:

1) Update the description page so that it indicates that your plugin is compatible with Moodle 2.6? The Download versions page indicates that it is compatible with Moodle 2.6 but the Description page says it is only compatible up to Moodle 2.5. Can you ?

2) Have Moodle filter support? We run a bilingual (English/French) site where users would want their certificates to be created the in the current site language. The functions format_string() and format_text() would need to be applied. For more information, see http://docs.moodle.org/dev/Output_functions.

3) Have a dropdown menu containing a list of certificate templates so that they would not have to be re-created each time someone creates a course? That way one could load a certificate and then just make minor changes as needed.

4) Expand the fonts? No matter what I do, the font always seems to be narrow. I was also going to ask if it would also be possible to add more sizes so that I could make fonts larger but then realized that I could probably do that in HTML. Still, it would be nice to have sizes available up to 72 pt.

5) Make the QR code in the Test Certificate verifiable? Either that or include a message somewhere that says it can't be verified. I spent some time testing the QR code with my phone only to eventually realize that it wasn't the Captcha I was typing that wasn't working.

6) Give the code below the QR Code image a solid background colour in case it is printed over an image?

That's it for now. Thanks again for all your great work!

Best regards,

Michael Milette

Olá Carlos, 

Parabéns pelo excelente módulo desenvolvido. A facilidade de edição realmente ficou muito simples.

Estava fazendo uns testes e me deparei com uma dúvida( que também tem no módulo certificate original)

Se uso os métodos de autenticação: correio eletrônico e redes sociais em meu curso, por padrão os campos Firstname e Lastname são destravados e consequentemente o usuário consegue editar a qualquer momento o seu nome e sobrenome.

Finalizei um curso e fui fazer um teste: o usuário poderá emitir quantos certificados ele quiser para várias pessoas apenas alterando o nome e sobrenome.

Vi que o QRcode será sempre o mesmo, assim como o código gerado no módulo certificate também, mas o nome sempre será o registrado na base de dados.

Se eu bloquear o campo nome e sobrenome os próximos a fazerem inscrição no moodle não conseguem se cadastrar.

Por enquanto não vi outra solução a não ser contar com o bom senso do aluno.

O que acha? já passou por algo similar?

até breve

Hi Is there any possibility to have a variable for the user picture so that it can be used to display/print in the certificate also?

New Version release:

v2.1.3 - 2014030100

Changes and fixes:

#66 Put white background color in code text (below QRcode picture)
#62 paging in Bulk operations doesn't work correctly
#60 Clear not set variables
#57 folder separation string
#55 Manager certificate is not removed
#54 certdatefmt left with old values after upgrade
#53 Fix some tables parameters
#65 Verify completation

Hi Carlos,

first of all, thanks for simple certificate. It surely takes a lot of time and passion to keep it up & running.

I am thinking about switching from ILIAS to Moodle, got a fresh installation of moodle with certificate and simple certificate for testings.

The plugin certificate works fine, including the creating of certificates. But it is from my point of view way hard to customize, especially if you offer more than one course. The plugin simple certificate unfortunately creates here an error if I want to get a certificate created: PHP catchable fatal error. That was surprising for me, too. So I turned on the debug and maybe this can help to sort it out:

---boc---

Notice: Undefined property: stdClass::$numsections in /var/www/.../moodle/mod/simplecertificate/lib.php on line 567

Coding problem: $PAGE->context was not set. You may have forgotten to call require_login() or $PAGE->set_context(). The page may not display correctly as a result

    line 451 of /lib/pagelib.php: call to debugging()
    line 734 of /lib/pagelib.php: call to moodle_page->magic_get_context()
    line 1394 of /lib/weblib.php: call to moodle_page->__get()
    line 1259 of /lib/grade/grade_item.php: call to format_string()
    line 575 of /lib/conditionlib.php: call to grade_item->get_name()
    line 525 of /lib/conditionlib.php: call to condition_info_base::get_grade_name()
    line 131 of /lib/conditionlib.php: call to condition_info_base::fill_availability_conditions_inner()
    line 1065 of /course/lib.php: call to condition_info::fill_availability_conditions()
    line 617 of /lib/modinfolib.php: call to get_array_of_activities()
    line 450 of /lib/modinfolib.php: call to course_modinfo::build_course_cache()
    line 411 of /lib/modinfolib.php: call to course_modinfo->__construct()
    line 2003 of /lib/modinfolib.php: call to course_modinfo::instance()
    line 2842 of /lib/moodlelib.php: call to get_fast_modinfo()
    line 39 of /mod/simplecertificate/view.php: call to require_login()

---eoc---

I read about some themes creating that error, tried every theme that comes along with moodle. No effect, the "PHP catchable fatal error" is resistant to that.

Any advice or anything I can send to solve this?

Thanks for your patience,

Chris

Hi Carlos!

I have a question... On the display of the certificate To "GET CERTIFICATE" is it possible to remove the summary of marks from this page? My client doesn't like how it shows up before the get certificate button and would like it removed. But there is no option to "hide" it and i was unsure where to start to remove it displaying from the code.

If you need more information please let me know.
Thank you for your help in advance.

Nicole.

Hi Carlos,

Thanks for creating this activity.  I was wondering if you could add a modulename_help language string for the component mod_simplecertificate so that a description will appear in the right side of the Activity chooser when Simple Certificate is selected.  Many of the activities have this help string and without one it just says "There is currently no help associated with this resource or activity". 

Maybe something like:

The simple certificate activity module enables the teacher to create a custom certificate that can be issued to participants who have completed the teacher’s specified requirements.

This would help promote this module to our users.

Thank you for your consideration and your work on this module.

Drew

Hello Carlos,

really thanks for this great moodle module!
I have an answer:

using {FIRSTNAME} tag you can display the student name,
using {LASTNAME} tag you can display the surname,
using {USERNAME} tag you can display both of them

but is possible display the username, that used to log in?

Thank you in advanced,

Antonio

P.S. Today I started to translate the module in my language, the italian.

Carlos,

Line 1237 in the \mod\simplecertificate\locallib.php page of your Simple Certificate activity contains:

    $limitsql = " LIMIT $perpage" . " OFFSET " . $page * $perpage ;

which adds a "LIMIT ... OFFSET ..." parameter to the $issedusers SQL:

    $issedusers = $DB->get_records_sql("SELECT u.*, ci.code, ci.timecreated
    FROM {user} u
    INNER JOIN {simplecertificate_issues} ci
    ON u.id = ci.userid
    WHERE u.deleted = 0
    AND ci.certificateid = :certificateid
    AND timedeleted IS NULL
    ORDER BY {$sort} {$limitsql}", array('certificateid' => $this->id));

SQL Server does not support "LIMIT" and "OFFSET" so that "LIMIT ... OFFSET ..." parameter effectively breaks the plugin on MS SQL Server:

Default exception handler: Error reading from database Debug: SQLState: 42000<br>
Error Code: 102<br>
Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'LIMIT'.<br>

SELECT u.*, ci.code, ci.timecreated
				FROM mdl_user u
				INNER JOIN mdl_simplecertificate_issues ci
				ON u.id = ci.userid
				WHERE u.deleted = 0
				AND ci.certificateid = '1'
				AND timedeleted IS NULL
				ORDER BY   CAST(firstname AS NVARCHAR(255))  +  CAST(' ' AS NVARCHAR(255))  +  CAST(lastname AS NVARCHAR(255))    LIMIT 30 OFFSET 0
[array (
  0 => '1',
)]
Error code: dmlreadexception
* line 423 of \lib\dml\moodle_database.php: dml_read_exception thrown
* line 260 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
* line 367 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
* line 788 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
* line 836 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
* line 1248 of \mod\simplecertificate\locallib.php: call to sqlsrv_native_moodle_database->get_records_sql()
* line 1338 of \mod\simplecertificate\locallib.php: call to simplecertificate->get_issued_certificate_users()
* line 83 of \mod\simplecertificate\view.php: call to simplecertificate->view_issued_certificates()

Is there a way to build that $issedusers SQL without using LIMIT ... OFFSET... so that your plugin works on SQL Server hsoted Moodle sites?

Hi there can I modify the QR code based on our own format? Also where can I see the code for that ? Thanks 

Hi!!

And congratulations for your work. 

I would like to use the "digital signature certification" option of TCPDF library (see an example of use in http://www.tcpdf.org/examples/example_052.phps).

Is it possible?

Hi Carlos

i Try to use SimpleCertificate in Moodle 2.7. Installation its ok,  but when i try to add a new custom certificate after complete all fields i have this error and debug info

Any chance to solve or upgrade to be compatible with 2.7 version of Moodle?

Thanks in advance

Hi Carlos,
Thank you so much for the certificate module, it works great. Could you please let us know how we may send email with the certificate automatically, once student completed the quiz in the course? Do you plan to add such a functionality in the nearest future?

Thank you,
Gennady

Hi!!

Two questions about signed simplecertificate PDF file. I've modified the locallib.php file and now the certificates are digitally signed with a *.crt certificate. But:

1. I would like to add one field in the activity form, for telling the app the name of the *.crt file that I want to use for signed the PDF file. How can I add a new field?

2. The "Download certificates in one ZIP file"  and "send by email" options does not produce signed PDF's. The rest of options works fine. How works these options?

Thanks!!

PD: I add my modified locallib file.

locallib.php

Hi Carlos,

Could you please let us know what would be the easiest way to make "Issued certificates" tab to show certificates ordered by the date with the newest on top?

Thank you,
Gennady

Hi Carlos, what do you mean by "Users that met the course objectives" in the Bulk operations; Show dropdown menu? Because everytime I select that option it also lists all the users enrolled in the course/group. Where should I modify the objectives so that it only lists all with the conditions met? Thanks in advance.. 

Invitation to test the new version of the plugin