cancel
Showing results for 
Search instead for 
Did you mean: 

File Adapter picks up the file but cant see it in MONI/Message Monitoring

Former Member
0 Kudos

Hi

I am using FCC in Sender File Adapter and have only one sub structure under Recordset hence I have not used the 'Key Field Name' though ''Key Field Type' by default is 'String(Case-Sensitive)'. Besides the 'fieldNames' heading I have mentioned all the fields of the sub structure in the same order as I have mentioned in the Data Type.

The problem that I am facing is that even though the file is picked up from ftp successfully still I cant see any traces of it in either MONI or Message Monitoring though

The error that I receive in the MDT is -

Success : Entire file content converted to XML format

Warning : Empty document found. Proceed without sending message

Success : File "Test.csv" deleted after processing

and I have data in the file.

Can u suggest a solution?

Warm regards,

Vaibhav

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Either the file is empty or their is a problem with your content conversion parameters. Do you have a sample of what this file would look like and what Conversion paramters you are using?

Former Member
0 Kudos

Hi Yaghya

Following is the hierarchy of my data type

Recordset

Input_File

SortSequence

GRMaterialDocument

I need it in the following xml format

<Recordset>

- <Input_File>

<SortSequence>A</SortSequence>

<GRMaterialDocument>B</GRMaterialDocument>

</Input_File>

</Recordset>

And my file communication channel details are -

Recordset Name : Recordset

Recordset Structure : Input_File,*

Recordset Sequence : Ascending

Input_File.fieldNames : SortSequence,GRMaterialDocument

Input_File.fieldSeparator : ,

Input_File.lineSeparator : 'nl'

So I have filled my test excel file with the values A and B in adjacent columns

Former Member
0 Kudos

Hey

>>So I have filled my test excel file with the values A and B in adjacent columns

are you picking up some .xls file?if yes,then Content conversion wont work,You have to create adapter module processor and you have to add to your module processor bean to the adapter...Just check the following procedure...

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

Thanx

Aamir suhail

Former Member
0 Kudos

> Hey

> >>So I have filled my test excel file with the values

> A and B in adjacent columns

> are you picking up some .xls file?if yes,then Content

> conversion wont work,You have to create adapter

> module processor and you have to add to your module

> processor bean to the adapter...Just check the

> following procedure...

> https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/

> 1967

> Thanx

> Aamir suhail

Hi Aamir

I had a look at the blog and according to that I will need to create a module...the prob with that is in the blog he hasnt provided the full steps for that. Also I had tried this thing earlier of using an excel file and saving it in .csv format and it had worked. I cant figure out what the error is this time

Have u worked on creating amodule for excel files b4?

Vaibhav

Former Member
0 Kudos

And when i use a notepad file with extension .txt, it works!! but not with an excel file saved as an ext of .csv

Vaibhav

Former Member
0 Kudos

And I have not made use of the tab 'Advance Selection for Source Tab' in file adapter

Answers (3)

Answers (3)

Former Member
0 Kudos

Bhargava,

Your error says:

Success : Entire file content converted to XML format

<i><b>Warning : Empty document found. Proceed without sending message</b></i>

Success : File "Test.csv" deleted after processing

So please check the file has data in it or not?

Regards,

---Satish

former_member181959
Contributor
0 Kudos

Hi,

Did u check CC in monitoring? Make sure that everything is ok in Communication channel?

_Prasad Babu.

prateek
Active Contributor
0 Kudos

Make sure the file u r sending has data and it is not blank.

Also if u r on >= SP19,

http://help.sap.com/saphelp_nw2004s/helpdata/en/e3/94007075cae04f930cc4c034e411e1/content.htm

Regards,

Prateek

Former Member
0 Kudos

Hi Prasad and Prateek

the file is not empty and CC shows the 3 lines that I mentioned in my first post

Former Member
0 Kudos

Can you please copy-paste your source file data....

Former Member
0 Kudos

is the field separator , for an excel file

can u try with ; or 0x09