Output CSV file problem

[Former Member]

Hi Guru,

I encounted 1 problem where my output csv file content incorrect. Source is from SAP Proxy.

Example my csv file should have Material code, material description and date. However when i open the csv file, it is only have material code in one line and the rest of fields are not display in the csv file.

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

<ns0:MT_PRD_MASTER_SND xmlns:ns0="http://com.starhub/sapprdcat">

<RECORDSET> 1:1

<RECORD> 1:unbounded

<MATNR/>

<MAKTX/>

<DATE_ADD/>

</RECORD>

</RECORDSET>

</ns0:MT_PRD_MASTER_SND>

My source and target are same.

CC Receiver setting:

Transport Protocal : File System NFS

Message Protocal : File Content Conversion

Adapter Engine : Integration Server

Recordset Structure : RECORD

RECORD.fiedlNames : MATNR,MAKTX,DATE_ADD

RECORD.endSeparator : 'nl'

RECORD.fieldSeparator : ,

RECORD.processFieldNames: fromConfiguration

RECORD.addHeaderLine: 0

The INCORRECT result only display MATNR in one line only.

HNOK0000102 HNOK0000108 C032S31384A C032S3XDATA CFGSC300300 CRAWC300001

Expected Result should be :

HNOK0000102,Material test 1,01/01/2007

HNOK0000108,Material test 2,01/02/2007

C032S31384A,Material test 3,01/01/2007

C032S3XDATA,Material test 4,01/01/2007

CFGSC300300,Material test 5,01/01/2007

CRAWC300001,Material test 6,01/01/2007

Thank you very much for help.

Regards,

[former_member184619]

hi,

check this parameter:

Recordset Structure : RECORD [wrong]

Recordset Structure : RECORDSET,RECORD [right]

and the other parameters will be like this:

RECORD.fiedlNames : MATNR,MAKTX,DATE_ADD

RECORD.endSeparator : 'nl'

RECORD.fieldSeparator : ,

RECORD.processFieldNames: fromConfiguration

RECORD.addHeaderLine: 0

<b>RECORDSET.fieldSeparator: 'nl'</b>

Sachin

Message was edited by:

Sachin Dhingra

[prabhu_s2]

check this in CCP

Recordset Name      :RECORDSET
Recordset Structure : RECORD,*

Message was edited by:

Prabhu S

[Former Member]

Hi,

You have not mentioned about the xml tag <RECORDSET> in content conversion.

Shouldn't you have in the Recordset Structure :RECORDSET,RECORD followed by an additional parameter RECORDSET.filedNames :RECORD??!!!!!!

Not very sure about this......

[Former Member]

Hi Guru,

This is my typo mistake in the email. In my actual configuration, the spelling is correct.

Thanks and regards,

[Former Member]

Mr Lord Shadow,

Please check on the record structure , where the field name is spelled different. Change it on and move forward. Surely it will work..

RECORD.fiedlNames : MATNR,MAKTX,DATE_ADD [Wrong]

RECORD.fieldNames : MATNR,MAKTX,DATE_ADD [Right]

Regards

vinod v

[Former Member]

Hello Lord,

Check out the spelling of field, you typed it as fiedl.This should solve your problem.

Thanks,

Sudhir

[nikhil_bose]

hi,

in your code, you specified

 RECORD.fiedlNames : MATNR,MAKTX,DATE_ADD 

which is wrong, but that should arose a file adapter problem.

and make sure that there is no white spaces in between any parameters.

regards,

nikhilbose