FCC

[Former Member]

Hi all,

i have a file at sender side as given below.....i need to upload in to SAP,IT IS CSV FILE,what are the FCC parameters to be used,

"350001.62125","62120",3.25,3.25,3.25,7771,"","00001",0,"620001",

"350001.62125","62120",6.51,6.51,6.51,7771,"","00001",0,"620001",

"350001.63200","63200",34.20,34.20,34.20,7771,"","00001",0,"620001",

"350001.63210","63210",16.32,16.32,16.32,7771,"","00001",0,"620001",

I have used

namea.fieldnames

namea.fieldsepeartor

namea.endseperator.

i want to remove " , because it won't be accepted by SAP,at receiver side.

please help,it is urgent.

Regards,

Swati

[aashish_sinha · Accepted solution]

Hi,

Have a look into these two weblogs will help you.

/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

Regards

Aashish Sinha

PS : reward points if helpful

[Former Member · Accepted solution]

Hi asish,

the links which u sent are for receiver adapter,

my structure is at sender and not at receiver.

Regards,

swati

[Former Member · Accepted solution]

Hello Swati,

Use One more parameter

NameA.enclosureConversion (YES/NO).

To remove the delimiter upon transfer, or to replace it with escape characters, enter YES. This is the default value.

To transfer the characters unchanged enter NO.

If you specify xml.enclosureSign=“ and xml.enclosureSignEsc=““, text enclosed in quotation marks is transferred unchanged and the quotation marks are removed.

If the escape character for a quotation mark (““) occurs in the text itself, it is replaced by the quotation mark during the transfer.

Find more about this at

http://help.sap.com/saphelp_nw2004s/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

Regards,

AshwinM,

{Dont forget to mark Helpful answers]

[Former Member · Accepted solution]

hi swati,

check this out for sender FCC

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30 ===> this will work for you

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

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

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

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

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

Regards

Ramesh P

Edited by: Ramesh P on Apr 28, 2008 12:44 PM

[Former Member · Accepted solution]

Hi,

as my structure contains

"350001.62125","62120",3.25,3.25,3.25,7771,"","00001",0,"620001",

"350001.62125","62120",6.51,6.51,6.51,7771,"","00001",0,"620001",

here the first field of the two columns contains "350001.62125","62120", should i consider that as single structure and do content conversion.

regards,

swati

[former_member556603 · Accepted solution]

Swathi,

Go through this IMP Blogs:

File content conversion sites

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

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

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

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

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

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

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/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/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Thanks,

Satya

[Former Member · Accepted solution]

> "350001.62125","62120",3.25,3.25,3.25,7771,"","00001",0,"620001",

> "350001.62125","62120",6.51,6.51,6.51,7771,"","00001",0,"620001",

> here the first field of the two columns contains "350001.62125","62120", should i consider that as single structure and do content conversion.

"350001.62125","62120" --- Ideally you should not consider as Single structure or single data element since it is clearly distinguished as two different data element.

But you can make it single at your graphical mapping level where you can use concat string to concat both the first and the second as one data element.

Regards

Ramesh P

Edited by: Ramesh P on Apr 28, 2008 1:16 PM

[Former Member · Accepted solution]

Hi ramesh,

i have read the blog which u sent..

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30 ===> this will work for you

In this blog the structure is as follows

"V00",01,"VEN",999000,272727,09

"A11","VR",13245,20050

"A11","VR",12345,90090

"A27","VR00027"

he has taken

"A11","VR",13245,20050

"A11","VR",12345,90090

as the single structure ....right

it is as SUB1..

in the same way should i take

"350001.62125","62120",3.25,3.25,3.25,7771,"","00001",0,"620001",

"350001.62125","62120",6.51,6.51,6.51,7771,"","00001",0,"620001",

as a single structure

Regards,

swati

[Former Member · Accepted solution]

hi swati,

Sorry last time i replied in different sense.

Yes you can take it as single structure, as all the records seems to be similar and there is no header data as such. Hence you can write them all in single structure which will yield 1 or more data segments (depending on the number of records) of same structure in XML.

Regards

Ramesh P

[Former Member · Accepted solution]

Hi ramesh,

for the structure which i have....

can i use

namea.filednames

namea.filedsepearator

namea.endsepeartor

is this enough.

Regards,

swati

[Former Member · Accepted solution]

Hi swati,

Yes this should suffice your requirement.

Regards

Ramesh P

[Former Member · Accepted solution]

Hi ramesh,

thank you.

regards,

swati

[Former Member · Accepted solution]

Hi,

i want to remove " from by document as it need to be sent to SAP,

where should we

xml.enclosureSign=“ and xml.enclosureSignEsc=““,

.

If the escape character for a quotation mark (““) occurs in the text itself, it is replaced by the quotation mark during the transfer.

what is meant by escape character?

Regards,

swati

Edited by: swati i on Apr 28, 2008 10:25 AM

[Former Member]

