Scheduling a BDC

[rajeshkumar_kaveti]

Hi Friends,

My requirement is to upload data in Excel every 1 hour. For this i developed a BDC and i scheduled it in SM36. I am also maintaining a table to record log info. Excel Sheet file name will be combination of date and hour. My Program will pick the file from path '
sap9\c\'. Here Sap9 is the network identification. Every 1 hour the file will be placed in this path. If i run it manually it is picking the file and uploading the data. But in Scheduling it is giving me FILE NOT FOUND error. This i come to know by checking my log table.

I hope the scenario is clear.

Please help me.

Thanks in advance

[rajeshkumar_kaveti]

Hi Friends,

My requirement is to upload data in Excel every 1 hour. For this i developed a BDC and i scheduled it in SM36. I am also maintaining a table to record log info. Excel Sheet file name will be combination of date and hour. My Program will pick the file from path '
sap9\c\'. Here Sap9 is the network identification. Every 1 hour the file will be placed in this path. If i run it manually it is picking the file and uploading the data. But in Scheduling it is giving me FILE NOT FOUND error. This i come to know by checking my log table.

I hope the scenario is clear.

Please help me.

Thanks in advance

[suresh_datti]

Hi Rajesh,

Are you sure you are using OPEN DATASET in your BDC that reads the file? I do hope that, if you use GUI_UPLOAD it will not work in the background.

Regards,

Suresh Datti

[Former Member]

While scheduling background job, you need to make sure that data is uploaded from a application server and not presentation server.

SAP does not support loading file from presentation server in background job. So make sure that you have a folder on your application server which will contain files.

You can use FTP to keep files in this application server and then use syntax OPEN DATASET, READ DATASET, CLOSE DATASET to upload data.

Message was edited by: Ashish Gundawar

[rajeshkumar_kaveti]

Thanks Ashish. Can u please elaborate me how to use FTP to keep file in Application server. And one more thing is i have to keep a new file every hour. How can i automate this.

[Former Member]

dear ashish,

how to schedule a bdc in background, please give details me to me. Yr valueable solution very help full for me.

Thanks & regards

Rathnam

[email protected]

[email protected]

[Former Member]

Hi,

Go through the links,

http://help.sap.com/saphelp_47x200/helpdata/en/69/c250414ba111d189750000e8322d00/frameset.htm

Regards,

Azaz Ali.