Hi ppatel
QUOTE:
My question is do you see a way to use the Export Content to import the data as Content Items? Or should I go through the mySQL admin?
A lot would depend on how familiar you are with the way Joomla does things. If you are just starting to feel your way around I would do it this way.
In Joomla create a section and category get there ID's and add them as shown below via phpMyadmin.
Once you have the content inserted you will be able to create other sections/categories and move the items to where you want them.
QUOTE:
The content is grouped and I can use one of the fields to assign it to a category.
You would need a section id as well unless you were going to add everything as static content items in which case a section and category id are not needed.
Listed below are all the fields of the content table with the fields highlighted that will be required if you want to have a section/category(s)/content item(s) structure.
Table: jos_content
|id |
title | title_alias |
introtext | fulltext |
state |
sectionid | mask |
catid | created |
created_by |created_by_alias | modified | modified_by | checked_out | checked_out_time | publish_up |publish_down | images | urls | attribs | version | parentid | ordering | metakey | metadesc |
access | hits |
Tips:
id is an autoIncrement field.
state should be set to "1" if you want all items published.
access is the permission level and should be set to "0" to make everything public viewable.
created_by "62" is normally the admin id.
There was a phpMyadmin Joomla extension around a while ago that would make the job a bit easier.
http://extensions.joomla.org/
If you need anymore help feel free to ask.
Support Forums 
