A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.

learn more… | top users | synonyms

0
votes
1answer
30 views

Exact Target Automation Studio: Create multiple automation instances listening to same folder

We use Exact Target for marketing emails. In ET cloud, we have several attributes (columns), and we want to populate different attributes at different frequency and using different csv import files. ...
1
vote
1answer
46 views

How to remove extra column from csv of bulk api in JAVA

I am importing the data in to the salesforce using Bulk API. But I am facing this issues. I am replacing the column header with the salesforce API name. But some of the heade which is not releted to ...
0
votes
2answers
67 views

How to create csv files in controller method from list

I want to create csv files from lists and send an email attaching them, how to do that in a controller method?
0
votes
0answers
24 views

How to upload csv to the exacttarget list using asp.net and C# application?

can you please help me any one, I am able to create list on Exact Target from my .net application. now i want to add the subscribers to that list from csv file using My .net application(asp.net and ...
1
vote
1answer
51 views

Test.loadData() static resource text/csv vs. text/comma-separated-values

I am trying load a csv of User data for an Apex test from a static resource using Test.loadData(). When I upload the csv as a static resource, Salesforce gives is a MIME type of ...
1
vote
2answers
103 views

How to import russian user records in salesforce?

I am trying to load the csv files data through data loader to salesforce,When i try to load the Russian data i get ?????? in the place of text .How to resolve this issue??
0
votes
0answers
122 views

Error while using the Data Import Wizard

I'm getting the following error while trying to import a UTF-8 csv file. I'm trying to import data into a custom table. Does anyone know what could be going wrong? Error while running ...
0
votes
0answers
52 views

Pagination for records from CSV

I have a requirement where am getting collection of records from another method as list which are not inserted in object(gettting from CSV), and i want display that list in visualforce page with ...
1
vote
0answers
59 views

Inserting a PersonAccount record using csv file in Testclass

i write a test class for the apex class which is based upon inserting the PersonAccount records.i try to insert a record using csv file in test class but i got a error at the time of ...
2
votes
1answer
114 views

Trying to parse large CSV, can't split and can't find second newline

I have a csv with about 24,000 lines that I need to parse in apex. I tried splitting the string by newline ('\n'), but got a limit error: System.LimitException: Regex too complicated I tried ...
2
votes
1answer
71 views

View State Problem

I am generating a csv file. For this i am using a visualforce page and its controller. I am able to generate csv. I am not able to see the view state of this page. Please tell me a way to view the ...
2
votes
1answer
52 views

How to use \r\n stored in a custom setting field

I'm trying to setup custom settings for my CSV Writer/Reader. Therefore I'd like to enable customized linebreaks. But i'm just not able to create a new line, '\r\n' is just printed into my string. ...
5
votes
1answer
470 views

Unable to display UTF-8 character in a csv file generated from apex code

I am parsing an excel and extracting data using which I cam creating a csv file and inserting it as an attachment in salesforce. The problem is with the characters other than english. I am able to ...
3
votes
1answer
399 views

Attachment UTF-8 Character Set

I have a Apex Code which generates a CSV file and saves it as an Attachment under a record. The issue is that when the file is opened using Excel, few characters do not show properly. Eg: ' as well as ...
2
votes
1answer
308 views

Unexpected Error while trying to perform simple Upsert

When sending the following XML and CSV, I get this error on the Bulk Data Load Job Detail screen: Got an unexpected error while processing BULK-API. Contact support with error ID: ...
0
votes
1answer
72 views

How to copy an attachment from an email to a case record using email service

I'm Using an Email Service to create a custom object record and a case record. The email has an CSV attachment and have to attached to the case record.
1
vote
1answer
512 views

CSV Parser for 'Importing large CSV files via Batch Apex '

I need help for Importing large CSV files via Batch Apex. I have tried this link => http://developer.financialforce.com/customizations/importing-large-csv-files-via-batch-apex/ .But unable to ...
4
votes
3answers
984 views

How to resolve the Invalid Date error in Apex while uploading CSV file?

I am trying to upload the CSV file via Apex programming I am getting an error like Invalid Date Error. Please find the screenshot for more details. I have given code like this site.Approved_Date__c ...
2
votes
2answers
605 views

Visualforce Error System.TypeException: Invalid decimal:

I have written Apex code and VF page for uploading records for my custom object. While uploading the CSV file into system via programatically I am getting the error "Visualforce Error System.Type ...
1
vote
1answer
119 views

Upload CSV in different encoding than UTF-8

Is it possible to set an encoding for a file that is uploaded via a VisualForce page? I am getting errors stating that the content of the uploaded file is not UTF-8 encoded. Ideally, the user would be ...
-1
votes
1answer
145 views

Trigger Duplicate CSV

I am trying to upload a CSV file / insert a bulk of records using the import wizard. In short I would like to keep the latest record, in case if duplicates are found. Duplicates record are a ...
4
votes
2answers
326 views

How to export more than 50K records matching a query as a CSV?

I'm building a CSV exporter for use within a Customer Portal that allows them to export in bulk some of their data (basically usage logs, which there are a ton of). For some super users there are ...
0
votes
0answers
447 views

XLS Read and Automatic CSV conversion

We have a requirement to read contents (rows) from an XLS file and upload (the file as an attachment) the same once the read and insert into custom Objects are complete. My observation after ...
4
votes
1answer
227 views

Describe/use picklist values in specific language, not the User's language

This Salesforce org includes English and Italian versions of field labels and picklist value labels. This works find within the UI, and for most purposes. However, we have a custom CSV upload page ...
4
votes
2answers
479 views

“REGEX too Complicated” error

Is "REGEX too Complicated" error while attempting to upload a CSV via Apex into SFDC an undocumented limit? What should be the optimal data volume for a CSV upload via Apex? I was trying with 10,000 ...
4
votes
2answers
1k views

CSV File Upload into SFDC

I am looking for an approach to perform the below: [1] Read an CSV file from the local drive and insert the contents into SFDC (having a typical Browse button) [2] Once the read is complete upload ...
2
votes
0answers
62 views

Scheduling a custom report to be sent as a CSV file in an email [duplicate]

Is it possible to send a custom report out as a CSV file using APEX email templates? If so does anyone have the steps to do so? I am new to Salesforce and would appreciate any help. Thank you in ...
5
votes
1answer
924 views

Create CSV file from SObject records - How to Optimize Script Statments [duplicate]

I have following code which Create CSV file from any SOQL query, but the problem is its not very efficient (not optimized to execute with less number of statements). This code runs out of script ...
2
votes
4answers
435 views

Reading a csv file(document) in Jquery

We have a requirement where we want to read a csv document in Jquery / Javascript. We are able to read the file from documents (via query) and Static Resource inside the controller and then pass it ...
1
vote
1answer
252 views

Data export from app on app exchange

I have a SFDC App which does data (Account, Contact, Lead) segmentation and flags them according to segmentation rules. I want to be able to provide a link on visualforce page to download certain ...
2
votes
1answer
87 views

How to create letter with related data?

I want to create a letter that can be sent via email or saved as PDF (or in the worst case exported as csv). The data for the letter comes from the following related objects: The important object ...
10
votes
5answers
615 views

Convert SObject.toString output to a CSV value line (Regexp..)

I am running into ToManyStatements Limits while creating a CSV blob for with the following code for(SObject row: list) { for(String fieldName : allFields) { line += fieldName + ','; } ...
9
votes
2answers
2k views

How do I use Visualforce to generate a CSV file that can be downloaded using IE8?

I am using the following Visualforce Page as an endpoint that generates a CSV file using POST data that it is handed. The following page definition works great for everything but IE8 (Internet ...
1
vote
2answers
44 views

Query for what's not found

I have a parsed csv where I need to match on two columns: for (integer i=1; i<lines.size()+1; i++){ try{ PremiseNumbers.add(lines[i][Pindexnumber]); ...
2
votes
3answers
928 views

Encode Long Text Area field

I am working on some code that retrieves certain cases and then emails those cases as a csv. This is working to some extent. The problem I have is that one of the fields is 'Description' which is a ...
2
votes
1answer
417 views

New string methods substring Before/After, etc

I'm playing with the new string toys. I'm getting something out of a CSV (and I have very good reason to need to do that). I tried this: contents = contents.substringAfter('/n') and it's not finding ...