How do I transfer items from K2 to Joomla articles or wordpress ? What is the most wise choice?
I feel fed up with the Joomla K2 extension. This is the most crappy extension I've ever used and I am tired of correcting mistakes and bugs all the time. Even in the K2 forums, most of the threads suddenly and strangely disappeared, leading google results to 404 pages.
I did the most foolish thing on joomla: I installed their extension in joomla 1.6 because I wanted to set featured images in every article and joomla didn't have something like that (and then upgraded to 2.5) . So I created a news portal that publishes about 6 articles (or K2 items) every day for a year. So far there are 10 categories, 1000 articles and 200 tags (and 4 users only). There is nothing complicated on the website and all components are used "as they are". I haven't even used K2 extra fields etc.
I desperately want to transfer all items, categories, tags and images from K2 to Joomla articles. Then I will upgrade to the new Joomla 3.0. If I had a choice, I would transfer all data to wordpress. I have no money to hire an experienced developer and I have advanced programming knowledge but I am not an expert. I can try to copy data from one column to another but I would really appreciate the opinion of a developer with a "strong" knowledge.
Answer
On Joomla's forums it says that:
K2 articles are stored in the table jos_k2_items. Use a sql query to copy them to jos_content.
INSERT INTO ###_content (title, alias, catid, published, introtext, fulltext)
SELECT title, alias, catid, published, introtext, fulltext
FROM ###_k2_items ;
This was posted about Joomla 1.5 Check the new table structure and make the necessary changes.