cancel
Showing results for 
Search instead for 
Did you mean: 

Proxy to File, FCC at Receiver side

raviteja_satuluri
Contributor
0 Kudos

Hi Experts,

Please help on the below Mapping requirement.

Out put File Format :

I have done the FCC Parameters in Communication Channel

But my requirement is the out put file is

The second line in the above pic is should be first line. and the first line should be second line.

For this what are the FCC parameters needs to be add.

Please let me know.

Regards,

Kamal

Accepted Solutions (1)

Accepted Solutions (1)

raviteja_satuluri
Contributor
0 Kudos

Thanks to all of you for support, The solution has obtained by doing some changes in Mapping level as it is an existing interface. The mapping changes has done by Senior.

Once again thanks to all.

Regards,

Kamal S.

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Kamal,


Glad to hear you issue was resolved.

Can you pls post the solution for this so it could help other who might be facing the similar issue.

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi kamal,

Do the mapping as per Your requirement. first line should be a second line and second line should be a first line.

Regards,

Rajendra K

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Kamal,

The first line in your output file would be the header line as you have maintained the parameter in FCC for it.

Coming from second line onwards, according to your xml, it will get appended to the file.

Please let us know with exact issue details if you still having issues.

raviteja_satuluri
Contributor
0 Kudos

Hi Vishnu,

Actually I have to get four constants above header line (header line is already cmng in ouput curremntly).so I have taken 4 fields and in receiver data type and mapped with the constants in mapping. I used FCC parameter also but constants are coming in second line as shown in screenshot.Please help me out how to get constants above header line by default.

raviteja_satuluri
Contributor
0 Kudos

structure is

header

  field1

  filed2

  field 3

  field 4

Record

  field 1

  field2

  '

  '

  '

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Kamal,

I don't think you can achieve this. Since the four fields you are sending in the xml message and in FCC you have enabled the header parameters, so the header parameters will take the precedence and after which the xml file data will come.

Pls let us know your requirement on sending four fields with constants from mapping so that we can think of a workaround.

iaki_vila
Active Contributor
0 Kudos

Hi Kamal,


The second line in the above pic is should be first line. and the first line should be second line.

Although it is not clear what is your inbound XML, have you thought to change in the mapping the order?. I want to mean this, if you have:

<root>

<a>

<a1>my first line, 1 field</a1>

<a2>my first line, 2 field</a2>

</a>

<b>

<b1>my second line, 1 field</b1>

<b2>my second line, 2 field</b2>

</b>

</root>

To map to:

<root>

<b>

<b1>my second line, 1 field</b1>

<b2>my second line, 2 field</b2>

</b>

<a>

<a1>my first line, 1 field</a1>

<a2>my first line, 2 field</a2>

</a>

</root>

Regards.

former_member186851
Active Contributor
0 Kudos

Hello Kamal,

Can you please mention more details.

Which line should be first and second is not clear.

raviteja_satuluri
Contributor
0 Kudos

Hi Raghu,

Thanks for your reply. In the out put file which is showing in the image,

The line which starts from Public is should be at first line and which starts from custom key is should be at second line.

remaining is same.

Regards,

Kamal.

former_member257758
Participant
0 Kudos

Hi Kamal,

Also these lines you are taking about are in single structure or multiple structures (header,line) or they are just field names or the value, because they are kind of confusing.

Pls answers below .

1. Has the output file has single structure?

2. Are you populating any header columns with custom field names?

Pls put the better output file example.

Thanks

Arun

former_member186851
Active Contributor
0 Kudos

Hello Kamal,

It depends on how your XML is formed. And your populating header line? that part is not clear.

Can you please post the XML as well.