Oracle Transactional Business Intelligence

Report Employee Photo in Custom Dashboard

101
Views
5
Comments

Summary

Is there a way to display an employee photo in a custom dashboard?

Content

We have a custom Talent Profile dashboard and I am wondering if there is a way to pull employee photos into the dashboard so they can be printed on the report?

Thank you!

Brenda

Comments

  • Hi Brenda,

    To display employee picture in the dashboard, you have to store all your employee pictures in a web folder and should accessible using the https url.

    Example : https://pbs.twimg.com/profile_images/800840075311333376/515GX-Cc.jpg

    Store the employee picture with employee id.(Ex: ID001.jpg,ID002.jpg)

    Use the below syntax to create a new formula column in your analysis report and select the HTML values in the Data Format (refer the attached screenshot).

    Formula  Sample : '<img src="https://pbs.twimg.com/profile_images/800840075311333376/' ||TRIM(CAST("Employee_ID_Field" AS CHAR)) ||  '.jpg">'

    Let me know if this resolve your issue.

    MANOJ

    Dynasoft Synergy

     

  • Hi Brenda,

    To display employee picture in the dashboard, you have to store all your employee pictures in a web folder and should accessible using the https url.

    Example : https://pbs.twimg.com/profile_images/800840075311333376/515GX-Cc.jpg

    Store the employee picture with employee id.(Ex: ID001.jpg,ID002.jpg)

    Use the below syntax to create a new formula column in your analysis report and select the HTML values in the Data Format (refer the attached screenshot).

    Formula  Sample : '<img src="https://pbs.twimg.com/profile_images/800840075311333376/' ||TRIM(CAST("Employee_ID_Field" AS CHAR)) ||  '.jpg">'

    Let me know if this resolve your issue.

    MANOJ

    Dynasoft Synergy

     

    Properties.png

  • Hi Manoj,

    Thank you for your response.  I'm not sure if my company will go for storing photos that way, but this solution is a definite possibility.  I have moved in the direction of trying to extract the employee photos directly from the table using a DM.  I am hoping to be able to show that in a report that can be pulled into the dashboard.  Have you been able to get that method working?  Here is the SQL from my DM, but I still haven't been able to get the image to show in the report.

    select per_all.person_number,
     per_name.last_name,
      per_name.first_name,
      per_i.IMAGE_NAME,
     per_i.IMAGE
    from fusion.PER_IMAGES per_i,
    fusion.PER_ALL_PEOPLE_F per_all,
    fusion.PER_PERSON_NAMES_F_V per_name
    where upper(PRIMARY_FLAG) = 'Y'
    and per_i.PERSON_ID = per_all.PERSON_ID
    and per_all.PERSON_ID = per_name.PERSON_ID
    and per_name.name_type = 'GLOBAL'

    Thank you!

    Brenda

  • Hi Brenda,

    Please send us sample data (dummy data) for your SQL. This will help us to understand in which format  the image data is stored in the database. Based on that we can suggest if there is a  solution/workaround to resolve the issue.

    MANOJ

    Dynasoft Synergy

  • Hi Manoj,

    I'm Brenda's colleague from Hungary and work as HRIS.

    How can we upload all our employee photos to the WEB folder and which folder?

    do we need a special tool or script for this (I didn't find any options/solution) ?

    Thanks

    Sandor