Hi,

where should i specify in the parameters.

Regards,

swati

Edited by: swati i on Apr 28, 2008 11:15 AM

[Former Member]

hi swati,

The quotes cannot be remove in FCC itself. You have to do in mapping.

Once your FCC is done for the scenario, come to IR and in the mapping use replaceString function to remove the double quotes for the fields.

check this.

http://www.flickr.com/photos/14825894@N08/

or also follow sap.help.com

http://help.sap.com/saphelp_nw04/helpdata/en/43/c4cdfc334824478090739c04c4a249/content.htm

Regards

Ramesh P

[Former Member]

Hi,

but the document says thet we can remove the quotes

http://help.sap.com/saphelp_nw04/helpdata/en/43/c4cdfc334824478090739c04c4a249/content.htm

this is the text which says we can remove the quotes.

please refer the document

NameA.enclosureSign

Specify a string that acts as a text delimiter.

Text enclosed by such delimiters is transferred to the target structure unchanged, although the default setting is to remove all text delimiters. Separators within such texts are ignored.

This parameter is optional. The default setting is an empty value (no text delimiter).

● NameA.enclosureSignEnd

If the text delimiters for the beginning and end of the text are different, specify the text delimiter for the end of the text here.

If you do not make an entry here, the entry from NameA.enclosureSign is used.

● NameA.enclosureSignEscape

Specify a string that replaces the text delimiter if it occurs within a text that it delimits.

When the text is transferred the string is replaced by the value specified in NameA.enclosureSign.

● NameA.enclosureSignEndEscape

Specify a string that replaces the text delimiter for the end of the text if it occurs within a text that it delimits.

When the text is transferred the string is replaced by the value specified in NameA.enclosureSignEnd.

● NameA.enclosureConversion

To remove the delimiter upon transfer, or to replace it with escape characters, enter YES. This is the default value.

To transfer the characters unchanged enter NO.

If you specify xml.enclosureSign=“ and xml.enclosureSignEsc=““, text enclosed in quotation marks is transferred unchanged and the quotation marks are removed.

If the escape character for a quotation mark (““) occurs in the text itself, it is replaced by the quotation mark during the transfer

Regards,

swati

[Former Member]

hi swati,

the link which you have sent does not contain the explanation you have given. Can you post the correct link.

I read the explanation, this also should work, but if you give the document where it specifies the NameA.enclosureSign it will be nice to conclude.

Regards

Ramesh {

[Former Member]

HI Ramesh,

please find the document.

http://help.sap.com/saphelp_nw2004s/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

i think we can eliminate quotes in mapping it self

where should we specify xml.enclosureSign="

and xml.enclosureSignEsc=""

Regards,

swati

[Former Member]

hi swati

● NameA.enclosureConversion

To remove the delimiter upon transfer, or to replace it with escape characters, enter YES. This is the default value.

To transfer the characters unchanged enter NO.

If you specify xml.enclosureSign=“ and xml.enclosureSignEsc=““, text enclosed in quotation marks is transferred unchanged and the quotation marks are removed.

This will work for your type of scenario.

Escape character here is ". why it said as escape character --- This is because since " belong to special characters group and this has to be specified explicitly it is called as escape character.

can you give it in the

Parameters for Recordset Structures only where you have entered for fixedfiledLengths... and try out.

Regards

Ramesh P

Edited by: Ramesh P on Apr 28, 2008 3:37 PM

[Former Member]

Hi ramesh,

as my field does not contain fixed fields.

where should i give xml.enclosureSign="

and xml.enclosureSignEsc=""

Regards,

swati

[Former Member]

> where should we specify xml.enclosureSign="

> and xml.enclosureSignEsc=""

Specify this in the recordset structure only where you have specified the name.fixedfieldlength, name.endSeparator. Give it here only

Regards

Ramesh P

[Former Member]

Hi Ramesh,

i will try it out.

thank you for the valuble inputs.

Regards,

swati

[Former Member]

hi

i tried out, it works fine.

you have just add

<name of the recordset>.enclosureSign=“

<name of the recordset>.enclosureSignEsc=

You add above in the recordset structure this will work fine.

Regards

Ramesh P

[Former Member]

Hi ramesh,

i think we should give in the CONTENT CONVERION PARAMETERS...not in RECORDSET STRUCTURE.

please confirm.

regards,

swati

[Former Member]

Yes in content conversion parameters!

Regards

Ramesh P

[Former Member]

Hi,

should i specify =" in the VALUE tab in conversion or in NAMES.

regards,

swati

[Former Member]

hi Swati,

Specify like this.

Name

<name of the recordset>.enclosureSign

<name of the recordset>.enclosureSignEsc

-

---

value

"

(dont specify anything here)

Regards

Ramesh P

[varun_k]

Hi Swati,

Use

NameA.fieldNames

NameA.fieldSeparator

NameA.endSeparator

NameA.fieldFixedLengths

Regards,

Varun