Problems with File Content Conversion

[Former Member]

Hy,

I still have a problem with the File Content Conversion. I don't get the adapter working. I am not sure if there is some wrong with the installation or if it is my fault.

Could someone please tell me the setting in the fileadapter for the following structure...

Interface

Input File

ValueA;ValueB

ValueA1;ValueB1

ValueA2;ValueB2

Thank you for your help

Thomas

[Former Member]

I think following File content conversion should work with your setting:

1. Message Protocol: File Content Conversion

2. Document Name: xmldocument

3. Document Namespace: <Name space from your Integration Designer that you are working with>

4. Recordset structure: root,*

5. Recordset Sequence: Ascending

6. Key Field type: String (Case-Insensitive)

7.

7.1: root.fieldNames: A,B

7.2: root.fieldSeperator: ,

7.3: ignoreRecordsetName: true

[Former Member]

I have a clarification!! If the File content conversion is not correct, I presume no messages in SXMB_MONI. Is there any place where the File content conversion error is logged in XI system?

[Former Member]

You can check it in MDT(message display tool)

Runtime workbench->Message monitoring->AdapterEngine

it will detail you all the log related to the Adapter engine messages.

It also throws error in adapterframework stating the error, like number of fields are more than required etc ..

For more details check MDT.

Cheers,

Satish

[Former Member]

Hi Thomas

Sender adapter parameter should be like this

Document Name:Message Type(which is in the xmldocument)

Recordset Name:root

Recordset Structure:root,*

Key Field Name:root

root.fieldNames:A,B

root.fieldSeparator: ;

Hope it helps

Regards

Arpit Seth

[Former Member]

Hi Thomas,

To generate the required file you need to do the following:

1) Choose File Content Conversion as your protocol

In the Content conversion Parameters:

As per the sample data, the root block may occur n number of times.

a) Give the document namespace as the name space of your scenario.

b)Mention the recordset name

c) In the parameter Recorset Structure, give:

root,*,A,1,B,1

d) In the KeyfieldName parameter, give root.

I have given the parameters keeping in view your sample data and XML structure.

In additional parameters, please give:

<b>root.fieldSeparator</b>: ;

<b>root.fieldNames</b>: A,B

These are the most important parameters.

You can also give other parameters as per your requirement.

I Hope this helps,

Thanks and Regards,

Varun Joshi

Message was edited by: Varun Joshi

Message was edited by: Varun Joshi

Message was edited by: Varun Joshi

[Former Member]

I tried the following settings for the sender adapter, but it doesn't work...

Document Name: xmldocument

Document Namespace: http://euh.com/TestCases

Document Offset:

Recordset Name: xmldocument

Recordset Namespace: http://euh.com/TestCases

Recordset Structure: row,*

Recordset Seqeuence: Ascending

Recordset per Message: *

Key Field Name: row

Key Field Type: String (Case-Sensitive)

row.fieldNames: A,B

row.fieldSeperator: ;

[Former Member]

HI Thomas

If ur input file is like this

ValueA;ValueB

ValueA1;ValueB1

ValueA2;ValueB2

than can plz tell wht data u r expecting when it is send from file adapter to XI.So that i can give u parameter to get ur output.

Regards

Arpit Seth

[former_member187339]

Hi Thomas,

Since both root and recordset's name are same, it might be a problem.Try changing your input file's Data type. For eg.

<Root>

<Recordset> (1..unbound)

<row>

<A></A>

<B></B>

</row>

</Recordset>

</Root>

You can have a look at the structure at

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

Regards

Suraj

[Former Member]

Hi Thomas,

Please upload the Content conversion parameters that your giving while configuring your Sender File Adapter.

Also send me accross the XML structure you wish to generate once the file is read into XI.

I am sure i'll be able to help you much more with the piece of infirmation mentioned above.

Thanks and Regards,

Varun Joshi

[Former Member]

hi Thomas

I have tried the file Content Conversion The struture is given below and i also give link that will helpful to u

<ns:FileConversionSender_MT xmlns:ns="urn://FileConversion">

<ContacatFile>

<Contact>

<FName>cxv</FName>

<LName>xvc</LName>

<CAddress>xcv</CAddress>

</Contact>

</ContacatFile>

</ns:FileConversionSender_MT>

Converting File Content in the Receiver Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Converting File Content in the Sender Adapter

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

[Former Member]

Hi,

You need to go check the file contenet conversion in

the message protocol.In the content conversion parameters:

docmnt name: (give message type)

docmnt namespace: (namespace)

recordset name :(xml root name)

recordset structure :(substructures and their no)

And you need to specify the field names and the field separators.

Hence for ur scenario:

recordset name :root

recordset structure :valueA,1,valueB,1

valueA.fieldNames -valueA1,valueB1.

valueB.fieldNames -valueA2,valueB2.

valueA.fieldSeparator - ,(giv any delimiter)

valueB.fieldSeparator - ,

valueA.endSeparator - ,

valueB.endSeparator - ,

Useful blogs:

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

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

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

Hope this has helped you

Regards,

Priyanka

[Former Member]

Hi Thomas,

https://www.sdn.sap.com/sdn/weblogs.sdn?blog=/pub/wlg/1779. [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken]

Hope this link will be useful to u.

Cheers,

Divya

[former_member187339]

Hi Thomas,

Check in the Adapter Framework whether the Adapter is working correctly or not. Also check whether Adapter status is set to <b>Active</b>.If not then make it Active and try again.

Regards

Suraj

[Former Member]

The adapter is working correctly, but when I switch to Content Conversion, the adapter does nothing. I checked the logfile of the ftp server, where I want to read the file from. Right up the moment I switch to Content Conversion, the Adapter doesn't even tries to connect to the ftp server. So the problem must be the content conversion settings.

Thomas