close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

How to print a training certificate

Thread began 6/05/2014 6:35 pm by mora398588 | Last modified 6/10/2014 11:26 am by Jason Byrnes | 976 views | 14 replies |

mora398588

How to print a training certificate

I used DA to create a database and administrative site to track information and enrollments of our training attendees. So far, the database is working great. Now, I would like to take this project a step further - give our attendees the option to view and print their training certificate.

I understand that I will need create a user login so our attendees can sign in and view their courses, as well as view and print their training certificates. My dilemma is how do I come up or design a training certificate template where I can dynamically insert the attendee's name, course title, and course completion date.

I have already checked online for training certificate html or php templates and cannot seem to find any. I am uncertain what WebAssist can do for me. I am open to any suggestions, referrals to other sites, software, etc. to assist with this project.

Thank you for your time.

Sign in to reply to this post

Jason ByrnesWebAssist

In this sense the training certificate would be a an HTML page that contains a recordset to pull in the dynamic data for the person viewing it.

use Dreamweaver to create the certificate design, and create the recordset that returns the dynamic data.

Sign in to reply to this post

mora398588

Thank you so much for your suggestions. It did not occur to me to use Dreamweaver to design the certificate. Now I know what to do.

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

Sign in to reply to this post

mora398588

Things are working great with my training certificate. However, I would like to limit the attendee's access to the certificate based on their course status.

My database contains a column which records the enrollment status of an attendee, i.e., enrolled, cancelled, pending, complete, etc.. I would like only those attendees whose enrollment has a status of "complete" to view their training certificate.

I am thinking I could create a URL variable (Status) and use Security Assist to create a rule where the variable can return the certificate, such as ?Status=Complete. However, I am uncertain how to go about coding or creating the rule where the rule pulls the correct information from the correct database column (in this case, the Status column within the database).

Thank you for your time and assistance.

Sign in to reply to this post

Jason ByrnesWebAssist

on the login page, edit the security assist authenticate user server behavior.

On the session tab, click the plus button and select the Status column to save the users status in a session at login.

Use that session when creating the access rule for the certificate.

Sign in to reply to this post

mora398588

Thank you for your reply, Jason.

However, I was not very clear as to where the enrollment status was recorded. For that, I apologize. The enrollment status is recorded in another table (enrollments), and is not located in the contacts table where Security Assist will use to authenticate the user.

So, based on your suggestions, I am unable to add the "status" column as a session variable. Should I insert a recordset of the contacts table and INNER JOIN the enrollments table where the enrollment status column is located? Will SA be able to see the inner joined status column and thus create the session variable?

Sign in to reply to this post

Jason ByrnesWebAssist

On the certificate page, create a recordset that looks up the status in the status table by the UserID session.

You can then use the set session value behavior to save the status to a session, and use the status session in the access.

when applying the access rule, just make sure that the code order has the page restriction code after the recordset and session code:
-recordset
-Set Session
-Page restriction

Sign in to reply to this post

mora398588

Here is what I have done so far. I have attached my certificate file, as well as the rules page for your review. Any feedback?

Thank you.

Attached Files
HelperGroupsRulesPHP.zip
course_certificate.zip
Sign in to reply to this post

Jason ByrnesWebAssist

The rs_enrollment recordset does not return the EnrollmentType column so will not be able to save that to the session.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...