Skip to main content
Group

Data Import

This group will be the new home of data import functionality in Salesforce. It covers the current available tools - Data Import Wizard - Data Loader - Legacy Import Tools and will also be the place to discuss exciting upcoming new data import capabilities. eMail to group: 0f9300000009rouca2@post.3-itzeai.na1.chatter.salesforce.com

Hello,

 

I have this error when i try to import a profile in another organisation, i looked up and i found that this error is for "Notification Emails: Add Recipients", do you know how can i resolve this please ?

1 answer
  1. Ines Garcia (get: Agile) Forum Ambassador
    Jan 22, 2024, 1:42 PM

    Hi Daniel,  what do you mean ""import a profile in another organistion" how ar eyou trying to do this exactly?

    and also just FYI, you can add one post here and tag multiple groups/topics when relevant, so need to duplicate entries at all!

0/9000

I Have CSV file, inside file there is a lookup relationship field, I can't import this field with data import wizard. How I can do that? it is posible import lookup relationship field to custom object?

Thanks

1 answer
  1. Jul 6, 2023, 3:39 AM

    If the lookup field is required you have to add the lookup field ids in the csv file for that lookup field and try to import  else if the field is not required skip mapping of that field and try to import

0/9000

Hello! I'm working on a project that requires importing 151k+ files and I'm currently using dataloader (apex/desktop) and it's pretty tedious, especially when I hit the java heap space error. With dataloader, we have to import in batches of 1, but the import file itself cannot contain all 151K rows, so I have to split out the import file into chunks of 300-400 rows. Then if any single file happens to be >25MB, java heap space error and I have to research where it actually stopped in the migration process against my import file. 

 

Has anyone come across any other tools to make files imports easier and/or faster? 

 

#Import Data Challenge

#Salesforce Admin

 

@Salesforce Administrators & Developers @Salesforce.org System Administrators

3 answers
  1. Ines Garcia (get: Agile) Forum Ambassador
    Jun 30, 2023, 10:51 AM

    hmm Gary, do you work 'for salesforce'? asking for the company name selected... why each post promoting external site and how ever old the post is.

    There is tons of Salesforce content within domains available and in context

0/9000

We are looking to train our data ops team on CDT, this training does not come under the standard training plan budget with our implementation partner - if anyone else in non-profits can let me know who trained the CDT aspect for salesforce and what this training plan might entail? Thanks Dani 

0/9000

Hi there, 

I'm importing data using Inspector and Salesforce is adding 5 hours in a Date/Time field. How can I fix the import to obtain the correct time? 

Anyone can help me with this?

2 answers
0/9000

hello guys, I'm new to salesforce I'm trying to import contacts from production to sandbox(Full). Are there any steps I need to follow as it keeps failing.

6 answers
  1. May 3, 2022, 3:41 AM

    @Stella s to suggest a basic step: have you tried going into Contacts and changing the list view to viewing those as 'All Contacts' (and perhaps search for some to confirm) just to review what is already in your sandbox?

0/9000
1 answer
  1. Feb 13, 2022, 5:16 PM

    For Informatica-specific questions you may get better luck on their forums as they're pretty active. 

0/9000

Hi folks.

I'm seeing some REALLY strange behaviour with the NPSP data import tool.

I've filled in the data for "Contact1 First Name" and "Contact1 Imported" but they're not importing into the NPSP data Import record. The "Contact1 Last Name" is importing fine.

This is the same behaviour for contact 2 as well.

Looking at the field mapping, we can actually see the sample data appearing against the first name and Contact 1 Imported fields. However after you import the file and look at the actual record the fields are blank.

4 answers
0/9000

Requesting Feedback on Bulk Data Load Jobs Page in Setup:  I am an Associate Product Manager on the Platform Services Team at Salesforce. We plan to improve the Bulk Data Load Jobs Page in Setup. We want to hear about your experience with the current page and what improvements you are looking for. Please message me on Trailhead, email me at abhilash.samantapudi@salesforce.com, or comment below if you are available for a quick 15-20 minute call. If not, you can also share your feedback via this short 4 question survey: https://forms.gle/zyA6zvVUcdgJHmV66  

@Data Import @True to the Core FYI @Sanghoon Oh

4 comments
  1. Dec 8, 2021, 4:05 PM

    Having the ability to download the request and results in the Bulk Data Load Jobs in Setup would be helpful like in V1.

0/9000

Creating new users with Dataloader. I've figured out all the other fields I need. Does anyone know which object is used in Dataloader to import the Id's for the CPQ Permissions Set License and AA (Advanced Approvals) Permission Set licenses?

2 answers
  1. Nov 18, 2021, 1:59 PM

    Got the answer.

    Object: PermissionSetLicenseAssign

    Columns in Excel: PermissionSetLicenseId and AssigneeId

    Query to get PermissionSetLicenseId: Select Id, MasterLabel From PermissionSetLicense

0/9000