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
29 views

INACTIVE_OWNER_OR_USER, owner or user is inactive

I got an issue when I want to load (data through Talend) to Salesforce. When I do the upsert, I have like 50% of upsert errors with this message : CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:UserTrigger: ...
0
votes
2answers
40 views

How can I insert records from one sandbox to another sandbox?

I have sandbox shared for my team and I have personal sandbox. How can I insert records sandbox shared for my team to my personal sandbox? I have required objects and fields. I don't need to insert ...
0
votes
2answers
26 views

Force RecordTypeId to Null on Contact

I am working in a very old org where majority of the contacts do not have a recordtypeid, and contact visibility, page layout assignments revolve around this master no record type id contact record. ...
0
votes
0answers
9 views

How to upsert child records with invalid foreign external ID(parent external ID)?

I am trying to upsert contact related to account using CLI Data Loader. We have a requirement to insert contact successfully even if the account with the external ID doesn't exist. For Example, if ...
0
votes
0answers
18 views

Import Knowledge invalid encoding for import setting: CSVEncoding

I've formatted my Solutions articles to fit the Knowledge fields and rich-text fields, downloaded and enter the correct parameter for my .property file and I keep getting an error of: The .properties ...
2
votes
1answer
44 views

EmailMessage Storage Issue [closed]

Currently we are facing storage issue in org production. It is reached to 90%. Most of the storage is consumed by emailmessage. We looking different solutions. We are planning to extract the ...
0
votes
1answer
12 views

Update using External Id

I understand UPDATE operation doesn't support ExternlID. Is there any other way i can use Dataloader to update Salesforce records using external id ? If i use UPSERT operation, i don't want to ...
0
votes
1answer
23 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
0answers
32 views

Dealing with failed records in an Upsert operation

With the help of responses to my previous posts I was finally successful in Upserting Contacts in Salesforce via Jitterbit using External Id. However two records failed. I am thinking these failed ...
0
votes
0answers
18 views

Dataloader - Upsert Contact and Relate to Account

