Heavy problem/bug importing Activities

[nutri]

After a lot of headaches I realised that SugarCRM fails heavily when importing Activities and linking them to contacts. No data is inserted to meeting_contacts, meeting_leads, calls_contacts and calls_leads.

Is interesting to see that this two activities have different DB structure than Tasks that keep the parent_id and contact_id inside only one table.

All looks like that some developer decided to split meeting and calls table linking information in other two tables to reduce size, tested the code for creating new activities but did not test the importing data process. Also, I do not understand why, decided to keep task table in one piece. Probably the process was the other, from 3 tables to one, but again, something failed.

Also, in the importing process, the Advanced Option of date format definition seams to be not used, as I have "DD/MM/AA hh:mm" and none option permits me to import the data.

So the import Activity fails at all.

[salesagility]

If you have complex relational data to import it is simpler to write a script or use a tool like Talend/Jitterbit than to use SUgar to import the data.

[nutri]

I simply need link activities imported with account+contacts or leads. I just wanted to avoid scripting something suposed to be in the SugarCRM itself. The point is that scripting the code, if I don't know all tables where, for activities entries are inserted or how ids are generated and linked, all become prune error or partially correct. I suffered that in other open source crm, whose name would be deleted if written, and won't repeat same mistakes and loss of time.

Anyway that's a bug. Confirmed then and no patch as said the bugzilla web.

Probably will study the process how task are created to send the correct code, if have time.

Thanks.