on 09-18-2007 2:03 PM
Hello,
I need to convert file content in File Receiver Adapter.
In my opinion, i have unexpected XML format of a payload message. (At least, the format does not contain a structure element):
That is,
I have the XML message:
<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_BW ID="123" BirthDay="20/03/1969" Title="consultant" Name="John" LastName="Smith" xmlns:ns0="http://sap.com/xi/BASIS"/>
I need to convert it into plane text format with fieldseparator.
How to convert this xml message into plane text format if it does not contain any structure elements (that is, <struc1> <field1>value</field1> </struc1>) according to help guide?
How should i configure RecordSet in File Adapter?
I am confused.
Thank you
Igor,
Are u getting the format from the source?
<ns0:MT_BW ID="123" BirthDay="20/03/1969" Title="consultant" Name="John" LastName="Smith" xmlns:ns0="http://sap.com/xi/BASIS"/>
If yes, then create one more data type with structure
<Record>
<ID/>
<BirthDay/>
<Title/>
<Name/>
<LastName/>
</Record>
And do direct mapping. So now you can easily configure the content conversion for the target format isn't it?
Its my thought, I don't know whether its feasible for you or not..
raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks to all !
Yes, indeed. I was to fulfill a correct procedure of creating inbound message type.
My mistake was uncorrected type for "type" field of main data type name . This field was defined as xsd:string and i cannot create "Subelement" for main data type (it was grey). This field should be blank and then i could create correct structure.
Hi,
Where are you getting XML source message from?
As Raj pointed out, it looks like a mapping problem and not content conversion problem. Since you need to perform content conversion on receiver side, try to get appropriate structure as output of mapping. That should ease the content conversion task automatically.
Bhavish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.