How can I UPSERT Contact and relate it to the Account ? Data Structure Supplier_ID__c (External Id on Account ) Supplier_AdminID__c (External ID on Contact) Supplier_ID__c (lookup field on ...
1
vote
1answer
26 views

What is ACT! in Salesforce

What is ACT! in Salesforce https://help.salesforce.com/articleView?id=exporting_from_act.htm&type=5 article talks about this and I see ACT! file on data import wizard and in one trailhead link but ...
1
vote
2answers
35 views

Exporting data from partial sandbox to developer sandbox for related objects

I am trying to export Account and Opportunity data using data loader from partial sandbox to the developer sandbox. Currently, the hurdle is that in Opportunity Account is a lookup and required field. ...
0
votes
0answers
21 views

Command line Data Loader for scheduled import of parent and child records

I am struggling with an urgent issue related to periodically scheduling data import using Dataloder CLI. We are planning to use command line DataLoader for scheduling the data load for multiple ...
0
votes
0answers
25 views

findDuplicates size() always 1 - how to prevent duplicates on accounts created from a trigger on a custom object

When a custom object record is created, I'd like to create a personAccount from that record's field values, but I also don't want to create duplicates. I'd like to use the standard duplicate / ...
0
votes
2answers
24 views

Data Loader - Connect Activity/Tasks to Quotes?

I'm Data Loading from Org to Org. Accounts, Contacts, Opportunities, Leads, Activities, Products, Price Books, and Quotes are all complete. I just finished Quotes. Activities/Tasks are showing on ...
0
votes
0answers
19 views

Do customer community/customer community plus licenses have access to Data Loader/Data Import Wizard?

I want to know if customer community or customer community + user licenses have access to data transfer applications like Data loader or Data Import Wizard? If not, is APEX driving custom component ...
0
votes
1answer
64 views

Dataloader stuck while exporting object

I have installed dataloader version 48 in my mac, I too have installed Zulu Java Sdk. I am trying to export Account object data from the sandbox and so far I am able to login using Password ...
2
votes
1answer
105 views

OAuth+SSO login works with Data Loader GUI but not Data Loader CLI

GUI On my Windows machine, I can login with GUI Data Loader 44.0.0 without providing a username and password, by choosing "OAuth" and "Production" environment and clicking "Log in": On the little ...
3
votes
1answer
58 views

Is it impossible to export more than 2000 records from an aggregate SOQL query?

It seems odd to me that this would be simply impossible to do, but the aggregate query below returns more than 2000 records, and it appears that there is no possible way to even run the query, let ...
0
votes
0answers
31 views

Salesforce removing line breaks when importing data from CSV

We're currently busy with a migration of data from our old system to our brand new Salesforce system. As part of this migration, we're migrating data fields that contain flat text with line breaks, ...
1
vote
2answers
23 views

How many parallel connections can be made for a single generic users?

I have a downstream system which will take data from SFDC to Snowflake through Talend Job. But I am connecting to SFDC through one generic user. Is there any limit on haw many jobs I can parallely run ...
0
votes
1answer
19 views

Data Loader - Command Line - Field Aliases

I am trying to extract data using Data Loader command line but can't get aliases to work. The following SOQL query will work perfectly fine in the Developer console: Select Hub_Name__r.Name ...
0
votes
1answer
43 views

Bulk Upload Attachments into Lightning Knowledge Articles

I would like to bulk upload list of pdfs as attachments against knowledge articles. I think the documents are getting stored in ContentDocument, but how can I use dataloader to load attachments and ...
0
votes
1answer
25 views

Salesforce Data Loader Cant Upsert Tasks using External Id to link to Account?

I'm trying to Upsert Tasks to their Accounts using an ExternalID field but the 2nd step (Step 2b) doesn't appear with a Task Upsert. Does Task not support External IDs for Account-association? Also,...
0
votes
1answer
26 views

Data Loader > Edit SOQL query for Extraction > using AND & OR in the conditions = Not working

I'm Using Dataloader to Export. In the SOQL Query, I can't seem to use "AND" & "OR" all in one Query. Only one or the other. Select ID, ParentId, RecordTypeId, OwnerId FROM Account WHERE ...
2
votes
1answer
80 views

Increase Heap Size for Data Loader Started from dataloader.bat Windows Batch File

For the older version of data loader this was possible by following the guide below: https://help.salesforce.com/articleView?id=000329565&language=en_US&type=1&mode=1 From the desktop ...
-1
votes
2answers
65 views

Dataloader Upserting: the Child overwrites the parent

I'm using Dataloader to Upsert a Child Account to Parent Account using an external ID. When the Upsert is complete, the Child overwrites the parent, it's not not connecting the Child Account to the ...
-1
votes
2answers
54 views

Dataloader Upserting Child Account to Parent Account using External ID: [duplicate]

I'm using Dataloader to Upsert a Child Account to Parent Account using an external ID. When the Upsert is complete, it's creating a new account, it's not not connecting the Child Account to the ...
0
votes
1answer
26 views

Data Loader Org to Org. Connecting mass children to parent Accounts?

Data Loader > Org to Org > How to connect mass children to their parent Accounts? Ok so I Inserted the parents. 1000+ I have a field where the old Account ID's are stored on the new Org. Now I have ...
-1
votes
1answer
30 views

Delete records in report object [closed]

I have 100 records in report object.tried multiple options like data loader, work bench and developer console to delete those 100 records but unable to delete those records.Could someone help??
0
votes
1answer
20 views

Dataloader Condition: Accounts with Contacts, Opportunities, etc.?

Is there a way in Dataload to add the condition when exporting Accounts so that it only pulls Accounts with Contacts, Opportunities, etc.? Thanks
0
votes
1answer
25 views

Dataloader Across Org's = How to match Contacts to their Accounts?

If I move an Account from Production to Sandbox, then when it's time to move the Contacts from Production to Sandbox, then in Excel, in the Contact CSV, I just update the AccountID Cell with the new ...
0
votes
1answer
30 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
54 views

Dataloader insufficient access rights on cross-reference id

I've been stuck on this for hours, I've researched for hours, nothing relevant has surfaced. So here goes: Dataloader > Insert > Accounts From Production to Sandbox. -I changed the OwnerID to my ID ...
1
vote
2answers
65 views

Questions: Migrate data from one organization to another

I am in the process of planning out and executing how we're going to migrate data from one SF organization to another. I want to make sure I do this properly. Based on https://help.salesforce.com/...
1
vote
1answer
54 views

Can't download Salesforce Data Loader 2020

I'm on a new computer and I haven't downloaded Data Loader in years but now, I'm having all kinds if issues. So apparently, I have to download Zulu JDK 11 (msi) first, Then download and unzip Data ...
0
votes
0answers
30 views

Command Line data loader; is an .SDL needed for extract?

I'm going through and creating the xml doc for an automated data loader extract. I put in the extractSOQL query and i'm wondering if i need a .sdl mapping? I just need the extract in a CSV in no ...
0
votes
1answer
35 views

Dataloader via Command Line cannot export out fields like Id and formula fields

I am currently using a batch script I wrote up to export out multiple standard/custom objects out daily so I need to use Dataloader Command Line to accomplish my job. However I noticed that ...
0
votes
1answer
472 views

Data Loader 48.0 Installation error - Could not find install.bat

Followed instructions here to install data loader https://help.salesforce.com/articleView?id=loader_install_windows.htm&type=5 Installed OpenJDK 11 from here https://www.azul.com/downloads/zulu-...
0
votes
0answers
16 views

Changed ContentDocument Owner via Dataloader, but is not being reflected in File List

I was asked to change the file's Owner, I did it via Dataloader app, the issue is that it still showing the old user as Owner. But the actual owner of the file is correct. I even deleted the sharing ...
0
votes
0answers
35 views

Error 'Java Heap Space' in Data Loader

With Data Loader (Version 44.0.0),I am trying to insert Attachments in Salesforce. There are 12k PDF files. Each file is around 190 kb. So total attachment are 2.28 GB This is the structure of my ...
0
votes
1answer
38 views

Command Line Dataloader cannot run process

I'm getting nowhere after following the exact steps and trying as much as i can. Can someone please help me why i'm getting this error? when i export, i am able tp run the job without having any ...
0
votes
0answers
27 views

Bulkified trigger giving error on data import: Z4PAccountAddressTrigger: System.LimitException: Too many future calls: 51

I have a future call that gives me the error: System.LimitException: Too many future calls: 51, while importing multiple record with data loader. I did some googling on the limitations of future calls ...
1
vote
1answer
41 views

Clone Data of big Object into another big Object

I have roughly 10 million records in Big Object and now I need to move the data/clone the records in another big Object. The reason why I am doing this is that I need to modify/add more fields to the ...
0
votes
0answers
13 views

Command Line DataLoader in Salesforce unsupported option -g [duplicate]

I am trying to set up Command line Data loader by following steps here (https://www.jitendrazaa.com/blog/salesforce/tutorial-of-command-line-dataloader-salesforce/) I am getting an error(see screen ...
0
votes
1answer
38 views

Importing 40k PDF as attchments

I have 40k PDF's in windows shared drive. Each pdf should be attached to parent account. The name of each pdf is an external ID in salesforce. e.g AA123.pdf corresponds to AccountRecordId '...
0
votes
0answers
18 views

Schedule weekly import of documents from external location

I want to schedule a weekly batch import of documents from an external drive into Salesforce. Say, in the external drive there is a folder called 'CompetitorScore' and in that folder there are 50 ...
1
vote
1answer
27 views

Exporting Contacts from a list of Accounts

We have a list of 10000 Accounts in CSV format that we are updating through Data Loader. We also want to update all the related Contacts. What would be the best way to do this? The last time i did ...
0
votes
0answers
61 views

Unable to run SalesForce DataLoader from CMD - Receiving errors - Incorrect directory

trying to run dataloader from CMD. Running CMD as Admin and it looks like process.bat is looking in the incorrect directory. C:\Users\<me>\Desktop\dataloader\process-conf.xml\process-conf.xml ...
0
votes
1answer
25 views

Dataloader Command line error

I need to be able to run Data Loader from the command line (we need a scheduled import/export of data once per day). I created the conf file but get the error message below when I run the proccess.bat ...

1
2 3 4 5
16