Guide To Add Logo To OTM Certificate

Guide To Add Logo To OTM Certificate

Guide To Add Logos To OTM Certificate. 


Step 01: First convert the image(logo) to base64 format using the below url


https://codebeautify.org/image-to-base64-converter



It will generate a large string value as above.




Step 02: Write the update query to add the image.


update ohrm_online_course_certificate_template set body = ’’;


Inside tag <img src= ‘data:image tag paste the large string value that was generated earlier on step 01


2.1: Adjust height and width of the logo according to the client requirement (this will be in the body property named as “height = px width = px”


2.2 Adjust alignment of the logo by tweaking the below style attributes this is also in the body property under img tag


style="display: block; margin: 0 auto;">



Note: margin: 0 auto will place the logo in the center and setting display: block will make alignment easy

Note: Sample query is also added for your reference. 



Verification steps (Front-end)


Go to Employee Management


Click an Employee


Go to the Qualifications tab as shown below




Scroll down to Certifications and download any one of the certificates.



This will open up in a another tab and check whether logo is correctly placed


If not edit the css part again according to your need and run the update query again (refresh the tab once you ran the update query to reflect the changes in OTM certificate)



    • Related Articles

    • Add doner in Gender Links instance

      Gender Links is a custom client. There can be a configuration request to "Add Doner", This needs to be added from the back end  1. Backup the database backup_db /var/www/html/OHRMStandalone/PROD/genderlinks/ 2. Insert the below query INSERT INTO ...
    • SSL Certificate Updation - Onsite Clients

      This KB was generated with Volante Technologies in mind as the client has a minor difference in how they update these certificates on their side (Azure Front Door). The certificate validity shows correctly when checking on the browser, however, on ...
    • What to know about Online training module (OTM)

      The online training module (OTM) is a separate module developed by the professional (PS) team. This is not part of the OrangeHRM base product. It is a separate build.  The video below contains the basics of the module. This video is based on the ...
    • CCS Pay Rate Update

      CCS Pay Rate Update Client requests to update Pay Rates for their employees from time to time. As this was a frequent requirement a custom script was written to do this task to avoid the manual work. Client's requirement is to update the Pay Rates of ...
    • Changing a birthday image

      Requirements           1.   IP address, username,password of the server.          2.  MySQL  password and username Procedure          Step 1:   Firstly, log into the server using appropriate credentials.                                   ssh -o ...