Variable substitution or dynamic configuration

[Former Member]

Hi,

I am doing Proxy sender to File receiver scenario. I have message payload like,

MTtest1..... 0..1

date.... 0..1

item....0...unbound

I want to create a text file with the name SAP<date>.

I am using a variable substitution method, date: payload: MTtest1, 1, date, 1

Target directory: SAP%date%

I am getting the filename correctly, But this creates a blank line in the top of the file. Please suggest me how to overcome this issue.

If a send the date at the end, how the it must be written in variable substitution method.

If I need to use dynamic configuration, please tell me how to do that, i saw few blogs, but i am not able to get it.

Thanks and Regards,

Sri

[former_member206760 · Accepted solution]

dear arunsuri,

modify your structure like this...

MTtest1..... 0..1

+item....0...unbound

++date.... 0..1

then write var subs like : payload : MTtest1,1,item,1,date,1

in FCC

item.fieldnames :abc,xyz,date

item.fieldfixedLengths:say 5,4,0

item.fixedLengthTooShortHandling:Cut

this will not allow ur date field to come in the output file

Edited by: Tarang Shah on Mar 25, 2009 8:03 AM

[former_member181985]

what is your file structure, flat or XML?

>I am using a variable substitution method, date: payload: MTtest1, 1, date, 1

>Target directory: SAP%date%

This doesnt create an blank line in the target payload.

Even if you use dynamic configuration also it doesnt create. No need to go for Dynamic Configuration for your case.....

[Former Member]

Hi,

It is from XML to a flatfile. The date field is not included in the flat file, because of which i am getting a blank in the notepad file.

[former_member181985]

Search forum this type of problem has been answered. You have to change File Content conversion logic a bit.

Can you paste the FCC conversion parameters used..........

Edited by: Praveen Gujjeti on Mar 25, 2009 9:42 AM

[Former Member]

Ya i tried searching, File content conversion will not remove blank line. They are sugesting to use dynamic configuration which i am not familiar with.

[former_member181985]

Can you paste the FCC conversion parameters used..........

[jagesh_lakdawala]

Dear Arunsri,

Better to use Dynamic Confi method becs its recommended by SAP also.

Please Follow the below steps.

(1)Create the UDF and pass Filename as an Input parameter as shown here.

___________________________________________________________________

public String Set_Output_File_Name(String var_Filename, String var_Directory, Container container) throws StreamTransformationException{

DynamicConfiguration conf = (DynamicConfiguration) container

.getTransformationParameters()

.get(StreamTransformationConstants.DYNAMIC_CONFIGURATION);

DynamicConfigurationKey key = DynamicConfigurationKey.create("http://sap.com/xi/XI/System/File","FileName");

conf.put(key, var_Filename);

return "TRUE";

________________________________________________________________-

(2)In File receiver adapter configuration, select the Adapter Specific message attributes and in that select the Filename Option.

Regards

jagesh

[Former Member]

Hi Jagesh Lakdawala ,

We are using a report program to trigger the proxy. We are not using any mapping in the XI side.

Will this Dynamic configuration works in this case.

Thanks,

Sri

[former_member181985]

Dynamic configuration will not work since you dont have a mapping case.