By genghis1227 on

I have 3 bloggars on b2evolution and I would like to switch to Drupal. Does anybody have any scripts to help convert from b2evolution to Drupal? Thanks!

Comments

paulap’s picture

paulap commented

I use b2evolution since one year. As a weblog tool it is ok. but i need more content management and therefore i decide to switch to drupal (very nice piece of software).

i have several hundred entries to import.

please help

PS: I know other b2evolution users too who think about to change.

ioo’s picture

ioo commented

Thanks guys...

B2E is falling apart, I would love to move my blog over to Drupal

marcp’s picture

marcp commented

Perhaps if someone would export the database, someone here on the Drupal forums might be able to help. I would definitely take a 5 minute look at it to see how hard it would be, but I don't have the time to set up a b2e site, populate it with stuff, and then deconstruct it.

So, if someone would post a small, but comprehensive, export, I'll import it into MySQL and see what it might take.

-------
http://www.funnymonkey.com
Tools for Teachers

jeremyhu’s picture

jeremyhu commented

http://cloud.cs.berkeley.edu/~jeremy/b2_evolution_db.bz2

The two main tables of interest are:
evo_comments
evo_posts

and both are pretty well organized.

larz01’s picture

larz01 commented

I also have a b2evo site I need to convert to Drupal, please help if there is a good way to move log entries from one to another.

Thanks

pabsta’s picture

pabsta commented

Hello everyone.
I did migrated from b2evolution to drupal. My b2evo tables were quite loaded (over a thousand posts) and it was hard enough. I did not do an entire sql switch, however. I only changed sql tables from b2evo about posts and comments.

It was not easy and I have lost some stuff during the process. For instance, b2evolution tables does have a column for url titles and drupal does not. So I first tried to concatenate the urls with the title with a fancy SQL UPDATE but I was not able to do it. I still have my b2evo table availlable so I might start it over once I understand drupal a little bit more.

Since I am usually writing (and speaking) in french, there is also an accent issue I am trying to fix. I did not pay attention to the taxonomy/classification issue at the beginning so all my imported posts are under "my own blog" category.

Also, if my comments are all there, there is no title attached to them since b2evo does not take allow this (but Drupal needs it to show them).

But my biggest problem is that I must have forgot to update one drupal table so he still believes that there is no post in the database, even if my posts are availlable by the web. So, everytime I add a new post, I can see an error message stating that the nid XXX is already used. Then you click refresh and you see the same message XXX+1 over and onver until you find a nid availlable.

I am trying right now to find more information about the SQL design and what is the usefullness of every table so I can fix this. Once I will have found that, I will update this post.

Sorry for the bad english.

--
pabsta's groove
www.pabsta.qc.ca
L'éternité, c'est long. Surtout vers la fin.

marcp’s picture

marcp commented

pabsta,

take a look at the sequences table. you will want to make sure that you have id for node_nid set to the highest (or one higher) value of nid in the node table.

your english is just fine, by the way.

-------
http://www.funnymonkey.com
Tools for Teachers

pabsta’s picture

pabsta commented

Hi,
I did change the sequence database and it worked.

I am now seeking to see how is coded (UTF, UFC, etc.) the text in the tables. My guess is that is the what is causing the main difference between the b2evo appearance and the drupal appearance.

Let me explain. When I have migrated, I did have to change the evo_posts.post_content column from the type "text" to the type "longtext" so it could be the same type as the node.body (or node.teaser) column.

When I first open the website, I noted that all my posts where having "?" instead of "é", "à", etc.

My guess is that it this not the format of the column that is affecting the accents, but how the text is coded. This is why I am looking for that.

Thanks.

Pier-André
--
pabsta's groove
www.pabsta.qc.ca
L'éternité, c'est long. Surtout vers la fin.

pabsta’s picture

pabsta commented

Ok. I think I have found what makes the problem with the accents. The pages in Drupal are sent with a UTF-8 coding header and b2evolution is using ISO-8959-1 coding.

Changing it must be pretty much simple. All you have to do is update every table that do have some text content with the php function string iconv( string $originalFormat, string $finalFormat, string $textToConvert)

I say must because the iconv php library is not yet implemented on my server. I have asked to my host to implement it. More news to come after that.
--
pabsta's groove
www.pabsta.qc.ca
L'éternité, c'est long. Surtout vers la fin.

Lenwood’s picture

Lenwood commented

I'm not sure if this will be helpful, but Wordpress and B2evolution are both derivatives of b2. So the node on Migrating from Wordpress may be of some assistance. I'm not sure how similar they are in terms of database structure at this point, but it can't hurt to look.

Just a thought.

jeffbearer’s picture

jeffbearer commented

This method has flaws but it was good enough for me and maybe good enough for others.

I just exported the evo_posts table , ran some Perl against it to reformat it a bit, and used the Node import module in Drupal. You can find more info here:

http://jeffbearer.com/node/214

If you just want to get your posts into drupal this will work fine, if you want all your posts to have comments and images in posts to work, it will take a lot more work.