Export CSV file

Am created a visual force page to genarate records in csv format am using apex page tag like

<apex:page standardController="Case" extensions="CasesController" sidebar="false" showheader="false" recordSetVar="cases" cache="true" contentType="text/csv#Export.csv" language="en-US">

But am getting csv file like :

Anybody can help?

Thanks

May 23, 2013
·
Like
0
·
Follow
0

Best Answer chosen by Admin (Salesforce Developers)

kranjan
Hi Varun,

You are using datatable which is adding all the extra HTML tags for formatting and other things. You should simply use <Apex:repeat> tag for processing your list and then use normal <apex:outputText> tags to write the text. Do not forget to add comma and carriage return for column and row speerator. In nut shel you would need to make it plain and simple and write text which is as per csv format. Your code shuld be something like this

<apex:page standardController="Case" showHeader="false" extensions="CasesController" sidebar="false" action="{!bumpCases}" recordSetVar="selected" cache="true" contentType="text/csv#Export.csv">  <apex:outputText value="casenumber"/><apex:outputText value="{!COMMA}"/> <apex:outputText value="subject"/><apex:outputText value="{!COMMA}"/> <apex:outputText value="priority"/><apex:outputText value="{!COMMA}"/> <apex:outputText value="{!CRLF}"/>  <apex:repeat value="{!selected}" var="case"> <apex:outputText value="{!case.casenumber}"/><apex:outputText value="{!COMMA}"/> <apex:outputText value="{!case.subject}"/><apex:outputText value="{!COMMA}"/> <apex:outputText value="{!case.priority}"/><apex:outputText value="{!COMMA}"/> <apex:outputText value="{!CRLF}"/> </apex:repeat> </apex:page>

And in your controller you can add 2 properties for comma and carriage return as follows:

public String COMMA {
get {
return String.fromCharArray(new List<Integer> { 44 });
}
}

public String CRLF {
get {
return '\r';
}
}

May 24, 2013
·
Like
0
·
Dislike
0

kranjan
Hi Varun,

You need to have only content which is formatted as per csv format. Can you please post your VF page code for reference.

Regards

May 23, 2013
·
Like
0
·
Dislike
0

Varun99
Hi jan,

Thanks for reply. I have alist burtton in my cases when i select cases and clidk on button it redirect to page and will export in csv format. without using contenttype records displaying vf page.
========Page========

<apex:page standardController="Case" showHeader="false" extensions="CasesController" sidebar="false" action="{!bumpCases}" recordSetVar="selected" cache="true" contentType="text/csv#Export.csv">
<apex:dataTable value="{!selected}" var="case">
<apex:column value="{!case.casenumber}"/>
<apex:column value="{!case.subject}"/>
<apex:column value="{!case.priority}"/>
</apex:dataTable>
</apex:page>

===========Class========================

public with sharing class CasesController
{
public ApexPages.StandardSetController standardController;
public CasesController(ApexPages.StandardSetController standardController)
{
this.standardController = standardController;
}
public PageReference bumpCases()
{
// Get the selected records (optional, you can use getSelected to obtain ID's and do your own SOQL)
List<Case> selectedCases = (List<Case>) standardController.getSelected();
// Update records
for(Case selectedCase : selectedCases)
{
if(selectedCase.Priority == null)
selectedCase.Priority = 'Low';
else if(selectedCase.Priority == 'Low')
selectedCase.Priority = 'Medium';
else if(selectedCase.Priority == 'Medium')
selectedCase.Priority = 'High';
}
return null;
}
public PageReference updateCases()
{
// Call StandardSetController 'save' method to update (optional, you can use your own DML)
return standardController.save();
}
}

Thank you

May 24, 2013
·
Like
0
·
Dislike
0

This was selected as the best answer

Varun99
Hi jan,

Thanks its working fine. Why can you use comma and CRLF what it return can you explain?

Thank you jan.

May 24, 2013
·
Like
0
·
Dislike
0

kranjan
Varun,

Thats to embed a comma after every field value and an ENTER after every record which is how a csv format is identified and read.

Regards

May 24, 2013
·
Like
0
·
Dislike
0

Varun99

Thank you Jan.

: )

May 24, 2013
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Export CSV file

All Answers

You need to sign in to do that.