Skip to Content
avatar image
Former Member

File To File

Hi All,

My scenario is Text file to Xml file.

My file Outbound message type xml looks like below :

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

http://text2xml.com">

<RECORD>

<ROW>

<Name>Abc</Name>

<Street>Def</Street>

<City>Ghi</City>

</ROW>

</RECORD>

</ns0:FILEINPUT>

At sender file adapter, message protocol is given as file content conversion and i have given the content conversion parameters correctly like below:

Document name : FILEINPUT

Document Namespace : http://text2xml.com

Document Offset : 1

Recordset Name : RECORD

Recordset Structure : ROW,*

ROW.fieldNames : Name,Street,City

ROW.fieldSeparator : ,

ROW.processFieldNames : fromConfiguration

and i have placed the file in appropriate location, but my file is not picked from the source directory.

My source file data looks like below :

Abc,Def,Ghi

Can any body help me in solving this issue. Kindly provide the solution. Can any body suggest me what might be the problem.

Regards,

Venkat.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • avatar image
    Former Member
    Aug 03, 2007 at 11:30 AM

    hi venkat..

    pls check for the dt structure ..else pls mention here how did you designed the dt structure..let me know. your structure wise from element to subelement

    regards

    praveen..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 02, 2007 at 10:34 AM

    try with this

    /people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

    http://help.sap.com/saphelp_nw04/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/frameset.htm

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 02, 2007 at 10:30 AM

    Put the data is xml format and check it out..

    The xml file lll be converted using FCC to the type of format u ahve specified..

    Thanks

    Sanjo

    Add comment
    10|10000 characters needed characters exceeded

    • hi,

      I got your point.. Actually you are trying to do an FCC on a txt file containing data. There are not XML tags and thats why the FCC wont work.. If it was an XML file and FCC is used then it will work as it is in your case..

      But again your scenario is a txt file to XML.. so no need of FCC at all. it would have been required it is the other way around..

      Thanks

      Sanjo

  • avatar image
    Former Member
    Aug 02, 2007 at 10:36 AM

    Hello Venkat,

    You are Saying it is a Text to XML scenario,But you are sending XML file ?

    as you are sending XML file what is the use of Using FCC in Sender Adapter.

    In my view there is no need.

    If you want to use FCC in Sender ,then give any CSV File.

    With Regards,

    Raju.

    ********please Reward with points if found useful

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Raju,

      The reason for sending XML file is, whehter the inputs which i have provided for Document Name, Document Namespace,Document Offset, Recordset Name, Recordset Structure are correct or not. U people are not aware of my data type so u can go thru the xml file and understand the structure. I think now it is clear . My scenario is text file to xml file and i am placing the txt file in the location, but it is not picking.

      Regards,

      Venkat

  • avatar image
    Former Member
    Aug 02, 2007 at 11:13 AM

    Document name : FILEINPUT

    Document Namespace : http://text2xml.com

    Document Offset : 1

    Recordset Name : RECORD

    Recordset Structure : ROW,*

    ROW.fieldNames : Name,Street,City

    ROW.fieldSeparator : ,

    ROW.endSeparator: 'nl'

    <ROW.processFieldNames : fromConfiguration> -> <b>Remove</b>....

    JUZ once once in the sender file adapter configuration check the file name mentioned.

    It has to be <filename.<b>TXT</b>>

    <b>Cheers,

    *RAJ*</b>

    Add comment
    10|10000 characters needed characters exceeded

    • Picking up of file does not depend upon ur extension and FCC params..

      It depends upon ur sender agreement. Check for the following

      1. Error in RWB -> ur communication channel

      2. Processing mode

      3. Filename along woth the directory name

      4. Ur FTP server is in working condition

      Regards,

      Prateek

  • avatar image
    Former Member
    Aug 03, 2007 at 08:51 AM

    Hi All,

    When i use message protocol as file and when i place the xml file in appropriate location it is picking the file and sending it to correct destination. But when i take message protocol as File Content conversion and provide the follwoing information in contnet conversion paratmeters :

    Document name : FILEINPUT

    Document Namespace : http://text2xml.com

    Document Offset : 1

    Recordset Name : RECORD

    Recordset Structure : ROW,*

    ROW.fieldNames : Name,Street,City

    ROW.fieldSeparator : ,

    Then in this case i am getting the following error when i check in RWB.

    And the record in my text file look like below:

    Name1,Street1,City

    Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Format error in 'xml.recordset' argument: incomplete structure (name,number) pair

    Can any body suggest me what is the problem by looking at error message. What i have do in order to resolve the issue.

    I think the information i have provided is sufficient to understand the issue.

    Regards,

    Venkat.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Prasad,

      I have given the properties which u have specified in reply now i am getting different :

      Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Mandatory parameter 'ROW.fieldNames': no value found

      ROW.fieldNames : Name,Street,City iam providing this but it is saying no value found. Whether it the problem with the data which iam providng in text file or what. I am confused.

      In text file the the records looks like below:

      Name1,Street1,City1

      Please correct me if my text file is wrong.

      Regards,

      Venkat

  • avatar image
    Former Member
    Aug 03, 2007 at 09:22 AM

    Hi Venkat,

    try using

    Document name : FILEINPUT

    Document Namespace : http://text2xml.com

    Recordset Name : RECORD

    Recordset Structure : ROW,*

    ROW.fieldNames : Name,Street,City

    ROW.fieldSeparator : ,

    ROW.endSeparator : 'nl'

    ignoreRecordsetName = 'true'

    Thanks,

    Maheshwari.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 03, 2007 at 11:19 AM

    hi,

    give the following input for ur FCC:

    Document name:ur message type name(i.e FILEINPUT)

    Document namespace : http://text2xml.com

    Recordset Name : RECORD

    Recordset Structure : ROW,*

    And in the table give the below details alone...

    ROW.fieldNames : Name,Street,City

    ROW.fieldSeparator : ,

    ROW.endSeparator : 'nl'

    definitely it ill work....

    ur source file shoulld be...

    efe,ssdf,efef

    egh,fgf,fghf

    hope this helpful...

    Add comment
    10|10000 characters needed characters exceeded