topic Re: dynamic name Flat file reading. in Application Development and Automation Discussions

dynamic name Flat file reading.

Former Member — Thu, 16 Apr 2009 03:53:40 GMT

Hi all,

my client wants to schedule a BDC program for daily running.

But the file name is changed daily eventhough path is fixed.

can this be done.

can we read dynamic file from local system.

thanks in advance

Vikash.

Re: dynamic name Flat file reading.

Former Member — Thu, 16 Apr 2009 04:00:12 GMT

Hello,

Although the path remains the same and the filename changes, is there any common pattern in the name of the file?

for eg..

..../ abc_20090416.txt, etc

If the name of file is dynamic based on either the current date or current time, we can handle these dynamic files in our program. But if the name of the file changes altogther handling it wont be possible. think about some common pattern for filename.

Hope i am clear.

Regards,

Mansi.

Re: dynamic name Flat file reading.

Former Member — Thu, 16 Apr 2009 04:00:58 GMT

Hi Vikas,

It can be done, just make some rule for the file name, like filename will be always the system date,

so as u know the path just u need to concatenate the system date with the file path and u can pass to the gui_upload FM to upload the file for the BDC.

Hope u get my point.

Amresh.

Re: dynamic name Flat file reading.

Former Member — Thu, 16 Apr 2009 04:16:01 GMT

hi,

yes it is possible, make sure that u r file name pattern and input file pattern should be same. in such a way that make the file name it is easy to handle.

Re: dynamic name Flat file reading.

Former Member — Thu, 16 Apr 2009 04:17:48 GMT

Hi ,

yes the file has the name pattern "SAP Forex Upload_10042009.xls" the dates will keep on changing..

with warm regards.

vikash

Re: dynamic name Flat file reading.

Former Member — Thu, 16 Apr 2009 04:26:28 GMT

yes. so u can at initialissation for the paramter which takes the filepath name you can set to synamic filename as below


data : p_filename  type RSVAR-FILEPATH.
initialization.

concatenate '/....SAP Forex Upload_' sy-datum+06(02) sy-datum+04(02) sy-datum+00(04) into p_filename.

Re: dynamic name Flat file reading.

Former Member — Thu, 16 Apr 2009 04:30:24 GMT

Hi Amresh,

Can u elaborate the solution.

the excel file is having a fixed pattern name that is "ddmmyyyy.xls"

what i need to concatenate .

currently i have put file path as parameter.

can u give me any sample code so that it ll be easy for me to understand.

Thanks in advance

Vikash

Re: dynamic name Flat file reading.

former_member156446 — Thu, 16 Apr 2009 04:40:13 GMT

in the initialization event...

concatenate p_path sy-datum '.xls' into p_path.

and use this p_path in gui_upload or open dataset... to read the file...

or you can provide a p_date type d in the selection screen and concatenate p_path p_date '.xls' into p_path.