Multiline file content conversion-- error

[Former Member]

Hi All

I am sending a txt file to CSV format (txt file), I have done IR and ID without errors. Adaptor Monitor shows that

Initialization error: Conversion initialization failed with java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found:

Parameter '.fieldFixedLengths' or '.fieldSeparator' is missing

I have given '.fieldFixedLengths' or '.fieldSeparator' in the Content conversion parameters in the receiver dommunication channel.

Could you please let me know what could be wrong?

Thanks,

Ram

[Former Member · Accepted solution]

You need to give *.fieldSeparator' which will be a comma(,) for your scenario.

'*' will be replaced by your substructure name.(eg : header.fieldSeparator)

*.fieldFixedLengths' is used in cases of fixed length flat files.

If you can give us the structure of your incoming file, we could help you out in giving the parameters.

Regrards

Priyanka

[bhavesh_kantilal]

Hi,

If you can give the Source File format, the Source Datatype and the content conversion paramerters, a better reason for the problem can be found,

Regards

Bhavesh

[Former Member]

Thanks Krishnamoorthy, Bhavesh, Priyanka for your reply

The Problem is the file is picked up from the source but not reaches the destination

<u><b>Sender Communication Channel Details:</b></u>

Source File format----test.txt (Notepad)

<b>Source Datatype:</b>

FILEINPUT

Record

Row

FirstName

LastName

MiddleName

City

Place

State

Country

<b>Content conversion paramerters:</b>

Row.fieldNames---FirstName,LastName,MiddleName,City,Place,State,Country

Row.fieldSeparator---,

Row.endSeparator---'nl'

Transport Protocol---NFS

Message Protocol---File Content Conversion

-

---

<u><b>Receiver Communication Channel Details:</b></u>

Target File format----Test.txt

<b>Target Datatype:</b>

FOUTPUT_TEST

Record

Row

FirstName

LastName

MiddleName

City

Place

State

Country

<b>Content conversion paramerters:</b>

Row.addHeaderLine-----0(zero)

Row.fieldSeparator------,(comma)

Record.fieldSeparator-----'nl'

Row.endSeparator-----'nl'

Transport Protocol---NFS

Message Protocol---File Content Conversion

I am sending a text file and I want to receive it as a text file.

In both, Sender communication channel and Receiver communication channel I am using file content conversion.

Thanks

Ram

[moorthy]

Hi,

Just try out like this,

Row.fieldSeparator------,(comma)

Row.endSeparator-----'nl'

Hope this helps,

Regards,

moorthy

[Former Member]

Hi there,

I am in the same situation commented here BUT my incoming file is not separated by commas (no separation between fields) and my FCC parameters are only referring to ROW (not Record as it is said in the last response).

Could you guys please explain how this error got solved??

Best regards,

david

[moorthy]

Hi,

Are you getting this error in the Sender Side or Receiver Side?

anyway the error tells me that, content conversion paramater is incorrect.

For Sender Side-

http://help.sap.com/saphelp_nw2004s/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

If it is a Reciever Side , what is the xml structure ? If it is a CSV file, u need to use only fieldSeparator .. so check out this. Also check the spelling with segments used in the Data type ..

I assume that, you are getting error in the Receiver side as per your last line.. So what is your target structure and how do you want the output

Hope this helspm,

Regards,

Moorthy