help working with node reference

Ok, that helps -- was wondering if that might be the approach, thanks! Two follow-ups:

1. Is there an example I overlooked in the module examples (or elsewhere) that shows a node reference field mapping and such?

2. Where does the idea of stub nodes mentioned in the Economist article come into play?

Thanks so much for getting me pointed in the right direction (and for the amazing work here)!

Thanks much for the help -- will check it out.

Hi Guys-

After a few epic battles, I'm making some headway with Migrate. One nasty issue I've run into with my node refs, though. If the widget type for my node ref field is a select box, life is good. However, if the widget type is set to autocomplete text field, the node ref will not be set during import (have confirmed by trying the two widgets on the same field). We're using autocomplete quite a bit in conjunction with the snazzy node relationships module functionality, so I really don't want to have to switch back to select boxen. Any pointers for how I might work around this issue? Hoping I'm just not configuring something properly.

Thanks much for your continued assistance.

-Brant

Apologies -- that is not correct. This particular node ref is not working for the select box either (I got fooled by it defaulting to the first person in the list). Sorry about that. More in a sec -- I think I've spotted another difference.

Sigh. I'm all good now. Move along. Nothing to see here. :)

(thanks, and sorry for the trouble)

Sorry for the incredibly delayed response. I'm afraid I don't recall what ended up being my own bug in getting the node ref fields to work, but in case it helps, here's a somewhat stripped down example where I imported Counties that were subsequently referenced from Districts:

abstract class MyBaseMigration extends Migration {
  public function __construct() {
    // Always call the parent constructor first for basic setup
    parent::__construct();

    // With migrate_ui enabled, migration pages will indicate people involved in
    // the particular migration, with their role and contact info. We default the
    // list in the shared class; it can be overridden for specific migrations.
    $this->team = array(
      new MigrateTeamMember('Fred G. Sanford', 'example@example.com', t('Implementer'))
    );

  }
}

class CountyMigration extends MyBaseMigration {
  public function __construct() {
    parent::__construct();
    $this->description = t('Migrate Counties');

    $this->map = new MigrateSQLMap($this->machineName,
      array(
        'name' => array(
          'type' => 'varchar',
          'length' => 255,
          'not null' => TRUE,
          'description' => 'County Name',
          'alias' => 'c',
        )
      ),
      MigrateDestinationNode::getKeySchema()
    );
    
    $query = db_select( 'feeds_data_counties', 'c' )
             -> fields( 'c', array('name') );

    $this->source = new MigrateSourceSQL( $query, array() );

    // Set up our destination - nodes of type county
    $this->destination = new MigrateDestinationNode('county');

    // Mapped fields
    $this->addFieldMapping( 'title', 'name' );
    $this->addFieldMapping( 'uid' )
         ->defaultValue(1);
  }
}

class DistrictMigration extends MyBaseMigration {
  public function __construct() {
    parent::__construct();
    $this->description = t('Migrate Districts');
    
    $this->dependencies = array('County','LegislativeSession');

    $this->map = new MigrateSQLMap($this->machineName,
      array(
        'district_sortable' => array(
          'type' => 'varchar',
          'length' => 255,
          'not null' => TRUE,
          'description' => 'District Sortable',
          'alias' => 'd',
        )
      ),
      MigrateDestinationNode::getKeySchema()
    );
    
    $query = db_select( 'feeds_data_districts', 'd' );
    $query->addField( 'd', 'district_sortable' );
    $query->addField( 'd', 'districtformal' );
    $query->addField( 'd', 'counties' );
    // add id_num for debug purposes only
    $query->addField( 'd', 'id_num' );

    $this->source = new MigrateSourceSQL($query, array() );

    // Set up our destination - nodes of type district
    $this->destination = new MigrateDestinationNode('district');

    // Mapped fields
    $this->addFieldMapping( 'title', 'districtformal' );
    $this->addFieldMapping( 'field_sortable_name', 'district_sortable' );
    $this->addFieldMapping( 'field_counties_in_district', 'counties_in_district' );

    // node ref
    $this->addFieldMapping( 'field_counties', 'counties' )
         ->sourceMigration('County')
         ->separator('|'); 
    
    // author  
    $this->addFieldMapping( 'uid' )
         ->defaultValue(1);
  }
    
}