Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs
9 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. ...
glls's user avatar
  • 20.2k
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
6 votes
Accepted

Why is the LastName field required for the contact? What is the best approach to import contacts that only have the first name?

As for the LastName being mandatory, I can only say that it's by design. And seems there were ideas to get it optional, but Salesforce doesn't have any plan to do so. So it is very unlikely we can get ...
Jayant Das's user avatar
  • 30.6k
6 votes

Bulk data load make the global search unusable

There is the article Salesforce Bulk Data Loads and Full-Text Search Indexes by Salesforce engineering. Strategies for Addressing Lags in Search Indexing So how can you architect acceptable ...
Daniel Ballinger's user avatar
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
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 ...
Santanu Boral's user avatar
4 votes
Accepted

Notes. Mass Upload. Hitting some limit and getting "Note can't be saved"

The standard limit on inserting ContentVersion, which underlies Notes, is 200,000 per day. I suspect you've reached that limit. Unfortunately, I am not aware of a way to view the consumption of this ...
David Reed's user avatar
  • 93.1k
3 votes
Accepted

Import Definition - File not found (automation studio)

Try using the following: WERBEKO-%%Year%%_%%Month%%_%%Day%%.csv Bare in mind, that each day it will only import the file with that day's date. Read about Import wildcards on Adam's blog: https://...
zuzannamj's user avatar
  • 14.4k
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
3 votes
Accepted

Bulk data load make the global search unusable

Found Solution: The approach is load data as slowly as possible. If you load relatively less records (say 5k or less) the global search is available in the matter of seconds (for me, it was less than ...
AtulRajguru9's user avatar
  • 9,120
3 votes

Exporting data from partial sandbox to developer sandbox for related objects

For this task, I recommend Salesforce DX. Simply export the records you want with: sfdx force:data:tree:export -q "query" -p -u sourceOrg This gets you a set of files (something like Accounts.json, ...
sfdcfox's user avatar
  • 493k
3 votes
Accepted

Exporting data from partial sandbox to developer sandbox for related objects

Data Loader When importing multiple connected objects, it's critical that you retain the success files that Data Loader emits. These allow you to map from old Ids to new Ids as you're populating ...
David Reed's user avatar
  • 93.1k
3 votes
Accepted

What is ACT! in Salesforce

ACT! is another CRM system (so a competitor to Salesforce) see the wikipedia article. The documentation you've linked says that it's possible to export contact data from ACT! (as some file using a ...
Derek F's user avatar
  • 62k
3 votes

Is it possible with Import Activity to clear data extension if salesforce report is empty?

This indeed is something which is not enabled by default. You will need to ask Salesforce Support to allow allow blank file processing - a setting which is managed by a business rule in the backend of ...
Lukas Lunow's user avatar
  • 21.6k
2 votes

ValueOutofRange error

I just got this error, and it looks like my DATE field is the issue - some of my dates are listed as 12/31/0069 - so the year appears to be the cause of the failure. I realize this post is over 2 ...
George Rosedale's user avatar
2 votes
Accepted

How do I restrict access to the Data Import Wizard but still allow object edit/create in UI?

The Data Import Wizard is governed by a few permissions. See What permissions do I need to import records? for more details, but basically, if you want to restrict all access, you can remove the "API ...
sfdcfox's user avatar
  • 493k
2 votes
Accepted

How to clear the values in a number data type field while importing data?

You are getting this error because, you might have used the text NULL in the column mapped with the number field. With the setting "Insert Null values" checked in data loader, you will have to leave ...
Vijay Ganji's user avatar
  • 6,646
2 votes

Import definition for mobile connect

You just add in Automation studio using the "Import Mobile Contacts" activity:
Rafał Wolsztyniak's user avatar
2 votes

Salesforce relational data backup and reload after sandbox refresh

Please find my answer below but note some questions which would be helpful for SFSE to know: I assume the data set over the 5 sObjects isn't in Production already? If the full data set is already in ...
Andy Hitchings's user avatar
2 votes

enable a user to use the import wizard to upload custom object records?

To import records, following permissions are required. Please check if below permissions are given:- To import custom object data via the Data Import Wizard: “Import Custom Objects”  AND “...
Ashwani's user avatar
  • 22.6k
2 votes
Accepted

Export and Import of Salesforce Files and Notes from one production org to another production org

The key to this is the ContentDocumentLink record that is a junction between the Object (Account in your case) and the ContentDocument (which is the parent of ContentVersion). You have to reconstruct ...
cropredy's user avatar
  • 71.7k
2 votes
Accepted

Transforming .csv Discovery Report into pipe delimited Marketing Cloud

When you export a Discover report as a csv file, Discover uses double-quote as the text qualifier. In order to successfully import a file like this to a Data Extension, ensure you check the "...
Macca's user avatar
  • 8,236
2 votes
Accepted

Integrate Google Analytics with SFMC

First of all, the ability to receive audiences requires GA360: Google Analytics Free users get access to sampled data reporting about their customer interactions. Marketing Cloud adheres to Google’s ...
Lukas Lunow's user avatar
  • 21.6k
1 vote

MobileConnect Contacts Import Doesn't update Contacts' Status (Opted Out => Opted In)

It's not possible to resubscribe an opted-out contact with an import definition. The only way this could be achieved right now seems to be an API call executed to the API of Marketing Cloud from a ...
Rafał Wolsztyniak's user avatar
1 vote

Marketing Cloud_ImportFile Activity error

I also have the same issue but I resolved it by giving the file mapping "Map by Ordinal and checked Import file had column headers" instead of Map Manually.. then all records are imported
user85686's user avatar
1 vote

Populating Big Objects from CSV

You can use Data Loader to populate Big Objects, you just need to enable 'Use Bulk API' in settings. Warning: Big Objects have a number of caveats, the first one being that you have to pay for ...
identigral's user avatar
  • 7,618
1 vote
Accepted

InvalidDecimalScale SFMC CSV data import

try like this see this image you get some idea
Ravi.A's user avatar
  • 594
1 vote

SFDX force:data:tree:import MALFORMED_ID

I had the same error... It seems that SFDX tree:import is failing when field name has a number in it. Please look at this post here: https://developer.salesforce.com/forums/?id=9060G0000005OE3QAM ...
Lucas Ennouchi's user avatar
1 vote

SFDX force:data:tree:import MALFORMED_ID

Make sure that "resolveRefs" and "saveRefs" are set to true. For you basically it should be enough to set "saveRefs" to true for litify_pm__ChildObj2__c. When sfdx cli inserts its (...
Eduard's user avatar
  • 5,139
1 vote

imported data not displaying and no option to set tab to show "All"

In Classic, once you click on the tab, choose the All option in the View drop down menu and click Go. If there is no All option, click Create New View, give it the name All, and save it. In Lightning,...
sfdcfox's user avatar
  • 493k

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