By teradome on

Hey guys,

I'm looking to shut down one of my many Drupal 5 sites and would like to merge the story posts made on that site back into my main Drupal blog.

I've looked into the Import/Export module, but it simply doesn't work. Does anyone know how to export the stories from MySQL in such a way that it could be easily imported into a new table?

At this point I don't care about comments or taxonomy, I just want to preserve the stories themselves and their time/date stamps.

Thanks!

⋅ Categories: Drupal 5.x

Comments

dami’s picture

dami commented

Can you elaborate how Import/Export doesn't work for you?
I think it should work ... I haven't used it recently, I may be wrong but you may need to manually edit the exported xml (to adjust nid #s, so it doesn't overwrite existing nodes) before importing ?

teradome’s picture

teradome commented

Ok.:

1: I click on Export in the menu, takes me to "http://{server}/admin/export"
2: I select "Story" and either CSV or XML output from the list
3: I click on "Next"
4: I get redirected to an empty admin page, the URL is "http://{server}/admin//build/story/xml"
5: I hack the URL a few times since the pathing is obviously boinked, but give up because all I get are empty pages.

teradome’s picture

teradome commented

(bump)

teradome’s picture

teradome commented

Please? Anyone? Is it really *that* difficult?

teradome’s picture

teradome commented

Someone in #drupal helped. The node_import module works great with a CSV export from MySQL.

It's a pretty generic import, but it works well with the right field mappings as long as you remember to query all the tables together to contain all the data you can map up, and your input format defaults match.

Only downside: no importing of categories.