Support » Plugin: Business Directory Plugin » HOWTO: Convert from Joomla's SOBI2

  • This is a basic “how-to” for converting from Joomla’s SOBI2 business plugin… requires novice to intermediate knowledge of SQL.

    1. Install Business Directory Plugin
    2. Set up all the form fields you need to port from Joomla, e.g. Address and lat/long
    3. Record the form field IDs from the wp_wpbdp_form_fields table
    4. Export a CSV of SOBI2… Either purchase the SOBI2 exporter or write a SQL query
    5. Back up your database
    6. Install and activate the “Ultimate CSV Importer” Plugin
    7. Go to that plugin’s menu and upload the CSV
    8. “Map” the CSV fields to the WPBD fields (refer to this image for inspiration)
    9. Click Import!

    Hope someone transitioning from Joomla finds this useful!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author businessdirectoryplugin


    Thanks for the insight, uzegonemad. Appreciate the post!

    Example sql query to get SOBI2 data from database:

    SELECT i.title, i.published, i.icon, i.image, i.metakey, i.metadesc, l.langValue, l.langKey, fd.data_txt FROM jos_sobi2_language AS l, jos_sobi2_fields_data AS fd, jos_sobi2_item AS i WHERE l.fieldid = fd.fieldid AND fd.itemid = i.itemid ORDER BY i.itemid

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘HOWTO: Convert from Joomla's SOBI2’ is closed to new replies.