FCC Issue - fields getting omitted

[Former Member]

Dear experts,

In my file to jdbc scenario, I am doing an NFS and picking up a tab-delimited file . The file has 38 fields. But it has been noticed that when the adapter picks it up some data is being omitted.

For eg, here is a sample:

Consider the column names are:

Number, Code, Desc,Fname, Lname, Title, Nickname, FunctCode,Email,Phone

If the actual data in the file is:

001, acd123,prodqt,George,Smith,Mr., Gsmith,mgr,gsmith@m,+643456789

After PI picks it up and after FCC; it looks like below:

<Number>001</Number>

<Code>acd123</Code>

<Desc>Gsmith</Desc>

<Fname>mgr</Fname>

<Lname>643456789</Lname>+

<Title>Null</Title>

<Nickname>Null</Nickname>

<FunctCode>Null</FunctCode>

<Email>Null</Email>

<Phone>Null</Phone>

If you notice, the Fname, Lname,Title and Email data are omitted. Same happens to rest of the records. I cannot figure out what is wrong.

There are no header or trailer records in the file, only detail record which can have many rows.

My FCC details are as below:

ignoreRecordsetName = false

Detail.endSeparator = 'nl'

Detail.fieldSeparator =

Detail.lastFieldsOptional = yes

Detail.fieldNames=<field names>

Please help...

Thank you

[apu_das2]

Hi,

This should work for you without any issue. Check once -

Detail.fieldSeparator = '0x09'

Detail.endSeparator = 'nl'

Thanks,

Apu

[former_member581827]

Hi,

Can you try removing the option lastFieldsOptional.

also try giving filedFixedLenths and FieldNames as well.

Regards,

Chandra.

[former_member581827]

Hi,

Can you try some thing like this

Detail.fieldFixedLengths

Detail.fixedLengthTooShortHandling as Cut

Regards,

Chandra.

[former_member187339]

Hi,

Give Detail.fieldSeparator = ','

Regards

Suraj

[Former Member]

Suraj, I had mentioned the file is tab delimited. So field separator I have given is "<tab>" or " "

[former_member187339]

Hi,

Then why your input file is having vaues separated by comma??

can you past the actual input that you are getting?

Also if File adapter is unable to understand you fieldSeparator as TAB, then you can try this.

Open a notepad. Put a tab (by pressing tab key), copy it and paste it in the File adapter. and retest your interface.

Regards

Suraj

[Former Member]

Suraj, I gave a sample with comma, since tab did not work here while posting the question.

I have edited it now...

[former_member187339]

Hi,

Did you tried the notepad approach

So your fieldSeparator will be

Details.fiedlSeparator =  (ie space without quotes, but make sure you copy from notepad)

Regards

Suraj

[Former Member]

Dear experts,

In my file to jdbc scenario, I am doing an NFS and picking up a tab-delimited file . The file has 38 fields. But it has been noticed that when the adapter picks it up some data is being omitted.

For eg, here is a sample:

Consider the column names are:

Number	Code	Desc	Fname	Lname	Title	Nickname	FunctCode	Email	Phone

If the actual data in the file is:

001	acd123	prodqt	George	Smith	Mr.	Gsmith	mgr	gsmith@mail	+643456789

After PI picks it up and after FCC; it looks like below:

<Number>001</Number>

<Code>acd123</Code>

<Desc>Gsmith</Desc>

<Fname>mgr</Fname>

<Lname>643456789</Lname>

<Title>Null</Title>

<Nickname>Null</Nickname>

<FunctCode>Null</FunctCode>

<Email>Null</Email>

<Phone>Null</Phone>

If you notice, the Fname, Lname,Title and Email data are omitted. Same happens to rest of the records. I cannot figure out what is wrong.

There are no header or trailer records in the file, only detail record which can have many rows.

My FCC details are as below:

ignoreRecordsetName = false

Detail.endSeparator = 'nl'

Detail.fieldSeparator = 	

Detail.lastFieldsOptional = yes

Detail.fieldNames=<field names>

Please help...

Thank you

[Former Member]

yes Suraj, I had tried from th enotepab and tab is working fine for me. Infact I dont have any problems with tab.

My issue is with missing data

[former_member187339]

Hi,

Ok I thought it might be because of the field separator

Also one more suggestion

Keep Details.keepIncompleteFields='YES' (with quotes)

Check the note

Note 868039 - XI 3.0 AF: Content conversion issues for lastFieldsOptional

Regards

Suraj

[Former Member]

I tried that, but no luck

[Former Member]

Try specifying fieldSeparator as '0x09' which stands for tab

Also try removing ignoreRecordsetName = false as recordset node gets inserted if it is not set to true

[Former Member]

Hi Mugdha,

I need the recordset node inserted, since I have that node in my DT.

[Former Member]

yes, that will be inserted by default.

No need to specify ignoreRecordset = false.

just check by not mentioning this parameter in content conversion

one more work around as you fcc parameters look perfect,

try removing lastFieldsOptional as this parameter is obsolete....as per help.sap.com

http://help.sap.com/saphelp_nw70/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

[former_member208396]

Hello Mugdha,

I also have the same requirement but in my case the fields are separated by " "(space) not tab.

Can you please help.

Regards,

Vishnu Srivastava