File Content Conversion in Sender File Adapter

[Former Member]

Hi,

I am implementing a scenario, where I need to do Content conversion in My file Adapter.My input file is as follows

BGN00S-A200711281003ET4

REF38381012

DTP007D820071128

N1P5P5MicrosoftFI58-0612397

INSY18030XNAN

REFZZZZ666666666

DTP336D819970331

NM1ILIL1AdamsMarkE34666666666

PERIPIPHP770555-5555

N31470 Georgia Club Drive

N4StathamGA30666

DMGD819571022MM7

HD030HLTAE1D

My data type is as below.

<header>

<BGN>

<A></A>

<B></B>

<C></C>

<D></D>

</BGN>

<REF>

<A1></A1>

<B1></B1>

<C1></C1>

<D1></D1>

</REF>

<DTP>

<A2></A2>

<B2></B2>

<C2></C2>

<D2></D2>

</DTP>

</header>

<Content>

<N1>

<A></A>

<B></B>

<C></C>

<D></D>

</N1>

<REFAR>

<A1></A1>

<B1></B1>

<C1></C1>

<D1></D1>

</REFAR>

<DMP>

<A2></A2>

<B2></B2>

<C2></C2>

<D2></D2>

</DMP>

</Content>

My issue is, How do I set my parameter in Sender Comm channel for content conversion especially at record structure.

I have provided the value as Header,1,Content,*

But its not working.

If I do provide like

BGN_REC,,REF_REC,,DTP_REC,,N1_REC,,INS_REC,,NM1_REC,,PER_REC,,N3_REC,,N4_REC,,DMG_REC,,HD_REC,* then ,I am not getting above XML format. Please suggest or How can I modify my Data type which competes to configure in Channel

Thanks

Manmadha

[nikhil_bose]

hi manmadha,

in the FCC, give the structure name (root element)

in FCC parameters

add

<b> <str_name>.fieldNames : at Values(add the fields/tags that you want

exactly in order)</b>

<b> <str_name>.fieldSeparator : leave a whitespace

<str_name>.endSeparator : 'nl' <i> </b>// end Line</i>

<i> it will be easier if the fields are seperated by commas, anyway you try

this and get me status</i>

<b> Check your File Adapter error: RWB->>ComponenetMoni->>Adapters

read the Adapter Configuration

http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1

/content.htm

regards,

nikhilbos.

<i>**reward if helpful

[Former Member]

HI,

refer the below weblog:

File Content Conversion for Multi Hierarchical Structure

/people/karthiknarayan.kesavan2/blog/2007/08/22/file-content-conversion-for-multi-hierarchical-structure

Thnx

Chirag Gohil

[Former Member]

HI Manmadha,

If i am not wrong your input file is

BGN00S-A200711281003ET4 REF38381012 DTP007D820071128 N1P5P5MicrosoftFI58-0612397 INSY18030XNAN REFZZZZ666666666 DTP336D819970331 NM1ILIL1AdamsMarkE34666666666 PERIPIPHP770555-5555 N31470 Georgia Club Drive N4StathamGA30666 DMGD819571022MM7 HD030HLTAE1D .

1. Kindly let me know the scenario type ? Is it a file to file scenario..?

2. File you are getting is fixed length or CSV ?

3. file adapter has capabilities to work on both sirttuations, justyou need to play around adapter..no need of Module Pool Prog..?

Kindly come up with the answers of my questions

Regards,

[former_member184619]

Hi manmadha,

Check this blog...

How to send a flat file with various field lengths and variable substructures to XI 3.0

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

Sachin

[Former Member]

Hi All,

I am sorry for the Jumbled Content. I dont know what happened.

I should get the XML output as below.

header>
	<BGN>
		<A></A>
		<B></B>
		<C></C>
		<D></D>
	</BGN>
	<REF>
		<A1></A1>
		<B1></B1>
		<C1></C1>
		<D1></D1>
	</REF>
	<DTP>
		<A2></A2>
		<B2></B2>
		<C2></C2>
		<D2></D2>
	</DTP>
</header>
<Content>
	<N1>
		<A></A>
		<B></B>
		<C></C>
		<D></D>
	</N1>
	<REFAR>
		<A1></A1>
		<B1></B1>
		<C1></C1>
		<D1></D1>
	</REFAR>
	<DMP>
		<A2></A2>
		<B2></B2>
		<C2></C2>
		<D2></D2>
	</DMP>
</Content>

[Former Member]

Any Idea Please........

Thanks

Manmadha

[Former Member]

Do I need to write a module program to parse the complete text document into XML? or Is there any other way to configure?

Any body come across this kind of situation.

Thanks

Manmadha