when I am customizing the importer and mapping the origin database to the sp database what do I do when the origin data for one SP table comes from two different tables from the origin db? So for example the sfposts table “post_id” and “topic_id” come from one table but “poster_ip” comes from another?
would I do two separate select/where like this ?
$map[‘tables’]->sfposts = true;
$map[‘sfposts’]->table = ‘origintable1’;
$map[‘sfposts’]->select = ”;
$map[‘sfposts’]->where = ”;
$map[‘sfposts’]->post_id = ‘msgid’;
$map[‘sfposts’]->topic_id = ‘threadid’;
$map[‘tables’]->sfposts = true;
$map[‘sfposts’]->table = ‘origintable2’;
$map[‘sfposts’]->select = ”;
$map[‘sfposts’]->where = ”;
$map[‘sfposts’]->poster_ip = ‘ipaddress’;