Problem File Adapter

[Former Member]

Hi,

I've a problem with the XI 3.0 File Send Adapter.

The First Field in every File he put an "" in front of the Value.

all other Rows in this File are fine.

Just the first has always these strange characters.

any idea what that could be ?

regards,

robin

[Former Member]

Hi

if you do not want these characters in the target side then u can also use the substring function .

use the substring function, define the length of the substrin u want

source->substring->target

suppose(4--->10)

Thanks

Rinku

[Former Member]

Hi,

the problem is there are really some strange characaters in the file.

But Wordpad or Notepad didn't show them.

We change the source System.... so that we get a header row.

No the strange characters are in this row and i can just skip this row in file adapter.

thanks.

robin

[Former Member]

Robin

If you are using Graphical Message mapping then try node function "mapWithDefault" & leave the value field empty so this will actually enter blank in case no value will be provided from the source side.

Let us know with the results.

- Lalit -

[Former Member]

what file type is this?

[Former Member]

flatfile

.txt document.

regards,

robin

[Former Member]

Hi,

If u want to avoid the the first line in the file then check these links and u can avoid the first row.

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Regards,

Phani

[Former Member]

Hi,

i dont want do avoid the first line.

I just want that the file adapter reads the value as they are.

regards,

robin

[Former Member]

Does the adapter fail when reading the file?

[Former Member]

no,

it just put always "" in front of the first value.

Even when the file is empty he creates a recordset and the first value is then just "".

regards,

robin

[bhavesh_kantilal]

Even when the file is empty he creates a recordset and the first value is then just "".

XI considers this as data and hence creates the payload as needed If you do not want the message to be created in case the file only contains this character only option would be to write a script that trims of these charcters and therby when XI reads the file, the file is a empty file.

If SP19 or above, you can also decide what you need to do with this empty file

Regards

Bhavesh