The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.



Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Import Users and Content
PostPosted: Mon Jul 09, 2012 8:35 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Jul 02, 2012 4:19 pm
Posts: 3
I am migrating from a Dot Net Nuke site that has close to a thousand articles and about 1800 users. Is there any documentation on the MySQL schema to help me make sure I do not forget to properly set up foreign keys, etc on my import function ???


Top
 Profile  
 
PostPosted: Mon Jul 09, 2012 9:36 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Thu Aug 18, 2005 8:55 pm
Posts: 18104
Location: Nijmegen, The Netherlands
workaround to import your data into Joomla:
  • Create a Joomla website with a couple of articles
  • In phpMyAdmin: Export the data of @__content table as OpenDocument Spreadsheet / CSV for MS Excel (check the option: Put columns names in the first row!)
  • Do the same for your DotNetNuke arcticles
  • Merge the data from the DotNetNuke spreadsheet with Joomla's data.
  • Any missing columns? Just copy some of Joomla's data from the first row to all the empty cells in the same column.
  • remove top row(s) so that the spreadsheet only contains your data & Export as CSV
  • In phpMyAdmin: Import the CSV data into your database.

Regarding your users:
Joomla 2.5 uses 2 tables: #__users and #__user_usergroup_map

_________________
Kind Regards,
Peter Martin, Global Moderator - Community Leadership Team
http://www.db8.nl - Joomla specialist, Nijmegen, Nederland
Joomla 2.5 multilanguage in 10 steps: http://www.db8.nl/multilanguage-in-10-steps


Top
 Profile  
 
PostPosted: Tue Jul 10, 2012 7:24 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Jul 02, 2012 4:19 pm
Posts: 3
OK. Thanks.

Just to confirm, then, on import, MySql will take care of assigning unique object IDs to each row. Right?

Thanks for the insight.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 



Who is online

Users browsing this forum: jezh, jriga, Per Yngve Berg, richardm55 and 82 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group