Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
0
votes
1answer
33 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
51 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
44 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
119 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
0answers
12 views
Best Approach To Upload Big CSV to Apex Object
I have 2000 to insert into Standard object by importing the CSV using custom code only and than creating the csv and make it available for user to download to see passed and failed records. I am able ...
0
votes
2answers
268 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
46 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
225 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
142 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
32 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
107 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
112 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
144 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
190 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
0answers
11 views
CSV Deletion in marketing cloud via SFTP
I have an import coming into marketing Cloud on an hourly basis via SFTP, and I am wondering if there is a way to automatically delete that csv after the import occurs, perhaps within the hour? ...
0
votes
1answer
57 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
84 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
104 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
380 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 ...
0
votes
0answers
46 views
Can you send a csv file from salesforce to an FTP server? [duplicate]
I figured that it would be possible to send a file to an ftp server using apex, but I am having some difficulty getting the contents of the file to send over. The files are saved as ContentDocument ...
1
vote
0answers
322 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
262 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
97 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
346 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
49 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
186 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
298 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
504 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 ...
1
vote
1answer
528 views
Export Visualforce CSV with UTF-8 (With BOM) format
I am trying to export a Csv file from a Visualforce page.
I have the following:
<apex:page controller="CaseCSVController" contentType="text/csv#File.csv" showheader="false" >
This way I ...
0
votes
1answer
1k views
Salesforce Dataloader id value of incorrect type
I am having this issue with dataloader. I am doing an insert and I get an error:
id value of incorrect type: ABCD
Where ABCD is my value. I have 2 custom objects and CustomObject2. CustomObject2 ...
1
vote
0answers
60 views
Uploading CSV with accented/special Characters using VFpage
I'm currently working on a vfpage that can upload records using CSVs similar to this project. But, the records in the CSV may contain accented characters from spanish alphabet. So, when I attempt to ...
2
votes
2answers
859 views
Loop through comma separated values in Visual Flow
I have a process where a Photographer provides an Excel sheet with all the zip codes of the locations they're willing to take pictures in. Currently we have to massage and data load that data.
Is ...
0
votes
1answer
37 views
List of names (hundreds) - easy way to get Salesforce IDs?
I have a spreadsheet with a list of names - I would like to add an event to all their Salesforce pages using the data loader. It seems like in order to do so I would need their WHOIDs...is there any ...
0
votes
1answer
110 views
Unable to parse last numeric value while reading csv file from APEX
Here is my Controller function:
Public PageReference readcsvFile(){
try{
fieldList = New List<string>();
assignmentList = new List<AssignmentWrapper>();
...
1
vote
1answer
29 views
Detecting duplicate record on on Imported data
I am trying to import data from the csv file and I have to check if there are duplicate rows which has the same column values. I am having trouble coding it so I hope all of you may help me. Thanks
...
0
votes
1answer
63 views
4 columns in actual .csv file but only 3 headers are defined in the mapping sdl file: what does Data Loader do with the unmapped column?
This wil be such a noob question - I'm very new to Data Loader and SOQL. Just started a few weeks back for an ad-hoc project assigned to me at work.
I found a solution via vbs to build a .csv file (...
0
votes
1answer
383 views
VF Page export as CSV with asian file name
I have VF Page and I manage to export it as CSV file. However, when I try to name the file with asian characters (japanese, chinese etc ...) , it does not show.
VF Page:
<apex:page controller="...
0
votes
2answers
65 views
Getting Error while trying to upload image using CSV through data loader
Below is the CSV -
Below is the Error -
SOURCE: 'Body' DESTINATION: 'Body' ERROR:Body: value not of required type:
0
votes
1answer
552 views
Visualforce Content Type text/csv#filename.csv Renders on One Row
This visualforce page renders a csv but all the data is on one row. Where did I go wrong, how do I get a new row after every apex:repeat?
Note: The code below is on one line to prevent empty header ...
1
vote
1answer
158 views
Replacing \n outside of quotes
I'am trying to parse a CSV but the column names contain new lines and I'am struggling to find a proper solution.
If I have the following csv header for example:
"Column 1 \n(this has valuable info)",...
0
votes
1answer
268 views
Update Lookup Relationship using Bulk API and CSV
I'm trying to perform an update on our users using Python's Salesforce Bulk interface. Each account has a User ID field (UserID__c, External ID, Unique Case Insensitive) and a Parent ID field (...
0
votes
1answer
191 views
How to display number of records in .csv file import in visualforce page
How to display the number of records in .csv file import in the visualforce page. I am able to import csv file and display the records in VF page, but I don't know how to display the record count in ...
1
vote
1answer
656 views
JSON_PARSER_ERROR: Cannot deserialize instance of date from VALUE_STRING [duplicate]
I am trying to insert date from csv file into Salesforce (Sandbox for now).
I have a csv file that has this format YYYY-MM-DD hh:mm:ss.
Bottom is screenshot from a csv file.
I tried inserting into ...
0
votes
0answers
29 views
Parsing ERROR Ending position out of bounds: 255
Need some help with parsing csv thru apex . Below are the records i am trying to pass in csv but i am seeing an error : Ending position out of bounds: 255
1,,,"ABC,DEF",,"Robert, Thoma; (CFD)", ,Me ...
0
votes
2answers
33 views
Csv Parsing -Reading Data between Parantheses [closed]
I am a little stuck here , Need some advice please ,I have converted the csv file from blob to string and i have divided the file into columns successfully and put them into values ,
But i now ...
0
votes
1answer
509 views
CSV Date format for Salesforce Date (or Date Time)
I am trying to insert data from csv file into Salesforce (using Python file).
Bottom is portion of Python script to fetch the data from csv file and into Salesforce database.
for line in file:
...
0
votes
1answer
161 views
Import .csv to knowledge using Import Wizard
I am trying to import .csv file to SalesForce Knowledge.
First Question : I cannot find the "Knowledge" option in "Custom Objects". When I goto Data Import Wizard,I should be able to see this. Am I ...
0
votes
1answer
189 views
getcontent() method not working, while generating the CSV file , no data (content) exit in csv
I'm trying to create a csv file attached to a visualforce email template.
When i comment "strOut = new PageReference(requestURL).getContent().toString();
"
then it generate a CSV file with no data.
...
0
votes
1answer
212 views
want to hide first column while exporting data to csv
want to hide first column while exporting data to csv;
Am using this code: plz help me out:
<script type='text/javascript' src='https://code.jquery.com/jquery-1.11.0.min.js'></script>
...
0
votes
1answer
342 views
generating a large text file (similar to a CSV but pipe delimited)
I need to generated a CSV like file (pipe delimited) that will contain tens of thousands of lines where the final file might be larger than 5MB or might incur in SF limits. Is there a way to get ...
