Keyword

how to convert k2 items to default joomla articles

  • Marco Elric
  • Marco Elric's Avatar Topic Author
  • Offline
  • New Member
More
12 years 8 months ago #75110 by Marco Elric
how to convert k2 items to default joomla articles?? please help.
:(

Please Log in or Create an account to join the conversation.

  • Marco Elric
  • Marco Elric's Avatar Topic Author
  • Offline
  • New Member
More
12 years 8 months ago #75111 by Marco Elric
Replied by Marco Elric on topic how to convert k2 items to default joomla articles
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

Please Log in or Create an account to join the conversation.

More
10 years 11 months ago #75112 by recipe cook
Replied by recipe cook on topic how to convert k2 items to default joomla articles
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 

Please Log in or Create an account to join the conversation.

  • Samuel Carbo III
  • Samuel Carbo III's Avatar
  • Offline
  • Junior Member
More
10 years 10 months ago #75113 by Samuel Carbo III
Replied by Samuel Carbo III on topic how to convert k2 items to default joomla articles
Has anyone tried the above and successfully completed it?

Please Log in or Create an account to join the conversation.

  • Samuel Carbo III
  • Samuel Carbo III's Avatar
  • Offline
  • Junior Member
More
10 years 10 months ago #75114 by Samuel Carbo III
Replied by Samuel Carbo III on topic how to convert k2 items to default joomla articles
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.

 

 

Please Log in or Create an account to join the conversation.

  • Samuel Carbo III
  • Samuel Carbo III's Avatar
  • Offline
  • Junior Member
More
10 years 10 months ago #75115 by Samuel Carbo III
Replied by Samuel Carbo III on topic how to convert k2 items to default joomla articles
Nevermind I figured it out!  Very exciting!

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #75116 by Macrohard
How in the hell to get the fulltext?  I keep getting errors!

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

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #75117 by Macrohard
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

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #75118 by Macrohard
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

Please Log in or Create an account to join the conversation.

More
8 years 11 months ago #75119 by Andrew Gaskell
Replied by Andrew Gaskell on topic Re: how to convert k2 items to default joomla articles
Hi

Just a quick one, I found the best query for categories was...
insert into vh4z6_categories (title, alias, description, parent_id, published, access, extension, language) select name, alias, description, parent, published, access, 'com_content', '*' from vh4z6_k2_categories 

Where "vh4z6" is your table prefix

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum