file access parameter in file adapter at receiver side

[Former Member]

Hi Experts,

1- i am using file adapter at receiver side. i want to create my file with time stamp for that i have given the file construction mode = add time stamp and put file directly .but it is showing time in file name????????

2. i want my file name as TimeSheet_Country_Date_time.csv so for this what value i have to give in file Name Scheme parameter.

Regards

[Former Member]

.........

[abhay_rajhans2]

Hi

Following links may help you for creation of dynamic configuration

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=%28J2EE3417600%29ID1175625250DB0064139626884038328...

http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=95093307

[former_member200962]

2. i want my file name as TimeSheet_Country_Date_time.csv so for this what value i have to give in file Name Scheme 
parameter.

The tiemstamp option that you are using will not give you the filename in the above format Date_Time.....if you are using this option then you cannot either change the format.

What you can do is apply Dynamic Configuration in your scenario....in the UDF get the current time....create the filenam in the format you want by concatinating the required variables and constants...and create the file.....at least the normal naming scheme wont help you.

Regards,

Abhishek.

[Former Member]

1- i am using file adapter at receiver side. i want to create my file with time stamp for that i have given the file construction mode = add time stamp and put file directly .but it is showing time in file name????????

The addtime stamp will add timestamp as the last part of the filename before the extension.

2. i want my file name as TimeSheet_Country_Date_time.csv so for this what value i have to give in file Name Scheme parameter.

You can achieve this using dynamic file naming UDF in mapping and using ASMA in file adapter.

Use current date function and generate the current date. Then use substring to pick date,time from it and format it according to your requirement (TimeSheet_Country_Date_time).Else you can write a UDF to generate the file name as per your requirement and then pass it to the dynamic filenaming UDF in the mapping.

Search SDN for dynamic file naming.

[former_member187339]

Hi,

File with timestamp means FileName+Timestamp, so if you have given filename as XYZ.csv then the output file name will be XYZ<timestamp>

>>i want my file name as TimeSheet_Country_Date_time.csv so for this what value i have to give in file Name Scheme parameter.

Give Filename as TimeSheet_Country_Date_time.csv in file adapter

Regards

Suraj