2022 Developer Survey is open! Take survey.
19 votes
Accepted

How can I backup/export my APEX code classes and triggers?

You can use the Meta-data API for these purposes. We do so at work quite often. There are two channels we adopt, basically both the same, but using different IDEs (Force.com IDE and SublimeText/...
user avatar
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 (').
user avatar
  • 142k
9 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 ...
user avatar
  • 562
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 ...
user avatar
  • 4,917
7 votes
Accepted

Export data to a file using apex

If you're concerned about time or memory limits, use a batch class. This is how I would perform the export of a potentially unknown size (10k+ records). global class X implements Database.Batchable&...
user avatar
  • 430k
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 ...
user avatar
  • 5,213
7 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 ...
user avatar
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 ...
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 ...
user avatar
5 votes
Accepted

Export to excel file problem with displaying information

Try this, <apex:dataTable value="{!acc}" var="a"> <apex:column value="{!a.ID}"/> <apex:column value="{!a.Name}"/> <apex:column> <apex:...
user avatar
  • 2,219
5 votes
Accepted

Size of "Weekly Export" vs. "Data Storage" is different, why?

Short Answer: The data storage size reported by Salesforce is based on a fixed size per record type and little relation to how many bytes it would take to store that data in a database. The Weekly ...
user avatar
5 votes
Accepted

Exporting entire database via API

Proceeding with apex, describe and SOQL will make it slower and in my experience it will rather add new bottlenecks and problems than remove existing. On thing you try is the weely export feautre to ...
user avatar
  • 33.6k
5 votes

Exporting Content from Salesforce

We needed these content to be exported urgently. So, couldn't tried any AppExchange App. Every salesforce content has it's download URL like : http://Your_ORG_URL/sfc/servlet.shepherd/version/...
user avatar
  • 2,212
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 ...
user avatar
  • 27.9k
5 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 ...
user avatar
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 ...
user avatar
4 votes

Custom Labels Data retrieval with translations

Custom labels are metadata. Normal access through data loader would be limited. Either you can access it through the IDE, or some other metadata tool. Or, you can turn on Translation Workbench, ...
user avatar
  • 19.1k
4 votes

How to import an SFDC Report CSV export file in Numbers on Apple's iCloud?

There should be export options when you're viewing a report. You should be able to export any report into CSV or XLS format and open in Numbers.
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 ...
user avatar
4 votes
Accepted

How to pick the right character encoding for exports?

Using an 8 bit character set such as ISO-8859-1 means that any characters stored in Salesforce that can't be represented by one of those 256 numbers will be missing from your export and so lost. UTF-...
user avatar
  • 129k
4 votes

Way to check triggers on object

You can review the existing triggers from Setup | Develop | Apex Triggers, and review the Sobject types to determine the base object. You can review all existing Workflow Rules from Setup | Create | ...
user avatar
  • 873
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 ...
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 ...
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 ...
user avatar
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 ...
user avatar
4 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, ...
user avatar
  • 430k
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 ...
user avatar
  • 61
3 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 ...
user avatar
3 votes
Accepted

How to escape commas in exported .csv / custom .csv delimiter

I just did a quick Export as CSV test from a report. All the export values were wrapped by double-quotes. E.g. "Company Name", "Phone" "Company Name, Inc.", "123545&...
user avatar
3 votes

Is there a way to see if a user has exported data?

Latest Comment from Salesforce on the idea around it : With the Winter '15 release, you can now use Event Log Files to understand organizational trends. See the release notes for more information: ...
user avatar
  • 3,830

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