Question Re: issue in content conversion in Technology Q&A

issue in content conversion

Former Member — Tue, 20 Aug 2013 13:40:36 GMT

Hi,

Am trying to convert Big-Endian content format (file to file scenario with content conversion in both adapters) with sender file adapter to utf-8 format file which is going to upload into SAP.

but am getting an issue while converting Big-Endian content...if you see input file...its converting in wrong format as the content is generating with blanks and so...fixedfiledlengths are showing wrong data.

anybody please help me what is going wrong...

-Kishore

Re: issue in content conversion

Muniyappan — Tue, 20 Aug 2013 14:29:17 GMT

Hi,

are you converting csv to xml?

from the xml it looks like it is converting the header?

that is why no values are not coming in the xml.

check this

http://scn.sap.com/thread/1946048

Regards,

Muniyappan.

Re: issue in content conversion

zameerf — Tue, 20 Aug 2013 14:37:10 GMT

Hi,

>>file to file scenario with content conversion in both adapters

is there any mapping or other run time requirements for this interface?

if not, just go for only ID objects and do a pass through file transfer.

Regards,

Zameer

Re: issue in content conversion

Former Member — Tue, 20 Aug 2013 14:52:18 GMT

Zameer,

there is no mapping involved...i can even pass through with file protocol but while placing in SAP, file content is again showing junk characters and hence am trying through content conversion...

Re: issue in content conversion

Former Member — Tue, 20 Aug 2013 14:55:58 GMT

I got you what you mean to say...but somehow am not able to see the values are in proper format due to content issue...for ex: first field am having lengh of 10 chars but if you see it is stopping with 4 if you see in XML file but when you see the source...blanks are coming in between and so it is taking only 4 chars...how to handle this...

Re: issue in content conversion

zameerf — Tue, 20 Aug 2013 16:04:18 GMT

Hi,

once you place the file in target directory, how is the file processed by SAP? where you able to see the same file as in source once you place in target directory? or you see junk characters there?

Re: issue in content conversion

Former Member — Tue, 20 Aug 2013 16:09:50 GMT

Zameer, once i place file in SAP, am not able to process the file and i see junk characters...but if i exctract the same file through filezilla to my local directory, i can see the data...not sure how can handle this...

Re: issue in content conversion

Muniyappan — Tue, 20 Aug 2013 17:31:23 GMT

Hi,

Can you paste you input csv file(open it in notepad) and FCC settings here?

Regards,

Muniyappan.

Re: issue in content conversion

zameerf — Tue, 20 Aug 2013 20:09:58 GMT

normally in pass through scenario, the file content will not be altered.

can you share a sample output file which has the junk chars?

Re: issue in content conversion

Former Member — Wed, 21 Aug 2013 03:56:14 GMT

Hi,

here i dont see any issue in FCC...if you see my first screenshot where "date" is the only char coming in for 10 chars and if you see the source file there are blanks which are occupying that length...which means file reading content is problem...i know source file update is useful but for the time being i could not update the same due to network issues...

Re: issue in content conversion

Former Member — Wed, 21 Aug 2013 05:24:31 GMT

Re: issue in content conversion

Former Member — Wed, 21 Aug 2013 12:17:32 GMT

can anybody help me on this...

Re: issue in content conversion

zameerf — Wed, 21 Aug 2013 13:17:40 GMT

Do you see this junk char only in al11 transaction?

when you open the file directly from file system how is the content?

Re: issue in content conversion

Former Member — Wed, 21 Aug 2013 13:38:58 GMT

I see this junk char in al11 tcode...if i download the same from system...file is OK and no issues...

Re: issue in content conversion

zameerf — Wed, 21 Aug 2013 13:56:44 GMT

in receiver file adapter, do you have file type as Binary in processing parameters?

can you try changing this to Text?

may be you can try setting the encoding as UTF-8 as well and see if that helps

this looks like unicode issue

Re: issue in content conversion

Former Member — Wed, 21 Aug 2013 14:32:11 GMT

Thats right...this is unicode issue...

I have tried to change setting to UTF-8 but then am getting parser issue during conversion in receiver adapter level...

please suggest...

Re: issue in content conversion

zameerf — Wed, 21 Aug 2013 15:45:27 GMT

did you try with only file type as text? without any encoding..

also please confirm if your are using any FCC here, i assume you are using pass through scenario?

Re: issue in content conversion

Former Member — Thu, 22 Aug 2013 07:19:43 GMT

here 2 things...i can simply pass through file but since am getting encoding issue am trying to sort out through FCC in which also am getting similar error.

let me try only file type as text without encoding...will update you. thanks...

Re: issue in content conversion

Former Member — Thu, 22 Aug 2013 08:54:31 GMT

Hi,

I am not sure but can you please try with encoding as UTF-16BE in sender File adapter?

http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/content.htm

■ UTF-16BE

16-bit Unicode character format, big-endian byte order

Thanks,

Beena

Re: issue in content conversion

Former Member — Thu, 22 Aug 2013 09:20:04 GMT

I have tried this...but am getting error as "Transform: failed to execute the transformation: com.sap.aii.af.sdk.xi.adapter.trans.TransformException: Error converting Message: java.lang.Exception: Exception in XML Parser (format problem?):org.xml.sax.SAXParseException: Content is not allowed in prolog.'; nested exception caused by: java.lang.Exception: Exception in XML Parser (format problem?):org.xml.sax.SAXParseException: Content is not allowed in prolog"