File To File

[Former Member]

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"?>

<ns0:FILEINPUT xmlns:ns0="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.

[Former Member]

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..

[Former Member]

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...

[Former Member]

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.

[Former Member]

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.

[former_member181959]

Hi can you try this,

Document name : FILEINPUT

Document Namespace : http://text2xml.com

Document Offset : 1

<Recordset Name : RECORD>.....................................Remove

Recordset Structure : ROW,*

ROW.fieldNames : Name,Street,City

ROW.fieldSeparator : ,

ignoreRecordsetName: true

Let me know.

Hope this helps.

-Prasad Babu.

[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

[Former Member]

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>

[Former Member]

Raj,

It is <filename.txt> only.

And i have removed <ROW.processFieldNames : fromConfiguration>

but still it is not working.

Venkat

[prateek]

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

[Former Member]

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

[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

[Former Member]

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

[former_member184543]

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

[Former Member]

Sanjo,

If i place Xml file instead of txt file it is working fine.

Regards,

Venkat.

[former_member184543]

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