Support Forum

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';