cancel
Showing results for 
Search instead for 
Did you mean: 

Issues in File Content Conversion in a Sender Adapter

Former Member
0 Kudos

Hi Folks ,

The XMl Structure of my input file is

<?xml version="1.0" encoding="UTF-8"?>

<ns:file_sender_mt xmlns:ns="urn:filetofiledemo">

<recordset>

<data>

<name />

<city />

<age />

</data>

<adress>

<fnaame />

<lanme />

</adress>

</recordset>

</ns:file_sender_mt>

In my file conversion paramaters i have mentioned

data.fieldSeparator ,

data.fieldNames name,city,age

adreess.fieldSeparator ,

adreess.fieldNames fnaame,lanme

ignoreRecordsetName true

recordset.fieldSeparator ,

data.endSeparator ,

I fail to understand when in my input file

i give

1,2,3

4,5

ie value of data and adrees on diff lines it works fine

bt when i give the imput as 1,2,3,4,5

it fails in adapater

giving the exception

Sender Adapter v1014 for Party '', Service 'filetofile_bs':

Configured at 12:11:43 2006-07-18

Last message processing started 05:22:34 2006-07-19, Error: Conversion of complete file content to XML format failed around position 0 with java.lang.Exception: ERROR converting document line no. 1 according to structure 'data':java.lang.Exception: ERROR in configuration: more elements in file csv structure than field names specified!

last retry interval started 05:22:34 2006-07-19

length 10,000 secs

I dont understand why i am getting this error as my data.endSeparator is ,

any inputs on this would be of grt help

Thanks

Amit

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

I understand u have 2 more fields in address. Just try with this settings.

data.fieldSeparator ;

data.endSeparator ,

address.fieldSeparator :

address.endSeparator 'nl'

Now u can give the input file like

1;2;3,4:5

But if ur requirement is to have same fieldSeparator and endSeparator, this one will not be useful. Experts let me also know if I can have same valnes for fieldSeparator and endSeparator.

Regards,

Jai Shankar.

Former Member
0 Kudos

well though my requirement is not that

but still i tried to do that

it didnt work even i give a diff field sperator .

Guess there is something else which we are missing

i tried with begin and end seprators alos

bt no luck

bhavesh_kantilal
Active Contributor
0 Kudos

Amit,

Try this,

<i>data.endSeparator ,

address.endSeparator 'nl'</i>

Regards,

Bhavesh

Former Member
0 Kudos

Hi Bhavesh,

Hope you are doing good . nice to see you among the top 3 contributors .

I had tried that 2 , doesnt work

you get the same error

Sender Adapter v1014 for Party '', Service 'filetofile_bs':

Configured at 05:44:14 2006-07-19

Last message processing started 05:44:54 2006-07-19, Error: Conversion of complete file content to XML format failed around position 0 with java.lang.Exception: ERROR converting document line no. 1 according to structure 'data':java.lang.Exception: ERROR in configuration: more elements in file csv structure than field names specified!

last retry interval started 05:44:54 2006-07-19

length 10,000 secs

Any clues bhavesh

Former Member
0 Kudos

Hi Amit,

Am not sure about this but worth a try.

The problem arises coz u have same values for both data.fieldSeparator & data.endSeparator ie ,. Just try with dat.fieldSeparator ; or other field separators.

Regards,

Jai Shankar.

Former Member
0 Kudos

Hi Amit,

In you data strcutre you have just two parameters and in the file you are giving has 5 values.

Your error is self explanatory:

<i>ERROR in configuration: more elements in file csv structure than field names specified!</i>

Regards

Vijaya

Former Member
0 Kudos

Mam if you look at my XML

<?xml version="1.0" encoding="UTF-8"?>

<ns:file_sender_mt xmlns:ns="urn:filetofiledemo">

<recordset>

<data>

<name />

<city />

<age />

</data>

<adress>

<fnaame />

<lanme />

</adress>

</recordset>

</ns:file_sender_mt>

I have 5 paramaters

name ,city ,age , fnaame , lname

and i am pasing those 5

Former Member
0 Kudos

Hi,

You have specified data.fieldNames with 3 fields.

And so, when you are trying to pass more than 3 fields in your file, you are getting the error.

Regards,

Smitha.

Former Member
0 Kudos

My adress.field Names has 2 more characters . i need to pass them also