CC Receiver file last field of line truncated

[Former Member]

Hi experts,

I have a cc receiver file with 3 structures defined in content conversion :

TOP, FAMILY, SUBFAMILY

And as content conversion parameters :

TOP.fieldfixedLengths     11,8,8,5

TOP.endSeparator     'nl'

FAMILY.fieldfixedLengths     6,3,40

FAMILY.endSeparator     'nl'

SUBFAMILY.fieldfixedLengths     6,3,3,40

SUBFAMILY.endSeparator     'nl'

the Last fields of FAMILY and SUBFAMILY structures are truncated in my final file, blanks are removed. However I can see the blanks in my payload.

In my final file I have this :

And I want this :

How can I keep the final blanks at the end of each line ?

Thanks

[Former Member]

Any other ideas ?

[Harish]

Hi Guz,

Please check the below discussion

[Former Member]

Yes, I have already saw these 2 links.

Unfortunately, it dosen't help me in my case (I have a CC Receiver File)

[Former Member]

Hi Guz,

Please try the options "missingLastFields = add" and "keepIncompleteFields = Yes". I know they are for sender adapter but just give it a try.

[Former Member]

Hi,

missingLastFields and keepIncompleteFields will not resolve my problem. I have the right number of fields. It's just my last field which is truncated, blanks are removed.

But thanks anyway.

[iaki_vila]

Hi Guz,

Have you tried with fieldFixedLength or to set in your schema the exact length in the fields definition?.

Regards.

[Former Member]

in my CC receiver file I use fieldFixedLength

and in ESR, in my dataset I have defined my field like that :

libelle_famille

Element

xsd:string

1

false

minLength="40"; maxLength="40"; whiteSpace="preserve"

[former_member184720]

You might want to add the parameter <<strcture>>.fieldContentFormatting-> nothing in your FCC.

Also have a look at the suggestion from Ryan in the below thread.

[Former Member]

I have already tried with structure.fieldContentFormatting but it doesn't works.

[former_member184720]

Are you also maintaining the lengths in your Data type in ESR as suggested by Ryan Crosby

[Former Member]

In ESR I have this for example for FAMILY structure :

field libelle_famille is defined as max length=40

[Former Member]

Hello,

Did u try doing left padding of spaces for the last field in mapping?

Thanks

Amit Srivastava

[Former Member]

In my mapping, I have complete field with spaces until the 40th character.

[Former Member]

Hello,

Tell me one thing, where exactly you are viewing ur file? AL11?

AL11 normally truncate spaces which are there at the end...so, if you are dumping file in PI file system (or some mounted folder) then i would suggest to download file from the system (using winscp or take help of a basis guy) and then view the same in notepad++ editor.

Thanks

Amit Srivastava

[Former Member]

Hello,

That's what I do.

I download file from the system, and I view it with notepad++

And with notepad++ i see that in the last field, blanks are removed.

[former_member184720]

I believe it should be minimum length(even the minimum should be of length 40). May be you can give a try with that.

[Former Member]

Hello,

Which protocol (NFS/FTP) u are using ? and how did u downloaded ur file (if u are using NFS don't downaload using sxda_tools)?

FCC with fixed field length sould work and reatin spaces without specifying any length in the structure.

Thanks

Amit Sriavstava

[Former Member]

Hi,

in my dataset I have defined field whese these details :

libelle_famille

Element

xsd:string

1

false

minLength="40"; maxLength="40"; whiteSpace="preserve"

[Former Member]

Hello,

I use NFS protocol

to download my file I use an option in AL11 to download file as text.

It could be that ?

In my outbound XML message in the payload I see the blanks.

Perhaps blanks are deleted when I download my file..

How can I be sure to keep blanks when I download my file ?

[Former Member]

Hello,

As already stated, If u have sufficient access then use winscp otherwise ask ur basis team to downlaod a file for u...

Thanks

Amit Srivastava