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.
757
questions
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 ...
