SimpleImport comes packaged with a Managed Import lightning component that allows you to drag and drop an importing widget into any Salesforce Lightning App Page, as well as a Salesforce Partner Community. This provides your internal and community users the ability to import and update records into an object and its fields that are pre-determined by the user configuring Managed Import.
Creating a saved mapping
Create a new template spreadsheet file for use with Managed Import. The file must contain column headings that will match up to fields within your Salesforce Org followed by a row of sample data underneath each column header.
Save the file on your computer.
Navigate to the SimpleImport Tab within Salesforce.
Upload the created template file.
Once the file has uploaded, select the Import to Salesforce button.
Select your Object(s) of choice.
Create a mapping in line with the Getting Started guide by mapping fields using the field finder and enabling matching if required.
Once the mapping has been created, select Save Mapping.
Name the mapping and select Save.
After saving the mapping, Cancel the import which will return you to the main screen.
Creating a custom setting
Before being able to use Managed Import, you will be required to active the mapping for use. If you skip this step, the following error will be shown when trying to use Managed Import:
Failed: Managed Import is not properly configured. Please contact your system administrator.
System Administrator with a SimpleImport license
The following steps must be taken via a System Administrator. If the System Administrator does not have a SimpleImport license, see the next section.
In SimpleImport, select Preferences in the top-right of the screen.
Scroll to the Mapping List section.
Search for the mapping by using the Search box.
Select Create Custom Setting in the Action column in the resulting row, a confirmation will appear once the custom setting has successfully been created.
Whilst on this page, make a note of the Mapping ID found in the ID column as this will be used in the next step.
System Administrator without a SimpleImport license
If your System Administrator does not have a license for SimpleImport, follow the steps below to manually create a custom setting to activate the mapping for use.
Have a licensed SimpleImport user fetch the Mapping ID via the preferences page and make a note of it.
Go to Setup | Custom Settings.
Select Manage next to Managed Import Settings.
Add a Name to the custom setting so that you are able to identify it.
Enter the Mapping ID sent to you into the Mapping ID field.
Adding the Managed Import Lightning Component to your page
The Lightning Component can be added to any Lightning App Page or Community layout across your Salesforce Org. This following steps will show configuration of the component on the home app page, but similar steps can be replicated across any app or lightning community page.
Navigate to Setup and select Lightning App Builder from the setup menu.
If you already have a custom Lightning Page for your page you want the component to sit on, select Edit next to it, alternatively, select New and follow the steps through to creating a new page.
From the component menu on the left of the screen, drag the Managed Import custom component onto your layout.
Once placed, the design parameters menu on the right of the screen will appear. In the Mapping ID field, enter the ID captured in the previous section.
Three other design parameters are available, edit them to meet your desired requirement:
- Button Text – for renaming the button’s text, leaving it blank will populate the button with “Import Records”
- Component Title – Give the component a title so your users can spot it, leaving it blank will hide the title and import icon.
- Component Message – A text area provided allowing you to write a message for your users to read, leaving it blank will hide the text area.
If you are experiencing any issues with the setup of your Managed Import component in your Org, please reach out to firstname.lastname@example.org where a member of our team will be happy to assist.