Import stream/mails from other crm

[SpeedBullet]

I successfully imported contacts, leads, accounts, opportunities, tasks, etc... from zurmo CRM. Is there a possibility to also import notes (or stream as it's called in espocrm) and emails attached to those zurmo contacts, leads and accounts? I'd like to get all my contact's history into espo, then I can ditch zurmo all together and fully work with espo. Thanks!

[yuri]

You can write script that will import it. Notes and emails are not supported in Import.

[SpeedBullet]

You can write script that will import it. Notes and emails are not supported in Import.

I looked at the database, I wanted to import them directly but I see they have hashed ID's... how would I go about generating those?

[yuri]

You can do in through php using entity manager frramework of EspoCRM

[rodrigocoelho]

Hi SpeedBullet, I'm trying the same thing. Please keep me informed if you have good results. Specially related to Notes and multiple email fields.

[SpeedBullet]

Hi SpeedBullet, I'm trying the same thing. Please keep me informed if you have good results. Specially related to Notes and multiple email fields.

I have no clue unfortunately... I don't even know how to start generating those espocrm ID's that are assigned to notes. Otherwise my plan was to insert them in the sql database with queries directly to the correct contacts but the espo-generated ID's stop me from doing that.

[rodrigocoelho]

I have no clue unfortunately... I don't even know how to start generating those espocrm ID's that are assigned to notes. Otherwise my plan was to insert them in the sql database with queries directly to the correct contacts but the espo-generated ID's stop me from doing that.

Maybe yuri could give us a help... Help us Yuri.....

[yuri]

create file in espocrm root directory. This will work only with recent versions of EspoCRM.

<?php

$contents = file_get_contents($argv[1]);

include "bootstrap.php";

$app = new \Espo\Core\Application();

$app->setupSystemUser();

$container = $app->getContainer();

$entityManager = $container->get('entityManager');

// here implement your import using entity manager

This is all I can help with.

[rodrigocoelho]

The rest of help can be found here:

https://www.espocrm.com/blog/orm-how-to-manage-entities-in-your-code/

Thank you yuri
I'm not a programmer, so, will wait for SpeedBullet

[yuri]

Or here: https://github.com/espocrm/documenta...lopment/orm.md