Upload data to CRM System from Excel File

[former_member210642]

Hi,

Please let me know how to create A program to upload data from Excel to CRM .We do not write BDC Program in CRM System.How to Achieve this functionality.

[Former Member]

Hi Sunramanyam,

In SAP there is a standard class to upload the data from any type of files,

cl_gui_frontend_services

In this class, we had few methods to upload the data from excel file

file_open_dialog

- Method used to open a dialog to select the file path

GUI_UPLOAD

      - Method used to upload the data..

Hope this class helps you.

Regards,

Magana

[former_member210642]

Hi,

Thanks for your reply,

I want to know how to write BDC Program in CRM.Its not the matter of data uploading.In Web Ui There is no possiblity of recording Screens right,so that let me know procedure how to get relations and how we are going to upload the data in CRM .

[Former Member]

Hi subramanyam,

We had the BDC Recording for GUI screens, but not for Web UI screens.

Could you please elobrate your requirement..for further Help..

Regards,

Magana.

[former_member210642]

in GUI we use Recordings. How we will upload data for a transaction in web ui.

Recording is not possible for web ui. How to proceed further by uploding Data.

[Former Member]

Hello Subrahmanyam

Please have a glance over this link..

http://wiki.sdn.sap.com/wiki/display/CRM/CRMWebUI-UploadingdatafromExcelfiles</link>

Regards,

Magana