Upload data into CRM web UI from Excel

[former_member190085]

Hi All,

I am working on CRM UI for SAP CRM 5.2. I need to import the contents of an excel file to a table of a result list. Is it possible to achieve this functionality in the new web UI? If so, how to proceed.

Kindly help me in this regard.

Thanks in advance,

Vijay.K

[Former Member]

Hello Vijay,

I'm never done it but I think that you can do it following way:

1) add to html

<htmlb:fileUpload>

- It's upload file to server

2) read this file with

OPEN DATASET

- I'm not sure that it will work but give it a try.

3) after you read this file and fill Internal Table you can fill a

GridLayout

4) don't forget to delete this file from server

The uploded file should be a csv for easy handling (CSV - Coma seperated values, just a text file with ceperated values).

Good Luck

Eli Steklov

Tell me if it worked

<b>Please reward points if it helps :-)</b>

[former_member190085]

Hi Eli Steklov,

Thank you very much for answering. It's very helpful and encouraging. You have provided what exactly i needed. But, i still face some problem in inserting the <htmlb:fileUpload> tag in the code of my scenario.

It works for a standalone BSP page when enclosed as follows:

<htmlb:content design="design2003">

<htmlb:page title = " ">

<htmlb:form encodingType = "multipart/form-data">

<htmlb:fileUpload id = "upload1" onUpload = "upload" upload_text = "click here"/>

</htmlb:form>

</htmlb:page>

</htmlb:content>

But in my case, i need this file upload above a result list table which is inside a view of an existing component. The view itself is enclosed inside some tags from its view set.

So,If i insert the above code before my table, i am getting an exception with following text.

"BSP element may be used once only".

I also tried inserting the tags for form and fileUpload only, but nothing is getting effected in that case. (i.e., no UI is seen).

I am working on some way for inserting this tag, and meanwhile, if you have any idea on my scenario, kindly help me.

Thanks once again for your answer.

Regards,

Vijay.K

[Former Member]

Hi,

I think the problem that you use <b>page/form/content</b> and this component should use only once, but don't forget that those components already used in your page.

Good Luck

[Former Member]

P.S.

I had the same problem but in BSP and with different componnet, after I wrap my component with current code (see bellow) the problem solved.

I'm not sure that it will work in ICWC but it worth give it a try.

If It wont work try to my previous advice.

<htmlb:content design="design2003" >

<htmlb:page title="print" >

<b><htmlb:document></b>

<htmlb:form>

<b><htmlb:fileUpload ...... /></b>

</htmlb:form>

<b></htmlb:document></b>

</htmlb:page>

</htmlb:content>

Hope it helped

Eli

[Former Member]

Hi,

Please use <<b>t</b>htmlb:fileUpload> tag in all CRM 5.1/5.2 pages. I guess this will work.

Reward if helpful!

Thanks,

Sudipta.