XI - Document Content Transformation By Punit J, YASH PI Proficiency Group, Yash Systems Description: File Content Conversion is utilized to transform non-XML file (smooth file) tó XML file ánd vice-versa. ln this blog site, we will see how to transform smooth file tó XML file whén file framework is bit complicated. For example, when exact same columns shows different info in various rows. Company Case: Allow's take an illustration with file demonstrated below. The file consists of employee information. First line includes Header info of Worker (Worker Identity and Title), 2nd and Third row contains his weekly information (Week No, Functioning Hours in the 7 days and Income for the Week), there can end up being n amount of rows for weekly information and Last row consists of Employee Month to month Overview (Overall hours worked well and Total Wage).

Screen photo Discover below the stép-by-step process to accomplish this scenario: Growth on Incorporation Repository part. Create Data Type. Right here I have included a filed Essential in all the information, we will discuss about this industry while configuring Sender Document Adapter. Create Message Kind.

3) Create Message Interface for Sender and Recipient. In this situation I was using exact same Message Type for both Sénder and Receiver ás we are converting toned file tó XML file. 4) Create Message Mapping. Right here we put on't possess to map the field ‘Essential'. Create User interface Mapping.

Dear SAP Community Member, In order to fully benefit. Message Protocol: File content conversion specify the source directory and the file. File Content Conversion In Sap Pi. In this article we will understand the concept of File Content Conversion. Salesforce.com Integration Using SAP PI. I'm reading a flat file using receiver file adapter in PI 7.5, and then converting it to xml using FCC. However, I need to save the file name to an element of the resulting XML after conversion, to later pass that value to a RFC. File Content Conversion helps in converting the file formats to/from XML. We have discussed the simple File Adapter Configuration earlier. In this article we will understand the concept of File Content Conversion using an.

Make sure you deliver us your comments/suggestions at. © 2006-2007 SAPTechnical.COM. All rights reserved. All product names are usually trademarks of their particular businesses.

SAPTechnical.COM is usually in no way affiliated with SAP AG. SAP, SAP Ur/3, R/3 software, mySAP, ABAP, BAPl, xApps, SAP NétWeaver, and and ány some other SAP art logos are signed up trademarks of SAP AG in Germany and in many other nations. Every work is produced to guarantee content integrity. Use info on this web site at your very own risk. Graphic Design.

Alice in wonderland movie 2010 full movie free. Name Value Header.keyFieldValue H Product.keyFieldValue I Header.fieldFixedLengths 1,3,3 Product.fieldFixedLengths 1,3,3 Header.fieldNames essential1,RecordID,PlantName Item.fieldNames key2,MaterialID,Quantity Header.endSeparator 'nl' Product.endSeparator 'nl' ignoreRecordSet genuine Sender Communication approach FILETOFILERECEIVERCC. Indicate the sticking with in the sénder cc.

Adapter Kind: Document Transport Protocol: FILE SYSTEM(NFS) Message Protocol: File content conversion Adapter Motor: Integration Machine Specify the focus on index and the file name and file construction mode: include time stamp. Content Transformation Variables: Report Structure: Header,Product. Name Worth Header.beginSeparator Header Product.beginSeparator Product Header.fieldFixedLengths 10 Product.fieldFixedLengths 10 Header.endSeparator 'nl' Item.endSeparator 'nl' Produce a fresh sender agreement and state the outbound interface, service and sender communication channel.

Create a new Receiver dedication and indicate the receiver support and interface. Create a brand-new Interface determination and identify the title of the User interface mapping. Create a brand-new Receiver contract and identify the receiver conversation channel. Take note: After each phase save and trigger it.

Some period we need to add the text line in the File content conversion. Allow's notice the structure scenario. Consider the above txt file is usually the source file of xi.

Now we fill up the File content Transformation parameter like as Document title, Namespace, record set Framework, Key field name. Now we need to stipulate the FCC guidelines. HeaderRecord.fieldSeparator:, HéaderRecord.fieldNames: RecordType,Senderld,RecipientId,Dateofpreparation,Timéofpreparation, UniqueReferencenumber,FileType HéaderRecord.keyFieldValue: 'H' HeaderRecord.enclosureSign: ' HeaderRecord.enclosureSignEnd: ' Same like identify the Fine detail and TrailerRecord fields. Result: If you notice the outcome the text line consists of field separator.But the whole line moved in a one industry with the help of enclosureSign,enclosureSignEnd parameter.