Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
228
questions
0
votes
0answers
13 views
Upload csv files to Firebase Cloud Database [closed]
I have a client that requires to upload internal SF report files as csv to a Firebase Cloud Database. I know how to generate the .csv but I've never worked with Firebase inside SF and I cannot find ...
0
votes
1answer
21 views
How to exclude leads from an imported .csv file regarding to their job title or any other attribute?
Hello!
I am trying to automate the lead importing process to save some time. Usually what I do whenever we have a list of participants to virtual events (.xlsx), is a VLOOKUP command to find duplicate ...
0
votes
0answers
4 views
How to perform restore sobject operation and verify it ? For me it gives the below error when checked for successfulResults
I created a job to perform restore operation of the Account sobject's sub-object like Account ->TestAcc, when I passed a modified csv file as payload , it shows 201 created status which says the ...
0
votes
0answers
29 views
Upload csv files from ftp into SF via Apex (without insertFile Tag) [duplicate]
I want to automatically upload csv files into Salesforce on a regular basis, doing a scheduled job. I want to have this job centralized so that everybody has access to the code and the process. I want ...
0
votes
1answer
17 views
In my aura component CSV export, double quotes break the export
I have an aura component that exports a list of cases to a CSV. In the description field, customers have been inserting double quotes in the field (example "variable") which breaks the ...
0
votes
0answers
96 views
Einstein Analytics Data Preparation CSV symbols error
in my prep for the SF Einstein certification I've been working on the "Einstein Analytics Data Preparation Specialist" super badge.
I'm on step 3 and I'm getting the following error:
I've ...
0
votes
1answer
77 views
Convert list of object to CSV string
I'm using the d3 library trying to do a geo chart with LWC. To do so I need a csv file with my values in it like the example bellow
var promises = [];
promises.push(d3.json('d3js/map-population/...
0
votes
1answer
74 views
Issue with Export to Csv when name consists of comma
we are trying to export data into csv file using Apex and Visualforce page in Salesforce .
The data is being exported but we have an issue .
Here we are exporting record from an object(Text Fields) .
...
0
votes
0answers
116 views
Empty Column in Csv , when exporting data as csv using Lwc component
I'm very new to salesforce and lwc , i'm trying to Export some static and some dynamic data in a csv using LWC Salesforce and succeeded in that( except with a new column has been added from the
...
0
votes
1answer
56 views
PapaParse - Want to ensure Chunks processed in sequence. Apex response need to fire next processing sequence
How can i ensure when first Chunk inserted in SF then need to fire second chunk to make sure sequential processing? I am able to chunk the records in SF and format accordingly but need to insert ...
1
vote
1answer
33 views
Email Attachment as CSV issues
if I run this code in developer console, I receive the attached csv in an email. However the output of the code is javsscript code instead of the data
String ReportId = '00O3300000331x3XXX';
...
0
votes
1answer
103 views
Convert XLSX into CSV in Apex [closed]
We are having some hard time converting a ContentDocument of type XLSX into CSV inside Salesforce APEX code. What we are looking for is a way to convert the stored XLSX file into SF to be converted ...
0
votes
1answer
20 views
CSV with autofit column from lightning component [closed]
I am exporting csv from lightning component.
But I need to ensure that column in autofit as per the column data when downloaded.
Thanks
-3
votes
1answer
107 views
How to format Excel Column in Apex? [closed]
I'm sending an email via scheduler class with an excel file as an attachment, but the data in the file does not appear to be in proper format. Please check the following image:
The code I'm using to ...
0
votes
0answers
36 views
Inserting bulk records from CSV on an object and capturing error rows
I am working on parsing CSV file to insert bulk records on an object (OBJECT 1)and populate two lookup fields(OBJECT 2 & OBJECT 3) on it. If the lookup records are already present in the database ...
0
votes
1answer
25 views
CSV date probelm
I am creating the CSV using the batch code.
Here is the code
Date testDate = 07/08/2020;
String monthOfTheDate = testDate.month()+'';
String dayOfTheDate = testDate.day()+'';
Integer monthSize = ...
-1
votes
1answer
32 views
string.isempty doesn't appear to work when trying to retrieve price list Name
it appears my if statement with String.isEmpty doesn't seem to be working. What i want it to do is check if a price list entry doesn't exist it creates a new one, and if it does it updates that one. ...
0
votes
1answer
42 views
Not Able To Update Price Entries
I am trying to insert products, then those products then create price entries if they don't already exist but if they do exist they update the previous price entry based on the name of the product ...
0
votes
2answers
25 views
Best way to convert SOQL when doing an import of data
I was wondering what would be the best way to convert the below code ,which is importing price book entries, so it doesn't hit the governor limits.
for (Integer i = 1; i < csvFileLines.size(); i+...
0
votes
2answers
153 views
How To Check For Duplicates Using SOQL and Apex
I am currently developing a csv importer for our Salesforce to deal with our way of quoting items, and I am currently trying to make it so that if the product has been added in, it detects whether ...
3
votes
1answer
96 views
Dynamic csv generation for a dynamic soql query in apex
When constructing a csv via apex how do we avoid hardcoding the recordString assignment within the query loop?
Note I have a dynamic List<String> fieldsList that represent field names. For ...
1
vote
1answer
670 views
How to parse large size csv file content into custom object in Salesforce?
I have requirements to implement the LWC file upload wizard which should handle very large size csv file( about 1 GB).. is it doable to parse such large size csv through APEX batch method?
I tried ...
0
votes
0answers
107 views
Pipe delimiter to generate CSV programmatically in apex
I am trying to generate CSV file with the pipe | as delimiter but the issue that I am facing is it is converting separator into |
For example, if csv headers are contained in the list shown ...
0
votes
1answer
47 views
What is the difference between supported Salesforce, Apex, and Dataloader text encodings?
If I export a file of Custom_Object__c with a Custom_Field__c (developer console and salesforce page layout displayed) value of:
XX – XYZ
I receive an exported CSV with:
XX � XYZ
If I open that ...
0
votes
3answers
46 views
Display Info Message First and then display Error Message on Visual Force Page through Apex
I am using an import CSV functionality using Visual Force Page and Apex through Quick Action Buttons.
I would like to show two messages.
First is INFO Message "CSV Imported, if any errors are ...
1
vote
1answer
699 views
Parse JSON to CSV and vice versa
I am converting an array of JS object to CSV by using below code
downloadCSVFromJson(filename, arrayOfJson) {
// convert JSON to CSV
const replacer = (key, value) => value === null ? '' : ...
0
votes
2answers
170 views
Encoding and Decoding BLOB due to error 'BLOB is not a valid UTF-8 string'
I try to encode and decode a BLOB in order to avoid the 'BLOB is not valid UTF-8 string' error, but when I encode the BLOB in UTF-8, decode it again and use the .toString-method, I stil get the error. ...
0
votes
0answers
46 views
Even after having the value in .csv file last column , apex is taking it as null and not able to insert that last column field in object
CsvAttach__c csv=new CsvAttach__c();
String[] fieldsData=readArray[1].split(‘,’);
For(Integer j=0;j<2 ;j++){
if(String.isNotEmpty(fieldsData[j] && field[j]==‘Subject’){
csv.put(Schema....
1
vote
1answer
104 views
URL to export to csv with parameters doesn't work anymore in Lightning whereas it works well within classic
we use a url like this one to export data from a SFDC report to CSV, by sending parameters :
https://www.salesforce.com/?pv0=123&pv2=1/1/2020&export=1&enc=ISO-8859-1&xf=localecsv
...
0
votes
0answers
40 views
CSV format issue
Here is the current code. I am expecting the 0000 value in my CSV file but it is printing only 0. Can anyone help with this?
fileRow = fileRow +','+ '"' +0000+ '"'; // Here I am expecting 0000 value ...
0
votes
2answers
58 views
CSV File Date Issue
Can anyone help me with this?. How to extract the time from the date field and also the date format while creating the CSV file in the batch class. Please find the below code.
String fileRow = '';
...
0
votes
0answers
25 views
Find Accounts without Attachments
In a CSv file I have a list of AccountId's. I am trying to determine the best way to find if these Accounts have an Attachment.
One Approach that come to mind is this -
Write an Apex script to ...
0
votes
1answer
156 views
Dataloader = CSV = Numbers = Scientific Notation
Dataloader requires CSV Files. When I convert my files to CSV it changes the numbers to "Scientific Notions":
Before:
After:
Then they show up in Salesforce as Scientific Notions "4.90001E+11".
...
0
votes
2answers
314 views
Problem with CSV file format from Marketing Cloud SFTP
I don't know if someone will be able to solve my problem but let's try it anyway.
Here is my situation :
I have an automation that contains a filter activity (step 1), a data extract activity (...
0
votes
1answer
60 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
259 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
60 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
36 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
1answer
85 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
288 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
44 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
55 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
122 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 ...
3
votes
2answers
3k 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
39 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
584 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
59 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
1answer
86 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
53 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
211 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 ...
