diff --git a/src-db/database/sourcedata/OBEI_ENTITY_MAPPING.xml b/src-db/database/sourcedata/OBEI_ENTITY_MAPPING.xml
--- a/src-db/database/sourcedata/OBEI_ENTITY_MAPPING.xml
+++ b/src-db/database/sourcedata/OBEI_ENTITY_MAPPING.xml
@@ -128,6 +128,22 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml b/src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
--- a/src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
+++ b/src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
@@ -604,6 +604,21 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -1302,6 +1317,21 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src-test/org/openbravo/service/external/integration/test/TestConstants.java b/src-test/org/openbravo/service/external/integration/test/TestConstants.java
--- a/src-test/org/openbravo/service/external/integration/test/TestConstants.java
+++ b/src-test/org/openbravo/service/external/integration/test/TestConstants.java
@@ -30,6 +30,7 @@
public static final String IMPORT_COUNTRY_ENTITY_MAPPING_ID = "1B9B0EC68F334C1EB6F4155AA2499ED5";
public static final String IMPORT_BP_ENTITY_MAPPING_ID = "564105CDF42B4D7B9A7066148A79E073";
+ public static final String IMPORT_USER_ROLES_ENTITY_MAPPING_ID = "6C3C50A7E8614FB9A006857B5E71C0C4";
public static final String IMPORT_PRICELIST_ENTITY_MAPPING_ID = "18449AC7EB934AD39FF406F639BF30FC";
public static final String IMPORT_COUNTRY_ENTITY_WITH_EXTENSIONS_MAPPING_ID = "4FD34B1171CF4EC8AB3AEFCE55F05AB0";
public static final String WRONG_IMPORT_ENTITY_MAPPING_ID = "DFF92D56616E4E12A61A2288CC104E3F";
diff --git a/src-test/org/openbravo/service/external/integration/test/_import/UserRolesImportTest.java b/src-test/org/openbravo/service/external/integration/test/_import/UserRolesImportTest.java
new file mode 100644
--- /dev/null
+++ b/src-test/org/openbravo/service/external/integration/test/_import/UserRolesImportTest.java
@@ -0,0 +1,78 @@
+/*
+ ************************************************************************************
+ * Copyright (C) 2020 Openbravo S.L.U.
+ * Licensed under the Openbravo Commercial License version 1.0
+ * You may obtain a copy of the License at http://www.openbravo.com/legal/obcl.html
+ * or in the legal folder of this module distribution.
+ ************************************************************************************
+ */
+package org.openbravo.service.external.integration.test._import;
+
+import static org.hamcrest.Matchers.is;
+import static org.junit.Assert.assertThat;
+import static org.openbravo.service.external.integration.test.TestConstants.IMPORT_USER_ROLES_ENTITY_MAPPING_ID;
+
+import org.junit.Before;
+import org.junit.Test;
+import org.openbravo.dal.core.OBContext;
+import org.openbravo.dal.service.OBDal;
+import org.openbravo.model.ad.access.UserRoles;
+import org.openbravo.service.external.integration.SynchronizableBusinessObject;
+import org.openbravo.test.base.TestConstants;
+
+/**
+ * Tests some special cases when creating business objects through the import infrastructure. For
+ * example, checks that it is possible to use a multi-path property (i.e. role.name) as "identifies
+ * record univocally".
+ */
+public class UserRolesImportTest extends BaseImportTest {
+
+ @Override
+ protected String getEntityMappingId() {
+ return IMPORT_USER_ROLES_ENTITY_MAPPING_ID;
+ }
+
+ @Before
+ public void setOBContext() {
+ OBContext.setOBContext(TestConstants.Users.OPENBRAVO, TestConstants.Roles.FB_GRP_ADMIN,
+ TestConstants.Clients.FB_GRP, TestConstants.Orgs.MAIN);
+ }
+
+ @Test
+ public void testCreateOnImport() {
+ try {
+ String user = "F&BUser";
+ String role = "F&B España, S.A - Finance";
+
+ // ADUserRoles does not exists yet
+ assertThat("ADUserRoles object does not exist yet", userRoleCreated(user, role), is(false));
+
+ importSynchronizableBusinessObject(getNewUserRolesSBO(user, role));
+
+ // ADUserRoles object is created
+ assertThat("ADUserRoles object is created", userRoleCreated(user, role), is(true));
+
+ } finally {
+ // Do not persist the BOBs created just for testing
+ OBDal.getInstance().rollbackAndClose();
+ }
+ }
+
+ private SynchronizableBusinessObject getNewUserRolesSBO(String user, String role) {
+ SynchronizableBusinessObject sbo = new SynchronizableBusinessObject();
+ sbo.addProperty("User", user);
+ sbo.addProperty("Role", role);
+ return sbo;
+ }
+
+ private boolean userRoleCreated(String user, String role) {
+ String hql = "select ur from ADUserRoles ur where userContact.name =:user and role.name = :role";
+ return OBDal.getInstance()
+ .getSession()
+ .createQuery(hql, UserRoles.class)
+ .setParameter("user", user)
+ .setParameter("role", role)
+ .uniqueResult() != null;
+ }
+
+}