19 thoughts on “Data Import Wizard”

1. I receive an email when my imports are complete that states the following: “Processed job information for imported Accounts: No link is available because you do not have the correct permissions to manage Bulk Api jobs.”

   I am a system administrator so we are unsure of what permissions I need. Is there a log somewhere that can show which records did not import?

   1. Hey Jay,

      I am not sure about it as you have system administrator profile. But normally to receive the link to view the Success/Failed accounts link, It required to have “Manage Data Integrations” permission on the user’s profile. Also check known issues https://success.salesforce.com/issues_view?id=a1p30000000SupPAAS

      Rakesh

2. Nice article Rakesh.. If Salesforce could introduce Batch size in Import wizard then it have been better 😛

   1. Agree with you,Thanks for your comment 🙂

3. nevermind- I see the problem is in my permissions- I will contact my admin – thanks anyway!

   1. Thanks for your response

4. In my account (Salesforce 14) there is no import wizard under Data Management – only Analytic Snapshots and Sandboxes. Any ideas why or where it may be? THanks!

5. Check this out – my production instance

   http://oi57.tinypic.com/2q30l13.jpg

   1. Yes, after Winter’14 refresh all organisation contains beta version of data import wizard

6. @Rakesh – Neat explanation, I wish the Salesforce has more options up here, so limitation I figured out in first view are

   This is very ‘limited’ version of my favorite ‘DataLoader.io’, this is missing some of key feature, not sure you know answer on them, as because this is broken on both sandbox and production instance for me (cs12, na5, na15)

   1. Can I do object Id discovery, what if I want to discover Id based on some criteria and import data based on id-id match or any match(most required)

   2. Scheduling Job – Can I schedule a job to run in future on a schedule

   3. Job resume/retrieval – what if I want to save this job for future use, can I save the job and resume it later at any time once logged in back .

   4. Does it take backup before making changes, do we receive sort of data recovery file, what if we mess, how do you recover ?

   6. Cloud integration for file host (most needed) in USA majority of companies now use file cloud (Box, DropBox) and other cloud based sharing, I wish this support more, I can see Gmail CSV is support but that too need local storage

   7. API call limit set (How can I set batch size, as this may cause an issue to my trigger and may error out ) when ran in bulk ?

   -Harshit

   1. Hi Harshit,

      Production ?? (I think this feature will available on production on 14th march 2014 as per mentioned in Salesforce schedule maintenance page)

      1. As you mentioned in previous comment, every thing we have to do in excel. This is very limited version.
      2. No, you can’t schedule job for future run, may be Salesforce add this feature in next release.
      3. I don’t think, there is no such option.
      4. No, you will get only a confirmation mail. You can monitor data load by visiting Name | Setup Jobs Administration Setup | Monitoring | | Bulk Data Load Jobs
      5. Yes I am also agree with you. Hope see this feature on next summer’14 release.
      6. We can’t set this in Data Import wizard, I know only Data loader where we have this option.

      Thanks for your comment.

      Regards,
      Rakesh Gupta

7. Did I miss whether the data import wizard will allow duplicates or not?

   Thanks!

   1. No, It won’t allow duplicates based on ID or Name. like example if you have a .csv that contain three records with same name. when you will use this file with Data import wizard select “Match Account by” account name so it will insert only one record in Salesforce. Let me know if you still have a query.

      1. Thank you. And if the Account already exists but you are adding a new contact to that account, do you need the account ID or will it match it?

         Love your blog!

         Thanks!

         1. Hi Alisha,

            In that case you have to provide Account ID.
            Thanks for your feedback.

            Regards,
            Rakesh Gupta

   2. @Alisa – Salesforce provide 15-18 char unique ID, best practices would be to match on ID. Far as name is concerned, this is curser push/pull. When you de-dupe you need to track back to check if the account is previously updated or not, which seemingly is low on probability that will de-dupe it for you. I recommend, de-dupe your data in Excel simply before importing to SF

      1. I import lists from events so often I will not know how many, if any of the contacts on a given list are new or existing contacts. I am trying to avoid exporting and doing a vlookup on each import. But is that was true Salesforce Admins need to do?

8. Great blog Rakash as usual. May I ask you questions:
   1. Will Existing Wizard removed ?
   2. What is the advantages compare to Existing Wizard ?
   3. How about compare to Data Loader and dataloader.io ?
   Thanks.

   1. Thanks Johan.Please find the answer below
      1. No existing wizard will also exist
      2. Streamline user interface that makes uploading data files and mapping easier then ever. You can drag an drop file here too.
      3. Salesforce administrator can import upto 50,000 records at a time, Other user can import 5,000 records at a time.

This site uses Akismet to reduce spam. Learn how your comment data is processed.