b2evo converter

[EdB]

Sometimes I think the "export a feed then import it into a new database" is a pretty good idea. Except for you can't always get what you want eh? Like renderers and settings and post history stuff to name a few that come to mind right now.

No fun ... this branch or a toothache. All I can say is better you than me

[Yabs]

Ok, managed to do a bit more on this today, week of antibiotics before they can rip my teeth out :-S

Anyway, it can now some tiny bits like read your evo _basic-config.php ( if uploaded to qp-config/ ) and import any unique antispam strings that you have

¥

[Yabs]

Ok, in keeping with lots of convo snippets from around these boards and irc, I'm gonna "freeze" the current importer branch and aim for a quick 'n' dirty converter instead as it'll be faster to code and gets us to the start line.

I'll be using a copy of the codex database for the evo_data but once we get it working smoothly with that I'll probably use IV's database as a crash test dummy

Anyway, arse into gear time, need to make this happen before we all get as old and grey as EdB ... ohhh, wait, I'm already grey

¥

[EdB]

Some fields in the evo_users table have become fields in the qp_plugin_sharedvalues table. For each user, near as I can tell, There might be 4 bits that move over to the new table. Moving means associating the current value with a user_ID and a fieldname. So something like this...

Code: Select all

FOREACH USER IN evo_users {
IF ISSET user_aim THEN INSERT INTO qp_plugin_sharedvalues
{ psv_user_ID, psv_psf_fieldname, psv_userfieldvalue == user_ID, 'aol_aim', user_aim }
IF ISSET user_msn THEN INSERT INTO qp_plugin_sharedvalues
{ psv_user_ID, psv_psf_fieldname, psv_userfieldvalue == user_ID, 'msn_im', user_msn }
IF ISSET user_yim THEN INSERT INTO qp_plugin_sharedvalues
{ psv_user_ID, psv_psf_fieldname, psv_userfieldvalue == user_ID, 'yahoo_im', user_yim }
IF ISSET user_avatar_file_ID THEN INSERT INTO qp_plugin_sharedvalues
{ psv_user_ID, psv_psf_fieldname, psv_userfieldvalue == user_ID, 'avatar_ID', user_avatar_file_ID }
}

Free-typed so ...

Not sure how you're doing a migrator, but if it was my mission that's how I'd get it done. Look at each field in each table, find where it goes, figure out what it might need, take care of it, then move on. Probably not more than a couple of hundred fields overall but that's just a guess. Could be more. Dunno. hmmm... Can't hurt to learn eh?

Did an export of an evo333 and qp installation and left out the data then stripped out comments. Probably didn't need to strip out comments but what's done is done eh? Anyway that made it real easy to count stuff. evo has 43 tables, we have 42. Evo has 320 fields, we have 307. We then match almost exactly on all sorts of trivial little counting games. Primary keys, Unique keys, Keys, MyISAM tables, InnoDB tables. We're also still totally latin1 for DEFAULT CHARSET which I thought a long time ago was something we figured was good to change.

[Yabs]

Yeah, walt was meant to be dragging us into the utf-8 world, but he kinda got distracted

Basic plan for a migrator is pretty much as you outlined. Everything except qp's user 1 will be overwritten by (converted) evo data .. Settings, Plugins, Widgets and Templates will be fun

¥

[Yabs]

New branch linked in first post

¥

[EdB]

I reckon Walter's work is still around here somewhere so there's a start. IIRC there was something about doing logic in the wrong places that Tblue didn't like. We should look and see if we can get that done right. Be a nice delta methinks.

[Yabs]

Should nudge tblue next time you're in IRC

Mind you, should nudge walt on twitter as well, about time he got his arse into gear again

Back on topic :
Some minor progress with the plugin, it does all sorts of ajax stuff now as a prelude to doing the actual conversion ... now the real "fun" begins

¥

[Yabs]

Progress made The plugin should now convert all the easy tables (ie/ straight forward copies ) ... now for the real ballache stuff

¥

[Yabs]

Users and UserSettings done

Note to self : need to check if admin_template is required

¥