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

learn more… | top users | synonyms

0
votes
1answer
33 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
15 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
19 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
27 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
31 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
0answers
26 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
63 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 ...
3
votes
2answers
48 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
39 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 ...
0
votes
2answers
66 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 ...
1
vote
1answer
50 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
90 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?
0
votes
0answers
18 views

Why are contacts(multiple) being created when importing Leads usng Import Wizard

I am having trouble importing my Leads using a CSV file. I have created all the correct columns for the mapping to match up on the leads page layouts. For some reason some of the leads(not all) have ...
1
vote
1answer
61 views

How to dummy mass update via Apex Data Loader?

I built a trigger on Object 1 which has a field, field1 which when updated will calculate another field, field2 in same object (had to use trigger for it's complexity). Now my question is that field1 ...
0
votes
2answers
40 views

Exception when Importing .csv file from CLI

I am able to import my .csv file using Apex Data Loader. When I try importing the same file from CLI I am getting an exception attached in the file. When the file contents are copied into a new csv ...
0
votes
0answers
21 views

Duplicate projects getting replaced with new Site ID's

I have a controller which uploads the csv file. In the csv file, there are 7-8 columns. The concern part is only Column [0] and Column [1]. Column [0] has Site ID and Column [1] has Job No. Now this ...
0
votes
1answer
57 views

Create Accounts and Contacts from single csv import

I have limited experience with the Data Import Wizard but I'm curious if it allows me to create new accounts and contacts from a single csv import. Rather then importing accounts from a csv, ...
0
votes
1answer
16 views

How to save a list of leads who opened a mailing to Salesforce?

I'm feeding data to Salesforce through a CSV using APEX. This works great to update the database, with new leads and updating lead information. I'm interested on also transfering lists to Salesforce ...
0
votes
2answers
48 views

Collect Child record fields into a CSV field on a parent

Because reporting on Opportunities with Team Members add rows for each member, I'd like to collect Opportunity Team Members into a single field and display them on the Opportunity Object - for ...
2
votes
1answer
234 views

Is it possible to populate a field of type Auto Number External ID?

I'm trying to populate a Lookup using External ID which is Auto Number field. It is giving the error: Compile Error: Field is not writeable: Opportunity.Opportunity_Number__c Opportunity_Number__c ...
0
votes
0answers
73 views

Importing an orders detail into a custom object via CSV file

I created a custom Object in sales force which I am calling past_orders . I then added a bunch of fields such as Sku, itemname, qty, itemprice, billingfirstname, etc. I then go to the Data Import ...
1
vote
2answers
1k views

Import excel csv data using apex class

I have an excel file with a lot of records, and I need to import these records to a salesforce object by implementing a class and a visualforce page in order to use it in the future if needed. So, I ...
0
votes
0answers
220 views

How to customize Date format in Exported CSV from Visualforce?

I'm trying to build an export to CSV Visualforce page with dynamic fields that may include Date/Datetime fields in the output. The trouble coming in my way is, if I don't format date/datetime fields, ...
0
votes
1answer
311 views

Display CSV data on a Visualforce page

I want to read in a CSV file and display the data as a table in a VF page. So for example my file might look like this: Name, category, description, Priority, Type, Status, Number, Issue11, Decision ...
1
vote
1answer
114 views

Regex to validate a generic CSV

I have two questions in order to make a custom csv importer in VF/Apex. I saw many samples out there but I'm not able to find validations samples. 1) I would like to know if is any regex to validate ...
1
vote
1answer
94 views

Order of Bulk API result rows

I am performing multiple batch upserts using the Bulk API using an external ID field from my system. In order to determine which record ids from my system failed, I'd need the results rows to ...
5
votes
7answers
213 views

Recurrent CSV import?

We have a client that will give us a .CSV with accounts once a week. I'm wondering how to automate the process of getting this data into SalesForce. I've been told it can only be done through Open ...
2
votes
1answer
177 views

renderAs CSV (10K+ rows): What are the best practices available to avoid hitting Apex cpu time limit exceeded limits?

I am trying to download a CSV using render as attribute in apex:page. The output data that is rendered is the real-time response from a callout from salesforce to SAP webservice. The number of records ...
1
vote
1answer
597 views

CSV created with first row as empty. Any suggestions please

i am trying to create a csv and succeeded in that except with a new empty row has been added on the top of the csv. The following is the visualforce page code for the generation. Also, i need to use ...
1
vote
1answer
112 views

Is that possible to generate and download a csv or xls on the fly without using “contentType=”text/csv#Export.csv"

I already tried to generate a csv of my list by create a separate vf page with the page attribute contentType="text/csv#Export.csv" Is that possible to generate and download a csv on the fly ...
3
votes
2answers
7k views

How to use TableTools plug-in for DataTables in Visualforce page?

i am trying to use TableTools plugin for the datatable to export the data that is being displayed in the table as CSV, Excel, etc. Though i included the plugin inside of my code it still did not ...
1
vote
2answers
331 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. ...
2
votes
1answer
333 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
1k 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?
2
votes
1answer
469 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
369 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
838 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
91 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
229 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
1k 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
135 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
215 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
2answers
3k 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
1k 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
522 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
116 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
2answers
1k 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
4answers
3k 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
3answers
2k 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
328 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 ...