File Content Conversion Problem

[Former Member]

Hi

I have a flat file having 10 fileds with fixed length of field 7 characters

abc bcd dce cef ecf fgi

123 234 343 233 434 343

322 222 222 222 222 222

+++++++++++++++++++++++++++++++

XML CODE FOLLOWS

+++++++++++++++++++++++++++++++

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_send xmlns:ns0="http://OTO-Continue.com">

-<SEND>

<abc>343</abc>

<bcd>343</bcd>

<dce>434</dce>

<cef>3434</cef>

<ecf>343</ecf>

<fgi>434</fgi>

</SEND>

</ns0:MT_send

As per the client req I'm going with FCC. The file is picking fine with the FILE. But not picking with the FCC.

The parameters which I gave are as follows.

SOURCE I feel it is fine since file is picking fine and keeping the same for FCC also.

PROCESSING

QOS -- Exactly Once

Poll Interval -- 10

Processing Mode -- Delete

Empty-File Handling -- Process empty files

CONTENT CONVERSION Parameters

Document Name -- (am giving sender data type name) DT_send

Document NSpace -- http://OTO-Continue.com

Recordset Name -- SEND

Recordset Structure -- SEND,*

Recordset Sequence -- Ascending

Recordset per Message -- 0

And in the table the parameters am settings are

SEND.fieldNames abc,bcd,cde,def,efg,ghk

SEND.fieldFixedLengths 7,7,7,7,7,7 (because each and every field has 7 characters)

SEND.keepIncompleteFields No

SEND.fieldFixedLengthType char

SEND.fieldContentFormatting trim

SEND.fieldEndSeparator 'nl'

This was the configuration. But this is not working I monitored the Communication Channel and file is not reading and not getting deleting.

What actually went wrong in above configuration. Why it is not working.

Thanks.

[Former Member · Accepted solution]

Hi Swarna,

I observed few things wihch you may need to change and give a try:

> Document Name -- (am giving sender data type name) DT_send

Try to cahnge with message type sender.

> SEND.fieldNames abc,bcd,cde,def,efg,ghk

But your sample file has: abc bcd dce cef ecf fgi (I hope its a typo, else your field names should exactly match)

> Recordset per Message -- 0

Remove this and dont put any number here

> SEND.fieldEndSeparator 'nl'

It should be SEND.EndSeparator 'nl'

> Also your input file is 123 234 343 233 434 343

I dont see the input length is 7 for each field. If you say the length is 7 then you should have 4 spaces after each of this values. Hope you have all tihs.

Try to cahnge this and let us know.

Regards,

---Satish

[Former Member]

Great.

[Former Member]

Do not specify anything in Recordset Name

Use ignoreRecordsetName = true in content conversion parameters

Also specify SEND.endSeparator = 'nl'

[Former Member]

Hi,

well, i think that in Document Name you can ommit value.

In RecordSetName (as your example, is tha name of message type) ---> MT_send

in the rest as Satish said....we suppose that the values are figgerent and have a 7 characters of length.

Regards,

lpbuff

[Former Member]

Hi All,

Still got stuck with this.

According to the XML source what are parameters. All the way I have changed the parameters still Content Conversion do not work.

PROCESSING

QOS -- Exactly Once

Poll Interval -- 10

Processing Mode -- Delete

Empty-File Handling -- Process empty files

CONTENT CONVERSION Parameters

Document Name -- ?

DocumentNSpace -- ?

Recordset Name -- ?

Recordset Structure -- ?

Recordset Sequence -- Ascending

Recordset per Message -- ?

And in the table the parameters am settings are

SEND.fieldNames abc,bcd,cde,def,efg,ghk

SEND.fieldFixedLengths 7,7,7,7,7,7 (because each and every field has 7 characters)

SEND.fieldFixedLengthType char

SEND.fieldContentFormatting trim

SEND.fieldEndSeparator 'nl'

Thanks.

[prasannakrishna_mynam]

Hi Swarna,

CONTENT CONVERSION Parameters
Document Name -- ?
DocumentNSpace -- ?
Recordset Name -- ?
Recordset Structure -- ?
Recordset Sequence -- Ascending
Recordset per Message -- ?

Document Name - <Message Type> eg:- (MT_ABC)

DocumentNSpace - Name space of your MT

Recordset Name - The root node( Which has one occurence)

Recordset Structure - The parent node of the fields(can have multiple occurences)

Recordset Sequence -- Ascending

Recordset per Message -- 1/* (No.of records per each record set)

In your structure

+++++++++++++++++++++++++++++++
XML CODE FOLLOWS
+++++++++++++++++++++++++++++++
<?xml version="1.0" encoding="UTF-8" ?> 
- <ns0:MT_send xmlns:ns0="http://OTO-Continue.com">
-<SEND>
<abc>343</abc> 
<bcd>343</bcd> 
<dce>434</dce> 
<cef>3434</cef> 
<ecf>343</ecf> 
<fgi>434</fgi> 
</SEND>
</ns0:MT_send

There is no root node, so in your FCC you need to mention your RecordsetName and you can ignoreRecordSetName in result structure. Check the following blog simulates your requirement.

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

Regards,

Prasanna

[Former Member]

Swarna,

When you go with field fixed lengths no need to give

field separator, you should specify line separator.

You also added some more args, which are not needed.

Check those and try it.