how to convert k2 items to default joomla articles?? please help.
:(

Just incase we upgrade into joomla1.6 .
we don't need k2 in joomla 1.6 we are all aware of that.

Solutions Expert said:two tabs in firefox.. old stuff in k2 and other tab where you are copying stuff too...lolzzzz they will never make this option (i already have said this a thousand times here... with zero response)---1 out of 20 reasons i moved on to resources.

just did this... myself

steps to migrate from k2 to joomla

 1. back up everything2. move users from k2 to joomla3. transfer all the table data from k2 to joomla and confirm it.Run the following queries in phpmyadmin

For transferring contents:-

insert into jos_content (title, alias, introtext, state, sectionid, catid, created_by, metakey, metadesc, ordering) select title, alias, introtext, published, '2', catid, '69', metakey, metadesc, ordering into jos_k2_items

here 2 represents section id of joomla and 69 represents admin id.

 

For transferring categories:-

insert into jos_categories (title, alias, published, ordering, section) select name, alias, published, ordering, '2' from jos_k2_categories

Here 2 represents section id

After confirming the data remove k2 componenthttp://recipe2cook.com 

Has anyone tried the above and successfully completed it?

Alright got it to work, a couple of things though I really hope you still get messages here recipe.

 

First and probably most importantly right this minute is, your code... should be changed from....

 

insert into jos_content (title, alias, introtext, state, sectionid, catid, created_by, metakey, metadesc, ordering) select title, alias, introtext, published, '2', catid, '69', metakey, metadesc, ordering into jos_k2_items

 

to...

 

insert into jos_content (title, alias, introtext, state, sectionid, catid, created_by, metakey, metadesc, ordering) select title, alias, introtext, published, '2', catid, '69', metakey, metadesc, ordering from jos_k2_items

 

Once the code is changed following your directions are simple.

 

Next, I would like to make some minor adjustments however I keep getting errors, I would like to have 'Hits' as well as 'created' added to this query, I am really hoping this is possible, as I think after two years you may have just made me what is possibly the happiest guy on the internets right now.

 

 

Nevermind I figured it out!  Very exciting!

How in the hell to get the fulltext?  I keep getting errors!

Samm Carbo said:
Nevermind I figured it out!  Very exciting!

Had to add it in like:

 

insert into jos_content (title, alias, introtext, `fulltext`, state, sectionid, catid, created_by, metakey, metadesc, ordering) select title, alias, introtext, `fulltext`, published, '2', catid, '69', metakey, metadesc, ordering from jos_k2_items

Well, so I thought.  It still didn't bring the fulltext over.

Jason Knight said:
Had to add it in like:

 

insert into jos_content (title, alias, introtext, `fulltext`, state, sectionid, catid, created_by, metakey, metadesc, ordering) select title, alias, introtext, `fulltext`, published, '2', catid, '69', metakey, metadesc, ordering from jos_k2_items

Hi

Just a quick one, I found the best query for categories was...

Where "vh4z6" is your table prefix