FCC on sender side

[Former Member]

Hey guys

i have a requirement wherein i will be getting a CSV file of the form

<Reg>3

<Name>mark</Name>

<Age>25</Age>

</Reg>

<Reg>4

<Name>Adam</Name>

<Age>27</Age>

</Reg>

i have convert this file to XML and send over HTTP,

is this possible using FCC,coz i know sender FCC permits only one level of substructure and here my structure is kinda strange.

any help would be appreciated

thanx

ahmad

[MichalKrawczyk · Accepted solution]

Hi,

but if your source file look like this:

<Reg>3

<Name>mark</Name>

<Age>25</Age>

</Reg>

<Reg>4

<Name>Adam</Name>

<Age>27</Age>

</Reg>

then is has nothing to do with CSV

CSV = Comma-separated values

and there are no commas in your file

this is also not an XML as it has more then one

root segment so you need to check

if this is really the file you will receive

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member · Accepted solution]

well the way i m gonna get the file is something like this

3

--->Mark

--->25

4

--->Adam

--->27

Note: ---> means space

is it possible to convert this to XML and send over http?

sorry it wasn't CSV,its separated by 'nl'

thanx

ahmad

[MichalKrawczyk · Accepted solution]

hi,

try with content conversion first but if not

develop a simple adapter module that will parse this file

using nl as separator to XML (0,5 - 1 day max)

but try with content conversion first

Regards,

michal

[Former Member · Accepted solution]

Thanx Michal

i'll wrk over it and get bak to sdn

thanx

ahmad

[Former Member · Accepted solution]

Hey

now client has changed the structure of file

i will be getting it in the following form

mark~25

Adam~27

Jimmy~30

so what will my FCC parameters be ?

thanx

ahmad

[MichalKrawczyk · Accepted solution]

Hi,

this is easy just use fieldSeparator = 'nl'

and one fieldname (inside the mapping you will cut mark~25 to

mark and 25)

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Regards,

michal

[Former Member · Accepted solution]

Thanx Michal

if i need a structure of the following form ,wat will my parameters be

<Employee>

<data>

<Name>Mark</Name>

</Age>25</Age>

</data>

<data>

<Name>Adam</Name>

<Age>27</Age>

</data>

</Employee>

thanx

ahmad

Message was edited by:

Ahmad

[bhavesh_kantilal · Accepted solution]

With source as ,

mark~25
Adam~27
Jimmy~30

XML needed as,

<Employee>
<data>
<Name>Mark</Name>
</Age>25</Age>
</data>
<data>
<Name>Adam</Name>
<Age>27</Age>
</data>
</Employee>

Use this content conversion.

Document Name : Employee
Document Namespace : namespacevalue

Recordset Strucutre : data,*

data.fieldNames : Name,Age
data.fieldSeparartor: ~
data.endSeparator : 'nl'
ignoreRecordsetName : true

Regards

Bhavesh

[Former Member · Accepted solution]

HI,

Use the following FCC parameters

Document Name : Employee

Document Namespace :

Recordset Strucutre : data,*

<i>Processing parameters</i>

ignoreRecordsetName : true

data.fieldNames : Name,Age

data.fieldSeparartor: ~

data.endSeparator : 'nl'

Also see the below links to get an idea about FCC

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp

/people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy

http://help.sap.com/saphelp_nw04/helpdata/en/ee/c9f0b4925af54cb17c454788d8e466/frameset.htm

Regards

Chilla

[Former Member · Accepted solution]

thanx guys for ur answers

i will implement this tomorrow and hopefully my scenario shud work

and yeah thanx to u again and sdn that my HTTP to FIle scenarios is working awesome:)

and chilla i will award u extra points in other questions,sorry i couldn't assign u full 10 points as i has already assigned that to Bhavesh

regards

ahmad

Message was edited by:

Ahmad