topic Re: BDC problem in Open Excel in Application Development and Automation Discussions

BDC problem in Open Excel

Former Member — Sat, 10 Oct 2009 10:40:34 GMT

Hi,

We are facing the problem to run the BDC.

Actually problem is that we are using the UBUNTU instead of Window XP / Server and Open Office instead of Microsoft Office..

File extension of Open Excel is .ODS & Microsoft Excel extension is .XLS. Also our BDC is supporting the .XLS extension files.

Is there any way to use the .ODS extension file in my BDC. Is it possible that if i change the code somewhere and use .ODS file, my BDC should run..

How to upload my .ODS file in BDC?? or any other way to make my BDC successful??

Thanks...

Edited by: @ABAP@ on Oct 10, 2009 5:57 PM

Re: BDC problem in Open Excel

Clemenss — Sat, 10 Oct 2009 13:39:33 GMT

Mr. fantasy,

it may be easier for you to save the open office douments in excel format.

SAP is still bound quite close to Bill Gates' world. BDC is more or less dead for many years, so they don't care about open office regarding BDC.

Regards,

Clemens

Re: BDC problem in Open Excel

Former Member — Mon, 12 Oct 2009 05:30:30 GMT

Hi,

i have worked on open office...it gives you the option to save the file in the .xls format as well, so if you save the file in .xls format rather than .ods then you can use the FM to upload the same .

If your requieement is regid then you need to serach the forum.

Pooja

Re: BDC problem in Open Excel

Former Member — Mon, 12 Oct 2009 06:57:10 GMT

Thanks dear,

I save the file in .xls format and upload the file, but show error as "File Error".

please let me know the FM, which i used for upload the file...

thanks..

Re: BDC problem in Open Excel

Former Member — Mon, 12 Oct 2009 07:02:30 GMT

Hi,

There are few things that I need you to check:

1.Make sure your file is not open while executing the eport

2.Declare internal table with all fields as Char type haning the length same as defined in the backend.

3.You can either upload the XLs file using the direct FM TEXT_convert_xls_to_sap

or save the xls file as the tabdeliminator file and use the Fm GUI_UPLOAD.

4.FM GUI_DOWNLOAD is used to download any fiel data to the presentaion server.

Hope now your problem will be solved.

Pooja