Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
Data Import Wizard doesn't show custom field of a custom object.
All the fields have its Field level security set for Admin Profile. even though i cannot see fields in native import wizard. i have 7 fields among which only 2 are automatically mapped other are not visible
I haven't created a tab for the custom object, will it be a issue.
Please let me know which part i'm going wrong. Thanks in advance.
I had the same problem and I have found a solution. The new Data Import Wizard picks the default record type and page layout as the controller for the visibility. You need to go to the profile and check what is the default record type and check if that record type page layout has the custom fields visible.
It worked for me.
This is a known issue listed on salesforce site
https://success.salesforce.com/issues_view?id=a1p30000000jjYUAAY
The Data Import Wizard uses page layouts and field-level security to determine the fields available on import.
In order for a field to be visible within the Data Import Wizard, it must be available to the user within the page layout and field-level security. This applies to end users as well as users with a System Administrator profile.
Go to the field and click on this button for the field and check it should be editable for the profile you are using.
For the auto-mapping your column name in CSV file should be same as Label or API Name of field
Fields must be visible to the profile of the logged in user. Click on the fields that are not visible and click on the View Field Accessibility Button and check against the profile of logged in user, it should not be hidden.
I had same issue with lookup fields. I went back to the Import your Data into Salesforce step of the wizard and mapped these lookup fields to the data type here and they were then available to map on the next page.
What has not been mentioned here is that on the page where you select Add or Update. You must scroll down the page to select the appropriate record type.
This solved the problem I had.
You can select Record Type under Add/Update options in the Data Import Wizard. That would open up more options available for a specific record type which could be missing on your default profile record type.
If it helps anyone in the future: If this problem is only for NON Admins, then a setting in the profile called 'Import Custom Objects' (setup--> profile --> system permission --> Import Custom Objects) can also help.
Updating/Checking the profile and field level security for editable permission is not sufficient for some reason you need to make it visible on the page layout as well.
