37
votes
Accepted
Why Are Data Silos Important in Unit Tests?
I think the answer is quite simply one of consistency. It's also one of minimizing variations between environments we test in. This makes our test more consistent and repeatable. These are all things ...
30
votes
Why Are Data Silos Important in Unit Tests?
In two words: "bitter experience"
I will admit that if you don't have any asserts in your code (another topic) you run a lesser risk but, the reasons all have to do with repeatability/predictability ...
19
votes
Accepted
Parent Field in Lightning Datatable
Doing the "flattening" as mentioned in Winter 18 <lightning:datatable> does not get values from a parent record can be simple if everything is hard coded:
if (state === "SUCCESS") {
...
16
votes
Why Are Data Silos Important in Unit Tests?
Another point to add to cropredy's excellent list is that tests have significant value as a specification of what the code being tested does. But that only works if you can see the inputs (often the ...
16
votes
Accepted
what happens when you reach your data storage limit in an org?
what happens when I reach my data limit in org?
Strictly speaking, nothing typically happens at 100% storage usage, except that Salesforce starts to notify administrators daily by email about storage ...
15
votes
Can I use SalesforceDX to load data into sandboxes?
The short answer is: yes. All of the commands in the force:data command namespace work on any edition of Salesforce any org (provided API is enabled on that org).
The long answer is: it depends on ...
11
votes
Accepted
What is the difference between using the LIMIT clause and using a fixed index to retrieve data from a query?
actually, there is a difference, in current example it impacts on total number of records retrieved by SOQL queries limits. Limits is one of the most important challenge working with salesforce ...
10
votes
Accepted
Contacts without Accounts: Is it possible, and if not, why?
Your understanding is correct; SFDC unashamedly assumes you're using a standard Sales-y workflow with Accounts and Contacts.
I'm not sure there's a really good alternative here. Some options might be:...
9
votes
Return different data type using only one method
You can set return type of the Apex method to Object.
public Object returnVariousDataType(String dataType){
//write something
if(dataType == 'String'){
// return String
return ...
9
votes
Accepted
Uploading 100,000 binary files as attachments to Case record - best approach
I would suggest you to go with data loader using SOAP API, which is by default (not Bulk API).
Why?
You do not need to write any code to use Data loader
It is tested solution, so no bugs
With ...
8
votes
Accepted
DE Special Character when importing from a CSV
Your source data file might not be encoded properly,
from the H&T portal, Why isn’t Data Loader importing special characters?
Make any modifications to your source data file in .xls format.
...
7
votes
Accepted
Struggling at logging into dataloader
You have two options here.
Either download Apex dataloader latest version which support TLS 1.2
and second not so good option is disable this update in your org.
The following steps can be followed ...
7
votes
Accepted
can i run an automation only when a data extension have data or records?
There is a new Verification Activity in Automation Studio. You can set this to verify if there are no subscribers in DE then stop the automation. This will prevent the error.
New Verification ...
7
votes
Accepted
sObject type 'Pricebook2__c' is not supported
It's hard to tell what data you're even working with, but the standard object name is simply Pricebook2 (no underscores).
If you are trying to insert a record looking up to this object (such as ...
7
votes
Accepted
Can't assign permission set to my user after installing Salesforce Data Mask!
It was not really clear from the announcement or from most of the documentation, but Salesforce Data Mask is actually a paid feature, and if you want to use it you need to talk to your Account Execute ...
6
votes
Accepted
How to import accounts without contacts using Data Import Wizard?
Choose Accounts and Contacts on the first step, and proceed through the wizard. Simply unmap all of the contact fields. If no contact fields are mapped for import, the wizard will only import accounts....
6
votes
How can I see emails sent from Marketing Cloud on Salesforce Records?
This is a standard feature of the Marketing Cloud Connector. It is built by default to transmit the tracking information back to Salesforce. Here's what you need to do
In Marketing Cloud -
Tracking ...
6
votes
Accepted
Can Lightning Data Service include data from Parent-Child relationships?
Using the Lightning Data Service - Considerations page as reference, it appears that currently you are able to work with data across spanning relationships (lookup, master-detail) but not collections ...
6
votes
Accepted
Client-side custom data caching
It's best to work with the framework, so I suggest that you have a read about the caching that Lightning offers
Storable actions
Lightning Data Service
Custom cache
See:
https://developer....
6
votes
Accepted
UNABLE_TO_LOCK_ROW error during inserting a new Record
There are lots of situations where an insert can cause a record lock against the parent of the inserted record, or even against third records. Inserting Task, for example, can lock the WhoId, WhatId, ...
6
votes
Accepted
Marketing Cloud to s3
You can’t do this directly between SFMC and S3. However, AWS has launched their fully managed SFTP service for S3 last year. If you have management access to the AWS environment and can configure this ...
5
votes
Import excel csv data using apex class
Providing the CSV files are not too big, you can use a Visualforce apex:inputFile to upload the file and then apply this Parse a CSV with Apex sample code to grab the data from the rows.
If the CSV ...
5
votes
Copy Data from Production to Sandbox after sandbox refresh
If you're trying to populate your Developer sandbox, you should use an app like SFXOrgData (http://www.sfapex.com) which will copy data from your Production/Sandbox to another Sandbox (i.e. your ...
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
How to load data into salesforce when I've run out of licenses?
You need a license to be able to upload data. There is no other way.
You could consider temporarily (e.g. outside of office hours) deactivating a Sales Rep license and assigning the license to your ...
5
votes
Can I choose which records are copied in a Partial Copy sandbox?
There are no guarantees of what records are copied to a partial sandbox. You get 10,000 random records of each object included in your template. There's not even a guarantee that you'll get all child ...
5
votes
Accepted
Org Benchmarking?
Salesforce doesn't experience any performance penalty as you near your org's capacity. Each large object has no effect on the performance of small objects. Your org will run just as efficiently at 105%...
5
votes
what update type to use in query for adding and updating in data extension
These are what the 3 query types are:
Append: Will only add records to the table without affecting the existing records.
Update: Will update existing records if their is a match or will add the ...
5
votes
Accepted
what update type to use in query for adding and updating in data extension
EDIT
Based on the comments below, this may be your best answer:
SELECT *
FROM SourceDE s
LEFT JOIN DestinationDE d
ON s.PrimaryKey = d.PrimaryKey
WHERE d.PrimaryKey IS NULL
This will force an ...
5
votes
Accepted
can i decrease the length of a column in data extension
There is no way to directly decrease the size of an existing text field.
The easiest way to handle this is to:
Export the data from your existing DE.
Clear your DE
Delete the existing field
Create a ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
data × 471marketing-cloud × 94
apex × 65
dataextensions × 56
data-loader × 50
soql × 20
sql × 20
integration × 19
data-export × 16
query × 15
import × 14
custom-object × 13
lightning-web-components × 12
ampscript × 12
api × 12
reporting × 12
visualforce × 11
security × 11
bulk-api × 11
sandbox × 10
data-migration × 10
loader × 10
trigger × 9
lightning × 9
email × 9