How to export K2 items to Joomla Articles?

Migrate K2 items to Joomla! articles in two easy steps using phpMyAdmin

K2 is great but if you are in the mission of removing a dependency on any third-party extensions and migrate K2 items to Joomla articles then this article will help you.

1. Migrate K2 categories to Joomla

• Access phpMyAdmin and go to SQL Query box of the respective database
• Enter the following queries in the query box and click on Go

insert into geek_categories (title, alias, parent_id, published, access, extension) select name, alias, parent, published, access, ‘com_content’, from geek_k2_categories 

Note: you got to change from geek to your database tables prefix. You can find tables prefix name from Server tab under Joomla Administrator>>System>>Global Configuration

2. Migrate K2 items to Joomla

• Enter below queries into the query box and click on Go

INSERT INTO `database_geek`.`geek_content` (`id`, `title`, `alias`, `catid`, `introtext`, `fulltext`, `created`, `created_by`, `publish_up`, `publish_down`, `access`) SELECT `id`, `title`, `alias`, `catid`, `introtext`, `fulltext`, `created`, `created_by`, `publish_up`, `publish_down`, `access` FROM `database_geek`.`geek_k2_items`

Note: you got to change two things here.

database_geek – change with your database name

geek – change the table prefix as you found in step number 1

Now, you should have K2 items into Joomla! content. This has helped me when I migrated K2 to Joomla and hope it will you too.