Skip to Content
author's profile photo Former Member
Former Member

File conversion Problem

Hi Experts,

we are facing a problem when converting one text file by using FTP adapter.

the flat txt file is as below

AT1230001

"AT" - Segment Name

"123" - Field One

"0001" - Field Two

we are using FTP Adapter conversion for the same

the result of XML is as below

- <AT>

<F1>AT</F1>

<F2>123</F2>

</AT>

for the field one it is taking the value of Segment Name, as we are giving KeyFieldValue in Configuration "AT".

please help, it is urgent,

Regards,

Study SAP

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2008 at 08:23 AM

    Hi,

    What is your problem.....I didnt understood what ur requirement is.

    Can you please eloborate it.

    Thnx

    Chirag

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2008 at 08:33 AM

    change the structure to the below and check with the fcc

    <row>

    <AT>

    <F1>AT</F1>

    <F2>123</F2>

    </AT>

    </row>

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2008 at 11:52 AM

    for this u dont need to use any key fld identification

    just have ur separators, fixed lengths mentioned in fcc. thats enough.

    also use this Recordsetstructurename.keyFieldInStructure----> ignore

    thanks

    kiran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2008 at 02:19 PM

    Hi,

    please try the following configuration in your Sender File Adapter:

    Documentname: AT

    Document Namespace: e.g. http://test

    Recordset Structure: Recordset,*

    Recordset Sequence: Ascending

    Recordsets per Message: *

    Key Field Name: Dummy

    Key Field Type: String

    Recordset.fieldNames: Dummy,F1,F2

    Recordset.fieldSeparator: *

    Recordset.keyFieldValue: AT

    Recordset.keyFieldInStructure: ignore

    ignoreRecordsetName: true

    The result should look like that:

    <?xml version="1.0" encoding="utf-8" ?>

    <ns:AT xmlns:ns="http://test">

    <Recordset>

    <F1>123</F1>

    <F2>0001</F2>

    </Recordset>

    </ns:AT>

    Best regards

    Lars

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.