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

learn more… | top users | synonyms

0
votes
1answer
44 views

Dataloader error : Error converting value to correct data type: Failed to parse date: Yes

I tried to upload a CSV file through Data loader without date field but still I am getting below error message: "Error converting value to correct data type: Failed to parse date: Yes" Please help ...
0
votes
1answer
43 views

Mapping Problem with data loader

I'm a beginner in salesforce and i hope this is the right place to ask. I'm currently trying to update using data loader, in the Mapping Step, the column header always become one, ID;USERNAME;...
1
vote
0answers
56 views

How to Convert data From CSV to JSON?

I am trying to create a Records from CSV File to Custom Object. This is my Method public Pagereference ReadFile() { NameFile1 = EncodingUtil.base64Encode(contentFile); string[]...
8
votes
2answers
96 views

VisualForce MultiLine UTF-8 CSV

Goal is to generate a CSV file from VF that contains UTF-8 chars and multiline text fields. All users are Mac users. Controller public class MultiLineUtf8CsvMac { public String utf8Bom {get {...
1
vote
1answer
26 views

Handle Extra Coma in CSV from code level

in Certification column there are 3 certificate which are mention as 1x,2x,3x when i parse csv it shown an error An error has occured reading the CSV fileList index out of bounds: 2 how to handle ...
1
vote
1answer
31 views

csv format in the Force.com CLI

When I do a soql query with --format:csv, and I view the results file in excel it seems that all entries are padded with spaces to match the column header width. This is not a huge problem but it's ...
0
votes
1answer
31 views

covert string into date time format in field ledObj.Scheduled_Time__c= csvRecordData[10];

this value is in my csv 5/4/2016 15:00:00 and when i upload csv its not save into field. public class importDataFromCSVController { public Blob csvFileBody{get;set;} public string csvAsString{get;set;...
3
votes
1answer
20 views

Empty Key/ Random string on export?

quick question- So I'm doing a data migration right now, and I just did an export of the Task object. Most of the Task's are related to the Account object, but in the CSV file that I exported, the ...
0
votes
1answer
36 views

issue adding csv file attachment to email in Batch job

In a batch file we are updating records, and for each one we are creating a record which is sent in an email when the batch completes. It all works swimmingly except that the csv file is sent as an ...
1
vote
0answers
21 views

Set report Export Details preferences (Excel vs CSV)?

When you Export Details in a report, it defaults to Excel. I don't use Excel, I always want csv. Is there a way to set the default or the preference?
4
votes
2answers
64 views

How to upload external data files to Wave Analytics using External Data API

I want to upload external data csv file to Salesforce Wave Analytics using External Data API and Web Services Connector (WSC). I have connected to salesforce using below code: ConnectorConfig config ...
0
votes
0answers
56 views

How to handle CSV file with 'line breaks' - data loading

I have a CSV file of Tasks (activity) to upload. As it can be seen from the picture below that the line breaks are occurring, how can I format such a file in excel, because the data loader or any CSV ...
3
votes
2answers
242 views

How to split a string by the newline character in Apex?

I wonder if it's possible to use the apex public String[] split(String regExp) method to split a string by the newline characters. The string being a csv file created on the Windows platform. I ...
0
votes
1answer
66 views

Error: Compile Error: Incompatible key type List<String> for Map<String,List<String>> at line 52 column 24

public class importSiteVisitFromCSVController{ public blob fileContent {get;set;} public string filename {get;set;} public List<List<String>> CSVlist{get;set;} /* ...
2
votes
0answers
64 views

Maximum view state size limit (135KB) exceeded. Actual view state size for this page was 137.641KB

I have a csv file who have 4000 records exists so it showing Maximum view state size limit (135KB) exceeded. Actual view state size for this page was 137.641KB Error on VFpage this is my class public ...
2
votes
2answers
59 views

Good practice in querying very large data from different objects inside batch process

Good day everyone, I have created an apex class which will save data from csv to account and contact object in salesforce. The concept of this class is that it will read the column in my csv and will ...
0
votes
1answer
51 views

Querying very large data without hitting too many query rows

Good day everyone I am trying to insert a new account and contact base on a data from csv file. The concept is that, when an account already exist I will not insert it. What I did is that I add Map<...
0
votes
1answer
32 views

csv not recognizing null on last line

The question is in regards to importing a csv into apex. The easiest way to explain this is to reference my debug log. In this log this is the test collection of 2 objects, account and registration, ...
3
votes
1answer
46 views

Upload .csv file to salesforce without converting its original encoding

I have created a functionality wherein I can upload a csv to salesforce. The problem I have at the moment is that when I try to upload an ANSI encoding, an error will occur 'Blob is not a valid UTF-8 ...
2
votes
0answers
28 views

how to create wrapper class so i can show two list data in csv

Header title show proper but its data not showing in proper format because two repeat i have applied, i want work only with one repeat this is my class public with sharing class ...
1
vote
1answer
28 views

Public and Private key Encryption in ANT

We need a solution for storing salesforce object's data as flat files in a S FTP folder as .csv files. But salesforce is not supporting to send files to S FTP/FTP. So we are trying to build a solution ...
1
vote
1answer
46 views

Using Test.loadData() for many level self-relationship data

I use loadData method very often in my test methods for custom settings and objects where lookup fields are not necessary for my case. Now, I ran into a situation where I need to create hundreds of ...
2
votes
1answer
87 views

Fahrenheit symbol (°F) causing “BLOB is not a valid UTF-8 string” exception

The requirement I'm working on requires to read a CSV file with temperature measurements. But Fahrenheit or Celcius symbols are causing exceptions when converting csv blob file to string using ...
3
votes
2answers
104 views

Issue while uploading CSV file with embedded comma within column

I am uploading CSV file using <apex:inputfile> in vf page. CSV file contains 4 columns. Scenario 1) When I try to upload a file without comma in any column, It gets uploaded without any error....
0
votes
3answers
44 views

Data Loader upsert with external id and opportunity id

Some of our opportunities are created in Salesforce and others are created in another system. I'm trying to make sure they all end up in both systems. When using upsert, in the data loader (just ...
0
votes
0answers
30 views

How to import contacts and opportunity records using npsp data import wizard

I am trying to upload contact that has opportunity in salesforce using npsp data import wizard. but when I try to upload my data, it successfully uploaded but when I click the opportunity record , the ...
0
votes
1answer
166 views

How to expose a CSV as a Webservice/odata for salesforce to show in lightning connect

We currently have a CSV file that is generated externally and this is is outside of salesforce, this is a master sheet and stored in a FTP and has details for all accounts together. We want to show ...
0
votes
1answer
72 views

Dynamic sObject to CSV class

I am trying to create a dynamic query to csv class that will take any query and convert it to a csv and send it back to the caller. I would like to use keith-c's format logic because it's way cool and ...
1
vote
2answers
76 views

How to assign leads to a campaign using der Data Import Wizard (for leads)

I want to import leads with a CSV-file and assign them to an existing campaign. The CSV contains a field 'campaign' with the name of the campaign. If you import the CSV with the Data Import Wizard ...
0
votes
1answer
245 views

How to create a new record from a CSV file attachment processed by the email service in salesforce

My requirement is that I need to create new records / update existing records based on the data from an email attachment consisting of .csv file format that is parsed to the Email Service that I've ...
0
votes
1answer
36 views

How to remove a data from a list

I got this CSV Data Debug: 15:40:47.129 (129957383)|USER_DEBUG|[77]|DEBUG|CSV:(Ticket__c:{First_Name__c=Mar, Last_Name__c=Roxas, Email_Address__c=maro@gmail.com , Status__c=Attended, Type__c=Non-...
3
votes
1answer
160 views

One day less than original date while uploading data in salesforce

I am importing data via a CSV file. In CSV file the date is 15/08/2015(dd/mm/yyyy) but when i check it in salesforce it is 14/08/2015(dd/mm/yyyy). The date is always one day less than original date. I ...
1
vote
1answer
42 views

Bulk Data Insertion that includes relationships

Good day everyone, I just want to ask your idea in regards with my problem. I am trying to read a data from csv and upload the data to salesforce. Below is an image of sample data in my csv. This is ...
0
votes
2answers
307 views

how to generate an excel sheet using apex code such that the excel sheet has proper table and data in order

How will I be able to generate a proper excel sheet with a proper table with data pulled from salesforce and applied in the excel sheet in a proper table with proper columns and rows. And also would ...
1
vote
2answers
136 views

how to highlight a cell in a .csv file using an apex code

Is there any apex code that a generates a csv file of data where a particular data is being highlighted or the background color of the cell where the data is present could be changed by the apex code ...
2
votes
0answers
88 views

Get first row of CSV data in salesforce and use for mapping

I want to get data from csv and upload it to salesforce. I use this link http://www.blueengine.com.au/?p=40#comment-271 and http://developer.financialforce.com/customizations/importing-large-csv-...
0
votes
0answers
110 views

Test class for http callout on documents

I have a class that makes a HTTP callout and gets the csv response and save it to the content in salesforce. Apex class: public class MYSQLCSV{ public Static void MySQLCSVContent(){ Http ...
0
votes
2answers
50 views

How to save a csv file to documents/content in salesforce

I have a requirement in salesforce through which I have to call a HTTP location which sends a csv in response. My question is Can I save it to salesforce on documents or Content so that the salesforce ...
0
votes
1answer
148 views

N>Help Optimizing Code to prevent “Apex CPU time limit exceeded” when saving

I got some code which is used to import csv, parse csv then save it in a custom object. My problem is when I try to save it to a custom object (using visual force) I finally reached an error of Apex ...
1
vote
1answer
31 views

csv file: error in uploading

I'm uploading Accounts in my org but the system doesn't let me do it. The values are separated by commas and at every end line there is '/r'. Why doesn't it work?
0
votes
1answer
50 views

CSV as Static Resource, Windows and newline characters not recognized

In our application we use Static Resources to store CSV files that contain record definitions. We have a CSV parser in Apex which usually works fine and correctly reads and upserts records when we ...
0
votes
1answer
55 views

Custom CSV Uploader save to lookup field with name rather than ID

I have put together a custom CSV uploader. I am uploading trees and one of the fields (Surgeon) is a lookup relationship to Contacts. Currently in order for it to work I need to have the ID of the ...
1
vote
1answer
283 views

How to download a file with remote action

I need to create a csv file based on passed parameters. I want to call my function from angular service using controller's remoteAction. How can I make the browser save the string output as a file?
3
votes
1answer
37 views

Custom Mapping Parameter File

This is kind of an odd scenario and I was wondering if anyone had seen anything like this before. We have a custom object called Financial_Account__c which stores information about our customers' ...
1
vote
2answers
269 views

Data Import Wizard: There was a problem uploading the CSV file. Try again, or choose another file

I'm trying to import a very simple .CSV file with the Data Import Wizard: FNAME,LNAME,CELL,EMAIL,SALUTATION,TITLE Andrea,Ianni,555-888-8888,aianni@example.com,Mr.,CEO Benedetta,Siniscalchi,555-999-...
3
votes
2answers
221 views

send a Report as a CSV/TEXT through HttpRequest

i am new to salesforce programming , and i am trying to send a file through HttpRequest to a 3rd party . the file i am trying to send is a report converted to csv format or text !! is there a way to ...
2
votes
1answer
59 views

Handling CSV content returned from a 3rd Party API

We currently have a contract with a vendor to provide a set of multi-language travel guides. The latest list of branded guides available can be downloaded via HTTP API call that returns a CSV file. I ...
1
vote
2answers
1k views

Not able to export query results to Bulk Csv

I have a SOQL query that I am able to run in eclipse, developer console and the workbench (as a list). Here is my query. The query is based on two standard objects - User and UserRole. Select u.Name,...
1
vote
1answer
381 views

Bulk Querying AccountFeed results in Binary field not supported error

While running the Bulk export in Java in CSV format, I get an error while the XML does not return error. I tried documentation which does not yield any results. Can I get specific error that relates ...
1
vote
1answer
312 views

Import CSV into Salesforce (Group Edition) automatically

I'd like to import CSV file into Salesforce automatically, e.g. once a day. I can't use Data Loader (Bulk API), because I don't have the needed edition. Is there any other, simple way?