Automation of flat files upload into DSO

[former_member189845]

Hi All,

After reading this Is it possible to receive a csv flat file for l... | SCN

I have thought to automate the manual work process of flat file upload. Generally in support projects, we receive flat files from business through email to upload it, and in a month generally there will at least 60 request. So is there any way to automate it, where we can communicate mail server to our BW system and then read the mail >> take the CSV file and put in to table > and then load in to concern DSO / objects

Any suggestion, how to start of ?

Thanks,

Siva

[former_member182997 · Accepted solution]

hi Siva,

Well to automate the flat file has to be kept in application server and the  process chain everytime when it runs it will select the file and load it in BW targets , the setting in the infopackage can be maintained:

Adapter = Load Text-Type File from Application Server

Step by Step has been described in this document:http://www.element61.be/e/resourc-detail.asp?ResourceId=410

PLease go through and see if it helps.

thanks

[former_member189845 · Accepted solution]

Hi Banik,

Thanks for suggesting link,Is there any way that mail sever can communicate with SAP BW system ?

Because in my case, my user will send the flat file to my mail box, and with manually doing, if there is already a mail server configured between SAP BW system, could be easily to run those flat files in to target.

Transferring Files FTP to SAP BW, there are already some set of users using it, but still FTP software and educating them about the files transfer to FTP and then to BW, is bit difficult. Instead of mail exchange it will be easier isn't so ?

Thanks,

Siva

[former_member182997 · Accepted solution]

hi,

I am trying to understand if this can be achieved another way.

what about no mails from the client and direct upload to the application server.

You can educate your client in this if below works.

I was thinking if  you guys can make use of below process for automation...

there is a function module called : ARCHIVFILE_CLIENT_TO_SERVER 

through which the clients dont need to send you mails and then you will upload the file in server and then process chain will load into BW targets.

They can directly load files and you can schedule the Process chain to load the data into targets in BW..

You can check AL11 in the app server to see the particular locations where to load the file,

There is also another FM called  GUI_UPLOAD

See if these help. I suggest sit with ABAPERS if required and see how you can make it available in client side to upload their files from their side on themselves.. what say? 

-thanks

[surendra_p]

Hi Krishnan,

We can load The Flat Files by Dynamically selection from Application Server On Daily Base using Simple Routine  while creation of Data Source .

For the reference see the below screenshots.

Here i am selecting Flat File from Application server for that we have to put/load Flat files into Application server .

And We have to follow particular Naming Convention for Flat File.

Regards

Surendra

[Loed]

Hi,

Check the link below..I did this to automate loading of flat file and linked it to process chain..

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/603efe5a-b9d4-2e10-67a5-f16e9aa6a...

Regards,

Loed

[former_member189845]

Hi Loed,

Thanks for your reply, I just checked the link but it quite different to my view,

Where my mail and SAP BW should communicate between each other.

Thx,

Siva

[former_member182997]

hi Mate..

How are you?..
Well I liked the link you have sent.

This also uses the FM i suggested . just a different approach all together 

but really liked it...

thanks- Loed !!
-Aparajit

[Loed]

Hi Mate,

Nice to see you active again here..

Really? I will also check your link, maybe it will help me in my future reports..

See you around..

Regards,

Loed

[Loed]

Hi,

Sorry, I think I didn't read the checking your mail thing in your message..

Anyway, instead of telling your users to email the files, how about dumping them in a SHARED FOLDER or APPLICATION SERVER in your company so that process chains will just read them?

Regards,

Loed