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
2
votes
1answer
238 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
43 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
555 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
86 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
190 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
1answer
275 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
33 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
155 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
429 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
371 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
68 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
142 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
154 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
302 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
344 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
308 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
137 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
611 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
360 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
86 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
146 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
62 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
415 views

Values are not getting updated in the picklist through the data loader, error: Bad value for restricted picklist field

I have a situation: Under opportunity Country and state are picklist. both country and state are a global set of picklist. Country and state are dependent picklists (controlling: country and state: ...
0
votes
1answer
74 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
381 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
118 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
835 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
193 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
948 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 ...
1
vote
1answer
126 views

Inserting record using Test Class vs data loader

I have a situation where I need to test whether the apex classes written in my org does not hit governors limit / anyother issues when bulk data is loaded. I decided to use test class to check this. ...
0
votes
0answers
39 views

Data Loader CLI - sporadically doesn't return results

Anyone had an issue where when using the Data Loader CLI they won't get back any results? We have a scheduled job in the morning to export some data to a CSV. This has been running for about a week ...
1
vote
0answers
359 views

Why does data loader fail a whole batch of records if just a single master-detail relationship is not filled correctly?

I'm trying to upload records using the data loader. The object I'm loading into has a master-detail relationship, but in the CSV, I don't set any external id or Salesforce id that identifies the ...
2
votes
1answer
169 views

Test.loadData() is there a way to load sObects with lookups to itself?

We have some custom object that has lookups to itself. Those objects used for some configs and there are quite a lot of them. Would be nice to create and load them from static resource for tests as ...
1
vote
2answers
380 views

Effect of TLS update in Apex Data Loader?

Does TLS update have any impact in apex Data loader? If it so, in what way will it affect? What measures has to be taken in order to use Data loader after that update?
-2
votes
2answers
472 views

query deleted custom object records from recyle bin [closed]

Query to get records from recycle bin
0
votes
0answers
450 views

Pentaho Kettle update salesforce

I get the following error when trying to update salesforce from a CSV Errors were found on item 0 Error code is: INVALID_TYPE_ON_FIELD_IN_RECORD Error message: Office: value not of required type: ...
1
vote
3answers
2k views

Timezone issue Data Loader

I have to upload a csv file in which a DateTime field has values across the global timezone, however I want to load this data in my org keeping the timezone consistent with my org. e.g. In CSV values ...
3
votes
3answers
2k views

Can I export related fields using a data loader?

I want to be able to export the related account fields for each quotation in Salesforce using Data Loader. I suspect this is possible using relationships (Object__r.FieldName__c), but I'm not 100% ...
0
votes
1answer
1k views

I am getting “407 Proxy Authorization Required” error when I try to login to Data Loader

I get "407 Proxy Authorization Required" error when I try to login from Salesforce Data Loader.
0
votes
1answer
174 views

Multi select picklist to picklist

I am trying to move from Multi-select picklist to a single select picklist. What steps should I take? I am thinking(not clear yet) there is a data load involved. Should I leave the existing data with ...
0
votes
0answers
92 views

process.conf.xml bind xxxx_lastRun.properties parameter in SOQL in API Dataloader CLI

I'm building a process.conf file to extract delta view records from Salesforce. my SOQL is looking like this now : <entry key="sfdc.extractionSOQL" value="SELECT Id,FirstName, LastName FROM ...
1
vote
2answers
816 views

updating the child record and linking it to parent

I have scnerio where I am loading the child record from an external system and I want to connect it with the parent record. But I do not have the sfdc id of the parent record that I can put in the ...
1
vote
0answers
87 views

Scheduled Jitterbit Upsert

I have a couple different upserts built out in Jitterbit that are all supposed to be running nightly. Some of them are working and some of them are not. As far as I can tell they are set up the exact ...