You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

bulk load photos into peoplesoft

9 replies [Last post]
Guest's picture
Guest

Hi all,

I am relatively new to Peoplesoft but have been asked to bulk load images we have stored in database table so that they are visible in the photo parts of the peoplesoft application.

Any help / advice will be much appreciated.

Thanks

CompShack's picture
User offline. Last seen 6 years 16 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
Re: bulk load photos into peoplesoft

Hi there,
I not an HR person so never had to deal with such a requirement but let me try to understand your question better. Are the pictures already on the PS_EMPL_PHOTO table?

visible in the photo parts of the peoplesoft application.

Can you expand on this please?

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Guest's picture
Guest (not verified)
Re: bulk load photos into peoplesoft

The photos exist in another table: PS_PHOTOS. These need to be migrated into PS_EMPL_PHOTO.

One problem with doing an insert statement is that PS_PHOTOS.PHOTOGRAPH is a BLOB type where as the PS_EMPL_PHOTO.EMPLOYEE_PHOTO is a LONG RAW type.

I appreciate your help.

CompShack's picture
User offline. Last seen 6 years 16 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
Re: bulk load photos into peoplesoft

The EMPLOYEE_PHOTO on PS_EMPL_PHOTO is a blob and not LONG RAW. Did you try something like this:

INSERT INTO ps_empl_photo
   (SELECT emplid, psimagever, TO_LOB (photograph)
      FROM ps_photos)

More details about the to_lob function can be found here. Please let us know the outcome!

You might also want to try the TO_BLOB() fucntion. It will convert RAW to BLOB. It is important to do that in your insert statement (like shown above).

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Guest's picture
Guest (not verified)
Re: bulk load photos into peoplesoft

Thanks, but please see below the describe on the tables on our system:

desc sysadm.ps_empl_photo;
EMPLID VARCHAR2(11)
PSIMAGEVER NUMBER(38)
EMPLOYEE_PHOTO LONG RAW

desc sysadm.ps_photos;
EMPLID VARCHAR2(11)
UM_USER_NAME VARCHAR2(150)
UPDATED_DTTM DATE
UM_RAW_IMAGE BLOB

I think the conversation from BLOB to LONG RAW is the problem. I cant find anything that will do the job. However, the PS_EMPL_PHOTO table is at the moment empty so can we change the type of the field and will it still work as normal through the front end?

Many thanks.

CompShack's picture
User offline. Last seen 6 years 16 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
Re: bulk load photos into peoplesoft

What version of Peoplesoft are you on? When I do desc on ps_empl_photo i get employee_photo as a blob.

PS_EMPL_PHOTO table is at the moment empty so can we change the type of the field

Yes, I would do that. Blob carries more advantages over LONG RAW and I would be surprised if this causes you any problem on the front end.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Guest's picture
Guest (not verified)
Re: bulk load photos into peoplesoft

Hi we are on PS version 8.9.

I tried changing the field type this morning, however now when I manually uplaod a photo through the front end the image is not displayable (it has a red cross in the far left) where as when I did this before the data type change it was fine so I dont think that is going to work.

Thanks

CompShack's picture
User offline. Last seen 6 years 16 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
Re: bulk load photos into peoplesoft

I'm sorry to hear that. I would login a ticket with PeopleSoft customer connection site to help you with this issue. I'm kind of out of ideas on this one :( (I haven't had enough exposure to HR since I'm a FIN guy)

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Guest's picture
Guest (not verified)
Re: bulk load photos into peoplesoft

Cool - thats no problem... Thank you for all your effort :)

Varun's picture
Varun (not verified)
Re: bulk load photos into peoplesoft

i have a similar situation. i need to display the picture of an employee who is currently logged in. when i checked in the above mentioned record EMPL_PHOTO, the values in the employee_photo are stored as BLOBS. can you tell me how should i display this photo on a page in Peoplesoft based on the current logged in User using Peoplecode?