Can't resolve the coupling between ActivitPointer and subentities RRS feed

  • Question

  • Hi,

    I'm trying to migrate CRM Dynamics On Premise to Dynamics Online. So far I've accomplished to migrate all of the data to online - except for the 'activities'-entities.

    So far I've noticed that all entities are ActivityPointers, with a ActivityTypeCode which refers to the kind of activity they are: Email, Fax, Phone, Letter etc. ActivityParty contains all the info about the regarding people (Bcc, cc, regaring, from, toRecipients etc).

    In my project I have to migrate the activities, first the Email. I just can't figure out what the EmailBase is for. It just got two attributes: ActivityId and CFIStatusCode (which is by all records is emty (NULL)). Do I have to Include this Entity for migrating to Online? With the same question for EmailHash and EmailSearch entities.. I've been figuring out this for days now and I'm literally with my hands in my hair.

    Also I've been looking for a Logical Database Diagram (model) for Online, so I can understand the database design. 

    Thanks in advance!

    Tuesday, November 4, 2014 10:08 AM

All replies

  • Tuesday, November 4, 2014 11:55 AM
  • Thanks for your reply!

    Two answers: I do and I don't. 

    At my firm here, we set up a FetchXMLConnector, which has in principle the same purpose..

    Therefore I have to extend the program to fetch and migrate the ActivityEntities, and I encountered the fact that the activities are more complex that thought they would.

    Thanks in advance

    Tuesday, November 4, 2014 12:30 PM
  • hi mate,

    as far as I know, there will not be much difference between online and onpremise database structure. And your data connector should be able to take care of the difference. So to get the structure, you could look into your onpremise database.

    to see the relationship, you can generate a database diagram in your _mscrm database.

    you can also generate classes using XRM and generate a class diagram.

    for emails, you can use deign view of filteredemail to get all related tables and the relationship.

    this is what I understand, with my limited database interaction.

    emailbase will hold the subject, and other common fields on form.

    activity pointer links email and activity party.




    Tuesday, November 4, 2014 8:39 PM
  • Hi, 

    First of all, thank you for your reply!

    The link you have sent, is very useful. Thanks. But, the problem I was stuck on a month ago, was the fact that the server of Online doesn't support a .Create() method to create the Activity (with sub-entities) and only the loose entities, such as Email, Phone, Appointment. 



    So, when I give the complex Activity-object to the server .Create(entity), I will get an error that there's no such method for the objectype. 

    How can I solve this? I have no idea how to map the complex Activity-object to the single objects.

    Wednesday, November 5, 2014 8:59 AM