Entity Mapping/Import
Last updated
Last updated
The web services and values defined in the Entities tab are available in the next tab, Entity Mapping/Import. This screen allows users to import ERP fields from Sage. Customers for example along with their respective contacts can be imported into Salesforce Accounts and Contacts. The import routine can be run as needed or automated to a set schedule.
Login into Salesforce, navigate to the GUMU™ Settings app, and click on the Entity Mapping/Import tab (you will notice default mappings that were created during the installation process)
Note: If you are unable to click the buttons, go to Session Settings > Lightning Web Security and uncheck the Use Lightning Web Security for Lightning Web components and Aura components checkboxes.
You need to sync the import routines one by one, to do this click the blue eye icon to view and then click the Sync Now button.
The Sequence in which the Import routines should be synchronized are as follows:
Location Entity
Location
Department
Project
Product
PricebookEntry STD
PricebookEntry
Account
BillToContact
ShipToContact
Order
OrderDetails
Import Sales Invoice
Import Sales Invoice item
You can sort the import routines based on type.
Let us understand the tabs and fields one by one. Click on the eye icon of “Sage Intact-Account import routine.
To schedule Import Routines, under the Action panel click on the green pencil icon to edit.
Click on the Schedule button at the top right and a new screen will appear as shown.
Set the Next Run Date & Time select Schedule Type as Hourly/Daily/Weekly/Monthly and click on the Save button (you can see the Previous Run Time when the current import routine runs)
To skip a schedule for a specific time, use the Skip Schedule tab, enter the start time and end time, and click Save.
Export Mapping
If you want to add the mapping to a different Salesforce Org without creating it manually, you can now Export the mapping from one org to another (e.g., Sandbox to Production)
Select the entity mapping you want to export and click on the Export Mapping button.
The selected Entity Mapping file will download immediately.
The next step is to log in to the other Org (Here we are showcasing in the same Org) and navigate to the Entity Mapping/Import tab, click the Import Mapping button, then click the Upload File button to upload the file.
After the file uploads, the user needs to click on the “Import” button. This will start the internal processing and once done user will be notified with a success message.
Details Tab
Navigate to the Details tab and click on the Mappings tab, here you can map the Sage fields with Salesforce fields (add additional mappings by clicking on the Edit button followed by the Refresh Fields button at the top).
Navigate to the Filter tab, here you can add a filter to the import routine if you want to import specific data (for example, we have filtered the import routine based on the Customer No 0000010), and click Save.
Click on the Preview button at the top to view the data from Sage, then import by clicking the Sync Now button present next to the Preview button.
The Relationship tab allows you to specify Parent-Child relationships (for example, Contact will always have a relationship with Account which we can define here).
You can set up a Relationship to Sync if the target object has a parent in Salesforce (for example, Account-Contact)
To add a relationship, click on the Add Row button, and select the Target, Source Field, and Parent Object Name from the list of Salesforce Objects (for example, Account is the Parent Object of the Contact object in Salesforce).
In the Logs tab, you can view the status of the import/sync.
Filter | Description |
---|---|
Fields | Detail |
---|---|