WordPress.org

Ready to get started?Download WordPress

Forums

Business Directory Plugin
HOWTO: Convert from Joomla's SOBI2 (3 posts)

  1. Benjamin Uzelac
    Member
    Posted 1 year ago #

    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!

    http://wordpress.org/extend/plugins/business-directory-plugin/

  2. businessdirectoryplugin
    Member
    Plugin Author

    Posted 1 year ago #

    Thanks for the insight, uzegonemad. Appreciate the post!

  3. acrontum
    Member
    Posted 9 months ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.