Data Import - identify related Contact entity by email

[BattleMetalChris]

Reposting this, I saw that Yuri mentioned in another post that some posts had disappeared after a forum upgrade and mine seems to be one of them.

We have a custom entity named Mailing List Member - we want to be able to bulk upload these using the Data Import but they hold a reference to a Contact entity. The only options for identifying these in the field mapping are using the ID or the Name field. Is there a way to identify them by the email field? Ideally in the field mapping there'd be an option 'Contact (Email)' to choose.

I'm happy writing custom code if needed.

[victor]

If I'm not mistaken:
In this thread, one of the users answered you that such a thing is only possible with the use of encoding, and in the next post you seem to agree that encoding is not a problem for you.

[BattleMetalChris]

I was hoping someone had already attempted this and had some advice ^_^

No problem if not.

[ILoveEspo]

I'm trying to do something similar. Currently have Leads, Organizations, Users, etc from Pipedrive but we have a lot of custom fields in those tables. We have been mostly discussing on a macro level about our Pipedrive -> Espo switch but I see that it's not so easy.

[yuri]

It's possible to relate by a foreign field. You need to create a Contact Email foreign field in your entity with Relate on Import checked.



It's a documented feature: https://docs.espocrm.com/administrat...ort/#relations

I tested and it related a contact by its email.