cancel
Showing results for 
Search instead for 
Did you mean: 

FCC To File Scenario without a header node

0 Kudos

Hello everyone,

I am new to PI and am trying to do an FCC to File scenario.

This is my source structure:

  <xsd:complexType name="DT_Employee">

      <xsd:sequence>

         <xsd:element name="EmpID" type="xsd:string" />

         <xsd:element name="EmpName" type="xsd:string" />

         <xsd:element name="Department" type="xsd:string" />

         <xsd:element name="Region" type="xsd:string" />

      </xsd:sequence>

   </xsd:complexType>

My question is: What should I put in the Recordset structure field of the sender communication channel?

If my structure had a root node such as "Details", under which there were 4 fields, I could have specified the root node in the Recordset structure.

But since I do not have any such node, what should I specify?

As it's a mandatory field, I cannot leave the field blank.

Thank you in advance,

Megha Chatterjee

Accepted Solutions (1)

Accepted Solutions (1)

iaki_vila
Active Contributor
0 Kudos

Hi Megha,

If i understood right your scenario:


My question is: What should I put in the Recordset structure field of the sender communication channel?

For example: Details,*


If my structure had a root node such as "Details", under which there were 4 fields, I could have specified the root node in the Recordset structure.

But since I do not have any such node, what should I specify?

For example in content conversion parameter: Details.fieldNames     EmpID,EmpName,Deparatament, Region.

I hope these links could help you with the sender FCC:

File Content Conversion - Process Integration - SCN Wiki

http://www.riyaz.net/sap/xipi-file-content-conversion-for-simple-structure/75/

Regards.

Answers (1)

Answers (1)

maheswarareddykonda
Active Contributor
0 Kudos

Hi Megha,

since you are handling txt file , why dont you create such as below,

mt_test

   details

      field1

      field2

      field3

and you are handling txt file from source, its every thing is upto you , you can follow the structure as above to get file from source.

let me explain one more thing, whenever we are handling the records in txt file means that file would contains rows and columns,

rows means record structure and columns means fields. so while handling the text file we must follow the structure.

finally i can say while handling the txt files either source or target, everything creation of structure is upto our end ( i mean nobody ask you such a specific way)

i hope you got it

if you still confusing , better to post your example input txt file, so that some one can help you

thanks & Regards,

Maheswarareddy

0 Kudos

Thank you Maheswarareddy. I think it cannot be done with my existing structure. I will try changing my structure.