Import Form Data from CKForms for Joomla! 1.5 to Visforms for Joomla! 2.5
You may use the following instruction to import your ckforms data into visforms for Joomla! 2.5. You can import data only into Visforms versions lower than 2.0.0. After you have completed the data import you can easily update to Visforms 2.0.0 by using the installation package which you can download in downloads menu.
Even if you want to import data from CKForms to Visforms for Joomla! 3 you always have to import to Joomla! 2.5 first following the steps described bellow. Afterwards you can Migrate Visforms from Joomla! 2.5 to Joomla! 3. Please read instructions first and don't forget to backup your website before you start!
- Download Visforms 1.0.4 and install the component first.
- Only use data from ckforms if you have not created any forms in Visforms yet.
- Copy #__ckforms via phpMyAdmin tool (tab operations) into a table #__visforms (replace #_ with correct table prefix of your Joomla! 2.5 installation).
- Delete columns "redirectdata" and "customjs" in copied table
- Export copied table as SQL into a file (do not use drop table if exists!)
- Import sql-file into Joomla! 2.5 database
- Copy #__ckfields via phpMyAdmin tool (tab operations) into a table #__visfields (replace #_ with correct Joomla! 2.5 table prefix)
- Delete columns "test_validity" and "customtextCSSclass" in copied table
- Export copied table as SQL into a file (do not use drop table if exists!)
- Import sql-file into Joomla! 2.5 database
- Export all #__ckforms* (* is a number) as SQL into a file (do not use drop table if exists!)
- Open file with a text editor
- Search for #__ckforms and replace it with #__visforms (use correct table prefixes instead of #_)
- Save your changes
- Import changed sql-file into Joomla! 2.5 database
- Go to your Joomla! backend to compontent Visforms, open each form and push the save button (without doing any changes); There are some new database fields that will be set on saving. Or upgrade to Visforms 2.0.0. You must not uninstall Visforms first!
If you think your are not able or willing to make the import we would luckily help you. Feel free to request an offer.