Uploading a file: File adapter-RFC

[Former Member]

Hi experts,

I need to upload an excel in my R3. I have to take it from a folder via file adapter.

I am actually using an RFC adapter calling a function who upload files in base64. My problem is that because my file comes into XI in a binary format I don't succeed with my mapping. Now I'm trying with modules in my file adapter.

Anybody have any idea about how to implement this scennary easily? (more or less )

Regards

Gonzalo

[Former Member · Accepted solution]

Hi Gonzalo !

Check this out :

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

Regards,

Matias.

[Former Member · Accepted solution]

Thanks, I knew this blog. But I don't want to use the content. I just want to take the whole file and upload into R3(via RFC or other method).

Do you think that I have to use modules? or there is other way?

Regards

Gonzalo

[nisarkhan_n · Accepted solution]

I dnt c any other menthod to upload whole file direclty...check this blog from michel

using XSLT mapping

/people/michal.krawczyk2/blog/2005/12/10/xi-generating-excel-files-without-the-java-nor-the-conversion-agent-not-possible

[Former Member · Accepted solution]

Hi Gonzalo !

If you don't want to use the content, you mean you want to upload it as a binary?

By the other hand, how are you planning to use this uploaded file once in R3? maybe with this info I can suggest any other ideas.

Regards,

Matias.

[Former Member · Accepted solution]

Hi Matias,

What I want is just upload the file in R3. Just take the file from a folder in binary, using, for example, a file adapter. I don't want to process the content, the functional content of the file is just the file itself.

Later, the file is uploaded in R3 ready for being consulted or uploading.

In fact we have developped an RFC who achieves in loading a file in R3 if it is sent as a base64 info.

The both links you have posted are useful in a content conversion case, but I just want to upload the file.

Regards

Gonzalo

[Former Member · Accepted solution]

hi

As U told that U developed a rfc

who achieves in loading a file in R3 if it is sent as a base64 info.

As per my knowledge from PI u"ll get only XML message .

If U want to Upload in R/3 first U jv to convert the

XML file into Excel ,then Only U r able to upload the file

So if U get an excel file output from PI then easily U can upload in R/3.

Thanks

ManAs

[Former Member · Accepted solution]

Hi Gonzalo !

Maybe you will need to use the PayloadSwapBean in file adapter sender to convert the message to attachment and then use ABAP Proxy server as receiver, that allows handling attachments (it uses SOAP to connect to XI). Then, inside the ABAP Proxy, you can "extract" the attachment and send it as parameter to your RFC.

I think you need to use

GET_ATTACHMENTS / (IF_WSPROTOCOL_ATTACHMENTS)

http://help.sap.com/saphelp_nw70/helpdata/en/a7/3b2a2d45a34a23b75e3b18745c63bc/content.htm

Regards,

Matias

ps: please award points if useful.

[Former Member · Accepted solution]

Thanks, that was the point!

I'll try with that.

Regards

Gonzalo