Skip to main content
7 votes

Will extracting data from salesforce remove all data from salesforce

No, you would have to do a delete. Extract with Dataloader is just a dump to a csv. So if you just do an export and don't then do a delete you're fine.
user4978's user avatar
  • 349
5 votes
Accepted

Why do some data loading tools work with professional edition?

There is actually a piece of documentation that goes over this in the ISVForce guide. API Access in Group and Professional Editions The first lines of text on that page read API access is not ...
Derek F's user avatar
  • 62.5k
3 votes
Accepted

How to retrieve a Date of Exported Files from the Data Loader tool

This is available by way of the Event Monitoring API. This is a paid feature, so you'll need to contact your account executive. It allows you to access the logs to see which user performed any ...
sfdcfox's user avatar
  • 495k
3 votes

Data Import Wizard not updating field

Whenever you update your account make sure to click the box update existing account information and that should do the trick!
Joshua Klaus's user avatar
3 votes

Extracting data

This is a very interesting situation, I would think initially about using ETL tool but on thinking it differently I believe it's possible to do it using data loader. Create a Field on your object, ...
Pranay Jaiswal's user avatar
2 votes
Accepted

Process Builder only calling invocable methods for top 3 records when uploading via DataLoader.io

As I said as comment, you don't loop through the list of InvoiceContact. Here's the solution: Global class sendInvoiceSurvey { @InvocableMethod public static void sendInvoiceEmail(List<...
Martin Lezer's user avatar
  • 7,295
2 votes
Accepted

Concatenate two fields on Dataloader.io

Apex Data Loader or Data loader.io does not support data transformations like concatenation of columns in your case. You need to use the excel CONCATENATE function to combine two or more columns.
varun guruvugari's user avatar
2 votes
Accepted

How to Export attachments with parentType.field = 'ABC'?

You can use a subquery filter for this: SELECT Body, Name, ParentId FROM Attachment WHERE ParentId IN (SELECT Id FROM Account WHERE Field__c = 'ABC')
sfdcfox's user avatar
  • 495k
2 votes
Accepted

How to clear the values in a number data type field while importing data?

You are getting this error because, you might have used the text NULL in the column mapped with the number field. With the setting "Insert Null values" checked in data loader, you will have to leave ...
Vijay Ganji's user avatar
  • 6,656
2 votes

Body is not present on the Attachment csv file

Export and import behavior with Attachment, and other objects that have binary-blob fields, varies depending on what tool and API you are using. If you execute a query via the REST API, the response ...
David Reed's user avatar
  • 93.2k
2 votes

What is advantage of mulesoft over dataloader in Salesforce

If all you need is simple data manipulation or simple data migrations, the Data Loader suffices in these cases. As soon as you want to start integrating with other systems, migrating data between ...
sfdcfox's user avatar
  • 495k
1 vote

salesforce Dataloader : field 'Description' can not be filtered in a query call

Long Text Area fields can't be a filter, but you can return it: SELECT Description FROM Task However, you can find records that match that word, just use SOSL instead: FIND {igloo} IN ALL FIELDS ...
sfdcfox's user avatar
  • 495k
1 vote

Extracting data

Pranay's suggestion is a good one. I just want to add a workaround for situations like I've encountered in the past where making a change to the schema is not permitted. This is an uglier solution. ...
David Reed's user avatar
  • 93.2k
1 vote

dataloader.io mapping

Irrespective of the platform, you just need to consider two important things while importing data. You have the required fields available. E.g., if you have validation rules on a field or that a ...
Jayant Das's user avatar
  • 30.6k
1 vote
Accepted

Can dataloader.io export files (not attachments)?

Hi @frackham, you can export the files using contentversion object but only problem is versiondata you will get is in blob datatype. But in attachment you are getting it as zip file. That's the ...
sanket kumar's user avatar
  • 15.4k
1 vote
Accepted

File Transfer One Org to another Org using Dataloader.io

We got "byte[] or InputStream" error in DataLoader.IO due to your file is not getting by them. We need to follow their steps(https://dataloader.io/dealing-attachments) but you need to take care of ...
Shrikant Parmar's user avatar
1 vote

Difference between dataloader and dataloader CLIq and dataloader.io?

There is not a limit on the number of records you can import via a data loader application as such. There are limits that apply to data load activity that will indirectly limit the number of records ...
David Reed's user avatar
  • 93.2k
1 vote
Accepted

Make Price Book Entry object's Product Code field Read/Write

You'll have to ask the people over at dataloader.io if there's a way to do this. Product Code itself is a "formula" on the Price Book Entry table, meaning it can be used to filter prices and display ...
sfdcfox's user avatar
  • 495k
1 vote
Accepted

Why does Dataloader.io not recognize my custom fields?

Got a response from the dataloader.io team: DisplayUrl and ExternalId fields from Product2 object were introduced in API version 39, while dataloader.io last release supports until API version ...
Scott C Wilson's user avatar
1 vote

How to extract notes and attachment for a custom object "X"

Using the Data loader App, DataLodear.io or Workbench you can't export Notes and Attachments directly from specific Objects. You need to check Custom X Object and from each record, you can download ...
Nikita Meshram's user avatar
1 vote

How to extract notes and attachment for a custom object "X"

I've done this using workbench.developerforce.com using the soql query functionality, and selecting the 'export as bulk CSV' option. You can write a query along these lines Select ID from attachment ...
gorav's user avatar
  • 4,537
1 vote
Accepted

Data Loader (or any API data import) logging / history

API Calls Documentation Link Go to Monitor | System Overview and there you will find the API REQUESTS, LAST 24 HOURS. This shows you how many API calls you've made in the last 24 hours including ...
Dave Humm's user avatar
  • 5,111

Only top scored, non community-wiki answers of a minimum length are eligible