cancel
Showing results for 
Search instead for 
Did you mean: 

probelm with file conversion

Former Member
0 Kudos

Hi

Iam doing File-XI-File scenario,where i send .txt file from source to Target with out any changes.

I simply pick it form source directory and place in Target.

Now if there is any Space between charcters inSource ,it is replacing with '#' in target.

No file content conversion is used.

Please help....

Edited by: Dinesh on Mar 6, 2008 3:33 PM

Accepted Solutions (0)

Answers (2)

Answers (2)

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

hi, could you paste the inbound message you get from sxi_monitor?

this issue is rare, spaces for "#"? i have never had this error using file adapters in my years of pi

thanks

Rodrigo

Edited by: Rodrigo Pertierra on Mar 6, 2008 7:17 AM

Former Member
0 Kudos

Hi,

Can u paste ur file data and the FCC parameters which is used.

Chirag

Former Member
0 Kudos

Hi Chirag ,

how r u man,

BTW iam not using any content conversion as i dont want to convert any thig.

i simply have to pick file from source and put it in Target.

Former Member
0 Kudos

Hi,

Paste ur file content here.

R u sending XML file.

Chirag

Former Member
0 Kudos

Hi,

{-

MIDBGBDD003

MIDBGBDD003

101

:20:0706250000047213

:21R:0000047213

:28D:1

/1

:52A:MIDBGBDD003

:30:070601

:25:

:21:2000000007 0601

:23E:URGP

:32B:GBP25000,00

:50H:/127665

ADRESS 1 COMPANY CODE

ADRESS 2 COMPANY CODE

ADRESS 3 COMPANY CODE

ADRESS 4 COMPANY CODE

:57A:NWBKGB2118R

:59:/12345678

EXTERNAL VENDOR

RUE DE THEUX, 42

1040 BRUSSEL BELGIUM

:70:INV. 1900000002 FR.01.05.07

:71A:SHA

-}

Former Member
0 Kudos

Hi,

From the content it seems that ur file is : separated. I think u need to use the FCC.

USe:

NameA.fieldSeparator

If you make an entry here, the system expects that the structure contains the specified character string (one or more characters) as a separator between the individual columns.

If you have not made an entry for fieldFixedLengths, this is the only specification to identify the individual columns in a row.

If you made a specification for fieldFixedLengths, the extra length of the separator is taken into account, but no further consistency checks are performed.

Thnx

Chirag