Skip to main content
The 2024 Developer Survey results are live! See the results
10 votes
Accepted

How do lookup relationships work with force:data:tree:export? Don't know where to start

the data export feature is a little tricky with lookup relationships unless you do nested SOQL queries in the command. For example: sfdx force:data:tree:export -q "SELECT Id, Name, (SELECT Name, ...
Zack Walton's user avatar
  • 1,626
9 votes
Accepted

Is it possible to copy fields from Sandbox to Production?

Yes, you can use a change set to deploy fields from a sandbox to production. First, in your Production org, go to "Deployment Settings" and edit your sandbox's deployment settings to allow inbound ...
IllusiveBrian's user avatar
9 votes
Accepted

Why it is forbidden to import several Apex Methods at once in LWC module?

Looks like here by "default" imports meant only imports which import one item from the module, so I have to use the following workaround. import Method1 from '@salesforce/apex/LWCController.Method1'; ...
Patlatus's user avatar
  • 17.3k
9 votes
Accepted

Is it possible to import a dynamic custom label in LWC JS?

New and Improved Access We no longer need the Visualforce page, as we can now Access Labels in Apex Dynamically. @AuraEnabled(cacheable=true) public static String getLabel(String namespace, String ...
sfdcfox's user avatar
  • 497k
8 votes

Import to Data Extension even if the CSV file has no rows (and has only header)

In order to do this, you will need to contact SFMC Support and request a business rule "Allow Blank File Processing" to be enabled on your instance. This allows the import of empty files without ...
Rain's user avatar
  • 5,785
8 votes

Is it possible to import a dynamic custom label in LWC JS?

As of Summer '23, the Apex language now allows you to dynamically get a label WITHOUT using the visualforce trick above. There is a new method, system.label.get() which takes a label name (and ...
Christian Carter's user avatar
7 votes
Accepted

Is it possible to preserve created date and last modified date on importing records

Yes, you can import records with created and last modified dates the first time. You need not to create a case with salesforce for this. You need to enable this in Setup | Customize | User Interface |...
C. Praveenkumar's user avatar
7 votes

Formating Date time field in excell to import via data loader

You want to format it as: yyyy-mm-ddThh:mm:ssZ Where you can just make hh:mm:ss be 00:00:00. e.g. 2016-01-18T00:00:00Z
Nick C's user avatar
  • 6,790
7 votes
Accepted

Import contacts SFMC via API vs FTP

This depends on how often these contacts are updated. You can easily have 1M+ contacts, but only 10.000 of them have monthly activity, keeping the number of data update calls to SFMC at a minimum. ...
Lukas Lunow's user avatar
  • 21.8k
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....
sfdcfox's user avatar
  • 497k
6 votes
Accepted

Automation studio SFTP file drop trigger to Import Activity

So the way I solve file conflict scenarios if I have no control over the file naming patterns is: Create 2 File Locations pointing to 2 seperate folders in your FTP: File Locations: import/...
thechrishaddad's user avatar
6 votes
Accepted

Updating All Subscribers from Data Extension

It's certainly a recommendation to build an import process to your All Subscribers in order to keep in sync the email address from your Data Extension with the email address in All Subscribers. ...
Gravitai's user avatar
  • 2,850
6 votes
Accepted

Auto Generate Subscriber Key

I personally don't recommend SFMC providing Subscriber Key to your contacts. The only way you can identify/deduplicate your subscribers on import will still be on email address - which will change ...
Lukas Lunow's user avatar
  • 21.8k
6 votes
Accepted

file trigger automation filepart error

My best guess here is the file is being renamed between triggering the automation and reaching the import activity. And I am not talking about something.csv to whatever.csv, but more on the filename ...
Lukas Lunow's user avatar
  • 21.8k
5 votes
Accepted

Update MobileConnect Demographics from a Data Extension

Please check you mapping in the import definition. On some occasions, the "Map by Header Row" is failing. Even though the mapping looks correctly in the UI, it fails to map the fields properly. ...
Lukas Lunow's user avatar
  • 21.8k
5 votes
Accepted

Limitations for Import from Enhanced FTP in SFMC

File Imports are the most tried and true method of getting large amounts of data into SMFC. As for limitations -- most of the issues I've seen with imports haven't been with size or row counts -- it'...
Adam Spriggs's user avatar
  • 30.8k
5 votes
Accepted

import es6 from an extra javascript file in another component bundle in LWC

On the Salesforce platform, you can't import a specific file from another module. You can only import the entry file. If you want module2.js to import some value exported by module1-extra.js this ...
pmdartus's user avatar
  • 2,687
5 votes
Accepted

Can't import createElement into lightning web component

TL;DR: you can't use createElement on the Salesforce Platform. Dynamic component creation isn't available in Lightning Web Component on the Salesforce Platform, mostly for performance reasons. You ...
Fabien Taillon's user avatar
5 votes
Accepted

Importing KvK NL CRT certificates to the Salesforce org

I'm afraid you're out of luck on this one. If you're making a callout (in Apex) from Salesforce to some external site, then that site needs to present a valid certificate chain that ends up pointing ...
Derek F's user avatar
  • 62.8k
4 votes
Accepted

Updating All Subscribers List with query, extract and import

Since you wanting to update the All Subscribers list (not a data extension), the correct field name is Email Address (note: the space). You will need to rename the header in your file to match or ...
David Devoy's user avatar
  • 2,615
4 votes
Accepted

List Import Error: Invalid Context Status

Figured out what was wrong. Initially the list was 2.2M long and I chose to go with the automatic mapping suggested by the wizard. This imported about 1.7 M customers and failed on the remainder. To ...
0xsegfault's user avatar
  • 6,603
4 votes
Accepted

How many concurrent import activities to DE

I've never had a problem running multiple imports to separate data extensions within the same step of an Automation - I've ran 19 imports once. What isn't advisible is to run multiple imports to the ...
Gravitai's user avatar
  • 2,850
4 votes

Add Only on an import definition requires a primary key?

The functionality of "Add Only" import type is to add new records. For instance your DE contains 4 records already and now you are importing a file with 6 records(that file contains those 4 already ...
Krati Garg's user avatar
4 votes

Is there a way to load every label data and every SObject description data in Lightning Web Component using only Javascript without any Apex?

An ES6 module is a JavaScript file that explicitly exports variables or functions that other modules can use. Modules make it easier to structure your code without polluting the global scope. ...
Pranay Jaiswal's user avatar
4 votes
Accepted

Trouble importing CSS from one LWC into another

Never mind just figured it out. I am using IntelliJ with Illuminated Cloud. Upon creation of a new LWC Illuminated Cloud instantiates a HTML and JS file in addition to the .css and .js-meta.xml files. ...
Arthlete's user avatar
  • 4,957
4 votes
Accepted

Save imports in file and use it in LWC js

Yes, you can do it via modules. Create a new LWC component for your fields. Add all imports to .js file. // myFields.js import ITEM1_API_FIELD from '@salesforce/schema/SObject.QX_Item1__c'; import ...
Piotr Gajek's user avatar
  • 2,784
4 votes
Accepted

Importing LWC JS function from different LWC's is not working

Yes, this is something that can happen because of how things are bundled before being sent to the client. It is for this reason that I always recommend using a service component. Separating your ...
sfdcfox's user avatar
  • 497k
3 votes
Accepted

How to automate/schedule data import to Marketing Cloud from Salesforce Report?

Yes. You can do this with Automation Studio. Since your interaction is not triggered by an FTP file drop, you have have to schedule an hourly import job in automation studio. Go to automation studio, ...
0xsegfault's user avatar
  • 6,603
3 votes

List Import Error: Invalid Context Status

Posting as an alternate answer as requested: Typically this error is from trying to import subscribers with a status field value that isn't 'Active' or 'Unsubscribed'. You can't upload subscribers ...
AnonWonderer's user avatar
  • 2,133
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

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