Questions tagged [data-loader]

The Salesforce Data Loader is a software application that can be used to insert, update, or delete Salesforce records from a CSV or export Salesforce records to a CSV.

Filter by
Sorted by
Tagged with
0
votes
0answers
33 views

Recognize Whether an Update is Via the API and which Fields Are Mapped

Once a month I update a couple of currency fields on accounts via a data loader. There are two corresponding date fields that show, after workflow-rule updates, when the previous fields were last ...
0
votes
1answer
146 views

Data migration when external Id is not unique on the detail object

We are migrating records from one org to another org and I ran into this scenario. Background: We have two objects with master detail relation between them and API names are Master__c and Detail__c ...
0
votes
1answer
40 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
130 views

Change display of Record “Name” Field

I'm importing all my data via dataloader and have the Object's record field setup as a "Name" (text). The problem is that the name generated by salesforce is a long ugly string (ex: a0mc0000003bNBi). ...
0
votes
1answer
435 views

Program Batch Process in Data Loader

I'm looking for set an automated time-based batch with Data Loader.. So, i've followed these steps: https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/command_line_intro.htm ...
0
votes
0answers
45 views

groupmember option missing using dataloader

Unable to get groupmember object using dataloader. Although chatter related groupobject is visible.Is that a api version issue.
0
votes
1answer
76 views

Macro instruction object not available in data loader in my DE. Why?

I had Created 1 macro with six instructions. In developer console I queried in query editor working fine see below.But in data loader there is not available Macro instruction object in Developer ...
0
votes
0answers
317 views

Set Negative Values on Currency Field while loading data with dataloader

I am trying to upload the data using workbench. The file contains columns as Id, currencyField. Here is the sample: ID Column1 | CurrencyField Column 2 XXXXXXX | 1234.33 YYYYYYY | -5678....
0
votes
2answers
852 views

Multiselect picklist - dataloader

When am trying to update contacts using Dataloader then multiselect picklist values for existing records gets overridden.I want values to be added to current multiselect picklist without overriding ...
1
vote
0answers
2k views

How to solve “Error: Check your username and password. If you still can't log in…”

Today I am having problems logging into Data Loader. I am using version 40 of Data Loader and using my admin profile user, I keep getting error message: Error: Check your username and password. If ...
0
votes
1answer
426 views

Create a SOQL query by retrieving the field names

I am using data loader from command line to extract data in csv format. I have to hard code the SOQL query in the sfdc.extractionSOQL property. Is there a way to get the field names dynamically and ...
0
votes
1answer
313 views

Before Insert Trigger Not Deleting The records

