Posted by sathu on December 6, 2012 at 8:18am
Hello
One of our client wants their site to be developed in Drupal. They have given us the SQL file of the site which is at present done in Joomla.
Can we use the same database while developing the site in Drupal? This is for a school site with different options like student / parent login, Alumni, testimonials, calendar, events, photogallery etc which is already in the database. po
I have the SQL file with me and using this is it possible to redo a newsite?
thank you
Sathish
Comments
Depends on your comfort level...
Do a 'joomla to drupal 7' module search- looks like there are some module solutions out there. http://drupal.org/project/joomla is one. Never used it so cannot speak to its efficacy. There is also Migrate- http://drupal.org/project/migrate
But if they don't quite do what you need another solution is to try the Feeds module. http://drupal.org/project/feeds
Export the data you need into CSV files, one for each entity type (users, each content type, taxonomies, etc).
Create your content types with Drupal fields matching your CSV data (e.g. date field for a date data, names, etc do not need to match).
Create a new Feed Importer (lots of tuts on how to do this). Use CSV importer and node parser. Map your Drupal fields to your CSV fields.
Go to the import page and upload your csv. If things don't import quite as needed, delete imported content, tweak and retry.
I'm unique, just like everybody else.
If I helped, please pay it forward, backward or sidelong.