Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    please let us know if you are following this?

    http://download.microsoft.com/download/6/D/6/6D67BDEA-1D67-42B4-A52A-CF13CD547CB5/OPtoCRMOnlineMigration.pdf

    regards

    Jithesh

    Tuesday, November 4, 2014 11:55 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    hth.

    regards

    Jithesh

    Tuesday, November 4, 2014 8:39 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    and the following blog explains the relationship.

    http://missdynamicscrm.blogspot.com.au/2014/09/deciphering-the-relationship-activitypointer-activitytype-phonecall-appointment-activityparty-crm-2011-2013.html?m=1

    Tuesday, November 4, 2014 8:44 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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. 

    Link:

    http://msdn.microsoft.com/en-us/library/microsoft.xrm.sdk.iorganizationservice.create.aspx

    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