Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
22 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
31 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
33 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
24 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
43 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 ...
2
votes
1answer
39 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
72 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
29 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 &#124; For example, if csv headers are contained in the list shown ...
0
votes
1answer
24 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
23 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 ...
0
votes
1answer
79 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
1answer
44 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
28 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....
0
votes
1answer
23 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
39 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
1answer
33 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
22 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
40 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
92 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
49 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
115 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
46 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
33 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
24 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
34 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
131 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
37 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
49 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
54 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
50 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 ...
1
vote
1answer
1k 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
36 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
293 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
25 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
39 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
60 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
40 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
49 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
118 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
307 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
535 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
205 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
241 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
540 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
263 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
556 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
388 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
2k 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
1k 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
149 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
2 3 4 5