File adapter Error

[Former Member]

Hi

I am trying to load CSV file using FILE ADAPTER my fine strructure is :

BB,502,Kennington Tube Station,Braganza Street,,,,SE17,,#

BB,502,Kennington Tube Station,Braganza Street,,,,SE17,,#

BB,502,Kennington Tube Station,Braganza Street,,,,SE17,,#

AdminUnitDetails.fieldseparator ,

AdminUnitDetails.fieldNames a,b,c,d,e,f,g,h,i,j

AdminUnitDetails.endSeparator 'nl'

AdminUnitDetails.missingLastFields ignore

error i am getting is

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'AdminUnitDetails.fieldFixedLengths' or 'AdminUnitDetails.fieldSeparator' is missing Consistency check: no. of arguments in 'AdminUnitDetails.fieldFixedLength' does not match 'AdminUnitDetails.fieldNames' (0 <> 10)

Can some one help me

Babu

[Former Member · Accepted solution]

> AdminUnitDetails.fieldseparator ,

I guess this is typo error in field separator.

AdminUnitDetails.fieldSeparator ,

[Former Member]

Hi Babu,

exactly this problem with field separator. correct it..

Thanks

Sivaram

[Former Member]

Hi Babu,

Is there any fixed length for any Element in your Structure, If it there, Then we need add one more parameter called FieldFixedLength in the File conversion.

Thanks,

Sateesh

[Shabarish_Nair]

>

> Hi Babu,
> 
> 
> Is there any fixed length for any Element in your Structure, If it there, Then we need add one more parameter called FieldFixedLength in the File conversion.
> 
> Thanks,
> Sateesh

why would you want a fixed field in this use case?

the example shows clearly a comma separated file .

please correct the parameter to fieldSeparator