File Content Conversion In Sap Pi At Receiver

Posted on
  1. File Content Conversion In Sap Pi At Receiver

XI - File Content Conversion By Punit J, YASH PI Competency Team, Yash Technologies Description: File Content Conversion is used to convert non-XML file (flat file) to XML file and vice-versa. In this blog, we will see how to convert flat file to XML file when file structure is bit complex. For example, when same columns shows different information in different rows.

What is sap pi 7.0

Name Value Header.keyFieldValue L Product.keyFieldValue I Header.fieldFixedLengths 1,3,3 Item.fieldFixedLengths 1,3,3 Header.fieldNames essential1,RecordID,PlantName Item.fieldNames key2,MaterialID,Volume Header.endSeparator 'nl' Product.endSeparator 'nl' ignoreRecordSet real Sender Conversation funnel FILETOFILERECEIVERCC. Identify the sticking with in the sénder cc. Adapter Kind: FILE Transport Protocol: FILE SYSTEM(NFS) Information Protocol: Document content conversion Adapter Motor: Incorporation Machine Specify the focus on index and the file title and file construction mode: include time stamp. Content Conversion Guidelines: Report Structure: Header,Product. Name Worth Header.beginSeparator Header Item.beginSeparator Item Header.fieldFixedLengths 10 Product.fieldFixedLengths 10 Header.endSeparator 'nl' Item.endSeparator 'nl' Produce a new sender contract and specify the outbound interface, assistance and sender communication station. Create a fresh Receiver determination and state the receiver service and user interface.

File Content Conversion In Sap Pi At Receiver

Create a new Interface perseverance and stipulate the title of the Interface mapping. Create a new Receiver agreement and specify the receiver communication channel. Take note: After each action save and power up it. Some period we need to include the text message line in the File content conversion. Let's see the trial scenario. Think about the above txt file is usually the resource file of xi.

Right now we fill up the File content Conversion parameter such as Record name, Namespace, report set Framework, Key field name. Today we require to designate the FCC variables. HeaderRecord.fieldSeparator:, HéaderRecord.fieldNames: RecordType,Senderld,RecipientId,Dateofpreparation,Timéofpreparation, UniqueReferencenumber,FileType HéaderRecord.keyFieldValue: 'H' HeaderRecord.enclosureSign: ' HeaderRecord.enclosureSignEnd: ' Exact same like state the Fine detail and TrailerRecord fields. Result: If you see the result the text line includes field separator.But the whole line moved in a single industry with the assist of enclosureSign,enclosureSignEnd parameter.

  1. File Content Conversion Scenario. Input Message: This is the input message to the receiver file adapter sent from XI. Input XML message. Output Message: Fig3. Output CSV Message. Steps: XI sends a XML message as input to the receiver adapter.Now this XML needs to be converted to a File in CSV format, i.e. It may be a comma separated, tab separated etc. To generate the required output, the data type at the receiver’s side plays a crucial rule.
  2. In this article we will understand the concept of File Content Conversion using an example of comma separated text file as source. File Content Conversion helps in converting the file formats to/from XML. We need to simply define the structure of the source or target file so that the adapter can accordingly convert it to/from XML.