Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Customized importer
Avatar
NorCal
Member
Free Members
sp_UserOfflineSmall Offline
Sep 17, 2019 - 12:08 am

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

Avatar
SP Community Support
SP Moderator
sp_UserOfflineSmall Offline
Sep 17, 2019 - 1:08 am

Hi:

Take a look at the Asgaros or bbPress importer - they pull data from multiple tables using the SELECT and WHERE items in the map arrays. 

There's a little bit of explanation in the CUSTOM VIEWS section at the bottom of this article that might help as well: https://simple-press.com/writi.....mplepress/

Avatar
NorCal
Member
Free Members
sp_UserOfflineSmall Offline
Sep 17, 2019 - 12:39 pm

Hi,

Import script can't find necessary function sp_create_member_data,  Any insights as to why can't script find this function?

Fatal error: Uncaught Error: Call to undefined function sp_create_member_data() in /public_html/wp-content/plugins/sp-import/engine/spimport.php:435 Stack trace: #0 /public_html/wp-content/plugins/sp-import/engine/spimport.php(114): spi_create_user(Object(stdClass), Object(stdClass), Array, Array, false, Array) #1 /public_html/wp-content/plugins/sp-import/engine/spimport.php(49): spi_import_users('2', Object(stdClass), Object(stdClass), Array) #2 {main} thrown in /public_html/wp-content/plugins/sp-import/engine/spimport.php on line 435

 
Avatar
NorCal
Member
Free Members
sp_UserOfflineSmall Offline
Sep 17, 2019 - 9:26 pm

can I please get some help with this?  I cannot use simplepress until I can migrate my forum.  I'm very frustrated.

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626