When the MIT Press needed to bring new product information into their website from their back-end database, we came through with an automated importer module that did the job in a flexible and extensible way.
We evaluated the existing import modules and settled on developing a custom Drupal module to validate and enqueue data exports from the AllBooks database, then use an object-oriented framework to update and/or create Drupal nodes based on the imported data. We also developed a reporting framework and suite of tests to ensure that the importer is working according to spec.