File Content Conversion - Recordset Structure required??

[Former Member]

Hi,

I have a File Sender Communication Channel (CC) to convert very simple csv format to XI data type (XML).

The contect of csv file will look something like this and will always have one line per file.

111,222,333,444,555

And I have defined the Data Type/Message Type with 5 fields as follows:

Sender_DT

---F1

---F2

---F3

---F4

---F5

Assuming that I'll always get one line of data in a csv file, I don't really need to set Recordset Structure in Content Conversion Paramters of File Sender CC but it is required parameter so you can't save it without populating this parameter.

I understand that I can add a recordset to my DT so that it will look like below and type in Recordset in the Recordset Structure parameter but wanted to see if there is any other way to go around this without adding Recordset to DT.

Sender_DT

---Recordset

-

---

F1

-

---

F2

-

---

F3

-

---

F4

-

---

F5

Thanks,

Jay

[Former Member · Accepted solution]

in your content conversion , set ignoreRecordsetName = true and it will not be inserted into xml generated. No need to modify your data type...

check http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm for details.

[Former Member · Accepted solution]

Hi Amol,

I am aware of ignoreRecordsetName = true and have this parameter in the content conversion. But there is another parameter named "Recordset Structure" which is required and my question is related to this parameter.

Thanks,

Jay

[Former Member · Accepted solution]

Hi Jay,

You are correct. You can't have a struct like

DT_SOURCE

--F1

--F2

--F3

You need another node with in DT_SOURCE like recordset

DT_SOURCE

-Recordset

--F1

--F2

--F3

If you don't get multiple lines in source file, you can simpl set the Recordset occurance to 1..1 but it is mandatory.

Regards,

Jai Shankar

[former_member184619 · Accepted solution]

Hi Jung.

Now your question is more clear.

We can't have it without Recordset.

Check this link for detail information.

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

Sachin

[Former Member · Accepted solution]

Thank Jai for clear answer to my question.

Jay

[Former Member · Accepted solution]

Not a problem. Always welcome

Regards,

Jai Shankar

[former_member184619]

Hi Jung,

Check these Blog

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

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

Sachin