Joomla+sobi2 Mysql/excelmport

Brief: I have a Joomla site running the SOBI2 Directory Component and I have thousands of Categories I need imported into the directory.
Site: http://funmoonbouncerentals.com/index.php

Description: SOBI2 Allows Directory Categories and Sub-Categories. I have added all the States for my site as Categories and I need the thousands of cities for each State added as Sub-Categories to there respective States.

Attached are all the Cities in a Excel file…I am not sure if you can run a MYSQL Query to import all the cities for each State or if you can write a script to import straight from the Excel file. The easiest method is preferred.

If you can do it via MySQL Query then run it for 1 state, let me know how and I will do the rest.

ONLY BID IF YOU ARE FAMILIAR WITH SOBI2 DIRECTORY STRUCTURE AND YOU CAN START/FINISH THIS NOW!!!!!

Leave a Reply

Your email address will not be published. Required fields are marked *