how to map comments in drupal migrate module So im migrating comments from a different database to Drupal 7 but i cant understand why this wont work. Im successful with migrating nodes, i only mapped the node fields and somehow its node_revision seemed to have automatically updated too.

But in comments it doesnt work, i know to add a comment these tables are affected in drupal:


comment
field_data_comment_body
field_revision_comment_body


am i missing some mapping here in my code?

$this-&gt;addFieldMapping('cid', 'id');
    $this-&gt;addFieldMapping('is_new')-&gt;defaultValue(TRUE); // i dont know what this thing does


    $this-&gt;addFieldMapping('nid', 'mainthread');
    $this-&gt;addFieldMapping('pid', 'parent')
         -&gt;sourceMigration('ForumComment')
         -&gt;description('Parent comment.');
    $this-&gt;addFieldMapping('comment_body', 'body');
    $this-&gt;addFieldMapping('subject', 'subject');
    $this-&gt;addFieldMapping('hostname', 'host');
    $this-&gt;addFieldMapping('created', 'date');
    $this-&gt;addFieldMapping('changed', 'last');
    $this-&gt;addFieldMapping('name', 'author');
    $this-&gt;addFieldMapping('status')
         -&gt;defaultValue(COMMENT_PUBLISHED);
    $this-&gt;addFieldMapping('comment_body:format')
        -&gt;defaultValue('full_html');

    /*$this-&gt;addFieldMapping('uid', 'accountid')
         -&gt;sourceMigration('WineUser')
         -&gt;defaultValue(1); */


    //optional
    //$this-&gt;addFieldMapping('tid', 'category_id');
    //$this-&gt;addFieldMapping('comment_count', 'hits');

    // Unmapped destination fields
    $this-&gt;addUnmigratedDestinations(array('uid', 'thread', 'mail', 'homepage', 'language', 'comment_body:language'));

      $this-&gt;addUnmigratedSources(array('category_id'));


and is my destination correct? here it is:

$this-&gt;destination = new MigrateDestinationComment('comment');


based on my code only the comment table is mapped, i just assumed that the body and its revision will automatically map too like in my migration of nodes.

Help please
I got it, you need to add another class for the mapping of the body of the comment

and the destination should be 'comment_node_forum'