Textpattern CMS

#1 2009-09-07 18:43:43

milkshake

Member

From: Linz, Austria

Registered: 2007-06-24

Posts: 80

Website

Convert categories to keywords

Is there a plugin to convert categories to keywords?

The Wordpress importer brings in tags as categories, but I would like to use tru_tags for tagging, which uses keywords.

#2 2009-09-07 19:12:46

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: Convert categories to keywords

Not tested, but try this in PHPmyAdmin (backup first!):

UPDATE textpattern SET keywords = TRIM(',' FROM CONCAT(',', Category1, Category2));
UPDATE textpattern SET Category1 = '', Category 2 = '';

#3 2009-09-07 19:44:31

milkshake

Member

From: Linz, Austria

Registered: 2007-06-24

Posts: 80

Website

Re: Convert categories to keywords

Thanks ruud. Here is the sql that worked for me (concat with string function, no space in ‘Category2’):

UPDATE textpattern SET keywords = TRIM(',' FROM CONCAT_WS(',', Category1, Category2));
UPDATE textpattern SET Category1 = '', Category2 = '';