Skip to main content
11 votes

SFDX force:data:tree:export Beyond 1 Level Deep

Hi following the instructions in your referenced link I managed to extract and import data from 2 levels deep relationship, Account -> Cases -> Tasks & Events. This is what I did: Extract ...
mnunezdm's user avatar
  • 909
10 votes
Accepted

Data Loader Error no viable alternative at character

You are only allowed to use single quotes in your query. Replace all of your double quote characters (") with single quote characters (').
Adrian Larson's user avatar
  • 151k
8 votes

Backup options for salesforce org

Salesforce does maintain back up data and can recover it, it's important to regularly back up your data locally so that you have the ability restore it to avoid relying on Salesforce backups to ...
Devendra's user avatar
  • 5,075
8 votes
Accepted

DX CLI force:data:tree:export Query returned no results

I've had a look at reproducing this. I got the same result when the data:tree:export included any specific ID's in the where clause. As soon as I took the where clause out of the SOQL query that data ...
Daniel Ballinger's user avatar
7 votes

Is there a custom direct link to download/export reports in one click in lightning?

Try appending the isdtp=p1parameter to your URL. We use a URL similar to the below one for extracting reports in CSV format: /YOUR_REPORT_ID?csv=1&exp=1&enc=UTF-8&isdtp=p1 Before ...
smukov's user avatar
  • 5,613
6 votes
Accepted

SFDX force:data:tree:export Invalid SOQL Query When Using File Path to Supply Query

I just tried executing by create a simple file in a folder as shown in the below screenshot and below command worked fine sfdx force:data:tree:export -q data/accounts/queryFile -d data/accounts/ My ...
Mohith Shrivastava's user avatar
6 votes

SFDX -How to Export data with record types to put in a scratch / qa org

I had this same issue, so I wrote a SFDX plugin to help. In the export query, you select RecordType.DeveloperName along with other fields from your object. Then run my plugin against the JSON data ...
William Young's user avatar
6 votes
Accepted

How to perform data extract hourly for current day

You can use the SOAP API to programmatically define and execute a data extract, analogous to creating the data extract activity in automation studio, but with the benefit of being able to set the ...
Clayton VonDras's user avatar
5 votes
Accepted

How to export the bulk of images in content in salesforce marketing cloud?

There is no easy way to export images from SFMC, it is likely an effort to keep users on platform instead of moving to another service. What I would recommend to pull bulk sets of images is via the ...
Gortonington's user avatar
  • 30.7k
5 votes
Accepted

SFDX commands to export and import related objects

It appears that all your objects are related together. You can use parent queries in your SOQL: sfdx force:data:tree:export --outputdir data --plan --query \ "SELECT Name, lkp_Account__r.Name, ...
sfdcfox's user avatar
  • 497k
5 votes
Accepted

Specify a fie path for External SFTP Marketing Cloud

When you choose "External SFTP" as the location type, your Url field should have the absolute path to the ftp folder you need to access. Example: sftp://ftp.domain.com/folderForSFMC/ You can find ...
jake314159's user avatar
4 votes

Is there a way to Download all notes/attachments from a Salesforce Opportunity?

One simple app is there on salesforce called "Mass file Download". This app Download Multiple Files on a single click. It supports Mass download of Attachments, Files, Static Resource and Documents as ...
Abdul Hafeez's user avatar
4 votes

Automate the downloading of Data Export zip files

I would like to add that I published an open source Python package to automate this process using selenium, this is lightning and classic compatible and easy to use in three lines of code. Give it a ...
salesforceninja's user avatar
4 votes
Accepted

Can I export related fields using a data loader?

You can export parent and their parent attribute values from Child object. But from the parent, you cannot export child object related attributes. You could move to 5 levels up to the Parent or ...
Santanu Boral's user avatar
4 votes
Accepted

Using Automation Studio to Export a Data Extension

This is easily done with an Automation containing a Data Extract Activity. Go to Automation Studio and create a new automation. Add a new Data Extract Activity, choose a name, a file naming pattern ...
Markus Dang - formerly Slabina's user avatar
4 votes
Accepted

Salesforce relational data backup and reload after sandbox refresh

If you do not have ETL tool and ordering a new fullcopy sandbox is expensive and not a viable option, then best way to do the data backup is to use Data loader will Bulk API option. I have seen that ...
Santanu Boral's user avatar
4 votes
Accepted

Scheduled Data Export: how to obtain ContentVersion linking data

One thing to realize is that ContentDocument can't be directly inserted; it is inserted automatically when the first ContentVersion is inserted. ContentDocument acts as a parent for each version of ...
cropredy's user avatar
  • 72.1k
4 votes
Accepted

How to get the evidence of the email sent for weekly data export?

You can track that with the use of Email Logs Navigate: Monitoring -> Email Log files. Email logs describe all emails sent through salesforce.com and can be used to help identify the status of an ...
Santanu Boral's user avatar
4 votes

Restrict a User to export data

Create a new profile for the user, remove the "Weekly Data Export", "Export Reports", and "Api Enabled" permissions, and then assign the user to the profile. This will remove all the most common ...
sfdcfox's user avatar
  • 497k
4 votes

Extracting all contacts from Marketing Cloud Contact Builder

What worked for me was using the "Create Mobile List" button in Contact Builder, you can find it on the "All Contacts" tab, under the "Mobile Lists" section. I am unsure ...
David 's user avatar
  • 61
3 votes
Accepted

Data Loader CLI

Unless someone finds a way to do it from within data loader, I'd set up the .bat job to rename the files after the extraction is run.
Wanderlei Santos's user avatar
3 votes

How to reinstall a managed beta package without losing custom objects data?

For your point first thats not possible. You need to first uninstall that package first. For second point you can take a offline backup in Eclipse and then remove dependency of your Beta package and ...
Tushar Sharma's user avatar
3 votes
Accepted

Export all contacts with automation issue

Tracking Extract is the type you need choose. From there, you have option to Extract Subscribers. Be sure and check the Include All Subscribers option otherwise you'll get only Subscribers who've ...
Adam Spriggs's user avatar
  • 30.8k
3 votes
Accepted

Broken CSV exports

Maybe this is an issue with text delimeters of microsoft office? When you import .csv Files where in some columns there could be values that inherit delimeters like " in odd-times, it may be that ...
Johannes Schapdick's user avatar
3 votes
Accepted

export xls limits

The PDF limits have absolutely no bearing on other types of file generation. You'll want to read more in Best Practices for Improving Visualforce Performance. In general, the most important limit for ...
sfdcfox's user avatar
  • 497k
3 votes

How to export limited rows from synchronized database from marketing cloud?

Your best bet is to utilize a SQL query to pull your X rows into a separate DE and then export that. For example: SELECT TOP 2000 /* Only pulls the first 2k records */ EmailAddress ,FirstName ...
Gortonington's user avatar
  • 30.7k
3 votes
Accepted

Best way to export records with attachments

Salesforce Standard Weekly export is the best way if you want it weekly or monthly without paying for extra ETL tools or API calls in a process to do so.... Best part, it backups files, Attachments ...
Pranay Jaiswal's user avatar
3 votes

How can I batch rename attachments I've exported?

Hoping this helps as I just had this same issue. One of my problems was that there are multiple Attachment folders in the export you get from Salesforce, but they're all listed in the CSV, so when you ...
Ashley S's user avatar
3 votes

Exporting data from partial sandbox to developer sandbox for related objects

For this task, I recommend Salesforce DX. Simply export the records you want with: sfdx force:data:tree:export -q "query" -p -u sourceOrg This gets you a set of files (something like Accounts.json, ...
sfdcfox's user avatar
  • 497k
3 votes
Accepted

Exporting data from partial sandbox to developer sandbox for related objects

Data Loader When importing multiple connected objects, it's critical that you retain the success files that Data Loader emits. These allow you to map from old Ids to new Ids as you're populating ...
David Reed's user avatar
  • 93.2k

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