I migrated about 30 websites from Joomla to DotNetNuke. The best way to do it ia to copy and paste content. But I have to publish 20,000 news articles which was impossible to copy and paste. Follow these steps below to publish huge data.
These are the following the steps I followed.
1. Import all your Joomla article data into MySql WorkBench
2. Then Export data by categoryID into seperate Excel spreadsheets
3. I copied all my images to DNN root Images folder so that the images URL matches.
4. Install DigArticle Module
5. Add Module on the page were you want to add articles and create a test article to view its moduleID in the database.
6. Change the categoryID to ModuleID in the spreadsheet and make sure you align the spreadsheet names asnd columns as its displayed in the digArticle table in SQL Server database.
7.Import all the data into SqlServer database and you will be amazed by the outcome as all you articles will be moved automatically on that page.
Thanks
Matthew
www.infobyte.com.au