Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I'm building a site for an art gallery, in the old cms has 20 years worth of exhibitions. The old system is custom built and is not based on anything readymade, so finding an importer plugin made for that is out of a question.

Any idea how to proceed?

Big thanks!

share|improve this question
add comment

2 Answers

I'd dump part of the database and see how the posts/pages/ titles, date and other meta is arranged and compare it to Wordpress's DB structure.

See http://codex.wordpress.org/Database_Description and http://codex.wordpress.org/Importing_Content for existing importers.

Decide what you really need to import and what needs to be generated that is specific to WP.
It's not going to be an easy move.

You may be able to work with the text database dump with grep and other text tools to manipulate it into an import file.

You can also export the database in CSV using phpmyadmin, work with the cells/tables, and try http://wordpress.org/extend/plugins/csv-importer/

One other alternative: does the old CMS have an RSS feed? That's a good way to export and import into WP, if it's available.

share|improve this answer
    
No RSS in the old :/ –  any_h Apr 16 '12 at 22:17
    
Found this plugin wordpress.org/extend/plugins/custom-tables I'm not really sure what it does. –  any_h Apr 16 '12 at 22:18
add comment

When importing (custom) sites I prefer to first have the two sets of tables (the custom one and the wordpress one) in the same database. Then, it's "just" a matter of identifying where the data you need is located in your tables and start creating the inserts that will fill the corresponding fields in the wordpress tables.

You may want to take a look at converters for other systems to get some examples that may give you some inspiration

share|improve this answer
    
Jordi, could you please give some examples on the inserts you mentioned? SQL stuff is not my strongest area. –  any_h Apr 17 '12 at 0:08
    
Maybe this example modeling-languages.com/migrating-drupal-6-to-wordpress-3 will help –  Jordi Cabot Apr 17 '12 at 5:47
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.