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/...
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 (').
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 ...
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 ...
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&...
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 ...
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 ...
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 ...
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 ...
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:...
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 ...
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 ...
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/...
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 ...
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 ...
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 ...
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, ...
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.
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 ...
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-...
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 | ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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&...
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:
...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
data-export × 271marketing-cloud × 48
data-loader × 42
salesforcedx × 21
reporting × 18
data × 16
apex × 15
visualforce × 15
excel × 15
csv × 14
dataextensions × 11
automationstudio × 11
backup × 11
soql × 10
automation × 9
import × 8
database × 8
data-import × 8
scratch-org × 7
api × 6
data-migration × 6
integration × 5
bulk-api × 5
trigger × 4
email × 4