function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AnumcaAnumca 

how to export the data from customer portal

Hi All

         I need to export the data from Customer portal 

please help me....

 

Thanks & Regards

Anu.....

Best Answer chosen by Admin (Salesforce Developers) 
Ankit AroraAnkit Arora

I think you have missed this :

 

<apex:page standardController="Account" recordSetVar="Account" contenttype="application/vnd.ms-excel">

 

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page

All Answers

Ankit AroraAnkit Arora

Can you please explain what kind of data you to export from suctomer portal. Is it of objects to xls or xls to object?

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page
AnumcaAnumca

Hi Ankit

          Thaks for the Reply.

 

I want to export all Custom & Standard Objects data which are in Customer Portal.  Can you please tell me how to export that data.

 

 

Thanks

Anu....
Ankit AroraAnkit Arora

I can provide you the direction, create a visualforce page with content type xls. That page will extract the data from your database using SOQL and when that page is hit it will export all records as XLS.

 

Please make sure the objects whoes data you want to export must have read rights. Also at a time you can extract 50000 records in xls.

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page
srikeerthisrikeerthi

Hi Anumca,

 

According to my knowledge in Customer Portal there is no concept of Data Export.

 

 

Thanks.
AnumcaAnumca

Hi Ankit

 

I wrote the page like this.But it is not getting the data in excel format. I am getting output  just "Account Name"

 

<apex:page standardController="Account" contenttype="application/vnd.ms-excel"> 

 <apex:pageBlock > 

    <apex:pageBlockTable value="{!account}" var="a"> 

       <apex:column value="{!a.Name}"/>   

  </apex:pageBlockTable> 

 </apex:pageBlock>   

</apex:page>

 

Plese tell me 

Thanks

 
Ankit AroraAnkit Arora

I think you have missed this :

 

<apex:page standardController="Account" recordSetVar="Account" contenttype="application/vnd.ms-excel">

 

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page

This was selected as the best answer
AnumcaAnumca

Hi Ankit

 

     Thanks for the help. I got it

 

 

 

 

Thanks 

 

Anu....
Ankit AroraAnkit Arora

Great, so if my post helped you then please mark it as solution so others may get benefit.

 

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page
srikeerthisrikeerthi

Thanks Ankit,For your clarification.

 

 
Ankit AroraAnkit Arora

Your welcome Srikeerthi.

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page