on 05-05-2005 12:03 PM
Hi all,
I am also trying the same scenario. In mapping test, i have taken the payload data and tested it. But the source structure is not being populated into target structure without any errors. Can u plz explain how u didit?
This is source xml instance:
<?xml version="1.0" standalone="yes" ?>
<resultset>
<row>
<field0>GNCHETTYROAD</field0>
<field1>T.NAGAR</field1>
<field2>10101980</field2>
<field3>CHENNAI</field3>
<field4>U3</field4>
<field5>HEXRAM</field5>
<field6>M</field6>
<field7>NANDURI</field7>
<field8>US</field8>
<field9>US04</field9>
<field10>0001</field10>
<field11>875945621</field11>
<field12>oh</field12>
<field13>44412</field13>
</row>
</resultset>
This is target instance after test execution:
<?xml version="1.0" encoding="UTF-8"?>
<ns0:ZHRONBOARD_ACCEPT xmlns:ns0="urn:sap-com:document:sap:rfc:functions">
<ADDRESS1 />
<BIRTHDATE />
<CITY />
<EMPLOYEESUBGROUP />
<FIRSTNAME />
<GENDER />
<LASTNAME />
<PAYROLLAREA />
<PERSONNELAREA />
<PERSONNELSUBAREA />
<SSN />
<STATE />
<ZIP />
</ns0:ZHRONBOARD_ACCEPT>
Can any one plz tell me where am doing mistake???
Are there any patches for sap xi 2.0 file adapter??
Rgds
Ramsri
Hi Ram,
It seems like your in your Graphic Mapping Editor you are not mapping the Source Target Field to the Destination Target Field. What I mean is if the cardinality is 1:1 then what you might want to do is drag or double click your root node from the Source Target Field and drag or double click your root node from the Destination Target Field. Once you have done this then connect the two to each other in your Data-Flow Editor.
Its like how you link the subordinate fields to each other to make the mapping work, you have to do the same thing for the parent node. I am not if what I said makes any sense or I confused you further. Please let me know if you don't understand.
Thanks,
Adnan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ram ,
It seems that you are not giving field names in file adapter and thats why source structure has name field1,2..... What you need to do is in file adapter define the fieldNames ( all the name of source data type)attribute with all the fields and source will have these name and finally your mapping we will work ..
Thanx & regards
Vinod Ahir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vinod,
Thanks for your reply. Here is my file adapter configurtion. I am working on sap xi 2.0.
classname=com.sap.aii.messaging.adapter.ModuleFile2XMB
mode=FILE2XMB
#mode = file2xmbwithrowconversion
Integration Engine address and document settings (example, see docu)
XMB.TargetURL=http://ht56f4:8000/sap/xi/engine/?type=entry
#XMB.SLDConfiguration = SLDaccessor7
XMB.User = xiappluser
XMB.Password = xipass
XMB.SenderBusinessSystem = Intromoto_bus
XMB.SenderInterfaceNamespace = http://inttest.com
XMB.SenderInterfaceName = zminterface
#XMB.SenderBusinessSystem=ExtAdapterSender
#XMB.SenderInterfaceNamespace=http://sap.com/xi/xidemo
#XMB.SenderInterfaceName=ExtAdapterSenderIF
XMB.ContentKind=T
#XMB.ContentKind=T
#XMB.ContentType=application/xml
#XMB.ContentType=text/xml
XMB.ContentType=text/plain
XMB.QualityOfService=EO
#ftp server details
ftp.host = 102.52.12.17
ftp.port = 21
ftp.user = heass
ftp.password = a****a
ftp.connection = permanently
ftp.mode = Text
#file.sourceFilename = bank.txt
##File Adapter specific parameters (example, see docu)
file.sourceDir= \/test\/
file.sourceFilename = satya3.txt
#file.processingMode=setAttribute
#file.processingMode=archive
#file.archiveDir=c:/temp_archive
file.pollInterval= 60
file.pollIntervalMsecs= 10
#file.retryInterval = 30
file.logPollInterval=YES
file.processingMode=delete
##xml conversion properties if mode FILE2XMBWITHROWCONVERSION specified (example, see docu)
#xml.fieldFixedLengths=8,9,2
xml.processFieldNames=from configuration
xml.fieldNames=Address1,Address2,DateOfBirth,City,Personal Subarea,LastName,Gender,FirstName,PersonalArea,PayrollArea,SSN,State,zip
xml.fieldSeparator=,
xml.enclosureConversione = YES
Can u plz inform where i am doing mistake??
Rgds,
Ram Sri
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.