File content conversion

[former_member614185]

Is it possible to have entire content of a flat file into a single field of source XML Message?

[Former Member · Accepted solution]

Hi,

Check this

Regards

Seshagiri

[Former Member]

Hi,

This article by Ravikumar would be useful. Check it out -

Regards,

Riyaz

Edited by: Riyaz Sayyad on Jul 4, 2008 4:04 PM

[former_member190389]

Hi,

This means that your file should get splitted at EOF (the whole file in one record)

try using the value 0x1A (hex for EOF) as the field seperator in order to get the whole file

[Former Member]

Hi Prabu,

yes it is possible but depends upon the size of file but u need to proper mapping

for this mapping u need to go with the UDF

Thanx

Sampath

[former_member614185]

Venkat,

can we get the whole file data as a single field data while picking up the file using content conversion

Edited by: Prabu M on Jul 4, 2008 8:47 AM

[Former Member]

Hi Prabu,

yes we can do it can u send a copy of that file so that i can have clear picture

Thanx

Sampath

[Former Member]

yes

check the below blog for

Hierarchy Upload from Flat files

regards

kummari

[former_member614185]

Am asking in terms of XI.

Example: Flat file to XML file.

Entire flat content should be populated into one of the XML field with any changes in the content.

How can do this with file content conversion?

[Former Member]

Hi Prabhu

if you want thre entire record of data from the sender side into a single string at the receiver side then you can concatinate all the field values in a single field of receiver side and do the one to one mapping,

and to create the flat file at the receiver side yopu can use the following parameters in the receiver communication channel.

filedname.fieldSeparator ;

fileldname.endSeparator 'nl'

nodename.fieldSeparator 'nl'

Thanks

Rinku Gangwani

[former_member614185]

Thanks Rinku,

But what i need is, I am going to create a single field at my source side and this source filed has to populated with entire flat file content.

Is there any way in content conversion.

your answers will be appreciated

[Former Member]

Hi Prabhu,

I think,My reply is suitable for you.

Check for my reply in the above

Regards

Seshagiri