file to rfc scenario

[Former Member]

hi all,

here i am doing file-->rfc scenario,but the thing is that files are in the format of CSV and XLS how to pick the files.please help me.

regards,

subba reddy

[MichalKrawczyk · Accepted solution]

hi,

for CSV you can use content conversion in the file adapter

for XSL you can use conversion agent

Regards,

Michal Krawczyk

[Former Member · Accepted solution]

hi michal,

what is meant by conversion agent,how to do,can u explain elaborately.

regards,

subba reddy

[Former Member · Accepted solution]

Hi Reddy,

Conversion Agent is a tool that allows you to build XML from PDF's,. TXT and excel files, mappings

for EDI etc. So, if your file is a .TXT file, then you can develop the mapping using Conversion

aganet to convert the .txt file and then call the corresponding COnversion Agent Module from your

file adapter.

If you can handle Content Conversion using FIle adapter, you should use the same, but, if needed you

can always use the Itemfield Conversion Agent to do the same. The only catch here with Conversion

Agent is that it has its licensing overheads and it runs on a separate engine and so perfrormance

when compared to file content conversion can be a bit poor but not lots.

SAP Conversion Agent by Itemfield is a data conversion system that enables you to create interfaces

between any data formats and XML-based systems. Conversion Agent can convert unstructured,

semi-structured, and structured formats to XML, and the other way around.

Conversion Agent comprises the Conversion Agent Studio and the Conversion Agent Engine. In the

Conversion Agent Studio you can develop and configure data conversions. The Conversion Agent

Engine then executes the data conversions.

Blog for conversion agent

/people/bla.suranyi/blog/2006/06/08/sap-xi-supports-edifact

Regards

Ramesh

[Former Member]

solved my problem

regards,

subba reddy

[Former Member]

Subba reddy,

Picking csv is a normal standard process.

For XLS either you have to purchase conversion agent or ask the sender to save the xls file as .csv (they can write a template and can do this easily) else you may write an adapter module for converting the xls file.

See this felix blog for an example:

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

Regards,

---Satish

[Former Member]

For a simple guide to CSV Content Conversion try the Riyaz example:

http://www.riyaz.net/blog/xipi-file-content-conversion-for-simple-structure/

[Former Member]

Hi,

If it is CSV file you will have to use <node>.fieldSeparator in Comunication Channel (content conversion).

Regards,

Radek

[Former Member]

if File is CSV, you have to do File Content Conversion in Sender File Adapter.

http://help.sap.com/saphelp_nw04/Helpdata/EN/bc/bb79d6061007419a081e58cbeaaf28/frameset.htm

http://www.riyaz.net/blog/xipi-file-content-conversion-for-simple-structure/