Here's the scenario: I've a custom object (ObjectA__c) with only one custom field Email_Address__c (which can be unique). Now I would be inserting new records using Data Loader such that: 1) If ...
0
votes
1answer
111 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 (...
1
vote
2answers
240 views

Data loader to insert data

Iam trying to upload data into custom object called "Migration" and i have Process on this object in process builder.i tried to insert 350 records into Migration using data loader.If i insert with 10 ...
0
votes
1answer
103 views

UserPreferencesHideS1BrowserUI field not visible in data loader

I can run soql query as below, but cannot find UserPreferencesHideS1BrowserUI in data loader. Is their another field i can use in data loader for this purpose? Select Id, ...
2
votes
1answer
286 views

Creating relationships between custom objects with data from dataloader

I've been going through this for nearly a week and can't figure it out - any ideas are appreciated. I'm trying to create a relationship between two custom objects that will eventually be populated ...
0
votes
0answers
46 views

Getting error during data upsert operation

I am doing data upsert operation in my org. There are around 40k records being userted. But during the operation i am getting error as shown in below screenshot: My data loader settings are as ...
1
vote
1answer
693 views

External Id is not showing up in data loader field mapping

I am trying to insert Junction object data based on External Id of the Contact. I have created an external id field as follows on Contact object: Name: External Id API: External_Id__c DataType: Text(...
0
votes
2answers
105 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
3answers
241 views

DataLoader reading string 2800E3 as scientific notation

We are migration a Dynamics environment to SalesForce. The majority of our data is migrated through DataLoader. Right now we are facing a issue with strings like 2800E3. Records containing this ...
0
votes
2answers
361 views

Data loader on custom object, Object ID not available in field mapping

Colleague has the same 'Admin' profile as me. If I try to update data via the data loader I see all fields, if he tries he can not see the custom object id but can access the object? Note this is ...
0
votes
1answer
39 views

How to migrate Opportunity Team Members Records?

I want to migrate Opty team members using Informatica cloud. I did mapping but when i ran the job it is not updating OpportunityAccessLevel accurately. It updates with Read access although from source ...
0
votes
1answer
197 views

Insert using Bulk API throws error MISSING_ARGUMENT:fiedXXX__c not specified:--

An external system is using bulk api to insert records in Salesforce. Salesforce throws an error saying - MISSING_ARGUMENT:fiedXXX__c not specified:-- where XXX is external Id of Parent of the ...
1
vote
2answers
478 views

How to automate data import on full sandbox refresh

I am involved in doing QA in a stage full sandbox environment. I am interested in being able to populate the sandbox with a small amount of consistent (I cant rely on production data) test data. Is ...
0
votes
2answers
408 views

Trigger Error: too many SOQL queries

I have developed following code for apex trigger and it will work when i am going to insert bulk data from the data loader, Trigger: System.LimitException: Too many SOQL queries: 101 I read some ...
0
votes
1answer
76 views

Upload events recurrence end error

When I try to upload events via the Data Loader I receive the following error "Select an end date on or before 17/02/2020.: Recurrence End" in the csv file. The RECURRENCE START DATETIME is 2015-03-...
1
vote
2answers
168 views

Assigning owner to ContentNotes

I am trying to assign the OwnerId to ContentNote (Notes) using Data Loader on new inserts, however I get the following error: Documents in a user's private library must always be owned by that user....
1
vote
2answers
2k views

Delete failed. First exception on row 0 with id xxxxxxxxxx; first error: ENTITY_IS_DELETED, entity is deleted: []

I am trying to Upsert bulk records in Custom object using dataloder. I got error like: FATAL_ERROR|System.DmlException: Delete failed. First exception on row 0 with id xxxxxxxxxx; first error: ...
1
vote
1answer
1k views

Data Loader for Professional Edition Salesforce That Does Not Use API?

I am working on a project to clean out old tasks and would like to be able to export all tasks including those which are archived and then upload a list of activity IDs for the ones which I would like ...
0
votes
1answer
1k views

How can I change where the Data Loader success or error files are stored?

When I first ran the Salesforce Data Loader it asked me where it should store the success and error files. I'd like to change that location now. How can I do that? It's not under settings. I've tried ...
0
votes
2answers
180 views

Sandbox dataloader

When I login to data loader through sandbox it is throwing the below error: Invalid Session ID found in session Header Can anyone suggest me in sorting out this? This is working fine through my ...
0
votes
2answers
1k views

Field integrity exception updating with data loader

I'm facing an exception when updating 100 Products using Data Loader, it reads: field integrity exception: unknown (0068000000yNrDl|1|538115.4|540365.4|73|74,)" Context: The format of the error ...
1
vote
1answer
341 views

Can we use '|' Pipe delimiter for command line data loader interface

I have a huge data file, but it is "|" (Pipe) separated, not comma. I have to schedule a dataload job with using data loader command line without any manual intervention, completely automated. I ...
1
vote
0answers
416 views

Challenge when inserting records that has lookup field(that uses external Id of parent record)

In my scenario , I am loading records of object xyz__c in my system. This xyz__c has a lookup field that refers to abc__c object. I am loading records using an external system. It maps the fields on ...
0
votes
1answer
368 views

Importing the data using command line data loader for multiple objects is possible by adding multiple beans (process.xml)?

Importing the data using command line data loader for multiple objects is possible by adding multiple beans in process.xml ?
0
votes
0answers
33 views

Examining A Data Load's Tentative Results Without Really Loading Data

Let's say I have a "Contact" object full of 50,000 records, 30,000 of which have a value in "MyExternalId__c." And then I have a CSV file full of 10,000 records, all of which have a value in "...
1
vote
1answer
160 views

What is is the purpose of database-conf.xml and process-conf.xml?

What is is the purpose of database-conf.xml and process-conf.xml and how does the two compare with each other for Salesforce Dataloader?
1
vote
1answer
677 views

Data Loader Command Line Extract Issue

I am working on extracting the Partner data from Salesforce using the Data Loader using the command line. I have done upserts using the Data Loader command line however I seem to be running into ...
0
votes
1answer
1k views

End of line with CR+LF when downloading data as CSV from Salesforce

When I download the Case records using Salesforce Data Loader, the downloaded CSV contains records which are terminated with CRLF (carriage return + LineFeed). And if any record is in multi line, then ...
1
vote
1answer
416 views

Command Line DataLoader Mapping constant and column value to Salesforce field

In the mapping file for command line data loader we can map column name to the salesforce field BillingCountry=BillingCountry or a constant value to the salesforce field "United\ States"=...
2
votes
0answers
94 views

Can't Resume Flows

I have several Process Builders and a couple directly-written Flows in our Org. I'm currently data loading 275k records over the weekend. Estimates show it should be done (if I don't find it stopped ...
0
votes
0answers
195 views

Insert Opportunity, Quote, QuotelineItem, Asset in single upload using data loader

I have exported csv file of Opportunity, Quote, QuoteLineItem, Asset(Quote Line) from external system and want to insert one by one in salesforce. but the thing is these four are related with ...
0
votes
1answer
71 views

How to capture Data Loader error when called from Shell script via SSIS package?

Salesforce Gurus: Thank you in advance for any insights you may have. For years now I have been extracting data from a custom Salesforce object named Branches__c using the following method... ...
0
votes
1answer
83 views

Error: The field RecurrenceEndDateOnly is invalid

Doing a mass update on some tasks and came across this error. I understand the RecurrenceEndDateOnly field is used for recurring tasks, so this question is more about the error than the field. Has ...
0
votes
1answer
431 views

Best practice for Data Integration using a .csv flat file into Salesforce (<100 rows of data)

I am trying to find a best practice of data integration using a .csv flat file into Salesforce database. I am trying to schedule this task once a day. Sorry. this is not a code-related question, ...
0
votes
1answer
1k views

No Package.XML found

Trying to deploy the Custom metadata loader ZIP file in workbench and its giving an error. Please see the below... Following this steps : https://github.com/forcedotcom/CustomMetadataLoader
0
votes
2answers
131 views

Dataloader upsert error

While I am doing an upsert operation in data loader, I am getting an error as: unable to obtain access to these records. What could be a possible reason for this?
0
votes
4answers
1k views

How to remove Duplicate Accounts? [duplicate]

In my salesforce org, I have a list of Accounts which was loaded externally using CSV file using Data loader tool. The problem is that 3 team member of my team uploaded same data thrice and thats why ...
0
votes
1answer
233 views

Data Loader Import Id to Lookup field on Contact

I did an initial import of Contact data using Data Loader. One of the fields on the Contact is a lookup to an Account object (custom record type called School). I loaded my csv with corresponding ...
2
votes
3answers
1k views

Using DataLoader (Command line) on Mac

Is it possible that Data Loader command line can work in os x? After all it is "just java." I'm sure some of the JDBC stuff might not work but is it possible that simple CSV extracts could work? I'm ...