Admun's NUDN

admun

  • San Francisco, CA

Navigation

Navigation

Categories

Wordpress conversion tool ported to Nucleus

Note: v1.2 is out and can be found @ http://edmondhui.homeip.net/nudn/item/1004

I spent some times ported b:cms's wp conversion tool (Thanks to Radek) from b:cms to Nucleus. Enjoy, wp users!

steps:
1 - install Nucleus
2 - put the script in nucleus/converts
3 - run the script, follow the step
4 - done!

click here to download

The latest version can be found here

Please let me know if this script works or you run into any problem (either here or from the forum)

21:32:52 on 03/14/05 by Admun - Category: My Work - tags: - print

Comments

Greg wrote:

worked great. The only problem was when I had matching category names in both wordpress and nucleus before I ran the conversion, then it just stopped.

once i figured that out, i just deleted all the categories in nucleus and the conversion went over perfectly.

Thanks for the tool.

04/26/05 09:22:26

Admun wrote:

Good to hear that.

Yes. The conversion should be done first thing after install Nucleus. If there is a collision with the default category, it should be renamed.

Thanks for the report!

04/26/05 09:47:25

gluon wrote:

Hello folks,
i did clean install of nucleus 3.2. Made so skining then. Now i want to convert wordpress 1.2 database to nucleus. Ok, i run the converter as written above, fill formfields with info, and the output is

Getting encoding...

Encoding: utf-8
Transfering categories...

rows to transfer: 4

1, insert into nucleus_nucleus_category (catid,cblog,cname,cdesc) values (2,1,'General','@wordpress')
that's all, but nothing has moved between wordpress and nucleuse database sad

05/11/05 16:12:19

gluon wrote:

hey sad

05/11/05 16:17:09

Admun wrote:

Did you have any post on the Nucleus setup?

05/11/05 16:58:35

gluon wrote:

There were only the original post Welcome to Nucleus ..... i tried to remove it then, but got the same result again. What is ment by New Nucleus:CMS Database Info / Database Name ... it's the name of the database in which i've installed Nucleus previously or i am supposed to creat another new database?

(btw. sorry for the "hey" post i just got a bit confused by lots'a things and didn't realised new posts moderation here smile )

05/11/05 18:21:42

Admun wrote:

hum... it's weird. I got one case that's it's working.... what version of wp you're using?

The Nucleus:CMS database info is the MySQl database name that Nucleus is using.

05/11/05 23:30:43

gluon wrote:

It is wordpress 1.2 as i wrote in the first post here smile . There in the message that converter makes is written: insert into nucleus_nucleus_category (catid,cblog,cname,cdesc). It means that it tries to put some values to the table called nucleus_nucleus_category? But my nucleuse database name is news2 and table prefix is nucleus_. So why is there nucleus twice? It works only when nucleus database name is called nucleus? Or it has problem with General category name colision?

05/12/05 02:54:41

gluon wrote:

Ok, finally it worked. It was some problem with that double prefix. I just made things wierd while installing nucleus. But now it works for me. Thank for the script and feedback.

Best Regards Gluon

05/12/05 04:01:16

Admun wrote:

actually, table prefix is _not_ a recommand feature to use... sad It for those really really need it... ie only have one db but need multiple installs.

Good to hear it work for you now.

05/12/05 09:47:54

dp wrote:

Script works great. However looks like there is 1 issue with the categories; in WP you can have multiple categories per item and after the conversion all my items in Nucleus had just 1 categorie.

I assume this is never gonna work with multiple categories per item ?

please confirm

thanks

05/23/05 06:45:51

Admun wrote:

True. Nuclues only support one category per item. There is a Multicategories plugin, but it's not support by the convert script right now.

Rgds,

05/23/05 12:53:28

Lee wrote:

Worked great -- Muchos Thank-You's

05/29/05 13:32:13

Admun wrote:

Lee, thanks for the report. cool

