Can I import my existing comments into Vanilla?

marglar

I just installed Vanilla and am integrating it with my existing wordpress site.

When I enable comment integration, my existing comments disappear off of my site. I really need to keep them.

Any ideas?

peregrine

fill in the fields from one table to another and assign it to a user. Your database guy should know how.

UnderDog

Do you want to import your comments from WordPress into Vanilla?

uh oh...

Do you know how to save the structure of 2 database tables and compare them?

marglar

I have a guy who could do that. Can you give me an idea of what needs to be done?

Some details would be awesome.

peregrine

fill in the fields from one table to another and assign it to a user. Your database guy should know how.

marglar

Thanks!

bnix

peregrine
fill in the fields from one table to another and assign it to a user. Your database guy should know how.

But if I don't 'have a guy' who can do this, what's the next best step to migrating from WP Comments to Vanilla Comments?

peregrine

bnix said:

peregrine
fill in the fields from one table to another and assign it to a user. Your database guy should know how.

But if I don't 'have a guy' who can do this, what's the next best step to migrating from WP Comments to Vanilla Comments?

It was an off-the cuff statement - I
I just used phpmyadmin - and saw that wordpress has a comments table with the comment and userid - and vanilla has something similar. - so it seemed somebody with the desire to convert could export one, modify it a bit and import it. As far as the particulars, that would be something for you to investigate. As far as the next best step I don't know.

butcher

Is there some automated way to import them ? I have a big site and wanted to try out with Vanilla forum but I dont want to waste another week for trying this out (dont have to much DB knowledge...) I already wasted 2 weeks for shitty bbPress

aery

Developers, please help by making a addon.

UnderDog

All we have is the porter plugin: http://vanillaforums.org/addon/porter-core The Porter plugin can convert comments from bbPress to Vanilla. It cannot convert from WordPress to Vanilla. Figure out if you would like to convert from bbPress to Vanilla, otherwise do the manual steps like peregrine said.
We'll help as much as we can if you decide to do the manual steps.
Let us know if you want to do the conversion (porter plugin) on your local (windows?) computer or on the server (host).

peregrine

here's a start on what to do for discussions.

pull this info out of wordpress

`fa_posts` (

  `post_author`
  `post_date` datetime 
  `post_content` 
  `post_title` 

 test for publish maybe
  `post_status` 
 find the posts type = posts
  `post_type`



put the info into vanilla.
start your discussion id from the last discussion id +1 that you have
figure out what category you want.  e.g. create a wordpress category and put it into there.

insert user id - would correspond to a user id  = synch the correct user names.
post_content - matches body
post_title - matches name
the last four fields are pretty much necessary 


  INSERT INTO `vanilla`.`GDN_Discussion` (
`DiscussionID` ,
`CategoryID` ,
`InsertUserID` ,
`Name` ,
`Body`,
`Format`,
`DateInserted`,
`DateLastComment`
)
VALUES (
'27', '2', '5', 'the NEW test', 'this is the new body' ,'Html', '2012-06-27 11:07:27','2012-06-27 11:07:27'
);


do something similar for match of wordpress comments for comments.

you will need to read up on mysql to implement - but its not that mysterious.

use phpmyadmin to look at tables and structures - you can use it to export and import.