Thread Starter
Edo
(@edo)
I couldn’t get the GM import script to work so I did it the hard way: Greymatter to Movable Type to WordPress. There was some strangeness: even after massaging the data from the MT export, upon import into WP every other entry had no author despite all posts being by the same author, and for the authorless entries the comments were skipped. I ended up having to manually delete and re-import entries one at a time. On re-import (using the same datafile), the comments would show up.
If I’d known it was going to be so complex, I would have just built a data file from scratch, but I didn’t have any idea of what MT’s export looked like.
Also, does anyone know authoritatively when the import scripts were written? I seem to remember reading somewhere that the GM to WP script was originally written for GM to b2. If this is true, perhaps that info should go into the Codex with a YMMV disclaimer.
i’m having the exact same problem. i keep getting this error message:
“The importer is running…
importing users…
Oops, can’t find any database named DB_NAME here !”
the old import script seemed to work fine. but not on 1.5. is there a fix for this?
okay i tried importing my gm entries into b2 and that worked fine.
then i tried importing from b2 to wordpress 1.5 and it didnt work.
i got this during step 2:
“First we’re going to add excerpt, post, and password functionality…
WordPress database error: [Duplicate column name ‘post_excerpt’]
ALTER TABLE wp_posts ADD COLUMN post_excerpt text NOT NULL;
WordPress database error: [Duplicate column name ‘post_status’]
ALTER TABLE wp_posts ADD post_status ENUM(‘publish’,’draft’,’private’) NOT NULL, ADD comment_status ENUM(‘open’,’closed’) NOT NULL, ADD ping_status ENUM(‘open’,’closed’) NOT NULL, ADD post_password varchar(20) NOT NULL;
That went well! Now let’s clean up the b2 database structure a bit…
WordPress database error: [Can’t DROP ‘ID’. Check that column/key exists]
ALTER TABLE wp_posts DROP INDEX ID
One down, two to go…
So far so good.
WordPress database error: [Can’t DROP ‘post_karma’. Check that column/key exists]
ALTER TABLE wp_posts DROP post_karma
Almost there…
WordPress database error: [Can’t DROP ‘ID’. Check that column/key exists]
ALTER TABLE wp_users DROP INDEX ID
Welcome to the family. Have fun!”
seems like none of the import scripts are working for wordpress 1.5
nevermind. got it to work by installing 1.2, importing, then upgrading to 1.5.
Thread Starter
Edo
(@edo)
hmm. actually i think i *may* have messed up with the b2 to wp 1.5 import that time (human error). it might still work but i havent tried it out again properly to check.
but the GM to wp 1.5 import definitely has bugs.
Where can one find a copy of 1.2 to download so that I can switch the Greymatter entries over?
A search for “import greymatter” would have shown this Lesson.
i had installed 1.5 then realized that the greymatter import script doesn’t work on this version. from the above postings it seems i have to install 1.2 then try importing. so do i need to uninstall 1.5 first? how do i do that?
In this thread
http://wordpress.org/support/topic/31470#post-177664
one of the developers (Ryan) has a link to an updated import script. You may want to try it…
(actually further below there is even a more updated one)
I’ve got a workaround for everyone.
Go ahead and install WP version 2.01.
Install everything and then…
Install the import-greymatter.php
— sounds normal so far —
If you set up your paths correctly (keep in mind, they are local paths) if you put the import script into a folder you have to use ../ before the path)
Log into wordpress and make a user with the name you want to import.
Run import-greymatter.cgi
If you did everything correctly, you will see a message that says “x user already exists” instead of the other error messages you get from the script being v1.5 and wordpress being v2.01
Worked for me, hope this helps everyone! Now to convert my templates…. ugh
