Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
200
questions
0
votes
1answer
45 views
Identify records in data extension from CSV file [closed]
I am trying to identify a series of records in a data extension.
I have a CSV file containing all the records that I want to identify in ly data extension but I don't know to proceed to clearly ...
0
votes
1answer
40 views
CSV file string parsing by newline error
I'm trying to write unit tests. The unit tests have input of a stringed csv file. So I'm having csvFileDataAsString as the simulated input.
String csvFileDataAsString = 'Column1,Column2,Column3\...
0
votes
2answers
39 views
Exclude Subscribers from a CSV file in Marketing Cloud
I have a CSV file containing duplicates contacts.
We would like to identify those duplicates in our DE to exclude them in an email send.
Do you know any solution for this issue?
Thanks,
Grégoire
0
votes
1answer
30 views
Batch Generated CSV attachement is cut
I designed a Stateful batch to some data and send it as CSV via email.
And I don't know why but the attachement received in the email doesn't contains all the expected data, the CSV file il cut in the ...
0
votes
0answers
14 views
Custom CSV Upload. Issue on getting Record's as separate row (missing /n on conversion)
I created a custom CSV file upload functionality in lightning component. I am converting the CSV file as string from component controller and passing the string to apex controller (using file reader ...
0
votes
1answer
30 views
How to create upload button
I'm creating a Salesforce interface that lets user fill in a form and assign those values to objects' fields.
My form is mostly based on this tutorial: LINK
I want to create an upload button, so ...
-2
votes
1answer
57 views
Batch Apex - Error related to Heap Size while Reading CSV [closed]
We have a batchable Apex where we read two CSV attachments on a custom object and we perform various operations on Accounts and Addresses that the CSV contain. The problem is when the files are a bit ...
1
vote
1answer
26 views
Bad data notification without stopping automation
I have an automation that imports a csv from an external SFTP and processes it by splitting and augmenting the data into 2 data extensions. There is a chance that some rows in the original csv might ...
-2
votes
1answer
45 views
I am not able to scheduling the below code
When I am trying to schedule this below code:
global class exportReport3 implements System.Schedulable {
global void execute(SchedulableContext sc) {
ApexPages.PageReference report = new ...
0
votes
0answers
30 views
Exceeded max length for one record data loader
How can I spot which record exceeds the limit shown by data loader when I try to insert the CSV in my 'to' salesforce environement?
The same files export fine in my 'from' environment.
I have tried ...
0
votes
0answers
35 views
First item in Map returning null when getting key value while iterating through List
I'm building a List<String> with the column header row from a CSV file to iterate through and get the API value from a Map<String,String> that is built from custom metadata.
The issue I'm ...
0
votes
1answer
121 views
Most robust way to parse CSV file via Apex code
I have been tasked to create a batch apex loader which parses a CSV file from an email attachment.
I will use an email handler to get the email with the CSV file attached, and then I will try to load ...
1
vote
1answer
35 views
first key of map is dissapeared
CSV File contains headers. Full Name - is first column header, Manager Email - last column header.
after file input, i create map that contains
rowIndex (for VF apex:repeat), 'Header'='Value' (Map)
...
0
votes
1answer
108 views
Insert Salesforce record from CSV using Lightning component
I have one excel with SFDC label Name, as a header and their corresponding records, and using lightning component I need to Create record from that.
My Approach :
I am taking the input in apex from ...
0
votes
0answers
16 views
Problem with annotations.csv in Einstein Object Detection
When file "annotations.csv" is uploaded in the correct form, Einstein reads only one, unique label even if there are a couple of them in the same picture. For example when I upload a file like this:
...
0
votes
0answers
32 views
What is file type of Bulk Data Load Jobs results-file while importing data through Data import Wizard?
New to Salesforce.I imported a certain .csv file into Salesforce through Data Import Wizard, when I clicked on data batch reports, a file named 'reports' was downloaded. But not sure or clue what type ...
0
votes
0answers
35 views
Aura component upload csv with special characters
Need to upload a csv file with the following values
Australian Children’s Education and Care Quality Authority (ACECQA)
we need to find the exact location of the special charter and only process the ...
0
votes
1answer
26 views
Process an existing spreadsheet and output it in excel [closed]
I have a requirement where I need to store an excel workbook (with multiple sheets) in salesforce. Most probably in static resources or salesforce documents. Then when I click on a button on the ...
0
votes
2answers
46 views
Possibilities of integration with SFDC
We need to upload daily data from the customer database to Salesforce. We had planned scheduled night loads.
One option is with csv files. For these loads, if the server is
Windows (I think it is ...
0
votes
1answer
73 views
Upsert using relationships
I have a custom object Relation__c which has two fields a__c and b__c both are lookups to the standard Account Object.
The Account object has an external Id field called z__c
If I have to use Bulk ...
1
vote
1answer
183 views
Unable to download CSV File from javascript
I have created a custom button. When user click on that button, it will redirect to a visualforce page. There I have written some code to download CSV file.
Code:
const rows = [
...
1
vote
1answer
274 views
Data Extension CSV export not working correctly
I'm currently transferring some data from an old BU that's being depreciated to a new one. As part of this I've recreated a data extension and am now attempting to export the data from the previous/...
0
votes
1answer
108 views
Formatting Excel Column from Apex
I'm sending an email through the batch class with CSV file as an attachment, but the data alignment is wrong after generating CSV, I want the same alignment for all the columns. Please check the ...
0
votes
2answers
148 views
Parse CSV fields in vf and map it to the respective sobject fields
I need to read header column of csv file and those fileds i have to display in vf page.
And those filed i shuld be able to map with the salesforce object . After mapping, insert/update the csv record ...
-2
votes
1answer
320 views
load a file and read the information
I want to open an Excel file through an Apex dialog box, then browse the information in my file line and display it with visualforce.
I show you my code
public class ImportExcel {
public String ...
0
votes
1answer
160 views
InvalidDecimalScale SFMC CSV data import
Anyone run into an InvalidDecimalScale error in the SFMC CSV data import?
I came up with a contrived example to test. I made my data extension super simple:
It's a data extension with three fields. ...
0
votes
1answer
326 views
Batch class to create a CSV file
first of all, thank you for your cooperation, right now I'm having problems changing my class to a batch class, the class that I will post below works, it creates a CSV file on "SageExtractFiles__c" ...
0
votes
0answers
303 views
How to remove double quotes from CSV
A .csv file I have imported via FTP (too large to manually upload) is wrapping several of the contained columns values in double quotes. When I review the file in Excel the quotes don't exist and the ...
0
votes
1answer
1k views
Parsing comma separated data from the cell of csv file and storing into object
I am trying to parse a csv file and inserting data into custom object. One cell of csv file having comma seprated values.
This cell is not getting processed successfully.
public string fieldSetName;
...
0
votes
2answers
993 views
How to parse CSV file in lightning Javascript
Currently I had built a file upload functionality in Lightning component which accepts the CSV file, read it as text(Each row in CSV is split using \n and each column in the row is split using ,). ...
1
vote
1answer
110 views
3rd Party load CSV into Marketing Cloud
I'm looking into a solution to allow a 3rd party to load a CSV into Marketing cloud.
The solution we're converging on is building a page, with a browse-save file dialog. The 3rd part can manually ...
1
vote
1answer
1k views
How do I upload csv files to Heroku Postgres? [closed]
I have a very basic question. I created a Metabase Heroku app:
http://walmart-store-sales-forecast.herokuapp.com
I see that there's a sample dataset. I want to be able to upload csv data from https:/...
0
votes
2answers
577 views
Junk Characters in excel
I exported my client's data as .csv file but when i open it in excel then it will show junk characters for Blank spaces after any character like below
but in csv file blank spaces treat same as blank ...
0
votes
1answer
62 views
Get only specific values from External CSV File
I'm struggling to find out the best solution to the following scenario:
I have a big static csv file containing data not related to salesforce. I would like to get a specific value on my csv file and ...
2
votes
2answers
207 views
Read through small CSV file returns Regex too complicated
I have a method which reads through a CSV file and if any of the columns match my keyset prepares them in an sObject, with my test files which contained 1,000 records but only 4 columns this worked ...
1
vote
2answers
339 views
Content Notes from CSV not uploading via Data Loader
We are attempting to upload a CSV containing local drive links to text files and html files. We want these to become "Content Notes". Data Loader keeps throwing errors when we attempt to upload (see ...
2
votes
1answer
253 views
Data Loader converting & to & and throwing error
I am trying to load a csv file (encoded as UTF-8) into the salesforce Data Loader. One of the values in the csv file is a string reading "Biotechnology & Science". When I try loading the csv file, ...
0
votes
1answer
492 views
Automating CSV Uploads into Einstein Analytics with Wave DatasetUtils
According to this Trailblazer Community Post, the Wave DatasetUtils tool can be used to automate csv uploads into Einstein Analytics (the user lists this option alongside automating via Apex). ...
0
votes
1answer
114 views
How to convert csv into tabular form
I have a csv stored into a String named csv in controller. I have passed this string to a javascript function.The original string(in controller) had line breaks but when I download the file it is ...
0
votes
1answer
274 views
Is there a CSV template for Contact Import
I want to import my customer list but I'm not sure what the correct ordering of fields should be. Is there a CSV template I can use to export my data and then import it into Salesforce Essentials?
0
votes
1answer
174 views
Why my csv file is blank?
I try to pass on a list to a new visualForce page and then display that list as a table to download as a csv file. But I am getting blank csv file. As soon as i redirect to my new page the list gets ...
1
vote
1answer
891 views
Setting parent id of attachment object
I'm trying to write an Apex class that queries data from an sObject and then writes that data to a csv file that is downloaded locally so that it can be uploaded to a big object. I'm adapting the ...
1
vote
0answers
457 views
Marketing Cloud - importing file (csv) to data extension errors
I have a few issues moving data from a csv in an external FTP to a data extension using the file import activity.
CSV files without data (but with headers and proper associated fields in the DE) ...
0
votes
2answers
864 views
bulk api text/csv CRLF error
So I recently completed trailheads API trail and for practice, I am trying to insert Product using bulk API
For Creating Job, I've sent following json as the request body
{
"operation" : "insert",
...
1
vote
0answers
166 views
Headers with Double Quotation Marks
We are trying to import a file to a data extension in SF marketing cloud via a csv file.
The data comes from another database, which add's double quotation marks around the header fields as well as ...
0
votes
2answers
768 views
Handle Extra “\r\n” new line in CSV from code level
I'm using the following code to Parse CSV file in Apex:
public static List<List<String>> parseCSV(String contents,Boolean skipHeaders) {
List<List<String>> allFields = new ...
0
votes
1answer
57 views
Broken CSV exports
I've exported several csvs to ftp from synchronized data extension and it appears that they are broken (ie. there are blank rows or certain rows that bleed into the next row.
Wondering if this is a ...
2
votes
1answer
368 views
Email Attachment (CSV) Issue
I have created a batch that will copy some event fields to a csv and attach it to an email. The problem I have is that I failed to replicate some characters (• bullet point, in this case) from the ...
0
votes
1answer
520 views
CSV file column validation
I've implemented an apex algorithm to upload a CSV file into Salesforce.
In the CSV file there are 7 necessary columns and I keep all of them in a list of strings:
private List<String> ...
1
vote
0answers
802 views
CSV Download Button in Lightning
I have created a 'Download csv' button through lightning page.When I click the button and choose the user from the dropdown for whom the related list be downloaded.The entire list according to the ...
