Mass upload of photo in Archive link

[Former Member]

Hi.

We have to do a mass-upload of photos in the Archivelink (OAAD).

Any standard program to do this, or any other clues anyone please?

Thanks in adv.

[Former Member]

Everyone on these boards who is posting technical details on creating a new program to upload HR photos is moslty correct, but overcomplicating the issue. SAP has already provided us a program called OA_UPLOAD_AND_LINK that will load and link employee photos.

Assuming that the backend is setup correctly, the main requirements are simply that the photo's are jpg files that have the naming convention of employee#.jpg (i.e. 00012345.jpg).

Despite being undocumented, I have personnally used this is verson 4.7 and in ECC 6 over a period of 4+ years.

In addition to employee photos, this program can also be used to upload just about any object. Again using the naming convention objectnumber.appropriateextention. The program can even be copied and modified to derive a differnt object number based on the file name. For example, if the file name is LastName,FirstName, the program could search for the employee number and use that derived number to upload the object.

[Former Member]

Everyone on these boards who is posting technical details on creating a new program to upload HR photos is moslty correct, but overcomplicating the issue. SAP has already provided us a program called OA_UPLOAD_AND_LINK that will load and link employee photos.

Assuming that the backend is setup correctly, the main requirements are simply that the photo's are jpg files that have the naming convention of employee#.jpg (i.e. 00012345.jpg).

Despite being undocumented, I have personnally used this is verson 4.7 and in ECC 6 over a period of 4+ years.

In addition to employee photos, this program can also be used to upload just about any object. Again using the naming convention objectnumber.appropriateextention. The program can even be copied and modified to derive a differnt object number based on the file name. For example, if the file name is LastName,FirstName, the program could search for the employee number and use that derived number to upload the object.

[Former Member]

Hi Alan

I have to do mass photo's upload. Do u have any steps to follow or document on this which will help me a lot.

Thanks

Chandra

[Former Member]

Hi Alan

I have to do mass photo's upload. As you said i am using OA_UPLOAD_AND_LINK.Do u have any steps to follow or document on this which will help me a lot.

Thanks

Chandra

[Former Member]

Alan!

Thank you so much.. your answer for bulk upload is so helpful.. thank you so much

For all the people.. why do you need more steps to use this program? Alan is simply described it!

Thanks again Alan.

Good luck

Regards,

Shweta Thakkar

[Former Member]

Hi,

You are true Shweta, I also have uploaded MASS Photos, as directed by Alan, no need to use any other program. This standard program rocks!

Thanks,

Roshan

[former_member18619]

Hi Alan,

I have tried the program OA_upload_and_link to upload mass employee photos but there is an error message stating file extension not set correctly. Please could you let me know as to how to proceed with this error.

thank you,

Naveen

[treee111]

Hi guys,

in addition to Alans answer which is correct, but first i failed because i saved the pictures without the leading zeros.

Safe the pictures with 8- digit length and .jpg ending and the program OA_UPLOAD_AND_LINK will do the job!

A link where the program is described in detail and also a way how to get all pictures with the correct naming convention: LINK

cheers

[Former Member]

Hi,

a simple SAP solution can be done by writing a small ABAP report: combine the following function modules:

SCMS_UPLOAD for uploading from a application server shared backend path or frontend path. The image is represented as a binary table.

SCMS_DOC_CREATE (or SCMS_AO_CREATE) for storage of a binary table in a content repository (the ID of the content repository must be ArchiveLink compliant meaning a two letters ID).

ARCHIV_CONNECTION_INSERT to write the connection in the ArchiveLink table. Here, you must know your relevant business object (SAP_OBJECT) your doctype (AR_OBJECT) and your OBJECT_ID.

I assume that you need this for HR so here your SAP_OBJECT is PREL and your AR_OBJECT should be HRICOLFOTO as far as I remember.

Now, you report must loop over the files and execute the upper function modules. The key issue is that it is possible to refer from the file name to the personnel number being part of the OBJECT_ID of the business object PREL.

I hope that helps a bit

Best regards

Torsten

[Former Member]

Thanks Torsten and Christopher.

I am on leave and shall check out the solutions proposed by you on Monday.

Thanks again.

Have awarded points

[Former Member]

Hello,

I am an ABAP-beginner and currently trying to write the little report you mentioned. I combined the three mentioned function modules. The function SCMS_UPLOAD results in an internal table line that contains the binary photo-string I suppose. I defined the table like this:

BEGIN OF it_picture OCCURS 0,

line(1022) type X,

END OF it_picture.

The next function SCMS_DOC_CREATE results in a Docid.

So far so good. The third funcition ARCHIV_CONNECTION_INSERT creates the connection between the personell number and the photo-file. When I search for the Docid in TA OAAD, I can find the entry with PREL, the Object-ID, the correct crep-ID, the Docid, the HRICOLFOTO, and doctype jpg.

But when I open PA20 to see the employees photo, I can't see it.

Also when I try to view the archived object from TA OAAD, I only see an empty page.

So I guess one of the three funcions modules is not working correctly. I have the feeling it's the SCMS_UPLOAD.

First I defined the line of my internal table with a length of 1024, but then the function scms_doc_create dumps because it expects a length of 1022 in the table content_bin.

Could this be the reason for my problem? Or does anyome of you have an idea what I could do to solve this problem?

Thanks & kind regards

Alex

[Former Member]

Hi sir,

i am new in HR and need to store a document in SAP_SYSTEM, adn want know with what shall i start first? after uploading the file, shall convert to string or to xstring and then which FM shall i call to strore my Document in SAP_SYSTEN and waht about the content repository id, how can i get it?

thanks in advance

Sharl

[ChrisSolomon]

Anurag pretty much just repeated useless information from other threads on here. Search the forums for "mass upload photo" and you will find several other threads on the same topic. Most folks seem to just ignore the actual question and post the same old well-known info about how to config ArchiveLink for photos, how to run t-code OAOH to link employee to photo, etc. But I will try to help for your actual question...how to MASS upload the photos....this comes from another thread where I answered this too...

()

we have/had the same problem. Since OAOH throws up a windows "file open" dialog, recording a BDC and going that route was not an option. Our solution...we used the Mercury tool to create a script to do it (you might be able to do this with a CATT script as well). Others on here have asked the same question in the past and I have yet to see a simple, SAP solution to this.

[Former Member]

transaction OAOH is used for manually uploading a photo of the employee.

For mass uploading check this thread it may help you.

[url=http://sap.ittoolbox.com/groups/technical-functional/Sap-r3-hr/photo-upload-871217[/url]