19
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/MavensMate). Here I will explain how to do this using the Force.com IDE (available from the Eclipse foundation, instructions here) and install it on your machine, ...
10
Try using ?export=1&enc=UTF-8&xf=xls for the query string.
e.g. /00Oi0000002vZ5W?export=1&enc=UTF-8&xf=xls
You might want to change &enc=UTF-8 with &enc=ISO-8859-1 depending on the file encoding you want.
You can also get a CSV by changing the xf parameter to &xf=csv.
In a custom button or link using window.open will prevent ...
10
You can use the action attribute of the page tag for this - that will execute an action method on the controller before anything is rendered. E.g.
Controller:
public class MyController
{
public void MyActionMethod()
{
// do some stuff here
}
}
Page:
<apex:page controller="MyController" action="{!MyActionMethod}">
<!-- rest of ...
10
You are only allowed to use single quotes in your query. Replace all of your double quote characters (") with single quote characters (').
8
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 recover
your data. The recovery process is time consuming and resource
intensive and typically involves an additional fee. To avoid recovery
fees and be ...
7
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<SObject>, Database.Stateful {
string[] Lines;
global Database.QueryLocator start(Database.BatchableContext bc) {
lines = new String[0];
...
6
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 migrating to Lightning we used a similar link but we had the isdtp=mn set, which stopped working after the migration. Simply changing this parameter to isdtp=p1 ...
6
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 folder structure is as below and you can see i have a file shown in the editor
And you can see I have a file queryFile which does not have any extension .
The ...
answered Oct 25 '17 at 5:05
Mohith Shrivastava
79.7k17 gold badges128 silver badges179 bronze badges
6
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 Account & Cases with its fields using the plan flag. Remember to extract all the fields you want to insert
$ sfdx force:data:tree:export -q "SELECT Id, Name,...
6
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 started exporting as expected. It even included the data for the Account I was trying to specify by ID.
I'm not certain at the moment, but I suspect it is ...
5
Outside of the platform
Regardless of the path - All your users will have to be API enabled if they're to use external tools to communicate with SF. That means they could install Data Loader, start exporting data like crazy, some nasty guy can run a mass delete on his last day of work ;) I'm just saying that you might want to review your security settings ...
5
What about the DOT process? Especially for a 1-off copy. This refers to the option of creating (or having SFDC create) a 'DOT' template - this can include or exclude data, and obviously includes the full org meta-data.
We use this process at Veeva - for large deployments across multi countries, we often end up with several 'child' production orgs, cloned ...
5
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 Export is a collection of zipped CSVs. Each byte will contribute to the file size, which will be further altered by the compression.
The weekly data export is not ...
5
Try this,
<apex:dataTable value="{!acc}" var="a">
<apex:column value="{!a.ID}"/>
<apex:column value="{!a.Name}"/>
<apex:column>
<apex:dataTable value="{!a.contacts}" var="c">
<apex:column value="{!c.id}"/>
<apex:column value="{!c.name}"/&...
5
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 export everything. But depending on the size of all your data, this can also be very slow. Also it splits up the export in many zip files, which are hard to ...
5
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/download/?asPdf=false"
We logged into one browser and wrote a automation script to download these files by it's URL.
It was quite fast.
5
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 file and a specific scratch org. In turn it will output a version of the JSON data file with the scratch org specific Record Type Id in it. Then you can data ...
5
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 REST API asset query using the asset types for images. Now a caveat is that this will only pull those from Content Builder and that it will pull the URLs of the ...
5
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 your folder's absolute path by viewing the folder in an FTP client and right-clicking on the folder to "Copy URL(s) to Clipboard" (that's the option in FileZilla)....
4
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 a zip throughout the organization on record level.
https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000EcsAOUAZ
4
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
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-8 avoids this risk. It uses a single byte for the ASCII characters and then more bytes to encode other characters. So practically speaking it is a "lossless" ...
4
SnapShot (http://appexchange.salesforce.com/listingDetail?listingId=a0N300000016YhyEAE) can migrate from any Org to any Org (as long as you have admin credentials). This includes migrating profiles, partial profiles - only FLS of one field but not the other etc., objects, workflows etc. You can even edit the profiles to update security settings en masse ...
4
2013-06-11T15:54:00Z is GMT
The Z at the end signifies Zulu which is UTC or GMT
All times are stored in the database as GMT times and then corrected for display based on the Users Timezone
So you can either convert to GMT and then query
2013-06-11T13:54:00Z (GMT = CET - 2?)
4
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, and use the export feature there. You can enable the Translation Workbench for only the primary language of your org. This export will include all labels, not ...
4
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 | Workflow & Approvals | Workflow Rules, and review the Object list to determine the base object.
You can review all existing Processes from Setup | Create |...
4
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 related objects.
As we cannot query foreign key relationships more than 5 levels away from the root SObject
so, maximum up to this level is supported from ...
4
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 for 2 Million records it takes hardly a minute though it depends on number of fields which you are taking the backup.
Approach of Data migration and Data ...
4
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 email delivery. Email logs are CSV files that provide information such as the email address of each email sender and its recipient, the date and time each email ...
4
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, lkp_Case__r.Subject, lkp_Contact__r.FirstName, lkp_Contact__r.LastName, lkp_Lead__r.FirstName, lkp_Lead__r.LastName, lkp_Opportunity__r.AccountId, ...
Only top voted, non community-wiki answers of a minimum length are eligible