05/29/05 16:15:22

eric wrote:

mine get's stuck and does not do anything.

Getting encoding...
Encoding: utf-8

Transfering categories...
rows to transfer: 21

1, insert into nucleus_category (catid,cblog,cname,cdesc) values (2,1,'General','@wordpress')

06/16/05 21:14:07

eric wrote:

maybe it doesn't work with 1.5.1.2

06/16/05 21:27:20

Admun wrote:

eric,

Thanks for the report, I will look at it once I got some time.

06/16/05 22:56:28

eric wrote:

thanks!

06/21/05 14:07:23

Adrian_es wrote:

works on WP 1.5.1.2¿?¿?

thx

06/22/05 13:45:18

Admun wrote:

I have not have time to look at it yet... currently on business trip. 8(

06/22/05 14:20:32

Adrian_es wrote:

ohh... that's ok...

no worry XD

06/23/05 02:06:26

Admun wrote:

yeah... just come back from business trip but than on vacation until Jul..... I will try to upgrade my wp playground once I'm back and going to checl out what going on....

06/23/05 11:39:39

Carla wrote:

Just to let you know, I had the same issue as Eric--it just stopped, pretty much in the same place.

Thanks for all your hard work! I really appreciate your putting this script out here for us to use.

08/07/05 19:24:49

Admun wrote:

hum..... I just upgraded to 1.5.1.3 on my test setup. I will try it out soon and see if I see the problem.

08/07/05 22:18:19

Admun wrote:

I just tried it with 1.5.1.3 and it works. I think it is something to do with some of your data...... please email me (ymehui at yahoo the dot com) and maybe I can look into that in more details.

08/07/05 22:40:07

Radek Hulán wrote:

" I spent some times ported b:cms's wp conversion tool " - I see you changed "BLOG:CMS" to "NucleusCMS" in source code and that is about that.. wink

09/02/05 18:41:24

Admun wrote:

That's pretty much. 15 minutes work plus some testing to make sure it works in Nucleus. We shouldn't leave the reference to b:cms while used in Nucleus, right?

09/03/05 10:41:27

Welsh Dog wrote:

Hey there,

Just thought I'd tell you how much I appreciate your work! I used the Wordpress to Nucleus converter and I had no problems at all. It's all arrived safe and sound.

Some slight editing to do to remove the 'setup posts' in Nucleus but other than that its almost a clone of the original WP set up - great stuff!

The url is currently
http://www.opinionaustralia... - until I change the index file and then just lose the directory biggrin

10/06/05 04:01:44

Admun wrote:

awesome! lol

10/06/05 09:57:53

alberto wrote:

WONDERFULLLLLLLLLLLLLLL

10/12/05 03:14:54

Admun wrote:

good to know it works. Thanks to the work of radak.....

10/12/05 09:52:29

Welsh Dog wrote:

Seems I made a stupid boo-boo and deleted an entire category that I'd imported thereby losing an entire years posts. I wrongly assumed the posts would just be moved to the Nucleus 'General' category. redface

Is there any way of importing just one category instead of the entire blog... i.e. just the 'General' category and leaving all the others?

Once I've done that I can delete the Wordpress files and get down to some serious whinging. twisted

10/20/05 07:00:01

Admun wrote:

hum.... unfortunatley the tool is written to blindly convert posts from wp to Nucleus.....

I guess one thing you can do is to delete the rest of the posts imported from wp and rerun the tool to convert everything again?

10/20/05 09:35:58

Welsh Dog wrote:

Trouble is if I do that I'd have to delete all the new posts I've made since converting to Nucleus. I suppose I'll just have to go through the 'old' posts and copy them one by one.

Deleting them was pretty stupid - after all... I *could* have just renamed the category! biggrin

Ah well... thanks anyway - the tool was still very impressive!!

10/20/05 17:31:22

Fran wrote:

--------------------------------------------------------------------
Getting encoding...

Encoding: UTF-8
Transfering categories...

rows to transfer: 15

1, 2, 3, 4, 5, insert into nucleus_category (catid,cblog,cname,cdesc) values (6,1,'X'D','@wordpress')
--------------------------------------------------------------------

WP 1.5.1.3
Nucleus 3.22

Although it created _some_ of the categories, no post has been ported. Any help would be apreciated.

Thanks in advance and congratulations for the great work!

Fran

11/08/05 16:59:50

Admun wrote:

Can you check in Apache error log any error?

11/08/05 18:45:25

Fran wrote:

-----------------------------------------------------------------
[Wed Nov 9 15:14:42 2005] [notice] jrApache[13677:10197] initialized proxy for 127.0.0.1:51010
[Wed Nov 9 15:14:42 2005] [notice] jrApache[13677:10197] Couldn't initialize from remote server, JRun server(s) probably down.
[Wed Nov 9 15:14:42 2005] [notice] jrApache[13677:10197] initialized proxy for 127.0.0.1:51010
[Wed Nov 9 15:14:42 2005] [notice] jrApache[13677:10197] Couldn't initialize from remote server, JRun server(s) probably down.
[Wed Nov 9 15:14:42 2005] [error] [client 83.55.59.177] File does not exist: /home/sites/franxus/www/public_html/favicon.ico
[Wed Nov 9 15:14:45 2005] [notice] jrApache[13677:10197] initialized proxy for 127.0.0.1:51010
[Wed Nov 9 15:14:45 2005] [notice] jrApache[13677:10197] Couldn't initialize from remote server, JRun server(s) probably down.
[Wed Nov 9 15:14:45 2005] [notice] jrApache[13677:10197] initialized proxy for 127.0.0.1:51010
[Wed Nov 9 15:14:45 2005] [notice] jrApache[13677:10197] Couldn't initialize from remote server, JRun server(s) probably down.
[Wed Nov 9 15:14:45 2005] [notice] jrApache[13677:10197] initialized proxy for 127.0.0.1:51010
[Wed Nov 9 15:14:45 2005] [notice] jrApache[13677:10197] Couldn't initialize from remote server, JRun server(s) probably down.
[Wed Nov 9 15:14:45 2005] [notice] jrApache[13677:10197] initialized proxy for 127.0.0.1:51010
[Wed Nov 9 15:14:45 2005] [notice] jrApache[13677:10197] Couldn't initialize from remote server, JRun server(s) probably down.
[Wed Nov 9 15:14:45 2005] [notice] jrApache[13677:10197] initialized proxy for 127.0.0.1:51010
[Wed Nov 9 15:14:45 2005] [notice] jrApache[13677:10197] Couldn't initialize from remote server, JRun server(s) probably down.
[Wed Nov 9 15:14:45 2005] [error] [client 83.55.59.177] File does not exist: /home/sites/franxus/www/public_html/favicon.ico
-----------------------------------------------------------------

That's the only thing that logs apache after trying to do the conversion.

Thanks in advance,

Fran

11/09/05 16:17:02

Admun wrote:

I don't think these logs are related to the convertor..... One thing to try is to flush the category, item, and other related tables and retry.

11/09/05 16:26:59

robwilks wrote:

Great easy to use script, just what I was looking for. However, it didn't transfer all the posts and comments? Why?

I get this:
_________

Getting encoding...

Encoding: UTF-8
Transfering categories...

rows to transfer: 62

1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62,
Transfering posts and comments...

rows to transfer: 0

Done! Enjoy your stay in Nucleus
________

Any ideas?

11/27/05 07:06:41

robwilks wrote:

Actually, I think I know what the problem is - all the tables created by WP were merged with WP beta2.0, and this could be why the posts and comments aren't being converted correctly.

Any plans to update the convert tool to allow it to be used with 2.0 tables?

11/27/05 07:20:35

Admun wrote:

not yet... I have not try wp 2.0..... I guess I will wait for the officical release first.

11/28/05 09:38:59

dvorcsak wrote:

i have wordpless blog and nucleus blog.
i am writing hungarian with áéöőúű letter in the wordpress.
when i converted from wp to nuc, everything was OK except the hungarian characters

example: költözés - Költözés

help.

thx

12/09/05 07:49:52

Admun wrote:

The script is assuming UTF-8 encoding. I think your wp is probably using different encoding . Try to search the code for all references to "utf-8" and change it to your encoding for Hungarian and see if it works.

12/09/05 09:29:02

Jack wrote:

helloo Admun : )
Have you developed the WP conversion tool for Wordpress 2.0.x ?
I find out that your this WP Conversion tool can\'t import the data of official WP 2.0 to Nucleus sad

03/19/06 06:58:35

Admun wrote:

sorry.... I have not have a chance to look into it.

03/19/06 07:21:18

shari wrote:

hi, I'm having difficulties with this script. I'm getting the following after running it:

Getting encoding...
Encoding: UTF-8

Transfering categories...

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/content/s/l/d/sldhost/html/nucleus/blogger_convert/wordpress.php on line 160

rows to transfer: 1

1, insert into nucleus_category (catid,cblog,cname,cdesc) values (1,1,'Daily Etceteral','@wordpress')

--------------------

my nucleus is installed on http://nucleus.sharilynnstu... and i am trying to bring in wp blog on http://blog.sharilynnstudio... Afterwards I plan on deleting the content on wp and renaming the nucleus subdomain to blog.

whatever assistance will be greatly appreciated.
--------------------

02/11/07 17:54:01

shari wrote:

Getting encoding...
Encoding: UTF-8

Transfering categories...

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/content/s/l/d/sldhost/html/nucleus/blogger_convert/wordpress.php on line 160

rows to transfer: 1

1, insert into nucleus_category (catid,cblog,cname,cdesc) values (1,1,'Daily Etceteral','@wordpress')

whatever assistance will be greatly appreciated

02/11/07 17:55:11

Admun wrote:

what version of wp you are using? it looks like it failed to input a category "@Wordpress" maybe try to rename it and retry?

BTW, have use start using the Nucleus blog yet? This script kind of flacky and only work on a newly install Nucleus setup..... should import from wp first before using it

hope this help.

02/11/07 21:54:36

shari wrote:

hi, disregard my previous posts.... it took all day but i finally found it.... line 159 of your blogcms.com code.....
ORIGINAL:
$q = mysql_query("SELECT count(*) as result FROM nucleus_category" wink ;

CORRECTED:
$q = mysql_query("SELECT count(*) as result FROM nuc_nucleus_category" wink ;

godaddy's script automatically puts in a prefix...

now if i can figure out why it didn't WRITE the files to nucleus' db.........

02/11/07 22:12:08

shari wrote:

yes its a brand new install... it failed on the category... see previous post... now i'm debugging the actual writing of these transferred posts to the nucleus db...

02/11/07 22:14:13

shari wrote:

well... it posts to the db now by changing the following:

line 185 change to:
$query="select ID,post_date,post_content,post_title from ".$prefixwp."posts order by ID";
now to get it to display.....

02/11/07 23:26:38

Admun wrote:

thanks for following up.

02/11/07 23:38:03

shari wrote:

i figured out how to make the posts display... when they were imported to the default category, the database entry was labeled with the incorrect category ID. it kept the wordpress category. So I manually changed it on myPHPadmin and voila! smile

02/13/07 01:52:03

Admun wrote:

ok... thanks for the info.... looks like there is something change that the catID is not matching in your case... wondering this is a bug in the convertor....

Thanks for getting back to me.

enjoy Nucleus

02/13/07 07:41:05

Add Comments

This item is closed, it's not possible to add new comments to it or to vote on it